| ControlArea Identifier |
| Base Entity | Control Area |
| Attribute Name | ControlArea Identifier |
| Logical Rolename | |
| ColumnName | CTRL_AREA_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| ControlArea Identifier Logical Attribute Properties |
| Logical Attribute Name | ControlArea Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| ControlArea Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ControlArea Identifier Security Types |
| Name | Current Value |
| ControlArea Identifier Bound Attachments |
| Name | Current Value |
| ControlArea Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| ControlArea Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Control Area ControlArea Identifier |
NO | ||
| SMPL (Oracle) CTRL_AREA CTRL_AREA_ID |
NO |
| ControlArea Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ControlArea Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ControlArea Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ControlArea Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Type Identifier |
| Base Entity | Control Area |
| Attribute Name | Type Identifier |
| Logical Rolename | |
| ColumnName | TYPE_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Type Identifier Logical Attribute Properties |
| Logical Attribute Name | Type Identifier |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| Type Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Type Identifier Security Types |
| Name | Current Value |
| Type Identifier Bound Attachments |
| Name | Current Value |
| Type Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Type Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Control Area Type Identifier |
NO | ||
| SMPL (Oracle) CTRL_AREA TYPE_ID |
NO |
| Type Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Type Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Type Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Type Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Identifier |
| Base Entity | Control Area |
| 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 Control Area Instrument Identifier |
NO | ||
| SMPL (Oracle) CTRL_AREA 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 |
| Laboratory Identifier |
| Base Entity | Control Area |
| Attribute Name | Laboratory Identifier |
| Logical Rolename | |
| ColumnName | LAB_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Laboratory Identifier: Abbreviated identifier for the laboratory. |
| Note |
| Laboratory Identifier Logical Attribute Properties |
| Logical Attribute Name | Laboratory Identifier |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Laboratory Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Laboratory Identifier Security Types |
| Name | Current Value |
| Laboratory Identifier Bound Attachments |
| Name | Current Value |
| Laboratory Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Laboratory Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Control Area Laboratory Identifier |
NO | ||
| SMPL (Oracle) CTRL_AREA LAB_ID |
NO |
| Laboratory Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Laboratory Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Laboratory Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Laboratory Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storage Identifier |
| Base Entity | Control Area |
| Attribute Name | Storage Identifier |
| Logical Rolename | |
| ColumnName | STOR_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Storage Identifier Logical Attribute Properties |
| Logical Attribute Name | Storage Identifier |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Storage Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Storage Identifier Security Types |
| Name | Current Value |
| Storage Identifier Bound Attachments |
| Name | Current Value |
| Storage Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Storage Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Control Area Storage Identifier |
NO | ||
| SMPL (Oracle) CTRL_AREA STOR_ID |
NO |
| Storage Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storage Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storage Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storage Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Handling Identifier |
| Base Entity | Control Area |
| Attribute Name | Handling Identifier |
| Logical Rolename | |
| ColumnName | HAND_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Handling Identifier Logical Attribute Properties |
| Logical Attribute Name | Handling Identifier |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Handling Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Handling Identifier Security Types |
| Name | Current Value |
| Handling Identifier Bound Attachments |
| Name | Current Value |
| Handling Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Handling Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Control Area Handling Identifier |
NO | ||
| SMPL (Oracle) CTRL_AREA HAND_ID |
NO |
| Handling Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Handling Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Handling Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Handling Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator |
| Base Entity | Control Area |
| Attribute Name | Display Indicator |
| Logical Rolename | |
| ColumnName | DISP__IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Display Indicator Logical Attribute Properties |
| Logical Attribute Name | Display Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Display Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Display 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 |
| Display Indicator Security Types |
| Name | Current Value |
| Display Indicator Bound Attachments |
| Name | Current Value |
| Display Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Display Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Control Area Display Indicator |
NO | ||
| SMPL (Oracle) CTRL_AREA DISP__IND |
NO |
| Display Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Inventory Reminder Code |
| Base Entity | Control Area |
| Attribute Name | Inventory Reminder Code |
| Logical Rolename | |
| ColumnName | INVT_REMIND_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Inventory Reminder Code: Indicates whether the given control area should get the inventory reminder email annually or bi-annually. |
| Note |
| Inventory Reminder Code Logical Attribute Properties |
| Logical Attribute Name | Inventory Reminder Code |
| Datatype | CHAR(1) |
| Nullable | YES |
| Inventory Reminder Code Domain Restrictions |
| CheckConstraint | @var IN('A','B') | ||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Inventory Reminder Code Security Types |
| Name | Current Value |
| Inventory Reminder Code Bound Attachments |
| Name | Current Value |
| Inventory Reminder Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Inventory Reminder Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Control Area Inventory Reminder Code |
NO | ||
| SMPL (Oracle) CTRL_AREA INVT_REMIND_CD |
NO |
| Inventory Reminder Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Inventory Reminder Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Inventory Reminder Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Inventory Reminder Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |