| BN |
| Base Object | EMPLOYEE |
| Attribute Name | Badge Number |
| ColumnName | BN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| 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 Employee Badge Number |
NO | ||
| 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 |
| 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 |
| USER_ID |
| Base Object | EMPLOYEE |
| Attribute Name | User Identifier |
| ColumnName | USER_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| USER_ID Column Properties |
| Datatype | VARCHAR2(9) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USER_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 9 |
| Percent Null | 0 |
| USER_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| USER_ID Security Types |
| Name | Current Value |
| USER_ID Bound Attachments |
| Name | Current Value |
| USER_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| USER_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee User Identifier |
NO | ||
| 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_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMP_CODE |
| Base Object | EMPLOYEE |
| Attribute Name | Employee Code |
| ColumnName | EMP_CODE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EMP_CODE Column Properties |
| Datatype | VARCHAR2(9) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMP_CODE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 9 |
| Percent Null | 0 |
| EMP_CODE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EMP_CODE Security Types |
| Name | Current Value |
| EMP_CODE Bound Attachments |
| Name | Current Value |
| EMP_CODE Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMP_CODE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Employee Code |
NO | ||
| 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 |
| EMP_CODE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMP_CODE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMP_CODE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMP_CODE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_EMP_IND |
| Base Object | EMPLOYEE |
| Attribute Name | Active Employee Indicator |
| ColumnName | ACT_EMP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ACT_EMP_IND Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_EMP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| ACT_EMP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ACT_EMP_IND Security Types |
| Name | Current Value |
| ACT_EMP_IND Bound Attachments |
| Name | Current Value |
| ACT_EMP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| ACT_EMP_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Active Employee Indicator |
NO | ||
| 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 |
| ACT_EMP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_EMP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_EMP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_EMP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM |
| Base Object | EMPLOYEE |
| Attribute Name | First Name |
| ColumnName | FIRST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| FIRST_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FIRST_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| FIRST_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIRST_NM Security Types |
| Name | Current Value |
| FIRST_NM Bound Attachments |
| Name | Current Value |
| FIRST_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| FIRST_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee First Name |
NO | ||
| 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_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIDDLE_NM |
| Base Object | EMPLOYEE |
| Attribute Name | Middle Name |
| ColumnName | MIDDLE_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| MIDDLE_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MIDDLE_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| MIDDLE_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MIDDLE_NM Security Types |
| Name | Current Value |
| MIDDLE_NM Bound Attachments |
| Name | Current Value |
| MIDDLE_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| MIDDLE_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Middle Name |
NO | ||
| 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_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIDDLE_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIDDLE_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIDDLE_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NAME |
| Base Object | EMPLOYEE |
| Attribute Name | Last Name |
| ColumnName | LAST_NAME |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| LAST_NAME Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LAST_NAME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| 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 | ||
| 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 |
| PREF_FIRST_NM |
| Base Object | EMPLOYEE |
| Attribute Name | Preferred First Name |
| ColumnName | PREF_FIRST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| PREF_FIRST_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PREF_FIRST_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| PREF_FIRST_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PREF_FIRST_NM Security Types |
| Name | Current Value |
| PREF_FIRST_NM Bound Attachments |
| Name | Current Value |
| PREF_FIRST_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| PREF_FIRST_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Preferred First Name |
NO | ||
| 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 |
| PREF_FIRST_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_FIRST_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_FIRST_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_FIRST_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_MID_NM |
| Base Object | EMPLOYEE |
| Attribute Name | Preferred Middle Name |
| ColumnName | PREF_MID_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| PREF_MID_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PREF_MID_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| PREF_MID_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PREF_MID_NM Security Types |
| Name | Current Value |
| PREF_MID_NM Bound Attachments |
| Name | Current Value |
| PREF_MID_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| PREF_MID_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Preferred Middle Name |
NO | ||
| 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 |
| PREF_MID_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_MID_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_MID_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_MID_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_LAST_NM |
| Base Object | EMPLOYEE |
| Attribute Name | Preferred Last Name |
| ColumnName | PREF_LAST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| PREF_LAST_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PREF_LAST_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| PREF_LAST_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PREF_LAST_NM Security Types |
| Name | Current Value |
| PREF_LAST_NM Bound Attachments |
| Name | Current Value |
| PREF_LAST_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| PREF_LAST_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Preferred Last Name |
NO | ||
| 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 |
| PREF_LAST_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_LAST_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_LAST_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_LAST_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BUILD |
| Base Object | EMPLOYEE |
| Attribute Name | Building |
| ColumnName | BUILD |
| Logical Rolename | |
| RoleName | |
| Domain | Building |
| Physical Only | NO |
| Definition | Building: The building number. |
| Note |
| BUILD Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BUILD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| BUILD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BUILD Security Types |
| Name | Current Value |
| BUILD Bound Attachments |
| Name | Current Value |
| BUILD Data Movement Rules |
| Name | Type | Rule Text/Value |
| BUILD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Building |
NO | ||
| 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 |
| BUILD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BUILD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BUILD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BUILD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ROOM |
| Base Object | EMPLOYEE |
| Attribute Name | Room |
| ColumnName | ROOM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ROOM Column Properties |
| Datatype | VARCHAR2(24) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ROOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 24 |
| Percent Null | 0 |
| 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 | ||
| 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 Object | EMPLOYEE |
| Attribute Name | Mail Stop |
| ColumnName | MAIL_STOP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| MAIL_STOP Column Properties |
| Datatype | VARCHAR2(12) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MAIL_STOP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 12 |
| Percent Null | 0 |
| 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 | ||
| 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_NO |
| Base Object | EMPLOYEE |
| Attribute Name | Work Phone Number |
| ColumnName | WORK_PHONE_NO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| WORK_PHONE_NO Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| WORK_PHONE_NO Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| WORK_PHONE_NO Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WORK_PHONE_NO Security Types |
| Name | Current Value |
| WORK_PHONE_NO Bound Attachments |
| Name | Current Value |
| WORK_PHONE_NO Data Movement Rules |
| Name | Type | Rule Text/Value |
| WORK_PHONE_NO Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Work Phone Number |
NO | ||
| 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_NO Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WORK_PHONE_NO Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WORK_PHONE_NO Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WORK_PHONE_NO Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NO |
| Base Object | EMPLOYEE |
| Attribute Name | Cell Number |
| ColumnName | CELL_NO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CELL_NO Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CELL_NO Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| CELL_NO Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CELL_NO Security Types |
| Name | Current Value |
| CELL_NO Bound Attachments |
| Name | Current Value |
| CELL_NO Data Movement Rules |
| Name | Type | Rule Text/Value |
| CELL_NO Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Cell Number |
NO | ||
| 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_NO Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NO Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NO Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NO Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR |
| Base Object | EMPLOYEE |
| Attribute Name | Email Address |
| ColumnName | EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | Email Addr |
| Physical Only | NO |
| Definition | Email Address: |
| Note |
| EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| EMAIL_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EMAIL_ADDR Security Types |
| Name | Current Value |
| EMAIL_ADDR Bound Attachments |
| Name | Current Value |
| EMAIL_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL_ADDR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Employee Email Address |
NO | ||
| 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_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |