RAILROAD COMMISSION OF TEXAS
OIL AND GAS SCHEDULE SNAPSHOT MASTER TAPE
MAGNETIC TAPE USER'S GUIDE
PUBLISHED BY THE
RAILROAD COMMISSION OF TEXAS
P.O. BOX 12967 - CAPITOL STATION
AUSTIN, TEXAS 78711-2967
This publication was developed for the general public
in response to inquiries concerning the availability of oil
and gas schedule information on magnetic tape. If you
request assistance in using the manual, your request will be
given every consideration.
First Edition: March 1993
The Railroad Commission does not discriminate on the basis of
race, color, national origin, sex, religion, age or disability.
Information is available upon request by calling (512)463-7288 or
(TDD) 1-800-735-2989 if special assistance is required.
Publication Number: SSA001
i
TABLE OF CONTENTS
ITEM PAGE
I. GENERAL INFORMATION
Identification I.1
System Description I.2
Schedule Snapshot Data Base Hierarchy I.4
Physical Tape Characteristics I.5
II. FILE INFORMATION
Schedule Snapshot Root Segment II.1
Schedule Snapshot Cycle Segment II.3
Schedule Snapshot Operator Segment II.5
Schedule Snapshot Lease Segment II.7
Schedule Snapshot Well Segment II.9
III. APPENDIX A
District Conversion Table III.1
ii
I. GENERAL INFORMATION
IDENTIFICATION
Developed For: Users of Oil and Gas Schedule Snapshot
Master Tape
By: Railroad Commission of Texas
System Name: Oil and Gas Schedule Snapshot
Computer: IBM 2003-116
I.1
SYSTEM DESCRIPTION
The Schedule Snapshot data base assists the Oil and Gas
Division in tracking wells that are on schedule for a specific
month. It keeps all the identifying information for a well
in the following order: district, field, cycle, operator,
lease, and well number.
The keys to the Schedule Snapshot data base records can
be found in the first two bytes of each record.
I.2
The key representation is as follows:
Schedule Snapshot Master Tape File
RECORD SEGMENT
KEY NAME DESCRIPTION
01 SSROOT District and field root segment
02 SSCYCLE Cycle segment
03 SSOPER Operator name and number segment
04 SSLEASE Lease segment
05 SSWELL Well segment
I.3
SCHEDULE SNAPSHOT DATA BASE HIERARCHY
**********
* SSROOT *
* KEY=01 *
**********
]
] ******
********** *
* SSCYCLE* *
* KEY=02 *
**********
]
] ******
********** *
* SSOPER * *
* KEY=03 *
**********
]
] ******
********** *
* SSLEASE* *
* KEY=04 *
**********
]
] ******
********** *
* SSWELL * *
* KEY=05 *
**********
I.4
PHYSICAL TAPE CHARACTERISTICS
1600 BPI, channel phase encoded, EBCDIC
IBM Standard Labels
(One 80-character volume label, two 80-character header labels
and two 80-character trailer labels)
The master file tape is identified by the following internal
dataset name and has the listed attributes:
Dataset Name: T.SSF991
Record Length: 40
Blocking Factor 819
Block Size: 32,760
I.5
II. FILE INFORMATION
*****************************************************************
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S ROOT SEGMENT *
* *
* *
* SEGMENT NAME: SSROOT TOTAL LENGTH: 10 BYTES *
*------*
* VARIABLE ] TYPE ] SSA *
* NAME ] ] NAME *
*------*
* SSROOT-KEY ] KEY ] SSROOTKY *
* SS-DISTRICT ] SEARCH ] SSDIST *
* SS-FIELD-NUMBER ] SEARCH ] SSFLDNUM *
*------*
*****************************************************************
01 RAILROAD-COMMISSION-TAPE-REC. POSITION
02 RRC-TAPE-RECORD-ID PIC X(02). 1
02 SCHEDULE-SNAPSHOT-ROOT.
05 SSROOT-KEY.
10 SS-DISTRICT PIC 9(02) VALUE ZEROS. 3
10 SS-FIELD-NUMBER PIC 9(08) VALUE ZEROS. 5
02 RRC-TAPE-FILLER PIC X(0028). 13
II.1
*****************************************************************
* SSW700A1 *
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S ROOT SEGMENT *
* *
* SEGMENT NAME: SSROOT *
*****************************************************************
------
RRC-TAPE-RECORD-ID
------
This two-digit number indicates the Railroad Commission (RRC)
schedule snapshot's record ID. Contained in the first two bytes of
each record, this record ID tells what type of information will be
found in each record.
RRC ID
Value Tape Record Description
01 Schedule Snapshot Root Segment
------
SSROOT-KEY
------
This data item contains the district and field number for each
well that is on schedule.
------
SS-DISTRICT
------
This data item is the numeric RRC district where the
field is located.
------
SS-FIELD-NUMBER
------
This data item is the field number to which all of
the subordinate information applies.
II.2
*****************************************************************
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S CYCLE SEGMENT *
* *
* *
* SEGMENT NAME: SSCYCLE TOTAL LENGTH: 4 BYTES *
*------*
* VARIABLE ] TYPE ] SSA *
* NAME ] ] NAME *
*------*
* SS-CYCLE-KEY ] KEY ] SSCYCKEY *
*------*
*****************************************************************
01 RAILROAD-COMMISSION-TAPE-REC. POSITION
02 RRC-TAPE-RECORD-ID PIC X(02). 1
02 SCHEDULE-SNAPSHOT-CYCLE-SEG.
05 SS-CYCLE-KEY PIC 9(04) VALUE ZEROS. 3
02 RRC-TAPE-FILLER PIC X(0034). 7
II.3
*****************************************************************
* SSW700B1 *
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S CYCLE SEGMENT *
* *
* SEGMENT NAME: SSCYCLE *
*****************************************************************
------
RRC-TAPE-RECORD-ID
------
This two-digit number indicates the Railroad Commission (RRC)
schedule snapshot's record ID. Contained in the first two bytes of
each record, this record ID tells what type of information will be
found in each record.
RRC ID
Value Tape Record Description
02 Schedule Snapshot Cycle Segment
------
SSCYCLE-KEY
------
This data item contains the cycle date for the period that the
subordinate information applied to the field. It is in YYMM
format.
II.4
*****************************************************************
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S OPERATOR SEGMENT *
* *
* *
* SEGMENT NAME: SSOPER TOTAL LENGTH: 38 BYTES *
*------*
* VARIABLE ] TYPE ] SSA *
* NAME ] ] NAME *
*------*
* SS-OPERATOR-KEY ] KEY ] SSOPRKEY *
* SS-OPERATOR-NAME ] SEARCH ] SSOPRNAM *
* SS-OPERATOR-NUMBER ] SEARCH ] SSOPRNUM *
*------*
*****************************************************************
01 RAILROAD-COMMISSION-TAPE-REC. POSITION
02 RRC-TAPE-RECORD-ID PIC X(02). 1
02 SCHEDULE-SNAPSHOT-OPERATOR-SEG.
05 SS-OPERATOR-KEY.
10 SS-OPERATOR-NAME PIC X(32) VALUE SPACES. 3
10 SS-OPERATOR-NUMBER PIC 9(06) VALUE ZEROS. 35
II.5
*****************************************************************
* SSW700C1 *
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S OPERATOR SEGMENT *
* *
* SEGMENT NAME: SSOPER *
*****************************************************************
------
RRC-TAPE-RECORD-ID
------
This two-digit number indicates the Railroad Commission (RRC)
schedule snapshot's record ID. Contained in the first two bytes of
each record, this record ID tells what type of information will be
found in each record.
RRC ID
Value Tape Record Description
03 Schedule Snapshot Operator Segment
------
SS-OPERATOR-KEY
------
This data item contains the name and number for the operator of
following lease(s) and well(s) for a particular cycle period in
the field.
------
SS-OPERATOR-NAME
------
This data item contains the name of the operator.
------
SS-OPERATOR-NUMBER
------
This data item contains the number of the operator.
II.6
*****************************************************************
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S LEASE SEGMENT *
* *
* *
* SEGMENT NAME: SSLEASE TOTAL LENGTH: 9 BYTES *
*------*
* VARIABLE ] TYPE ] SSA *
* NAME ] ] NAME *
*------*
* SSLEASE-KEY ] KEY ] SSLSEKEY *
* SS-LEASE-OIL-OR-GAS-CODE ] SECONDARY INDEX ] XSSOORG *
* SS-LEASE-OIL-OR-GAS-CODE ] SEARCH ] SSOGCODE *
* SS-LEASE-DISTRICT ] SEARCH ] SSLSEDST *
* SS-LEASE-NUMBER-OR-GAS-ID ] SEARCH ] SSLSEID *
*------*
*****************************************************************
01 RAILROAD-COMMISSION-TAPE-REC. POSITION
02 RRC-TAPE-RECORD-ID PIC X(02). 1
02 SCHEDULE-SNAPSHOT-LEASE-SEG.
05 SSLEASE-KEY.
10 SS-LEASE-OIL-OR-GAS-CODE PIC X(01) VALUE SPACE. 3
10 SS-LEASE-DISTRICT PIC 9(02) VALUE ZEROS. 4
10 SS-LEASE-NUMBER-OR-GAS-ID PIC 9(06) VALUE ZEROS. 6
02 RRC-TAPE-FILLER PIC X(0029). 12
II.7
*****************************************************************
* SSW700D1 *
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S LEASE SEGMENT *
* *
* SEGMENT NAME: SSLEASE *
*****************************************************************
------
RRC-TAPE-RECORD-ID
------
This two-digit number indicates the Railroad Commission (RRC)
schedule snapshot's record ID. Contained in the first two bytes of
each record, this record ID tells what type of information will be
found in each record.
RRC ID
Value Tape Record Description
04 Schedule Snapshot Lease Segment
------
SSLEASE-KEY
------
This data item contains the oil or gas code, district, and lease
or gas identification number of a well.
------
SS-LEASE-OIL-OR-GAS-CODE
------
This data item indicates whether the lease is a gas
or oil lease: "O" for oil, "G" for gas.
------
SS-LEASE-DISTRICT
------
This data item is the numeric RRC district where the
lease is located.
------
SS-LEASE-NUMBER-OR-GAS-ID
------
This data item is gas identification number or oil lease number
to the gas/oil lease.
II.8
*****************************************************************
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S WELL SEGMENT *
* *
* *
* SEGMENT NAME: SSWELL TOTAL LENGTH: 15 BYTES *
*------*
* VARIABLE ] TYPE ] SSA *
* NAME ] ] NAME *
*------*
* SSWELL-KEY ] KEY ] SSWELKEY *
* SS-WELL-UNIT-IDENTIFIER ] SEARCH ] SSUNITID *
* SS-WELL-NUMBER ] SEARCH ] SSWELLNO *
* SS-WELL-DATABASE-ROOT-KEY ] SECONDARY INDEX ] XSSWLKEY *
* SS-WELL-DATABASE-ROOT-KEY ] SEARCH ] SSWLRTKY *
*------*
*****************************************************************
01 RAILROAD-COMMISSION-TAPE-REC. POSITION
02 RRC-TAPE-RECORD-ID PIC X(02). 1
02 SCHEDULE-SNAPSHOT-WELL-SEG.
05 SSWELL-KEY.
10 SS-WELL-UNIT-IDENTIFIER PIC X(01) VALUE HIGH-VALUES. 1
10 SS-WELL-NUMBER PIC X(06) VALUE SPACE. 2
05 SS-WELL-DATABASE-ROOT-KEY PIC 9(08) VALUE ZEROS. 8
02 RRC-TAPE-FILLER PIC X(0023). 18
II.9
*****************************************************************
* SSW700E1 *
* *
* THIS COPY IS USED FOR THE SCHEDULE SNAPSHOT *
* DATA BASE'S WELL SEGMENT *
* *
* SEGMENT NAME: SSWELL *
*****************************************************************
------
RRC-TAPE-RECORD-ID
------
This two-digit number indicates the Railroad Commission (RRC)
schedule snapshot's record ID. Contained in the first two bytes of
each record, this record ID tells what type of information will be
found in each record.
RRC ID
Value Tape Record Description
05 Schedule Snapshot Well Segment
------
SSWELL-KEY
------
This data item contains the unit identifier and well number
of each well on a particular lease.
------
SS-WELL-UNIT-IDENTIFIER
------
This data item contains the oil well unit identifier
or high-values for wells not in a unit.
------
SS-WELL-NUMBER
------
This data item contains the well number assigned to the
well.
------
SS-WELL-DATABASE-ROOT-KEY
------
This data item contains the well data base key for this
well.
II.10
III. APPENDIX A
DISTRICT CONVERSION TABLE
Railroad Commission Numeric District District
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
III.1