Public Information - Standard File Record Layout
Standard files contain information on current renewable licenses listed under A SINGLE Department of Consumer Affairs Board/Bureau/Committee/Program (hereafter referred to as "Agency") throughout California, for resident and non-resident licensees, sorted by county, then by licensee (business or individual) name.
The following table describes the data provided in a Standard 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 Standard 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 |
| BLANK | 271 — 283 | 13 | |
| CLASS CODE * | 284 — 286 | 03 | A |
| PRIMARY STATUS CODE *** (Only current renewable licenses are provided for Standard files) | 287 — 296 | 10 | N |
