Operation Group Identifier |
Base Entity | Operation Subgroup |
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 | NO |
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 Operation Subgroup Operation Group Identifier |
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 | Operation Subgroup |
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 | NO |
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 Operation Subgroup Operation Subgroup1 Identifier |
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 |
Operation Subgroup1 Name |
Base Entity | Operation Subgroup |
Attribute Name | Operation Subgroup1 Name |
Logical Rolename | |
ColumnName | OPER_SUBGRP1_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Equipment Subcategory Name: The name of the equipment subcategory. |
Note |
Operation Subgroup1 Name Logical Attribute Properties |
Logical Attribute Name | Operation Subgroup1 Name |
Datatype | VARCHAR(120) |
Nullable | YES |
Operation Subgroup1 Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Operation Subgroup1 Name Security Types |
Name | Current Value |
Operation Subgroup1 Name Bound Attachments |
Name | Current Value |
Operation Subgroup1 Name Data Movement Rules |
Name | Type | Rule Text/Value |
Operation Subgroup1 Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Subgroup Operation Subgroup1 Name |
NO |
Operation Subgroup1 Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup1 Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup1 Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup1 Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Display Order Number |
Base Entity | Operation Subgroup |
Attribute Name | Display Order Number |
Logical Rolename | |
ColumnName | DISP_ORD_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Equipment Subcategory Display Order: This is used when listing subcategories in the application's drop down list. |
Note |
Display Order Number Logical Attribute Properties |
Logical Attribute Name | Display Order Number |
Datatype | NUMERIC(3, 0) |
Nullable | YES |
Display Order Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Display Order Number Security Types |
Name | Current Value |
Display Order Number Bound Attachments |
Name | Current Value |
Display Order Number Data Movement Rules |
Name | Type | Rule Text/Value |
Display Order Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Subgroup Display Order Number |
NO |
Display Order Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Display Order Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Display Order Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Display Order Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Indicator |
Base Entity | Operation Subgroup |
Attribute Name | Elog Indicator |
Logical Rolename | |
ColumnName | ELOG_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Electronic Logbook Inidcator: Inidicates the entry is used as a Logbook category in the electronic logbook. |
Note |
Elog Indicator Logical Attribute Properties |
Logical Attribute Name | Elog Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Elog Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Elog 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 |
Elog Indicator Security Types |
Name | Current Value |
Elog Indicator Bound Attachments |
Name | Current Value |
Elog Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Elog Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Subgroup Elog Indicator |
NO |
Elog Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Indicator |
Base Entity | Operation Subgroup |
Attribute Name | Call Down Indicator |
Logical Rolename | |
ColumnName | CALL_DOWN_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Call Down List Indicator: Indicates that this category is used as category in the Operations call down list. |
Note |
Call Down Indicator Logical Attribute Properties |
Logical Attribute Name | Call Down Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Call Down Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Call Down 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 |
Call Down Indicator Security Types |
Name | Current Value |
Call Down Indicator Bound Attachments |
Name | Current Value |
Call Down Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Call Down Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Subgroup Call Down Indicator |
NO |
Call Down Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |