PRPSL_ID |
Base Object | PRPSL_LAB_REQ_CHEM_ASSC |
Attribute Name | Proposal Identifier |
ColumnName | PRPSL_ID |
Logical Rolename | Proposal Identifier |
RoleName | PRPSL_ID |
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 Chemical Association Proposal Identifier |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC PRPSL_ID |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC 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_CHEM_ASSC |
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 Chemical Association Submission Number |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC SUBMISS_NBR |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC 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 |
CHEM_NM |
Base Object | PRPSL_LAB_REQ_CHEM_ASSC |
Attribute Name | Chemical Name |
ColumnName | CHEM_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CHEM_NM Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CHEM_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
CHEM_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CHEM_NM Security Types |
Name | Current Value |
CHEM_NM Bound Attachments |
Name | Current Value |
CHEM_NM Data Movement Rules |
Name | Type | Rule Text/Value |
CHEM_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Laboratory Request Chemical Association Chemical Name |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC CHEM_NM |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC CHEM_NM |
NO |
CHEM_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CHEM_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CHEM_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CHEM_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAS_NBR |
Base Object | PRPSL_LAB_REQ_CHEM_ASSC |
Attribute Name | Chemical Abstract Service Number |
ColumnName | CAS_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CAS_NBR Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CAS_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
CAS_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CAS_NBR Security Types |
Name | Current Value |
CAS_NBR Bound Attachments |
Name | Current Value |
CAS_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
CAS_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Laboratory Request Chemical Association Chemical Abstract Service Number |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC CAS_NBR |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC CAS_NBR |
NO |
CAS_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAS_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAS_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAS_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ST_ID |
Base Object | PRPSL_LAB_REQ_CHEM_ASSC |
Attribute Name | ST_ID |
ColumnName | ST_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ST_ID Column Properties |
Datatype | VARCHAR2(6) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ST_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
ST_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ST_ID Security Types |
Name | Current Value |
ST_ID Bound Attachments |
Name | Current Value |
ST_ID Data Movement Rules |
Name | Type | Rule Text/Value |
ST_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Laboratory Request Chemical Association ST_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC ST_ID |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC ST_ID |
NO |
ST_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ST_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ST_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ST_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TOTAL_AMT |
Base Object | PRPSL_LAB_REQ_CHEM_ASSC |
Attribute Name | Total Amount |
ColumnName | TOTAL_AMT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TOTAL_AMT Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TOTAL_AMT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
TOTAL_AMT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TOTAL_AMT Security Types |
Name | Current Value |
TOTAL_AMT Bound Attachments |
Name | Current Value |
TOTAL_AMT Data Movement Rules |
Name | Type | Rule Text/Value |
TOTAL_AMT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Laboratory Request Chemical Association Total Amount |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC TOTAL_AMT |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC TOTAL_AMT |
NO |
TOTAL_AMT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TOTAL_AMT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TOTAL_AMT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TOTAL_AMT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AMT_USED |
Base Object | PRPSL_LAB_REQ_CHEM_ASSC |
Attribute Name | Amount Used |
ColumnName | AMT_USED |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
AMT_USED Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
AMT_USED Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
AMT_USED Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AMT_USED Security Types |
Name | Current Value |
AMT_USED Bound Attachments |
Name | Current Value |
AMT_USED Data Movement Rules |
Name | Type | Rule Text/Value |
AMT_USED Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Laboratory Request Chemical Association Amount Used |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC AMT_USED |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC AMT_USED |
NO |
AMT_USED Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AMT_USED Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AMT_USED Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AMT_USED Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GLOVE_MATL_ID |
Base Object | PRPSL_LAB_REQ_CHEM_ASSC |
Attribute Name | GLOVE_MATL_ID |
ColumnName | GLOVE_MATL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
GLOVE_MATL_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
GLOVE_MATL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
GLOVE_MATL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GLOVE_MATL_ID Security Types |
Name | Current Value |
GLOVE_MATL_ID Bound Attachments |
Name | Current Value |
GLOVE_MATL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
GLOVE_MATL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Laboratory Request Chemical Association GLOVE_MATL_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_LAB_REQ_CHEM_ASSC GLOVE_MATL_ID |
NO | ||
PRPSL (Oracle) PRPSL_LAB_REQ_CHEM_ASSC GLOVE_MATL_ID |
NO |
GLOVE_MATL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GLOVE_MATL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GLOVE_MATL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GLOVE_MATL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |