Machine Snapshop Signals:  The signal identifers that were snapshoted,

SCORE Snapshot Signal Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Equip Cat Id		VARCHAR(10)	NO
Operation Group Identifier	Operation Group	VARCHAR(10)	NO	Equipment Category Identifier: The unique identifier for a specific equipment category.
Mod Dte	Date	DATE	NO	Date: Date and time to seconds.
RB Sgnl Id		VARCHAR(75)	NO
Set Pt Sgnl Id		VARCHAR(75)	NO
RB Sngl Id	Signal Id	VARCHAR(75)	YES	Readback Signal Identifier:
Set Pt Sgnl Val		VARCHAR(15)	YES	Set Point Signal Value: The values for the signal at the given timestamp. Implemented as an Oracle varray.
RB Sgnl Val		VARCHAR(15)	YES	Readback Signal Value: In some rare cases it will be necessary to restore the readback value into the PV, as opposed to the PV value at time of save.

SCORE Snapshot Signal Keys

Key Name	Key Type	Keys
PK_SCORE_SNAPSHOT_SGNL	PrimaryKey	Equip Cat Id, Operation Group Identifier, Mod Dte, RB Sgnl Id, Set Pt Sgnl Id

SCORE Snapshot Signal Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
SCORE Snapshot Group	Identifying	One To Zero or More				Equip Cat Id, Mod Dte	NO
SCORE Snapshot Group Signal	Identifying	One To Zero or More				Operation Group Identifier, RB Sgnl Id, Set Pt Sgnl Id	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

SCORE Snapshot Signal Check Constraints

Check Constraint Name

CheckConstraint

SCORE Snapshot Signal Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

SCORE Snapshot Signal Security Types

Name	Current Value

SCORE Snapshot Signal Bound Attachments

Name	Current Value

SCORE Snapshot Signal Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical EPICS.SCORE Snapshot Signal	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) EPICS.SCORE_SNAPSHOT_SGNL	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) Does Not Exist	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) SCORE_SNAPSHOT_SGNL	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

SCORE Snapshot Signal Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	EPICS
Logical	SCORE
EPICS (Oracle)	Main Model
SCORE (Oracle)	Main Model

SCORE Snapshot Signal Data Movement Rules

Name

Type

Rule Text/Value