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 |
PDF_IND |
Base Object | DIAG_REP |
Attribute Name | PDF Indicator |
ColumnName | PDF_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
PDF_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PDF_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
PDF_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
PDF_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 |
PDF_IND Security Types |
Name | Current Value |
PDF_IND Bound Attachments |
Name | Current Value |
PDF_IND Data Movement Rules |
Name | Type | Rule Text/Value |
PDF_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Report PDF Indicator |
NO | ||
DIAG (Oracle) DIAG_REP PDF_IND |
NO | ||
Watchman (Oracle) DIAG_REP PDF_IND |
NO |
PDF_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PDF_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PDF_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PDF_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PDF_FREQ |
Base Object | DIAG_REP |
Attribute Name | PDF Frequency |
ColumnName | PDF_FREQ |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | PDF Frequency: How often to create a PDF of the plot. |
Note |
PDF_FREQ Column Properties |
Datatype | NUMBER(4, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PDF_FREQ Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
PDF_FREQ Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PDF_FREQ Security Types |
Name | Current Value |
PDF_FREQ Bound Attachments |
Name | Current Value |
PDF_FREQ Data Movement Rules |
Name | Type | Rule Text/Value |
PDF_FREQ Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Report PDF Frequency |
NO | ||
DIAG (Oracle) DIAG_REP PDF_FREQ |
NO | ||
Watchman (Oracle) DIAG_REP PDF_FREQ |
NO |
PDF_FREQ Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PDF_FREQ Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PDF_FREQ Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PDF_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 |
SGNL_ID |
Base Object | DIAG_REP |
Attribute Name | Sgnl Id |
ColumnName | SGNL_ID |
Logical Rolename | |
RoleName | |
Domain | Signal Id |
Physical Only | NO |
Definition | Signal Identifier: |
Note |
SGNL_ID Column Properties |
Datatype | VARCHAR2(75) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SGNL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
SGNL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SGNL_ID Security Types |
Name | Current Value |
SGNL_ID Bound Attachments |
Name | Current Value |
SGNL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SGNL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Report Sgnl Id |
NO | ||
DIAG (Oracle) DIAG_REP SGNL_ID |
NO | ||
Watchman (Oracle) DIAG_REP SGNL_ID |
NO |
SGNL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNAPSHOT_TYPE_NM |
Base Object | DIAG_REP |
Attribute Name | Snapshot Type Nm |
ColumnName | SNAPSHOT_TYPE_NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Snapshot Type Name: Identifies a list of predefined signal identifers that are to be snapshoted. |
Note |
SNAPSHOT_TYPE_NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SNAPSHOT_TYPE_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
SNAPSHOT_TYPE_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SNAPSHOT_TYPE_NM Security Types |
Name | Current Value |
SNAPSHOT_TYPE_NM Bound Attachments |
Name | Current Value |
SNAPSHOT_TYPE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
SNAPSHOT_TYPE_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Report Snapshot Type Nm |
NO | ||
DIAG (Oracle) DIAG_REP SNAPSHOT_TYPE_NM |
NO | ||
Watchman (Oracle) DIAG_REP SNAPSHOT_TYPE_NM |
NO |
SNAPSHOT_TYPE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNAPSHOT_TYPE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNAPSHOT_TYPE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNAPSHOT_TYPE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PLOT_ID |
Base Object | DIAG_REP |
Attribute Name | Plot Identifier |
ColumnName | PLOT_ID |
Logical Rolename | Plot Identifier |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PLOT_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PLOT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
PLOT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PLOT_ID Security Types |
Name | Current Value |
PLOT_ID Bound Attachments |
Name | Current Value |
PLOT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PLOT_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Diagnostics Report Plot Identifier |
NO | ||
DIAG (Oracle) DIAG_REP PLOT_ID |
NO | ||
Watchman (Oracle) DIAG_REP PLOT_ID |
NO |
PLOT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PLOT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PLOT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PLOT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |