Experiment Sample 
EntityType  Dependent 
Logical Entity Name  Experiment Sample 
Default Table Name  EXPT_SMPL 
Logical Only  NO 
Owner  PRPSL 
Definition  
Experiment Sample: Information on the sample material that will be use in the experiment.
 
Note 
 

Experiment Sample Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Proposal Identifier(PK)(FK)    NUMERIC(10, 0)  NO 
 
Submission Number(PK)(FK)  Identifier  NUMERIC(38, 0)  NO 
 
Sample Identifier(PK)    NUMERIC(10, 0)  NO  
Sample Identifier: A sequential numeric identifier for the proposal samples.
 
Sample Name  Name  VARCHAR(120)  NO  
Name: A long description name usually accompanied by an abbreviated code.
 
Sample Description  Description  VARCHAR(2000)  NO  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Sample Formula    VARCHAR(2000)  YES  
Sample Formula: Any sensible chemical formula.
 
Sample Length    NUMERIC(7, 2)  YES  
Sample Length: Length of sample in centimeters.
 
Sample Width    NUMERIC(7, 2)  YES  
Sample Width: Width of sample in centimeters.
 
Sample Height    NUMERIC(7, 2)  YES  
Sample Height: Height of sample in centimeters.
 
Sample Mass    NUMERIC(14, 4)  YES  
Sample Mass: Mass of sample in grams.
 
Sample Total Number    NUMERIC(5, 0)  YES  
Sample Total Number: Total number of samples for this description.
 
Equipment    VARCHAR(4000)  YES  
Equipment: Experimenter supplied equipment or sample environments.
 
Local Equipment    VARCHAR(4000)  YES  
Local Equipment: On-site equipment needed for the experiment.
 
Length Unit Identifier(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Mass Unit Identifier(FK)    VARCHAR(3)  YES  
Mass Unit Identifier: Abbreviated unit of mass.
 
State Id(FK)    VARCHAR(6)  YES  
State Identifier: The material state.
 
Temperature    VARCHAR(25)  YES  
Temperature: Temperature of which the sample should be mesured. Currently only used by Mail-In BL-11A proposals.
 
Temperature Unit Identifier(FK)    CHAR(1)  YES  
Unit Identifier: Abbreviated unit of mass.
 
Sample Descriptor Identifier(FK)    VARCHAR(5)  YES 
 
Sample Containment    VARCHAR(2000)  YES 
 
Irradiation History    VARCHAR(2000)  YES 
 
Sample Disposition    VARCHAR(2000)  YES 
 
Minor Modification Notes  Note  VARCHAR(4000)  YES 
 
Sample Density    NUMERIC(7, 2)  YES 
 
Container Identifier  Identifier  VARCHAR(25)  YES 
 
Single Crystal Dimension A    NUMERIC(10, 2)  YES 
 
Single Crystal Dimension B    NUMERIC(10, 2)  YES 
 
Single Crystal Dimension C    NUMERIC(10, 2)  YES 
 
Single Crystal Dimension V    NUMERIC(10, 2)  YES 
 
Single Crystal Dimension Alpha    NUMERIC(10, 2)  YES 
 
Single Crystal Dimension Beta    NUMERIC(10, 2)  YES 
 
Single Crystal Dimension Gamma    NUMERIC(10, 2)  YES 
 
Single Crystal Dimension Space Group    VARCHAR(8)  YES 
 
Modify Date  Date  DATE  YES 
 
Confirm Date  Date  DATE  YES 
 
Neutron Beam Indicator  Indicator  CHAR(1)  YES 
 
Justification Comment  Comment  VARCHAR(2000)  YES 
 
Single Crystal Atom Unit Number    INTEGER  YES 
 
Single Crystal Skip Indicator  Indicator  CHAR(1)  NO 
 
Approve Identifer(FK)  Identifier  VARCHAR(25)  YES 
 
Thin Film Shape and Surface    VARCHAR(50)  YES 
 
Delete Indicator  Indicator  CHAR(1)  NO 
 
Crystal Exist Indicator  Indicator  CHAR(1)  YES 
 
Crystal Alignment Needed Indicator  Indicator  CHAR(1)  YES 
 
Data Minimum    NUMERIC(38, 2)  YES  
Data Miniimum: The low value of the data values to be captured on the sample. (Currently used only for BL-11A Mail-In)
 
Data Maximum    NUMERIC(38, 2)  YES  
Data Maximum: The high value of the data values to be captured on the sample. (Currently used only for BL-11A Mail-In)
 
Can Size    VARCHAR(25)  YES  
Can Size: The size of can requested for BL-11A Mail-In proposals.
 
Return Shipping Address    VARCHAR(1000)  YES  
Return Shipping Address: The sample return shipping address for mail-in proposals.
 

Experiment Sample Keys 
Key Name  Key Type  Keys 
PK_EXPT_SMPL  PrimaryKey  Proposal Identifier, Submission Number, Sample Identifier 
EXPT_SMPL_IND1  Inversion Entry  Approve Identifer 

Experiment Sample Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Unit of Length  Non-Identifying  Zero or One to Zero or More        Length Unit Identifier  NO 
Unit of Mass  Non-Identifying  Zero or One to Zero or More        Mass Unit Identifier  NO 
Material State  Non-Identifying  Zero or One to Zero or More        State Id  NO 
Proposal Submission  Identifying  One To Zero or More        Proposal Identifier, Submission Number  NO 
Sample Descriptor  Non-Identifying  Zero or One to Zero or More        Sample Descriptor Identifier  NO 
Unit of Temperature  Non-Identifying  Zero or One to Zero or More        Temperature Unit Identifier  NO 
Experiment Sample Approval Code  Non-Identifying  Zero or One to Zero or More        Approve Identifer  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Experiment Sample Form Association  Identifying  One To Zero or More          NO 
Experiment Sample Hazard Association  Identifying  One To Zero or More          NO 
Experiment Sample Instrument Association  Identifying  One To Zero or More          NO 
Experiment Sample Special Requirement Association  Identifying  One To Zero or More          NO 
Experiment Sample Sample Environment Association  Identifying  One To Zero or More          NO 
Experiment Sample Sample Safety Association  Identifying  One To Zero or More          NO 
Experiment Sample Sample Condition Association  Identifying  One To Zero or More          NO 

Experiment Sample Check Constraints 
Check Constraint Name  CheckConstraint 

Experiment Sample Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
PRPSL_USER  Role  ALTER  Revoke  NO  NO 
PRPSL_USER  Role  DELETE  Grant  NO  NO 
PRPSL_USER  Role  INSERT  Grant  NO  NO 
PRPSL_USER  Role  REFERENCES  Revoke  NO  NO 
PRPSL_USER  Role  SELECT  Grant  NO  NO 
PRPSL_USER  Role  UPDATE  Grant  NO  NO 
Experiment Sample Security Types 
Name  Current Value 

Experiment Sample Bound Attachments 
Name  Current Value 

Experiment Sample Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
PRPSL.Experiment Sample 		 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)
PRPSL.EXPT_SMPL 		 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)
PRPSL.EXPT_SMPL 		 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 Sample Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Integrated Proposal Tracking System 
IPTSv5 (Oracle)  Main Model 
PRPSL (Oracle)  Main Model 

Experiment Sample Data Movement Rules 
Name  Type  Rule Text/Value