Proposal Identifier |
Base Entity | Proposal Submission |
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 Submission Proposal Identifier |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS PRPSL_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS PRPSL_ID |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS PRPSL_ID |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS 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 Submission |
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 Submission Submission Number |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SUBMISS_NBR |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SUBMISS_NBR |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SUBMISS_NBR |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS 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 |
Status Identifier |
Base Entity | Proposal Submission |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Status Identifer: Abbreviated idenfifer for the given status. |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Status Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Status Identifier |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS STAT_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS STAT_ID |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS STAT_ID |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS STAT_ID |
NO |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Date |
Base Entity | Proposal Submission |
Attribute Name | Proposal Date |
Logical Rolename | |
ColumnName | PRPSL_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | |
Note |
Proposal Date Logical Attribute Properties |
Logical Attribute Name | Proposal Date |
Datatype | DATE |
Nullable | NO |
Proposal Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Proposal Date Security Types |
Name | Current Value |
Proposal Date Bound Attachments |
Name | Current Value |
Proposal Date Data Movement Rules |
Name | Type | Rule Text/Value |
Proposal Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Proposal Date |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS PRPSL_DTE |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS PRPSL_DTE |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS PRPSL_DTE |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS PRPSL_DTE |
NO |
Proposal Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Human Animal Material Indicator |
Base Entity | Proposal Submission |
Attribute Name | Human Animal Material Indicator |
Logical Rolename | |
ColumnName | HUM_ANI_MAT_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Human Animal Material Indicator Logical Attribute Properties |
Logical Attribute Name | Human Animal Material Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Human Animal Material Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Human Animal Material 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 |
Human Animal Material Indicator Security Types |
Name | Current Value |
Human Animal Material Indicator Bound Attachments |
Name | Current Value |
Human Animal Material Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Human Animal Material Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Human Animal Material Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS HUM_ANI_MAT_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS HUM_ANI_MAT_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS HUM_ANI_MAT_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS HUM_ANI_MAT_IND |
NO |
Human Animal Material Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Human Animal Material Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Human Animal Material Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Human Animal Material Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Hazard Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Hazard Indicator |
Logical Rolename | |
ColumnName | SAF_HAZ_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Hazard Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Hazard Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Safety Hazard Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Safety Hazard 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 |
Safety Hazard Indicator Security Types |
Name | Current Value |
Safety Hazard Indicator Bound Attachments |
Name | Current Value |
Safety Hazard Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Hazard Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Hazard Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SAF_HAZ_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SAF_HAZ_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SAF_HAZ_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SAF_HAZ_IND |
NO |
Safety Hazard Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Hazard Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Hazard Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Hazard Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Biological Hazard Indicator |
Base Entity | Proposal Submission |
Attribute Name | Biological Hazard Indicator |
Logical Rolename | |
ColumnName | BIO_HAZ_IND |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Biological Hazard Indicator Logical Attribute Properties |
Logical Attribute Name | Biological Hazard Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Biological Hazard Indicator Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | 'N' | ||
Bound Default |
Biological Hazard Indicator Security Types |
Name | Current Value |
Biological Hazard Indicator Bound Attachments |
Name | Current Value |
Biological Hazard Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Biological Hazard Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Biological Hazard Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS BIO_HAZ_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS BIO_HAZ_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS BIO_HAZ_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS BIO_HAZ_IND |
NO |
Biological Hazard Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Biological Hazard Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Biological Hazard Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Biological Hazard Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Nano Material Indicator |
Base Entity | Proposal Submission |
Attribute Name | Nano Material Indicator |
Logical Rolename | |
ColumnName | NANO_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Nano Material Indicator Logical Attribute Properties |
Logical Attribute Name | Nano Material Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Nano Material Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Nano Material 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 |
Nano Material Indicator Security Types |
Name | Current Value |
Nano Material Indicator Bound Attachments |
Name | Current Value |
Nano Material Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Nano Material Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Nano Material Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS NANO_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS NANO_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS NANO_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS NANO_IND |
NO |
Nano Material Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Nano Material Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Nano Material Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Nano Material Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Human Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Human Indicator |
Logical Rolename | |
ColumnName | SFTY_HUMAN_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Human Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Human Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Safety Human Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Safety Human 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 |
Safety Human Indicator Security Types |
Name | Current Value |
Safety Human Indicator Bound Attachments |
Name | Current Value |
Safety Human Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Human Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Human Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_HUMAN_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_HUMAN_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_HUMAN_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_HUMAN_IND |
NO |
Safety Human Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Human Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Human Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Human Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Animal Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Animal Indicator |
Logical Rolename | |
ColumnName | SFTY_ANIMAL_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Animal Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Animal Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Safety Animal Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Safety Animal 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 |
Safety Animal Indicator Security Types |
Name | Current Value |
Safety Animal Indicator Bound Attachments |
Name | Current Value |
Safety Animal Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Animal Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Animal Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_ANIMAL_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_ANIMAL_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_ANIMAL_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_ANIMAL_IND |
NO |
Safety Animal Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Animal Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Animal Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Animal Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Biological Hazard Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Biological Hazard Indicator |
Logical Rolename | |
ColumnName | SFTY_BIO_HAZ_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Biological Hazard Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Biological Hazard Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Safety Biological Hazard Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Safety Biological Hazard 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 |
Safety Biological Hazard Indicator Security Types |
Name | Current Value |
Safety Biological Hazard Indicator Bound Attachments |
Name | Current Value |
Safety Biological Hazard Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Biological Hazard Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Biological Hazard Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_BIO_HAZ_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_BIO_HAZ_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_BIO_HAZ_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_BIO_HAZ_IND |
NO |
Safety Biological Hazard Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Biological Hazard Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Biological Hazard Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Biological Hazard Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Electrical Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Electrical Indicator |
Logical Rolename | |
ColumnName | SFTY_ELEC_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Electrical Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Electrical Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Safety Electrical Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Safety Electrical 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 |
Safety Electrical Indicator Security Types |
Name | Current Value |
Safety Electrical Indicator Bound Attachments |
Name | Current Value |
Safety Electrical Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Electrical Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Electrical Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_ELEC_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_ELEC_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_ELEC_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_ELEC_IND |
NO |
Safety Electrical Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Electrical Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Electrical Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Electrical Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Isotope Indicator |
Logical Rolename | |
ColumnName | SFTY_ISOTOPE_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Isotope Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Isotope Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Safety Isotope Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Safety Isotope 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 |
Safety Isotope Indicator Security Types |
Name | Current Value |
Safety Isotope Indicator Bound Attachments |
Name | Current Value |
Safety Isotope Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Isotope Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Isotope Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_ISOTOPE_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_ISOTOPE_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_ISOTOPE_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_ISOTOPE_IND |
NO |
Safety Isotope Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Comment |
Base Entity | Proposal Submission |
Attribute Name | Safety Isotope Comment |
Logical Rolename | |
ColumnName | SFTY_ISO_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Safety Isotope Comment Logical Attribute Properties |
Logical Attribute Name | Safety Isotope Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Safety Isotope Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Safety Isotope Comment Security Types |
Name | Current Value |
Safety Isotope Comment Bound Attachments |
Name | Current Value |
Safety Isotope Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Isotope Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Isotope Comment |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_ISO_CMNT |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_ISO_CMNT |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_ISO_CMNT |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_ISO_CMNT |
NO |
Safety Isotope Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Isotope Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Nanoscale Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Nanoscale Indicator |
Logical Rolename | |
ColumnName | SFTY_NANO_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Nanoscale Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Nanoscale Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Safety Nanoscale Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Safety Nanoscale 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 |
Safety Nanoscale Indicator Security Types |
Name | Current Value |
Safety Nanoscale Indicator Bound Attachments |
Name | Current Value |
Safety Nanoscale Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Nanoscale Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Nanoscale Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_NANO_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_NANO_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_NANO_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_NANO_IND |
NO |
Safety Nanoscale Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Nanoscale Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Nanoscale Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Nanoscale Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Nanoscale Matrix Indicator |
Base Entity | Proposal Submission |
Attribute Name | Nanoscale Matrix Indicator |
Logical Rolename | |
ColumnName | NANO_MATRIX_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Nanoscale Matrix Indicator Logical Attribute Properties |
Logical Attribute Name | Nanoscale Matrix Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Nanoscale Matrix Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Nanoscale Matrix 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 |
Nanoscale Matrix Indicator Security Types |
Name | Current Value |
Nanoscale Matrix Indicator Bound Attachments |
Name | Current Value |
Nanoscale Matrix Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Nanoscale Matrix Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Nanoscale Matrix Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS NANO_MATRIX_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS NANO_MATRIX_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS NANO_MATRIX_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS NANO_MATRIX_IND |
NO |
Nanoscale Matrix Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Nanoscale Matrix Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Nanoscale Matrix Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Nanoscale Matrix Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Review Status Identifier |
Base Entity | Proposal Submission |
Attribute Name | Review Status Identifier |
Logical Rolename | |
ColumnName | PRPSL_REVIEW_STAT |
RoleName | PRPSL_REVIEW_STAT |
Domain | |
Logical Only | NO |
Definition | |
Note |
Review Status Identifier Logical Attribute Properties |
Logical Attribute Name | Review Status Identifier |
Datatype | VARCHAR(20) |
Nullable | YES |
Review Status Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Review Status Identifier Security Types |
Name | Current Value |
Review Status Identifier Bound Attachments |
Name | Current Value |
Review Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Review Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Review Status Identifier |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS PRPSL_REVIEW_STAT |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS PRPSL_REVIEW_STAT |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS PRPSL_REVIEW_STAT |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS PRPSL_REVIEW_STAT |
NO |
Review Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Review Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Review Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Review Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Carryover Justification |
Base Entity | Proposal Submission |
Attribute Name | Carryover Justification |
Logical Rolename | |
ColumnName | CARRYOVER_JUST |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Carryover Justification Logical Attribute Properties |
Logical Attribute Name | Carryover Justification |
Datatype | VARCHAR(2000) |
Nullable | YES |
Carryover Justification Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Carryover Justification Security Types |
Name | Current Value |
Carryover Justification Bound Attachments |
Name | Current Value |
Carryover Justification Data Movement Rules |
Name | Type | Rule Text/Value |
Carryover Justification Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Carryover Justification |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS CARRYOVER_JUST |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS CARRYOVER_JUST |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS CARRYOVER_JUST |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS CARRYOVER_JUST |
NO |
Carryover Justification Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Carryover Justification Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Carryover Justification Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Carryover Justification Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification Identifier |
Base Entity | Proposal Submission |
Attribute Name | Continuation Justification Identifier |
Logical Rolename | |
ColumnName | CONT_JUST_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Continuation Justification Identifier Logical Attribute Properties |
Logical Attribute Name | Continuation Justification Identifier |
Datatype | VARCHAR(25) |
Nullable | YES |
Continuation Justification Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Continuation Justification Identifier Security Types |
Name | Current Value |
Continuation Justification Identifier Bound Attachments |
Name | Current Value |
Continuation Justification Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Continuation Justification Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Continuation Justification Identifier |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS CONT_JUST_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS CONT_JUST_ID |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS CONT_JUST_ID |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS CONT_JUST_ID |
NO |
Continuation Justification Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification |
Base Entity | Proposal Submission |
Attribute Name | Continuation Justification |
Logical Rolename | |
ColumnName | CONT_JUST |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Continuation Justification Logical Attribute Properties |
Logical Attribute Name | Continuation Justification |
Datatype | VARCHAR(2000) |
Nullable | YES |
Continuation Justification Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Continuation Justification Security Types |
Name | Current Value |
Continuation Justification Bound Attachments |
Name | Current Value |
Continuation Justification Data Movement Rules |
Name | Type | Rule Text/Value |
Continuation Justification Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Continuation Justification |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS CONT_JUST |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS CONT_JUST |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS CONT_JUST |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS CONT_JUST |
NO |
Continuation Justification Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Continuation Justification Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date |
Base Entity | Proposal Submission |
Attribute Name | Modify Date |
Logical Rolename | |
ColumnName | MOD_DATE |
RoleName | |
Domain | Modify Date |
Logical Only | NO |
Definition | |
Note |
Modify Date Logical Attribute Properties |
Logical Attribute Name | Modify Date |
Datatype | DATE |
Nullable | NO |
Modify Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Modify Date Security Types |
Name | Current Value |
Modify Date Bound Attachments |
Name | Current Value |
Modify Date Data Movement Rules |
Name | Type | Rule Text/Value |
Modify Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Modify Date |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS MOD_DATE |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS MOD_DATE |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS MOD_DATE |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS MOD_DATE |
NO |
Modify Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Programmatic Progress Report Comment |
Base Entity | Proposal Submission |
Attribute Name | Programmatic Progress Report Comment |
Logical Rolename | |
ColumnName | PRGM_PROG_RPT_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Programmatic Progress Report Comment Logical Attribute Properties |
Logical Attribute Name | Programmatic Progress Report Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Programmatic Progress Report Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Programmatic Progress Report Comment Security Types |
Name | Current Value |
Programmatic Progress Report Comment Bound Attachments |
Name | Current Value |
Programmatic Progress Report Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Programmatic Progress Report Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Programmatic Progress Report Comment |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS PRGM_PROG_RPT_CMNT |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS PRGM_PROG_RPT_CMNT |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS PRGM_PROG_RPT_CMNT |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS PRGM_PROG_RPT_CMNT |
NO |
Programmatic Progress Report Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Programmatic Progress Report Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Programmatic Progress Report Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Programmatic Progress Report Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Pressure Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Pressure Indicator |
Logical Rolename | |
ColumnName | SFTY_PRESS_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Pressure Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Pressure Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Safety Pressure Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Safety Pressure 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 |
Safety Pressure Indicator Security Types |
Name | Current Value |
Safety Pressure Indicator Bound Attachments |
Name | Current Value |
Safety Pressure Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Pressure Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Pressure Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_PRESS_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_PRESS_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_PRESS_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_PRESS_IND |
NO |
Safety Pressure Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Pressure Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Pressure Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Pressure Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Chemical Indicator |
Base Entity | Proposal Submission |
Attribute Name | Safety Chemical Indicator |
Logical Rolename | |
ColumnName | SFTY_CHEM_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Safety Chemical Indicator Logical Attribute Properties |
Logical Attribute Name | Safety Chemical Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Safety Chemical Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Safety Chemical 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 |
Safety Chemical Indicator Security Types |
Name | Current Value |
Safety Chemical Indicator Bound Attachments |
Name | Current Value |
Safety Chemical Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Safety Chemical Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Safety Chemical Indicator |
NO | ||
EXPRESS (Oracle) PRPSL_SUBMISS SFTY_CHEM_IND |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS SFTY_CHEM_IND |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS SFTY_CHEM_IND |
NO | ||
XF_ADMIN (Oracle) PRPSL_SUBMISS SFTY_CHEM_IND |
NO |
Safety Chemical Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Chemical Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Chemical Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Safety Chemical Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |