Operation Group Identifier 
Base Entity  Operation Subgroup5 
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 Subgroup5
Operation Group Identifier 		 NO     
OPER (Oracle)
OPER_SUBGRP5
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 Subgroup5 
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 Subgroup5
Operation Subgroup1 Identifier 		 NO     
OPER (Oracle)
OPER_SUBGRP5
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 Subgroup5 
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 Subgroup5
Operation Subgroup2 Identifier 		 NO     
OPER (Oracle)
OPER_SUBGRP5
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 Subgroup5 
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 Subgroup5
Operation Subgroup3 Identifier 		 NO     
OPER (Oracle)
OPER_SUBGRP5
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 Subgroup4 Identifier 
Base Entity  Operation Subgroup5 
Attribute Name  Operation Subgroup4 Identifier 
Logical Rolename   
ColumnName  OPER_SUBGRP4_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Operation Subgroup4 Identifier Logical Attribute Properties 
Logical Attribute Name  Operation Subgroup4 Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Operation Subgroup4 Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Operation Subgroup4 Identifier Security Types 
Name  Current Value 

Operation Subgroup4 Identifier Bound Attachments 
Name  Current Value 

Operation Subgroup4 Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Operation Subgroup4 Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Subgroup5
Operation Subgroup4 Identifier 		 NO     
OPER (Oracle)
OPER_SUBGRP5
OPER_SUBGRP4_ID 		 NO     

Operation Subgroup4 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup4 Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup4 Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup4 Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Identifer 
Base Entity  Operation Subgroup5 
Attribute Name  Operation Subgroup5 Identifer 
Logical Rolename   
ColumnName  OPER_SUBGRP5_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Operation Subgroup5 Identifer Logical Attribute Properties 
Logical Attribute Name  Operation Subgroup5 Identifer 
Datatype  VARCHAR(10) 
Nullable  NO 

Operation Subgroup5 Identifer Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Operation Subgroup5 Identifer Security Types 
Name  Current Value 

Operation Subgroup5 Identifer Bound Attachments 
Name  Current Value 

Operation Subgroup5 Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Operation Subgroup5 Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Subgroup5
Operation Subgroup5 Identifer 		 NO     
OPER (Oracle)
OPER_SUBGRP5
OPER_SUBGRP5_ID 		 NO     

Operation Subgroup5 Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Name 
Base Entity  Operation Subgroup5 
Attribute Name  Operation Subgroup5 Name 
Logical Rolename   
ColumnName  OPER_SUBGRP5_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Equipment Sub Subcategory Name:  The name of the equipment subcategory.
 
Note 
 

Operation Subgroup5 Name Logical Attribute Properties 
Logical Attribute Name  Operation Subgroup5 Name 
Datatype  VARCHAR(120) 
Nullable  YES 

Operation Subgroup5 Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Operation Subgroup5 Name Security Types 
Name  Current Value 

Operation Subgroup5 Name Bound Attachments 
Name  Current Value 

Operation Subgroup5 Name Data Movement Rules 
Name  Type  Rule Text/Value 

Operation Subgroup5 Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Subgroup5
Operation Subgroup5 Name 		 NO     
OPER (Oracle)
OPER_SUBGRP5
OPER_SUBGRP5_NM 		 NO     

Operation Subgroup5 Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Subgroup5 Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Display Order Number 
Base Entity  Operation Subgroup5 
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 Subgroup5
Display Order Number 		 NO     
OPER (Oracle)
OPER_SUBGRP5
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