Chart Identifier 
Base Entity  Diagnostics Chart 
Attribute Name  Chart Identifier 
Logical Rolename   
ColumnName  CHART_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

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

Chart Identifier Domain Restrictions 

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

Chart Identifier Bound Attachments 
Name  Current Value 

Chart Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Chart Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Chart
Chart Identifier 
NO     
Watchman (Oracle)
DIAG_CHART
CHART_ID 
NO     

Chart Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Chart Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Chart Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Chart Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Description 
Base Entity  Diagnostics Chart 
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 Chart
Description 
NO     
Watchman (Oracle)
DIAG_CHART
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 Chart 
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 Chart
Title 
NO     
Watchman (Oracle)
DIAG_CHART
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 


Legend Indicator 
Base Entity  Diagnostics Chart 
Attribute Name  Legend Indicator 
Logical Rolename   
ColumnName  LEG_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Legend Indicator: Indicates if the chart legend should be displayed.
 
Note 
 

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

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

Legend 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 

Legend Indicator Security Types 
Name  Current Value 

Legend Indicator Bound Attachments 
Name  Current Value 

Legend Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Legend Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diagnostics Chart
Legend Indicator 
NO     
Watchman (Oracle)
DIAG_CHART
LEG_IND 
NO     

Legend Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Legend Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Legend Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Legend Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modified By Badge Number 
Base Entity  Diagnostics Chart 
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 Chart
Modified By Badge Number 
NO     
Watchman (Oracle)
DIAG_CHART
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 Chart 
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 Chart
Modify Date 
NO     
Watchman (Oracle)
DIAG_CHART
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 


Sart Time 
Base Entity  Diagnostics Chart 
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 Chart
Sart Time 
NO     
Watchman (Oracle)
DIAG_CHART
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 Chart 
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 Chart
Start Time Offset 
NO     
Watchman (Oracle)
DIAG_CHART
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 Chart 
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 Chart
End Time 
NO     
Watchman (Oracle)
DIAG_CHART
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 Chart 
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 Chart
End Time Offset 
NO     
Watchman (Oracle)
DIAG_CHART
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 Chart 
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  NO 

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 Chart
Unit Of Measure 
NO     
Watchman (Oracle)
DIAG_CHART
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 Chart 
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 Chart
Unit Of Measure 
NO     
Watchman (Oracle)
DIAG_CHART
PERIOD_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 Chart 
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 Chart
Period Offset 
NO     
Watchman (Oracle)
DIAG_CHART
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