Operation Group Identifier |
Base Entity | Operation Subgroup2 |
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 Subgroup2 Operation Group Identifier |
NO | ||
OPER (Oracle) OPER_SUBGRP2 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 | Operation Subgroup2 |
Attribute Name | Operation Subgroup1 Identifier |
Logical Rolename | |
ColumnName | OPER_SUBGRP1_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Equipment Subcategory Identifier: The unique identifier 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 Subgroup2 Operation Subgroup1 Identifier |
NO | ||
OPER (Oracle) OPER_SUBGRP2 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 |
Operation Subgroup2 Identifier |
Base Entity | Operation Subgroup2 |
Attribute Name | Operation Subgroup2 Identifier |
Logical Rolename | |
ColumnName | OPER_SUBGRP2_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Equipment Sub Subcategory Identifier: The unique identifer for an equipment sub subcategory. |
Note |
Operation Subgroup2 Identifier Logical Attribute Properties |
Logical Attribute Name | Operation Subgroup2 Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Operation Subgroup2 Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Operation Subgroup2 Identifier Security Types |
Name | Current Value |
Operation Subgroup2 Identifier Bound Attachments |
Name | Current Value |
Operation Subgroup2 Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Operation Subgroup2 Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Subgroup2 Operation Subgroup2 Identifier |
NO | ||
OPER (Oracle) OPER_SUBGRP2 OPER_SUBGRP2_ID |
NO |
Operation Subgroup2 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup2 Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup2 Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup2 Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup2 Name |
Base Entity | Operation Subgroup2 |
Attribute Name | Operation Subgroup2 Name |
Logical Rolename | |
ColumnName | OPER_SUBGRP2_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Equipment Sub Subcategory Name: The name of the equipment subcategory. |
Note |
Operation Subgroup2 Name Logical Attribute Properties |
Logical Attribute Name | Operation Subgroup2 Name |
Datatype | VARCHAR(120) |
Nullable | YES |
Operation Subgroup2 Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Operation Subgroup2 Name Security Types |
Name | Current Value |
Operation Subgroup2 Name Bound Attachments |
Name | Current Value |
Operation Subgroup2 Name Data Movement Rules |
Name | Type | Rule Text/Value |
Operation Subgroup2 Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Subgroup2 Operation Subgroup2 Name |
NO | ||
OPER (Oracle) OPER_SUBGRP2 OPER_SUBGRP2_NM |
NO |
Operation Subgroup2 Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup2 Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup2 Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Operation Subgroup2 Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Display Order Number |
Base Entity | Operation Subgroup2 |
Attribute Name | Display Order Number |
Logical Rolename | |
ColumnName | DISP_ORD_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Equipment Sub 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 Subgroup2 Display Order Number |
NO | ||
OPER (Oracle) OPER_SUBGRP2 DISP_ORD_NBR |
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 |