Daily Index Extract Files
Story 1
Below are examples of the index files
Three files will be created each day document records are released to the public. Normally, release days are Monday through Friday excluding holidays. The data is in pipe (|) delimited format. Trailing spaces are trimmed from character data. Leading zeros are trimmed from numeric data. Blank fields are null (||-two sequential pipes).
CFN Files
MM-DDcfn.txt and MM-DDcfn-rec.txt are the CFN files and will contain one record per CFN (Clerk's File Number).
Example of a CFN record:
103523019|11/26/2003|091651|WD|206000.00|36494|876|O|PINEHURST 5-13 B LOT 1 LESS W 60,4 LESS W 60 BLK 2|8236010130|C|
This file contains the following:
| Clerk's File Number |
Up to 9 positions. Always present |
| Record Date |
MM/DD/YYYY Always present |
| Record Time |
HHMMSS Always present |
| Document Type Code |
Up to 10 positions. Always present. |
| Consideration Amount |
Monetary value (ex. 999.99) up to 19 positions. Records with no Consideration Amount will contain 0.00 |
| Book Number |
Book Number, up to six positions. Always present. |
| Page Number |
Page Number within a book, up to four positions. Always present. |
| Book Type |
Type of Book, (ex. O = Official Records Book, P = Plat Book, M = Map Book) one position. Always present. |
| Legal Description |
Up to 255 positions. May be present. |
| Parcel ID |
12 positions. May be present. |
| Re-record Flag |
C=Corrected Document, R=Re-recorded Document, one position. May be present. |
Name files
MM-DDnme.txt and MM-DDnme-rec.txt are the Name files and will contain one record per name indexed to a document. There can be multiple name records per new recording.
Examples of a Name record:
103524378|PALM VACATION GROUP|D|1|
103524378|SMITH,DONALD L|R|1|
103524378|SMITH,MICHELINA|R|2|
This file contains the following:
| Clerk's File Number |
Up to 9 positions. Always present |
| Party Name |
Up to 60 positions. Always present. |
| Party Type |
"D" indicates direct (from) party "R" indicates reverse (to) party. One position. Always present |
| Name Sequence |
Numeric, designates order in which name was indexed within a party type classification of a document. Always present</TD< TR> |
Link File
MM-DDlnk.txt is the Link file and will contain one record per link indexed to a document. It is used to link new recordings to prior related records (e.g., Satisfaction of Mortgage to the original Mortgage). There can be multiple link records per new recording.
Example of a Link record:
100000002|26000|102|O|SM|96416592|25304|988|O|M|
This file contains the following:
| Clerk's File Number |
Up to 9 positions. Always present |
| Book Number |
Book Number, up to six positions. Always present. |
| Page Number |
Page Number within a book, up to four positions. Always present. |
| Book Type |
Type of Book, (ex. O = Official Records Book, P = Plat Book, M = Map Book) one position. Always present. |
| Document Type Code |
Up to 10 positions. Always present. |
| Prior Clerk's File Number |
Up to 9 positions. Always present |
| Prior Book Number |
Book Number, up to six positions. Always present. |
| Prior Page Number |
Page Number within a book, up to four positions. Always present. |
| Prior Book Type |
Type of Book, (ex. O = Official Records Book, P = Plat Book, M = Map Book) one position. Always present. |
| Prior Document Type Code |
Up to 10 positions. Always present. |