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