Device Identifer |
Base Entity | Device Outage |
Attribute Name | Device Identifer |
Logical Rolename | |
ColumnName | DVC_ID |
RoleName | |
Domain | Device Id |
Logical Only | NO |
Definition | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
Note |
Device Identifer Logical Attribute Properties |
Logical Attribute Name | Device Identifer |
Datatype | VARCHAR(50) |
Nullable | NO |
Device Identifer Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Device Identifer Security Types |
Name | Current Value |
Device Identifer Bound Attachments |
Name | Current Value |
Device Identifer Data Movement Rules |
Name | Type | Rule Text/Value |
Device Identifer Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Device Identifer |
NO | ||
OPER (Oracle) DVC_OUTAGE DVC_ID |
NO |
Device Identifer Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Device Identifer Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Device Identifer Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Device Identifer Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outage Dte |
Base Entity | Device Outage |
Attribute Name | Outage Dte |
Logical Rolename | |
ColumnName | OUTAGE_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Outage Dte Logical Attribute Properties |
Logical Attribute Name | Outage Dte |
Datatype | DATE |
Nullable | NO |
Outage Dte Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Outage Dte Security Types |
Name | Current Value |
Outage Dte Bound Attachments |
Name | Current Value |
Outage Dte Data Movement Rules |
Name | Type | Rule Text/Value |
Outage Dte Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Outage Dte |
NO | ||
OPER (Oracle) DVC_OUTAGE OUTAGE_DTE |
NO |
Outage Dte Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outage Dte Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outage Dte Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outage Dte Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Canceled Indicator |
Base Entity | Device Outage |
Attribute Name | Canceled Indicator |
Logical Rolename | |
ColumnName | CAN_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Cancelled Indicator: Indicates that the scheduled device outage was canceled. |
Note |
Canceled Indicator Logical Attribute Properties |
Logical Attribute Name | Canceled Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Canceled Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Canceled 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 |
Canceled Indicator Security Types |
Name | Current Value |
Canceled Indicator Bound Attachments |
Name | Current Value |
Canceled Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Canceled Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Canceled Indicator |
NO | ||
OPER (Oracle) DVC_OUTAGE CAN_IND |
NO |
Canceled Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Canceled Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Canceled Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Canceled Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Proj Outage |
Base Entity | Device Outage |
Attribute Name | Proj Outage |
Logical Rolename | |
ColumnName | PROJ_OUTAGE |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Projected Outage: The projected amount of time in hours and tenths the device will be unavailable. |
Note |
Proj Outage Logical Attribute Properties |
Logical Attribute Name | Proj Outage |
Datatype | NUMERIC(2, 1) |
Nullable | NO |
Proj Outage Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Proj Outage Security Types |
Name | Current Value |
Proj Outage Bound Attachments |
Name | Current Value |
Proj Outage Data Movement Rules |
Name | Type | Rule Text/Value |
Proj Outage Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Proj Outage |
NO | ||
OPER (Oracle) DVC_OUTAGE PROJ_OUTAGE |
NO |
Proj Outage Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proj Outage Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proj Outage Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Proj Outage Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Act Outage |
Base Entity | Device Outage |
Attribute Name | Act Outage |
Logical Rolename | |
ColumnName | ACT_OUTAGE |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Actual Outage: The actualk time in hours and tenths that the device was unavailable. |
Note |
Act Outage Logical Attribute Properties |
Logical Attribute Name | Act Outage |
Datatype | NUMERIC(2, 1) |
Nullable | YES |
Act Outage Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Act Outage Security Types |
Name | Current Value |
Act Outage Bound Attachments |
Name | Current Value |
Act Outage Data Movement Rules |
Name | Type | Rule Text/Value |
Act Outage Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Act Outage |
NO | ||
OPER (Oracle) DVC_OUTAGE ACT_OUTAGE |
NO |
Act Outage Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Act Outage Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Act Outage Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Act Outage Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment |
Base Entity | Device Outage |
Attribute Name | Comment |
Logical Rolename | |
ColumnName | CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Comment Logical Attribute Properties |
Logical Attribute Name | Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Comment Security Types |
Name | Current Value |
Comment Bound Attachments |
Name | Current Value |
Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Comment |
NO | ||
OPER (Oracle) DVC_OUTAGE CMNT |
NO |
Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By Badge Number |
Base Entity | Device Outage |
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 Device Outage Modified By Badge Number |
NO | ||
OPER (Oracle) DVC_OUTAGE 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 | Device Outage |
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 Device Outage Modify Date |
NO | ||
OPER (Oracle) DVC_OUTAGE 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 |