| EXPT_RSRC_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Experiment Resource Identifier |
| ColumnName | EXPT_RSRC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EXPT_RSRC_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EXPT_RSRC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| EXPT_RSRC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EXPT_RSRC_ID Security Types |
| Name | Current Value |
| EXPT_RSRC_ID Bound Attachments |
| Name | Current Value |
| EXPT_RSRC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EXPT_RSRC_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Experiment Resource Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC EXPT_RSRC_ID |
NO |
| EXPT_RSRC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Status Identifier |
| ColumnName | STAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| STAT_ID Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| STAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STAT_ID Security Types |
| Name | Current Value |
| STAT_ID Bound Attachments |
| Name | Current Value |
| STAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| STAT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Status Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC STAT_ID |
NO |
| STAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMS_RSRC_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Experiment Management System Resource Identifier |
| ColumnName | EMS_RSRC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EMS_RSRC_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMS_RSRC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| EMS_RSRC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EMS_RSRC_ID Security Types |
| Name | Current Value |
| EMS_RSRC_ID Bound Attachments |
| Name | Current Value |
| EMS_RSRC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMS_RSRC_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Experiment Management System Resource Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC EMS_RSRC_ID |
NO |
| EMS_RSRC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMS_RSRC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMS_RSRC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMS_RSRC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSRC_NM |
| Base Object | EXPT_RSRC |
| Attribute Name | Resource Name |
| ColumnName | RSRC_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| RSRC_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RSRC_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| RSRC_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RSRC_NM Security Types |
| Name | Current Value |
| RSRC_NM Bound Attachments |
| Name | Current Value |
| RSRC_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| RSRC_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Resource Name |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC RSRC_NM |
NO |
| RSRC_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSRC_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSRC_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSRC_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_TYPE_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Experiment Resource Type Identifier |
| ColumnName | EXPT_RSRC_TYPE_ID |
| Logical Rolename | Experiment Resource Type Identifier |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EXPT_RSRC_TYPE_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EXPT_RSRC_TYPE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| EXPT_RSRC_TYPE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EXPT_RSRC_TYPE_ID Security Types |
| Name | Current Value |
| EXPT_RSRC_TYPE_ID Bound Attachments |
| Name | Current Value |
| EXPT_RSRC_TYPE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EXPT_RSRC_TYPE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Experiment Resource Type Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC EXPT_RSRC_TYPE_ID |
NO |
| EXPT_RSRC_TYPE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_TYPE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_TYPE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_TYPE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_SUBTYPE_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Experiment Resource Subtype Identifer |
| ColumnName | EXPT_RSRC_SUBTYPE_ID |
| Logical Rolename | Experiment Resource Subtype Identifer |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EXPT_RSRC_SUBTYPE_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EXPT_RSRC_SUBTYPE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| EXPT_RSRC_SUBTYPE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EXPT_RSRC_SUBTYPE_ID Security Types |
| Name | Current Value |
| EXPT_RSRC_SUBTYPE_ID Bound Attachments |
| Name | Current Value |
| EXPT_RSRC_SUBTYPE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EXPT_RSRC_SUBTYPE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Experiment Resource Subtype Identifer |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC EXPT_RSRC_SUBTYPE_ID |
NO |
| EXPT_RSRC_SUBTYPE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_SUBTYPE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_SUBTYPE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RSRC_SUBTYPE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEXT_AVAIL_DTE |
| Base Object | EXPT_RSRC |
| Attribute Name | Next Available Date |
| ColumnName | NEXT_AVAIL_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Next Available Date: Time when the equipment is expected to be available for a new commitment. |
| Note |
| NEXT_AVAIL_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NEXT_AVAIL_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| NEXT_AVAIL_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| NEXT_AVAIL_DTE Security Types |
| Name | Current Value |
| NEXT_AVAIL_DTE Bound Attachments |
| Name | Current Value |
| NEXT_AVAIL_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| NEXT_AVAIL_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Next Available Date |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC NEXT_AVAIL_DTE |
NO |
| NEXT_AVAIL_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEXT_AVAIL_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEXT_AVAIL_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEXT_AVAIL_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL |
| Base Object | EXPT_RSRC |
| Attribute Name | Uniform Resource Locator |
| ColumnName | URL |
| Logical Rolename | |
| RoleName | |
| Domain | URL |
| Physical Only | NO |
| Definition | Universal Resource Locator: The global address of documents and other resources on the web. In this case the URL to the specifications of the equipment. |
| Note |
| URL Column Properties |
| Datatype | VARCHAR2(2048) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| URL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| URL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| URL Security Types |
| Name | Current Value |
| URL Bound Attachments |
| Name | Current Value |
| URL Data Movement Rules |
| Name | Type | Rule Text/Value |
| URL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Uniform Resource Locator |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC URL |
NO |
| URL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME |
| Base Object | EXPT_RSRC |
| Attribute Name | Restore Time |
| ColumnName | RESTORE_TIME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Restore Time: The typical amount of time in hours it takes to restore the equipment back to its base configuration. |
| Note |
| RESTORE_TIME Column Properties |
| Datatype | NUMBER(2, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RESTORE_TIME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| RESTORE_TIME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RESTORE_TIME Security Types |
| Name | Current Value |
| RESTORE_TIME Bound Attachments |
| Name | Current Value |
| RESTORE_TIME Data Movement Rules |
| Name | Type | Rule Text/Value |
| RESTORE_TIME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Restore Time |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC RESTORE_TIME |
NO |
| RESTORE_TIME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | RESTORE_TIME_UOM |
| Logical Rolename | Restore Time Unit of Measure |
| RoleName | RESTORE_TIME_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| RESTORE_TIME_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RESTORE_TIME_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| RESTORE_TIME_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RESTORE_TIME_UOM Security Types |
| Name | Current Value |
| RESTORE_TIME_UOM Bound Attachments |
| Name | Current Value |
| RESTORE_TIME_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| RESTORE_TIME_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC RESTORE_TIME_UOM |
NO |
| RESTORE_TIME_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESTORE_TIME_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME |
| Base Object | EXPT_RSRC |
| Attribute Name | Setup Time |
| ColumnName | SETUP_TIME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Setup Time: The typical amount of time in hours it takes to setup the equipment. |
| Note |
| SETUP_TIME Column Properties |
| Datatype | NUMBER(2, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SETUP_TIME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| SETUP_TIME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SETUP_TIME Security Types |
| Name | Current Value |
| SETUP_TIME Bound Attachments |
| Name | Current Value |
| SETUP_TIME Data Movement Rules |
| Name | Type | Rule Text/Value |
| SETUP_TIME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Setup Time |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC SETUP_TIME |
NO |
| SETUP_TIME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | SETUP_TIME_UOM |
| Logical Rolename | Setup Time Unit of Measure |
| RoleName | SETUP_TIME_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| SETUP_TIME_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SETUP_TIME_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| SETUP_TIME_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SETUP_TIME_UOM Security Types |
| Name | Current Value |
| SETUP_TIME_UOM Bound Attachments |
| Name | Current Value |
| SETUP_TIME_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| SETUP_TIME_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC SETUP_TIME_UOM |
NO |
| SETUP_TIME_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SETUP_TIME_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME |
| Base Object | EXPT_RSRC |
| Attribute Name | Breakdown Time |
| ColumnName | BRKDWN_TIME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BRKDWN_TIME Column Properties |
| Datatype | NUMBER(2, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BRKDWN_TIME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| BRKDWN_TIME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BRKDWN_TIME Security Types |
| Name | Current Value |
| BRKDWN_TIME Bound Attachments |
| Name | Current Value |
| BRKDWN_TIME Data Movement Rules |
| Name | Type | Rule Text/Value |
| BRKDWN_TIME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Breakdown Time |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC BRKDWN_TIME |
NO |
| BRKDWN_TIME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | BRKDWN_TIME_UOM |
| Logical Rolename | Breakdown Time Unit of Measure |
| RoleName | BRKDWN_TIME_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| BRKDWN_TIME_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BRKDWN_TIME_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| BRKDWN_TIME_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BRKDWN_TIME_UOM Security Types |
| Name | Current Value |
| BRKDWN_TIME_UOM Bound Attachments |
| Name | Current Value |
| BRKDWN_TIME_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| BRKDWN_TIME_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC BRKDWN_TIME_UOM |
NO |
| BRKDWN_TIME_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BRKDWN_TIME_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AVAIL |
| Base Object | EXPT_RSRC |
| Attribute Name | Availibility |
| ColumnName | AVAIL |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Operating Schedule: The normal operating schedule in day and hours formatted as follows. |
| Note |
| AVAIL Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AVAIL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| AVAIL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AVAIL Security Types |
| Name | Current Value |
| AVAIL Bound Attachments |
| Name | Current Value |
| AVAIL Data Movement Rules |
| Name | Type | Rule Text/Value |
| AVAIL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Availibility |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC AVAIL |
NO |
| AVAIL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AVAIL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AVAIL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AVAIL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAX_ALLOC_PER |
| Base Object | EXPT_RSRC |
| Attribute Name | Maximum Allocation Percentage |
| ColumnName | MAX_ALLOC_PER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| MAX_ALLOC_PER Column Properties |
| Datatype | NUMBER(3, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MAX_ALLOC_PER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| MAX_ALLOC_PER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MAX_ALLOC_PER Security Types |
| Name | Current Value |
| MAX_ALLOC_PER Bound Attachments |
| Name | Current Value |
| MAX_ALLOC_PER Data Movement Rules |
| Name | Type | Rule Text/Value |
| MAX_ALLOC_PER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Maximum Allocation Percentage |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC MAX_ALLOC_PER |
NO |
| MAX_ALLOC_PER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAX_ALLOC_PER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAX_ALLOC_PER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MAX_ALLOC_PER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MIN |
| Base Object | EXPT_RSRC |
| Attribute Name | Temperature Minimum |
| ColumnName | TEMP_MIN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEMP_MIN Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP_MIN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| TEMP_MIN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP_MIN Security Types |
| Name | Current Value |
| TEMP_MIN Bound Attachments |
| Name | Current Value |
| TEMP_MIN Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP_MIN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Temperature Minimum |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC TEMP_MIN |
NO |
| TEMP_MIN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MIN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MIN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MIN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MAX |
| Base Object | EXPT_RSRC |
| Attribute Name | Temperature Maximum |
| ColumnName | TEMP_MAX |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEMP_MAX Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP_MAX Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| TEMP_MAX Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP_MAX Security Types |
| Name | Current Value |
| TEMP_MAX Bound Attachments |
| Name | Current Value |
| TEMP_MAX Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP_MAX Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Temperature Maximum |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC TEMP_MAX |
NO |
| TEMP_MAX Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MAX Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MAX Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_MAX Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | TEMP_UOM |
| Logical Rolename | Temperature Unit of Measure |
| RoleName | TEMP_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| TEMP_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| TEMP_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP_UOM Security Types |
| Name | Current Value |
| TEMP_UOM Bound Attachments |
| Name | Current Value |
| TEMP_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC TEMP_UOM |
NO |
| TEMP_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MIN |
| Base Object | EXPT_RSRC |
| Attribute Name | Pressure Minimum |
| ColumnName | PRESS_MIN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PRESS_MIN Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PRESS_MIN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| PRESS_MIN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PRESS_MIN Security Types |
| Name | Current Value |
| PRESS_MIN Bound Attachments |
| Name | Current Value |
| PRESS_MIN Data Movement Rules |
| Name | Type | Rule Text/Value |
| PRESS_MIN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Pressure Minimum |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC PRESS_MIN |
NO |
| PRESS_MIN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MIN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MIN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MIN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MAX |
| Base Object | EXPT_RSRC |
| Attribute Name | Pressure Maximum |
| ColumnName | PRESS_MAX |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PRESS_MAX Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PRESS_MAX Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| PRESS_MAX Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PRESS_MAX Security Types |
| Name | Current Value |
| PRESS_MAX Bound Attachments |
| Name | Current Value |
| PRESS_MAX Data Movement Rules |
| Name | Type | Rule Text/Value |
| PRESS_MAX Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Pressure Maximum |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC PRESS_MAX |
NO |
| PRESS_MAX Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MAX Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MAX Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_MAX Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | PRESS_UOM |
| Logical Rolename | Pressure Unit of Measure |
| RoleName | PRESS_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| PRESS_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PRESS_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| PRESS_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PRESS_UOM Security Types |
| Name | Current Value |
| PRESS_UOM Bound Attachments |
| Name | Current Value |
| PRESS_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| PRESS_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC PRESS_UOM |
NO |
| PRESS_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRESS_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_HT |
| Base Object | EXPT_RSRC |
| Attribute Name | Cell Size Height |
| ColumnName | CELL_SIZE_HT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CELL_SIZE_HT Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CELL_SIZE_HT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| CELL_SIZE_HT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CELL_SIZE_HT Security Types |
| Name | Current Value |
| CELL_SIZE_HT Bound Attachments |
| Name | Current Value |
| CELL_SIZE_HT Data Movement Rules |
| Name | Type | Rule Text/Value |
| CELL_SIZE_HT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Cell Size Height |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC CELL_SIZE_HT |
NO |
| CELL_SIZE_HT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_HT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_HT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_HT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_DIA |
| Base Object | EXPT_RSRC |
| Attribute Name | Cell Size Diameter |
| ColumnName | CELL_SIZE_DIA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CELL_SIZE_DIA Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CELL_SIZE_DIA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| CELL_SIZE_DIA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CELL_SIZE_DIA Security Types |
| Name | Current Value |
| CELL_SIZE_DIA Bound Attachments |
| Name | Current Value |
| CELL_SIZE_DIA Data Movement Rules |
| Name | Type | Rule Text/Value |
| CELL_SIZE_DIA Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Cell Size Diameter |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC CELL_SIZE_DIA |
NO |
| CELL_SIZE_DIA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_DIA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_DIA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_DIA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | CELL_SIZE_UOM |
| Logical Rolename | Cell Size Unit of Measure |
| RoleName | CELL_SIZE_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| CELL_SIZE_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CELL_SIZE_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| CELL_SIZE_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CELL_SIZE_UOM Security Types |
| Name | Current Value |
| CELL_SIZE_UOM Bound Attachments |
| Name | Current Value |
| CELL_SIZE_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| CELL_SIZE_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC CELL_SIZE_UOM |
NO |
| CELL_SIZE_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CELL_SIZE_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_HT |
| Base Object | EXPT_RSRC |
| Attribute Name | Sample Space Height |
| ColumnName | SMPL_SPACE_HT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_SPACE_HT Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_SPACE_HT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| SMPL_SPACE_HT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_SPACE_HT Security Types |
| Name | Current Value |
| SMPL_SPACE_HT Bound Attachments |
| Name | Current Value |
| SMPL_SPACE_HT Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_SPACE_HT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Sample Space Height |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC SMPL_SPACE_HT |
NO |
| SMPL_SPACE_HT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_HT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_HT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_HT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_DIA |
| Base Object | EXPT_RSRC |
| Attribute Name | Sample Space Diameter |
| ColumnName | SMPL_SPACE_DIA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_SPACE_DIA Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_SPACE_DIA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SMPL_SPACE_DIA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_SPACE_DIA Security Types |
| Name | Current Value |
| SMPL_SPACE_DIA Bound Attachments |
| Name | Current Value |
| SMPL_SPACE_DIA Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_SPACE_DIA Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Sample Space Diameter |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC SMPL_SPACE_DIA |
NO |
| SMPL_SPACE_DIA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_DIA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_DIA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_DIA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | SMPL_SPACE_UOM |
| Logical Rolename | Sample Space Unit of Measure |
| RoleName | SMPL_SPACE_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| SMPL_SPACE_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_SPACE_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| SMPL_SPACE_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_SPACE_UOM Security Types |
| Name | Current Value |
| SMPL_SPACE_UOM Bound Attachments |
| Name | Current Value |
| SMPL_SPACE_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_SPACE_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC SMPL_SPACE_UOM |
NO |
| SMPL_SPACE_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SPACE_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_HT |
| Base Object | EXPT_RSRC |
| Attribute Name | Bore Size Height |
| ColumnName | BORE_SIZE_HT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BORE_SIZE_HT Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BORE_SIZE_HT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| BORE_SIZE_HT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BORE_SIZE_HT Security Types |
| Name | Current Value |
| BORE_SIZE_HT Bound Attachments |
| Name | Current Value |
| BORE_SIZE_HT Data Movement Rules |
| Name | Type | Rule Text/Value |
| BORE_SIZE_HT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Bore Size Height |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC BORE_SIZE_HT |
NO |
| BORE_SIZE_HT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_HT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_HT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_HT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_DIA |
| Base Object | EXPT_RSRC |
| Attribute Name | Bore Size Diameter |
| ColumnName | BORE_SIZE_DIA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BORE_SIZE_DIA Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BORE_SIZE_DIA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| BORE_SIZE_DIA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BORE_SIZE_DIA Security Types |
| Name | Current Value |
| BORE_SIZE_DIA Bound Attachments |
| Name | Current Value |
| BORE_SIZE_DIA Data Movement Rules |
| Name | Type | Rule Text/Value |
| BORE_SIZE_DIA Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Bore Size Diameter |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC BORE_SIZE_DIA |
NO |
| BORE_SIZE_DIA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_DIA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_DIA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_DIA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | BORE_SIZE_UOM |
| Logical Rolename | Bore Size Unit of Measure |
| RoleName | BORE_SIZE_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| BORE_SIZE_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BORE_SIZE_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| BORE_SIZE_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BORE_SIZE_UOM Security Types |
| Name | Current Value |
| BORE_SIZE_UOM Bound Attachments |
| Name | Current Value |
| BORE_SIZE_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| BORE_SIZE_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC BORE_SIZE_UOM |
NO |
| BORE_SIZE_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BORE_SIZE_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INTERFACE_CONN |
| Base Object | EXPT_RSRC |
| Attribute Name | Interface Connection |
| ColumnName | INTERFACE_CONN |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| INTERFACE_CONN Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INTERFACE_CONN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| INTERFACE_CONN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INTERFACE_CONN Security Types |
| Name | Current Value |
| INTERFACE_CONN Bound Attachments |
| Name | Current Value |
| INTERFACE_CONN Data Movement Rules |
| Name | Type | Rule Text/Value |
| INTERFACE_CONN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Interface Connection |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC INTERFACE_CONN |
NO |
| INTERFACE_CONN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INTERFACE_CONN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INTERFACE_CONN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INTERFACE_CONN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER |
| Base Object | EXPT_RSRC |
| Attribute Name | Distance Interface Beam Center |
| ColumnName | DIST_INT_BEAM_CENTER |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| DIST_INT_BEAM_CENTER Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DIST_INT_BEAM_CENTER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| DIST_INT_BEAM_CENTER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DIST_INT_BEAM_CENTER Security Types |
| Name | Current Value |
| DIST_INT_BEAM_CENTER Bound Attachments |
| Name | Current Value |
| DIST_INT_BEAM_CENTER Data Movement Rules |
| Name | Type | Rule Text/Value |
| DIST_INT_BEAM_CENTER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Distance Interface Beam Center |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC DIST_INT_BEAM_CENTER |
NO |
| DIST_INT_BEAM_CENTER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_ADJ |
| Base Object | EXPT_RSRC |
| Attribute Name | Distance Interface Beam Center Adjustment |
| ColumnName | DIST_INT_BEAM_CENTER_ADJ |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DIST_INT_BEAM_CENTER_ADJ Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DIST_INT_BEAM_CENTER_ADJ Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| DIST_INT_BEAM_CENTER_ADJ Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DIST_INT_BEAM_CENTER_ADJ Security Types |
| Name | Current Value |
| DIST_INT_BEAM_CENTER_ADJ Bound Attachments |
| Name | Current Value |
| DIST_INT_BEAM_CENTER_ADJ Data Movement Rules |
| Name | Type | Rule Text/Value |
| DIST_INT_BEAM_CENTER_ADJ Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Distance Interface Beam Center Adjustment |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC DIST_INT_BEAM_CENTER_ADJ |
NO |
| DIST_INT_BEAM_CENTER_ADJ Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_ADJ Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_ADJ Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_ADJ Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | DIST_INT_BEAM_CENTER_UOM |
| Logical Rolename | Distance Interface Beam Center Unit of Measure |
| RoleName | DIST_INT_BEAM_CENTER_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| DIST_INT_BEAM_CENTER_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DIST_INT_BEAM_CENTER_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| DIST_INT_BEAM_CENTER_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DIST_INT_BEAM_CENTER_UOM Security Types |
| Name | Current Value |
| DIST_INT_BEAM_CENTER_UOM Bound Attachments |
| Name | Current Value |
| DIST_INT_BEAM_CENTER_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| DIST_INT_BEAM_CENTER_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC DIST_INT_BEAM_CENTER_UOM |
NO |
| DIST_INT_BEAM_CENTER_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_INT_BEAM_CENTER_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER |
| Base Object | EXPT_RSRC |
| Attribute Name | Distance Stick Beam Center |
| ColumnName | DIST_STICK_BEAM_CENTER |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| DIST_STICK_BEAM_CENTER Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DIST_STICK_BEAM_CENTER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| DIST_STICK_BEAM_CENTER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DIST_STICK_BEAM_CENTER Security Types |
| Name | Current Value |
| DIST_STICK_BEAM_CENTER Bound Attachments |
| Name | Current Value |
| DIST_STICK_BEAM_CENTER Data Movement Rules |
| Name | Type | Rule Text/Value |
| DIST_STICK_BEAM_CENTER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Distance Stick Beam Center |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC DIST_STICK_BEAM_CENTER |
NO |
| DIST_STICK_BEAM_CENTER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | DIST_STICK_BEAM_CENTER_UOM |
| Logical Rolename | Distance Stick Beam Center Unit of Measure |
| RoleName | DIST_STICK_BEAM_CENTER_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| DIST_STICK_BEAM_CENTER_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DIST_STICK_BEAM_CENTER_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| DIST_STICK_BEAM_CENTER_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DIST_STICK_BEAM_CENTER_UOM Security Types |
| Name | Current Value |
| DIST_STICK_BEAM_CENTER_UOM Bound Attachments |
| Name | Current Value |
| DIST_STICK_BEAM_CENTER_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| DIST_STICK_BEAM_CENTER_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC DIST_STICK_BEAM_CENTER_UOM |
NO |
| DIST_STICK_BEAM_CENTER_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIST_STICK_BEAM_CENTER_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_BEAM_CENTER |
| Base Object | EXPT_RSRC |
| Attribute Name | Tail Distance Beam Center |
| ColumnName | TAIL_DIST_BEAM_CENTER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TAIL_DIST_BEAM_CENTER Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TAIL_DIST_BEAM_CENTER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| TAIL_DIST_BEAM_CENTER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TAIL_DIST_BEAM_CENTER Security Types |
| Name | Current Value |
| TAIL_DIST_BEAM_CENTER Bound Attachments |
| Name | Current Value |
| TAIL_DIST_BEAM_CENTER Data Movement Rules |
| Name | Type | Rule Text/Value |
| TAIL_DIST_BEAM_CENTER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Tail Distance Beam Center |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC TAIL_DIST_BEAM_CENTER |
NO |
| TAIL_DIST_BEAM_CENTER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_BEAM_CENTER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_BEAM_CENTER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_BEAM_CENTER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_CENTER_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | TAIL_DIST_CENTER_UOM |
| Logical Rolename | Tail Distance Center Unit of Measure |
| RoleName | TAIL_DIST_CENTER_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| TAIL_DIST_CENTER_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TAIL_DIST_CENTER_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| TAIL_DIST_CENTER_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TAIL_DIST_CENTER_UOM Security Types |
| Name | Current Value |
| TAIL_DIST_CENTER_UOM Bound Attachments |
| Name | Current Value |
| TAIL_DIST_CENTER_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| TAIL_DIST_CENTER_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC TAIL_DIST_CENTER_UOM |
NO |
| TAIL_DIST_CENTER_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_CENTER_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_CENTER_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TAIL_DIST_CENTER_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_SMPL_SP_BTM |
| Base Object | EXPT_RSRC |
| Attribute Name | Beam Center to Sample Space Bottom |
| ColumnName | BEAM_CENTER_SMPL_SP_BTM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BEAM_CENTER_SMPL_SP_BTM Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BEAM_CENTER_SMPL_SP_BTM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| BEAM_CENTER_SMPL_SP_BTM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BEAM_CENTER_SMPL_SP_BTM Security Types |
| Name | Current Value |
| BEAM_CENTER_SMPL_SP_BTM Bound Attachments |
| Name | Current Value |
| BEAM_CENTER_SMPL_SP_BTM Data Movement Rules |
| Name | Type | Rule Text/Value |
| BEAM_CENTER_SMPL_SP_BTM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Beam Center to Sample Space Bottom |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC BEAM_CENTER_SMPL_SP_BTM |
NO |
| BEAM_CENTER_SMPL_SP_BTM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_SMPL_SP_BTM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_SMPL_SP_BTM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_SMPL_SP_BTM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_BTM_UOM |
| Base Object | EXPT_RSRC |
| Attribute Name | Unit Identifier |
| ColumnName | BEAM_CENTER_BTM_UOM |
| Logical Rolename | Beam Center Bottom Unit of Measure |
| RoleName | BEAM_CENTER_BTM_UOM |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| BEAM_CENTER_BTM_UOM Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BEAM_CENTER_BTM_UOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| BEAM_CENTER_BTM_UOM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BEAM_CENTER_BTM_UOM Security Types |
| Name | Current Value |
| BEAM_CENTER_BTM_UOM Bound Attachments |
| Name | Current Value |
| BEAM_CENTER_BTM_UOM Data Movement Rules |
| Name | Type | Rule Text/Value |
| BEAM_CENTER_BTM_UOM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Unit Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC BEAM_CENTER_BTM_UOM |
NO |
| BEAM_CENTER_BTM_UOM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_BTM_UOM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_BTM_UOM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BEAM_CENTER_BTM_UOM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT |
| Base Object | EXPT_RSRC |
| Attribute Name | Comment |
| ColumnName | CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Comment: General comments. |
| Note |
| CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CMNT Security Types |
| Name | Current Value |
| CMNT Bound Attachments |
| Name | Current Value |
| CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Comment |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC CMNT |
NO |
| CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANUF_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Manufacturer Identifier |
| ColumnName | MANUF_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| MANUF_ID Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MANUF_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| MANUF_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MANUF_ID Security Types |
| Name | Current Value |
| MANUF_ID Bound Attachments |
| Name | Current Value |
| MANUF_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MANUF_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Manufacturer Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC MANUF_ID |
NO |
| MANUF_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANUF_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANUF_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANUF_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Model |
| Base Object | EXPT_RSRC |
| Attribute Name | Model |
| ColumnName | Model |
| Logical Rolename | |
| RoleName | |
| Domain | Machine Mode Ind |
| Physical Only | NO |
| Definition | |
| Note |
| Model Column Properties |
| Datatype | RAW(1) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Model Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Model Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Model Security Types |
| Name | Current Value |
| Model Bound Attachments |
| Name | Current Value |
| Model Data Movement Rules |
| Name | Type | Rule Text/Value |
| Model Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Model |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC Model |
NO |
| Model Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Model Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Model Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Model Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANFU_SERIAL_NBR |
| Base Object | EXPT_RSRC |
| Attribute Name | Manufacturer Serial Number |
| ColumnName | MANFU_SERIAL_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| MANFU_SERIAL_NBR Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MANFU_SERIAL_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| MANFU_SERIAL_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MANFU_SERIAL_NBR Security Types |
| Name | Current Value |
| MANFU_SERIAL_NBR Bound Attachments |
| Name | Current Value |
| MANFU_SERIAL_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| MANFU_SERIAL_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Manufacturer Serial Number |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC MANFU_SERIAL_NBR |
NO |
| MANFU_SERIAL_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANFU_SERIAL_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANFU_SERIAL_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MANFU_SERIAL_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COST |
| Base Object | EXPT_RSRC |
| Attribute Name | Cost |
| ColumnName | COST |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| COST Column Properties |
| Datatype | NUMBER(12, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| COST Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| COST Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| COST Security Types |
| Name | Current Value |
| COST Bound Attachments |
| Name | Current Value |
| COST Data Movement Rules |
| Name | Type | Rule Text/Value |
| COST Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Cost |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC COST |
NO |
| COST Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COST Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COST Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COST Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMM_DTE |
| Base Object | EXPT_RSRC |
| Attribute Name | Commission Date |
| ColumnName | COMM_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| COMM_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| COMM_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| COMM_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| COMM_DTE Security Types |
| Name | Current Value |
| COMM_DTE Bound Attachments |
| Name | Current Value |
| COMM_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| COMM_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Commission Date |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC COMM_DTE |
NO |
| COMM_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMM_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMM_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMM_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REV_DTE |
| Base Object | EXPT_RSRC |
| Attribute Name | Revision Date |
| ColumnName | REV_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| REV_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| REV_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| REV_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| REV_DTE Security Types |
| Name | Current Value |
| REV_DTE Bound Attachments |
| Name | Current Value |
| REV_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| REV_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Revision Date |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC REV_DTE |
NO |
| REV_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REV_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REV_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REV_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIEW_CD |
| Base Object | EXPT_RSRC |
| Attribute Name | View Code |
| ColumnName | VIEW_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| VIEW_CD Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| VIEW_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| VIEW_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| VIEW_CD Security Types |
| Name | Current Value |
| VIEW_CD Bound Attachments |
| Name | Current Value |
| VIEW_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| VIEW_CD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource View Code |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC VIEW_CD |
NO |
| VIEW_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIEW_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIEW_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIEW_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DS_ASSET_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | DataStream Assest Identifier |
| ColumnName | DS_ASSET_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| DS_ASSET_ID Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DS_ASSET_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| DS_ASSET_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DS_ASSET_ID Security Types |
| Name | Current Value |
| DS_ASSET_ID Bound Attachments |
| Name | Current Value |
| DS_ASSET_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DS_ASSET_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource DataStream Assest Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC DS_ASSET_ID |
NO |
| DS_ASSET_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DS_ASSET_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DS_ASSET_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DS_ASSET_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MEL_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Master Equipment List Identifier |
| ColumnName | MEL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | Master Equipment List Identifier: The id assigned to the resource in HFIR's Master Equipment List system. |
| Note |
| MEL_ID Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MEL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| MEL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MEL_ID Security Types |
| Name | Current Value |
| MEL_ID Bound Attachments |
| Name | Current Value |
| MEL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MEL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Master Equipment List Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC MEL_ID |
NO |
| MEL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MEL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MEL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MEL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR |
| Base Object | EXPT_RSRC |
| Attribute Name | ORNL Property Number |
| ColumnName | ORNL_PROP_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ORNL_PROP_NBR Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ORNL_PROP_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| ORNL_PROP_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ORNL_PROP_NBR Security Types |
| Name | Current Value |
| ORNL_PROP_NBR Bound Attachments |
| Name | Current Value |
| ORNL_PROP_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL_PROP_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource ORNL Property Number |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC ORNL_PROP_NBR |
NO |
| ORNL_PROP_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Facility Identifier |
| ColumnName | FACIL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place. |
| Note |
| FACIL_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FACIL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| FACIL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FACIL_ID Security Types |
| Name | Current Value |
| FACIL_ID Bound Attachments |
| Name | Current Value |
| FACIL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| FACIL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Facility Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC FACIL_ID |
NO |
| FACIL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOC_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Location Identifier |
| ColumnName | LOC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| LOC_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LOC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| LOC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LOC_ID Security Types |
| Name | Current Value |
| LOC_ID Bound Attachments |
| Name | Current Value |
| LOC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| LOC_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Location Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC LOC_ID |
NO |
| LOC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QTY |
| Base Object | EXPT_RSRC |
| Attribute Name | Quantity |
| ColumnName | QTY |
| Logical Rolename | |
| RoleName | |
| Domain | Quantity |
| Physical Only | NO |
| Definition | |
| Note |
| QTY Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| QTY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| QTY Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 1 |
| Bound Default |
| QTY Security Types |
| Name | Current Value |
| QTY Bound Attachments |
| Name | Current Value |
| QTY Data Movement Rules |
| Name | Type | Rule Text/Value |
| QTY Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Quantity |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC QTY |
NO |
| QTY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QTY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| QTY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| QTY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_IND |
| Base Object | EXPT_RSRC |
| Attribute Name | Approval Indicator |
| ColumnName | APPRV_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Approval Indicator: Indicates if the resource needs approval to be scheduled. |
| Note |
| APPRV_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| APPRV_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| APPRV_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| APPRV_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 |
| APPRV_IND Security Types |
| Name | Current Value |
| APPRV_IND Bound Attachments |
| Name | Current Value |
| APPRV_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| APPRV_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Approval Indicator |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC APPRV_IND |
NO |
| APPRV_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DRAW_NBR |
| Base Object | EXPT_RSRC |
| Attribute Name | Drawing Number |
| ColumnName | DRAW_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Drawing Number: NScD drawing number. |
| Note |
| DRAW_NBR Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DRAW_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| DRAW_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DRAW_NBR Security Types |
| Name | Current Value |
| DRAW_NBR Bound Attachments |
| Name | Current Value |
| DRAW_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DRAW_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Drawing Number |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC DRAW_NBR |
NO |
| DRAW_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DRAW_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DRAW_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DRAW_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAT_IND |
| Base Object | EXPT_RSRC |
| Attribute Name | Catalog Indicator |
| ColumnName | CAT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Catalog Indicator: Indicates the resource should be treated as a catalog item. Catalog items are low support required, generally available and easily replenishable. |
| Note |
| CAT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CAT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| CAT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| CAT_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 |
| CAT_IND Security Types |
| Name | Current Value |
| CAT_IND Bound Attachments |
| Name | Current Value |
| CAT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| CAT_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Catalog Indicator |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC CAT_IND |
NO |
| CAT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ELEC_CERT_ID |
| Base Object | EXPT_RSRC |
| Attribute Name | Electrical Certification Identifier |
| ColumnName | ELEC_CERT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| ELEC_CERT_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ELEC_CERT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| ELEC_CERT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ELEC_CERT_ID Security Types |
| Name | Current Value |
| ELEC_CERT_ID Bound Attachments |
| Name | Current Value |
| ELEC_CERT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| ELEC_CERT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Electrical Certification Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC ELEC_CERT_ID |
NO |
| ELEC_CERT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ELEC_CERT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ELEC_CERT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ELEC_CERT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_DESC |
| Base Object | EXPT_RSRC |
| Attribute Name | Website Description |
| ColumnName | WEB_DESC |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Website Description: Text describing the experiment resource which will display on the public website. |
| Note |
| WEB_DESC Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| WEB_DESC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| WEB_DESC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WEB_DESC Security Types |
| Name | Current Value |
| WEB_DESC Bound Attachments |
| Name | Current Value |
| WEB_DESC Data Movement Rules |
| Name | Type | Rule Text/Value |
| WEB_DESC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Resource Website Description |
NO | ||
| EXPRESS (Oracle) EXPT_RSRC WEB_DESC |
NO |
| WEB_DESC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_DESC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_DESC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_DESC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |