OPER_GRP_ID 
Base Object  DT_TIMER_ACCT_ASSC 
Attribute Name  Operation Group Identifier 
ColumnName  OPER_GRP_ID 
Logical Rolename   
RoleName   
Domain  Operation Group 
Physical Only  NO 
Definition 
Equipment Category  Identifier: The unique identifier for a specific equipment category.
 
Note 
 

OPER_GRP_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

OPER_GRP_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

OPER_GRP_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

OPER_GRP_ID Security Types 
Name  Current Value 

OPER_GRP_ID Bound Attachments 
Name  Current Value 

OPER_GRP_ID Data Movement Rules 
Name  Type  Rule Text/Value 

OPER_GRP_ID 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     

OPER_GRP_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

OPER_GRP_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

OPER_GRP_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

OPER_GRP_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


OPER_SUBGRP1_ID 
Base Object  DT_TIMER_ACCT_ASSC 
Attribute Name  Operation Subgroup1 Identifier 
ColumnName  OPER_SUBGRP1_ID 
Logical Rolename  Operation Subgroup1 Identifier 
RoleName  OPER_SUBGRP1_ID 
Domain   
Physical Only  NO 
Definition 
Equipment Subcategory Identifier:  The unique identifer for an equipment subcategory.
 
Note 
 

OPER_SUBGRP1_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

OPER_SUBGRP1_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

OPER_SUBGRP1_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

OPER_SUBGRP1_ID Security Types 
Name  Current Value 

OPER_SUBGRP1_ID Bound Attachments 
Name  Current Value 

OPER_SUBGRP1_ID Data Movement Rules 
Name  Type  Rule Text/Value 

OPER_SUBGRP1_ID 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     

OPER_SUBGRP1_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

OPER_SUBGRP1_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

OPER_SUBGRP1_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

OPER_SUBGRP1_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


downtime_dte 
Base Object  DT_TIMER_ACCT_ASSC 
Attribute Name  Downtime Dte 
ColumnName  downtime_dte 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

downtime_dte Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

downtime_dte Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

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 


timer_seq_id 
Base Object  DT_TIMER_ACCT_ASSC 
Attribute Name  Sequence Identifer 
ColumnName  timer_seq_id 
Logical Rolename   
RoleName  timer_seq_id 
Domain  Sequence 
Physical Only  NO 
Definition 
Sequence:  A numerical primary key value derived from a Sequence.
 
Note 
 

timer_seq_id Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

timer_seq_id Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

timer_seq_id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

timer_seq_id Security Types 
Name  Current Value 

timer_seq_id Bound Attachments 
Name  Current Value 

timer_seq_id Data Movement Rules 
Name  Type  Rule Text/Value 

timer_seq_id 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     

timer_seq_id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

timer_seq_id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

timer_seq_id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

timer_seq_id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TIMER_SEQ_ID 
Base Object  DT_TIMER_ACCT_ASSC 
Attribute Name  TIMER_SEQ_ID 
ColumnName  TIMER_SEQ_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

TIMER_SEQ_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

TIMER_SEQ_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

TIMER_SEQ_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

TIMER_SEQ_ID Security Types 
Name  Current Value 

TIMER_SEQ_ID Bound Attachments 
Name  Current Value 

TIMER_SEQ_ID Data Movement Rules 
Name  Type  Rule Text/Value 

TIMER_SEQ_ID 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     

TIMER_SEQ_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_SEQ_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_SEQ_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TIMER_SEQ_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description