Badge Number |
Base Entity | Personnel Role |
Attribute Name | Badge Number |
Logical Rolename | |
ColumnName | BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | |
Note |
Badge Number Logical Attribute Properties |
Logical Attribute Name | Badge Number |
Datatype | VARCHAR(10) |
Nullable | NO |
Badge Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Badge Number Security Types |
Name | Current Value |
Badge Number Bound Attachments |
Name | Current Value |
Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Role Badge Number |
NO | ||
OPER (Oracle) PERS_ROLES BN |
NO |
Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pers Role Desc |
Base Entity | Personnel Role |
Attribute Name | Pers Role Desc |
Logical Rolename | |
ColumnName | Pers Role Desc |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Pers Role Desc Logical Attribute Properties |
Logical Attribute Name | Pers Role Desc |
Datatype | VARCHAR(255) |
Nullable | YES |
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 | ||
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 Entity | Personnel Role |
Attribute Name | Opr Ind |
Logical Rolename | |
ColumnName | Opr Ind |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Operator Indicator: Indicates accelerator operator. |
Note |
Opr Ind Logical Attribute Properties |
Logical Attribute Name | Opr Ind |
Datatype | CHAR(1) |
Nullable | NO |
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 | ||
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 Entity | Personnel Role |
Attribute Name | Opr Mgr |
Logical Rolename | |
ColumnName | Opr Mgr |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Operations Manager: Indicates Operations Manager role. |
Note |
Opr Mgr Logical Attribute Properties |
Logical Attribute Name | Opr Mgr |
Datatype | CHAR(1) |
Nullable | NO |
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 | ||
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 |
Area Mgr Ind |
Base Entity | Personnel Role |
Attribute Name | Area Mgr Ind |
Logical Rolename | |
ColumnName | AREA_MGR_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Area Manager Indicator: |
Note |
Area Mgr Ind Logical Attribute Properties |
Logical Attribute Name | Area Mgr Ind |
Datatype | CHAR(1) |
Nullable | NO |
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 | ||
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 Entity | Personnel Role |
Attribute Name | Area Engr Ind |
Logical Rolename | |
ColumnName | AREA_ENGR_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Area Engr Ind Logical Attribute Properties |
Logical Attribute Name | Area Engr Ind |
Datatype | CHAR(1) |
Nullable | NO |
Area Engr Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Area Engr 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 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 | ||
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 |
Logbook Read Only Ind |
Base Entity | Personnel Role |
Attribute Name | Logbook Read Only Ind |
Logical Rolename | |
ColumnName | LOG_READ_ONLY_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Technical Contact Indicator: Owner or technical contact of equipment. |
Note |
Logbook Read Only Ind Logical Attribute Properties |
Logical Attribute Name | Logbook Read Only Ind |
Datatype | CHAR(1) |
Nullable | NO |
Logbook Read Only Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Logbook Read Only 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 |
Logbook Read Only Ind Security Types |
Name | Current Value |
Logbook Read Only Ind Bound Attachments |
Name | Current Value |
Logbook Read Only Ind Data Movement Rules |
Name | Type | Rule Text/Value |
Logbook Read Only Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Role Logbook Read Only Ind |
NO | ||
OPER (Oracle) PERS_ROLES LOG_READ_ONLY_IND |
NO |
Logbook Read Only Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Logbook Read Only Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Logbook Read Only Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Logbook Read Only Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Photograph |
Base Entity | Personnel Role |
Attribute Name | Photograph |
Logical Rolename | |
ColumnName | PHOTO |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Photograph Logical Attribute Properties |
Logical Attribute Name | Photograph |
Datatype | VARBINARY/BLOB(50) |
Nullable | YES |
Photograph Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Photograph Security Types |
Name | Current Value |
Photograph Bound Attachments |
Name | Current Value |
Photograph Data Movement Rules |
Name | Type | Rule Text/Value |
Photograph Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Personnel Role Photograph |
NO | ||
OPER (Oracle) PERS_ROLES PHOTO |
NO |
Photograph Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Photograph Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Photograph Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Photograph Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |