Assignment & Release — data dictionary
Mortgage assignment + release (satisfaction) recordings. · 38 fields · source FA Assignment and Release Data Dictionary Layout v24 20250601 (v24 · 2025-06-01).
| Field | Type | Display | Code table | Description |
|---|---|---|---|---|
| PROPERTY IDENTIFICATION INFORMATION | ||||
| FIPS | char(5) | Public Display | FIPS | FIPS: Federal Information Processing Standard. Five digit code. First two digits represent the STATE, while the last three digits represent the COUNTY or county equivalents. |
| PropertyID | bigint(11) | No Display | The First American Derived ID that uniquely identifies a property in the First American Database. | |
| APN | varchar(45) | No Display | Assessor's Parcel Number or Parcel Identification Number. An arbitrary parcel identifier assigned by the county Assessor to simplify identification and expedite the locating of parcels. | |
| APNSeqNbr | varchar(3) | No Display | Internal sequence number assigned to Assessor Parcel Number. | |
| OldAPN | varchar(45) | No Display | OTHER APN (type is based on OldApnIndicator). | |
| TaxAccountNumber | varchar(45) | Restricted Display | When provided in the assessment files, an arbitrary parcel identifier usually assigned by the County Treasurer for tax purposes. | |
| PROPERTY ADDRESS INFORMATION | ||||
| SitusFullStreetAddress | varchar(116) | Restricted Display | Street Address: 123 S MAIN ST # 4 | |
| SitusHouseNbr | varchar(30) | Restricted Display | House Number: 123 S MAIN ST # 4 | |
| SitusHouseNbrSuffix | varchar(10) | Restricted Display | Alpha characters found to the right of the house number: 123 W S MAIN ST # 4 | |
| SitusDirectionLeft | varchar(2) | Restricted Display | Alpha characters found to the left of the street name: 123 S MAIN ST # 4 | |
| SitusStreet | varchar(60) | Restricted Display | Name or number of the street. 123 S MAIN ST # 4 | |
| SitusMode | varchar(5) | Restricted Display | Suffix of the Street: 123 S MAIN ST # 4 | |
| SitusDirectionRight | varchar(2) | Restricted Display | Represents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4 | |
| SitusUnitType | varchar(10) | Restricted Display | The type used in the property address for the unit: 123 S Main St # 4 | |
| SitusUnitNbr | varchar(15) | Restricted Display | The unit or suite number of the property address: 123 S Main St # 4 | |
| SitusCity | varchar(30) | Restricted Display | The city for the property address. | |
| SitusState | varchar(2) | Restricted Display | Two letter state abbreviation for the property. | |
| SitusZIP5 | varchar(9) | Restricted Display | Five digit code assigned by the USPS: 90001-1000 | |
| SitusZIP4 | varchar(9) | Restricted Display | Four digit code assigned by the USPS: 90001-1000 | |
| SitusCarrierCode | varchar(4) | Restricted Display | Four digit code used by the local mail carrier to identify delivery path. | |
| ASSIGNMENT AND RELEASE INFORMATION | ||||
| FATransactionID | bigint(11) | No Display | First American unique number assigned to each transaction. | |
| DocumentNbr | varchar(20) | Restricted Display | Recorder's Document Number. | |
| RecordingBook | varchar(10) | Restricted Display | Recorder's Book Number. | |
| RecordingPage | varchar(10) | Restricted Display | Recorder's Page Number. | |
| RecordingDate | varchar(8) | Restricted Display | Date on which the Assignment / Release was publicly recorded with the county / local jurisdiction. | |
| ContractDate | varchar(8) | Restricted Display | Date of execution of the document (typically, the signature date on the instrument. | |
| DocumentType | varchar(2) | Restricted Display | DOC_TYPE | Document type use to record the assignment and release. |
| BorrowerFullName | varchar(60) | Restricted Display | Full name of borrower. | |
| NewLenderName | varchar(60) | Restricted Display | Name of the new lender on assignment documents. | |
| OriginalLenderName | varchar(60) | Restricted Display | Original lender name from the original mortgage. | |
| OriginalMortgageDate | varchar(8) | Restricted Display | Original recording date of the original mortgage. | |
| OriginalDocumentNbr | varchar(20) | Restricted Display | Original recorder's document number from the original mortgage. | |
| OriginalBook | varchar(10) | Restricted Display | Original recorder's book number from the original mortgage. | |
| OriginalPage | varchar(10) | Restricted Display | Original recorder's page number from the original mortgage. | |
| OriginalLoanAmt | varchar(15) | Restricted Display | Original Loan amount from the original mortgage. | |
| OriginalFATransactionID | bigint(11) | No Display | Original First American unique number assigned of the original mortgage. | |
| ADDITIONAL FA PROCESSING INFORMATION | ||||
| FATimeStamp | datetime2(15) | No Display | Timestamp applied to transaction records when created, edited, or deleted. Format: 20150925. | |
| FARecordType | char(1) | No Display | I - Insert (new record). C & U - Change or Update to the record (treat the same). D = Record deleted. | |
Code tables · 1 tables, 122 codes
DOC_TYPE122 codes
| CODE | DESCRIPTION |
|---|---|
| 1 | Assignment of Sub Agreement of Sale (Hawaii) |
| 2 | Assignment of Sub Lease (Hawaii) |
| 3 | Assignment of Commercial Lease (Hawaii) |
| 4 | Administrator’s Deed |
| 5 | Affidavit |
| 6 | Agreement of Sale |
| 7 | Assignment of Agreement of Sale (Hawaii) |
| 8 | Assignment Deed (or Condo Deed if Land Use = "CND") |
| 9 | Affidavit of Trust or Trust Agreement (Los Angeles) |
| 10 | Assignment of Sub Commercial Lease (Hawaii) |
| 11 | Beneficiary Deed (Buyer ID = "BE") |
| 12 | Bargain and Sale Deed |
| 13 | Commissioners Assignment of Lease (Hawaii) |
| 14 | Condominium Deed |
| 15 | Cash Sale Deed |
| 16 | Commercial Lease (Hawaii) |
| 17 | Commissioner’s Deed - North Carolina in probate-related transfers. In Hawaii foreclosure-related transfers. |
| 18 | Cancellation of Agreement of Sale (Hawaii) |
| 19 | Conservator’s Deed |
| 20 | Corporation Deed |
| 21 | Correction Deed |
| 22 | Contract of Sale |
| 23 | Certificate of Transfer |
| 24 | Deed of Distribution |
| 25 | Declaration |
| 26 | Transfer on Death Deed |
| 27 | Deed |
| 28 | Deed of Guardian |
| 29 | Affidavit of Death of Joint Tenant |
| 30 | Deed in Lieu of Foreclosure |
| 31 | Distress Sale |
| 32 | Exchange |
| 33 | Executor’s Deed |
| 34 | Foreclosure |
| 35 | Fiduciary Deed |
| 36 | Grant Deed |
| 37 | Gift Deed |
| 38 | Ground Lease |
| 39 | Individual Deed |
| 40 | Intrafamily Transfer & Dissolution |
| 41 | Joint Tenancy Deed |
| 42 | Legal Action/Court Order |
| 43 | Leasehold Conv. With Agreement of Sale (Fee Purchase) (Hawaii) |
| 44 | Land Contract |
| 45 | Lease (Hawaii) |
| 46 | Assignment of Lease (Leasehold Sale) (Hawaii) |
| 47 | Leasehold Conv. with an Agreement of Sale (Hawaii) |
| 48 | Land Court (Massachusetts) |
| 49 | Limited Warranty Deed |
| 50 | Special Master Deed |
| 51 | Other |
| 52 | Public Action - Common in Florida (Clerks Tax Deed or Tax Deeds or property sold for taxes. |
| 53 | Partnership Deed |
| 54 | Personal Representatives Deed |
| 55 | Quit Claim Deed |
| 56 | Satisfaction of Land Contract (WI) or Release/Satisfaction of Agreement of Sale (Fee Property) (HI) |
| 57 | Receiver’s Deed |
| 58 | Redemption Deed |
| 59 | Referee’s Deed - transfer pursuant to a foreclosure sale (NY) |
| 60 | Release/Satisfaction of Agreement of Sale (Leasehold) (Hawaii) |
| 61 | Re-recorded Document |
| 62 | Sub Agreement of Sale (Hawaii) |
| 63 | Sub Commercial Lease (Hawaii) |
| 64 | Sheriff’s Deed |
| 65 | Sub Lease (Hawaii) |
| 66 | Affidavit Death of Trustee/Successor Trustee (Los Angeles) |
| 67 | Survivorship Deed |
| 68 | Special Warranty Deed |
| 69 | Trustee’s Deed (Certificate of Title) |
| 70 | Vendor’s Lien |
| 71 | Warranty Deed |
| 72 | Transaction History Record |
| 73 | Foreclosure Cancelled |
| 74 | Certificate of Purchase/Certificate of Foreclosure Recorded |
| 75 | Order Rescheduling Foreclosure Sale Date |
| 76 | Foreclosure Judgment Entered |
| 77 | Notice of Default |
| 78 | PreForeclosure Newly Filed Complaint |
| 79 | Notice of Lis Pendens |
| 80 | Notice of Rescission |
| 81 | Notice of Foreclosure Sale |
| 82 | Notice of Trustee Sale |
| 83 | Order of Dismissal/ Cancellation/ Release of Lis Pendens |
| 84 | Re-recorded Notice of Default |
| 85 | Re-recorded Final Judgment of Foreclosure |
| 86 | Re-recorded Notice of Lis Pendens |
| 87 | Re-Recorded Order of Dismissal |
| 88 | Re-Recorded Notice of Rescission |
| 89 | NF/NS updated with Sale Information (Rescheduled) |
| 90 | Re-recorded Notice of Trustee's Sale |
| 91 | PreForeclosure Sold |
| 92 | Re-recorded Notice of Sale |
| 93 | Stand Alone Mortgage |
| 94 | Assignment of Mortgage |
| 95 | Affidavit of Lost (or Missing) Assignment |
| 96 | Correction Assignment |
| 97 | Miscellaneous Assignment. Partial interest assignment |
| 98 | Master Assignment. Single document for assignment of several mortgages |
| 99 | Rerecorded Assignment |
| A | Substitution of Trustee and Assignment of Deed of Trust |
| B | Full Release WITH a legal description |
| C | Multiple Release. One document release several mortgages |
| D | Partial Release WITH a legal description |
| E | Partial Release with NO legal description |
| F | Full Release with NO legal description |
| G | Substitution of Trustee and Full Reconveyance |
| H | Mortgage |
| K | Assessor Sales History |
| L | Divorce/Dissolution of Marriage Transfer |
| M | Affidavit of Death of Life Tenant |
| N | REO Sale (REO Out) |
| O | Quit Claim Deed (arm's length) |
| P | Owelty Deed / Owelty Agreement |
| Q | Re-Recorded Partial Release of Lis Pendens |
| R | Mineral Rights Deed |
| S | Re-Recorded Power of Attorney to Foreclose |
| U | Assignment of Final Judgement of Foreclosure |
| V | Affidavit- Notice of Sale (published or mailed) |
| W | Power of Attorney to Foreclose Mortgage |
| X | Partial Release of Lis Pendens |
| Y | Deed to Secure Debt/Security Deed |
| DT | Affidavit of Death of Life Tenant |