Report Identifier 
Base Entity  Diagnostics Report 
Attribute Name  Report Identifier 
Logical Rolename   
ColumnName  REP_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Report Identifier Logical Attribute Properties 
Logical Attribute Name  Report Identifier 
Datatype  VARCHAR(50) 
Nullable  NO 

Report Identifier Domain Restrictions 

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

Report Identifier Bound Attachments 
Name  Current Value 

Report Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Report Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Report Identifier 
NO     
DIAG (Oracle)
DIAG_REP
REP_ID 
NO     
Watchman (Oracle)
DIAG_REP
REP_ID 
NO     

Report Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Report Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Report Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Report Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Description 
Base Entity  Diagnostics Report 
Attribute Name  Description 
Logical Rolename   
ColumnName  DESCR 
RoleName   
Domain  Description 
Logical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Description Logical Attribute Properties 
Logical Attribute Name  Description 
Datatype  VARCHAR(255) 
Nullable  YES 

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

Description Security Types 
Name  Current Value 

Description Bound Attachments 
Name  Current Value 

Description Data Movement Rules 
Name  Type  Rule Text/Value 

Description Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Description 
NO     
DIAG (Oracle)
DIAG_REP
DESCR 
NO     
Watchman (Oracle)
DIAG_REP
DESCR 
NO     

Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Title 
Base Entity  Diagnostics Report 
Attribute Name  Title 
Logical Rolename   
ColumnName  TITLE 
RoleName   
Domain  Title 
Logical Only  NO 
Definition 
 
Note 
 

Title Logical Attribute Properties 
Logical Attribute Name  Title 
Datatype  VARCHAR(255) 
Nullable  NO 

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

Title Security Types 
Name  Current Value 

Title Bound Attachments 
Name  Current Value 

Title Data Movement Rules 
Name  Type  Rule Text/Value 

Title Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Title 
NO     
DIAG (Oracle)
DIAG_REP
TITLE 
NO     
Watchman (Oracle)
DIAG_REP
TITLE 
NO     

Title Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Title Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Title Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Title Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Static Image Indicator 
Base Entity  Diagnostics Report 
Attribute Name  Static Image Indicator 
Logical Rolename   
ColumnName  STAT_IMG_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Static Image Indicator Logical Attribute Properties 
Logical Attribute Name  Static Image Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Static Image Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Static Image Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Static Image Indicator Security Types 
Name  Current Value 

Static Image Indicator Bound Attachments 
Name  Current Value 

Static Image Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Static Image Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Static Image Indicator 
NO     
DIAG (Oracle)
DIAG_REP
STAT_IMG_IND 
NO     
Watchman (Oracle)
DIAG_REP
STAT_IMG_IND 
NO     

Static Image Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Static Image Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Static Image Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Static Image Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Static Image Frequency 
Base Entity  Diagnostics Report 
Attribute Name  Static Image Frequency 
Logical Rolename   
ColumnName  STAT_IMG_FREQ 
RoleName   
Domain   
Logical Only  NO 
Definition 
Static Image Frequency: How often to create a static image of the plot.
 
Note 
 

Static Image Frequency Logical Attribute Properties 
Logical Attribute Name  Static Image Frequency 
Datatype  NUMERIC(4, 0) 
Nullable  NO 

Static Image Frequency Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Static Image Frequency Security Types 
Name  Current Value 

Static Image Frequency Bound Attachments 
Name  Current Value 

Static Image Frequency Data Movement Rules 
Name  Type  Rule Text/Value 

Static Image Frequency Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Static Image Frequency 
NO     
DIAG (Oracle)
DIAG_REP
STAT_IMG_FREQ 
NO     
Watchman (Oracle)
DIAG_REP
STAT_IMG_FREQ 
NO     

Static Image Frequency Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Static Image Frequency Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Static Image Frequency Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Static Image Frequency Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Note 
Base Entity  Diagnostics Report 
Attribute Name  Note 
Logical Rolename   
ColumnName  NOTE 
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
Diagnostics Report
Note 
NO     
DIAG (Oracle)
DIAG_REP
NOTE 
NO     
Watchman (Oracle)
DIAG_REP
NOTE 
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 


Template Identifier 
Base Entity  Diagnostics Report 
Attribute Name  Template Identifier 
Logical Rolename   
ColumnName  TMPL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Template Identifier Logical Attribute Properties 
Logical Attribute Name  Template Identifier 
Datatype  VARCHAR(25) 
Nullable  NO 

Template Identifier Domain Restrictions 

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

