| BN |
| Base Entity | SNS Employee Materialized View |
| Attribute Name | BN |
| Logical Rolename | |
| ColumnName | BN |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| BN Logical Attribute Properties |
| Logical Attribute Name | BN |
| Datatype | VARCHAR(18) |
| Nullable | NO |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | USER_ID |
| Logical Rolename | |
| ColumnName | USER_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| USER_ID Logical Attribute Properties |
| Logical Attribute Name | USER_ID |
| Datatype | CHAR(9) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | ACT_EMP_IND |
| Logical Rolename | |
| ColumnName | ACT_EMP_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ACT_EMP_IND Logical Attribute Properties |
| Logical Attribute Name | ACT_EMP_IND |
| Datatype | VARCHAR(3) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | PREF_FIRST_NM |
| Logical Rolename | |
| ColumnName | PREF_FIRST_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| PREF_FIRST_NM Logical Attribute Properties |
| Logical Attribute Name | PREF_FIRST_NM |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | PREF_LAST_NM |
| Logical Rolename | |
| ColumnName | PREF_LAST_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| PREF_LAST_NM Logical Attribute Properties |
| Logical Attribute Name | PREF_LAST_NM |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | WORK_PHONE_NO |
| Logical Rolename | |
| ColumnName | WORK_PHONE_NO |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| WORK_PHONE_NO Logical Attribute Properties |
| Logical Attribute Name | WORK_PHONE_NO |
| Datatype | CHAR(30) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | CELL_NO |
| Logical Rolename | |
| ColumnName | CELL_NO |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| CELL_NO Logical Attribute Properties |
| Logical Attribute Name | CELL_NO |
| Datatype | CHAR(30) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | PAGER_NO |
| Logical Rolename | |
| ColumnName | PAGER_NO |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| PAGER_NO Logical Attribute Properties |
| Logical Attribute Name | PAGER_NO |
| Datatype | CHAR(30) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | HOME_PHONE_NO |
| Logical Rolename | |
| ColumnName | HOME_PHONE_NO |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| HOME_PHONE_NO Logical Attribute Properties |
| Logical Attribute Name | HOME_PHONE_NO |
| Datatype | CHAR(30) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | EMAIL_ADDR |
| Logical Rolename | |
| ColumnName | EMAIL_ADDR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| EMAIL_ADDR Logical Attribute Properties |
| Logical Attribute Name | EMAIL_ADDR |
| Datatype | VARCHAR(300) |
| Nullable | YES |
| 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 Entity | SNS Employee Materialized View |
| Attribute Name | PAYROLL |
| Logical Rolename | |
| ColumnName | PAYROLL |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| PAYROLL Logical Attribute Properties |
| Logical Attribute Name | PAYROLL |
| Datatype | VARCHAR(3) |
| Nullable | YES |
| 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 |