| PRPSL_ID |
| Base Object | EXPT_SMPL_ENV |
| 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 Experiment Sample Environment Proposal Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV PRPSL_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV 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 | EXPT_SMPL_ENV |
| 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 Experiment Sample Environment Submission Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV SUBMISS_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV 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 |
| TEMP_LOW |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Temperature Low |
| ColumnName | TEMP_LOW |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEMP_LOW Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP_LOW Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| TEMP_LOW Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP_LOW Security Types |
| Name | Current Value |
| TEMP_LOW Bound Attachments |
| Name | Current Value |
| TEMP_LOW Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP_LOW Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Temperature Low |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV TEMP_LOW |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV TEMP_LOW |
NO |
| TEMP_LOW Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_LOW Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_LOW Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_LOW Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_HIGH |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Temperature High |
| ColumnName | TEMP_HIGH |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEMP_HIGH Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP_HIGH Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| TEMP_HIGH Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP_HIGH Security Types |
| Name | Current Value |
| TEMP_HIGH Bound Attachments |
| Name | Current Value |
| TEMP_HIGH Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP_HIGH Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Temperature High |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV TEMP_HIGH |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV TEMP_HIGH |
NO |
| TEMP_HIGH Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_HIGH Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_HIGH Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_HIGH Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Pressure |
| ColumnName | PRESS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PRESS Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PRESS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| PRESS Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PRESS Security Types |
| Name | Current Value |
| PRESS Bound Attachments |
| Name | Current Value |
| PRESS Data Movement Rules |
| Name | Type | Rule Text/Value |
| PRESS Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Pressure |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV PRESS |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV PRESS |
NO |
| PRESS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAG_FLD |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Magnetic Field |
| ColumnName | MAG_FLD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| MAG_FLD Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MAG_FLD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| MAG_FLD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MAG_FLD Security Types |
| Name | Current Value |
| MAG_FLD Bound Attachments |
| Name | Current Value |
| MAG_FLD Data Movement Rules |
| Name | Type | Rule Text/Value |
| MAG_FLD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Magnetic Field |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV MAG_FLD |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV MAG_FLD |
NO |
| MAG_FLD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAG_FLD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAG_FLD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAG_FLD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| THERO_OTHER |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Thermodynamics Other |
| ColumnName | THERO_OTHER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| THERO_OTHER Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| THERO_OTHER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| THERO_OTHER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| THERO_OTHER Security Types |
| Name | Current Value |
| THERO_OTHER Bound Attachments |
| Name | Current Value |
| THERO_OTHER Data Movement Rules |
| Name | Type | Rule Text/Value |
| THERO_OTHER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Thermodynamics Other |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV THERO_OTHER |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV THERO_OTHER |
NO |
| THERO_OTHER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| THERO_OTHER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| THERO_OTHER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| THERO_OTHER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Note |
| ColumnName | NOTE |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| NOTE Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NOTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| NOTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NOTE Security Types |
| Name | Current Value |
| NOTE Bound Attachments |
| Name | Current Value |
| NOTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| NOTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Note |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV NOTE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV NOTE |
NO |
| NOTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SUP_EQUIP |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | User Supplied Equipment |
| ColumnName | USER_SUP_EQUIP |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| USER_SUP_EQUIP Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USER_SUP_EQUIP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| USER_SUP_EQUIP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| USER_SUP_EQUIP Security Types |
| Name | Current Value |
| USER_SUP_EQUIP Bound Attachments |
| Name | Current Value |
| USER_SUP_EQUIP Data Movement Rules |
| Name | Type | Rule Text/Value |
| USER_SUP_EQUIP Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment User Supplied Equipment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV USER_SUP_EQUIP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV USER_SUP_EQUIP |
NO |
| USER_SUP_EQUIP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SUP_EQUIP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SUP_EQUIP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SUP_EQUIP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_FACIL_TECH_CONT |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Home Facility Tecnical Contact |
| ColumnName | HOME_FACIL_TECH_CONT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| HOME_FACIL_TECH_CONT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HOME_FACIL_TECH_CONT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| HOME_FACIL_TECH_CONT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HOME_FACIL_TECH_CONT Security Types |
| Name | Current Value |
| HOME_FACIL_TECH_CONT Bound Attachments |
| Name | Current Value |
| HOME_FACIL_TECH_CONT Data Movement Rules |
| Name | Type | Rule Text/Value |
| HOME_FACIL_TECH_CONT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Home Facility Tecnical Contact |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV HOME_FACIL_TECH_CONT |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV HOME_FACIL_TECH_CONT |
NO |
| HOME_FACIL_TECH_CONT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_FACIL_TECH_CONT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_FACIL_TECH_CONT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HOME_FACIL_TECH_CONT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_IND |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Feasibility Indicator |
| ColumnName | FEAS_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| FEAS_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FEAS_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| FEAS_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FEAS_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 |
| FEAS_IND Security Types |
| Name | Current Value |
| FEAS_IND Bound Attachments |
| Name | Current Value |
| FEAS_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| FEAS_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Feasibility Indicator |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV FEAS_IND |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV FEAS_IND |
NO |
| FEAS_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_CMNT |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Feasibility Comment |
| ColumnName | FEAS_CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | |
| Note |
| FEAS_CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FEAS_CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| FEAS_CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FEAS_CMNT Security Types |
| Name | Current Value |
| FEAS_CMNT Bound Attachments |
| Name | Current Value |
| FEAS_CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| FEAS_CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Feasibility Comment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV FEAS_CMNT |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV FEAS_CMNT |
NO |
| FEAS_CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEAS_CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OTHER_HAZ |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Other Hazards |
| ColumnName | OTHER_HAZ |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | |
| Note |
| OTHER_HAZ Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OTHER_HAZ Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| OTHER_HAZ Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OTHER_HAZ Security Types |
| Name | Current Value |
| OTHER_HAZ Bound Attachments |
| Name | Current Value |
| OTHER_HAZ Data Movement Rules |
| Name | Type | Rule Text/Value |
| OTHER_HAZ Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Other Hazards |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV OTHER_HAZ |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV OTHER_HAZ |
NO |
| OTHER_HAZ Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OTHER_HAZ Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OTHER_HAZ Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OTHER_HAZ Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SPLY_EQUIP_IND |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | User Supplied Equipment Indicator |
| ColumnName | USER_SPLY_EQUIP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| USER_SPLY_EQUIP_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USER_SPLY_EQUIP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| USER_SPLY_EQUIP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| USER_SPLY_EQUIP_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| USER_SPLY_EQUIP_IND Security Types |
| Name | Current Value |
| USER_SPLY_EQUIP_IND Bound Attachments |
| Name | Current Value |
| USER_SPLY_EQUIP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| USER_SPLY_EQUIP_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment User Supplied Equipment Indicator |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV USER_SPLY_EQUIP_IND |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV USER_SPLY_EQUIP_IND |
NO |
| USER_SPLY_EQUIP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SPLY_EQUIP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SPLY_EQUIP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_SPLY_EQUIP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_DESCR |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Waste Description |
| ColumnName | WASTE_DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | |
| Note |
| WASTE_DESCR Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| WASTE_DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 18 |
| Percent Null | 0 |
| WASTE_DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WASTE_DESCR Security Types |
| Name | Current Value |
| WASTE_DESCR Bound Attachments |
| Name | Current Value |
| WASTE_DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| WASTE_DESCR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Waste Description |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV WASTE_DESCR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV WASTE_DESCR |
NO |
| WASTE_DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Modify Date |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| MOD_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_DTE Security Types |
| Name | Current Value |
| MOD_DTE Bound Attachments |
| Name | Current Value |
| MOD_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Modify Date |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV MOD_DTE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV MOD_DTE |
NO |
| MOD_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID |
| Base Object | EXPT_SMPL_ENV |
| Attribute Name | Temperature Unit Identifier |
| ColumnName | TEMP_UNIT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Unit Identifier: Abbreviated unit of mass. |
| Note |
| TEMP_UNIT_ID Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP_UNIT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| TEMP_UNIT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP_UNIT_ID Security Types |
| Name | Current Value |
| TEMP_UNIT_ID Bound Attachments |
| Name | Current Value |
| TEMP_UNIT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP_UNIT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Environment Temperature Unit Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_ENV TEMP_UNIT_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_ENV TEMP_UNIT_ID |
NO |
| TEMP_UNIT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |