OPER.Personnel Role |
EntityType | Independent |
Logical Entity Name | Personnel Role |
Default Table Name | PERS_ROLES |
Logical Only | NO |
Owner | OPER |
Definition | Personnel Roles: Identifes the roles personnel hold within the facility. (i.e. Accelerator Operator) |
Note |
OPER.Personnel Role Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
BN | Badge Number | VARCHAR(10) | NO | |
Pers Role Desc | Description | VARCHAR(255) | YES | Description: Often used in validation tables accompanying an abbreviated identifer. |
Opr Ind | Indicator | CHAR(1) | NO | Operator Indicator: Indicates accelerator operator. |
Opr Mgr | Indicator | CHAR(1) | NO | Operations Manager: Indicates Operations Manager role. |
Chf Opr Ind | Indicator | CHAR(1) | NO | Chief Operator Indicator: Indicates a chief operator. |
Tech Cont Ind | Indicator | CHAR(1) | NO | Technical Contact Indicator: Owner or technical contact of equipment. |
Chklst Admin Ind | Indicator | CHAR(1) | NO | Checklist Administrator Administrator: Allow the person to create new checklist bodies. |
Area Mgr Ind | Indicator | CHAR(1) | NO | Area Manager Indicator: |
Area Engr Ind | VARCHAR(50) | YES | Area Engineer Indicator: The person is assigned to become the steward of the functional performance of the systems and components within his/her assigned area and ensure they are maintained ready to support the production of neutrons. Provide leadership and coordination as necessary to ensure systems and component upgrades are accomplished. |
|
Area Fld Tech Ind | Indicator | CHAR(1) | NO | Area Field Engineer/Technician Indicator: The person is assigned to assume the stewardship of an assigned area of the SNS accelerator and target facilities. He/she will oversee daily activities and provide leadership and coordination as necessary to get work done and to keep the space in accordance with ISM and its appearance worthy of its high-tech scientific mission. He/she will provide input into the processes for planning and coordination of future activities. |
Lab Space Mgr Ind | Indicator | CHAR(1) | NO | Laboratory Space Manager Indicator: The person is assigned to manage and allocate space in their responsible laboratory. |
Operations Shift Technician Indicator | Indicator | CHAR(1) | NO | |
Radiation Control Technican | Indicator | CHAR(1) | NO | |
Photograph | VARBINARY/BLOB(50) | YES | ||
Job Title Identifier | Identifier | VARCHAR(25) | YES |
OPER.Personnel Role Keys |
Key Name | Key Type | Keys |
pers_roles_pk | PrimaryKey | BN |
OPER.Personnel Role Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Job Title | Non-Identifying | Zero or One to Zero or More | Job Title Identifier | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Personnel Role Equipment SubCat Assignment | Identifying | One To Zero or More | NO | ||||
Personnel Role Equipment Category Assignment | Identifying | One To Zero or More | NO | ||||
Shift Scheduled Work Assignment | Identifying | One To Zero or More | NO |
OPER.Personnel Role Check Constraints |
Check Constraint Name | CheckConstraint |
OPER.Personnel Role Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
OPER.Personnel Role Security Types |
Name | Current Value |
OPER.Personnel Role Bound Attachments |
Name | Current Value |
OPER.Personnel Role Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical OPER.Personnel Role |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) NS_OPER.PERS_ROLES |
NO | |||
OPER (Oracle) OPER.PERS_ROLES |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
OPER.Personnel Role Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Operation |
Logical | Operation - OPM |
NS_OPER (Oracle) | Main Model |
OPER (Oracle) | Main Model |
OPER (Oracle) | OPM |
OPER.Personnel Role Data Movement Rules |
Name | Type | Rule Text/Value |