| Instrument Support Activity Identifier |
| Base Entity | Instrument Support Activity |
| Attribute Name | Instrument Support Activity Identifier |
| Logical Rolename | |
| ColumnName | INSTR_SUP_ACT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Instrument Support Activity Identifier Logical Attribute Properties |
| Logical Attribute Name | Instrument Support Activity Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Instrument Support Activity Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Instrument Support Activity Identifier Security Types |
| Name | Current Value |
| Instrument Support Activity Identifier Bound Attachments |
| Name | Current Value |
| Instrument Support Activity Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Instrument Support Activity Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Instrument Support Activity Identifier |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT INSTR_SUP_ACT_ID |
NO |
| Instrument Support Activity Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Support Activity Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Support Activity Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Support Activity Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date |
| Base Entity | Instrument Support Activity |
| Attribute Name | Start Date |
| Logical Rolename | |
| ColumnName | START_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Start Date Logical Attribute Properties |
| Logical Attribute Name | Start Date |
| Datatype | DATE |
| Nullable | NO |
| Start Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Start Date Security Types |
| Name | Current Value |
| Start Date Bound Attachments |
| Name | Current Value |
| Start Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Start Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Start Date |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT START_DTE |
NO |
| Start Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| End Date |
| Base Entity | Instrument Support Activity |
| Attribute Name | End Date |
| Logical Rolename | |
| ColumnName | END_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| End Date Logical Attribute Properties |
| Logical Attribute Name | End Date |
| Datatype | DATE |
| Nullable | NO |
| End Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| End Date Security Types |
| Name | Current Value |
| End Date Bound Attachments |
| Name | Current Value |
| End Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| End Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity End Date |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT END_DTE |
NO |
| End Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| End Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| End Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| End Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Identifier |
| Base Entity | Instrument Support Activity |
| Attribute Name | Instrument Identifier |
| Logical Rolename | |
| ColumnName | INSTR_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Instrument Identifier: Abbreviated identier for the instrument. |
| Note |
| Instrument Identifier Logical Attribute Properties |
| Logical Attribute Name | Instrument Identifier |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Instrument Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Instrument Identifier Security Types |
| Name | Current Value |
| Instrument Identifier Bound Attachments |
| Name | Current Value |
| Instrument Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Instrument Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Instrument Identifier |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT INSTR_ID |
NO |
| Instrument Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number |
| Base Entity | Instrument Support Activity |
| Attribute Name | Badge Number |
| Logical Rolename | |
| ColumnName | BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| Badge Number Logical Attribute Properties |
| Logical Attribute Name | Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Badge Number Security Types |
| Name | Current Value |
| Badge Number Bound Attachments |
| Name | Current Value |
| Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Badge Number |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT BN |
NO |
| Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier |
| Base Entity | Instrument Support Activity |
| Attribute Name | Operation Group Identifier |
| Logical Rolename | |
| ColumnName | OPER_GRP_ID |
| RoleName | |
| Domain | Operation Group |
| Logical Only | NO |
| Definition | Equipment Category Identifier: The unique identifier for a specific equipment category. |
| Note |
| Operation Group Identifier Logical Attribute Properties |
| Logical Attribute Name | Operation Group Identifier |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Operation Group Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Operation Group Identifier Security Types |
| Name | Current Value |
| Operation Group Identifier Bound Attachments |
| Name | Current Value |
| Operation Group Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Operation Group Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Operation Group Identifier |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT OPER_GRP_ID |
NO |
| Operation Group Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier |
| Base Entity | Instrument Support Activity |
| Attribute Name | Operation Subgroup1 Identifier |
| Logical Rolename | |
| ColumnName | OPER_SUBGRP1_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Equipment Subcategory Identifier: The unique identifer for an equipment subcategory. |
| Note |
| Operation Subgroup1 Identifier Logical Attribute Properties |
| Logical Attribute Name | Operation Subgroup1 Identifier |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Operation Subgroup1 Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Operation Subgroup1 Identifier Security Types |
| Name | Current Value |
| Operation Subgroup1 Identifier Bound Attachments |
| Name | Current Value |
| Operation Subgroup1 Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Operation Subgroup1 Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Operation Subgroup1 Identifier |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT OPER_SUBGRP1_ID |
NO |
| Operation Subgroup1 Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Activity |
| Base Entity | Instrument Support Activity |
| Attribute Name | Activity |
| Logical Rolename | |
| ColumnName | ACT |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Activity Logical Attribute Properties |
| Logical Attribute Name | Activity |
| Datatype | VARCHAR(4000) |
| Nullable | NO |
| Activity Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Activity Security Types |
| Name | Current Value |
| Activity Bound Attachments |
| Name | Current Value |
| Activity Data Movement Rules |
| Name | Type | Rule Text/Value |
| Activity Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Activity |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT ACT |
NO |
| Activity Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Activity Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Activity Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Activity Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier |
| Base Entity | Instrument Support Activity |
| Attribute Name | Status Identifier |
| Logical Rolename | |
| ColumnName | STAT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Status Identifier Logical Attribute Properties |
| Logical Attribute Name | Status Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Status Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Status Identifier Security Types |
| Name | Current Value |
| Status Identifier Bound Attachments |
| Name | Current Value |
| Status Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Status Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Status Identifier |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT STAT_ID |
NO |
| Status Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Priority Indicator |
| Base Entity | Instrument Support Activity |
| Attribute Name | High Priority Indicator |
| Logical Rolename | |
| ColumnName | HIGH_PRIOR_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| High Priority Indicator Logical Attribute Properties |
| Logical Attribute Name | High Priority Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| High Priority Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| High Priority Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| High Priority Indicator Security Types |
| Name | Current Value |
| High Priority Indicator Bound Attachments |
| Name | Current Value |
| High Priority Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| High Priority Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity High Priority Indicator |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT HIGH_PRIOR_IND |
NO |
| High Priority Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Priority Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Priority Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| High Priority Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Impact Area |
| Base Entity | Instrument Support Activity |
| Attribute Name | Impact Area |
| Logical Rolename | |
| ColumnName | IMPACT_AREA |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Impact Area Logical Attribute Properties |
| Logical Attribute Name | Impact Area |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Impact Area Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Impact Area Security Types |
| Name | Current Value |
| Impact Area Bound Attachments |
| Name | Current Value |
| Impact Area Data Movement Rules |
| Name | Type | Rule Text/Value |
| Impact Area Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Support Activity Impact Area |
NO | ||
| NS_OPER (Oracle) INSTR_SUP_ACT IMPACT_AREA |
NO |
| Impact Area Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Impact Area Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Impact Area Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Impact Area Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |