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