Controlled Substances Registration

New Search

Instructions for Downloading and Reading the Controlled Substance Registration - Registrant File

File Download Instructions:

  1. Go to the Controlled Substances homepage on the DPS website – http://www.txdps.state.tx.us/csr
  2. Right click on the link “Click here to download the registrants file”.
  3. Choose "Save Target As" from the menu.
  4. Your browser will display a "Save As" dialog box. The name of the Registrants File is ‘csr.tgz’. Note the Save In folder to which the file will be copied. Click the "OK" button.
  5. When the copying process has finished, you may open ‘csr.tgz’ from the folder noted above. The size of ‘csr.tgz’ will be approximately 3-4mb.

Reading the Registrant File:
The Registrant File downloaded to your computer is named ‘csr.tgz’. The file is compressed, so before you can read the file you must first un-compress it using file un-compression software. Many good shareware and freeware programs exist. Some examples include:

Un-compress the file ‘csr.tgz’ according to your software’s instructions. This will produce a plain text file named ‘csr.txt’. The size of this file will be approximately 12mb. You can open ‘csr.txt’ in any text editor (such as Notepad) or word processor (such as Microsoft Word).

Registrant File Format:
The Registrant File ‘csr.txt’ is a fixed length delimited 213 character file. The layout is as follows:

The first record of the file is a date/time stamp displaying the date and time the file was created. The layout of this record is:

Position Length Field Description
1 8 date in YYYYMMDD format
9 6 time in HHMMSS format
15 92 blanks

The remaining data records are in the following layout:

Position Length Field Description
1 1 delimiter “|”
2 8 registrant DPS number
10 1 delimiter “|”
11 35 registrant name
46 1 delimiter “|”
47 9 state board license
56 1 delimiter “|”
57 1 drug schedule authorization
58 1 delimiter “|”
59 2 drug schedule authorization
61 1 delimiter “|”
62 1 drug schedule authorization
63 1 delimiter “|”
64 2 drug schedule authorization
66 1 delimiter “|”
67 1 drug schedule authorization
68 1 delimiter “|”
69 1 drug schedule authorization
70 1 delimiter “|”
71 8 registrant expiration date
79 1 delimiter “|”
80 9 blanks
89 1 delimiter “|”
90 35 registrant address line 1
125 1 delimiter “|”
126 30 registrant address line 2
156 1 delimiter “|”
157 20 registrant address line 3
177 1 delimiter “|”
178 20 registrant address line 4
198 1 delimiter “|”
199 5 registrant zip code
204 1 delimiter “|”
205 8 original issue date
213 1 delimiter “|”
214 22 business activity <== New
236 1 delimiter “|”