Operation Group Identifier 
Base Entity  Downtime Timer Accounting Association 
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
Downtime Timer Accounting Association
Operation Group Identifier 		 NO     
OPER (Oracle)
DT_TIMER_ACCT_ASSC
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  Downtime Timer Accounting Association 
Attribute Name  Operation Subgroup1 Identifier 
Logical Rolename   
ColumnName  OPER_SUBGRP1_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Equipment Subcategory Identifier:  The unique identifer 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
Downtime Timer Accounting Association
Operation Subgroup1 Identifier 		 NO     
OPER (Oracle)
DT_TIMER_ACCT_ASSC
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 

Downtime Dte 
Base Entity  Downtime Timer Accounting Association 
Attribute Name  Downtime Dte 
Logical Rolename   
ColumnName  downtime_dte 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Downtime Dte Logical Attribute Properties 
Logical Attribute Name  Downtime Dte 
Datatype  DATE 
Nullable  NO 

Downtime Dte Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Downtime Dte Security Types 
Name  Current Value 

Downtime Dte Bound Attachments 
Name  Current Value 

Downtime Dte Data Movement Rules 
Name  Type  Rule Text/Value 

Downtime Dte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer Accounting Association
Downtime Dte 		 NO     
OPER (Oracle)
DT_TIMER_ACCT_ASSC
downtime_dte 		 NO     

Downtime Dte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Dte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Dte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Dte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sequence Identifer 
Base Entity  Downtime Timer Accounting Association 
Attribute Name  Sequence Identifer 
Logical Rolename   
ColumnName  timer_seq_id 
RoleName  timer_seq_id 
Domain  Sequence 
Logical Only  NO 
Definition  
Sequence:  A numerical primary key value derived from a Sequence.
 
Note 
 

Sequence Identifer Logical Attribute Properties 
Logical Attribute Name  Sequence Identifer 
Datatype  INTEGER 
Nullable  NO 

Sequence Identifer Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sequence Identifer Security Types 
Name  Current Value 

Sequence Identifer Bound Attachments 
Name  Current Value 

Sequence Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Sequence Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Downtime Timer Accounting Association
Sequence Identifer 		 NO     
OPER (Oracle)
DT_TIMER_ACCT_ASSC
timer_seq_id 		 NO     

Sequence Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sequence Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sequence Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sequence Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description