NMLS — data dictionary
NMLS lender / loan-originator registry. · 20 fields · source FA NMLS Data Dictionary Layout v24 20250601 (v24 · 2025-06-01).
| Field | Type | Display | Code table | Description |
|---|---|---|---|---|
| MARKETSHARE INFORMATION | ||||
| FIPS | varchar(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. |
| CountyName | varchar(60) | Public Display | County Name Associated with the FIPS Code | |
| PropertyID | BigInt(19) | No Display | The First American Derived ID that uniquely identifies a property in the First American Database. | |
| ParcelNumber | 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. | |
| Address | varchar(116) | Public Display | Street Address: 123 S MAIN ST # 4 | |
| City | varchar(55) | Public Display | The city for the property address. | |
| State | varchar(2) | Public Display | Two letter state abbreviation for the property. | |
| ZipCode | varchar(9) | Public Display | Five digit code assigned by the USPS: 90001-1000 | |
| FATransactionID | BigInt(19) | No Display | First American unique number assigned to each transaction. | |
| RecordingDate | varchar(8) | Restricted Display | Date the transaction was recorded by the county/jurisdiction. | |
| MtgDocNbr | varchar(20) | Restricted Display | Recorder's document number for the Mortgage recording. | |
| MtgBookPage | varchar(101) | Restricted Display | Recorder's Book/Page value for the Mortgage recording. | |
| NMLS INFORMATION | ||||
| NMLSAgentID | varchar(64) | No Display | The Nationwide Mortgage Licensing System Loan Officer Identification Number. | |
| NMLSAgentName | varchar(200) | Restricted Display | The Nationwide Mortgage Licensing System Loan Officer Name. | |
| NMLSLenderID | varchar(250) | No Display | The Nationwide Mortgage Licensing System Lender Identification Number. | |
| NMLSLenderName | varchar(250) | Restricted Display | The Nationwide Mortgage Licensing System Lender Name. | |
| NMLSBrokerID | varchar(64) | No Display | The Nationwide Mortgage Licensing System Broker Identification Number. | |
| NMLSBrokerName | varchar(150) | Restricted Display | The Nationwide Mortgage Licensing System Broker Name. | |
| FIRST AMERICAN PROCESSING INFORMATION | ||||
| FATimestamp | varchar(8) | No Display | Timestamp applied to transaction records when created, edited, or deleted. Format: 20150925. | |
| RecordType | varchar(1) | No Display | I - Insert (new record). C & U - Change or Update to the record (treat the same). D = Record deleted. | |