Data Format

Utah Division of Oil, Gas and Mining


Oil & Gas	Mining

Data Table Specifications

The Data Table specifications are included to show the file structure for the sample data and the tables used in selecting and verifying information in the program. These specification have been included to assist those who desire to develop and maintain their own database system of water sampling information and for those who need to develop programs to automatically write data in the standard comma delimited format.

It is important to be aware that the information provided as part of data is specific to key field information in the APPX database. Incorrectly entered data creates errors and problems which must be resolved before the data can be processed and incorporated into the APPX database.

In order to minimize data entry error, a series of tables have been created in conjunction with the program that provide valid field data entry information. The Field Names used in the tables are further explained in the Field Names and Descriptions section. The specifications for those tables follow the specifications for the EDI standard format:

Table 01 - SAMPLES (STANDARD EDI FORMAT)

The SAMPLES Table represents the unique set of sampling information required to identify the mine, location, date and time for each sample parameter and method used for the sample. This database file is in the required format for updating fields in the APPX water database. This file structure is used to generate a comma delimited file which can be transferred electronically for incorporation into the APPX database using the division's standard EDI format. The field order and the field names are as follows:

Structure for table: SAMPLES

Field	Field Name	Type	Width	Dec
1	MINE_ID	Integer	4
2	SITE_ID	Integer	4
3	LAB_CODE	Character	3
4	LAB_ID	Character	10
5	PARAM_ID	Integer	4
6	EQUALITY	Character	1
7	VALUE	Numeric	14	6
8	UNITS	Character	10
9	MIN_DET	Numeric	14	6
10	ANAL_METHD	Character	10
11	DATE_ANAL	Date*	8
12	TIME_ANAL	Integer	4
13	ANAL_NAME	Character	3
14	DATE_REC	Date*	8
15	DATE_RPT	Date*	8
16	DATE_SAMP	Date*	8
17	TIME_SAMP	Integer	4
18	SAMP_TYPE	Integer	4
19	SAMPLR_NAM	Character	20
20	COMMENTS	Character	50

*Note - Date fields determined in the database tables yield dates in the comma delimited file as a character field in the long international format (MM/DD/YYYY) with the "/'s" included in the field so that the date fields in the comma delimited files appear as, "MM/DD/YYYY".

Table 02 - LABS

The LABS Table provides a valid data entry table for the name and identification of laboratories used for water analysis. The field order and the field names are as follows:

Structure for table: LABS.TBL

The most current comma delimited file for LABS.TBL is here - LABS.CDF

Field	Field Name	Type	Width	Dec
1	LAB_CODE	Character	3
2	LAB_NAME	Character	35

Table 03 - METHODS

The METHODS Table provides a valid data entry table for the methods of analysis which can be used for different analytical parameters. The field order and the field names are as follows:

Structure for table: METHODS.TBL

The most current comma delimited file for METHODS.TBL is here - METHODS.CDF

Field	Field Name	Type	Width	Dec
1	PARAM_ID	Integer	4
2	ANAL_METHD	Character	10
3	DESCRIPT	Character	35

Table 04 - PARAMETER

The PARAMETER Table provides a valid data entry table for analytical parameters. The field order and the field names are as follows:

Structure for table: PARAMETER.TBL

The most current comma delimited file for PARAMETER.TBL is here - PARAMETE.CDF

Field	Field Name	Type	Width	Dec
1	PARAM_ID	Integer	4
2	DESCRIPT	Character	35

Table - 05 SITES

The SITES Table provides a valid data entry table for mine sites and their respective sample sites. The field order and the filed names are as follows:

Structure for table: SITES.TBL

The most current comma delimited file for SITES.TBL is here - SITES.CDF

Field	Field Name	Type	Width	Dec
1	PERM_NO	Character	6
2	MINE_NAME	Character	25
3	MINE_ID	Integer	4
4	SITE_ID	Integer	4
5	SITE_NAME	Character	15
6	SITE_TYPE	Character	6
7	DESCRIPT	Character	40

Table 06 - UNITS

The UNITS Table provides a valid data entry table for the units of measurement for various sample parameters. The field order and the field names are as follows:

Structure for table: UNITS.TBL

The most current comma delimited file for UNITS.TBL is here - UNITS.CDF

Field	Field Name	Type	Width	Dec
1	PARAM_ID	Integer	4
2	UNITS	Character	10
3	DESCRIPT	Character	35

Field Names and Descriptions

The following field names and descriptions are to used consistently throughout the database tables so that fields in various tables can readily be identified:

FIELD NAME	DESCRIPTION
DATE-ANAL*	Date the Analysis was performed, 8 characters text, DATE value. (Data is entered from the Lab/Field Sample Sheets and Reports)
ANAL_METHD	Method of Analysis, 10 character text, different methods of analysis can be used when sampling any given parameter (from the APPX water sample database), use valid entry table for selection. (Use Table 03 - METHODS)
TIME_ANAL	Time the Analysis was taken, 4 character text, TIME value HHMM (military), (i.e. 4:30pm is 1630)(Data is entered from the Lab/Field Sample Sheets and Reports)
ANAL_NAME	Name of Lab Analyst, 3 character text, (initials of analyst)(Data is entered from the Lab/Field Sample Sheets and Reports)
VALUE	Analytical Value Measured, 14 characters numeric, 6 decimal places. (Data is entered from the Lab/Field Sample Sheets and Reports)
COMMENTS	Comments regarding the Sample Data, 50 characters text, (Data is entered from the Lab/Field Sample Sheets and Reports)
EQUALITY	Equality Indicator, 1 character text, use valid entry table. Acceptable values for this field are "<", ">", or ""
DATE_SAMP*	Field Date of Sample, 8 characters text, DATE value.(Data is entered from the Lab/Field Sample Sheets and Reports)
TIME_SAMP	Field Time of Sample, 4 characters text, TIME value HHMM(military time), (i.e. 4:30pm is 1630)(Data is entered from the Lab/Field Sample Sheets and Reports)
LAB_CODE	Laboratory Code, 3 character text, a three-letter code of each lab (from the APPX water sample database), use valid entry table for selection. (Use Table 02 - LABS)
DATE_REC	Date Lab Received Sample, 8 characters text, DATE value.(Data is entered from the Lab/Field Sample Sheets and Reports)
DATE_RPT*	Date of Lab Report, 8 characters text, DATE value.(Data is entered from the Lab/Field Sample Sheets and Reports)
LAB_ID	Laboratory Identification Number, 10 character text, must be derived from the actual lab data sheet. This is the sampling laboratories unique lab number assigned to each sample data sheet. (Data is entered from the Lab/Field Sample Sheets and Reports)
LAB_NAME	Name of Laboratory, 35 characters text, (from the APPX water sample database), use valid entry table for selection. (Use Table 02 - LABS)
DESCRIPT(3)	Description of the Analytical Method Used for the Sample Parameter, 35 characters text, (from the APPX water sample database), use valid entry table for selection.(Use Table 03 - METHODS)
MINE_DET	Minimum Detection Limit, 14 characters numeric, 6 decimal places. (Data is entered from the Lab/Field Sample Sheets and Reports)
MINE_ID	Mine ID Number, 4 character numeric integer, each mine has a unique three digit Id number (from the APPX water sample database), use valid entry table for selection. (Use Table 05 - SITES)
MINE_NAME	Name of Mine, 25 characters text, (from the APPX water sample database), use valid entry table for selection.(Use Table 05 - SITES)
MINE_NUM	Mine Number, 3 characters text, (from the APPX water sample database), since the Mine Number is the last three digits of the Permit Number, i.e. 007'004', this field is not present in the tables.
MINE_OPER	Name of Mine Operator (Company), 25 characters text, (from the APPX water sample database), since the Permit Number and the Mine Name are sufficient for identification, this field has not been included for selection.
DESCRIPT(4)	Description of the Sample Parameters, 35 characters text, (from the APPX water sample database), use valid entry table for selection.(Use Table 04 - PARAMETER)
PARAM_ID	Sample Parameter Identification Number, 4 character numeric integer, each analysis has a specific parameter number (from the APPX water sample database), use valid entry table for selection. (Use Table 04 - PARAMETER)
PERM_NO	Permit Number, 6 characters text [County Number&Mine Number], this is the unique permit number used to identify each coal mine based on state-established county numbers and assigned mine numbers for each mine in their respective counties. (from the APPX water sample database), use valid entry table for selection.(Use Table 05 - SITES)
SAMPLR_NAM	Name of Sampler, 20 characters text (Data is entered from the Lab/Field Sample Sheets and Reports)
SAMP_TYPE	Type of Sample Taken, 4 character numeric integer, unique numbers assigned to the type of sample take, acceptable entries for this field are: 4 - Grab Sample; 10 - No Flow; 11 - No Access; and. 20 - Field Reading.
DESCRIPT(5)	Description of the Sample Location Site, 40 characters text, (usually the description or name of the site as it is referenced to by the mine operator). (from the APPX water sample database), use valid entry table for selection.(Use Table 05 - SITES)
SITE_ID	Sample Site Identification Number, 4 character numeric integer, unique three digit number assigned to sample point at a mine (from the APPX water sample database), use valid entry table for selection. (Use Table 05 - SITES)
SITE_NAME	Name of Sample Site Location, 25 characters text, (from the APPX water sample database), use valid entry table for selection. (Use Table 05 - SITES)
UNITS	Unit of Measure, 10 character text, an acceptable unit of measure for each parameter is necessary (from the APPX water sample database), use valid entry table for selection. (Use Table 06 - UNITS)
DESCRIPT(6)	Description of the Units of measure, 35 characters text, (from the APPX water sample database), use valid entry table for selection. (Use Table 06 - UNITS)

*Note - Date fields determined in the database tables yield dates in the comma delimited file as a character field in the long international format (MM/DD/YYYY) with the "/'s" included in the field so that the date fields in the comma delimited files appear as, "MM/DD/YYYY".


Abandoned Mine Reclamation \| Coal Program \| Minerals Program DOGM Home \| The Division \| Oil & Gas \| Mining DOGM Contact \| Division Staff \| Division Happenings \| DOGM FILES