Notary
Journal ASCII File Layout |
The
Notary Journal is transmitted as an ASCII Comma-Delimited text file.
This format allows for subsequent import into most spreadsheet or database
programs. The fields, their type and maximum lengths are provided in
the table below. |
Field | Type | Max Size | |
---|---|---|---|
Notary Id | Num | 7 | |
First Name | Chr | 30 | |
Middle Name | Chr | 20 | |
Last Name | Chr | 40 | |
Certificate Series | Chr | 2 | |
Certificate Number | Num | 6 | |
Issue Date (MMDDYY) | Chr | 6 | |
Expire Date (MMDDYY) | Chr | 6 | |
Bond Agency | Chr | 12 | |
Agency Appl Id | Chr | 12 | |
Trans Type | Chr | 3 | |
Address Restriction | Chr | 1 | If Y, Next Six Fields Will Be * Filled. |
Address | Chr | 30 | |
Address 2 | Chr | 30 | |
City | Chr | 30 | |
State | Chr | 2 | |
Zip | Chr | 9 | |
Phone | Chr | 10 | |
Emp Name | Chr | 50 | |
Emp Address | Chr | 30 | |
Emp Address 2 | Chr | 30 | |
Emp City | Chr | 30 | |
Emp State | Chr | 2 | |
Emp Zip | Chr | 9 | |
Emp Phone | Chr | 10 | |
Birth Date (MMDDYY) | Chr | 6 | |
Surety Company | Chr | 12 | |
Mailing Code | Chr | 1 | |
Mail Address | Chr | 30 | |
Mail Address 2 | Chr | 30 | |
Mail City | Chr | 30 | |
Mail State | Chr | 2 | |
Mail Zip | Chr | 9 |