| PERSON_ID |
| Base Object | PERSON |
| Attribute Name | Person Identifier |
| ColumnName | PERSON_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
| Note |
| PERSON_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PERSON_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| PERSON_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PERSON_ID Security Types |
| Name | Current Value |
| PERSON_ID Bound Attachments |
| Name | Current Value |
| PERSON_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PERSON_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Person Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PERSON PERSON_ID |
NO | ||
| ENGA (Oracle) PERSON PERSON_ID |
NO | ||
| EXPRESS (Oracle) PERSON PERSON_ID |
NO | ||
| IPTSv5 (Oracle) PERSON PERSON_ID |
NO | ||
| PRPSL (Oracle) PERSON PERSON_ID |
NO | ||
| PUBL (Oracle) PERSON PERSON_ID |
NO | ||
| XF_ADMIN (Oracle) PERSON PERSON_ID |
NO |
| PERSON_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERSON_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERSON_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERSON_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN |
| Base Object | PERSON |
| Attribute Name | Badge Number |
| ColumnName | BN |
| Logical Rolename | |
| RoleName | |
| Domain | Badge Number |
| Physical Only | NO |
| Definition | |
| Note |
| BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| 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 Person Badge Number |
NO | ||
| CNMS_PRPSL (Oracle) PERSON BN |
NO | ||
| ENGA (Oracle) PERSON BN |
NO | ||
| EXPRESS (Oracle) PERSON BN |
NO | ||
| IPTSv5 (Oracle) PERSON BN |
NO | ||
| PRPSL (Oracle) PERSON BN |
NO | ||
| PUBL (Oracle) PERSON BN |
NO | ||
| XF_ADMIN (Oracle) PERSON 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 |
| FIRST_NM |
| Base Object | PERSON |
| Attribute Name | First Name |
| ColumnName | FIRST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | First Name: Person first name. |
| Note |
| FIRST_NM Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FIRST_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| 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 Person First Name |
NO | ||
| CNMS_PRPSL (Oracle) PERSON FIRST_NM |
NO | ||
| ENGA (Oracle) PERSON FIRST_NM |
NO | ||
| EXPRESS (Oracle) PERSON FIRST_NM |
NO | ||
| IPTSv5 (Oracle) PERSON FIRST_NM |
NO | ||
| PRPSL (Oracle) PERSON FIRST_NM |
NO | ||
| PUBL (Oracle) PERSON FIRST_NM |
NO | ||
| XF_ADMIN (Oracle) PERSON 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 |
| LAST_NM |
| Base Object | PERSON |
| Attribute Name | Last Name |
| ColumnName | LAST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Last Name: person last name. |
| Note |
| LAST_NM Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LAST_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| LAST_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LAST_NM Security Types |
| Name | Current Value |
| LAST_NM Bound Attachments |
| Name | Current Value |
| LAST_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| LAST_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Last Name |
NO | ||
| CNMS_PRPSL (Oracle) PERSON LAST_NM |
NO | ||
| ENGA (Oracle) PERSON LAST_NM |
NO | ||
| EXPRESS (Oracle) PERSON LAST_NM |
NO | ||
| IPTSv5 (Oracle) PERSON LAST_NM |
NO | ||
| PRPSL (Oracle) PERSON LAST_NM |
NO | ||
| PUBL (Oracle) PERSON LAST_NM |
NO | ||
| XF_ADMIN (Oracle) PERSON LAST_NM |
NO |
| LAST_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USRNM |
| Base Object | PERSON |
| Attribute Name | Username |
| ColumnName | USRNM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Username: XCAMS computer username. |
| Note |
| USRNM Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USRNM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| USRNM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| USRNM Security Types |
| Name | Current Value |
| USRNM Bound Attachments |
| Name | Current Value |
| USRNM Data Movement Rules |
| Name | Type | Rule Text/Value |
| USRNM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Username |
NO | ||
| CNMS_PRPSL (Oracle) PERSON USRNM |
NO | ||
| ENGA (Oracle) PERSON USRNM |
NO | ||
| EXPRESS (Oracle) PERSON USRNM |
NO | ||
| IPTSv5 (Oracle) PERSON USRNM |
NO | ||
| PRPSL (Oracle) PERSON USRNM |
NO | ||
| PUBL (Oracle) PERSON USRNM |
NO | ||
| XF_ADMIN (Oracle) PERSON USRNM |
NO |
| USRNM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USRNM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USRNM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USRNM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR |
| Base Object | PERSON |
| Attribute Name | Email Address |
| ColumnName | EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Email Address: Person email address. |
| Note |
| EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| 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 Person Email Address |
NO | ||
| CNMS_PRPSL (Oracle) PERSON EMAIL_ADDR |
NO | ||
| ENGA (Oracle) PERSON EMAIL_ADDR |
NO | ||
| EXPRESS (Oracle) PERSON EMAIL_ADDR |
NO | ||
| IPTSv5 (Oracle) PERSON EMAIL_ADDR |
NO | ||
| PRPSL (Oracle) PERSON EMAIL_ADDR |
NO | ||
| PUBL (Oracle) PERSON EMAIL_ADDR |
NO | ||
| XF_ADMIN (Oracle) PERSON 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 |
| ST_ADDR |
| Base Object | PERSON |
| Attribute Name | Street Address |
| ColumnName | ST_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Street Address: |
| Note |
| ST_ADDR Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ST_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| ST_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ST_ADDR Security Types |
| Name | Current Value |
| ST_ADDR Bound Attachments |
| Name | Current Value |
| ST_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| ST_ADDR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Street Address |
NO | ||
| CNMS_PRPSL (Oracle) PERSON ST_ADDR |
NO | ||
| ENGA (Oracle) PERSON ST_ADDR |
NO | ||
| EXPRESS (Oracle) PERSON ST_ADDR |
NO | ||
| IPTSv5 (Oracle) PERSON ST_ADDR |
NO | ||
| PRPSL (Oracle) PERSON ST_ADDR |
NO | ||
| PUBL (Oracle) PERSON ST_ADDR |
NO | ||
| XF_ADMIN (Oracle) PERSON ST_ADDR |
NO |
| ST_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CITY |
| Base Object | PERSON |
| Attribute Name | City |
| ColumnName | CITY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | City: |
| Note |
| CITY Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CITY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| CITY Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CITY Security Types |
| Name | Current Value |
| CITY Bound Attachments |
| Name | Current Value |
| CITY Data Movement Rules |
| Name | Type | Rule Text/Value |
| CITY Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person City |
NO | ||
| CNMS_PRPSL (Oracle) PERSON CITY |
NO | ||
| ENGA (Oracle) PERSON CITY |
NO | ||
| EXPRESS (Oracle) PERSON CITY |
NO | ||
| IPTSv5 (Oracle) PERSON CITY |
NO | ||
| PRPSL (Oracle) PERSON CITY |
NO | ||
| PUBL (Oracle) PERSON CITY |
NO | ||
| XF_ADMIN (Oracle) PERSON CITY |
NO |
| CITY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CITY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CITY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CITY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATE |
| Base Object | PERSON |
| Attribute Name | State |
| ColumnName | STATE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | State: US state or country province. |
| Note |
| STATE Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STATE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| STATE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STATE Security Types |
| Name | Current Value |
| STATE Bound Attachments |
| Name | Current Value |
| STATE Data Movement Rules |
| Name | Type | Rule Text/Value |
| STATE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person State |
NO | ||
| CNMS_PRPSL (Oracle) PERSON STATE |
NO | ||
| ENGA (Oracle) PERSON STATE |
NO | ||
| EXPRESS (Oracle) PERSON STATE |
NO | ||
| IPTSv5 (Oracle) PERSON STATE |
NO | ||
| PRPSL (Oracle) PERSON STATE |
NO | ||
| PUBL (Oracle) PERSON STATE |
NO | ||
| XF_ADMIN (Oracle) PERSON STATE |
NO |
| STATE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| POST_CD |
| Base Object | PERSON |
| Attribute Name | Postal Code |
| ColumnName | POST_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Postal Code: |
| Note |
| POST_CD Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| POST_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| POST_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| POST_CD Security Types |
| Name | Current Value |
| POST_CD Bound Attachments |
| Name | Current Value |
| POST_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| POST_CD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Postal Code |
NO | ||
| CNMS_PRPSL (Oracle) PERSON POST_CD |
NO | ||
| ENGA (Oracle) PERSON POST_CD |
NO | ||
| EXPRESS (Oracle) PERSON POST_CD |
NO | ||
| IPTSv5 (Oracle) PERSON POST_CD |
NO | ||
| PRPSL (Oracle) PERSON POST_CD |
NO | ||
| PUBL (Oracle) PERSON POST_CD |
NO | ||
| XF_ADMIN (Oracle) PERSON POST_CD |
NO |
| POST_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| POST_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| POST_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| POST_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID |
| Base Object | PERSON |
| Attribute Name | Country Identifier |
| ColumnName | CNTRY_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Country Identifier: Abbreviated identrifier for a country. |
| Note |
| CNTRY_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CNTRY_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| CNTRY_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CNTRY_ID Security Types |
| Name | Current Value |
| CNTRY_ID Bound Attachments |
| Name | Current Value |
| CNTRY_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CNTRY_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Country Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PERSON CNTRY_ID |
NO | ||
| ENGA (Oracle) PERSON CNTRY_ID |
NO | ||
| EXPRESS (Oracle) PERSON CNTRY_ID |
NO | ||
| IPTSv5 (Oracle) PERSON CNTRY_ID |
NO | ||
| PRPSL (Oracle) PERSON CNTRY_ID |
NO | ||
| PUBL (Oracle) PERSON CNTRY_ID |
NO | ||
| XF_ADMIN (Oracle) PERSON CNTRY_ID |
NO |
| CNTRY_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR |
| Base Object | PERSON |
| Attribute Name | Phone Number |
| ColumnName | PHONE_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Phone Number: Numeric text and separator characters possibly including country code. |
| Note |
| PHONE_NBR Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PHONE_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| PHONE_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PHONE_NBR Security Types |
| Name | Current Value |
| PHONE_NBR Bound Attachments |
| Name | Current Value |
| PHONE_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| PHONE_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Phone Number |
NO | ||
| CNMS_PRPSL (Oracle) PERSON PHONE_NBR |
NO | ||
| ENGA (Oracle) PERSON PHONE_NBR |
NO | ||
| EXPRESS (Oracle) PERSON PHONE_NBR |
NO | ||
| IPTSv5 (Oracle) PERSON PHONE_NBR |
NO | ||
| PRPSL (Oracle) PERSON PHONE_NBR |
NO | ||
| PUBL (Oracle) PERSON PHONE_NBR |
NO | ||
| XF_ADMIN (Oracle) PERSON PHONE_NBR |
NO |
| PHONE_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NBR |
| Base Object | PERSON |
| Attribute Name | Cell Number |
| ColumnName | CELL_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | Phone |
| Physical Only | NO |
| Definition | |
| Note |
| CELL_NBR Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CELL_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| CELL_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CELL_NBR Security Types |
| Name | Current Value |
| CELL_NBR Bound Attachments |
| Name | Current Value |
| CELL_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| CELL_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Cell Number |
NO | ||
| CNMS_PRPSL (Oracle) PERSON CELL_NBR |
NO | ||
| ENGA (Oracle) PERSON CELL_NBR |
NO | ||
| EXPRESS (Oracle) PERSON CELL_NBR |
NO | ||
| IPTSv5 (Oracle) PERSON CELL_NBR |
NO | ||
| PRPSL (Oracle) PERSON CELL_NBR |
NO | ||
| PUBL (Oracle) PERSON CELL_NBR |
NO | ||
| XF_ADMIN (Oracle) PERSON CELL_NBR |
NO |
| CELL_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_ID |
| Base Object | PERSON |
| Attribute Name | Institute Identifier |
| ColumnName | INST_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Institute Identifer: Abbreviated identifier for a institute. |
| Note |
| INST_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INST_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| INST_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INST_ID Security Types |
| Name | Current Value |
| INST_ID Bound Attachments |
| Name | Current Value |
| INST_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| INST_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Institute Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PERSON INST_ID |
NO | ||
| ENGA (Oracle) PERSON INST_ID |
NO | ||
| EXPRESS (Oracle) PERSON INST_ID |
NO | ||
| IPTSv5 (Oracle) PERSON INST_ID |
NO | ||
| PRPSL (Oracle) PERSON INST_ID |
NO | ||
| PUBL (Oracle) PERSON INST_ID |
NO | ||
| XF_ADMIN (Oracle) PERSON INST_ID |
NO |
| INST_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_DEPT |
| Base Object | PERSON |
| Attribute Name | Institute Department |
| ColumnName | INST_DEPT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| INST_DEPT Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INST_DEPT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| INST_DEPT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INST_DEPT Security Types |
| Name | Current Value |
| INST_DEPT Bound Attachments |
| Name | Current Value |
| INST_DEPT Data Movement Rules |
| Name | Type | Rule Text/Value |
| INST_DEPT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Institute Department |
NO | ||
| CNMS_PRPSL (Oracle) PERSON INST_DEPT |
NO | ||
| ENGA (Oracle) PERSON INST_DEPT |
NO | ||
| EXPRESS (Oracle) PERSON INST_DEPT |
NO | ||
| IPTSv5 (Oracle) PERSON INST_DEPT |
NO | ||
| PRPSL (Oracle) PERSON INST_DEPT |
NO | ||
| PUBL (Oracle) PERSON INST_DEPT |
NO | ||
| XF_ADMIN (Oracle) PERSON INST_DEPT |
NO |
| INST_DEPT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_DEPT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_DEPT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INST_DEPT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTIF_READ_IND |
| Base Object | PERSON |
| Attribute Name | Notification Read Indicator |
| ColumnName | NOTIF_READ_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| NOTIF_READ_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NOTIF_READ_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| NOTIF_READ_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| NOTIF_READ_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| NOTIF_READ_IND Security Types |
| Name | Current Value |
| NOTIF_READ_IND Bound Attachments |
| Name | Current Value |
| NOTIF_READ_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| NOTIF_READ_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Person Notification Read Indicator |
NO | ||
| CNMS_PRPSL (Oracle) PERSON NOTIF_READ_IND |
NO | ||
| ENGA (Oracle) PERSON NOTIF_READ_IND |
NO | ||
| EXPRESS (Oracle) PERSON NOTIF_READ_IND |
NO | ||
| IPTSv5 (Oracle) PERSON NOTIF_READ_IND |
NO | ||
| PRPSL (Oracle) PERSON NOTIF_READ_IND |
NO | ||
| PUBL (Oracle) PERSON NOTIF_READ_IND |
NO | ||
| XF_ADMIN (Oracle) PERSON NOTIF_READ_IND |
NO |
| NOTIF_READ_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTIF_READ_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTIF_READ_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTIF_READ_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |