| Badge Number |
| Base Entity | Employee |
| Attribute Name | Badge Number |
| Logical Rolename | |
| ColumnName | BN |
| RoleName | |
| Domain | |
| 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 Employee Badge Number |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE BN |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE Bn |
NO | ||
| ENGA (Oracle) EMPLOYEE BN |
NO | ||
| EXPRESS (Oracle) EMPLOYEE BN |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE BN |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE BN |
NO | ||
| OPER (Oracle) EMPLOYEE BN |
NO | ||
| PRPSL (Oracle) EMPLOYEE BN |
NO | ||
| SMPL (Oracle) EMPLOYEE BN |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE 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 |
| User Identifier |
| Base Entity | Employee |
| Attribute Name | User Identifier |
| Logical Rolename | |
| ColumnName | USER_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| User Identifier Logical Attribute Properties |
| Logical Attribute Name | User Identifier |
| Datatype | VARCHAR(9) |
| Nullable | YES |
| User Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| User Identifier Security Types |
| Name | Current Value |
| User Identifier Bound Attachments |
| Name | Current Value |
| User Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| User Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee User Identifier |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE USER_ID |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE USER_ID |
NO | ||
| ENGA (Oracle) EMPLOYEE USER_ID |
NO | ||
| EXPRESS (Oracle) EMPLOYEE USER_ID |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE USER_ID |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE USER_ID |
NO | ||
| OPER (Oracle) EMPLOYEE USER_ID |
NO | ||
| PRPSL (Oracle) EMPLOYEE USER_ID |
NO | ||
| SMPL (Oracle) EMPLOYEE USER_ID |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE USER_ID |
NO |
| User Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Employee Code |
| Base Entity | Employee |
| Attribute Name | Employee Code |
| Logical Rolename | |
| ColumnName | EMP_CODE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Employee Code Logical Attribute Properties |
| Logical Attribute Name | Employee Code |
| Datatype | VARCHAR(9) |
| Nullable | YES |
| Employee Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Employee Code Security Types |
| Name | Current Value |
| Employee Code Bound Attachments |
| Name | Current Value |
| Employee Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Employee Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Employee Code |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| ENGA (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| EXPRESS (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| OPER (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| PRPSL (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| SMPL (Oracle) EMPLOYEE EMP_CODE |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE EMP_CODE |
NO |
| Employee Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Employee Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Employee Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Employee Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Employee Indicator |
| Base Entity | Employee |
| Attribute Name | Active Employee Indicator |
| Logical Rolename | |
| ColumnName | ACT_EMP_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Active Employee Indicator Logical Attribute Properties |
| Logical Attribute Name | Active Employee Indicator |
| Datatype | VARCHAR(3) |
| Nullable | YES |
| Active Employee Indicator Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Active Employee Indicator Security Types |
| Name | Current Value |
| Active Employee Indicator Bound Attachments |
| Name | Current Value |
| Active Employee Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Active Employee Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Active Employee Indicator |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| ENGA (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| EXPRESS (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| OPER (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| PRPSL (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| SMPL (Oracle) EMPLOYEE ACT_EMP_IND |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE ACT_EMP_IND |
NO |
| Active Employee Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Employee Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Employee Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Employee Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| First Name |
| Base Entity | Employee |
| Attribute Name | First Name |
| Logical Rolename | |
| ColumnName | FIRST_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| First Name Logical Attribute Properties |
| Logical Attribute Name | First Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| First Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| First Name Security Types |
| Name | Current Value |
| First Name Bound Attachments |
| Name | Current Value |
| First Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| First Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee First Name |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| ENGA (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| EXPRESS (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| OPER (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| PRPSL (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| SMPL (Oracle) EMPLOYEE FIRST_NM |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE FIRST_NM |
NO |
| First Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| First Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| First Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| First Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Middle Name |
| Base Entity | Employee |
| Attribute Name | Middle Name |
| Logical Rolename | |
| ColumnName | MIDDLE_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Middle Name Logical Attribute Properties |
| Logical Attribute Name | Middle Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Middle Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Middle Name Security Types |
| Name | Current Value |
| Middle Name Bound Attachments |
| Name | Current Value |
| Middle Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Middle Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Middle Name |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| ENGA (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| EXPRESS (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| OPER (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| PRPSL (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| SMPL (Oracle) EMPLOYEE MIDDLE_NM |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE MIDDLE_NM |
NO |
| Middle Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Middle Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Middle Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Middle Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name |
| Base Entity | Employee |
| Attribute Name | Last Name |
| Logical Rolename | |
| ColumnName | LAST_NAME |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Last Name Logical Attribute Properties |
| Logical Attribute Name | Last Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Last Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Last Name Security Types |
| Name | Current Value |
| Last Name Bound Attachments |
| Name | Current Value |
| Last Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Last Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Last Name |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| ENGA (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| EXPRESS (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| OPER (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| PRPSL (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| SMPL (Oracle) EMPLOYEE LAST_NAME |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE LAST_NAME |
NO |
| Last Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred First Name |
| Base Entity | Employee |
| Attribute Name | Preferred First Name |
| Logical Rolename | |
| ColumnName | PREF_FIRST_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Preferred First Name Logical Attribute Properties |
| Logical Attribute Name | Preferred First Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Preferred First Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Preferred First Name Security Types |
| Name | Current Value |
| Preferred First Name Bound Attachments |
| Name | Current Value |
| Preferred First Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Preferred First Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Preferred First Name |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| ENGA (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| EXPRESS (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| OPER (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| PRPSL (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| SMPL (Oracle) EMPLOYEE PREF_FIRST_NM |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE PREF_FIRST_NM |
NO |
| Preferred First Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred First Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred First Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred First Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Middle Name |
| Base Entity | Employee |
| Attribute Name | Preferred Middle Name |
| Logical Rolename | |
| ColumnName | PREF_MID_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Preferred Middle Name Logical Attribute Properties |
| Logical Attribute Name | Preferred Middle Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Preferred Middle Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Preferred Middle Name Security Types |
| Name | Current Value |
| Preferred Middle Name Bound Attachments |
| Name | Current Value |
| Preferred Middle Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Preferred Middle Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Preferred Middle Name |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| ENGA (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| EXPRESS (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| OPER (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| PRPSL (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| SMPL (Oracle) EMPLOYEE PREF_MID_NM |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE PREF_MID_NM |
NO |
| Preferred Middle Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Middle Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Middle Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Middle Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Last Name |
| Base Entity | Employee |
| Attribute Name | Preferred Last Name |
| Logical Rolename | |
| ColumnName | PREF_LAST_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Preferred Last Name Logical Attribute Properties |
| Logical Attribute Name | Preferred Last Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Preferred Last Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Preferred Last Name Security Types |
| Name | Current Value |
| Preferred Last Name Bound Attachments |
| Name | Current Value |
| Preferred Last Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Preferred Last Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Preferred Last Name |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| ENGA (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| EXPRESS (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| OPER (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| PRPSL (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| SMPL (Oracle) EMPLOYEE PREF_LAST_NM |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE PREF_LAST_NM |
NO |
| Preferred Last Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Last Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Last Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Preferred Last Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Building |
| Base Entity | Employee |
| Attribute Name | Building |
| Logical Rolename | |
| ColumnName | BUILD |
| RoleName | |
| Domain | Building |
| Logical Only | NO |
| Definition | Building: The building number. |
| Note |
| Building Logical Attribute Properties |
| Logical Attribute Name | Building |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Building Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Building Security Types |
| Name | Current Value |
| Building Bound Attachments |
| Name | Current Value |
| Building Data Movement Rules |
| Name | Type | Rule Text/Value |
| Building Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Building |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE BUILD |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE BUILD |
NO | ||
| ENGA (Oracle) EMPLOYEE BUILD |
NO | ||
| EXPRESS (Oracle) EMPLOYEE BUILD |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE BUILD |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE BUILD |
NO | ||
| OPER (Oracle) EMPLOYEE BUILD |
NO | ||
| PRPSL (Oracle) EMPLOYEE BUILD |
NO | ||
| SMPL (Oracle) EMPLOYEE BUILD |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE BUILD |
NO |
| Building Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Building Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Building Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Building Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room |
| Base Entity | Employee |
| Attribute Name | Room |
| Logical Rolename | |
| ColumnName | ROOM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Room Logical Attribute Properties |
| Logical Attribute Name | Room |
| Datatype | VARCHAR(24) |
| Nullable | YES |
| Room Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Room Security Types |
| Name | Current Value |
| Room Bound Attachments |
| Name | Current Value |
| Room Data Movement Rules |
| Name | Type | Rule Text/Value |
| Room Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Room |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE ROOM |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE ROOM |
NO | ||
| ENGA (Oracle) EMPLOYEE ROOM |
NO | ||
| EXPRESS (Oracle) EMPLOYEE ROOM |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE ROOM |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE ROOM |
NO | ||
| OPER (Oracle) EMPLOYEE ROOM |
NO | ||
| PRPSL (Oracle) EMPLOYEE ROOM |
NO | ||
| SMPL (Oracle) EMPLOYEE ROOM |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE ROOM |
NO |
| Room Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mail Stop |
| Base Entity | Employee |
| Attribute Name | Mail Stop |
| Logical Rolename | |
| ColumnName | MAIL_STOP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Mail Stop Logical Attribute Properties |
| Logical Attribute Name | Mail Stop |
| Datatype | VARCHAR(12) |
| Nullable | YES |
| Mail Stop Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Mail Stop Security Types |
| Name | Current Value |
| Mail Stop Bound Attachments |
| Name | Current Value |
| Mail Stop Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mail Stop Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Mail Stop |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| ENGA (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| EXPRESS (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| OPER (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| PRPSL (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| SMPL (Oracle) EMPLOYEE MAIL_STOP |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE MAIL_STOP |
NO |
| Mail Stop Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mail Stop Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mail Stop Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mail Stop Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Phone Number |
| Base Entity | Employee |
| Attribute Name | Work Phone Number |
| Logical Rolename | |
| ColumnName | WORK_PHONE_NO |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Work Phone Number Logical Attribute Properties |
| Logical Attribute Name | Work Phone Number |
| Datatype | VARCHAR(30) |
| Nullable | YES |
| Work Phone Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Work Phone Number Security Types |
| Name | Current Value |
| Work Phone Number Bound Attachments |
| Name | Current Value |
| Work Phone Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Work Phone Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Work Phone Number |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| ENGA (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| EXPRESS (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| OPER (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| PRPSL (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| SMPL (Oracle) EMPLOYEE WORK_PHONE_NO |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE WORK_PHONE_NO |
NO |
| Work Phone Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Phone Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Phone Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Phone Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cell Number |
| Base Entity | Employee |
| Attribute Name | Cell Number |
| Logical Rolename | |
| ColumnName | CELL_NO |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Cell Number Logical Attribute Properties |
| Logical Attribute Name | Cell Number |
| Datatype | VARCHAR(30) |
| Nullable | YES |
| Cell Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Cell Number Security Types |
| Name | Current Value |
| Cell Number Bound Attachments |
| Name | Current Value |
| Cell Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Cell Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Cell Number |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE CELL_NO |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE CELL_NO |
NO | ||
| ENGA (Oracle) EMPLOYEE CELL_NO |
NO | ||
| EXPRESS (Oracle) EMPLOYEE CELL_NO |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE CELL_NO |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE CELL_NO |
NO | ||
| OPER (Oracle) EMPLOYEE CELL_NO |
NO | ||
| PRPSL (Oracle) EMPLOYEE CELL_NO |
NO | ||
| SMPL (Oracle) EMPLOYEE CELL_NO |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE CELL_NO |
NO |
| Cell Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cell Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cell Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cell Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address |
| Base Entity | Employee |
| Attribute Name | Email Address |
| Logical Rolename | |
| ColumnName | EMAIL_ADDR |
| RoleName | |
| Domain | Email Addr |
| Logical Only | NO |
| Definition | Email Address: |
| Note |
| Email Address Logical Attribute Properties |
| Logical Attribute Name | Email Address |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Email Address Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Email Address Security Types |
| Name | Current Value |
| Email Address Bound Attachments |
| Name | Current Value |
| Email Address Data Movement Rules |
| Name | Type | Rule Text/Value |
| Email Address Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Email Address |
NO | ||
| BYPASS_REQ (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| CNMS_PRPSL (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| ENGA (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| EXPRESS (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| ICS_SFTW_APPL (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| IPTSv5 (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| OPER (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| PRPSL (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| SMPL (Oracle) EMPLOYEE EMAIL_ADDR |
NO | ||
| XF_ADMIN (Oracle) EMPLOYEE EMAIL_ADDR |
NO |
| Email Address Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |