SAMPLE 
Logical Entity Name  Sample 
Default Table Name  SAMPLE 
Oracle Temporary Table  NO 
Physical Only  NO 
Do Not Generate  False 
Owner  SMPL 
Definition  
Experiment Sample: Information on the sample material that will be use in the experiment.
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE SMPL.SAMPLE(
     SMPL_ID                  NUMBER(38, 0)      NOT NULL,
     FAM_SMPL_ID              NUMBER(38, 0),
     SMPL_TYPE_IND            CHAR(1)            DEFAULT 'L' NOT NULL,
     SMPL_NM                  VARCHAR2(120)      NOT NULL,
     SMPL_FMLA                VARCHAR2(2000),
     SMPL_DESCR               VARCHAR2(2000)     NOT NULL,
     VOL_WGT_AMT              NUMBER(8, 2)       NOT NULL,
     MASS_UNIT_ID             VARCHAR2(3)        NOT NULL,
     SMPL_HGT                 VARCHAR2(5),
     LEN_UNIT_ID              VARCHAR2(3),
     NEUTRON_BEAM_IND         CHAR(1)            DEFAULT 'N' NOT NULL,
     CTRL_AREA_ID             NUMBER(38, 0)      NOT NULL,
     SUBAREA_ID               NUMBER(38, 0),
     SUBAREA1_ID              NUMBER(38, 0),
     SUBAREA2_ID              NUMBER(38, 0),
     SMPL_DISP                VARCHAR2(2000),
     CONT_ID                  VARCHAR2(25)       NOT NULL,
     STAT_ID                  VARCHAR2(25)       NOT NULL,
     ST_ID                    VARCHAR2(6)        NOT NULL,
     REQ_ID                   VARCHAR2(25)       NOT NULL,
     GRP_ID                   VARCHAR2(128),
     CMNT                     VARCHAR2(2000),
     MOD_DTE                  DATE               DEFAULT sysdate NOT NULL,
     MOD_BY_USERID            VARCHAR2(64)       NOT NULL,
     DISP_ID                  VARCHAR2(25)       NOT NULL,
     RCRA_WASTE_CD            VARCHAR2(50),
     UN_ID                    VARCHAR2(50),
     DOT_DIV_NBR              CHAR(3),
     DOT_SUB_HAZ_DIV_NBR      CHAR(3),
     PKG_GRP_ID               VARCHAR2(3),
     WASTE_CHAR_CMNT          VARCHAR2(2000),
     LWS_IND                  CHAR(1)            DEFAULT 'N' NOT NULL,
     DOT_CLASS_NBR            CHAR(1),
     DOT_SUB_CLASS_NBR        CHAR(1),
     smpl_owner_person_id     VARCHAR2(10),
     DISP_VERIF_IND           CHAR(1)            DEFAULT 'N' NOT NULL,
     SMPL_RET_NM              VARCHAR2(75),
     SMPL_RET_ADDR            VARCHAR2(500),
     CAN_ID                   VARCHAR2(20),
     DISP_CMNT                VARCHAR2(2000),
     SPEC_HAND_PLAN_IND       CHAR(1)            DEFAULT 'N' NOT NULL,
     CHECK (SMPL_TYPE_IND IN('L','B')),
     CONSTRAINT PK_SAMPLE PRIMARY KEY (SMPL_ID)
     USING INDEX
         LOGGING,
     CONSTRAINT fk_sample_to_smpl_cont FOREIGN KEY (CONT_ID)
     REFERENCES SMPL.SMPL_CONT(CONT_ID),
     CONSTRAINT fk_sample_to_smpl_status FOREIGN KEY (STAT_ID)
     REFERENCES SMPL.SMPL_STAT(STAT_ID),
     CONSTRAINT fk_sample_to_ctrl_area FOREIGN KEY (CTRL_AREA_ID)
     REFERENCES SMPL.CTRL_AREA(CTRL_AREA_ID),
     CONSTRAINT fk_smpl_grp_to_sample FOREIGN KEY (GRP_ID)
     REFERENCES SMPL.SMPL_GRP(GRP_ID),
     CONSTRAINT fk_sample_to_mat_stat FOREIGN KEY (ST_ID)
     REFERENCES XF_ADMIN.MATL_ST(ST_ID),
     CONSTRAINT RefSAMPLE2498 FOREIGN KEY (FAM_SMPL_ID)
     REFERENCES SMPL.SAMPLE(SMPL_ID),
     CONSTRAINT fk_smpl_to_smpl_spec_req FOREIGN KEY (REQ_ID)
     REFERENCES SMPL.SMPL_SPEC_REQ(REQ_ID),
     CONSTRAINT fk_sample_to_ctrl_area_subarea FOREIGN KEY (CTRL_AREA_ID, SUBAREA_ID)
     REFERENCES SMPL.CTRL_AREA_SUBAREA(CTRL_AREA_ID, SUBAREA_ID),
     CONSTRAINT fk_smpl_haz_to_dot_haz_class FOREIGN KEY (DOT_CLASS_NBR, DOT_DIV_NBR)
     REFERENCES SMPL.DOT_HAZ_MAT_CLASS(DOT_CLASS_NBR, DOT_DIV_NBR),
     CONSTRAINT fk_smpl_to_dot_pkg_grp FOREIGN KEY (PKG_GRP_ID)
     REFERENCES SMPL.DOT_PKG_GRP(PKG_GRP_ID),
     CONSTRAINT fk_smpl_subhaz_to_dot_hazclass FOREIGN KEY (DOT_SUB_CLASS_NBR, DOT_SUB_HAZ_DIV_NBR)
     REFERENCES SMPL.DOT_HAZ_MAT_CLASS(DOT_CLASS_NBR, DOT_DIV_NBR),
     CONSTRAINT fk_smpl_to_smpl_can FOREIGN KEY (CAN_ID, CONT_ID)
     REFERENCES SMPL.SMPL_CAN(CAN_ID, CONT_ID),
     CONSTRAINT fk_smpl_to_uol FOREIGN KEY (LEN_UNIT_ID)
     REFERENCES XF_ADMIN.UNIT_LEN(LEN_UNIT_ID),
     CONSTRAINT fk_smpl_to_ctrl_area_subarea1 FOREIGN KEY (CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID)
     REFERENCES SMPL.CTRL_AREA_SUBAREA1(CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID),
     CONSTRAINT fk_smpl_to_ctrl_area_subarea2 FOREIGN KEY (CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID, SUBAREA2_ID)
     REFERENCES SMPL.CTRL_AREA_SUBAREA2(CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID, SUBAREA2_ID)
)
LOGGING
NOPARALLEL
NOCACHE
NOCOMPRESS
;
 
