| BN |
| Base Object | PERS_ROLES |
| Attribute Name | BN |
| 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 Personnel Role BN |
NO | ||
| NS_OPER (Oracle) PERS_ROLES BN |
NO | ||
| OPER (Oracle) PERS_ROLES 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 |
| PERS_ROLE_DESC |
| Base Object | PERS_ROLES |
| Attribute Name | PERS_ROLE_DESC |
| ColumnName | PERS_ROLE_DESC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PERS_ROLE_DESC Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PERS_ROLE_DESC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| PERS_ROLE_DESC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PERS_ROLE_DESC Security Types |
| Name | Current Value |
| PERS_ROLE_DESC Bound Attachments |
| Name | Current Value |
| PERS_ROLE_DESC Data Movement Rules |
| Name | Type | Rule Text/Value |
| PERS_ROLE_DESC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role PERS_ROLE_DESC |
NO | ||
| NS_OPER (Oracle) PERS_ROLES PERS_ROLE_DESC |
NO | ||
| OPER (Oracle) PERS_ROLES PERS_ROLE_DESC |
NO |
| PERS_ROLE_DESC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERS_ROLE_DESC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERS_ROLE_DESC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERS_ROLE_DESC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPR_MGR_IND |
| Base Object | PERS_ROLES |
| Attribute Name | OPR_MGR_IND |
| ColumnName | OPR_MGR_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| OPR_MGR_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OPR_MGR_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| OPR_MGR_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| OPR_MGR_IND Security Types |
| Name | Current Value |
| OPR_MGR_IND Bound Attachments |
| Name | Current Value |
| OPR_MGR_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| OPR_MGR_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role OPR_MGR_IND |
NO | ||
| NS_OPER (Oracle) PERS_ROLES OPR_MGR_IND |
NO | ||
| OPER (Oracle) PERS_ROLES OPR_MGR_IND |
NO |
| OPR_MGR_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPR_MGR_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPR_MGR_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPR_MGR_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND |
| Base Object | PERS_ROLES |
| Attribute Name | AREA_MGR_IND |
| ColumnName | AREA_MGR_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| AREA_MGR_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AREA_MGR_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| AREA_MGR_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| AREA_MGR_IND Security Types |
| Name | Current Value |
| AREA_MGR_IND Bound Attachments |
| Name | Current Value |
| AREA_MGR_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| AREA_MGR_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Area Mgr Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES AREA_MGR_IND |
NO | ||
| OPER (Oracle) PERS_ROLES AREA_MGR_IND |
NO |
| AREA_MGR_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_MGR_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND |
| Base Object | PERS_ROLES |
| Attribute Name | AREA_ENGR_IND |
| ColumnName | AREA_ENGR_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| AREA_ENGR_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AREA_ENGR_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| AREA_ENGR_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| AREA_ENGR_IND Security Types |
| Name | Current Value |
| AREA_ENGR_IND Bound Attachments |
| Name | Current Value |
| AREA_ENGR_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| AREA_ENGR_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Area Engr Ind |
NO | ||
| NS_OPER (Oracle) PERS_ROLES AREA_ENGR_IND |
NO | ||
| OPER (Oracle) PERS_ROLES AREA_ENGR_IND |
NO |
| AREA_ENGR_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ENGR_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOG_READ_ONLY_IND |
| Base Object | PERS_ROLES |
| Attribute Name | LOG_READ_ONLY_IND |
| ColumnName | LOG_READ_ONLY_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| LOG_READ_ONLY_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LOG_READ_ONLY_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| LOG_READ_ONLY_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| LOG_READ_ONLY_IND Security Types |
| Name | Current Value |
| LOG_READ_ONLY_IND Bound Attachments |
| Name | Current Value |
| LOG_READ_ONLY_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| LOG_READ_ONLY_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role LOG_READ_ONLY_IND |
NO | ||
| NS_OPER (Oracle) PERS_ROLES LOG_READ_ONLY_IND |
NO | ||
| OPER (Oracle) PERS_ROLES LOG_READ_ONLY_IND |
NO |
| LOG_READ_ONLY_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOG_READ_ONLY_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOG_READ_ONLY_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOG_READ_ONLY_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO |
| Base Object | PERS_ROLES |
| Attribute Name | PHOTO |
| ColumnName | PHOTO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PHOTO Column Properties |
| Datatype | BLOB |
| Nullable | YES |
| Not Null Constraint |
| PHOTO Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| PHOTO Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PHOTO Security Types |
| Name | Current Value |
| PHOTO Bound Attachments |
| Name | Current Value |
| PHOTO Data Movement Rules |
| Name | Type | Rule Text/Value |
| PHOTO Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Photograph |
NO | ||
| NS_OPER (Oracle) PERS_ROLES PHOTO |
NO | ||
| OPER (Oracle) PERS_ROLES PHOTO |
NO |
| PHOTO Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FILE_NM |
| Base Object | PERS_ROLES |
| Attribute Name | FILE_NM |
| ColumnName | FILE_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| FILE_NM Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FILE_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| FILE_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FILE_NM Security Types |
| Name | Current Value |
| FILE_NM Bound Attachments |
| Name | Current Value |
| FILE_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| FILE_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role FILE_NM |
NO | ||
| NS_OPER (Oracle) PERS_ROLES FILE_NM |
NO | ||
| OPER (Oracle) PERS_ROLES FILE_NM |
NO |
| FILE_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FILE_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FILE_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FILE_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIMETYPE |
| Base Object | PERS_ROLES |
| Attribute Name | MIMETYPE |
| ColumnName | MIMETYPE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| MIMETYPE Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MIMETYPE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| MIMETYPE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MIMETYPE Security Types |
| Name | Current Value |
| MIMETYPE Bound Attachments |
| Name | Current Value |
| MIMETYPE Data Movement Rules |
| Name | Type | Rule Text/Value |
| MIMETYPE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role MIMETYPE |
NO | ||
| NS_OPER (Oracle) PERS_ROLES MIMETYPE |
NO | ||
| OPER (Oracle) PERS_ROLES MIMETYPE |
NO |
| MIMETYPE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIMETYPE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIMETYPE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIMETYPE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO_LAST_UPDTE |
| Base Object | PERS_ROLES |
| Attribute Name | PHOTO_LAST_UPDTE |
| ColumnName | PHOTO_LAST_UPDTE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PHOTO_LAST_UPDTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PHOTO_LAST_UPDTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| PHOTO_LAST_UPDTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PHOTO_LAST_UPDTE Security Types |
| Name | Current Value |
| PHOTO_LAST_UPDTE Bound Attachments |
| Name | Current Value |
| PHOTO_LAST_UPDTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PHOTO_LAST_UPDTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role PHOTO_LAST_UPDTE |
NO | ||
| NS_OPER (Oracle) PERS_ROLES PHOTO_LAST_UPDTE |
NO | ||
| OPER (Oracle) PERS_ROLES PHOTO_LAST_UPDTE |
NO |
| PHOTO_LAST_UPDTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO_LAST_UPDTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO_LAST_UPDTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHOTO_LAST_UPDTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |