PERS_ROLES |
Logical Entity Name | Personnel Role |
Default Table Name | PERS_ROLES |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | OPER |
Definition | Personnel Roles: Identifes the roles personnel hold within the facility. (i.e. Accelerator Operator) |
Note | |
PreSQL | |
DDL Code | CREATE TABLE OPER.PERS_ROLES(      BN                    VARCHAR2(10)      NOT NULL,      "Pers Role Desc"      VARCHAR2(255),      "Opr Ind"             CHAR(1)           DEFAULT 'N' NOT NULL,      "Opr Mgr"             CHAR(1)           DEFAULT 'N' NOT NULL,      "Chf Opr Ind"         CHAR(1)           DEFAULT 'N' NOT NULL,      "Tech Cont Ind"       CHAR(1)           DEFAULT 'N' NOT NULL,      "Chklst Admin Ind"    CHAR(1)           DEFAULT 'N' NOT NULL,      AREA_MGR_IND          CHAR(1)           DEFAULT 'N' NOT NULL,      AREA_ENGR_IND         VARCHAR2(50),      AREA_FLD_TECH_IND     CHAR(1)           DEFAULT 'N' NOT NULL,      LAB_SPACE_MGR_IND     CHAR(1)           DEFAULT 'N' NOT NULL,      OST_IND               CHAR(1)           DEFAULT 'N' NOT NULL,      RCT_IND               CHAR(1)           DEFAULT 'N' NOT NULL,      PHOTO                 BLOB,      JOB_TITLE_ID          VARCHAR2(25),      CONSTRAINT fk_pers_role_to_job_title FOREIGN KEY (JOB_TITLE_ID)      REFERENCES OPER.JOB_TITLE(JOB_TITLE_ID) ) PCTFREE 10 INITRANS 1 MAXTRANS 255 TABLESPACE OPER_TS LOGGING NOPARALLEL STORAGE(INITIAL 64K          NEXT 1024K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          ) NOCACHE LOB(PHOTO) STORE AS   (TABLESPACE OPER STORAGE (INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS UNLIMITED) CHUNK 8192 NOCACHE LOGGING) NOCOMPRESS ; ALTER TABLE OPER.PERS_ROLES ADD      CONSTRAINT pers_roles_pk PRIMARY KEY (BN)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE OPER          LOGGING          STORAGE(INITIAL 64K                  NEXT 1024K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  ) ; |
PostSQL |
PERS_ROLES Columns |
ColumnName | Domain | Datatype | NULL | Definition |
BN | Badge Number | VARCHAR2(10) | NO | |
Pers Role Desc | Description | VARCHAR2(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 | VARCHAR2(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. |
OST_IND | Indicator | CHAR(1) | NO | |
RCT_IND | Indicator | CHAR(1) | NO | |
PHOTO | BLOB | YES | ||
JOB_TITLE_ID | Identifier | VARCHAR2(25) | YES |
PERS_ROLES Primary and Unique Keys |
Key Name | Key Type | Keys |
pers_roles_pk | PrimaryKey | BN |
PERS_ROLES Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
JOB_TITLE | Non-Identifying | Zero or One to Zero or More | fk_pers_role_to_job_title | JOB_TITLE_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
PERS_ROLE_EQUIP_SUBCAT_ASGN | Identifying | One To Zero or More | FK_FRESA_PERS_ROLES_BN | NO | NO | NO | |||
PERS_ROLE_EQUIP_CAT_ASGN | Identifying | One To Zero or More | FK_PRECA_PERS_ROLES_BN | NO | NO | NO | |||
SHIFT_SCHED_WORK_ASGN | Identifying | One To Zero or More | fk_spa_to_pers_role | NO | NO | NO |
PERS_ROLES Check Constraints |
Check Constraint Name | CheckConstraint |
PERS_ROLES Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER_TS |
PctFree | 10 |
PCTUSED | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 1 |
MaxTrans | 255 |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | |
Table Compression | NO |
Row Movement | Disabled |
PERS_ROLES Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERS_ROLES Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 344 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
PERS_ROLES Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
PERS_ROLES Security Types |
Name | Current Value |
PERS_ROLES Bound Attachments |
Name | Current Value |
PERS_ROLES Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical NS_OPER.Personnel Role |
NO | |||
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 |
PERS_ROLES Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Instrument Hall Coordinator Operations |
Logical | Operation |
Logical | Operation - OPM |
NS_OPER (Oracle) | Main Model |
OPER (Oracle) | Main Model |
OPER (Oracle) | OPM |
PERS_ROLES Data Movement Rules |
Name | Type | Rule Text/Value |