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