| Proposal Identifier |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Proposal Identifier |
| Logical Rolename | |
| ColumnName | PRPSL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Proposal Identifier Logical Attribute Properties |
| Logical Attribute Name | Proposal Identifier |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| Proposal Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Proposal Identifier Security Types |
| Name | Current Value |
| Proposal Identifier Bound Attachments |
| Name | Current Value |
| Proposal Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proposal Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Proposal Identifier |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ PRPSL_ID |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ PRPSL_ID |
NO |
| Proposal Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Submission Number |
| Logical Rolename | |
| ColumnName | SUBMISS_NBR |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Submission Number Logical Attribute Properties |
| Logical Attribute Name | Submission Number |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Submission Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Submission Number Security Types |
| Name | Current Value |
| Submission Number Bound Attachments |
| Name | Current Value |
| Submission Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Submission Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Submission Number |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ SUBMISS_NBR |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ SUBMISS_NBR |
NO |
| Submission Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYP_USAGE_IND |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | TYP_USAGE_IND |
| Logical Rolename | |
| ColumnName | TYP_USAGE_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| TYP_USAGE_IND Logical Attribute Properties |
| Logical Attribute Name | TYP_USAGE_IND |
| Datatype | CHAR(1) |
| Nullable | YES |
| TYP_USAGE_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'N' | ||
| Bound Default |
| TYP_USAGE_IND Security Types |
| Name | Current Value |
| TYP_USAGE_IND Bound Attachments |
| Name | Current Value |
| TYP_USAGE_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| TYP_USAGE_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request TYP_USAGE_IND |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ TYP_USAGE_IND |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ TYP_USAGE_IND |
NO |
| TYP_USAGE_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYP_USAGE_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYP_USAGE_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYP_USAGE_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_USAGE_IND |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | SPEC_USAGE_IND |
| Logical Rolename | |
| ColumnName | SPEC_USAGE_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| SPEC_USAGE_IND Logical Attribute Properties |
| Logical Attribute Name | SPEC_USAGE_IND |
| Datatype | CHAR(1) |
| Nullable | YES |
| SPEC_USAGE_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'N' | ||
| Bound Default |
| SPEC_USAGE_IND Security Types |
| Name | Current Value |
| SPEC_USAGE_IND Bound Attachments |
| Name | Current Value |
| SPEC_USAGE_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SPEC_USAGE_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request SPEC_USAGE_IND |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ SPEC_USAGE_IND |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ SPEC_USAGE_IND |
NO |
| SPEC_USAGE_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_USAGE_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_USAGE_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_USAGE_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_IND |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | ADV_USAGE_IND |
| Logical Rolename | |
| ColumnName | ADV_USAGE_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ADV_USAGE_IND Logical Attribute Properties |
| Logical Attribute Name | ADV_USAGE_IND |
| Datatype | CHAR(1) |
| Nullable | YES |
| ADV_USAGE_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'N' | ||
| Bound Default |
| ADV_USAGE_IND Security Types |
| Name | Current Value |
| ADV_USAGE_IND Bound Attachments |
| Name | Current Value |
| ADV_USAGE_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| ADV_USAGE_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request ADV_USAGE_IND |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ ADV_USAGE_IND |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ ADV_USAGE_IND |
NO |
| ADV_USAGE_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_NOTES |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | ADV_USAGE_NOTES |
| Logical Rolename | |
| ColumnName | ADV_USAGE_NOTES |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ADV_USAGE_NOTES Logical Attribute Properties |
| Logical Attribute Name | ADV_USAGE_NOTES |
| Datatype | VARCHAR(max) |
| Nullable | YES |
| ADV_USAGE_NOTES Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| ADV_USAGE_NOTES Security Types |
| Name | Current Value |
| ADV_USAGE_NOTES Bound Attachments |
| Name | Current Value |
| ADV_USAGE_NOTES Data Movement Rules |
| Name | Type | Rule Text/Value |
| ADV_USAGE_NOTES Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request ADV_USAGE_NOTES |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ ADV_USAGE_NOTES |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ ADV_USAGE_NOTES |
NO |
| ADV_USAGE_NOTES Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_NOTES Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_NOTES Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADV_USAGE_NOTES Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_NOTES |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | ACT_NOTES |
| Logical Rolename | |
| ColumnName | ACT_NOTES |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ACT_NOTES Logical Attribute Properties |
| Logical Attribute Name | ACT_NOTES |
| Datatype | VARCHAR(max) |
| Nullable | YES |
| ACT_NOTES Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| ACT_NOTES Security Types |
| Name | Current Value |
| ACT_NOTES Bound Attachments |
| Name | Current Value |
| ACT_NOTES Data Movement Rules |
| Name | Type | Rule Text/Value |
| ACT_NOTES Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request ACT_NOTES |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ ACT_NOTES |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ ACT_NOTES |
NO |
| ACT_NOTES Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_NOTES Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_NOTES Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_NOTES Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Name |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Item Return Name |
| Logical Rolename | |
| ColumnName | ITEM_RET_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Item Return Name Logical Attribute Properties |
| Logical Attribute Name | Item Return Name |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Item Return Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Item Return Name Security Types |
| Name | Current Value |
| Item Return Name Bound Attachments |
| Name | Current Value |
| Item Return Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Item Return Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Item Return Name |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ ITEM_RET_NM |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ ITEM_RET_NM |
NO |
| Item Return Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Address |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Item Return Address |
| Logical Rolename | |
| ColumnName | ITEM_RET_ADDR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Item Return Address Logical Attribute Properties |
| Logical Attribute Name | Item Return Address |
| Datatype | VARCHAR(500) |
| Nullable | YES |
| Item Return Address Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Item Return Address Security Types |
| Name | Current Value |
| Item Return Address Bound Attachments |
| Name | Current Value |
| Item Return Address Data Movement Rules |
| Name | Type | Rule Text/Value |
| Item Return Address Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Item Return Address |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ ITEM_RET_ADDR |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ ITEM_RET_ADDR |
NO |
| Item Return Address Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Address Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Address Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Return Address Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_TEMP_SEN_IND |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | ITEM_TEMP_SEN_IND |
| Logical Rolename | |
| ColumnName | ITEM_TEMP_SEN_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ITEM_TEMP_SEN_IND Logical Attribute Properties |
| Logical Attribute Name | ITEM_TEMP_SEN_IND |
| Datatype | CHAR(1) |
| Nullable | YES |
| ITEM_TEMP_SEN_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'N' | ||
| Bound Default |
| ITEM_TEMP_SEN_IND Security Types |
| Name | Current Value |
| ITEM_TEMP_SEN_IND Bound Attachments |
| Name | Current Value |
| ITEM_TEMP_SEN_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| ITEM_TEMP_SEN_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request ITEM_TEMP_SEN_IND |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ ITEM_TEMP_SEN_IND |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ ITEM_TEMP_SEN_IND |
NO |
| ITEM_TEMP_SEN_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_TEMP_SEN_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_TEMP_SEN_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_TEMP_SEN_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CARR_ID |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | CARR_ID |
| Logical Rolename | |
| ColumnName | CARR_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| CARR_ID Logical Attribute Properties |
| Logical Attribute Name | CARR_ID |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| CARR_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| CARR_ID Security Types |
| Name | Current Value |
| CARR_ID Bound Attachments |
| Name | Current Value |
| CARR_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CARR_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request CARR_ID |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ CARR_ID |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ CARR_ID |
NO |
| CARR_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CARR_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CARR_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CARR_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_RET_SHIP_ACCT_NBR |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | ITEM_RET_SHIP_ACCT_NBR |
| Logical Rolename | |
| ColumnName | ITEM_RET_SHIP_ACCT_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ITEM_RET_SHIP_ACCT_NBR Logical Attribute Properties |
| Logical Attribute Name | ITEM_RET_SHIP_ACCT_NBR |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| ITEM_RET_SHIP_ACCT_NBR Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| ITEM_RET_SHIP_ACCT_NBR Security Types |
| Name | Current Value |
| ITEM_RET_SHIP_ACCT_NBR Bound Attachments |
| Name | Current Value |
| ITEM_RET_SHIP_ACCT_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| ITEM_RET_SHIP_ACCT_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request ITEM_RET_SHIP_ACCT_NBR |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ ITEM_RET_SHIP_ACCT_NBR |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ ITEM_RET_SHIP_ACCT_NBR |
NO |
| ITEM_RET_SHIP_ACCT_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_RET_SHIP_ACCT_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_RET_SHIP_ACCT_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_RET_SHIP_ACCT_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_NEED_NOTES |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | LOCAL_NEED_NOTES |
| Logical Rolename | |
| ColumnName | LOCAL_NEED_NOTES |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| LOCAL_NEED_NOTES Logical Attribute Properties |
| Logical Attribute Name | LOCAL_NEED_NOTES |
| Datatype | VARCHAR(max) |
| Nullable | YES |
| LOCAL_NEED_NOTES Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| LOCAL_NEED_NOTES Security Types |
| Name | Current Value |
| LOCAL_NEED_NOTES Bound Attachments |
| Name | Current Value |
| LOCAL_NEED_NOTES Data Movement Rules |
| Name | Type | Rule Text/Value |
| LOCAL_NEED_NOTES Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request LOCAL_NEED_NOTES |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ LOCAL_NEED_NOTES |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ LOCAL_NEED_NOTES |
NO |
| LOCAL_NEED_NOTES Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_NEED_NOTES Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_NEED_NOTES Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_NEED_NOTES Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Usage Indicator |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Usage Indicator |
| Logical Rolename | |
| ColumnName | USAGE_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Usage Indicator Logical Attribute Properties |
| Logical Attribute Name | Usage Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Usage Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Usage 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 |
| Usage Indicator Security Types |
| Name | Current Value |
| Usage Indicator Bound Attachments |
| Name | Current Value |
| Usage Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Usage Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Usage Indicator |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ USAGE_IND |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ USAGE_IND |
NO |
| Usage Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Usage Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Usage Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Usage Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days Before Beamtime |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Days Before Beamtime |
| Logical Rolename | |
| ColumnName | DAYS_BEFORE_BEAM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Days Before Beamtime Logical Attribute Properties |
| Logical Attribute Name | Days Before Beamtime |
| Datatype | NUMERIC(2, 0) |
| Nullable | NO |
| Days Before Beamtime Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 0 | ||
| Bound Default |
| Days Before Beamtime Security Types |
| Name | Current Value |
| Days Before Beamtime Bound Attachments |
| Name | Current Value |
| Days Before Beamtime Data Movement Rules |
| Name | Type | Rule Text/Value |
| Days Before Beamtime Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Days Before Beamtime |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ DAYS_BEFORE_BEAM |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ DAYS_BEFORE_BEAM |
NO |
| Days Before Beamtime Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days Before Beamtime Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days Before Beamtime Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days Before Beamtime Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days After Beamtime |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Days After Beamtime |
| Logical Rolename | |
| ColumnName | DAYS_AFTER_BEAM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Days After Beamtime Logical Attribute Properties |
| Logical Attribute Name | Days After Beamtime |
| Datatype | NUMERIC(2, 0) |
| Nullable | NO |
| Days After Beamtime Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 0 | ||
| Bound Default |
| Days After Beamtime Security Types |
| Name | Current Value |
| Days After Beamtime Bound Attachments |
| Name | Current Value |
| Days After Beamtime Data Movement Rules |
| Name | Type | Rule Text/Value |
| Days After Beamtime Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Days After Beamtime |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ DAYS_AFTER_BEAM |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ DAYS_AFTER_BEAM |
NO |
| Days After Beamtime Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days After Beamtime Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days After Beamtime Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Days After Beamtime Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Off-site Equipment |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Off-site Equipment |
| Logical Rolename | |
| ColumnName | OFFSITE_EQUIP |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Off-site Equipment Logical Attribute Properties |
| Logical Attribute Name | Off-site Equipment |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Off-site Equipment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Off-site Equipment Security Types |
| Name | Current Value |
| Off-site Equipment Bound Attachments |
| Name | Current Value |
| Off-site Equipment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Off-site Equipment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Off-site Equipment |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ OFFSITE_EQUIP |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ OFFSITE_EQUIP |
NO |
| Off-site Equipment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Off-site Equipment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Off-site Equipment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Off-site Equipment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Level Identifier |
| Base Entity | Proposal Laboratory Request |
| Attribute Name | Work Level Identifier |
| Logical Rolename | |
| ColumnName | WORK_LVL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Work Level Identifier Logical Attribute Properties |
| Logical Attribute Name | Work Level Identifier |
| Datatype | VARCHAR(2) |
| Nullable | YES |
| Work Level Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Work Level Identifier Security Types |
| Name | Current Value |
| Work Level Identifier Bound Attachments |
| Name | Current Value |
| Work Level Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Work Level Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Laboratory Request Work Level Identifier |
NO | ||
| IPTSv5 (Oracle) PRPSL_LAB_REQ WORK_LVL_ID |
NO | ||
| PRPSL (Oracle) PRPSL_LAB_REQ WORK_LVL_ID |
NO |
| Work Level Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Level Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Level Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Work Level Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |