Experiment Resource 
EntityType  Independent 
Logical Entity Name  Experiment Resource 
Default Table Name  EXPT_RSRC 
Logical Only  NO 
Owner  EXPRESS 
Definition  
Experiment Resource: Pool of resources used in the operation of a beam line or laboratory and for the execution of an approved experiment proposal.
 
Note 
 

Experiment Resource Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Experiment Resource Identifier(PK)    VARCHAR(50)  NO 
 
Status Identifier(FK)    VARCHAR(20)  NO 
 
Experiment Management System Resource Identifier    INTEGER  YES 
 
Resource Name  Name  VARCHAR(120)  NO  
Name: A long description name usually accompanied by an abbreviated code.
 
Experiment Resource Type Identifier(FK)    VARCHAR(50)  NO 
 
Experiment Resource Subtype Identifer(FK)    VARCHAR(50)  YES 
 
Next Available Date  Date  DATE  YES  
Next Available Date: Time when the equipment is expected to be available for a new commitment.
 
Uniform Resource Locator  URL  VARCHAR(2048)  YES  
Universal Resource Locator: The global address of documents and other resources on the web. In this case the URL to the specifications of the equipment.
 
Restore Time    NUMERIC(2, 0)  YES  
Restore Time: The typical amount of time in hours it takes to restore the equipment back to its base configuration.
 
Restore Time Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Setup Time    NUMERIC(2, 0)  YES  
Setup Time: The typical amount of time in hours it takes to setup the equipment.
 
Setup Time Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Breakdown Time    NUMERIC(2, 0)  YES 
 
Breakdown Time Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Availibility    VARCHAR(50)  YES  
Operating Schedule: The normal operating schedule in day and hours formatted as follows.



M T W T F | 8:00 - 16:00
 
Maximum Allocation Percentage    NUMERIC(3, 0)  YES 
 
Temperature Minimum    VARCHAR(5)  YES 
 
Temperature Maximum    VARCHAR(5)  YES 
 
Temperature Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Pressure Minimum    VARCHAR(5)  YES 
 
Pressure Maximum    VARCHAR(5)  YES 
 
Pressure Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Cell Size Height    VARCHAR(10)  YES 
 
Cell Size Diameter    VARCHAR(50)  YES 
 
Cell Size Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Sample Space Height    VARCHAR(50)  YES 
 
Sample Space Diameter    VARCHAR(20)  YES 
 
Sample Space Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Bore Size Height    VARCHAR(50)  YES 
 
Bore Size Diameter    VARCHAR(50)  YES 
 
Bore Size Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Interface Connection  Description  VARCHAR(255)  YES  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Distance Interface Beam Center  Description  VARCHAR(255)  YES  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Distance Interface Beam Center Adjustment    VARCHAR(25)  YES 
 
Distance Interface Beam Center Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Distance Stick Beam Center  Description  VARCHAR(255)  YES  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Distance Stick Beam Center Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Tail Distance Beam Center    VARCHAR(50)  YES 
 
Tail Distance Center Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Beam Center to Sample Space Bottom    VARCHAR(10)  YES 
 
Beam Center Bottom Unit of Measure(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Comment  Comment  VARCHAR(2000)  YES  
Comment:  General comments.
 
Manufacturer Identifier(FK)  Identifier  VARCHAR(30)  YES 
 
Model  Machine Mode Ind  BINARY(1)  YES 
 
Manufacturer Serial Number    VARCHAR(50)  YES 
 
Cost    NUMERIC(12, 2)  YES 
 
Commission Date  Date  DATE  NO  
Date: Date and time to seconds.
 
Revision Date  Date  DATE  NO  
Date: Date and time to seconds.
 
View Code    CHAR(1)  NO 
 
DataStream Assest Identifier  Identifier  VARCHAR(30)  YES 
 
Master Equipment List Identifier  Identifier  VARCHAR(75)  YES  
Master Equipment List Identifier: The id assigned to the resource in HFIR's Master Equipment List system.
 
ORNL Property Number    VARCHAR(10)  YES 
 
Facility Identifier(FK)    VARCHAR(10)  NO  
Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place.
 
Location Identifier(FK)  Identifier  VARCHAR(50)  YES 
 
Quantity  Quantity  INTEGER  YES 
 
Approval Indicator  Indicator  CHAR(1)  NO  
Approval Indicator: Indicates if the resource needs approval to be scheduled.
 
Drawing Number    VARCHAR(50)  YES  
Drawing Number: NScD drawing number.
 
Catalog Indicator  Indicator  CHAR(1)  NO  
Catalog Indicator: Indicates the resource should be treated as a catalog item. Catalog items are low support required, generally available and easily replenishable.
 
Electrical Certification Identifier(FK)  Identifier  VARCHAR(25)  YES 
 
Website Description  Description  VARCHAR(2000)  YES  
Website Description: Text describing the experiment resource which will display on the public website.
 

Experiment Resource Keys 
Key Name  Key Type  Keys 
PK_EXPT_RSRC  PrimaryKey  Experiment Resource Identifier 

Experiment Resource Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Unit of Measure  Non-Identifying  Zero or One to Zero or More      fk_beam_cen_btm_to_uom  Beam Center Bottom Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Bore Size Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Breakdown Time Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Cell Size Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Distance Interface Beam Center Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Distance Stick Beam Center Unit of Measure  NO 
Experiment Resource Facility  Non-Identifying  One To Zero or More        Facility Identifier  NO 
Experiment Resource Subtype  Non-Identifying  Zero or One to Zero or More        Experiment Resource Type Identifier, Experiment Resource Subtype Identifer, Facility Identifier  NO 
Experiment Resource Status  Non-Identifying  One To Zero or More        Status Identifier  NO 
Electrical Certification  Non-Identifying  Zero or One to Zero or More        Electrical Certification Identifier  NO 
Experiment Resource Location  Non-Identifying  Zero or One to Zero or More        Facility Identifier, Location Identifier  NO 
Experiment Resource Type  Non-Identifying  One To Zero or More        Experiment Resource Type Identifier, Facility Identifier  YES 
Experiment Resource Manufacturer  Non-Identifying  Zero or One to Zero or More        Manufacturer Identifier  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Pressure Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Restore Time Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Setup Time Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Sample Space Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Tail Distance Center Unit of Measure  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Temperature Unit of Measure  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Experiment Resource Association  Identifying  One To Zero or More          NO 
Experiment Resource Association  Identifying  One To Zero or More          NO 
Experiment Resource Attachment Association  Identifying  One To Zero or More          NO 
Experiment Resource Instrument Association  Identifying  One To Zero or More          NO 
Experiment Resource Log  Identifying  One To Zero or More          NO 
Experiment Resource Maintenance Schedule  Identifying  One To Zero or More          NO 
Experiment Resource Personnel Association  Identifying  One To Zero or More          NO 
Experiment Resource Schedule  Identifying  One To Zero or More          NO 
Experiment Resource Status History  Identifying  One To Zero or More          NO 
Experiment Resource Training  Identifying  One To Zero or More          NO 
Experiment Resource Maintenance  Identifying  One To Zero or More          NO 
Experiment Resource Unavailable  Identifying  One To Zero or More          NO 
Resource Set Temporary  Identifying  One To Zero or More          NO 

Experiment Resource Check Constraints 
Check Constraint Name  CheckConstraint 

Experiment Resource Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
Experiment Resource Security Types 
Name  Current Value 

Experiment Resource Bound Attachments 
Name  Current Value 

Experiment Resource Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
EXPRESS.Experiment Resource 		 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)
EXPRESS.EXPT_RSRC 		 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       

Experiment Resource Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Express 
EXPRESS (Oracle)  Main Model 

Experiment Resource Data Movement Rules 
Name  Type  Rule Text/Value