Proposal Identifier |
Base Entity | Experiment Sample Environment |
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 Experiment Sample Environment Proposal Identifier |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV PRPSL_ID |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV 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 | Experiment Sample Environment |
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 Experiment Sample Environment Submission Number |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV SUBMISS_NBR |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV 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 |
Temperature Low |
Base Entity | Experiment Sample Environment |
Attribute Name | Temperature Low |
Logical Rolename | |
ColumnName | TEMP_LOW |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Temperature Low Logical Attribute Properties |
Logical Attribute Name | Temperature Low |
Datatype | VARCHAR(50) |
Nullable | YES |
Temperature Low Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Temperature Low Security Types |
Name | Current Value |
Temperature Low Bound Attachments |
Name | Current Value |
Temperature Low Data Movement Rules |
Name | Type | Rule Text/Value |
Temperature 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 |
Temperature Low Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Low Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Low Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Low Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature High |
Base Entity | Experiment Sample Environment |
Attribute Name | Temperature High |
Logical Rolename | |
ColumnName | TEMP_HIGH |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Temperature High Logical Attribute Properties |
Logical Attribute Name | Temperature High |
Datatype | VARCHAR(50) |
Nullable | YES |
Temperature High Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Temperature High Security Types |
Name | Current Value |
Temperature High Bound Attachments |
Name | Current Value |
Temperature High Data Movement Rules |
Name | Type | Rule Text/Value |
Temperature 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 |
Temperature High Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature High Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature High Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature High Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure |
Base Entity | Experiment Sample Environment |
Attribute Name | Pressure |
Logical Rolename | |
ColumnName | PRESS |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Pressure Logical Attribute Properties |
Logical Attribute Name | Pressure |
Datatype | VARCHAR(50) |
Nullable | YES |
Pressure Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Pressure Security Types |
Name | Current Value |
Pressure Bound Attachments |
Name | Current Value |
Pressure Data Movement Rules |
Name | Type | Rule Text/Value |
Pressure 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 |
Pressure Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field |
Base Entity | Experiment Sample Environment |
Attribute Name | Magnetic Field |
Logical Rolename | |
ColumnName | MAG_FLD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Magnetic Field Logical Attribute Properties |
Logical Attribute Name | Magnetic Field |
Datatype | VARCHAR(50) |
Nullable | YES |
Magnetic Field Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Magnetic Field Security Types |
Name | Current Value |
Magnetic Field Bound Attachments |
Name | Current Value |
Magnetic Field Data Movement Rules |
Name | Type | Rule Text/Value |
Magnetic Field 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 |
Magnetic Field Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Thermodynamics Other |
Base Entity | Experiment Sample Environment |
Attribute Name | Thermodynamics Other |
Logical Rolename | |
ColumnName | THERO_OTHER |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Thermodynamics Other Logical Attribute Properties |
Logical Attribute Name | Thermodynamics Other |
Datatype | VARCHAR(120) |
Nullable | YES |
Thermodynamics Other Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Thermodynamics Other Security Types |
Name | Current Value |
Thermodynamics Other Bound Attachments |
Name | Current Value |
Thermodynamics Other Data Movement Rules |
Name | Type | Rule Text/Value |
Thermodynamics 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 |
Thermodynamics Other Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Thermodynamics Other Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Thermodynamics Other Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Thermodynamics Other Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Note |
Base Entity | Experiment Sample Environment |
Attribute Name | Note |
Logical Rolename | |
ColumnName | NOTE |
RoleName | |
Domain | Note |
Logical Only | NO |
Definition | |
Note |
Note Logical Attribute Properties |
Logical Attribute Name | Note |
Datatype | VARCHAR(4000) |
Nullable | YES |
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 Supplied Equipment |
Base Entity | Experiment Sample Environment |
Attribute Name | User Supplied Equipment |
Logical Rolename | |
ColumnName | USER_SUP_EQUIP |
RoleName | |
Domain | Note |
Logical Only | NO |
Definition | |
Note |
User Supplied Equipment Logical Attribute Properties |
Logical Attribute Name | User Supplied Equipment |
Datatype | VARCHAR(4000) |
Nullable | YES |
User Supplied Equipment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
User Supplied Equipment Security Types |
Name | Current Value |
User Supplied Equipment Bound Attachments |
Name | Current Value |
User Supplied Equipment Data Movement Rules |
Name | Type | Rule Text/Value |
User Supplied Equipment 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 Supplied Equipment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Supplied Equipment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Supplied Equipment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Supplied Equipment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Home Facility Tecnical Contact |
Base Entity | Experiment Sample Environment |
Attribute Name | Home Facility Tecnical Contact |
Logical Rolename | |
ColumnName | HOME_FACIL_TECH_CONT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Home Facility Tecnical Contact Logical Attribute Properties |
Logical Attribute Name | Home Facility Tecnical Contact |
Datatype | VARCHAR(2000) |
Nullable | YES |
Home Facility Tecnical Contact Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Home Facility Tecnical Contact Security Types |
Name | Current Value |
Home Facility Tecnical Contact Bound Attachments |
Name | Current Value |
Home Facility Tecnical Contact Data Movement Rules |
Name | Type | Rule Text/Value |
Home Facility Tecnical Contact 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 Facility Tecnical Contact Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Home Facility Tecnical Contact Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Home Facility Tecnical Contact Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Home Facility Tecnical Contact Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Indicator |
Base Entity | Experiment Sample Environment |
Attribute Name | Feasibility Indicator |
Logical Rolename | |
ColumnName | FEAS_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Feasibility Indicator Logical Attribute Properties |
Logical Attribute Name | Feasibility Indicator |
Datatype | CHAR(1) |
Nullable | YES |
Feasibility Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Feasibility 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 |
Feasibility Indicator Security Types |
Name | Current Value |
Feasibility Indicator Bound Attachments |
Name | Current Value |
Feasibility Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Feasibility Indicator 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 |
Feasibility Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Comment |
Base Entity | Experiment Sample Environment |
Attribute Name | Feasibility Comment |
Logical Rolename | |
ColumnName | FEAS_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | |
Note |
Feasibility Comment Logical Attribute Properties |
Logical Attribute Name | Feasibility Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Feasibility Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Feasibility Comment Security Types |
Name | Current Value |
Feasibility Comment Bound Attachments |
Name | Current Value |
Feasibility Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Feasibility Comment 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 |
Feasibility Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Feasibility Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Other Hazards |
Base Entity | Experiment Sample Environment |
Attribute Name | Other Hazards |
Logical Rolename | |
ColumnName | OTHER_HAZ |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | |
Note |
Other Hazards Logical Attribute Properties |
Logical Attribute Name | Other Hazards |
Datatype | VARCHAR(2000) |
Nullable | YES |
Other Hazards Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Other Hazards Security Types |
Name | Current Value |
Other Hazards Bound Attachments |
Name | Current Value |
Other Hazards Data Movement Rules |
Name | Type | Rule Text/Value |
Other Hazards 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 Hazards Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Other Hazards Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Other Hazards Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Other Hazards Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Supplied Equipment Indicator |
Base Entity | Experiment Sample Environment |
Attribute Name | User Supplied Equipment Indicator |
Logical Rolename | |
ColumnName | USER_SPLY_EQUIP_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
User Supplied Equipment Indicator Logical Attribute Properties |
Logical Attribute Name | User Supplied Equipment Indicator |
Datatype | CHAR(1) |
Nullable | YES |
User Supplied Equipment Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
User Supplied Equipment 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 |
User Supplied Equipment Indicator Security Types |
Name | Current Value |
User Supplied Equipment Indicator Bound Attachments |
Name | Current Value |
User Supplied Equipment Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
User Supplied Equipment Indicator 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 Supplied Equipment Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Supplied Equipment Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Supplied Equipment Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Supplied Equipment Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Description |
Base Entity | Experiment Sample Environment |
Attribute Name | Waste Description |
Logical Rolename | |
ColumnName | WASTE_DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | |
Note |
Waste Description Logical Attribute Properties |
Logical Attribute Name | Waste Description |
Datatype | VARCHAR(max) |
Nullable | YES |
Waste Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Waste Description Security Types |
Name | Current Value |
Waste Description Bound Attachments |
Name | Current Value |
Waste Description Data Movement Rules |
Name | Type | Rule Text/Value |
Waste Description 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 Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date |
Base Entity | Experiment Sample Environment |
Attribute Name | Modify Date |
Logical Rolename | |
ColumnName | MOD_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | |
Note |
Modify Date Logical Attribute Properties |
Logical Attribute Name | Modify Date |
Datatype | DATE |
Nullable | YES |
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 Experiment Sample Environment Modify Date |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV MOD_DTE |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV MOD_DTE |
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 |
Temperature Unit Identifier |
Base Entity | Experiment Sample Environment |
Attribute Name | Temperature Unit Identifier |
Logical Rolename | |
ColumnName | TEMP_UNIT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Unit Identifier: Abbreviated unit of mass. |
Note |
Temperature Unit Identifier Logical Attribute Properties |
Logical Attribute Name | Temperature Unit Identifier |
Datatype | CHAR(1) |
Nullable | YES |
Temperature Unit Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Temperature Unit Identifier Security Types |
Name | Current Value |
Temperature Unit Identifier Bound Attachments |
Name | Current Value |
Temperature Unit Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Temperature Unit Identifier 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 |
Temperature Unit Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Unit Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Unit Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Unit Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Indicator |
Base Entity | Experiment Sample Environment |
Attribute Name | Magnetic Field Indicator |
Logical Rolename | |
ColumnName | MAG_FLD_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Magnetic Field Indicator Logical Attribute Properties |
Logical Attribute Name | Magnetic Field Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Magnetic Field Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Magnetic Field 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 |
Magnetic Field Indicator Security Types |
Name | Current Value |
Magnetic Field Indicator Bound Attachments |
Name | Current Value |
Magnetic Field Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Magnetic Field Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Sample Environment Magnetic Field Indicator |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV MAG_FLD_IND |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV MAG_FLD_IND |
NO |
Magnetic Field Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Maximum |
Base Entity | Experiment Sample Environment |
Attribute Name | Magnetic Field Maximum |
Logical Rolename | |
ColumnName | MAG_FLD_MAX |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Magnetic Field Maximum Logical Attribute Properties |
Logical Attribute Name | Magnetic Field Maximum |
Datatype | VARCHAR(25) |
Nullable | YES |
Magnetic Field Maximum Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Magnetic Field Maximum Security Types |
Name | Current Value |
Magnetic Field Maximum Bound Attachments |
Name | Current Value |
Magnetic Field Maximum Data Movement Rules |
Name | Type | Rule Text/Value |
Magnetic Field Maximum Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Sample Environment Magnetic Field Maximum |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV MAG_FLD_MAX |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV MAG_FLD_MAX |
NO |
Magnetic Field Maximum Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Maximum Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Maximum Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Maximum Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Orientation Code |
Base Entity | Experiment Sample Environment |
Attribute Name | Magnetic Field Orientation Code |
Logical Rolename | |
ColumnName | MAG_FLD_ORIET_CD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Magnetic Field Orientation Code: V - Vertical; H - Horizontal |
Note |
Magnetic Field Orientation Code Logical Attribute Properties |
Logical Attribute Name | Magnetic Field Orientation Code |
Datatype | CHAR(1) |
Nullable | YES |
Magnetic Field Orientation Code Domain Restrictions |
CheckConstraint | MAG_FLD_ORIET_CD IN ('H','V') | ||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Magnetic Field Orientation Code Security Types |
Name | Current Value |
Magnetic Field Orientation Code Bound Attachments |
Name | Current Value |
Magnetic Field Orientation Code Data Movement Rules |
Name | Type | Rule Text/Value |
Magnetic Field Orientation Code Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Sample Environment Magnetic Field Orientation Code |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV MAG_FLD_ORIET_CD |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV MAG_FLD_ORIET_CD |
NO |
Magnetic Field Orientation Code Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Orientation Code Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Orientation Code Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Magnetic Field Orientation Code Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Indicator |
Base Entity | Experiment Sample Environment |
Attribute Name | High Pressure Indicator |
Logical Rolename | |
ColumnName | HIGH_PRESS_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
High Pressure Indicator Logical Attribute Properties |
Logical Attribute Name | High Pressure Indicator |
Datatype | CHAR(1) |
Nullable | NO |
High Pressure Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
High 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 |
High Pressure Indicator Security Types |
Name | Current Value |
High Pressure Indicator Bound Attachments |
Name | Current Value |
High Pressure Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
High Pressure Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Sample Environment High Pressure Indicator |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV HIGH_PRESS_IND |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV HIGH_PRESS_IND |
NO |
High Pressure Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Maximum |
Base Entity | Experiment Sample Environment |
Attribute Name | High Pressure Maximum |
Logical Rolename | |
ColumnName | HIGH_PRESS_MAX |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
High Pressure Maximum Logical Attribute Properties |
Logical Attribute Name | High Pressure Maximum |
Datatype | VARCHAR(25) |
Nullable | YES |
High Pressure Maximum Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
High Pressure Maximum Security Types |
Name | Current Value |
High Pressure Maximum Bound Attachments |
Name | Current Value |
High Pressure Maximum Data Movement Rules |
Name | Type | Rule Text/Value |
High Pressure Maximum Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Sample Environment High Pressure Maximum |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV HIGH_PRESS_MAX |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV HIGH_PRESS_MAX |
NO |
High Pressure Maximum Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Maximum Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Maximum Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
High Pressure Maximum Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit Identifier |
Base Entity | Experiment Sample Environment |
Attribute Name | Pressure Unit Identifier |
Logical Rolename | |
ColumnName | PRESS_UNIT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Pressure Unit Identifier Logical Attribute Properties |
Logical Attribute Name | Pressure Unit Identifier |
Datatype | VARCHAR(25) |
Nullable | YES |
Pressure Unit Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Pressure Unit Identifier Security Types |
Name | Current Value |
Pressure Unit Identifier Bound Attachments |
Name | Current Value |
Pressure Unit Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Pressure Unit Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Sample Environment Pressure Unit Identifier |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV PRESS_UNIT_ID |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV PRESS_UNIT_ID |
NO |
Pressure Unit Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Gas Enviroment Indicator |
Base Entity | Experiment Sample Environment |
Attribute Name | Gas Enviroment Indicator |
Logical Rolename | |
ColumnName | GAS_ENV_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Gas Enviroment Indicator Logical Attribute Properties |
Logical Attribute Name | Gas Enviroment Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Gas Enviroment Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Gas Enviroment 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 |
Gas Enviroment Indicator Security Types |
Name | Current Value |
Gas Enviroment Indicator Bound Attachments |
Name | Current Value |
Gas Enviroment Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Gas Enviroment Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Sample Environment Gas Enviroment Indicator |
NO | ||
IPTSv5 (Oracle) EXPT_SMPL_ENV GAS_ENV_IND |
NO | ||
PRPSL (Oracle) EXPT_SMPL_ENV GAS_ENV_IND |
NO |
Gas Enviroment Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Gas Enviroment Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Gas Enviroment Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Gas Enviroment Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |