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 |
Y | Yes |
N | 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 |