| PERSON_ID |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Person Identifier |
| ColumnName | PERSON_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
| Note |
| PERSON_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PERSON_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| PERSON_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PERSON_ID Security Types |
| Name | Current Value |
| PERSON_ID Bound Attachments |
| Name | Current Value |
| PERSON_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PERSON_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical 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_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERSON_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERSON_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PERSON_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Status Identifer |
| ColumnName | STAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| STAT_ID Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| STAT_ID Domain Restrictions |
| CheckConstraint | stat_id IN ('N','I','V') |
| Check Constraint Name | CK_PTOA_STAT_ID |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STAT_ID Security Types |
| Name | Current Value |
| STAT_ID Bound Attachments |
| Name | Current Value |
| STAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| STAT_ID 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 |
| STAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APP_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Approved Indicator |
| ColumnName | PAS_APP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_APP_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_APP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PAS_APP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS_APP_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| PAS_APP_IND Security Types |
| Name | Current Value |
| PAS_APP_IND Bound Attachments |
| Name | Current Value |
| PAS_APP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_APP_IND 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 |
| PAS_APP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SITE_ACC_TRAIN_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Site Access Training Indictor |
| ColumnName | SITE_ACC_TRAIN_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| SITE_ACC_TRAIN_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SITE_ACC_TRAIN_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SITE_ACC_TRAIN_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SITE_ACC_TRAIN_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| SITE_ACC_TRAIN_IND Security Types |
| Name | Current Value |
| SITE_ACC_TRAIN_IND Bound Attachments |
| Name | Current Value |
| SITE_ACC_TRAIN_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SITE_ACC_TRAIN_IND 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_ACC_TRAIN_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SITE_ACC_TRAIN_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SITE_ACC_TRAIN_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SITE_ACC_TRAIN_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_PRE_APP_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | SNS Pre Approval Indicator |
| ColumnName | SNS_PRE_APP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| SNS_PRE_APP_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNS_PRE_APP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SNS_PRE_APP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNS_PRE_APP_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| SNS_PRE_APP_IND Security Types |
| Name | Current Value |
| SNS_PRE_APP_IND Bound Attachments |
| Name | Current Value |
| SNS_PRE_APP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNS_PRE_APP_IND 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_APP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_PRE_APP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_PRE_APP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_PRE_APP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_TGT_ACC_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | SNS Target Access Indicator |
| ColumnName | SNS_TGT_ACC_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| SNS_TGT_ACC_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNS_TGT_ACC_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SNS_TGT_ACC_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNS_TGT_ACC_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| SNS_TGT_ACC_IND Security Types |
| Name | Current Value |
| SNS_TGT_ACC_IND Bound Attachments |
| Name | Current Value |
| SNS_TGT_ACC_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNS_TGT_ACC_IND 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_TGT_ACC_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_TGT_ACC_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_TGT_ACC_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNS_TGT_ACC_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR_GEN_USER_ACC_TRAIN_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | HFIR General User Access Training Indicator |
| ColumnName | HFIR_GEN_USER_ACC_TRAIN_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| HFIR_GEN_USER_ACC_TRAIN_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HFIR_GEN_USER_ACC_TRAIN_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| HFIR_GEN_USER_ACC_TRAIN_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HFIR_GEN_USER_ACC_TRAIN_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| HFIR_GEN_USER_ACC_TRAIN_IND Security Types |
| Name | Current Value |
| HFIR_GEN_USER_ACC_TRAIN_IND Bound Attachments |
| Name | Current Value |
| HFIR_GEN_USER_ACC_TRAIN_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| HFIR_GEN_USER_ACC_TRAIN_IND 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_GEN_USER_ACC_TRAIN_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR_GEN_USER_ACC_TRAIN_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR_GEN_USER_ACC_TRAIN_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HFIR_GEN_USER_ACC_TRAIN_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_WORK_TRAIN_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Radiation Worker Training Indicator |
| ColumnName | RAD_WORK_TRAIN_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| RAD_WORK_TRAIN_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_WORK_TRAIN_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| RAD_WORK_TRAIN_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_WORK_TRAIN_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| RAD_WORK_TRAIN_IND Security Types |
| Name | Current Value |
| RAD_WORK_TRAIN_IND Bound Attachments |
| Name | Current Value |
| RAD_WORK_TRAIN_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_WORK_TRAIN_IND 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 |
| RAD_WORK_TRAIN_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_WORK_TRAIN_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_WORK_TRAIN_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_WORK_TRAIN_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PFE_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Practical Factors Date |
| ColumnName | PFE_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| PFE_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PFE_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| PFE_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PFE_DTE Security Types |
| Name | Current Value |
| PFE_DTE Bound Attachments |
| Name | Current Value |
| PFE_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PFE_DTE 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 |
| PFE_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PFE_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PFE_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PFE_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACC_DTE_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Access Date Indicator |
| ColumnName | ACC_DTE_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| ACC_DTE_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACC_DTE_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| ACC_DTE_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ACC_DTE_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| ACC_DTE_IND Security Types |
| Name | Current Value |
| ACC_DTE_IND Bound Attachments |
| Name | Current Value |
| ACC_DTE_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| ACC_DTE_IND 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 |
| ACC_DTE_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACC_DTE_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACC_DTE_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACC_DTE_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOSIMETRY_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Dosimetry Indicator |
| ColumnName | DOSIMETRY_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| DOSIMETRY_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DOSIMETRY_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| DOSIMETRY_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DOSIMETRY_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| DOSIMETRY_IND Security Types |
| Name | Current Value |
| DOSIMETRY_IND Bound Attachments |
| Name | Current Value |
| DOSIMETRY_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOSIMETRY_IND 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_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOSIMETRY_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOSIMETRY_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOSIMETRY_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHYS_CARD_NBR |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | PHYS_CARD_NBR |
| ColumnName | PHYS_CARD_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PHYS_CARD_NBR Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PHYS_CARD_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| 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 |
| INSTR_ACC_BEGIN_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Instrument Access Begin Date |
| ColumnName | INSTR_ACC_BEGIN_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| INSTR_ACC_BEGIN_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INSTR_ACC_BEGIN_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| INSTR_ACC_BEGIN_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INSTR_ACC_BEGIN_DTE Security Types |
| Name | Current Value |
| INSTR_ACC_BEGIN_DTE Bound Attachments |
| Name | Current Value |
| INSTR_ACC_BEGIN_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| INSTR_ACC_BEGIN_DTE 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 |
| INSTR_ACC_BEGIN_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_ACC_BEGIN_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_ACC_BEGIN_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_ACC_BEGIN_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_ACC_END_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Instrument Access End Date |
| ColumnName | INSTR_ACC_END_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| INSTR_ACC_END_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INSTR_ACC_END_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| INSTR_ACC_END_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INSTR_ACC_END_DTE Security Types |
| Name | Current Value |
| INSTR_ACC_END_DTE Bound Attachments |
| Name | Current Value |
| INSTR_ACC_END_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| INSTR_ACC_END_DTE 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 |
| INSTR_ACC_END_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_ACC_END_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_ACC_END_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_ACC_END_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BN |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | PAS Badge Number |
| ColumnName | PAS_BN |
| Logical Rolename | |
| RoleName | |
| Domain | Badge Number |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| PAS_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS_BN Security Types |
| Name | Current Value |
| PAS_BN Bound Attachments |
| Name | Current Value |
| PAS_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_BN 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_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TGT_BLDG_ORIENT_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Target Building Orientation Indicator |
| ColumnName | TGT_BLDG_ORIENT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| TGT_BLDG_ORIENT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TGT_BLDG_ORIENT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| TGT_BLDG_ORIENT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TGT_BLDG_ORIENT_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| TGT_BLDG_ORIENT_IND Security Types |
| Name | Current Value |
| TGT_BLDG_ORIENT_IND Bound Attachments |
| Name | Current Value |
| TGT_BLDG_ORIENT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| TGT_BLDG_ORIENT_IND 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 |
| TGT_BLDG_ORIENT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TGT_BLDG_ORIENT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TGT_BLDG_ORIENT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TGT_BLDG_ORIENT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACCESS_EMAIL_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Access Email Date |
| ColumnName | ACCESS_EMAIL_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| ACCESS_EMAIL_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACCESS_EMAIL_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| ACCESS_EMAIL_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ACCESS_EMAIL_DTE Security Types |
| Name | Current Value |
| ACCESS_EMAIL_DTE Bound Attachments |
| Name | Current Value |
| ACCESS_EMAIL_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| ACCESS_EMAIL_DTE 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_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACCESS_EMAIL_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACCESS_EMAIL_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACCESS_EMAIL_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_EMAIL_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Host Email Date |
| ColumnName | HOST_EMAIL_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| HOST_EMAIL_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HOST_EMAIL_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| HOST_EMAIL_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HOST_EMAIL_DTE Security Types |
| Name | Current Value |
| HOST_EMAIL_DTE Bound Attachments |
| Name | Current Value |
| HOST_EMAIL_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| HOST_EMAIL_DTE 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_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_EMAIL_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_EMAIL_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_EMAIL_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_BN |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Host Badge Number |
| ColumnName | HOST_BN |
| Logical Rolename | |
| RoleName | |
| Domain | Badge Number |
| Physical Only | NO |
| Definition | |
| Note |
| HOST_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HOST_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| HOST_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HOST_BN Security Types |
| Name | Current Value |
| HOST_BN Bound Attachments |
| Name | Current Value |
| HOST_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| HOST_BN 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_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOST_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INPUT_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Input Date |
| ColumnName | PAS_INPUT_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_INPUT_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_INPUT_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| PAS_INPUT_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS_INPUT_DTE Security Types |
| Name | Current Value |
| PAS_INPUT_DTE Bound Attachments |
| Name | Current Value |
| PAS_INPUT_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_INPUT_DTE 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 |
| PAS_INPUT_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INPUT_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INPUT_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INPUT_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRAIN_EMAIL_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Training Email Sent Date |
| ColumnName | TRAIN_EMAIL_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| TRAIN_EMAIL_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TRAIN_EMAIL_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| TRAIN_EMAIL_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TRAIN_EMAIL_DTE Security Types |
| Name | Current Value |
| TRAIN_EMAIL_DTE Bound Attachments |
| Name | Current Value |
| TRAIN_EMAIL_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| TRAIN_EMAIL_DTE 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 |
| TRAIN_EMAIL_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRAIN_EMAIL_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRAIN_EMAIL_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRAIN_EMAIL_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVITE_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Invitation Date |
| ColumnName | PAS_INVITE_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_INVITE_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_INVITE_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| PAS_INVITE_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS_INVITE_DTE Security Types |
| Name | Current Value |
| PAS_INVITE_DTE Bound Attachments |
| Name | Current Value |
| PAS_INVITE_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_INVITE_DTE 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 |
| PAS_INVITE_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVITE_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVITE_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVITE_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BLDG_ACCESS_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Building Access Indicator |
| ColumnName | PAS_BLDG_ACCESS_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_BLDG_ACCESS_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_BLDG_ACCESS_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PAS_BLDG_ACCESS_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| PAS_BLDG_ACCESS_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| PAS_BLDG_ACCESS_IND Security Types |
| Name | Current Value |
| PAS_BLDG_ACCESS_IND Bound Attachments |
| Name | Current Value |
| PAS_BLDG_ACCESS_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_BLDG_ACCESS_IND 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 |
| PAS_BLDG_ACCESS_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BLDG_ACCESS_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BLDG_ACCESS_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_BLDG_ACCESS_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVIT_ID |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Invitiation Identifier |
| ColumnName | PAS_INVIT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_INVIT_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_INVIT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| PAS_INVIT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS_INVIT_ID Security Types |
| Name | Current Value |
| PAS_INVIT_ID Bound Attachments |
| Name | Current Value |
| PAS_INVIT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_INVIT_ID 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 |
| PAS_INVIT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVIT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVIT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_INVIT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APPRV_SENT |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Sent |
| ColumnName | PAS_APPRV_SENT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_APPRV_SENT Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_APPRV_SENT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| PAS_APPRV_SENT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PAS_APPRV_SENT Security Types |
| Name | Current Value |
| PAS_APPRV_SENT Bound Attachments |
| Name | Current Value |
| PAS_APPRV_SENT Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_APPRV_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 |
| PAS_APPRV_SENT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APPRV_SENT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APPRV_SENT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_APPRV_SENT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_HALL_TRNG_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Experiment Hall Training Indicator |
| ColumnName | EXPT_HALL_TRNG_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| EXPT_HALL_TRNG_IND Column Properties |
| Datatype | VARCHAR2(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EXPT_HALL_TRNG_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| EXPT_HALL_TRNG_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EXPT_HALL_TRNG_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| EXPT_HALL_TRNG_IND Security Types |
| Name | Current Value |
| EXPT_HALL_TRNG_IND Bound Attachments |
| Name | Current Value |
| EXPT_HALL_TRNG_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| EXPT_HALL_TRNG_IND 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 |
| EXPT_HALL_TRNG_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_HALL_TRNG_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_HALL_TRNG_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_HALL_TRNG_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_OK_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personell Access System OK Indicator |
| ColumnName | PAS_OK_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| PAS_OK_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_OK_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PAS_OK_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| PAS_OK_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| 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 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 |
| 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 Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | User Office Attending Indicator |
| ColumnName | UO_ATTEND_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| UO_ATTEND_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| UO_ATTEND_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| UO_ATTEND_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| UO_ATTEND_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| 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 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 |
| 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 |
| PAS_ACC_START_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Access Start Date |
| ColumnName | PAS_ACC_START_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| PAS_ACC_START_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_ACC_START_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| PAS_ACC_START_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| PAS_ACC_START_DTE Security Types |
| Name | Current Value |
| PAS_ACC_START_DTE Bound Attachments |
| Name | Current Value |
| PAS_ACC_START_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_ACC_START_DTE 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 |
| PAS_ACC_START_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_ACC_START_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_ACC_START_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_ACC_START_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_ACC_END_DTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Personnel Access System Access End Date |
| ColumnName | PAS_ACC_END_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| PAS_ACC_END_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PAS_ACC_END_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| PAS_ACC_END_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| PAS_ACC_END_DTE Security Types |
| Name | Current Value |
| PAS_ACC_END_DTE Bound Attachments |
| Name | Current Value |
| PAS_ACC_END_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PAS_ACC_END_DTE 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 |
| PAS_ACC_END_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_ACC_END_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_ACC_END_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PAS_ACC_END_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Note |
| ColumnName | NOTE |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| NOTE Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NOTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| 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 Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Other Notes |
| ColumnName | OTHER_NOTES |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| OTHER_NOTES Column Properties |
| Datatype | VARCHAR2(1000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OTHER_NOTES Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1000 |
| Percent Null | 0 |
| 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_CHK_IND |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | User Checked In Indicator |
| ColumnName | USER_CHK_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| USER_CHK_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USER_CHK_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| USER_CHK_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| USER_CHK_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| USER_CHK_IND Security Types |
| Name | Current Value |
| USER_CHK_IND Bound Attachments |
| Name | Current Value |
| USER_CHK_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| USER_CHK_IND 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_CHK_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_CHK_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_CHK_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_CHK_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_UID |
| Base Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Modified By User Identifer |
| ColumnName | MOD_BY_UID |
| Logical Rolename | |
| RoleName | |
| Domain | Userid |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_BY_UID Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_BY_UID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| 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 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 |
| 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 Object | PRPSL_TM_ONSITE_ACC |
| Attribute Name | Modified Date |
| ColumnName | MOD_BY_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| MOD_BY_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_BY_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| MOD_BY_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| 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 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 |
| 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 |