Table: SPEC

Contents: Specimen Information

Primary Key: none

Parent Table: none

Columns:

Name Type Size Contents Units/Value
PROJYEAR VARCHAR 3 Project Year  
SITEGRP Number (Integer) 2 Site Group SITEGRP
ASM VARCHAR 7 ASM no.  
FEATURE VARCHAR 11 Feature no.  
SUBFEATURE VARCHAR 14 Subfeature no.  
STRATUM VARCHAR 12 Stratum  
MPN Number (Integer) 2 Minimum Provenience no.  
LEVEL Number (Long) 4 Level LEVEL_
SPECIMEN Number (Long) 4 Specimen no.  
SPECTYPE Number (Single) 4 Specimen Type SPECTYPE
CLEANED Number (Integer) 2 Cleaned  
SPECCOUNT Number (Integer) 2 Specimen Count  
COMMENT Memo - Comments  
you are here: ari >collections >rpms >spec.htm