Uniform Commercial Code (UCC) Bulk Order File Layouts
(Rev.7/22/2025) Bulk Order Types
The bulk order types listed below will use the format detailed in the following sections:
- Master Unload (New Master Unload)
- Daily Filing Update
Bulk Order file generation and file formats
For bulk orders of type 1, a data file is generated on a monthly basis. Files are put in a specified directory on the server and are made available to clients upon purchase. For type 2, a file containing data and images is generated daily at 1:00 AM.
Bulk order data is now provided in JSON format. Each record type will be represented as a JSON object with the associated fields:
- Record Code 1. Master Record
- Record Code 2. Organization Debtor File
- Record Code 3. Individual Debtor File
- Record Code 4. Organization Secured Party File
- Record Code 5. Individual Secured Party File
- Record Code 6. Amendment File
- Record Code 9. Trailer Record
Each record’s structure will follow a defined JSON schema specific to the record code.
Record Code 1 – Master Record
Start Position |
End Position |
Length | Description |
---|---|---|---|
1 | 1 | 1 | Record Code = 1 |
2 | 18 | 17 | Initial Filing Number |
19 | 19 | 1 | Filing Type (Appendix A) |
20 | 20 | 1 | Filing Status (A = Active, L = Lapsed) |
21 | 28 | 8 | Expiration Date (YYYYMMDD) |
29 | 32 | 4 | Total Page Count for Filing |
33 | 52 | 20 | Document Number of Initial Financing Statement Filing Number |
53 | 511 | 459 | Filler |
Record Code 2 – Organization Debtor File
Start Position |
End Position |
Length | Description |
---|---|---|---|
1 | 1 | 1 | Record Code = 2 |
2 | 18 | 17 | Initial Filing Number |
19 | 318 | 300 | Organization Debtor Name |
319 | 428 | 110 | Organization Debtor Street Address |
429 | 492 | 64 | Organization Debtor City |
493 | 494 | 2 | Organization Debtor State |
495 | 502 | 8 | Organization Debtor Zip Code |
503 | 508 | 6 | Organization Debtor Zip Code Extension** |
509 | 511 | 3 | Organization Debtor Country Code |
Record Code 3 – Individual Debtor File
Start Position |
End Position |
Length | Description |
---|---|---|---|
1 | 1 | 1 | Record Code = 3 |
2 | 18 | 17 | Initial Filing Number |
19 | 68 | 50 | Individual Debtor Last Name |
69 | 118 | 50 | Individual Debtor First Name |
119 | 168 | 50 | Individual Debtor Middle Name |
169 | 174 | 6 | Individual Debtor Suffix |
175 | 284 | 110 | Individual Debtor Street Address |
285 | 348 | 64 | Individual Debtor City |
349 | 350 | 2 | Individual Debtor State |
351 | 358 | 8 | Individual Debtor Zip Code |
359 | 364 | 6 | Individual Debtor Zip Code Extension** |
365 | 367 | 3 | Individual Debtor Country Code |
368 | 511 | 144 | Filler |
Record Code 4 – Organization Secured Party File
Start Position |
End Position |
Length | Description |
---|---|---|---|
1 | 1 | 1 | Record Code = 4 |
2 | 18 | 17 | Initial Filing Number |
19 | 318 | 300 | Organization Secured Party Name |
319 | 428 | 110 | Organization Secured Party Street Address |
429 | 492 | 64 | Organization Secured Party City |
493 | 494 | 2 | Organization Secured Party State |
495 | 502 | 8 | Organization Secured Party Zip Code |
503 | 508 | 6 | Organization Secured Party Zip Code Extension** |
509 | 511 | 3 | Organization Secured Party Country Code |
Record Code 5 – Individual Secured Party File
Start Position |
End Position |
Length | Description |
---|---|---|---|
1 | 1 | 1 | Record Code = 5 |
2 | 18 | 17 | Initial Filing Number |
19 | 68 | 50 | Individual Secured Party Last Name |
69 | 118 | 50 | Individual Secured Party First Name |
119 | 168 | 50 | Individual Secured Party Middle Name |
169 | 174 | 6 | Individual Secured Party Suffix |
175 | 284 | 110 | Individual Secured Party Street Address |
285 | 348 | 64 | Individual Secured Party City |
349 | 350 | 2 | Individual Secured Party State |
351 | 358 | 8 | Individual Secured Party Zip Code |
359 | 364 | 6 | Individual Secured Party Zip Code Extension** |
365 | 367 | 3 | Individual Secured Party Country Code |
368 | 511 | 144 | Filler |
Record Code 6 – Amendment File (or any other UCC3 filing)*
Start Position |
End Position |
Length | Description |
---|---|---|---|
1 | 1 | 1 | Record Code = 6 |
2 | 18 | 17 | Initial Filing Number |
19 | 30 | 12 | Filing Number of Filing |
31 | 34 | 4 | Amendment Filing Type) |
35 | 42 | 8 | Filing Date (YYYYMMDD) |
43 | 46 | 4 | Filing Time (HH24MI) |
47 | 50 | 4 | Page Count of UCC3 Filing |
51 | 58 | 8 | Filing Entry Date (YYYYMMDD) |
59 | 62 | 4 | Filing Entry Time (HH24MI) |
319 | 338 | 20 | Document Number of UCC3 Filing |
339 | 511 | 173 | Filler |
*Note: Master Record will be the initial filing and will be available in record code 6. For MR record: It will be UCC1’s filing number, document number, and page count. For all amendments (UCC3) it will be filing number, document number, and page count of UCC3 filing.
Record Code 9 – Trailer Record
Start Position |
End Position |
Length | Description |
---|---|---|---|
1 | 1 | 1 | Record Code = 9 |
2 | 13 | 12 | Filing Number = "999999999999" |
14 | 21 | 8 | Count of code 1 records |
22 | 29 | 8 | Count of code 2 records |
30 | 37 | 8 | Count of code 3 records |
38 | 45 | 8 | Count of code 4 records |
46 | 53 | 8 | Count of code 5 records |
54 | 61 | 8 | Count of code 6 records |
62 | 69 | 8 | Count of code 7 records |
70 | 79 | 10 | Grand total of all records (Exclusive of this, code 9, trailer record) |
80 | 89 | 10 | Date of file generation |
90 | 506 | 417 | Filler - Not Used |
Appendix A
Initial Filing Type (UCC1 Type)
UCC_TYPE_ID | UCC_TYPE |
---|---|
D | The code of “D” is not a Filing Type. This indicates that the record was deleted from the UCC index. |
Blank | Financing Statement |
A | Agricultural Lien |
I | Aircraft Maintenance Lien |
G | Contract Agricultural Lien |
F | Federal Lien |
M | Manufactured-Home Transaction |
P | Public-Finance Transaction |
R | Restitution Lien |
T | Transition Property Notice |
S | Transmitting Utility |
U | Utility Security Instrument |
E | Securitization Property Notice |
Amendment Filing Type (UCC3 Type)
UCC_TYPE_ID | UCC_TYPE |
---|---|
MR | Master Record (the initial filing document, UCC1)* |
AM | Amendment, Master Amendment |
A | Assignment, Master Assignment |
CC | Change Collateral Amendment |
CP | Change Party Amendment |
C | Continuation |
O | Correction |
IS | Information Statement |
J | Judicial Finding of Fact |
RV | Revoked, Revoked edit |
T | Termination |
*Master Record (the initial filing document, UCC1)is not an actual amendment type but is used to designate where the master record is inserted in the JSON file
**The Zip Code Extension field is not strictly required and is considered an arbitrary value.