Public Information - Masterfile Record Layout
The Masterfile contains information on current renewable licenses listed under the majority of the Department of Consumer Affairs Boards/Bureaus/Committees/Programs (hereafter referred to as "Agency") throughout California, for resident and non-resident licensees, sorted by agency code, then by license type, then by license number.
The following table describes the data provided in the Masterfile:
| FIELD DESCRIPTION | STARTING & ENDING POSITIONS | FIELD LENGTH | CHARACTER TYPE (A = LETTERS/ NUMBERS N = NUMBERS ONLY) |
|---|---|---|---|
| RECORD TYPE (H = Header / Title Line, M = Masterfile) | 1 — 1 | 01 | A |
| AGENCY CODE | 2 — 5 | 04 | N |
| LICENSE TYPE * | 6 — 8 | 03 | A |
| LICENSE NUMBER (Provided if requested on Masterfile Request Form) | 9 — 16 | 08 | N |
| CLASS CODE * | 17 — 19 | 03 | A |
| BUSINESS (B) OR PERSON (P) INDICATOR | 20 — 20 | 01 | A |
| BUSINESS NAME | 21 — 85 | 65 | A |
| OR PERSONAL NAME LAST FIRST MIDDLE SUFFIX |
21 — 55 56 — 70 71 — 82 83 — 85 |
35 15 12 03 |
A A A A |
| FIRST LINE OF ADDRESS | 86 — 125 | 40 | A |
| SECOND LINE OF ADDRESS | 126 — 165 | 40 | A |
| CITY NAME | 166 — 190 | 25 | A |
| CITY CODE | 191 — 195 | 05 | N |
| COUNTY CODE ** | 196 — 197 | 02 | N |
| STATE | 198 — 199 | 02 | A |
| ZIP CODE | 200 — 208 | 09 | N |
| COUNTRY NAME (Blank for USA) | 209 — 233 | 25 | A |
| PRIMARY STATUS CODE *** (Only current renewable licenses are provided for the Masterfile) | 234 — 237 | 04 | N |
| EXPIRATION DATE | 238 — 245 | 08 | N |
| ORIGINAL ISSUE DATE | 246 — 253 | 08 | N |
| BLANK | 254 — 261 | 08 | |
| PROCESS DATE (The Masterfile is produced the first business day of every month) | 262 — 269 | 08 | N |
