Operation Group Identifier |
Base Entity | Equipment Subcategory |
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 Equipment Subcategory 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 |
Equip Subcat Id |
Base Entity | Equipment Subcategory |
Attribute Name | Equip Subcat Id |
Logical Rolename | |
ColumnName | Equip Subcat Id |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Equipment Subcategory Identifier: The unique identifer for an equipment subcategory. |
Note |
Equip Subcat Id Logical Attribute Properties |
Logical Attribute Name | Equip Subcat Id |
Datatype | VARCHAR(10) |
Nullable | NO |
Equip Subcat Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Equip Subcat Id Security Types |
Name | Current Value |
Equip Subcat Id Bound Attachments |
Name | Current Value |
Equip Subcat Id Data Movement Rules |
Name | Type | Rule Text/Value |
Equip Subcat Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Subcategory Equip Subcat Id |
NO |
Equip Subcat Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Nm |
Base Entity | Equipment Subcategory |
Attribute Name | Equip Subcat Nm |
Logical Rolename | |
ColumnName | Equip Subcat Nm |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Equipment Subcategory Name: The name of the equipment subcategory. |
Note |
Equip Subcat Nm Logical Attribute Properties |
Logical Attribute Name | Equip Subcat Nm |
Datatype | VARCHAR(120) |
Nullable | YES |
Equip Subcat Nm Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Equip Subcat Nm Security Types |
Name | Current Value |
Equip Subcat Nm Bound Attachments |
Name | Current Value |
Equip Subcat Nm Data Movement Rules |
Name | Type | Rule Text/Value |
Equip Subcat Nm Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Subcategory Equip Subcat Nm |
NO |
Equip Subcat Nm Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Nm Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Nm Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Nm Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Disp Ord |
Base Entity | Equipment Subcategory |
Attribute Name | Equip Subcat Disp Ord |
Logical Rolename | |
ColumnName | Equip Subcat Disp Ord |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Equipment Subcategory Display Order: This is used when listing subcategories in the application's drop down list. |
Note |
Equip Subcat Disp Ord Logical Attribute Properties |
Logical Attribute Name | Equip Subcat Disp Ord |
Datatype | NUMERIC(3, 0) |
Nullable | YES |
Equip Subcat Disp Ord Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Equip Subcat Disp Ord Security Types |
Name | Current Value |
Equip Subcat Disp Ord Bound Attachments |
Name | Current Value |
Equip Subcat Disp Ord Data Movement Rules |
Name | Type | Rule Text/Value |
Equip Subcat Disp Ord Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Subcategory Equip Subcat Disp Ord |
NO |
Equip Subcat Disp Ord Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Disp Ord Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Disp Ord Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Subcat Disp Ord Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ETS Ind |
Base Entity | Equipment Subcategory |
Attribute Name | ETS Ind |
Logical Rolename | |
ColumnName | ETS Ind |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Equipment Tracking Inidicator: Inidcates if the entry is used as an ETS sub-group. |
Note |
ETS Ind Logical Attribute Properties |
Logical Attribute Name | ETS Ind |
Datatype | CHAR(1) |
Nullable | NO |
ETS Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
ETS 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 |
ETS Ind Security Types |
Name | Current Value |
ETS Ind Bound Attachments |
Name | Current Value |
ETS Ind Data Movement Rules |
Name | Type | Rule Text/Value |
ETS Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Subcategory ETS Ind |
NO |
ETS Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ETS Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ETS Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ETS Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Ind |
Base Entity | Equipment Subcategory |
Attribute Name | Elog Ind |
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 Ind Logical Attribute Properties |
Logical Attribute Name | Elog Ind |
Datatype | CHAR(1) |
Nullable | NO |
Elog Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Elog 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 |
Elog Ind Security Types |
Name | Current Value |
Elog Ind Bound Attachments |
Name | Current Value |
Elog Ind Data Movement Rules |
Name | Type | Rule Text/Value |
Elog Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Subcategory Elog Ind |
NO |
Elog Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Elog Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Ind |
Base Entity | Equipment Subcategory |
Attribute Name | Call Down Ind |
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 Ind Logical Attribute Properties |
Logical Attribute Name | Call Down Ind |
Datatype | CHAR(1) |
Nullable | NO |
Call Down Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Call Down 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 |
Call Down Ind Security Types |
Name | Current Value |
Call Down Ind Bound Attachments |
Name | Current Value |
Call Down Ind Data Movement Rules |
Name | Type | Rule Text/Value |
Call Down Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Subcategory Call Down Ind |
NO |
Call Down Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Call Down Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Downtime Ind |
Base Entity | Equipment Subcategory |
Attribute Name | Beam Downtime Ind |
Logical Rolename | |
ColumnName | beam_downtime_ind |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Beam Downtime Indicator: Indicates that this category can be used in the tracking of beam downtime causes. |
Note |
Beam Downtime Ind Logical Attribute Properties |
Logical Attribute Name | Beam Downtime Ind |
Datatype | CHAR(1) |
Nullable | NO |
Beam Downtime Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Beam Downtime 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 |
Beam Downtime Ind Security Types |
Name | Current Value |
Beam Downtime Ind Bound Attachments |
Name | Current Value |
Beam Downtime Ind Data Movement Rules |
Name | Type | Rule Text/Value |
Beam Downtime Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Subcategory Beam Downtime Ind |
NO |
Beam Downtime Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Downtime Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Downtime Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Downtime Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |