Device Outage: Device that will be taken out of sevice along with their expected duration.

Device Outage Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Device Identifer	Device Id	VARCHAR(50)	NO	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.
Outage Dte	Date	DATE	NO	Date: Date and time to seconds.
Canceled Indicator	Indicator	CHAR(1)	NO	Cancelled Indicator: Indicates that the scheduled device outage was canceled.
Proj Outage		NUMERIC(2, 1)	NO	Projected Outage: The projected amount of time in hours and tenths the device will be unavailable.
Act Outage		NUMERIC(2, 1)	YES	Actual Outage: The actualk time in hours and tenths that the device was unavailable.
Comment	Comment	VARCHAR(2000)	YES	Comment: General comments.
Modified By Badge Number	Modied By Badge Number	VARCHAR(10)	NO	Modified by Badge Number: The ORNL badge number of the person who inserted or update a record in the table.
Modify Date	Modify Date	DATE	NO	Modify Date: The date the entity values were were created or modified.

Device Outage Keys

Key Name	Key Type	Keys
PK_DVC_OUT	PrimaryKey	Device Identifer, Outage Dte

Device Outage Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Device	Identifying	One To Zero or More				Device Identifer	YES

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Device Outage Affected Devices	Identifying	One To Zero or More					NO

Device Outage Check Constraints

Check Constraint Name

CheckConstraint

Device Outage Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Device Outage Security Types

Name	Current Value

Device Outage Bound Attachments

Name	Current Value

Device Outage Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical OPER.Device Outage	NO
ALARM_MYSQL (MySQL) Does Not Exist	NO
ALARM_ORACLE (Oracle) Does Not Exist	NO
BICS (Oracle) Does Not Exist	NO
BLM (Oracle) Does Not Exist	NO
BYPASS_REQ (Oracle) Does Not Exist	NO
CHAN_ARCH (Oracle) Does Not Exist	NO
CNMS_PRPSL (Oracle) Does Not Exist	NO
DIAG (Oracle) Does Not Exist	NO
DIAG_MPS (Oracle) Does Not Exist	NO
ENGA (Oracle) Does Not Exist	NO
EPICS (Oracle) Does Not Exist	NO
EQUIP (Oracle) Does Not Exist	NO
EXPRESS (Oracle) Does Not Exist	NO
ICS_SFTW_APPL (Oracle) Does Not Exist	NO
INSTR (Oracle) Does Not Exist	NO
Instrument Logbook (Oracle) Does Not Exist	NO
INVT (Oracle) Does Not Exist	NO
IONSRC (Oracle) Does Not Exist	NO
IONSRC1 (Oracle) Does Not Exist	NO
IPTSv5 (Oracle) Does Not Exist	NO
IRMISBase (Oracle) Does Not Exist	NO
Logbook (Oracle) Does Not Exist	NO
Magnet (Oracle) Does Not Exist	NO
MPS (Oracle) Does Not Exist	NO
NS_OPER (Oracle) Does Not Exist	NO
OPER (Oracle) OPER.DVC_OUTAGE	NO
PART (Oracle) Does Not Exist	NO
PRINT (Oracle) Does Not Exist	NO
PROC (Oracle) Does Not Exist	NO
PRPSL (Oracle) Does Not Exist	NO
PUBL (Oracle) Does Not Exist	NO
PUBL_V1 (Oracle) Does Not Exist	NO
PV_LOGGER (Oracle) Does Not Exist	NO
SCORE (Oracle) Does Not Exist	NO
SICAT (Oracle) Does Not Exist	NO
SMPL (Oracle) Does Not Exist	NO
SMPLACT (Oracle) Does Not Exist	NO
SURVEY (Oracle) Does Not Exist	NO
Watchman (Oracle) Does Not Exist	NO
XAL_OPTICS (Oracle) Does Not Exist	NO
XF_ADMIN (Oracle) Does Not Exist	NO

Device Outage Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
OPER (Oracle)	Main Model

Device Outage Data Movement Rules

Name

Type

Rule Text/Value