| Email Address |
| Base Entity | NonValidated Person |
| Attribute Name | Email Address |
| Logical Rolename | |
| ColumnName | EMAIL_ADDR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Email Address: Person email address. |
| Note |
| Email Address Logical Attribute Properties |
| Logical Attribute Name | Email Address |
| Datatype | VARCHAR(100) |
| Nullable | NO |
| Email Address Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Email Address Security Types |
| Name | Current Value |
| Email Address Bound Attachments |
| Name | Current Value |
| Email Address Data Movement Rules |
| Name | Type | Rule Text/Value |
| Email Address Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person Email Address |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON EMAIL_ADDR |
NO |
| Email Address Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Start Date |
| Base Entity | NonValidated Person |
| Attribute Name | Personnel Access System Start Date |
| Logical Rolename | |
| ColumnName | PAS_START_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Personnel Access System Start Date Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Start Date |
| Datatype | DATE |
| Nullable | NO |
| Personnel Access System Start Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Personnel Access System Start Date Security Types |
| Name | Current Value |
| Personnel Access System Start Date Bound Attachments |
| Name | Current Value |
| Personnel Access System Start Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Start Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person Personnel Access System Start Date |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON PAS_START_DTE |
NO |
| Personnel Access System Start Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Start Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Start Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Start Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System End Date |
| Base Entity | NonValidated Person |
| Attribute Name | Personnel Access System End Date |
| Logical Rolename | |
| ColumnName | PAS_END_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Personnel Access System End Date Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System End Date |
| Datatype | DATE |
| Nullable | NO |
| Personnel Access System End Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Personnel Access System End Date Security Types |
| Name | Current Value |
| Personnel Access System End Date Bound Attachments |
| Name | Current Value |
| Personnel Access System End Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System End Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person Personnel Access System End Date |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON PAS_END_DTE |
NO |
| Personnel Access System End Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System End Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System End Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System End Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Standard Access Training Expiration Date |
| Base Entity | NonValidated Person |
| Attribute Name | Standard Access Training Expiration Date |
| Logical Rolename | |
| ColumnName | SAT_EXP_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Standard Access Training Expiration Date Logical Attribute Properties |
| Logical Attribute Name | Standard Access Training Expiration Date |
| Datatype | DATE |
| Nullable | NO |
| Standard Access Training Expiration Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Standard Access Training Expiration Date Security Types |
| Name | Current Value |
| Standard Access Training Expiration Date Bound Attachments |
| Name | Current Value |
| Standard Access Training Expiration Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Standard Access Training Expiration Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person Standard Access Training Expiration Date |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON SAT_EXP_DTE |
NO |
| Standard Access Training Expiration Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Standard Access Training Expiration Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Standard Access Training Expiration Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Standard Access Training Expiration Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Access Expiration Date |
| Base Entity | NonValidated Person |
| Attribute Name | SNS Access Expiration Date |
| Logical Rolename | |
| ColumnName | SNS_ACC_EXP_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| SNS Access Expiration Date Logical Attribute Properties |
| Logical Attribute Name | SNS Access Expiration Date |
| Datatype | DATE |
| Nullable | NO |
| SNS Access Expiration Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| SNS Access Expiration Date Security Types |
| Name | Current Value |
| SNS Access Expiration Date Bound Attachments |
| Name | Current Value |
| SNS Access Expiration Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNS Access Expiration Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person SNS Access Expiration Date |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON SNS_ACC_EXP_DTE |
NO |
| SNS Access Expiration Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Access Expiration Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Access Expiration Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Access Expiration Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR Access Expiration Date |
| Base Entity | NonValidated Person |
| Attribute Name | HFIR Access Expiration Date |
| Logical Rolename | |
| ColumnName | HFIR_ACC_EXP_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| HFIR Access Expiration Date Logical Attribute Properties |
| Logical Attribute Name | HFIR Access Expiration Date |
| Datatype | DATE |
| Nullable | NO |
| HFIR Access Expiration Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| HFIR Access Expiration Date Security Types |
| Name | Current Value |
| HFIR Access Expiration Date Bound Attachments |
| Name | Current Value |
| HFIR Access Expiration Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| HFIR Access Expiration Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person HFIR Access Expiration Date |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON HFIR_ACC_EXP_DTE |
NO |
| HFIR Access Expiration Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR Access Expiration Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR Access Expiration Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR Access Expiration Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiological Worker Training Expiration Date |
| Base Entity | NonValidated Person |
| Attribute Name | Radiological Worker Training Expiration Date |
| Logical Rolename | |
| ColumnName | RWT_EXP_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Radiological Worker Training Expiration Date Logical Attribute Properties |
| Logical Attribute Name | Radiological Worker Training Expiration Date |
| Datatype | DATE |
| Nullable | NO |
| Radiological Worker Training Expiration Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Radiological Worker Training Expiration Date Security Types |
| Name | Current Value |
| Radiological Worker Training Expiration Date Bound Attachments |
| Name | Current Value |
| Radiological Worker Training Expiration Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radiological Worker Training Expiration Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person Radiological Worker Training Expiration Date |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON RWT_EXP_DTE |
NO |
| Radiological Worker Training Expiration Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiological Worker Training Expiration Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiological Worker Training Expiration Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiological Worker Training Expiration Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Organization Approval Date |
| Base Entity | NonValidated Person |
| Attribute Name | Organization Approval Date |
| Logical Rolename | |
| ColumnName | ORG_APPR_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Organization Approval Date: Date the request was sent for PAS approval by the instrument organization. (? ) |
| Note |
| Organization Approval Date Logical Attribute Properties |
| Logical Attribute Name | Organization Approval Date |
| Datatype | DATE |
| Nullable | NO |
| Organization Approval Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Organization Approval Date Security Types |
| Name | Current Value |
| Organization Approval Date Bound Attachments |
| Name | Current Value |
| Organization Approval Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Organization Approval Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person Organization Approval Date |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON ORG_APPR_DTE |
NO |
| Organization Approval Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Organization Approval Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Organization Approval Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Organization Approval Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Office Note |
| Base Entity | NonValidated Person |
| Attribute Name | User Office Note |
| Logical Rolename | |
| ColumnName | USER_OFF_NOTE |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| User Office Note Logical Attribute Properties |
| Logical Attribute Name | User Office Note |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| User Office Note Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| User Office Note Security Types |
| Name | Current Value |
| User Office Note Bound Attachments |
| Name | Current Value |
| User Office Note Data Movement Rules |
| Name | Type | Rule Text/Value |
| User Office Note Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical NonValidated Person User Office Note |
NO | ||
| PRPSL (Oracle) NONVAL_PERSON USER_OFF_NOTE |
NO |
| User Office Note Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Office Note Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Office Note Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Office Note Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |