3 Year Inactive Well File
3
Table of Contents
Purpose 1
File Layout 1
Data Dictionary 2
3
Purpose
Listed below is the file format for the 3 Year Inactive Well File (BWF029). BWF029 can be sorted by statewide (BWF030), by District (BWF031), and by Organization (BWF032). The file layout is the same, regardless of sort.
BWF030 sorted by Statewide and BWF031 sorted by District is available in CD, FTP and Listing. BWF032 sorted by Operator is run for up to 10 Organizations and is available as a Listing.
Revised: October 2014
File Layout
**********************************************************************
* BWW029A1 *
* WORKING-STORAGE COPY FOR FILE S.BWF029 *
* 3-YEAR INACTIVE WELLBORES FILE *
* *
* FILE ORGANIZATION ==> SEQUENTIAL *
* RECORD LENGTH ======> 170 *
* *
**********************************************************************
*
01 BWF029-RECORD.
05 BWF029-API-NUMBER.
10 BWF029-API-COUNTY PIC 9(03) VALUE ZEROS.
10 BWF029-API-UNIQUE-NUMBER PIC 9(05) VALUE ZEROS.
05 BWF029-WELL-KEY.
10 BWF029-LEASE-KEY.
15 BWF029-OAG-CODE PIC X(01) VALUE SPACE.
15 BWF029-DISTRICT PIC 9(02) VALUE ZEROS.
15 BWF029-LEASE-NUMBER.
20 FILLER PIC 9(01) VALUE ZEROS.
20 BWF029-OIL-LEASE-NUM PIC 9(05)
VALUE ZEROS.
10 BWF029-WELL-NUMBER PIC X(06) VALUE SPACES.
05 BWF029-ON-OFF-SCHED-INDICTR PIC X(1) VALUE 'N'.
88 BWF029-ON-SCHEDULE VALUE 'N'.
88 BWF029-OFF-SCHEDULE VALUE 'Y'.
05 BWF029-CERT-EFFECTIVE-FLAG PIC X(1) VALUE 'N'.
88 BWF029-CERT-EFFECTIVE VALUE 'Y'.
05 BWF029-FIELD-NUMBER PIC 9(08) VALUE ZEROS.
05 BWF029-OPERATOR-NUMBER PIC 9(06) VALUE ZEROS.
05 BWF029-ORGANIZATION-NAME PIC X(32) VALUE SPACES.
05 BWF029-ADDRESS-LINE-1 PIC X(31) VALUE SPACES.
05 BWF029-ADDRESS-LINE-2 PIC X(31) VALUE SPACES.
05 BWF029-ZIP-CODE PIC 9(05) VALUE ZEROS.
05 BWF029-ZIP-CODE-SUFFIX PIC 9(04) VALUE ZEROS.
05 BWF029-CURR-PHONE-NUM.
10 BWF029-CURR-AREA-CODE PIC 9(03) VALUE ZEROS.
10 BWF029-CURR-PREFIX PIC 9(03) VALUE ZEROS.
10 BWF029-CURR-SUFFIX PIC 9(04) VALUE ZEROS.
05 BWF029-DESIGNATION-EFFECTVE-DT.
10 BWF029-DESIGNATION-CC PIC 99 VALUE ZEROS.
10 BWF029-DESIGNATION-YY PIC 99 VALUE ZEROS.
10 BWF029-DESIGNATION-MM PIC 99 VALUE ZEROS.
05 FILLER PIC X(12) VALUE SPACES.
Data Dictionary
The data dictionary provides the description of each column in the file.
Column Name / Column Description /API-NUMBER / This data item is assigned by the Commission to the well bore. The first three characters are the Texas county code for the county where the bore is located. The last five characters are assigned as a unique number. This number, in combination with the county code, creates a unique number for each bore in the state of Texas.
WELL-KEY
OIL-OR-GAS-CODE / This code indicates whether the information that follows
is for an oil lease or a gas well.
Oil lease value 'O'
Gas well value 'G'
DISTRICT / The district sequence number. This is the internal representation of the actual district number of the P4 record that was updated.
District Code / District Number
01 / 01
02 / 02
03 / 03
04 / 04
05 / 05
06 / 06
07 / 6E
08 / 7B
09 / 7C
10 / 08
11 / 8A
12 / 8B
13 / 09
14 / 10
LEASE-NUMBER / A five-digit oil lease number padded with a leading zero or a six-digit gas well identification number; it is assigned by the RRC.
WELL-NUMBER / This data item contains a six-digit number assigned by the
Operator. The first byte may be alphabetic, numeric or blank. The second and third bytes may be numeric or blank. The fourth byte may be numeric. The fifth or sixth bytes may be alphabetic or blank. If the third byte is blank, the second byte must be blank and the first byte may not be numeric. The well number is required on all reports by well.
ON-OFF-SCHED-INDICTR / This code indicates whether the information that follows
is for an oil lease or a gas well.
On Schedule value 'N'
Off Schedule value 'Y'
CERT-EFFECTIVE-FLAG / This data item is a one character flag which will contain either a value of 'Y' or 'N'. A value of 'Y' indicates that since designation of the well bore this or another completion in the well bore has been tested and a "3-Year Inactive Well Bore" Certification has been issued.
FIELD-NUMBER / This data item contains the RRC-assigned identifying number of the field in which the lease is currently located.
OPERATOR-NUMBER / This data item contains the RRC-assigned P-5 number of the company listed as the current operator of the lease on the Form P-4.
ORGANIZATION-NAME / Organization name as filed on RRC Organization Report Form (Form P-5).
ADDRESS-LINE-1 / Organization address line 1.
ADDRESS-LINE-2 / Organization address line 2.
ZIP-CODE / Organization zip code.
ZIP-CODE-SUFFIX / Organization zip code suffix.
CURR-PHONE-NUM / This data item contains the operator's primary phone number. The first three characters are the area code. The last seven characters are the local phone number.
DESIGNATION-EFFECTVE-DT / This data item is a six character date in century, year, month format representing the first date the well becomes eligible for certification for tax exemption.
DESIGNATION-DATE / This data item is a six character date representing the
Date the well becomes eligible for certification for tax
Exemption. Format: CCYYMM
CERTIFIED-INDICATOR / This data item is the flag if wellbore was certified to a tax credit for senate bill 126.
3