| BN |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | BN |
| ColumnName | BN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BN Column Properties |
| Datatype | VARCHAR2(18) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 18 |
| 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 SNS Employee Materialized View BN |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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 | SNS_EMPLOYEE_MV |
| Attribute Name | USER_ID |
| ColumnName | USER_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| USER_ID Column Properties |
| Datatype | CHAR(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 SNS Employee Materialized View USER_ID |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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 |
| ACT_EMP_IND |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | ACT_EMP_IND |
| 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 SNS Employee Materialized View ACT_EMP_IND |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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 |
| PREF_FIRST_NM |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | PREF_FIRST_NM |
| ColumnName | PREF_FIRST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| 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 SNS Employee Materialized View PREF_FIRST_NM |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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_LAST_NM |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | PREF_LAST_NM |
| ColumnName | PREF_LAST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| 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 SNS Employee Materialized View PREF_LAST_NM |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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 |
| WORK_PHONE_NO |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | WORK_PHONE_NO |
| ColumnName | WORK_PHONE_NO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| WORK_PHONE_NO Column Properties |
| Datatype | CHAR(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 SNS Employee Materialized View WORK_PHONE_NO |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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 | SNS_EMPLOYEE_MV |
| Attribute Name | CELL_NO |
| ColumnName | CELL_NO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CELL_NO Column Properties |
| Datatype | CHAR(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 SNS Employee Materialized View CELL_NO |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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 |
| PAGER_NO |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | PAGER_NO |
| ColumnName | PAGER_NO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PAGER_NO Column Properties |
| Datatype | CHAR(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAGER_NO Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| PAGER_NO Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAGER_NO Security Types |
| Name | Current Value |
| PAGER_NO Bound Attachments |
| Name | Current Value |
| PAGER_NO Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAGER_NO Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical SNS Employee Materialized View PAGER_NO |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV PAGER_NO |
NO |
| PAGER_NO Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAGER_NO Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAGER_NO Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAGER_NO Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_PHONE_NO |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | HOME_PHONE_NO |
| ColumnName | HOME_PHONE_NO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| HOME_PHONE_NO Column Properties |
| Datatype | CHAR(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HOME_PHONE_NO Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| HOME_PHONE_NO Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HOME_PHONE_NO Security Types |
| Name | Current Value |
| HOME_PHONE_NO Bound Attachments |
| Name | Current Value |
| HOME_PHONE_NO Data Movement Rules |
| Name | Type | Rule Text/Value |
| HOME_PHONE_NO Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical SNS Employee Materialized View HOME_PHONE_NO |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV HOME_PHONE_NO |
NO |
| HOME_PHONE_NO Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_PHONE_NO Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_PHONE_NO Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_PHONE_NO Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | EMAIL_ADDR |
| ColumnName | EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(300) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 300 |
| 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 SNS Employee Materialized View EMAIL_ADDR |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV 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 |
| PAYROLL |
| Base Object | SNS_EMPLOYEE_MV |
| Attribute Name | PAYROLL |
| ColumnName | PAYROLL |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PAYROLL Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAYROLL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| PAYROLL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAYROLL Security Types |
| Name | Current Value |
| PAYROLL Bound Attachments |
| Name | Current Value |
| PAYROLL Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAYROLL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical SNS Employee Materialized View PAYROLL |
NO | ||
| OPER (Oracle) SNS_EMPLOYEE_MV PAYROLL |
NO |
| PAYROLL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAYROLL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAYROLL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAYROLL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |