Magnetic Spline:  This table is implemented as a nested table within the Oracle database.

Magnet Spline Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Equip Id	Asset Identifier	VARCHAR(30)	NO	Equipment Identifier: The SNS barcode number used to uniquely identify equipment.
Fld_Cur_Func_Ind	Indicator	CHAR(1)	NO	Field Current Function Indicator: The spline is for a fit of: (A) field as a function of current or (B) current as a function of field.
Coefs	Magnet Large Value	NUMERIC(14, 10)	YES	Cooeficient
X_Pt	Magnet Large Value	NUMERIC(14, 10)	YES
Y_Pt	Magnet Large Value	NUMERIC(14, 10)	YES
Max Cur	Standard Number	NUMERIC(14, 6)	YES	Maximum Current: The maximum operation current for the magnet.
Min Cur	Standard Number	NUMERIC(14, 6)	YES	Minimum Current: The minimum field set for the magnet.
Max Fld	Standard Number	NUMERIC(14, 6)	YES	Maximum Field: The maximum field set for the magnet.
Min Fld	Standard Number	NUMERIC(14, 6)	YES	Minimum Field:
File Name	File Name	VARCHAR(255)	YES	File name: The file name for the spline data.
Dir Nm		VARCHAR(255)	YES	Directory Name: The directory where the spline file is exported to.
Modify Date	Modify Date	DATE	NO	Modify Date: The date the entity values were were created or modified.
Mod By Uid	Mod By Uid	VARCHAR(64)	NO	Modified by Userid: The database userid of the person who inserted or update a record in the table.

Magnet Spline Keys

Key Name	Key Type	Keys
mag_spline_pk	PrimaryKey	Equip Id, Fld_Cur_Func_Ind

Magnet Spline Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Magnet	Identifying	One To Zero or More				Equip Id	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Magnet Spline Check Constraints

Check Constraint Name

CheckConstraint

Magnet Spline Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Magnet Spline Security Types

Name	Current Value

Magnet Spline Bound Attachments

Name	Current Value

Magnet Spline Where Used - Model Usage

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

Magnet Spline Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Magnet
Logical	Power Supply

Magnet Spline Data Movement Rules

Name

Type

Rule Text/Value