Beam Downtime Accounting: The amount unplanned beam down time grouped by operational category.

Beam Downtime Accounting Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Operation Group Identifier	Operation Group	VARCHAR(10)	NO	Equipment Category Identifier: The unique identifier for a specific equipment category.
Operation Subgroup1 Identifier		VARCHAR(10)	NO	Equipment Subcategory Identifier: The unique identifer for an equipment subcategory.
Downtime Dte	Date	DATE	NO	Date: Date and time to seconds.
Downtime		NUMERIC(3, 1)	NO	Downtime: The amount of beam time down in tenths due to problem that feel within the operation category.
Note	Note	VARCHAR(4000)	YES
Previous Shift Indicator		CHAR(1)	NO	Previous Shift Indicator: Indicates the downtime is a continuation from the previous shift.
Work Order Number		VARCHAR(10)	YES	Work Order Number: Assign a DataStream work order initiated to repair the cause of the downtime to the entry.

Beam Downtime Accounting Keys

Key Name	Key Type	Keys
beam_downtime_acct_pk	PrimaryKey	Operation Group Identifier, Operation Subgroup1 Identifier, Downtime Dte

Beam Downtime Accounting Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Equipment Category	Identifying	One To Zero or More				Operation Group Identifier	NO
Operation Subgroup1	Identifying	One To Zero or More				Operation Group Identifier, Operation Subgroup1 Identifier	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Downtime Timer Accounting Association	Identifying	One To Zero or More					NO

Beam Downtime Accounting Check Constraints

Check Constraint Name

CheckConstraint

Beam Downtime Accounting Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Beam Downtime Accounting Security Types

Name	Current Value

Beam Downtime Accounting Bound Attachments

Name	Current Value

Beam Downtime Accounting Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical OPER.Beam Downtime Accounting	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.BEAM_DOWNTIME_ACCT	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

Beam Downtime Accounting Where Used - Submodel Usage

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

Beam Downtime Accounting Data Movement Rules

Name

Type

Rule Text/Value