Person Identifier |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Person Identifier |
Logical Rolename | |
ColumnName | PERSON_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
Note |
Person Identifier Logical Attribute Properties |
Logical Attribute Name | Person Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Person Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Person Identifier Security Types |
Name | Current Value |
Person Identifier Bound Attachments |
Name | Current Value |
Person Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Person Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Person Identifier |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PERSON_ID |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC PERSON_ID |
NO |
Person Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Person Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Person Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Person Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifer |
Base Entity | 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_PTOA_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 Proposal Team Member Onsite Access Status Identifer |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC STAT_ID |
NO | ||
PRPSL (Oracle) 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 Indicator |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Personnel Access System Approved Indicator |
Logical Rolename | |
ColumnName | PAS_APP_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Personnel Access System Approved Indicator Logical Attribute Properties |
Logical Attribute Name | Personnel Access System Approved Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Personnel Access System Approved Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Personnel Access System Approved 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 |
Personnel Access System Approved Indicator Security Types |
Name | Current Value |
Personnel Access System Approved Indicator Bound Attachments |
Name | Current Value |
Personnel Access System Approved Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Personnel Access System Approved Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Personnel Access System Approved Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_APP_IND |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC PAS_APP_IND |
NO |
Personnel Access System Approved Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Approved Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Approved Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Approved Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Site Access Training Indictor |
Base Entity | 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 Proposal Team Member Onsite Access Site Access Training Indictor |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC SITE_ACC_TRAIN_IND |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access SNS Pre Approval Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC SNS_PRE_APP_IND |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access SNS Target Access Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC SNS_TGT_ACC_IND |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access HFIR General User Access Training Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC HFIR_GEN_USER_ACC_TRAIN_IND |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access Radiation Worker Training Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC RAD_WORK_TRAIN_IND |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access Practical Factors Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PFE_DTE |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access Access Date Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC ACC_DTE_IND |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access Dosimetry Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC DOSIMETRY_IND |
NO | ||
PRPSL (Oracle) 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 |
PHYS_CARD_NBR |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | PHYS_CARD_NBR |
Logical Rolename | |
ColumnName | PHYS_CARD_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
PHYS_CARD_NBR Logical Attribute Properties |
Logical Attribute Name | PHYS_CARD_NBR |
Datatype | NUMERIC(38, 0) |
Nullable | YES |
PHYS_CARD_NBR Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
PHYS_CARD_NBR Security Types |
Name | Current Value |
PHYS_CARD_NBR Bound Attachments |
Name | Current Value |
PHYS_CARD_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
PHYS_CARD_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access PHYS_CARD_NBR |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PHYS_CARD_NBR |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC PHYS_CARD_NBR |
NO |
PHYS_CARD_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PHYS_CARD_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PHYS_CARD_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PHYS_CARD_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access Begin Date |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Instrument Access Begin Date |
Logical Rolename | |
ColumnName | INSTR_ACC_BEGIN_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | |
Note |
Instrument Access Begin Date Logical Attribute Properties |
Logical Attribute Name | Instrument Access Begin Date |
Datatype | DATE |
Nullable | YES |
Instrument Access Begin Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Instrument Access Begin Date Security Types |
Name | Current Value |
Instrument Access Begin Date Bound Attachments |
Name | Current Value |
Instrument Access Begin Date Data Movement Rules |
Name | Type | Rule Text/Value |
Instrument Access Begin Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Instrument Access Begin Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC INSTR_ACC_BEGIN_DTE |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC INSTR_ACC_BEGIN_DTE |
NO |
Instrument Access Begin Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access Begin Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access Begin Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access Begin Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access End Date |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Instrument Access End Date |
Logical Rolename | |
ColumnName | INSTR_ACC_END_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | |
Note |
Instrument Access End Date Logical Attribute Properties |
Logical Attribute Name | Instrument Access End Date |
Datatype | DATE |
Nullable | YES |
Instrument Access End Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Instrument Access End Date Security Types |
Name | Current Value |
Instrument Access End Date Bound Attachments |
Name | Current Value |
Instrument Access End Date Data Movement Rules |
Name | Type | Rule Text/Value |
Instrument Access End Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Instrument Access End Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC INSTR_ACC_END_DTE |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC INSTR_ACC_END_DTE |
NO |
Instrument Access End Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access End Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access End Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Access End Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAS Badge Number |
Base Entity | 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 Proposal Team Member Onsite Access PAS Badge Number |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_BN |
NO | ||
PRPSL (Oracle) 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 |
Target Building Orientation Indicator |
Base Entity | 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 Proposal Team Member Onsite Access Target Building Orientation Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC TGT_BLDG_ORIENT_IND |
NO | ||
PRPSL (Oracle) 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 |
Access Email Date |
Base Entity | 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 Proposal Team Member Onsite Access Access Email Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC ACCESS_EMAIL_DTE |
NO | ||
PRPSL (Oracle) 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 |
Host Email Date |
Base Entity | 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 Proposal Team Member Onsite Access Host Email Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC HOST_EMAIL_DTE |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access Host Badge Number |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC HOST_BN |
NO | ||
PRPSL (Oracle) 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 Input Date |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Personnel Access System Input Date |
Logical Rolename | |
ColumnName | PAS_INPUT_DTE |
RoleName | |
Domain | Date |
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 Proposal Team Member Onsite Access Personnel Access System Input Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_INPUT_DTE |
NO | ||
PRPSL (Oracle) 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 Sent Date |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Training Email Sent Date |
Logical Rolename | |
ColumnName | TRAIN_EMAIL_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | |
Note |
Training Email Sent Date Logical Attribute Properties |
Logical Attribute Name | Training Email Sent Date |
Datatype | DATE |
Nullable | YES |
Training Email Sent Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Training Email Sent Date Security Types |
Name | Current Value |
Training Email Sent Date Bound Attachments |
Name | Current Value |
Training Email Sent Date Data Movement Rules |
Name | Type | Rule Text/Value |
Training Email Sent Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Training Email Sent Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC TRAIN_EMAIL_DTE |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC TRAIN_EMAIL_DTE |
NO |
Training Email Sent Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Training Email Sent Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Training Email Sent Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Training Email Sent Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Invitation Date |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Personnel Access System Invitation Date |
Logical Rolename | |
ColumnName | PAS_INVITE_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | |
Note |
Personnel Access System Invitation Date Logical Attribute Properties |
Logical Attribute Name | Personnel Access System Invitation Date |
Datatype | DATE |
Nullable | YES |
Personnel Access System Invitation Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Personnel Access System Invitation Date Security Types |
Name | Current Value |
Personnel Access System Invitation Date Bound Attachments |
Name | Current Value |
Personnel Access System Invitation Date Data Movement Rules |
Name | Type | Rule Text/Value |
Personnel Access System Invitation Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Personnel Access System Invitation Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_INVITE_DTE |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC PAS_INVITE_DTE |
NO |
Personnel Access System Invitation Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Invitation Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Invitation Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Invitation Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Building Access Indicator |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Personnel Access System Building Access Indicator |
Logical Rolename | |
ColumnName | PAS_BLDG_ACCESS_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Personnel Access System Building Access Indicator Logical Attribute Properties |
Logical Attribute Name | Personnel Access System Building Access Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Personnel Access System Building Access Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Personnel Access System 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 |
Personnel Access System Building Access Indicator Security Types |
Name | Current Value |
Personnel Access System Building Access Indicator Bound Attachments |
Name | Current Value |
Personnel Access System Building Access Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Personnel Access System Building Access Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Personnel Access System Building Access Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_BLDG_ACCESS_IND |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC PAS_BLDG_ACCESS_IND |
NO |
Personnel Access System Building Access Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Building Access Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Building Access Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Building Access Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Invitiation Identifier |
Base Entity | 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 Proposal Team Member Onsite Access Personnel Access System Invitiation Identifier |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_INVIT_ID |
NO | ||
PRPSL (Oracle) 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 Sent |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Personnel Access System Sent |
Logical Rolename | |
ColumnName | PAS_APPRV_SENT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Personnel Access System Sent Logical Attribute Properties |
Logical Attribute Name | Personnel Access System Sent |
Datatype | DATE |
Nullable | YES |
Personnel Access System Sent Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Personnel Access System Sent Security Types |
Name | Current Value |
Personnel Access System Sent Bound Attachments |
Name | Current Value |
Personnel Access System Sent Data Movement Rules |
Name | Type | Rule Text/Value |
Personnel Access System Sent Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Personnel Access System Sent |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_APPRV_SENT |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC PAS_APPRV_SENT |
NO |
Personnel Access System Sent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Sent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Sent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Sent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Experiment Hall Training Indicator |
Base Entity | 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 Proposal Team Member Onsite Access Experiment Hall Training Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC EXPT_HALL_TRNG_IND |
NO | ||
PRPSL (Oracle) 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 |
Personell Access System OK Indicator |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Personell Access System OK Indicator |
Logical Rolename | |
ColumnName | PAS_OK_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Personell Access System OK Indicator Logical Attribute Properties |
Logical Attribute Name | Personell Access System OK Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Personell Access System OK Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Personell Access System OK 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 |
Personell Access System OK Indicator Security Types |
Name | Current Value |
Personell Access System OK Indicator Bound Attachments |
Name | Current Value |
Personell Access System OK Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Personell Access System OK Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Personell Access System OK Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_OK_IND |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC PAS_OK_IND |
NO |
Personell Access System OK Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personell Access System OK Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Personell Access System OK Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personell Access System OK Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Office Attending Indicator |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | User Office Attending Indicator |
Logical Rolename | |
ColumnName | UO_ATTEND_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
User Office Attending Indicator Logical Attribute Properties |
Logical Attribute Name | User Office Attending Indicator |
Datatype | CHAR(1) |
Nullable | NO |
User Office Attending Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
User Office Attending 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 |
User Office Attending Indicator Security Types |
Name | Current Value |
User Office Attending Indicator Bound Attachments |
Name | Current Value |
User Office Attending Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
User Office Attending Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access User Office Attending Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC UO_ATTEND_IND |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC UO_ATTEND_IND |
NO |
User Office Attending Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Office Attending Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Office Attending Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Office Attending Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Personnel Access System Access Start Date |
Base Entity | 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 | YES |
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 Proposal Team Member Onsite Access Personnel Access System Access Start Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_ACC_START_DTE |
NO | ||
PRPSL (Oracle) 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 | 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 | YES |
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 Proposal Team Member Onsite Access Personnel Access System Access End Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC PAS_ACC_END_DTE |
NO | ||
PRPSL (Oracle) 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 |
Note |
Base Entity | 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 Proposal Team Member Onsite Access Note |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC NOTE |
NO | ||
PRPSL (Oracle) 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 | 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 Proposal Team Member Onsite Access Other Notes |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC OTHER_NOTES |
NO | ||
PRPSL (Oracle) 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 |
User Checked In Indicator |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | User Checked In Indicator |
Logical Rolename | |
ColumnName | USER_CHK_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
User Checked In Indicator Logical Attribute Properties |
Logical Attribute Name | User Checked In Indicator |
Datatype | CHAR(1) |
Nullable | NO |
User Checked In Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
User Checked In 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 |
User Checked In Indicator Security Types |
Name | Current Value |
User Checked In Indicator Bound Attachments |
Name | Current Value |
User Checked In Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
User Checked In Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access User Checked In Indicator |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC USER_CHK_IND |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC USER_CHK_IND |
NO |
User Checked In Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Checked In Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Checked In Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Checked In Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By User Identifer |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Modified By User Identifer |
Logical Rolename | |
ColumnName | MOD_BY_UID |
RoleName | |
Domain | Userid |
Logical Only | NO |
Definition | |
Note |
Modified By User Identifer Logical Attribute Properties |
Logical Attribute Name | Modified By User Identifer |
Datatype | VARCHAR(64) |
Nullable | NO |
Modified By User Identifer Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Modified By User Identifer Security Types |
Name | Current Value |
Modified By User Identifer Bound Attachments |
Name | Current Value |
Modified By User Identifer Data Movement Rules |
Name | Type | Rule Text/Value |
Modified By User Identifer Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Modified By User Identifer |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC MOD_BY_UID |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC MOD_BY_UID |
NO |
Modified By User Identifer Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By User Identifer Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By User Identifer Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By User Identifer Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modified Date |
Base Entity | Proposal Team Member Onsite Access |
Attribute Name | Modified Date |
Logical Rolename | |
ColumnName | MOD_BY_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Modified Date Logical Attribute Properties |
Logical Attribute Name | Modified Date |
Datatype | DATE |
Nullable | NO |
Modified Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Modified Date Security Types |
Name | Current Value |
Modified Date Bound Attachments |
Name | Current Value |
Modified Date Data Movement Rules |
Name | Type | Rule Text/Value |
Modified Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Team Member Onsite Access Modified Date |
NO | ||
IPTSv5 (Oracle) PRPSL_TM_ONSITE_ACC MOD_BY_DTE |
NO | ||
PRPSL (Oracle) PRPSL_TM_ONSITE_ACC MOD_BY_DTE |
NO |
Modified Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modified Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modified Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modified Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |