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 | 0 |
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 | 0 |
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 | 0 |
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 | 1 |
Percent Null | 0 |
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 |
Y | Yes |
N | 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 | 3 |
Percent Null | 0 |
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 | 6 |
Percent Null | 0 |
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 | 7 |
Percent Null | 0 |
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 | 0 |
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 | 0 |
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 | 7 |
Percent Null | 0 |
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 | 3 |
Percent Null | 0 |
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 | 7 |
Percent Null | 0 |
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 | 3 |
Percent Null | 0 |
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 | 0 |
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 |