Operation Group Identifier 
Base Entity  Equipment Sub 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 Sub 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 Sub Subcategory 
Attribute Name  Equip Subcat Id 
Logical Rolename   
ColumnName  Equip Subcat Id 
RoleName   
Domain   
Logical Only  NO 
Definition 
Equipment Subcategory Identifier:  The unique identifier 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 Sub 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 Sub Subcat ID 
Base Entity  Equipment Sub Subcategory 
Attribute Name  Equip Sub Subcat ID 
Logical Rolename   
ColumnName  Equip Sub Subcat ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Equipment Sub  Subcategory Identifier:  The unique identifer for an equipment sub subcategory.
 
Note 
 

Equip Sub Subcat ID Logical Attribute Properties 
Logical Attribute Name  Equip Sub Subcat ID 
Datatype  VARCHAR(10) 
Nullable  NO 

Equip Sub Subcat ID Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Equip Sub Subcat ID Security Types 
Name  Current Value 

Equip Sub Subcat ID Bound Attachments 
Name  Current Value 

Equip Sub Subcat ID Data Movement Rules 
Name  Type  Rule Text/Value 

Equip Sub Subcat ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Sub Subcategory
Equip Sub Subcat ID 
NO     

Equip Sub Subcat ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Sub Subcat ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Sub Subcat ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Sub Subcat ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

Sub Subcat Nm Logical Attribute Properties 
Logical Attribute Name  Sub Subcat Nm 
Datatype  VARCHAR(120) 
Nullable  YES 

Sub Subcat Nm Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sub Subcat Nm Security Types 
Name  Current Value 

Sub Subcat Nm Bound Attachments 
Name  Current Value 

Sub Subcat Nm Data Movement Rules 
Name  Type  Rule Text/Value 

Sub Subcat Nm Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Sub Subcategory
Sub Subcat Nm 
NO     

Sub Subcat Nm Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sub Subcat Nm Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sub Subcat Nm Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sub Subcat Nm Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sub Subcat Disp Ord 
Base Entity  Equipment Sub Subcategory 
Attribute Name  Sub Subcat Disp Ord 
Logical Rolename   
ColumnName  Sub Subcat Disp Ord 
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 
 

Sub Subcat Disp Ord Logical Attribute Properties 
Logical Attribute Name  Sub Subcat Disp Ord 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Sub Subcat Disp Ord Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Sub Subcat Disp Ord Security Types 
Name  Current Value 

Sub Subcat Disp Ord Bound Attachments 
Name  Current Value 

Sub Subcat Disp Ord Data Movement Rules 
Name  Type  Rule Text/Value 

Sub Subcat Disp Ord Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Sub Subcategory
Sub Subcat Disp Ord 
NO     

Sub Subcat Disp Ord Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sub Subcat Disp Ord Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sub Subcat Disp Ord Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sub Subcat Disp Ord Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description