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 | 6 |
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 | 64 |
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 |