REP_ID 
Base Object  DIAG_REP 
Attribute Name  Report Identifier 
ColumnName  REP_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

REP_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  50 
Percent Null 

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

REP_ID Security Types 
Name  Current Value 

REP_ID Bound Attachments 
Name  Current Value 

REP_ID Data Movement Rules 
Name  Type  Rule Text/Value 

REP_ID 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     

REP_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

REP_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

REP_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

REP_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

DESCR Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

DESCR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

DESCR Security Types 
Name  Current Value 

DESCR Bound Attachments 
Name  Current Value 

DESCR Data Movement Rules 
Name  Type  Rule Text/Value 

DESCR 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     

DESCR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TITLE 
Base Object  DIAG_REP 
Attribute Name  Title 
ColumnName  TITLE 
Logical Rolename   
RoleName   
Domain  Title 
Physical Only  NO 
Definition 
 
Note 
 

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

TITLE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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 


STAT_IMG_IND 
Base Object  DIAG_REP 
Attribute Name  Static Image Indicator 
ColumnName  STAT_IMG_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

STAT_IMG_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

STAT_IMG_IND 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 

STAT_IMG_IND Security Types 
Name  Current Value 

STAT_IMG_IND Bound Attachments 
Name  Current Value 

STAT_IMG_IND Data Movement Rules 
Name  Type  Rule Text/Value 

STAT_IMG_IND 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     

STAT_IMG_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_IMG_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_IMG_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_IMG_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

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

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

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

STAT_IMG_FREQ Security Types 
Name  Current Value 

STAT_IMG_FREQ Bound Attachments 
Name  Current Value 

STAT_IMG_FREQ Data Movement Rules 
Name  Type  Rule Text/Value 

STAT_IMG_FREQ 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     

STAT_IMG_FREQ Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_IMG_FREQ Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_IMG_FREQ Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_IMG_FREQ Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

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

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

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

MOD_BY_BN Security Types 
Name  Current Value 

MOD_BY_BN Bound Attachments 
Name  Current Value 

MOD_BY_BN Data Movement Rules 
Name  Type  Rule Text/Value 

MOD_BY_BN 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     

MOD_BY_BN Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_BN Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_BN Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_BN Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

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

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

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

MOD_DATE Security Types 
Name  Current Value 

MOD_DATE Bound Attachments 
Name  Current Value 

MOD_DATE Data Movement Rules 
Name  Type  Rule Text/Value 

MOD_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     

MOD_DATE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DATE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DATE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DATE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NOTE 
Base Object  DIAG_REP 
Attribute Name  Note 
ColumnName  NOTE 
Logical Rolename   
RoleName   
Domain  Note 
Physical Only  NO 
Definition 
 
Note 
 

NOTE Column Properties 
Datatype  VARCHAR2(4000) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

NOTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  4000 
Percent Null 

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 


TMPL_ID 
Base Object  DIAG_REP 
Attribute Name  Template Identifier 
ColumnName  TMPL_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

TMPL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  25 
Percent Null 

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

TMPL_ID Security Types 
Name  Current Value 

TMPL_ID Bound Attachments 
Name  Current Value 

TMPL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

TMPL_ID 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     

TMPL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TMPL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TMPL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TMPL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

START_TIME Column Properties 
Datatype  TIMESTAMP(6) 
Nullable  YES 
Not Null Constraint   
Time Zone  NO 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

START_TIME Security Types 
Name  Current Value 

START_TIME Bound Attachments 
Name  Current Value 

START_TIME Data Movement Rules 
Name  Type  Rule Text/Value 

START_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     

START_TIME Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

START_TIME Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

START_TIME Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

START_TIME Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


START_TIME_OFFSET 
Base Object  DIAG_REP 
Attribute Name  Start Time Offset 
ColumnName  START_TIME_OFFSET 
Logical Rolename   
RoleName   
Domain   
Physical 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 Column Properties 
Datatype  NUMBER(5, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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 Object  DIAG_REP 
Attribute Name  End Time 
ColumnName  END_TIME 
Logical Rolename   
RoleName   
Domain  Datetime 
Physical Only  NO 
Definition 
 
Note 
 

END_TIME Column Properties 
Datatype  TIMESTAMP(6) 
Nullable  YES 
Not Null Constraint   
Time Zone  NO 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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 Object  DIAG_REP 
Attribute Name  End Time Offset 
ColumnName  END_TIME_OFFSET 
Logical Rolename   
RoleName   
Domain   
Physical 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 Column Properties 
Datatype  NUMBER(5, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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_UOM_ID 
Base Object  DIAG_REP 
Attribute Name  Unit Of Measure 
ColumnName  OFFSET_UOM_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Unit of Measure:  A field used to define a unique unit of measure.
 
Note 
 

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

OFFSET_UOM_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  50 
Percent Null 

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

OFFSET_UOM_ID Security Types 
Name  Current Value 

OFFSET_UOM_ID Bound Attachments 
Name  Current Value 

OFFSET_UOM_ID Data Movement Rules 
Name  Type  Rule Text/Value 

OFFSET_UOM_ID 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_UOM_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

OFFSET_UOM_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

OFFSET_UOM_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

OFFSET_UOM_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description