Template Identifier Bound Attachments 
Name  Current Value 

Template Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Template Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Template Identifier 
NO     
DIAG (Oracle)
DIAG_REP
TMPL_ID 
NO     
Watchman (Oracle)
DIAG_REP
TMPL_ID 
NO     

Template Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Template Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Template Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Template Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sart Time 
Base Entity  Diagnostics Report 
Attribute Name  Sart Time 
Logical Rolename   
ColumnName  START_TIME 
RoleName   
Domain  Start Time 
Logical Only  NO 
Definition 
Start Time: If the axis is a temporal plot then the starting time.
 
Note 
 

Sart Time Logical Attribute Properties 
Logical Attribute Name  Sart Time 
Datatype  DATETIME 
Nullable  YES 

Sart Time Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sart Time Security Types 
Name  Current Value 

Sart Time Bound Attachments 
Name  Current Value 

Sart Time Data Movement Rules 
Name  Type  Rule Text/Value 

Sart Time Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Sart Time 
NO     
DIAG (Oracle)
DIAG_REP
START_TIME 
NO     
Watchman (Oracle)
DIAG_REP
START_TIME 
NO     

Sart Time Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sart Time Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sart Time Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sart Time Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Start Time Offset 
Base Entity  Diagnostics Report 
Attribute Name  Start Time Offset 
Logical Rolename   
ColumnName  START_TIME_OFFSET 
RoleName   
Domain   
Logical Only  NO 
Definition 
Start Time Offset: The offset, most often in days to apply to the the start time. (i.e. sysdate - 1).
 
Note 
 

Start Time Offset Logical Attribute Properties 
Logical Attribute Name  Start Time Offset 
Datatype  NUMERIC(5, 0) 
Nullable  YES 

Start Time Offset Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Start Time Offset Security Types 
Name  Current Value 

Start Time Offset Bound Attachments 
Name  Current Value 

Start Time Offset Data Movement Rules 
Name  Type  Rule Text/Value 

Start Time Offset Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Start Time Offset 
NO     
DIAG (Oracle)
DIAG_REP
START_TIME_OFFSET 
NO     
Watchman (Oracle)
DIAG_REP
START_TIME_OFFSET 
NO     

Start Time Offset Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Start Time Offset Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Start Time Offset Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Start Time Offset Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


End Time 
Base Entity  Diagnostics Report 
Attribute Name  End Time 
Logical Rolename   
ColumnName  END_TIME 
RoleName   
Domain  Datetime 
Logical Only  NO 
Definition 
 
Note 
 

End Time Logical Attribute Properties 
Logical Attribute Name  End Time 
Datatype  DATETIME 
Nullable  YES 

End Time Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

End Time Security Types 
Name  Current Value 

End Time Bound Attachments 
Name  Current Value 

End Time Data Movement Rules 
Name  Type  Rule Text/Value 

End Time Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
End Time 
NO     
DIAG (Oracle)
DIAG_REP
END_TIME 
NO     
Watchman (Oracle)
DIAG_REP
END_TIME 
NO     

End Time Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

End Time Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

End Time Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

End Time Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


End Time Offset 
Base Entity  Diagnostics Report 
Attribute Name  End Time Offset 
Logical Rolename   
ColumnName  END_TIME_OFFSET 
RoleName   
Domain   
Logical Only  NO 
Definition 
End Time Offset: The offset, most often in days to apply to the the end time. (i.e. sysdate - 1).
 
Note 
 

End Time Offset Logical Attribute Properties 
Logical Attribute Name  End Time Offset 
Datatype  NUMERIC(5, 0) 
Nullable  YES 

End Time Offset Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
End Time Offset Security Types 
Name  Current Value 

End Time Offset Bound Attachments 
Name  Current Value 

End Time Offset Data Movement Rules 
Name  Type  Rule Text/Value 

End Time Offset Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
End Time Offset 
NO     
DIAG (Oracle)
DIAG_REP
END_TIME_OFFSET 
NO     
Watchman (Oracle)
DIAG_REP
END_TIME_OFFSET 
NO     

End Time Offset Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

End Time Offset Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

End Time Offset Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

End Time Offset Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Offset Unit of Measure Identifier 
Base Entity  Diagnostics Report 
Attribute Name  Unit Of Measure 
Logical Rolename  Offset Unit of Measure Identifier 
ColumnName  OFFSET_UOM_ID 
RoleName  OFFSET_UOM_ID 
Domain   
Logical Only  NO 
Definition 
Unit of Measure:  A field used to define a unique unit of measure.
 
