SAMPLE_TYPE	COLUMN_NAME	LABEL	UNITS	TABLE_NAME	LEGAL_VALUES	VAR_TYPE	RANGE_HIGH	RANGE_LOW	REFERENCE	BUFFER_AREA	RASTER_RESOLUTION	SOURCE	METRIC_TYPE
MICX	ABSORBANCE	Absorbance		tblLABRESULTS									
COLUMN	ANALYST	Name/initials of laboratory personnel who analyzed the sample											
COLUMN	ANALYTE	Analyte											
COLUMN	BATCH_ID	Laboratory batch number											
MICX	COND	Conductivity value provided by an external lab		tblLABRESULTS									
MICX	CONDITION_CODE	"Condition of sample upon arrival at lab; Legal values are: OK = Sample is in good condition, C = Sample container is cracked, L = Sample container is leaking, ML = Sample Label is missing, NF = Sample is not frozen (for samples shipped frozen), W = Sample is warm; Q = other quality concern not otherwise noted. See comment."		tblLABRESULTS									
MICX	COND_6500	"For samples with conductivity above 6500 uS, the sample was run with an additional step to account for the salinity. In the event of those samples, do not use the regular RESULT column result, instead, use the RESULT_SALINE result for your analysis"		tblLABRESULTS									
COLUMN	DATE_ANALYZED	Date lab sample analyzed											
PTVER	DATE_COL	Date site was visited		tblPOINTVERIFICATION		CHARACTER							
MICX	DATE_RECEIVED	Date sample received		tblLABRESULTS									
MICX	DILUTION_FACTOR	Dilution sample factor		tblLABRESULTS									
COLUMN	LAB	Code for laboratory used to analyze sample											
COLUMN	MATRIX	Material used for analysis											
COLUMN	MDL	Method detection limit											
MICX	NARS_FLAG	NARS FLAG. ND = Nondetect; H = holding time issue; S = shipping issue; L = Less than reporting limit but above MDL; Q = other quality issue.		tblLABRESULTS									
DESIGN	PSTL_CODE	"State two letter postal code for site sampled. 50 state postal codes plus AS, MP, GU, PR, VI for American Samoa, Commonwealth of Northern Marianas, Guam, Puerto Rico and Virgin Islands.  No missing or \blank\"" values allowed."""		tblSITETRUTH		CHARACTER							
COLUMN	PUBLICATION_DATE	Date of data file publication											
MICX	RESULT	Value of associated parameter for samples with conductivity values at or below 6500 uS		tblLABRESULTS									
COLUMN	RESULT_UNITS	Result unit											
MICX	RL	Reporting limit		tblLABRESULTS									
MICX	SAMPLE_ID	MICX sample id		tblSAMPLES		CHARACTER	0						
COLUMN	SAMPLE_TYPE	Code identifying sample type											
DESIGN	SITE_ID	"Unique Site ID for the study and design cycle sampled. Preferred form is NWCnn_MM-xxxxx  where  nn is current cycle year (11, 16, 21), MM is two letter state code, and xxxxx is between 10001 and 99999.  No missing or \blank\"" values allowed."""		tblSITETRUTH		CHARACTER							
COLUMN	UID	Unique site visit ID											
COLUMN	UNIQUE_ID	"Unique site ID based on location that does not depend on year sampled or any other factor. Form is NWC_ss_nnnnn  where ss state and nnnnn is number that starts at 10001.   No missing or \blank\"" values allowed. NA"""											
PTVER	VISIT_NO	Visit Number		tblPOINTVERIFICATION	|R|1|2	CHARACTER