PostSQL   

SAMPLE Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SMPL_ID(PK)  Identifier  NUMBER(38, 0)  NO 
 
FAM_SMPL_ID(FK)  Identifier  NUMBER(38, 0)  YES 
 
SMPL_TYPE_IND  Indicator  CHAR(1)  NO 
 
SMPL_NM  Name  VARCHAR2(120)  NO  
Name: A long description name usually accompanied by an abbreviated code.
 
SMPL_FMLA    VARCHAR2(2000)  YES  
Sample Formula: Any sensible chemical formula.
 
SMPL_DESCR  Description  VARCHAR2(2000)  NO  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
VOL_WGT_AMT    NUMBER(8, 2)  NO 
 
MASS_UNIT_ID    VARCHAR2(3)  NO  
Unit Identifier: Abbreviated unit of mass.
 
SMPL_HGT    VARCHAR2(5)  YES 
 
LEN_UNIT_ID(FK)    VARCHAR2(3)  YES  
Length Unit Identifier: Abbreviated unit of length.
 
NEUTRON_BEAM_IND  Indicator  CHAR(1)  NO 
 
CTRL_AREA_ID(FK)  Identifier  NUMBER(38, 0)  NO 
 
SUBAREA_ID(FK)  Identifier  NUMBER(38, 0)  YES 
 
SUBAREA1_ID(FK)  Identifier  NUMBER(38, 0)  YES 
 
SUBAREA2_ID(FK)  Identifier  NUMBER(38, 0)  YES 
 
SMPL_DISP    VARCHAR2(2000)  YES 
 
CONT_ID(FK)  Identifier  VARCHAR2(25)  NO 
 
STAT_ID(FK)  Identifier  VARCHAR2(25)  NO 
 
ST_ID(FK)    VARCHAR2(6)  NO  
State Identifier: The material state.
 
REQ_ID(FK)  Identifier  VARCHAR2(25)  NO 
 
GRP_ID(FK)  Identifier  VARCHAR2(128)  YES 
 
CMNT  Comment  VARCHAR2(2000)  YES  
Comment:  General comments.
 
MOD_DTE  Date  DATE  NO  
Date: Date and time to seconds.
 
MOD_BY_USERID  Userid  VARCHAR2(64)  NO 
 
DISP_ID  Identifier  VARCHAR2(25)  NO 
 
RCRA_WASTE_CD    VARCHAR2(50)  YES  
Resource Conservation and Recovery Act Waste Code:
 
UN_ID    VARCHAR2(50)  YES  
UN Identifier:
 
DOT_DIV_NBR(FK)    CHAR(3)  YES 
 
DOT_SUB_HAZ_DIV_NBR(FK)    CHAR(3)  YES 
 
PKG_GRP_ID(FK)  Identifier  VARCHAR2(3)  YES 
 
WASTE_CHAR_CMNT  Comment  VARCHAR2(2000)  YES  
Comment:  General comments.
 
LWS_IND  Indicator  CHAR(1)  NO 
 
DOT_CLASS_NBR(FK)    CHAR(1)  YES 
 
DOT_SUB_CLASS_NBR(FK)    CHAR(1)  YES 
 
smpl_owner_person_id    VARCHAR2(10)  YES  
Person Identifier: Unique identifier for a person derived from XCAMS.
 
DISP_VERIF_IND  Indicator  CHAR(1)  NO  
Disposition Verified Indicator: Simple placeholder indicating that all sample disposition items have been checked.
 
SMPL_RET_NM    VARCHAR2(75)  YES  
Item Return Name: The name of the person to which the experiment samples are to be returned.
 
SMPL_RET_ADDR    VARCHAR2(500)  YES  
Item Return Address: The address to which the experiment samples ae to be returned.
 
CAN_ID(FK)  Identifier  VARCHAR2(20)  YES 
 
DISP_CMNT  Comment  VARCHAR2(2000)  YES  
Comment:  General comments.
 
SPEC_HAND_PLAN_IND  Indicator  CHAR(1)  NO 
 

SAMPLE Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_SAMPLE  PrimaryKey  SMPL_ID 

