| BN |
| Base Object | PERS_ROLES |
| Attribute Name | BN |
| ColumnName | BN |
| Logical Rolename | |
| RoleName | |
| Domain | Badge Number |
| Physical Only | NO |
| Definition | |
| Note |
| BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BN Security Types |
| Name | Current Value |
| BN Bound Attachments |
| Name | Current Value |
| BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role BN |
NO | ||
| Logical Personnel Role Badge Number |
NO | ||
| NS_OPER (Oracle) PERS_ROLES BN |
NO | ||
| OPER (Oracle) PERS_ROLES BN |
NO |
| BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Pers Role Desc |
| Base Object | PERS_ROLES |
| Attribute Name | Pers Role Desc |
| ColumnName | Pers Role Desc |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| Pers Role Desc Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Pers Role Desc Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| Pers Role Desc Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Pers Role Desc Security Types |
| Name | Current Value |
| Pers Role Desc Bound Attachments |
| Name | Current Value |
| Pers Role Desc Data Movement Rules |
| Name | Type | Rule Text/Value |
| Pers Role Desc Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Pers Role Desc |
NO | ||
| Logical Personnel Role Pers Role Desc |
NO | ||
| NS_OPER (Oracle) PERS_ROLES Pers Role Desc |
NO | ||
| OPER (Oracle) PERS_ROLES Pers Role Desc |
NO |
| Pers Role Desc Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Pers Role Desc Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Pers Role Desc Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Pers Role Desc Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Ind |
| Base Object | PERS_ROLES |
| Attribute Name | Opr Ind |
| ColumnName | Opr Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Operator Indicator: Indicates accelerator operator. |
| Note |
| Opr Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Opr Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Opr Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Opr Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Opr Ind Security Types |
| Name | Current Value |
| Opr Ind Bound Attachments |
| Name | Current Value |
| Opr Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Opr Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Opr Ind |
NO | ||
| Logical Personnel Role Opr Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES Opr Ind |
NO | ||
| OPER (Oracle) PERS_ROLES Opr Ind |
NO |
| Opr Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Mgr |
| Base Object | PERS_ROLES |
| Attribute Name | Opr Mgr |
| ColumnName | Opr Mgr |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Operations Manager: Indicates Operations Manager role. |
| Note |
| Opr Mgr Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Opr Mgr Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Opr Mgr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Opr Mgr Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Opr Mgr Security Types |
| Name | Current Value |
| Opr Mgr Bound Attachments |
| Name | Current Value |
| Opr Mgr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Opr Mgr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Opr Mgr |
NO | ||
| Logical Personnel Role Opr Mgr |
NO | ||
| NS_OPER (Oracle) PERS_ROLES Opr Mgr |
NO | ||
| OPER (Oracle) PERS_ROLES Opr Mgr |
NO |
| Opr Mgr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Mgr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Mgr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Opr Mgr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chf Opr Ind |
| Base Object | PERS_ROLES |
| Attribute Name | Chf Opr Ind |
| ColumnName | Chf Opr Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Chief Operator Indicator: Indicates a chief operator. |
| Note |
| Chf Opr Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Chf Opr Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Chf Opr Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Chf Opr Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Chf Opr Ind Security Types |
| Name | Current Value |
| Chf Opr Ind Bound Attachments |
| Name | Current Value |
| Chf Opr Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Chf Opr Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Chf Opr Ind |
NO | ||
| Logical Personnel Role Chf Opr Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES Chf Opr Ind |
NO | ||
| OPER (Oracle) PERS_ROLES Chf Opr Ind |
NO |
| Chf Opr Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chf Opr Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chf Opr Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chf Opr Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tech Cont Ind |
| Base Object | PERS_ROLES |
| Attribute Name | Tech Cont Ind |
| ColumnName | Tech Cont Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Technical Contact Indicator: Owner or technical contact of equipment. |
| Note |
| Tech Cont Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Tech Cont Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Tech Cont Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Tech Cont Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Tech Cont Ind Security Types |
| Name | Current Value |
| Tech Cont Ind Bound Attachments |
| Name | Current Value |
| Tech Cont Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Tech Cont Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Tech Cont Ind |
NO | ||
| Logical Personnel Role Tech Cont Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES Tech Cont Ind |
NO | ||
| OPER (Oracle) PERS_ROLES Tech Cont Ind |
NO |
| Tech Cont Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tech Cont Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tech Cont Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tech Cont Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chklst Admin Ind |
| Base Object | PERS_ROLES |
| Attribute Name | Chklst Admin Ind |
| ColumnName | Chklst Admin Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Checklist Administrator Administrator: Allow the person to create new checklist bodies. |
| Note |
| Chklst Admin Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Chklst Admin Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Chklst Admin Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Chklst Admin Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Chklst Admin Ind Security Types |
| Name | Current Value |
| Chklst Admin Ind Bound Attachments |
| Name | Current Value |
| Chklst Admin Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Chklst Admin Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Chklst Admin Ind |
NO | ||
| Logical Personnel Role Chklst Admin Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES Chklst Admin Ind |
NO | ||
| OPER (Oracle) PERS_ROLES Chklst Admin Ind |
NO |
| Chklst Admin Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chklst Admin Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chklst Admin Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Chklst Admin Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND |
| Base Object | PERS_ROLES |
| Attribute Name | Area Mgr Ind |
| ColumnName | AREA_MGR_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Area Manager Indicator: |
| Note |
| AREA_MGR_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AREA_MGR_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| AREA_MGR_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| AREA_MGR_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| AREA_MGR_IND Security Types |
| Name | Current Value |
| AREA_MGR_IND Bound Attachments |
| Name | Current Value |
| AREA_MGR_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| AREA_MGR_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Area Mgr Ind |
NO | ||
| Logical Personnel Role Area Mgr Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES AREA_MGR_IND |
NO | ||
| OPER (Oracle) PERS_ROLES AREA_MGR_IND |
NO |
| AREA_MGR_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND |
| Base Object | PERS_ROLES |
| Attribute Name | Area Engr Ind |
| ColumnName | AREA_ENGR_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | 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. |
| Note |
| AREA_ENGR_IND Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AREA_ENGR_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| AREA_ENGR_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AREA_ENGR_IND Security Types |
| Name | Current Value |
| AREA_ENGR_IND Bound Attachments |
| Name | Current Value |
| AREA_ENGR_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| AREA_ENGR_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Area Engr Ind |
NO | ||
| Logical Personnel Role Area Engr Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES AREA_ENGR_IND |
NO | ||
| OPER (Oracle) PERS_ROLES AREA_ENGR_IND |
NO |
| AREA_ENGR_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_FLD_TECH_IND |
| Base Object | PERS_ROLES |
| Attribute Name | Area Fld Tech Ind |
| ColumnName | AREA_FLD_TECH_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | 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. |
| Note |
| AREA_FLD_TECH_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AREA_FLD_TECH_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| AREA_FLD_TECH_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| AREA_FLD_TECH_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| AREA_FLD_TECH_IND Security Types |
| Name | Current Value |
| AREA_FLD_TECH_IND Bound Attachments |
| Name | Current Value |
| AREA_FLD_TECH_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| AREA_FLD_TECH_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Area Fld Tech Ind |
NO | ||
| Logical Personnel Role Area Fld Tech Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES AREA_FLD_TECH_IND |
NO | ||
| OPER (Oracle) PERS_ROLES AREA_FLD_TECH_IND |
NO |
| AREA_FLD_TECH_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_FLD_TECH_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_FLD_TECH_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_FLD_TECH_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAB_SPACE_MGR_IND |
| Base Object | PERS_ROLES |
| Attribute Name | Lab Space Mgr Ind |
| ColumnName | LAB_SPACE_MGR_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Laboratory Space Manager Indicator: The person is assigned to manage and allocate space in their responsible laboratory. |
| Note |
| LAB_SPACE_MGR_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LAB_SPACE_MGR_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| LAB_SPACE_MGR_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| LAB_SPACE_MGR_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| LAB_SPACE_MGR_IND Security Types |
| Name | Current Value |
| LAB_SPACE_MGR_IND Bound Attachments |
| Name | Current Value |
| LAB_SPACE_MGR_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| LAB_SPACE_MGR_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Lab Space Mgr Ind |
NO | ||
| Logical Personnel Role Lab Space Mgr Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES LAB_SPACE_MGR_IND |
NO | ||
| OPER (Oracle) PERS_ROLES LAB_SPACE_MGR_IND |
NO |
| LAB_SPACE_MGR_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAB_SPACE_MGR_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAB_SPACE_MGR_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAB_SPACE_MGR_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OST_IND |
| Base Object | PERS_ROLES |
| Attribute Name | Operations Shift Technician Indicator |
| ColumnName | OST_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| OST_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OST_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| OST_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| OST_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| OST_IND Security Types |
| Name | Current Value |
| OST_IND Bound Attachments |
| Name | Current Value |
| OST_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| OST_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Operations Shift Technician Indicator |
NO | ||
| Logical Personnel Role Operations Shift Technician Indicator |
NO | ||
| NS_OPER (Oracle) PERS_ROLES OST_IND |
NO | ||
| OPER (Oracle) PERS_ROLES OST_IND |
NO |
| OST_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OST_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OST_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OST_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCT_IND |
| Base Object | PERS_ROLES |
| Attribute Name | Radiation Control Technican |
| ColumnName | RCT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| RCT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RCT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| RCT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| RCT_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| RCT_IND Security Types |
| Name | Current Value |
| RCT_IND Bound Attachments |
| Name | Current Value |
| RCT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| RCT_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Radiation Control Technican |
NO | ||
| Logical Personnel Role Radiation Control Technican |
NO | ||
| NS_OPER (Oracle) PERS_ROLES RCT_IND |
NO | ||
| OPER (Oracle) PERS_ROLES RCT_IND |
NO |
| RCT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO |
| Base Object | PERS_ROLES |
| Attribute Name | Photograph |
| ColumnName | PHOTO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PHOTO Column Properties |
| Datatype | BLOB |
| Nullable | YES |
| Not Null Constraint |
| PHOTO Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| PHOTO Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PHOTO Security Types |
| Name | Current Value |
| PHOTO Bound Attachments |
| Name | Current Value |
| PHOTO Data Movement Rules |
| Name | Type | Rule Text/Value |
| PHOTO Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Photograph |
NO | ||
| Logical Personnel Role Photograph |
NO | ||
| NS_OPER (Oracle) PERS_ROLES PHOTO |
NO | ||
| OPER (Oracle) PERS_ROLES PHOTO |
NO |
| PHOTO Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| JOB_TITLE_ID |
| Base Object | PERS_ROLES |
| Attribute Name | Job Title Identifier |
| ColumnName | JOB_TITLE_ID |
| Logical Rolename | |
| RoleName | JOB_TITLE_ID |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| JOB_TITLE_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| JOB_TITLE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| JOB_TITLE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| JOB_TITLE_ID Security Types |
| Name | Current Value |
| JOB_TITLE_ID Bound Attachments |
| Name | Current Value |
| JOB_TITLE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| JOB_TITLE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Job Title Identifier |
NO | ||
| Logical Personnel Role Job Title Identifier |
NO | ||
| NS_OPER (Oracle) PERS_ROLES JOB_TITLE_ID |
NO | ||
| OPER (Oracle) PERS_ROLES JOB_TITLE_ID |
NO |
| JOB_TITLE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| JOB_TITLE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| JOB_TITLE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| JOB_TITLE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |