Chipmunk:

Chipmunk Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Equip Id	Asset Identifier	VARCHAR(30)	NO	Asset Identifier: The Datastream/Infor asset identifier also often referred to as the Barcode Id.
Instl Dte	Date	DATE	NO	Date: Date and time to seconds.
Chan Nbr		CHAR(2)	NO	Channel Number: The channel the chipmunk device is talking to the interface box on.
Req Nbr		VARCHAR(50)	NO	Requisition Number:
Bckgrnd Rt		CHAR(3)	NO	Background Rate: The Chipmunk has a small radioactive check source that causes the device to produce a constant signal (outputs 66 to 125 pulses per 1000 seconds). The rate varies so the background rate is measured for each Chipmunk (i.e. 79 pulses per 1000 seconds). The units are "pulses per 1000 seconds".
Trip Lvl		CHAR(2)	NO	Trip Level: The radiation level in mrem/hr that will shut off (trip) the accelerator.
Alarm Lvl		CHAR(3)	NO	Alarm Level: The radiation level in mrem/hr that will activate the local alarm beacons.
Qual Fac		CHAR(3)	NO	Quality Factor: A multiplication factor to increase the output signal of the Chipmunk to account for the quality factor of a mixed radiation field (gamma and neutrons). Acceptable values are 1, 2.5, 5 and 10.
Loc		VARCHAR(50)	NO	Location: The location of the Chipmunk Alarm for this requistion. The location is dynamic and as such cannot have a predefinied list of locations.
EPICS Loc	Default Text	VARCHAR(50)	NO	EPICS Location: A generic location from an EPICS viewpoint not constrained to a formal system/subsystem.
Interface Box	Device Id	VARCHAR(50)	NO	Interface Box: Receives signals from the chipmunk monitor and routes them to the ioc.
Decomm Dte		DATE	YES	Decommission Date:

Chipmunk Keys

Key Name	Key Type	Keys
PK319	PrimaryKey	Equip Id, Instl Dte

Chipmunk Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Chipmunk Check Constraints

Check Constraint Name

CheckConstraint

Chipmunk Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Chipmunk Security Types

Name	Current Value

Chipmunk Bound Attachments

Name	Current Value

Chipmunk Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical EQUIP.Chipmunk	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

Chipmunk Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model

Chipmunk Data Movement Rules

Name

Type

Rule Text/Value