| Proposal Identifier |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Proposal Identifier |
| Logical Rolename | |
| ColumnName | PRPSL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Proposal Identifier Logical Attribute Properties |
| Logical Attribute Name | Proposal Identifier |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| Proposal Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Proposal Identifier Security Types |
| Name | Current Value |
| Proposal Identifier Bound Attachments |
| Name | Current Value |
| Proposal Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proposal Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Proposal Identifier |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PRPSL_ID |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PRPSL_ID |
NO |
| Proposal Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Submission Number |
| Logical Rolename | |
| ColumnName | SUBMISS_NBR |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Submission Number Logical Attribute Properties |
| Logical Attribute Name | Submission Number |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Submission Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Submission Number Security Types |
| Name | Current Value |
| Submission Number Bound Attachments |
| Name | Current Value |
| Submission Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Submission Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Submission Number |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SUBMISS_NBR |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SUBMISS_NBR |
NO |
| Submission Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Address |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Email Address |
| Logical Rolename | |
| ColumnName | NONVAL_PERSON_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 Proposal Team Member Onsite Access Email Address |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC NONVAL_PERSON_EMAIL_ADDR |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC 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 |
| Email Addr |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| 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(64) |
| Nullable | NO |
| 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 Nonvalidated Proposal Team Member Onsite Access Email Addr |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC EMAIL_ADDR |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC 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 |
| Start Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Start Date |
| Logical Rolename | |
| ColumnName | START_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Start Date Logical Attribute Properties |
| Logical Attribute Name | Start Date |
| Datatype | DATE |
| Nullable | NO |
| Start Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Start Date Security Types |
| Name | Current Value |
| Start Date Bound Attachments |
| Name | Current Value |
| Start Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Start Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Start Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC START_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC START_DTE |
NO |
| Start Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Status Identifer |
| Logical Rolename | |
| ColumnName | STAT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Status Identifer Logical Attribute Properties |
| Logical Attribute Name | Status Identifer |
| Datatype | CHAR(1) |
| Nullable | NO |
| Status Identifer Domain Restrictions |
| CheckConstraint | stat_id IN ('N','I','V') | ||
| Check Constraint Name | CK_NPTOA_STAT_ID | ||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Status Identifer Security Types |
| Name | Current Value |
| Status Identifer Bound Attachments |
| Name | Current Value |
| Status Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Status Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Status Identifer |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC STAT_ID |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC STAT_ID |
NO |
| Status Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approved |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Personnel Access System Approved |
| Logical Rolename | |
| ColumnName | PAS_APP_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Personnel Access System Approved Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Approved |
| Datatype | CHAR(1) |
| Nullable | NO |
| Personnel Access System Approved Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Personnel Access System Approved 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 |
| Personnel Access System Approved Security Types |
| Name | Current Value |
| Personnel Access System Approved Bound Attachments |
| Name | Current Value |
| Personnel Access System Approved Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Approved Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Personnel Access System Approved |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_APP_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_APP_IND |
NO |
| Personnel Access System Approved Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approved Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approved Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approved Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Site Access Training Indictor |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Site Access Training Indictor |
| Logical Rolename | |
| ColumnName | SITE_ACC_TRAIN_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Site Access Training Indictor Logical Attribute Properties |
| Logical Attribute Name | Site Access Training Indictor |
| Datatype | CHAR(1) |
| Nullable | NO |
| Site Access Training Indictor Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Site Access Training Indictor 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 |
| Site Access Training Indictor Security Types |
| Name | Current Value |
| Site Access Training Indictor Bound Attachments |
| Name | Current Value |
| Site Access Training Indictor Data Movement Rules |
| Name | Type | Rule Text/Value |
| Site Access Training Indictor Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Site Access Training Indictor |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SITE_ACC_TRAIN_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SITE_ACC_TRAIN_IND |
NO |
| Site Access Training Indictor Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Site Access Training Indictor Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Site Access Training Indictor Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Site Access Training Indictor Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Pre Approval Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | SNS Pre Approval Indicator |
| Logical Rolename | |
| ColumnName | SNS_PRE_APP_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| SNS Pre Approval Indicator Logical Attribute Properties |
| Logical Attribute Name | SNS Pre Approval Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| SNS Pre Approval Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNS Pre Approval Indicator 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 |
| SNS Pre Approval Indicator Security Types |
| Name | Current Value |
| SNS Pre Approval Indicator Bound Attachments |
| Name | Current Value |
| SNS Pre Approval Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNS Pre Approval Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access SNS Pre Approval Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SNS_PRE_APP_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SNS_PRE_APP_IND |
NO |
| SNS Pre Approval Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Pre Approval Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Pre Approval Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Pre Approval Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Target Access Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | SNS Target Access Indicator |
| Logical Rolename | |
| ColumnName | SNS_TGT_ACC_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| SNS Target Access Indicator Logical Attribute Properties |
| Logical Attribute Name | SNS Target Access Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| SNS Target Access Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNS Target Access Indicator 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 |
| SNS Target Access Indicator Security Types |
| Name | Current Value |
| SNS Target Access Indicator Bound Attachments |
| Name | Current Value |
| SNS Target Access Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNS Target Access Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access SNS Target Access Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SNS_TGT_ACC_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC SNS_TGT_ACC_IND |
NO |
| SNS Target Access Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Target Access Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Target Access Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS Target Access Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR General User Access Training Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | HFIR General User Access Training Indicator |
| Logical Rolename | |
| ColumnName | HFIR_GEN_USER_ACC_TRAIN_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| HFIR General User Access Training Indicator Logical Attribute Properties |
| Logical Attribute Name | HFIR General User Access Training Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| HFIR General User Access Training Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HFIR General User Access Training Indicator 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 |
| HFIR General User Access Training Indicator Security Types |
| Name | Current Value |
| HFIR General User Access Training Indicator Bound Attachments |
| Name | Current Value |
| HFIR General User Access Training Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| HFIR General User Access Training Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access HFIR General User Access Training Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC HFIR_GEN_USER_ACC_TRAIN_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC HFIR_GEN_USER_ACC_TRAIN_IND |
NO |
| HFIR General User Access Training Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR General User Access Training Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR General User Access Training Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR General User Access Training Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Worker Training Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Radiation Worker Training Indicator |
| Logical Rolename | |
| ColumnName | RAD_WORK_TRAIN_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Radiation Worker Training Indicator Logical Attribute Properties |
| Logical Attribute Name | Radiation Worker Training Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Radiation Worker Training Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Radiation Worker Training Indicator 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 |
| Radiation Worker Training Indicator Security Types |
| Name | Current Value |
| Radiation Worker Training Indicator Bound Attachments |
| Name | Current Value |
| Radiation Worker Training Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radiation Worker Training Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Radiation Worker Training Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC RAD_WORK_TRAIN_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC RAD_WORK_TRAIN_IND |
NO |
| Radiation Worker Training Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Worker Training Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Worker Training Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiation Worker Training Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Practical Factors Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Practical Factors Date |
| Logical Rolename | |
| ColumnName | PFE_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Practical Factors Date Logical Attribute Properties |
| Logical Attribute Name | Practical Factors Date |
| Datatype | DATE |
| Nullable | YES |
| Practical Factors Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Practical Factors Date Security Types |
| Name | Current Value |
| Practical Factors Date Bound Attachments |
| Name | Current Value |
| Practical Factors Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Practical Factors Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Practical Factors Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PFE_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PFE_DTE |
NO |
| Practical Factors Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Practical Factors Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Practical Factors Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Practical Factors Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Date Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Access Date Indicator |
| Logical Rolename | |
| ColumnName | ACC_DTE_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Access Date Indicator Logical Attribute Properties |
| Logical Attribute Name | Access Date Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Access Date Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Access Date Indicator 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 |
| Access Date Indicator Security Types |
| Name | Current Value |
| Access Date Indicator Bound Attachments |
| Name | Current Value |
| Access Date Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Access Date Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Access Date Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC ACC_DTE_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC ACC_DTE_IND |
NO |
| Access Date Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Date Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Date Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Date Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dosimetry Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Dosimetry Indicator |
| Logical Rolename | |
| ColumnName | DOSIMETRY_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Dosimetry Indicator Logical Attribute Properties |
| Logical Attribute Name | Dosimetry Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Dosimetry Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Dosimetry Indicator 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 |
| Dosimetry Indicator Security Types |
| Name | Current Value |
| Dosimetry Indicator Bound Attachments |
| Name | Current Value |
| Dosimetry Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dosimetry Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Dosimetry Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC DOSIMETRY_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC DOSIMETRY_IND |
NO |
| Dosimetry Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dosimetry Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dosimetry Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dosimetry Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Badge Number |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | PAS Badge Number |
| Logical Rolename | |
| ColumnName | PAS_BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| PAS Badge Number Logical Attribute Properties |
| Logical Attribute Name | PAS Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| PAS Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS Badge Number Security Types |
| Name | Current Value |
| PAS Badge Number Bound Attachments |
| Name | Current Value |
| PAS Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access PAS Badge Number |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_BN |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_BN |
NO |
| PAS Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Email Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Access Email Date |
| Logical Rolename | |
| ColumnName | ACCESS_EMAIL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Access Email Date Logical Attribute Properties |
| Logical Attribute Name | Access Email Date |
| Datatype | DATE |
| Nullable | YES |
| Access Email Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Access Email Date Security Types |
| Name | Current Value |
| Access Email Date Bound Attachments |
| Name | Current Value |
| Access Email Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Access Email Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Access Email Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC ACCESS_EMAIL_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC ACCESS_EMAIL_DTE |
NO |
| Access Email Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Email Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Email Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Access Email Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Target Building Orientation Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Target Building Orientation Indicator |
| Logical Rolename | |
| ColumnName | TGT_BLDG_ORIENT_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Target Building Orientation Indicator Logical Attribute Properties |
| Logical Attribute Name | Target Building Orientation Indicator |
| Datatype | CHAR(1) |
| Nullable | YES |
| Target Building Orientation Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Target Building Orientation Indicator 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 |
| Target Building Orientation Indicator Security Types |
| Name | Current Value |
| Target Building Orientation Indicator Bound Attachments |
| Name | Current Value |
| Target Building Orientation Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Target Building Orientation Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Target Building Orientation Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC TGT_BLDG_ORIENT_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC TGT_BLDG_ORIENT_IND |
NO |
| Target Building Orientation Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Target Building Orientation Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Target Building Orientation Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Target Building Orientation Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Email Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Host Email Date |
| Logical Rolename | |
| ColumnName | HOST_EMAIL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Host Email Date Logical Attribute Properties |
| Logical Attribute Name | Host Email Date |
| Datatype | DATE |
| Nullable | YES |
| Host Email Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Host Email Date Security Types |
| Name | Current Value |
| Host Email Date Bound Attachments |
| Name | Current Value |
| Host Email Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Host Email Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Host Email Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC HOST_EMAIL_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC HOST_EMAIL_DTE |
NO |
| Host Email Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Email Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Email Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Email Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Badge Number |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Host Badge Number |
| Logical Rolename | |
| ColumnName | HOST_BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| Host Badge Number Logical Attribute Properties |
| Logical Attribute Name | Host Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Host Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Host Badge Number Security Types |
| Name | Current Value |
| Host Badge Number Bound Attachments |
| Name | Current Value |
| Host Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Host Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Host Badge Number |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC HOST_BN |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC HOST_BN |
NO |
| Host Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Host Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invite Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Personnel Access System Invite Date |
| Logical Rolename | |
| ColumnName | PAS_INVITE_DTE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Personnel Access System Invite Date Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Invite Date |
| Datatype | DATE |
| Nullable | YES |
| Personnel Access System Invite Date Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Personnel Access System Invite Date Security Types |
| Name | Current Value |
| Personnel Access System Invite Date Bound Attachments |
| Name | Current Value |
| Personnel Access System Invite Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Invite Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Personnel Access System Invite Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_INVITE_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_INVITE_DTE |
NO |
| Personnel Access System Invite Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invite Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invite Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invite Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Input Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Personnel Access System Input Date |
| Logical Rolename | |
| ColumnName | PAS_INPUT_DTE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Personnel Access System Input Date Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Input Date |
| Datatype | DATE |
| Nullable | YES |
| Personnel Access System Input Date Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Personnel Access System Input Date Security Types |
| Name | Current Value |
| Personnel Access System Input Date Bound Attachments |
| Name | Current Value |
| Personnel Access System Input Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Input Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Personnel Access System Input Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_INPUT_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_INPUT_DTE |
NO |
| Personnel Access System Input Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Input Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Input Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Input Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Training Email Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Training Email Date |
| Logical Rolename | |
| ColumnName | TRAIN_EMAIL_DTE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Training Email Date Logical Attribute Properties |
| Logical Attribute Name | Training Email Date |
| Datatype | DATE |
| Nullable | YES |
| Training Email Date Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Training Email Date Security Types |
| Name | Current Value |
| Training Email Date Bound Attachments |
| Name | Current Value |
| Training Email Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Training Email Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Training Email Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC TRAIN_EMAIL_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC TRAIN_EMAIL_DTE |
NO |
| Training Email Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Training Email Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Training Email Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Training Email Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Building Access Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | PAS Building Access Indicator |
| Logical Rolename | |
| ColumnName | PAS_BLDG_ACCESS_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| PAS Building Access Indicator Logical Attribute Properties |
| Logical Attribute Name | PAS Building Access Indicator |
| Datatype | CHAR(1) |
| Nullable | YES |
| PAS Building Access Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS Building Access Indicator 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 |
| PAS Building Access Indicator Security Types |
| Name | Current Value |
| PAS Building Access Indicator Bound Attachments |
| Name | Current Value |
| PAS Building Access Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS Building Access Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access PAS Building Access Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_BLDG_ACCESS_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_BLDG_ACCESS_IND |
NO |
| PAS Building Access Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Building Access Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Building Access Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS Building Access Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invitiation Identifier |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Personnel Access System Invitiation Identifier |
| Logical Rolename | |
| ColumnName | PAS_INVIT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Personnel Access System Invitiation Identifier Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Invitiation Identifier |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Personnel Access System Invitiation Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Personnel Access System Invitiation Identifier Security Types |
| Name | Current Value |
| Personnel Access System Invitiation Identifier Bound Attachments |
| Name | Current Value |
| Personnel Access System Invitiation Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Invitiation Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Personnel Access System Invitiation Identifier |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_INVIT_ID |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_INVIT_ID |
NO |
| Personnel Access System Invitiation Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invitiation Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invitiation Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Invitiation Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approval Sent Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Personnel Access System Approval Sent Date |
| Logical Rolename | |
| ColumnName | PAS_APPRV_SENT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Personnel Access System Approval Sent Date Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Approval Sent Date |
| Datatype | DATE |
| Nullable | YES |
| Personnel Access System Approval Sent Date Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Personnel Access System Approval Sent Date Security Types |
| Name | Current Value |
| Personnel Access System Approval Sent Date Bound Attachments |
| Name | Current Value |
| Personnel Access System Approval Sent Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Approval Sent Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Personnel Access System Approval Sent Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_APPRV_SENT |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_APPRV_SENT |
NO |
| Personnel Access System Approval Sent Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approval Sent Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approval Sent Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Approval Sent Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Hall Training Indicator |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Experiment Hall Training Indicator |
| Logical Rolename | |
| ColumnName | EXPT_HALL_TRNG_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Experiment Hall Training Indicator Logical Attribute Properties |
| Logical Attribute Name | Experiment Hall Training Indicator |
| Datatype | VARCHAR(1) |
| Nullable | YES |
| Experiment Hall Training Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Experiment Hall Training Indicator 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 |
| Experiment Hall Training Indicator Security Types |
| Name | Current Value |
| Experiment Hall Training Indicator Bound Attachments |
| Name | Current Value |
| Experiment Hall Training Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Experiment Hall Training Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Experiment Hall Training Indicator |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC EXPT_HALL_TRNG_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC EXPT_HALL_TRNG_IND |
NO |
| Experiment Hall Training Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Hall Training Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Hall Training Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Hall Training Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_OK_IND |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | PAS_OK_IND |
| Logical Rolename | |
| ColumnName | PAS_OK_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| PAS_OK_IND Logical Attribute Properties |
| Logical Attribute Name | PAS_OK_IND |
| Datatype | VARCHAR(1) |
| Nullable | YES |
| PAS_OK_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| PAS_OK_IND Security Types |
| Name | Current Value |
| PAS_OK_IND Bound Attachments |
| Name | Current Value |
| PAS_OK_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_OK_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access PAS_OK_IND |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_OK_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_OK_IND |
NO |
| PAS_OK_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_OK_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_OK_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_OK_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UO_ATTEND_IND |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | UO_ATTEND_IND |
| Logical Rolename | |
| ColumnName | UO_ATTEND_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| UO_ATTEND_IND Logical Attribute Properties |
| Logical Attribute Name | UO_ATTEND_IND |
| Datatype | CHAR(1) |
| Nullable | YES |
| UO_ATTEND_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| UO_ATTEND_IND Security Types |
| Name | Current Value |
| UO_ATTEND_IND Bound Attachments |
| Name | Current Value |
| UO_ATTEND_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| UO_ATTEND_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access UO_ATTEND_IND |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC UO_ATTEND_IND |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC UO_ATTEND_IND |
NO |
| UO_ATTEND_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UO_ATTEND_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UO_ATTEND_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UO_ATTEND_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Note |
| Logical Rolename | |
| ColumnName | NOTE |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Note Logical Attribute Properties |
| Logical Attribute Name | Note |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Note Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Note Security Types |
| Name | Current Value |
| Note Bound Attachments |
| Name | Current Value |
| Note Data Movement Rules |
| Name | Type | Rule Text/Value |
| Note Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Note |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC NOTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC NOTE |
NO |
| Note Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Notes |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Other Notes |
| Logical Rolename | |
| ColumnName | OTHER_NOTES |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Other Notes Logical Attribute Properties |
| Logical Attribute Name | Other Notes |
| Datatype | VARCHAR(1000) |
| Nullable | YES |
| Other Notes Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Other Notes Security Types |
| Name | Current Value |
| Other Notes Bound Attachments |
| Name | Current Value |
| Other Notes Data Movement Rules |
| Name | Type | Rule Text/Value |
| Other Notes Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Other Notes |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC OTHER_NOTES |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC OTHER_NOTES |
NO |
| Other Notes Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Notes Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Notes Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Notes Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_UID |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | MOD_BY_UID |
| Logical Rolename | |
| ColumnName | MOD_BY_UID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| MOD_BY_UID Logical Attribute Properties |
| Logical Attribute Name | MOD_BY_UID |
| Datatype | VARCHAR(64) |
| Nullable | YES |
| MOD_BY_UID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| MOD_BY_UID Security Types |
| Name | Current Value |
| MOD_BY_UID Bound Attachments |
| Name | Current Value |
| MOD_BY_UID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_BY_UID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access MOD_BY_UID |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC MOD_BY_UID |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC MOD_BY_UID |
NO |
| MOD_BY_UID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_UID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_UID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_UID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_DTE |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | MOD_BY_DTE |
| Logical Rolename | |
| ColumnName | MOD_BY_DTE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| MOD_BY_DTE Logical Attribute Properties |
| Logical Attribute Name | MOD_BY_DTE |
| Datatype | DATE |
| Nullable | NO |
| MOD_BY_DTE Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| MOD_BY_DTE Security Types |
| Name | Current Value |
| MOD_BY_DTE Bound Attachments |
| Name | Current Value |
| MOD_BY_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_BY_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access MOD_BY_DTE |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC MOD_BY_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC MOD_BY_DTE |
NO |
| MOD_BY_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access Start Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Personnel Access System Access Start Date |
| Logical Rolename | |
| ColumnName | PAS_ACC_START_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Personnel Access System Access Start Date Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Access Start Date |
| Datatype | DATE |
| Nullable | NO |
| Personnel Access System Access Start Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Personnel Access System Access Start Date Security Types |
| Name | Current Value |
| Personnel Access System Access Start Date Bound Attachments |
| Name | Current Value |
| Personnel Access System Access Start Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Access Start Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Personnel Access System Access Start Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_ACC_START_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_ACC_START_DTE |
NO |
| Personnel Access System Access Start Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access Start Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access Start Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access Start Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access End Date |
| Base Entity | Nonvalidated Proposal Team Member Onsite Access |
| Attribute Name | Personnel Access System Access End Date |
| Logical Rolename | |
| ColumnName | PAS_ACC_END_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Personnel Access System Access End Date Logical Attribute Properties |
| Logical Attribute Name | Personnel Access System Access End Date |
| Datatype | DATE |
| Nullable | NO |
| Personnel Access System Access End Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Personnel Access System Access End Date Security Types |
| Name | Current Value |
| Personnel Access System Access End Date Bound Attachments |
| Name | Current Value |
| Personnel Access System Access End Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Personnel Access System Access End Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Nonvalidated Proposal Team Member Onsite Access Personnel Access System Access End Date |
NO | ||
| IPTSv5 (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_ACC_END_DTE |
NO | ||
| PRPSL (Oracle) NONVAL_PRPSL_TM_ONSITE_ACC PAS_ACC_END_DTE |
NO |
| Personnel Access System Access End Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access End Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access End Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Personnel Access System Access End Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |