Public Information - Custom File Record Layout
Custom files contain specific license information related to A SINGLE Board/Bureau/Committee/Program (hereafter referred to as "Agency"), for resident and non-resident licensees, based on available selection and sorting options.
The following table describes all possible data that can be provided in a Custom file:
| FIELD DESCRIPTION | STARTING & ENDING POSITIONS | FIELD LENGTH | CHARACTER TYPE (A = LETTERS/ NUMBERS N = NUMBERS ONLY) |
|---|---|---|---|
| TRANSACTION CODE (U = Update) | 1 — 1 | 01 | A |
| TRANSACTION DATE (Date license record was last updated by the Agency) | 2 — 9 | 08 | N |
| AGENCY CODE | 10 — 13 | 04 | N |
| LICENSE TYPE * | 14 — 16 | 03 | A |
| LICENSE NUMBER (Provided if requested on Custom Request Form) | 17 — 24 | 08 | N |
| BUSINESS (B) OR PERSON (P) INDICATOR | 25 — 25 | 01 | A |
| BUSINESS NAME | 26 — 90 | 65 | A |
| OR PERSONAL NAME LAST FIRST MIDDLE SUFFIX |
26 — 60 61 — 75 76 — 87 88 — 90 |
35 15 12 03 |
A A A A |
| FIRST LINE OF ADDRESS | 91 — 130 | 40 | A |
| SECOND LINE OF ADDRESS | 131 — 170 | 40 | A |
| CITY NAME | 171 — 195 | 25 | A |
| CITY CODE | 196 — 200 | 05 | N |
| COUNTY CODE ** | 201 — 202 | 02 | N |
| STATE | 203 — 204 | 02 | A |
| ZIP CODE | 205 — 213 | 09 | N |
| COUNTRY NAME (Blank for USA) | 214 — 238 | 25 | A |
| ORIGINAL ISSUE DATE | 239 — 246 | 08 | N |
| BLANK | 247 — 262 | 16 | |
| EXPIRATION DATE | 263 — 270 | 08 | N |
| EDUCATION (Only available through certain Boards/Bureaus/ Committees/Programs with their submitted approval) SCHOOL CODE YEAR GRADUATED DEGREE CODE |
271 — 275 276 — 279 280 — 283 |
05 04 04 |
A N A |
| CLASS CODE * | 284 — 286 | 03 | A |
| PRIMARY STATUS CODE *** (Unless specified, only current renewable licenses will be listed) | 287 — 296 | 10 | N |
| PHONE NUMBER (Only business numbers are available, if provided) | 297 — 317 | 21 | N |
