# Location

LocationDescription:
Buoy #53  Ms Sound/Gulfport Ship Channel


LocationDescription:
Bay St. Louis - Railroad Bridge & Hwy 90


LocationDescription:
St. Francis West - St.Charles - Harrison Beach


# sysDataMap

ImportFileType:
Text (tab delimted; csv)( *.txt;*.csv)|*.txt;*.csv;*.mdb|Microsoft Access (*.mdb)|*.mdb;


TargetTables:
'Samples', 'SamplesAir', 'SamplesTags', 'Location', 'Events', 'refMatrixLst', 'LabAnalyses'


TargetTables:
'Samples', 'SamplesAir', 'SamplesTags', 'Location', 'Events', 'refMatrixLst'


TargetTables:
'Samples', 'SamplesBiota', 'SamplesTags', 'Location', 'Events', 'refMatrixLst', 'LabAnalyses'


TargetTables:
'Samples', 'SamplesBiota', 'SamplesTags', 'Location', 'Events', 'refMatrixLst'


TargetTables:
'Samples', 'SamplesTags', 'Location', 'Events', 'refMatrixLst', 'LabAnalyses'


TargetTables:
'Samples', 'SamplesSoilGas', 'SamplesTags', 'Location', 'Events', 'refMatrixLst', 'LabAnalyses'


TargetTables:
'Samples', 'SamplesSoilGas', 'SamplesTags', 'Location', 'Events', 'refMatrixLst'


TargetTables:
'Samples', 'SamplesSoil', 'SamplesTags', 'Location', 'Events', 'refMatrixLst'


TargetTables:
'Samples', 'SamplesSoil', 'SamplesTags', 'Location', 'Events', 'refMatrixLst', 'LabAnalyses'


TargetTables:
'Samples', 'SamplesWater', 'SamplesTags', 'Location', 'Events', 'refMatrixLst', 'LabAnalyses'


TargetTables:
'Samples', 'SamplesWater', 'SamplesTags', 'Location', 'Events', 'refMatrixLst'


TargetTables:
'Samples', 'SamplesWipe', 'SamplesTags', 'Location', 'Events', 'refMatrixLst', 'LabAnalyses'


TargetTables:
'Samples', 'SamplesWipe', 'SamplesTags', 'Location', 'Events', 'refMatrixLst'


# sysDataMapCol

Description:
Analysis Name (i.e.VOCs; PCBs; Metals TAL)   (Required)


Description:
Analyses Type (i.e. Organics; Inorganics; RCRA; USER_DEFINED; Other)


Description:
The Turnaround Time assigned to the analysis.


Description:
Turnaround time units for the analysis (i.e. Days; Hours)


Description:
Analyte/Paramater name (i.e. Lead; Arsenic; etc.)  (Required PK; FK)


Description:
"Wet" for wet_weight basis reporting; "Dry" for dry_weight reporting


Description:
CLP Sample Number for samples submitted to the CLP program.


Description:
Date Sample Collected as reported by the Lab


Description:
Detected or Not Detected. i.e. "Y" for detected analytes or "N" for non_detects.


Description:
Lab Extraction Method (i.e. MEP; TCLP; SPLP; EP)


Description:
The final volume of the sample after sample prepartion. Include all dilution factors.


Description:
The unit of measurement that corresponds to the final_amount.


Description:
Chain of Custody Number as reported by the Lab


Description:
Matrix ID reported by Lab. (i.e. Soil; Water; Air; etc.)


Description:
Percent Moisture of the sample portion used in the test


Description:
Quantitation Limits as determined by the lab.


Description:
"Yes" for results which are considered to be reportable; or "No" for othere results


Description:
Reporting Limits as determined by the lab.


Description:
Final/Validated Result qualifier/flag (i.e. J;U;ND;<;>)


Description:
"TRG" for a target or regular result; "TIC" for tentatively identifed compounds; "SUR" for surrogates; "IS" for internal standards; or "SC" for spiked compounds.


Description:
Result Unit of measurement (Required PK)


Description:
Scribe/Field Sample Number (Required PK; FK)


Description:
Code which distinguishes between different types of samples. For example normal samples must be distinguished from lab method blank samples


Description:
Unit of measurement for subsample amount.


Description:
Type of test  (i.e. "initial"; "reextract1"; "reextract2"; "reextract3"; "reanalysis"; "dilution1"; "dilution2"; and "dilution3")


Description:
"D" for dissolved or filtered (metal) concentration; or "T" for everything else


Description:
Geopositioning datum associated with the Latitude and Longitude coordinates.  (i.e. NAD27; NAD83)


Description:
Datum used to determine the elevation measurement. ( i.e NAVD88; NGVD29; WGS84; Sea Level; Unknown)  Datum used to determine the elevation measurement  Datum used to determine the elevation measurement.   i.e.  NAVD88; NGVD29; WGS84; Sea Level; Unknown


Description:
Method used to determine the elevation measurement. ( i.e. Altimetry; GPS; Interpolation; Other; Survey)


Description:
Geopositioning method used to establish Latitude and Longitude coordinates. (i.e. GPS; Interpolation; Survey)


Description:
Scale of the map or photo used to interpolate the Latitude and Longitude coordinates


Description:
GPS Correction Type (i.e. uncorrected; corrected)


Description:
Sampling Location Code/Monitoring Location Code  (PK)


Description:
Location Description further describes the Location Code.


Description:
Location Zone describes the area impacted relative to the site.


Description:
Surface Elevation records the Ground elevation of a geographic point where samples or field measurements are collected.


Description:
Surface Elevation Units (i.e. feet; meters)


Description:
Lab Analyses for this sample (i.e. VOCs)  (FK)


Description:
Sampling location coordinate system. (i.e UTM NAD83)


Description:
Datum used to determine the elevation measurement.( i.e NAVD88; NGVD29; WGS84; Sea Level; Unknown)  Datum used to determine the elevation measurement  Datum used to determine the elevation measurement.   i.e.  NAVD88; NGVD29; WGS84; Sea Level; Unknown


Description:
Method used to determine the elevation measurement. (i.e. Altimetry; GPS; Interpolation; Other; Survey)


Description:
EventID. Use to group data by sampling events.  Defaults to 'Sampling'  (i.e.  EOC; Site Assessment)


Description:
System field. N = Has Not been imported. Y  = Has been imported into a Scribe project


Description:
Location Image Path to related image file.


Description:
Describes the area impacted relative to the  site


Description:
Sample Matrix. i.e. Water; Filtered Water; Ground Water


Description:
Matrix Spike/Matrix Spike Duplicate (Y or N)


Description:
Sample Concentration (low; medium; high)


Description:
Sample Number. Scribe requires a unique sample number  (Required)


Description:
Sample Collection Method (i.e. Grab; Composite; Discrete Interval)


Description:
( i.e. Drainage; Groundwater; Monitoring Well; Residential; Tap)


Description:
Sample Type (i.e. Field Sample; Field Duplicate; Lab QC; Spike; Trip Blank)


Description:
Sub Location. Use to describe Location. For example; for a residential sampling location: Living Room; Basement; etc.


# sysDataViews

SQL:
Select * FROM [lookupentry] ORDER BY LookupID

SQLInsert:
INSERT INTO LookupEntry ([LookupID],[LookupDisplay]) VALUES ('#NEW','#NEW')


SQLInsert:
INSERT INTO user_group_members ([groupname],[username]) VALUES ('Default Group','#NEW')


SQLInsert:
INSERT INTO user_list ([UserName],[Active]) VALUES ('#NEW',True)


# sysTableLst

PrimaryKey:
Site_No, Samp_No, Analysis, Analyte, Result_Units


PrimaryKey:
Site_No, InstrumentID, Location, Mon_Date, Mon_Time, Mon_Parameter


Description:
Supported Task Categories (i.e. Soil Sampling, Air Sampling)


