Magnet Device:

Magnet Device

Magnet Device Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Device Identifer	Device Id	VARCHAR(50)	NO	The unique identifier for the device. It is represented in the form of a bar code. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
Path Lngth		NUMERIC(12, 6)	YES	Path Length: The reference trajectory path length in the element (m).
Polarity	Polarity	CHAR(1)	YES	Polarity: Indicates if wiring is connected to the positive or negative pole.
Dipole Exit Pole Curv		NUMERIC(12, 6)	YES	Dipole Exit Pole Curvature
Dipole Entr Rotation Angle		NUMERIC(12, 6)	YES	Dipole Entrance Rotation Angle
Dipole Exit Rotation Angle		NUMERIC(12, 6)	YES	Dipole Exit Rotation Angle
Dipole Entr Pole Curv		NUMERIC(12, 6)	YES	Dipole Entrance Pole Curve
Dipole Bend Angle		NUMERIC(12, 6)	YES	Dipole Bend Angle
Dipole Quad Term		NUMERIC(12, 7)	YES	Dipole Quadrupole Terminal: The quadrupole terminal of the field (T/m).
PM Quad Strength	Magnet Default	NUMERIC(12, 6)	YES	PM Quadrupole Strength
Beam Orient Ind	Beam Orient Ind	NUMERIC(1, 0)	YES	Beam Orientation: Indicates the direction the magnet faces along the beamline. 1 if magnet leads are on the beam entrance end; -1 if leads are on the beam exit end.
Pos Term Ind	Pos Term Ind	NUMERIC(1, 0)	YES	Positive Terminal Inidcator: Tthe terminal number that the positive lead is connected to (allowed values = 1 or 2).
Term Lead Plus		VARCHAR(12)	YES	Terminal Lead Plus: The label for the attachment of positive lead from the power supply.
Term Lead Minus		VARCHAR(12)	YES	Terminal Lead Minus: The label for the attachment of negative lead from the power supply.
Trim Term Lead Plus		VARCHAR(12)	YES	Trim Terminal Lead Plus: The terminal label the positive lead of the trim winding should attach to.
Trim Term Lead Minus		VARCHAR(12)	YES	Trim Terminal Lead Minus: The terminal label the negative lead of the trim winding should attach to.
Mod By Uid	Userid	VARCHAR(64)	YES	Modify By Userid: The userid of the person who last changed the Magnet record.
Mod Dte		DATE	YES	Modify Date: Date and time when this row was last modified
V Reg		NUMERIC(12, 6)	YES	Voltage Regulation: Stability in PPM of full scale. (Maximum voltage)
I Reg		NUMERIC(12, 6)	YES	Current Regulation: Stability in PPM of full scale. (Maximum voltage)
Accur		NUMERIC(12, 6)	YES	Accuracy: Linearity accuracy of the current setting (PPM of full scale).
Max V		NUMERIC(12, 6)	YES	Maximum Voltage: The maximum Voltage for "n" supplies of this magnet(V).
Min V		NUMERIC(12, 6)	YES	Minimum Voltage: The minimum Voltage for "n" supplies for this magnet(V).
Max I		NUMERIC(12, 6)	YES	Maximum Current: The maximum current for this magnet.
Min I		NUMERIC(12, 6)	YES	Minimum Current: The minimum current for this magnet.
PS Dvc Id	Device Id	VARCHAR(50)	YES	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.

Magnet Device Keys

Key Name	Key Type	Keys
mag_dvc_pk	PrimaryKey	Device Identifer

Magnet Device Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Device	Non-Identifying	Zero or One to Zero or More				PS Dvc Id	YES
Device	Identifying	One To Zero or More				Device Identifer	YES

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Magnet Device Check Constraints

Check Constraint Name

CheckConstraint

Magnet Device Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Magnet Device Security Types

Name	Current Value

Magnet Device Bound Attachments

Name	Current Value

Magnet Device Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical EPICS.Magnet Device	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.MAG_DVC	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) 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) EPICS.MAG_DVC	NO
XF_ADMIN (Oracle) Does Not Exist	NO

Magnet Device Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	EPICS
Logical	Power Supply
Logical	XAL Optics
EPICS (Oracle)	Main Model
XAL_OPTICS (Oracle)	Main Model

Magnet Device Data Movement Rules

Name

Type

Rule Text/Value