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

SMPL.Sample Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Sample Identifier(PK)  Identifier  NUMERIC(38, 0)  NO 
 
Family Sample Identifier(FK)  Identifier  NUMERIC(38, 0)  YES 
 
Sample Type Indicator  Indicator  CHAR(1)  NO 
 
Sample Name  Name  VARCHAR(120)  NO  
Name: A long description name usually accompanied by an abbreviated code.
 
Sample Formula    VARCHAR(2000)  YES  
Sample Formula: Any sensible chemical formula.
 
Sample Description  Description  VARCHAR(2000)  NO  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Volume Weight Amount    NUMERIC(8, 2)  NO 
 
Mass Unit Identifier(FK)    VARCHAR(3)  NO  
Unit Identifier: Abbreviated unit of mass.
 
Sample Height    VARCHAR(5)  YES 
 
Length Unit Identifier(FK)    VARCHAR(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
Neutron Beam Indicator  Indicator  CHAR(1)  NO 
 
ControlArea Identifier(FK)  Identifier  NUMERIC(38, 0)  NO 
 
SubArea Identifier(FK)  Identifier  NUMERIC(38, 0)  YES 
 
SubArea1 Identifier(FK)  Identifier  NUMERIC(38, 0)  YES 
 
SubArea2 Identifier(FK)  Identifier  NUMERIC(38, 0)  YES 
 
Sample Disposition    VARCHAR(2000)  YES 
 
Container Identifier(FK)  Identifier  VARCHAR(25)  NO 
 
Status Identifier(FK)  Identifier  VARCHAR(25)  NO 
 
Material State Identifier(FK)    VARCHAR(6)  NO  
State Identifier: The material state.
 
Requirement Identifier(FK)  Identifier  VARCHAR(25)  NO 
 
Group Identifier(FK)  Identifier  VARCHAR(128)  YES 
 
Comment  Comment  VARCHAR(2000)  YES  
Comment:  General comments.
 
Modify Date  Date  DATE  NO  
Date: Date and time to seconds.
 
Modify By Userid  Userid  VARCHAR(64)  NO 
 
Disposition Identifier(FK)  Identifier  VARCHAR(25)  NO 
 
Resource Conservation and Recovery Act Waste Code    VARCHAR(50)  YES  
Resource Conservation and Recovery Act Waste Code:
 
UN Identifier    VARCHAR(50)  YES  
UN Identifier:
 
DOT Division Number(FK)    CHAR(3)  YES 
 
DOT Sub-Hazard Division Number(FK)    CHAR(3)  YES 
 
Packing Group Identifier(FK)  Identifier  VARCHAR(3)  YES 
 
Waste Characterization Comment  Comment  VARCHAR(2000)  YES  
Comment:  General comments.
 
Lab Waste Certification Indicator  Indicator  CHAR(1)  NO 
 
DOT Class Number(FK)    CHAR(1)  YES 
 
DOT Sub Class Number(FK)    CHAR(1)  YES 
 
Sample Owner Person Identifier(FK)    VARCHAR(10)  YES  
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Disposition Verified Indicator  Indicator  CHAR(1)  NO  
Disposition Verified Indicator: Simple placeholder indicating that all sample disposition items have been checked.
 
Sample Return Name    VARCHAR(75)  YES  
Item Return Name: The name of the person to which the experiment samples are to be returned.
 
Sample Return Address    VARCHAR(500)  YES  
Item Return Address: The address to which the experiment samples ae to be returned.
 
Can Identifier(FK)  Identifier  VARCHAR(20)  YES 
 
Disposition Comment  Comment  VARCHAR(2000)  YES  
Comment:  General comments.
 
Special Handling Plan Indicator  Indicator  CHAR(1)  NO 
 
Theoretical Mass Density    NUMERIC(7, 5)  YES  
Theoretical Mass Density: Measured in grams per centimeter cube (g/cm^3)
 

SMPL.Sample Keys 
Key Name  Key Type  Keys 
PK_SAMPLE  PrimaryKey  Sample Identifier 

SMPL.Sample Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Unit of Mass  Non-Identifying  One To Zero or More        Mass Unit Identifier  NO 
Sample  Non-Identifying  Zero or One to Zero or More        Family Sample Identifier  NO 
Control Area  Non-Identifying  One To Zero or More        ControlArea Identifier  NO 
Control Area Subarea  Non-Identifying  Zero or One to Zero or More        ControlArea Identifier, SubArea Identifier  NO 
Material State  Non-Identifying  One To Zero or More        Material State Identifier  NO 
Sample Container  Non-Identifying  One To Zero or More        Container Identifier  NO 
Sample Disposition  Non-Identifying  One To Zero or More        Disposition Identifier  NO 
Sample Status  Non-Identifying  One To Zero or More        Status Identifier  NO 
Sample Group  Non-Identifying  Zero or One to Zero or More        Group Identifier  NO 
Department of Transportation Hazardous Material Class  Non-Identifying  Zero or One to Zero or More        DOT Division Number, DOT Class Number  NO 
Department of Transportation Hazardous Material Class  Non-Identifying  Zero or One to Zero or More        DOT Sub-Hazard Division Number, DOT Sub Class Number  NO 
Control Area Subarea1  Non-Identifying  Zero or One to Zero or More        ControlArea Identifier, SubArea Identifier, SubArea1 Identifier  NO 
Control Area Subarea2  Non-Identifying  Zero or One to Zero or More        ControlArea Identifier, SubArea Identifier, SubArea1 Identifier, SubArea2 Identifier  NO 
Department of Transportation Packing Group  Non-Identifying  Zero or One to Zero or More        Packing Group Identifier  NO 
Person  Non-Identifying  Zero or One to Zero or More        Sample Owner Person Identifier  NO 
Sample Can  Non-Identifying  Zero or One to Zero or More        Container Identifier, Can Identifier  NO 
Sample Special Requirement  Non-Identifying  One To Zero or More        Requirement Identifier  NO 
Unit of Length  Non-Identifying  Zero or One to Zero or More        Length Unit Identifier  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Sample Set Temporary  Identifying  One To Zero or More          NO 
Sample  Non-Identifying  One To Zero or More          NO 
Can Substrate Cell Usage  Non-Identifying  One To Zero or More          NO 
Sample Classification  Identifying  One To Zero or More          NO 
Sample Delete Request  Identifying  One To Zero or More          NO 
Sample Delivery Request  Identifying  One To Zero or More          NO 
Sample Irradiation  Identifying  One To Zero or More          NO 
Sample List Sample Association  Identifying  One To Zero or More          NO 
Sample Log  Identifying  One To Zero or More          NO 
Sample Proposal Association  Identifying  One To Zero or More          NO 
Sample Radionuclide Association  Identifying  One To Zero or More          NO 
Sample Sample Shipment Association  Identifying  One To Zero or More          NO 
Sample Transfer  Identifying  One To Zero or More          NO 
Sample Sample Attachment Association  Identifying  One To Zero or More          NO 
Sample Sample Form Association  Identifying  One To Zero or More          NO 
Sample Special Requirement Association  Identifying  One To Zero or More          NO 

SMPL.Sample Check Constraints 
Check Constraint Name  CheckConstraint 

SMPL.Sample Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
SMPL.Sample Security Types 
Name  Current Value 

SMPL.Sample Bound Attachments 
Name  Current Value 

SMPL.Sample Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
SMPL.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)
CHAN_ARCH.SAMPLE 		 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)
SMPL.SAMPLE 		 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)
SICAT.SAMPLE 		 NO       
SMPL (Oracle)
SMPL.SAMPLE 		 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       

SMPL.Sample Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Express 
Logical  Print 
Logical  Sample 
CHAN_ARCH (Oracle)  Main Model 
EXPRESS (Oracle)  Main Model 
SICAT (Oracle)  Main Model 
SMPL (Oracle)  Main Model 

SMPL.Sample Data Movement Rules 
Name  Type  Rule Text/Value