Note 
 

Offset Unit of Measure Identifier Logical Attribute Properties 
Logical Attribute Name  Unit Of Measure 
Datatype  VARCHAR(20) 
Nullable  YES 

Offset Unit of Measure Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Offset Unit of Measure Identifier Security Types 
Name  Current Value 

Offset Unit of Measure Identifier Bound Attachments 
Name  Current Value 

Offset Unit of Measure Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Offset Unit of Measure Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Unit Of Measure 
NO     
DIAG (Oracle)
DIAG_REP
OFFSET_UOM_ID 
NO     
Watchman (Oracle)
DIAG_REP
OFFSET_UOM_ID 
NO     

Offset Unit of Measure Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Offset Unit of Measure Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Offset Unit of Measure Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Offset Unit of Measure Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Period Unit of Measure Identifier 
Base Entity  Diagnostics Report 
Attribute Name  Unit Of Measure 
Logical Rolename  Period Unit of Measure Identifier 
ColumnName  PERIOD_UOM_ID 
RoleName  PERIOD_UOM_ID 
Domain   
Logical Only  NO 
Definition 
Unit of Measure:  A field used to define a unique unit of measure.
 
Note 
 

Period Unit of Measure Identifier Logical Attribute Properties 
Logical Attribute Name  Unit Of Measure 
Datatype  VARCHAR(20) 
Nullable  YES 

Period Unit of Measure Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Period Unit of Measure Identifier Security Types 
Name  Current Value 

Period Unit of Measure Identifier Bound Attachments 
Name  Current Value 

Period Unit of Measure Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Period Unit of Measure Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Unit Of Measure 
NO     
DIAG (Oracle)
DIAG_REP
PERIOD_UOM_ID 
NO     
Watchman (Oracle)
DIAG_REP
OFFSET_UOM_ID 
NO     

Period Unit of Measure Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Period Unit of Measure Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Period Unit of Measure Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Period Unit of Measure Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Period Offset 
Base Entity  Diagnostics Report 
Attribute Name  Period Offset 
Logical Rolename   
ColumnName  PERIOD_OFFSET 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Period Offset Logical Attribute Properties 
Logical Attribute Name  Period Offset 
Datatype  NUMERIC(5, 0) 
Nullable  YES 

Period Offset Domain Restrictions 

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

Period Offset Bound Attachments 
Name  Current Value 

Period Offset Data Movement Rules 
Name  Type  Rule Text/Value 

Period Offset Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Period Offset 
NO     
DIAG (Oracle)
DIAG_REP
PERIOD_OFFSET 
NO     
Watchman (Oracle)
DIAG_REP
PERIOD_OFFSET 
NO     

Period Offset Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Period Offset Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Period Offset Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Period Offset Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modified By Badge Number 
Base Entity  Diagnostics Report 
Attribute Name  Modified By Badge Number 
Logical Rolename   
ColumnName  MOD_BY_BN 
RoleName   
Domain  Modied By Badge Number 
Logical Only  NO 
Definition 
Modified by Badge Number:  The ORNL badge number of the person who inserted or update a record in the table.
 
Note 
 

Modified By Badge Number Logical Attribute Properties 
Logical Attribute Name  Modified By Badge Number 
Datatype  VARCHAR(10) 
Nullable  NO 

Modified By Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modified By Badge Number Security Types 
Name  Current Value 

Modified By Badge Number Bound Attachments 
Name  Current Value 

Modified By Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Modified By Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Modified By Badge Number 
NO     
DIAG (Oracle)
DIAG_REP
MOD_BY_BN 
NO     
Watchman (Oracle)
DIAG_REP
MOD_BY_BN 
NO     

Modified By Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modify Date 
Base Entity  Diagnostics Report 
Attribute Name  Modify Date 
Logical Rolename   
ColumnName  MOD_DATE 
RoleName   
Domain  Modify Date 
Logical Only  NO 
Definition 
Modify Date: The date the entity values were were created or modified.
 
Note 
 

Modify Date Logical Attribute Properties 
Logical Attribute Name  Modify Date 
Datatype  DATE 
Nullable  NO 

Modify Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modify Date Security Types 
Name  Current Value 

Modify Date Bound Attachments 
Name  Current Value 

Modify Date Data Movement Rules 
Name  Type  Rule Text/Value 

Modify Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Report
Modify Date 
NO     
DIAG (Oracle)
DIAG_REP
MOD_DATE 
NO     
Watchman (Oracle)
DIAG_REP
MOD_DATE 
NO     

Modify Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description