EMAIL_ADDR |
Base Object | NONVAL_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 Non Validated Person Email Address |
NO | ||
Logical NonValidated Person Email Address |
NO | ||
PRPSL (Oracle) NONVAL_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 |
PAS_START_DTE |
Base Object | NONVAL_PERSON |
Attribute Name | Personnel Access System Start Date |
ColumnName | PAS_START_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
PAS_START_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAS_START_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
PAS_START_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
PAS_START_DTE Security Types |
Name | Current Value |
PAS_START_DTE Bound Attachments |
Name | Current Value |
PAS_START_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
PAS_START_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person Personnel Access System Start Date |
NO | ||
Logical NonValidated Person Personnel Access System Start Date |
NO | ||
PRPSL (Oracle) NONVAL_PERSON PAS_START_DTE |
NO |
PAS_START_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAS_START_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAS_START_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAS_START_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAS_END_DTE |
Base Object | NONVAL_PERSON |
Attribute Name | Personnel Access System End Date |
ColumnName | PAS_END_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
PAS_END_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAS_END_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
PAS_END_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
PAS_END_DTE Security Types |
Name | Current Value |
PAS_END_DTE Bound Attachments |
Name | Current Value |
PAS_END_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
PAS_END_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person Personnel Access System End Date |
NO | ||
Logical NonValidated Person Personnel Access System End Date |
NO | ||
PRPSL (Oracle) NONVAL_PERSON PAS_END_DTE |
NO |
PAS_END_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAS_END_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAS_END_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAS_END_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SAT_EXP_DTE |
Base Object | NONVAL_PERSON |
Attribute Name | Standard Access Training Expiration Date |
ColumnName | SAT_EXP_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
SAT_EXP_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SAT_EXP_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
SAT_EXP_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
SAT_EXP_DTE Security Types |
Name | Current Value |
SAT_EXP_DTE Bound Attachments |
Name | Current Value |
SAT_EXP_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
SAT_EXP_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person Standard Access Training Expiration Date |
NO | ||
Logical NonValidated Person Standard Access Training Expiration Date |
NO | ||
PRPSL (Oracle) NONVAL_PERSON SAT_EXP_DTE |
NO |
SAT_EXP_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SAT_EXP_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SAT_EXP_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SAT_EXP_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_ACC_EXP_DTE |
Base Object | NONVAL_PERSON |
Attribute Name | SNS Access Expiration Date |
ColumnName | SNS_ACC_EXP_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
SNS_ACC_EXP_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SNS_ACC_EXP_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
SNS_ACC_EXP_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
SNS_ACC_EXP_DTE Security Types |
Name | Current Value |
SNS_ACC_EXP_DTE Bound Attachments |
Name | Current Value |
SNS_ACC_EXP_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
SNS_ACC_EXP_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person SNS Access Expiration Date |
NO | ||
Logical NonValidated Person SNS Access Expiration Date |
NO | ||
PRPSL (Oracle) NONVAL_PERSON SNS_ACC_EXP_DTE |
NO |
SNS_ACC_EXP_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_ACC_EXP_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_ACC_EXP_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_ACC_EXP_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_ACC_EXP_DTE |
Base Object | NONVAL_PERSON |
Attribute Name | HFIR Access Expiration Date |
ColumnName | HFIR_ACC_EXP_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
HFIR_ACC_EXP_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HFIR_ACC_EXP_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
HFIR_ACC_EXP_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
HFIR_ACC_EXP_DTE Security Types |
Name | Current Value |
HFIR_ACC_EXP_DTE Bound Attachments |
Name | Current Value |
HFIR_ACC_EXP_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
HFIR_ACC_EXP_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person HFIR Access Expiration Date |
NO | ||
Logical NonValidated Person HFIR Access Expiration Date |
NO | ||
PRPSL (Oracle) NONVAL_PERSON HFIR_ACC_EXP_DTE |
NO |
HFIR_ACC_EXP_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_ACC_EXP_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_ACC_EXP_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_ACC_EXP_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RWT_EXP_DTE |
Base Object | NONVAL_PERSON |
Attribute Name | Radiological Worker Training Expiration Date |
ColumnName | RWT_EXP_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
RWT_EXP_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RWT_EXP_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
RWT_EXP_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
RWT_EXP_DTE Security Types |
Name | Current Value |
RWT_EXP_DTE Bound Attachments |
Name | Current Value |
RWT_EXP_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
RWT_EXP_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person Radiological Worker Training Expiration Date |
NO | ||
Logical NonValidated Person Radiological Worker Training Expiration Date |
NO | ||
PRPSL (Oracle) NONVAL_PERSON RWT_EXP_DTE |
NO |
RWT_EXP_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RWT_EXP_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RWT_EXP_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RWT_EXP_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_APPR_DTE |
Base Object | NONVAL_PERSON |
Attribute Name | Organization Approval Date |
ColumnName | ORG_APPR_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Organization Approval Date: Date the request was sent for PAS approval by the instrument organization. (? ) |
Note |
ORG_APPR_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORG_APPR_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
ORG_APPR_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
ORG_APPR_DTE Security Types |
Name | Current Value |
ORG_APPR_DTE Bound Attachments |
Name | Current Value |
ORG_APPR_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
ORG_APPR_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person Organization Approval Date |
NO | ||
Logical NonValidated Person Organization Approval Date |
NO | ||
PRPSL (Oracle) NONVAL_PERSON ORG_APPR_DTE |
NO |
ORG_APPR_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_APPR_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_APPR_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_APPR_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
USER_OFF_NOTE |
Base Object | NONVAL_PERSON |
Attribute Name | User Office Note |
ColumnName | USER_OFF_NOTE |
Logical Rolename | |
RoleName | |
Domain | Note |
Physical Only | NO |
Definition | |
Note |
USER_OFF_NOTE Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
USER_OFF_NOTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
USER_OFF_NOTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
USER_OFF_NOTE Security Types |
Name | Current Value |
USER_OFF_NOTE Bound Attachments |
Name | Current Value |
USER_OFF_NOTE Data Movement Rules |
Name | Type | Rule Text/Value |
USER_OFF_NOTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Non Validated Person User Office Note |
NO | ||
Logical NonValidated Person User Office Note |
NO | ||
PRPSL (Oracle) NONVAL_PERSON USER_OFF_NOTE |
NO |
USER_OFF_NOTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
USER_OFF_NOTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
USER_OFF_NOTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
USER_OFF_NOTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |