Operation Group Identifier 
Base Entity  Beam Downtime Accounting 
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
Beam Downtime Accounting
Operation Group Identifier 		 NO     
OPER (Oracle)
BEAM_DOWNTIME_ACCT
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  Beam Downtime Accounting 
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
Beam Downtime Accounting
Operation Subgroup1 Identifier 		 NO     
OPER (Oracle)
BEAM_DOWNTIME_ACCT
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  Beam Downtime Accounting 
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
Beam Downtime Accounting
Downtime Dte 		 NO     
OPER (Oracle)
BEAM_DOWNTIME_ACCT
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 

Downtime 
Base Entity  Beam Downtime Accounting 
Attribute Name  Downtime 
Logical Rolename   
ColumnName  downtime 
RoleName   
Domain   
Logical Only  NO 
Definition  
Downtime: The amount of beam time down in tenths due to problem that feel within the operation category.
 
Note 
 

Downtime Logical Attribute Properties 
Logical Attribute Name  Downtime 
Datatype  NUMERIC(3, 1) 
Nullable  NO 

Downtime Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Downtime Security Types 
Name  Current Value 

Downtime Bound Attachments 
Name  Current Value 

Downtime Data Movement Rules 
Name  Type  Rule Text/Value 

Downtime Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Beam Downtime Accounting
Downtime 		 NO     
OPER (Oracle)
BEAM_DOWNTIME_ACCT
downtime 		 NO     

Downtime Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Downtime Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Note 
Base Entity  Beam Downtime Accounting 
Attribute Name  Note 
Logical Rolename   
ColumnName  notes 
RoleName   
Domain  Note 
Logical Only  NO 
Definition 
 
Note 
 

Note Logical Attribute Properties 
Logical Attribute Name  Note 
Datatype  VARCHAR(4000) 
Nullable  YES 

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

Note Security Types 
Name  Current Value 

Note Bound Attachments 
Name  Current Value 

Note Data Movement Rules 
Name  Type  Rule Text/Value 

Note Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Beam Downtime Accounting
Note 		 NO     
OPER (Oracle)
BEAM_DOWNTIME_ACCT
notes 		 NO     

Note Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Note Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Note Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Note Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Previous Shift Indicator 
Base Entity  Beam Downtime Accounting 
Attribute Name  Previous Shift Indicator 
Logical Rolename   
ColumnName  PREV_SHIFT_IND 
RoleName   
Domain   
Logical Only  NO 
Definition  
Previous Shift Indicator: Indicates the downtime is a continuation from the previous shift.
 
Note 
 

Previous Shift Indicator Logical Attribute Properties 
Logical Attribute Name  Previous Shift Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Previous Shift Indicator Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   
Previous Shift Indicator Security Types 
Name  Current Value 

Previous Shift Indicator Bound Attachments 
Name  Current Value 

Previous Shift Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Previous Shift Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Beam Downtime Accounting
Previous Shift Indicator 		 NO     
OPER (Oracle)
BEAM_DOWNTIME_ACCT
PREV_SHIFT_IND 		 NO     

Previous Shift Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Previous Shift Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Previous Shift Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Previous Shift Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Work Order Number 
Base Entity  Beam Downtime Accounting 
Attribute Name  Work Order Number 
Logical Rolename   
ColumnName  WO_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition  
Work Order Number: Assign a DataStream work order initiated to repair the cause of the downtime to the entry.
 
Note 
 

Work Order Number Logical Attribute Properties 
Logical Attribute Name  Work Order Number 
Datatype  VARCHAR(10) 
Nullable  YES 

Work Order Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Work Order Number Security Types 
Name  Current Value 

Work Order Number Bound Attachments 
Name  Current Value 

Work Order Number Data Movement Rules 
Name  Type  Rule Text/Value 

Work Order Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Beam Downtime Accounting
Work Order Number 		 NO     
OPER (Oracle)
BEAM_DOWNTIME_ACCT
WO_NBR 		 NO     

Work Order Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Work Order Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Work Order Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Work Order Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description