SAMPLE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
SAMPLE  Non-Identifying  Zero or One to Zero or More        FAM_SMPL_ID  NO  NO  NO 
CTRL_AREA  Non-Identifying  One To Zero or More  fk_sample_to_ctrl_area      CTRL_AREA_ID  NO  NO  NO 
CTRL_AREA_SUBAREA  Non-Identifying  Zero or One to Zero or More  fk_sample_to_ctrl_area_subarea      CTRL_AREA_ID, SUBAREA_ID  NO  NO  NO 
MATL_ST  Non-Identifying  One To Zero or More  fk_sample_to_mat_stat      ST_ID  NO  NO  NO 
SMPL_CONT  Non-Identifying  One To Zero or More  fk_sample_to_smpl_cont      CONT_ID  NO  NO  NO 
SMPL_STAT  Non-Identifying  One To Zero or More  fk_sample_to_smpl_status      STAT_ID  NO  NO  NO 
SMPL_GRP  Non-Identifying  Zero or One to Zero or More  fk_smpl_grp_to_sample      GRP_ID  NO  NO  NO 
DOT_HAZ_MAT_CLASS  Non-Identifying  Zero or One to Zero or More  fk_smpl_haz_to_dot_haz_class      DOT_DIV_NBR, DOT_CLASS_NBR  NO  NO  NO 
DOT_HAZ_MAT_CLASS  Non-Identifying  Zero or One to Zero or More  fk_smpl_subhaz_to_dot_hazclass      DOT_SUB_HAZ_DIV_NBR, DOT_SUB_CLASS_NBR  NO  NO  NO 
CTRL_AREA_SUBAREA1  Non-Identifying  Zero or One to Zero or More  fk_smpl_to_ctrl_area_subarea1      CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID  NO  NO  NO 
CTRL_AREA_SUBAREA2  Non-Identifying  Zero or One to Zero or More  fk_smpl_to_ctrl_area_subarea2      CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID, SUBAREA2_ID  NO  NO  NO 
DOT_PKG_GRP  Non-Identifying  Zero or One to Zero or More  fk_smpl_to_dot_pkg_grp      PKG_GRP_ID  NO  NO  NO 
SMPL_CAN  Non-Identifying  Zero or One to Zero or More  fk_smpl_to_smpl_can      CONT_ID, CAN_ID  NO  NO  NO 
SMPL_SPEC_REQ  Non-Identifying  One To Zero or More  fk_smpl_to_smpl_spec_req      REQ_ID  NO  NO  NO 
UNIT_LEN  Non-Identifying  Zero or One to Zero or More  fk_smpl_to_uol      LEN_UNIT_ID  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
SMPL_SET_TEMP  Identifying  One To Zero or More          NO  NO  NO 
SAMPLE  Non-Identifying  One To Zero or More          NO  NO  YES 
SMPL_CLASS  Identifying  One To Zero or More  fk_smpl_class_to_sample        NO  NO  NO 
SMPL_DEL_REQ  Identifying  One To Zero or More  fk_smpl_del_req_to_smpl        NO  NO  NO 
SMPL_DELIV_REQ  Identifying  One To Zero or More  fk_smpL_deliv_req_to_smpl        NO  NO  NO 
SMPL_IRRAD  Identifying  One To Zero or More  FK_SMPL_IRRAD_TO_SMPL        NO  NO  NO 
SMPL_LOG  Identifying  One To Zero or More  fk_smpl_log_to_sample        NO  NO  NO 
SMPL_PRPSL_ASSC  Identifying  One To Zero or More  fk_smpl_prpsl_assc_to_sample        NO  NO  NO 
SMPL_RADIONUC_ASSC  Identifying  One To Zero or More  fk_smpl_radio_assc_to_smpl        NO  NO  NO 
SMPL_SMPL_SHIP_ASSC  Identifying  One To Zero or More  FK_SMPL_SHIP_ASSC_TO_SMPL        NO  NO  NO 
SMPL_TRANS  Identifying  One To Zero or More  fk_smpl_trans_to_sample        NO  NO  NO 
SAMPLE_SMPL_ATTACH_ASSC  Identifying  One To Zero or More  fk_ssaa_to_sample        NO  NO  NO 
SMPL_SMPL_FORM_ASSC  Identifying  One To Zero or More  fk_ssfa_to_smpl        NO  NO  NO 
SMPL_SPEC_REQ_ASSC  Identifying  One To Zero or More  fk_ssra_to_sample        NO  NO  NO 

SAMPLE Check Constraints 
Check Constraint Name  CheckConstraint 

SAMPLE Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE   
PctFree   
PCTUSED    
MinExtents   
MaxExtents   
Initial   
Next   
PctIncrease   
InitTrans   
MaxTrans   
Organization  Heap 
Cache  NO 
Logging   
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS   
FREELIST GROUPS   
Buffer Pool   
Table Compression  NO 
Compress Expression   
Row Movement  Disabled 

SAMPLE Partitions 
PARTITION PROPERTY  PARTITION PROPERTY VALUE 

SAMPLE Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  0 
Growth  Static 
Growth Type  N/A 
Growth Period  N/A 
Maximum Rows  0 
Average Row Size  0 

SAMPLE Object Permissions 

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

SAMPLE Bound Attachments 
Name  Current Value 

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

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

SAMPLE Data Movement Rules 
Name  Type  Rule Text/Value