PRPSL_ID |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Proposal Identifier |
ColumnName | PRPSL_ID |
Logical Rolename | Proposal Identifier |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PRPSL_ID Column Properties |
Datatype | NUMBER(10, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PRPSL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
PRPSL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PRPSL_ID Security Types |
Name | Current Value |
PRPSL_ID Bound Attachments |
Name | Current Value |
PRPSL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PRPSL_ID 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 |
PRPSL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMISS_NBR |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Submission Number |
ColumnName | SUBMISS_NBR |
Logical Rolename | Submission Number |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
SUBMISS_NBR Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SUBMISS_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SUBMISS_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SUBMISS_NBR Security Types |
Name | Current Value |
SUBMISS_NBR Bound Attachments |
Name | Current Value |
SUBMISS_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
SUBMISS_NBR 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 |
SUBMISS_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMISS_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMISS_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMISS_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TYP_USAGE_IND |
Base Object | PRPSL_LAB_REQ |
Attribute Name | TYP_USAGE_IND |
ColumnName | TYP_USAGE_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TYP_USAGE_IND Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TYP_USAGE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
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 Object | PRPSL_LAB_REQ |
Attribute Name | SPEC_USAGE_IND |
ColumnName | SPEC_USAGE_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SPEC_USAGE_IND Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SPEC_USAGE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
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 Object | PRPSL_LAB_REQ |
Attribute Name | ADV_USAGE_IND |
ColumnName | ADV_USAGE_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ADV_USAGE_IND Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ADV_USAGE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
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 Object | PRPSL_LAB_REQ |
Attribute Name | ADV_USAGE_NOTES |
ColumnName | ADV_USAGE_NOTES |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ADV_USAGE_NOTES Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ADV_USAGE_NOTES Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
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 Object | PRPSL_LAB_REQ |
Attribute Name | ACT_NOTES |
ColumnName | ACT_NOTES |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ACT_NOTES Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ACT_NOTES Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
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_RET_NM |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Item Return Name |
ColumnName | ITEM_RET_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ITEM_RET_NM Column Properties |
Datatype | VARCHAR2(75) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ITEM_RET_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
ITEM_RET_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ITEM_RET_NM Security Types |
Name | Current Value |
ITEM_RET_NM Bound Attachments |
Name | Current Value |
ITEM_RET_NM Data Movement Rules |
Name | Type | Rule Text/Value |
ITEM_RET_NM 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_RET_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_RET_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_RET_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_RET_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_RET_ADDR |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Item Return Address |
ColumnName | ITEM_RET_ADDR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ITEM_RET_ADDR Column Properties |
Datatype | VARCHAR2(500) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ITEM_RET_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 500 |
Percent Null | 0 |
ITEM_RET_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ITEM_RET_ADDR Security Types |
Name | Current Value |
ITEM_RET_ADDR Bound Attachments |
Name | Current Value |
ITEM_RET_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
ITEM_RET_ADDR 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_RET_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_RET_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_RET_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_RET_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ITEM_TEMP_SEN_IND |
Base Object | PRPSL_LAB_REQ |
Attribute Name | ITEM_TEMP_SEN_IND |
ColumnName | ITEM_TEMP_SEN_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ITEM_TEMP_SEN_IND Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ITEM_TEMP_SEN_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
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 Object | PRPSL_LAB_REQ |
Attribute Name | CARR_ID |
ColumnName | CARR_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CARR_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CARR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
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 Object | PRPSL_LAB_REQ |
Attribute Name | ITEM_RET_SHIP_ACCT_NBR |
ColumnName | ITEM_RET_SHIP_ACCT_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ITEM_RET_SHIP_ACCT_NBR Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ITEM_RET_SHIP_ACCT_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
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 Object | PRPSL_LAB_REQ |
Attribute Name | LOCAL_NEED_NOTES |
ColumnName | LOCAL_NEED_NOTES |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
LOCAL_NEED_NOTES Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
LOCAL_NEED_NOTES Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
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_IND |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Usage Indicator |
ColumnName | USAGE_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
USAGE_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
USAGE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
USAGE_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
USAGE_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 |
USAGE_IND Security Types |
Name | Current Value |
USAGE_IND Bound Attachments |
Name | Current Value |
USAGE_IND Data Movement Rules |
Name | Type | Rule Text/Value |
USAGE_IND 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_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
USAGE_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
USAGE_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
USAGE_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_BEFORE_BEAM |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Days Before Beamtime |
ColumnName | DAYS_BEFORE_BEAM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DAYS_BEFORE_BEAM Column Properties |
Datatype | NUMBER(2, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DAYS_BEFORE_BEAM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
DAYS_BEFORE_BEAM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 0 |
Bound Default |
DAYS_BEFORE_BEAM Security Types |
Name | Current Value |
DAYS_BEFORE_BEAM Bound Attachments |
Name | Current Value |
DAYS_BEFORE_BEAM Data Movement Rules |
Name | Type | Rule Text/Value |
DAYS_BEFORE_BEAM 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_BEAM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_BEFORE_BEAM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_BEFORE_BEAM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_BEFORE_BEAM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_AFTER_BEAM |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Days After Beamtime |
ColumnName | DAYS_AFTER_BEAM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DAYS_AFTER_BEAM Column Properties |
Datatype | NUMBER(2, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DAYS_AFTER_BEAM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
DAYS_AFTER_BEAM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 0 |
Bound Default |
DAYS_AFTER_BEAM Security Types |
Name | Current Value |
DAYS_AFTER_BEAM Bound Attachments |
Name | Current Value |
DAYS_AFTER_BEAM Data Movement Rules |
Name | Type | Rule Text/Value |
DAYS_AFTER_BEAM 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_BEAM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_AFTER_BEAM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_AFTER_BEAM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DAYS_AFTER_BEAM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OFFSITE_EQUIP |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Off-site Equipment |
ColumnName | OFFSITE_EQUIP |
Logical Rolename | |
RoleName | |
Domain | Note |
Physical Only | NO |
Definition | |
Note |
OFFSITE_EQUIP Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OFFSITE_EQUIP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
OFFSITE_EQUIP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OFFSITE_EQUIP Security Types |
Name | Current Value |
OFFSITE_EQUIP Bound Attachments |
Name | Current Value |
OFFSITE_EQUIP Data Movement Rules |
Name | Type | Rule Text/Value |
OFFSITE_EQUIP 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 |
OFFSITE_EQUIP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OFFSITE_EQUIP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OFFSITE_EQUIP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OFFSITE_EQUIP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_LVL_ID |
Base Object | PRPSL_LAB_REQ |
Attribute Name | Work Level Identifier |
ColumnName | WORK_LVL_ID |
Logical Rolename | Work Level Identifier |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
WORK_LVL_ID Column Properties |
Datatype | VARCHAR2(2) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
WORK_LVL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
WORK_LVL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WORK_LVL_ID Security Types |
Name | Current Value |
WORK_LVL_ID Bound Attachments |
Name | Current Value |
WORK_LVL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
WORK_LVL_ID 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_LVL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_LVL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_LVL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_LVL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |