Magnet Check:

Magnet Checklist 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.
TF1_0M	Indicator	CHAR(1)	NO	Transfer Function 1.0 Measured Indicator: The transfer function at 1.0 GeV measured indicator.
TF1_0M Cmnt	Comment	VARCHAR(2000)	YES	Transfer Function 1.0 Measured Comment: The transfer function at 1.0 GeV measured comment.
TF1_3M	Indicator	CHAR(1)	NO	Transfer Function 1.3 Measured Indicator: The transfer function at 1.3 GeV measured indicator.
TF1_3M Cmnt	Comment	VARCHAR(2000)	YES	Transfer Function 1.3 Measured Commnent: The transfer function at 1.3 GeV measured comment.
TF Ind	Indicator	CHAR(1)	NO	Transfer Function Indicator: Indicates whether the integral transfer function is satisfactory.
TF Cmnt	Comment	VARCHAR(2000)	YES	Transfer Function Comment: A free form text field relating to the Transfer Function Indicator.
Mul Ind	Indicator	CHAR(1)	NO	Magnetic Harmonic Indicator
Mul Cmnt	Comment	VARCHAR(2000)	YES	Magnetic Harmonic Comment
Data Ind	Indicator	CHAR(1)	NO	Data Indicator: Indicates if the data was properly transferred to the database tables.
Data Cmnt	Comment	VARCHAR(2000)	YES	Data Comment: A free form text field relating to the data ind field.
Mech Ind	Indicator	CHAR(1)	NO	Mechanical Indicator: Used to indicate if the mechanical test is complete.
Mech Cmnt	Comment	VARCHAR(2000)	YES	Mechanical Comment: A free form text field relating to the mechanical indicator.
Elec Ind	Indicator	CHAR(1)	NO	Electrical Indicator: Used to indicate if the electrical test is complete.
Elec Cmnt	Comment	VARCHAR(2000)	YES	Electrical Comment: A free form text field relating to the Electrical Indicator.
Shim Ind	Indicator	CHAR(1)	NO	Shim Indicator: Used to indicated if the magnet is shimmed.
Shim Cmnt	Comment	VARCHAR(2000)	YES	Shimmed Comment: A free form text field relating to the Shimmed Indicator.
Sort Ind	Indicator	CHAR(1)	NO	Sort Indicator: Used to indicate if the magnetic check is sorted.
Sort Cmnt	Comment	VARCHAR(2000)	YES	Sort Comment: A free form text field relating to the Sort Indicator.
Surv Ind	Indicator	CHAR(1)	NO	Survey Indicator: Indicates if the survey is complete.
Surv Cmnt	Comment	VARCHAR(2000)	YES	Survey Comment: A free from text field relating to the Sort Indicator.
Doc Ind	Indicator	CHAR(1)	NO	Documentation Indicator: Use to indicated if the documentation is complete.
Doc Cmnt	Comment	VARCHAR(2000)	YES	Documentation Comment: A free form text field relating to the documentatiion indicator.
HCA Ind	Indicator	CHAR(1)	NO	Half Cell Assigned Indicator: Used to indicated if the half-cell is assigned.
HCA Cmnt	Comment	VARCHAR(2000)	YES	Half-Cell Comment: A free form text field relating to the Half-Cell Indicator.
Sumry Ind	Indicator	CHAR(1)	NO	Survey Indicator: Used to indicate if the survey is complete.
Sumry Cmnt	Comment	VARCHAR(2000)	YES	Survey Comment: A free form text field relating to the Survey Indicator.
Meas Data Ind	Indicator	CHAR(1)	NO	Measurement Data Indicator. Used to indicate if the data was sent to SNS.
Meas Data Cmnt	Comment	VARCHAR(2000)	YES	Measurement Data Comment: A free from text field related to the Measurement Data Indicator.
Mdl IO Ind	Indicator	CHAR(1)	NO	Model Input/Output Indicator: Indicates if the magnet model input and output information was sent to SNS.
Mdl IO Cmnt	Comment	VARCHAR(2000)	YES	Model Input/Output Comment: A free form text field relating to the Model Input/Output Indicator.
Modify Date	Modify Date	DATE	NO	Modify Date: The date the current entry was made.

Magnet Checklist Keys

Key Name	Key Type	Keys
mag_chk_pk	PrimaryKey	Equip Id

Magnet Checklist Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Magnet Checklist Check Constraints

Check Constraint Name

CheckConstraint

Magnet Checklist Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Magnet Checklist Security Types

Name	Current Value

Magnet Checklist Bound Attachments

Name	Current Value

Magnet Checklist Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical MAGNET.Magnet Checklist	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 Checklist Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Magnet

Magnet Checklist Data Movement Rules

Name

Type

Rule Text/Value