Overview › Resources › First American › Deed & Mortgage

Deed & Mortgage — data dictionary

Recorded sale + loan events — the transaction history. · 181 fields · source FA Deed and Mortgage Data Dictionary Layout v24 20251114 (v24 · 2025-11-14).

REI sale labels (y_sold) and Tier C/D leverage + mortgage-age features.

Field	Type	Display	Code table	Description
PROPERTY IDENTIFICATION 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.
PropertyID	Big Int(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.
MatchedFlag	varchar(1)	No Display		First American Flag indicating if the transaction is matched to the current assessment/tax roll file.
PROPERTY ADDRESS INFORMATION
SitusHouseNbr	varchar(30)	Public Display		House Number: 123 S MAIN ST # 4
SitusHouseNbrSuffix	varchar(10)	Public Display		Alpha characters found to the right of the house number: 123 W S MAIN ST # 4
SitusDirectionLeft	varchar(2)	Public Display		Alpha characters found to the left of the street name: 123 S MAIN ST # 4
SitusStreet	varchar(60)	Public Display		Name or number of the street. 123 S MAIN ST # 4
SitusMode	varchar(10)	Public Display		Suffix of the Street: 123 S MAIN ST # 4
SitusDirectionRight	varchar(2)	Public Display		Represents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4
SitusUnitType	varchar(20)	Public Display		The type used in the property address for the unit: 123 S Main St # 4
SitusUnitNbr	varchar(15)	Public Display		The unit or suite number of the property address: 123 S Main St # 4
SitusCity	varchar(55)	Public Display		The city for the property address.
SitusState	varchar(2)	Public Display		Two letter state abbreviation for the property.
SitusZIP5	varchar(5)	Public Display		Five digit code assigned by the USPS: 90001-1000
SitusZIP4	varchar(4)	Public 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.
BUYER 1
BuyerBorrower1CorpInd	varchar(1)	Restricted Display		First Buyer or Borrower identified as a corporation.
BuyerBorrower1Name	varchar(60)	Restricted Display		Buyer or Borrower Full Name.
BuyerBorrower1EtalInd	varchar(1)	Restricted Display		Indicator were additional names exist, but are not represented on the record provided.
BuyerBorrower1CareOfName	varchar(60)	No Display		Mailing Care Of Name.
BuyerBorrower1OwnershipRightsCode	varchar(3)	Restricted Display	OWNER_VEST	Vesting type declared for the owner/buyer party names.
BuyerBorrower1RelationshipType	varchar(3)	No Display	RELATION	Relationship type declared for the owner/buyer party names.
BUYER 2
BuyerBorrower2CorpInd	varchar(1)	Restricted Display		Second Buyer or Borrower identified as a corporation.
BuyerBorrower2Name	varchar(60)	Restricted Display		Buyer or Borrower Full Name
BuyerBorrower2OwnershipRightsCode	varchar(3)	Restricted Display	OWNER_VEST	Vesting type declared for the owner/buyer party names.
BuyerBorrower2RelationshipType	varchar(3)	No Display	RELATION	Relationship type declared for the owner/buyer party names.
BUYER NAMES
BuyerBorrower1LastName	varchar(30)	Restricted Display		First Owner Last name.
BuyerBorrower1FirstName	varchar(32)	Restricted Display		First Owner First name.
BuyerBorrower1MiddleInitial	varchar(10)	Restricted Display		First Owner Middle name.
BuyerBorrower1NameSuffix	varchar(10)	Restricted Display		First Owner Generation identifier.
BuyerBorrower2LastName	varchar(30)	Restricted Display		Second Owner Last name.
BuyerBorrower2FirstName	varchar(32)	Restricted Display		Second Owner First name.
BuyerBorrower2MiddleInitial	varchar(10)	Restricted Display		Second Owner Middle name.
BuyerBorrower2NameSuffix	varchar(10)	Restricted Display		Second Owner Generation identifier.
MAIL ADDRESS INFORMATION
MailingHouseNbr	varchar(30)	No Display		House Number: 123 S MAIN ST # 4
MailingHouseNbrSuffix	varchar(10)	No Display		Alpha characters found to the right of the house number: 123 W S MAIN ST # 4
MailingDirectionLeft	varchar(2)	No Display		Alpha characters found to the left of the street name: 123 S MAIN ST # 4
MailingStreet	varchar(60)	No Display		Name or number of the street. 123 S MAIN ST # 4
MailingMode	varchar(10)	No Display		Suffix of the Street: 123 S MAIN ST # 4
MailingDirectionRight	varchar(2)	No Display		Represents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4
MailingUnitType	varchar(20)	No Display		The type used in the mailing address for the unit: 123 S Main St # 4
MailingUnitNbr	varchar(15)	No Display		The unit or suite number of the mailing address: 123 S Main St # 4
MailingCity	varchar(55)	No Display		The city for the mailing address.
MailingState	varchar(2)	No Display		Two letter state abbreviation for the mailing address.
MailingZIP5	varchar(9)	No Display		Five digit code assigned by the USPS: 90001-1000
MailingZIP4	varchar(4)	No Display		Four digit code assigned by the USPS: 90001-1000
MailingCarrierCode	varchar(4)	No Display		Four digit code used by the local mail carrier to identify delivery path.
MailingCountyFipsCode	varchar(5)	No Display		County FIPS for Mailing Address.
MailingForeignAddressInd	varchar(1)	No Display		Indicates the mailing address is a foreign address. C = Canadian, everything else = 'Y'
SALES INFORMATION
FATransactionID	bigint(20)	No Display		First American unique number assigned to each transaction.
RecordingDate	varchar(8)	Restricted Display		Date on which Deed / Instrument was publicly recorded with the county / local jurisdiction.
SaleDate	varchar(8)	Restricted Display		Date of execution of the document (typically, the signature date on the instrument.
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.
HawaiiLandCourtDocumentNbr	varchar(20)	Restricted Display		Alternate recording document number in the HI Land Court index.
HawaiiCertificateNbr	varchar(20)	Restricted Display		Certificate of Title recorded for properties in the HI Land Court index.
WAExiceNbr	varchar(20)	Restricted Display		Excise Tax Number listed on the recorded document for State of Washington.
DocumentType	varchar(2)	Restricted Display	DOC_TYPE	Instrument type. i.e. Grant Deed / Warranty Deed / etc…
TransactionType	varchar(1)	Restricted Display	TRAN_TYPE	First American code indicating the type of transaction.
Seller1Name	varchar(60)	Restricted Display		First Seller's Name
Seller1CorpInd	varchar(1)	Restricted Display		First Seller identified as a corporation.
Seller2Name	varchar(60)	Restricted Display		Second Seller's Name
Seller2CorpInd	varchar(1)	Restricted Display		Second Seller identified as a corporation.
SaleAmt	varchar(15)	Restricted Display		Sale Price
SalesPriceCode	varchar(2)	Restricted Display	SALE_PRICE	Describes how the Sales Price was derived or calculated.
TransferTax	varchar(15)	Restricted Display		Documentary Transfer Tax paid in the sale/transfer of the property(ies), if any.
PartialInterestFlag	varchar(1)	Restricted Display	PARTIAL_INT_IND	First American Indicator when a partial interest of the property is transferred.
ResaleFlag	varchar(1)	Restricted Display		First American Flag indicating the sale of previously sold property. i.e. resale of a existing home.
NewConstructionFlag	varchar(1)	Restricted Display		First American Flag indicating the sale of a new home. i.e. builder sells home to a family.
InterFamilyFlag	varchar(1)	Restricted Display		First American Flag indicating the sale or transfer is between related parties.
ForeclosureFlag	varchar(1)	Restricted Display		First American Flag indicating the sale or transfer is at auction by an investor or repossession by a financial institution.
REOSaleFlag	varchar(1)	Restricted Display		First American Flag indicating the sale is by a financial institution back to the open market after a foreclosure.
MORTGAGE 1
FirstMtgRecordingDate	varchar(8)	Restricted Display		Date on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
FirstMtgDocumentDate	varchar(8)	Restricted Display		Date of execution of the document (typically, the signature date on the instrument.
FirstMtgDocumentNbr	varchar(20)	Restricted Display		Recorder's Document Number.
FirstMtgBook	varchar(10)	Restricted Display		Recorder's Book Number.
FirstMtgPage	varchar(10)	Restricted Display		Recorder's Page Number.
FirstMtgDocumentType	varchar(2)	Restricted Display		Instrument type. i.e. Mortgage / Deed of Trust.
FirstMtgAmt	int(15)	Restricted Display		Mortgage Amount.
FirstMtgLenderName	varchar(60)	Restricted Display		Name of the Lender.
FirstMtgLoanTransType	varchar(3)	Restricted Display	LOAN_TRAN_TYPE	Type of mortgage.
FirstMtgLoanType	varchar(2)	Restricted Display	LOAN_TYPE	First American code indicating the type of loan.
FirstMtgTermCode	varchar(1)	Restricted Display		The length of the mortgage in months "M" or years "Y".
FirstMtgTerm	varchar(4)	Restricted Display		Mortgage term. Use the above MtgTerm code to determine if the term is in months or years.
FirstMtgDueDate	varchar(8)	Restricted Display		Maturity / Final due date of the loan.
FirstMtgInterestRateType	varchar(3)	Restricted Display	FIN_TYPE	Interest rate type on the mortgage instrument.
FirstMtgInterestRate	varchar(7)	Restricted Display		Interest rate on a fixed interest rate loan or the starting rate of an adjustable rate loan.
FirstMtgEstimatedInterestRateInd	varchar(1)	No Display	MTG_EST_RT_IND	Indicates if the above mentioned interest rate is estimated.
FirstMtgSellerCarryBackFlag	varchar(1)	Restricted Display		First American Flag indicating the loan is a Seller Carried Loan.
FirstMtgPrivatePartyLender	varchar(1)	Restricted Display		First American Flag indicating the loan is issued by a Private Party.
FirstMtgConstructionLoan	varchar(1)	Restricted Display		First American Flag indicating the loan is used for construction purposes.
FirstMtgRefiFlag	varchar(1)	Restricted Display		First American Flag indicating the loan is a refinance of an existing mortgage.
FirstMtgEquityFlag	varchar(1)	Restricted Display		First American indicating an equity loan.
FirstMtgHelocFlag	varchar(1)	Restricted Display		First American Flag indicating loan is a HELOC or Credit Line.
FirstMtgOtherSubordinateLoanFlag	varchar(1)	Restricted Display		First American Flag indicating a subordinate loan, not coded as a Refinance or Equity.
FirstMtgSecondHomeRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Second Home Rider.
FirstMtgCondominiumRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Condominium Rider.
FirstMtgMultiFamily4Rider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a MultiFamily 4 Rider.
FirstMtgPlannedUnitDevelopmentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Planned Unit Development Rider.
FirstMtgAssumabilityRider	varchar(1)	Restricted Display		Flag indicating the loan is assumable.
FirstMtgBalloonRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Balloon Rider.
FirstMtgBiweeklyPaymentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Bi-Weekly Payment Option.
FirstMtgFixedStepRateRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Conversion to a Fixed Rate Rider.
FirstMtgGraduatedPaymentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Graduated Payment Rider.
FirstMtgPrepaymentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Prepayment Rider.
FirstMtgRateImprovementRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Rate Improvement Rider.
FirstMtgAdjustableRateRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Adjustable Rate Rider.
FirstMtgAdjustableRateIndex	varchar(20)	Restricted Display		Identifies the type of index the Adjustable Loan is tied to.
FirstMtgChangeIndex	varchar(7)	Restricted Display		Identifies the margin (expressed as a percentage) that is added by the Lender to the interest rate derived from the index. If not available, then the value represents the maximum change in the interest rate at any one time.
FirstMtgFirstChangeDateMonthDay	varchar(4)	Restricted Display		Month and Day of First Interest Rate Change.
FirstMtgFirstChangeDateYear	varchar(4)	Restricted Display		Year of the First Interest Rate Change.
FirstMtgInterestOnlyPeriod	varchar(3)	Restricted Display		The period of time the borrower can pay only the interest on the mortgage.
FirstMtgMaximumInterestRate	varchar(7)	Restricted Display		Maximum Interest Rate allowed on the mortgage.
FirstMtgMinimumInterestRate	varchar(7)	Restricted Display		Minimum Interest Rate allowed on the mortgage.
FirstMtgRateChangeFrequency	varchar(3)	Restricted Display	CHG_FREQ	Indicates the frequency the Interest Rates may change.
MORTGAGE 2
SecondMtgRecordingDate	varchar(8)	Restricted Display		Date on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
SecondMtgDocumentDate	varchar(8)	Restricted Display		Date of execution of the document (typically, the signature date on the instrument.
SecondMtgDocumentNbr	varchar(20)	Restricted Display		Recorder's Document Number.
SecondMtgBook	varchar(10)	Restricted Display		Recorder's Book Number.
SecondMtgPage	varchar(10)	Restricted Display		Recorder's Page Number.
SecondMtgDocumentType	varchar(2)	Restricted Display		Instrument type. i.e. Mortgage / Deed of Trust.
SecondMtgAmt	int(15)	Restricted Display		Mortgage Amount.
SecondMtgLenderName	varchar(30)	Restricted Display		Name of the Lender.
SecondMtgLoanTransType	varchar(3)	Restricted Display	LOAN_TRAN_TYPE	Type of mortgage.
SecondMtgLoanType	varchar(2)	Restricted Display	LOAN_TYPE	First American code indicating the type of loan.
SecondMtgTermCode	varchar(1)	Restricted Display		The length of the mortgage in months "M" or years "Y".
SecondMtgTerm	varchar(4)	Restricted Display		Mortgage term. Use the above MtgTerm code to determine if the term is in months or years.
SecondMtgDueDate	varchar(8)	Restricted Display		Maturity / Final due date of the loan.
SecondMtgInterestRateType	varchar(3)	Restricted Display	FIN_TYPE	Interest rate type on the mortgage instrument.
SecondMtgInterestRate	varchar(7)	Restricted Display		Interest rate on a fixed interest rate loan or the starting rate of an adjustable rate loan.
SecondMtgEstimatedInterestRateInd	varchar(1)	No Display	MTG_EST_RT_IND	Indicates if the above mentioned interest rate is estimated.
SecondMtgSellerCarryBackFlag	varchar(1)	Restricted Display		First American Flag indicating the loan is a Seller Carried Loan.
SecondMtgPrivatePartyLender	varchar(1)	Restricted Display		First American Flag indicating the loan is issued by a Private Party.
SecondMtgConstructionLoan	varchar(1)	Restricted Display		First American Flag indicating the loan is used for construction purposes.
SecondMtgRefiFlag	varchar(1)	Restricted Display		First American Flag indicating the loan is a refinance of an existing mortgage.
SecondMtgEquityFlag	varchar(1)	Restricted Display		First American indicating an equity loan.
SecondMtgHelocFlag	varchar(1)	Restricted Display		First American Flag indicating loan is a HELOC or Credit Line.
SecondMtgOtherSubordinateLoanFlag	varchar(1)	Restricted Display		First American Flag indicating a subordinate loan, not coded as a Refinance or Equity.
SecondMtgSecondHomeRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Second Home Rider.
SecondMtgCondominiumRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Condominium Rider.
SecondMtgMultiFamily4Rider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a MultiFamily 4 Rider.
SecondMtgPlannedUnitDevelopmentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Planned Unit Development Rider.
SecondMtgAssumabilityRider	varchar(1)	Restricted Display		Flag indicating the loan is assumable.
SecondMtgBalloonRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Balloon Rider.
SecondMtgBiweeklyPaymentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Bi-Weekly Payment Option.
SecondMtgFixedStepRateRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Conversion to a Fixed Rate Rider.
SecondMtgGraduatedPaymentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Graduated Payment Rider.
SecondMtgPrepaymentRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Prepayment Rider.
SecondMtgRateImprovementRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Rate Improvement Rider.
SecondMtgAdjustableRateRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Adjustable Rate Rider.
SecondMtgAdjustableRateIndex	varchar(20)	Restricted Display		Identifies the type of index the Adjustable Loan is tied to.
SecondMtgChangeIndex	varchar(7)	Restricted Display		Identifies the margin (expressed as a percentage) that is added by the Lender to the interest rate derived from the index. If not available, then the value represents the maximum change in the interest rate at any one time.
SecondMtgFirstChangeDateMonthDay	varchar(4)	Restricted Display		Month and Day of First Interest Rate Change.
SecondMtgFirstChangeDateYear	varchar(4)	Restricted Display		Year of the First Interest Rate Change.
SecondMtgInterestOnlyPeriod	varchar(3)	Restricted Display		The period of time the borrower can pay only the interest on the mortgage.
SecondMtgMaximumInterestRate	varchar(7)	Restricted Display		Maximum Interest Rate allowed on the mortgage.
SecondMtgMinimumInterestRate	varchar(7)	Restricted Display		Minimum Interest Rate allowed on the mortgage.
SecondMtgRateChangeFrequency	varchar(3)	Restricted Display	CHG_FREQ	Indicates the frequency the Interest Rates may change.
LEGAL DESCRIPTION
LotCode	varchar(2)	Restricted Display	LOT_CODE	Identifies properties which include more than one lot or partial lots.
LotNbr	varchar(7)	Restricted Display		The lot number or numbers if the lot is comprised of multiple lots. Population as allowed by the field length, separated with a comma (,) or ampersand (&). A hyphen (-) is used to indicate a range. Refer to Lot Code.
LandLot	varchar(10)	Restricted Display		A large portion or tract of land (which may also encompass many individual blocks or lots) in which the property is located.
Block	varchar(7)	Restricted Display		The block of the subdivision or city in which the property is located.
Section	varchar(7)	Restricted Display		Section of the city in which the property is located. Not related to Section / Township / Range.
District	varchar(12)	Restricted Display		The district in which the property is located. Usually a numeric or text code corresponding to the City, Municipality, Township.
LegalUnit	varchar(6)	Restricted Display		The subdivision unit number. Common for condominiums, townhomes, etc. Not necessarily the same as the Property Unit Number.
Municipality	varchar(30)	Restricted Display		The jurisdiction in which the property is located. May be “Unincorporated”, if applicable. Often a description of the value provided in District. Not necessarily the same as the Property City.
SubdivisionName	varchar(40)	Restricted Display		The name of the subdivision, plat, or tract.
SubdivisionPhaseNbr	varchar(7)	Restricted Display		Generally, the phase of a subdivision or tract development.
SubdivisionTractNbr	varchar(10)	Restricted Display		The number of the tract in which the property is located. "POR" = portion when provided.
Meridian	varchar(30)	Restricted Display		Contains the Section/Township/Range. Format: ZZ QTR SEC 99 TWN 99A RNG 99A QTR where provided. A = Directional (N/S for TWN and E/W for RNG).
AssessorsMapRef	varchar(15)	Restricted Display		Standardized to identify each portion. Multiples indicated with the ampersand (&), and ranges separated with a hyphen (-). Depending on the length of the Map Reference, spaces may be omitted.
LegalDescription	varchar(250)	No Display		Legal Description captured from Assessor / local authority.
TITLE COMPANY DESCRIPTION
TitleCompanyName	varchar(60)	No Display		Name of the recording company. Typically this is the title company, but recording services and attorney codes are also collected.
ADDITIONAL TRANSACTION INFORMATION
MultiAPN	varchar(1)	No Display	MULTIAPN	Indicator if more than one property is involved in the transaction.
FATimeStamp	datetime(15)	No Display		Timestamp applied to transaction records when created, edited, or deleted. Format: 20150925.
FARecordType	varchar(1)	No Display		I - Insert (new record). C & U - Change or Update to the record (treat the same). D = Record deleted.

Code tables · 13 tables, 466 codes

Lookup values referenced by the fields above. Click a field’s code-table link to jump here.

CHG_FREQ11 codes

CODE	DESCRIPTION
M	Monthly - Revolving Credit monthly, unless otherwise stated on document.
Q	Quarterly
S	Six months or Semi-annually
A	Annually
2	Two Years
3	Three Years
4	Four Years
F	Five Years - May be reported on document as "every 60th month".
7	Seven Years
T	Ten Years
E	Fifteen Years

DOC_TYPE87 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
74	Certificate of Purchase/Certificate of Foreclosure Recorded
91	PreForeclosure Sold
93	Stand Alone Mortgage
F	Full Release with NO legal description
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
R	Mineral Rights Deed
Y	Deed to Secure Debt/Security Deed
DE	Deed
DT	Affidavit of Death of Life Tenant

FIN_TYPE9 codes

CODE	DESCRIPTION
ADJ	Adjustable Rate
AITD	All Inclusive DOT-Legacy
BAL	Balloon
FIX	Fixed Rate
MUL	Multiple Loan Amounts
OTH	Other
STP	Step Interest Rate
UNK	Unknown
VAR	Variable

LOAN_TRAN_TYPE6 codes

CODE	DESCRIPTION
1	HELOCS - both Purchase Money and Non-Purchase
2	REFI LOANS and 2ND TRUST DEEDS - both Purchase Money and Non-Purchase
3	RESALE PURCHASE MONEY LOANS - subset of TRANSACTION TYPE 2
4	CONSTRUCTION LOANS - both Purchase Money and Non-Purchase (LOAN TYPE "B")
5	NEW RESIDENTIAL PURCHASE MONEY LOANS - subset of TRANSACTION TYPE 3
6	NON-RESIDENTIAL Mortgages - both Purchase Money and Non-Purchase

LOAN_TYPE34 codes

CODE	DESCRIPTION
1	Stand Alone First
2	Stand Alone Second
3	ARM (Adjustable Rate Mortgage)
4	Amount keyed is an Aggregate amount
5	USDA
6	Closed-end Mortgage
7	Assumption
8	Building or Construction Loan
9	Cash
10	2nd Mortgage made to cover Down Payment
11	Credit Line (Revolving)
12	FHA
13	Fannie Mae/Freddie Mac (Fannie Mae does not originate loans directly to borrowers or investors. Most "new conventional" loans meet their general underwriting guidelines.)
14	Balloon
15	Farmers Home Administration
16	Negative Amortization
17	Loan Amount $1-9 billion - first 9-digits Loan Amount x 10 = actual amount.
18	Land Contract (Argmt. Of Sale)
19	Mortgage Modification
20	New Conventional
21	Commercial
22	Purchase Money Mortgage
23	Undefined / Multiple Amounts
24	Stand Alone Refi (Refinance of Original Loan)
25	Seller take-back
26	Loan Amount $10-99 billion - first 9-digits of Loan Amount x 100 = actual amount.
27	Unknown (DEFAULT)
28	VA
29	Future Advance Clause / Open End Mortgage
30	Trade
31	State Veterans (code phased out August 17, 2020)
32	Reverse Mortgage (Home Equity Conversion Mortgage)
33	Non Purchase Money Mortgage
34	SBA Participation Trust Deed

LOT_CODE4 codes

CODE	DESCRIPTION
M	More than one lot
MP	Multiple w/a portion of one or more lots
P	Portion of a lot
1-99	Single Lot number

MTG_EST_RT_IND3 codes

CODE	DESCRIPTION
B	Provided
E	Estimated
F	FHA

MULTIAPN9 codes

CODE	DESCRIPTION
1	Multi-APN
2	Multi-APN researched.
3	Unable to match deed record to its corresponding assessment record and deed APN pulls up a totally different assessment record.
4	Portion of property sold (Ex- 5,000 SF of a 10,000 SF lot).
5	Multiple Tax ID's on document (Tax ID is another parcel identifier that is not an APN).
6	APNs formatted, by adding leading zeros, in ORANGE, CA. Code phased out April 2001.
7	Complete Legal Description Code Legal fields outside of Legal City, S/T/R, Lot Size were skipped for keying due to only metes and bounds presented. No specific lot number, block number, subdivision, tract, etc. given
8	This is simply the first record keyed for the first listed APN of a sale. If there is only 1 APN, code 8 still applies. Subsequent records for additional APN's would have code 2
9	Dependant Property of a Multi Parcel Sale

OWNER_RELATION126 codes

CODE	DESC
99	Heirs
AB	Alternate Beneficiary
AC	Guardian/Custodian
AD	Administrator
AE	Assignee (Buyer/Borrower only)
AF	Name derived from Affidavit
AG	Agent or Guardian
AK	Also known as (A/K/A)
AL	All as/Undefined
AO	Alter Ego
AR	Assignor (Seller only)
AS	Association
BE	Beneficiary / Creditor - Doc Type BD, buyer ID identifies designated to acquire title upon death of Grantor.
BS	Brother & Sister
BU	Builder/Developer
CE	Corporate Trustee
CF	Contract Purchasor
CN	Corporation
CO	Company
CP	Community Property (Marital Community)
CR	Community Property (Marital Community) with rights of survivorship
CT	Corporate Trust
DB	Doing business as (DBA)
DC	Deceased
DE	DECEASED
DF	Defendant
DP	Domestic Partner
DR	Divorced not Remarried
DS	Disabled
DV	Divorced
DW	Dower Clause
EA	Et al (and others) - vendor data only
ES	Estate
EU	Et ux (and wife) - vendor data only
EX	Executor / Administrator
FK	Formerly known as (F/K/A)
FL	Family Living Trust
FM	Family Trust
FR	Family Revocable Trust
GD	Guardian
GN	General Partnership
GP	General Partner
GV	Government
HE	Heirs
HH	Her Husband
HU	Husband and Husband
HW	Husband and Wife
IA	IRA (Individual Retirement Account)
ID	Individual(s)
IL	Irrevocable Living Trust
IN	incompetent
IR	Irrevocable Trust
JS	Joint tenants with right of survivorship
JT	Joint Tenants
JV	Joint Venture
L2	Seller is owner on current Assessment File
LB	Life Benefit Estate
LC	Limited Liability Company
LE	Life Estate (phased out Spring, 2009, now Buyer/Borrow ID Code = "LT".)
LF	Lease From
LL	Limited Liability Partnership
LP	Limited Partnership
LS	Limited Partnership
LT	Life Tenant
LV	Living Trust
LW	Last Will and Testament
MA	Married
MC	Married Couple
ME	Member
MI	Minor, Ward or Client (Represented by Trustee)
MM	Married Man as his sole and separate property
MN	Managing Member
MP	Married Person
MW	Married Woman as her sole and separate property
NK	Now Known as
NM	Never Married Person
NP	Not Provided (name blurred or missing from document)
NT	Non Declared Trust
NV	Non-Vested Spouse
PA	Partnership
PF	Plaintiff
PR	Personal Representative
PS	Partnership
PT	Personal Trust
RC	Receiver
RL	Revocable Living Trust
RM	Remainderman
RS	Right of Survivorship
RT	Revocable Trust
SE	Separate Property
SG	Single
SI	Successor in Interest
SJ	Surviving Joint Tenant
SL	Sole Proprietorship
SM	Single man
SO	Sole and Separate
SP	Survivorship Martial Property (Wisconsin/Alaska with marital property system effective 01/01/1986. )
SS	Surviving Spouse
ST	Successor Trustee (LA County only)
SU	Survivor
SV	Tenants in Severalty
SW	Single woman
SX	Separated
SY	Survivorship Martial Property -- This code will be used primarily in Wisconsin/Alaska who adopted a marital property system effective 01/01/1986.
TC	Tenants in Common
TD	Transfer of Death
TE	Tenants by Entireties
TN	Tenant
TR	Trust
TS	Trustor/Debtor (Borrower in Default/Foreclosure on Trustee's Deed)
TT	Trust
TX	TAX PAYER
TY	Tenants in Entirety
UI	Undivided Interest
UM	Unmarried Man
UN	Unmarried
US	United States
UW	Unmarried Woman
WA	Who Acquired Title As
WD	Widow or Widower
WF	Wife
WH	His Wife
WI	Wife
WR	Widower
WW	Wife and Wife
XX	Wholly Exempt

OWNER_VEST129 codes

CODE	DESCRIPTION
99	Heirs
AB	Alternate Beneficiary
AC	Guardian/Custodian
AD	Administrator
AE	Assignee (Buyer/Borrower only)
AF	Name derived from Affidavit
AG	Agent or Guardian
AK	Also known as (A/K/A)
AL	All as/Undefined
AO	Alter Ego
AR	Assignor (Seller only)
AS	Association
BE	Beneficiary / Creditor - Doc Type BD, buyer ID identifies designated to acquire title upon death of Grantor.
BS	Brother & Sister
BU	Builder/Developer
CA	Corporate Trustee
CE	Corporate Trustee
CF	Contract Purchasor
CN	Corporation
CO	Company
CP	Community Property (Marital Community)
CR	Community Property (Marital Community) with rights of survivorship
CT	Corporate Trust
DB	Doing business as (DBA)
DC	Deceased
DE	DECEASED
DF	Defendant
DP	Domestic Partner
DR	Divorced not Remarried
DS	Disabled
DV	Divorced
DW	Dower Clause
EA	Et al (and others) - vendor data only
ES	Estate
EU	Et ux (and wife) - vendor data only
EX	Executor / Administrator
FK	Formerly known as (F/K/A)
FL	Family Living Trust
FM	Family Trust
FR	Family Revocable Trust
FT	Family Trust
GD	Guardian
GN	General Partnership
GP	General Partner
GV	Government
HE	Heirs
HH	Her Husband
HU	Husband and Husband
HW	Husband and Wife
IA	IRA (Individual Retirement Account)
ID	Individual(s)
IL	Irrevocable Living Trust
IN	incompetent
IR	Irrevocable Trust
IT	Irrevocable Trust
JS	Joint tenants with right of survivorship
JT	Joint Tenants
JV	Joint Venture
L2	Seller is owner on current Assessment File
LB	Life Benefit Estate
LC	Limited Liability Company
LE	Life Estate (phased out Spring, 2009, now Buyer/Borrow ID Code = "LT".)
LF	Lease From
LL	Limited Liability Partnership
LP	Limited Partnership
LS	Limited Partnership
LT	Life Tenant
LV	Living Trust
LW	Last Will and Testament
MA	Married
MC	Married Couple
ME	Member
MI	Minor, Ward or Client (Represented by Trustee)
MM	Married Man as his sole and separate property
MN	Managing Member
MP	Married Person
MW	Married Woman as her sole and separate property
NK	Now Known as
NM	Never Married Person
NP	Not Provided (name blurred or missing from document)
NT	Non Declared Trust
NV	Non-Vested Spouse
PA	Partnership
PF	Plaintiff
PR	Personal Representative
PS	Partnership
PT	Personal Trust
RC	Receiver
RL	Revocable Living Trust
RM	Remainderman
RS	Right of Survivorship
RT	Revocable Trust
SE	Separate Property
SG	Single
SI	Successor in Interest
SJ	Surviving Joint Tenant
SL	Sole Proprietorship
SM	Single man
SO	Sole and Separate
SP	Survivorship Martial Property (Wisconsin/Alaska with marital property system effective 01/01/1986. )
SS	Surviving Spouse
ST	Successor Trustee (LA County only)
SU	Survivor
SV	Tenants in Severalty
SW	Single woman
SX	Separated
SY	Survivorship Martial Property -- This code will be used primarily in Wisconsin/Alaska who adopted a marital property system effective 01/01/1986.
TC	Tenants in Common
TD	Transfer of Death
TE	Tenants by Entireties
TN	Tenant
TR	Trust
TS	Trustor/Debtor (Borrower in Default/Foreclosure on Trustee's Deed)
TT	Trust
TX	TAX PAYER
TY	Tenants in Entirety
UI	Undivided Interest
UM	Unmarried Man
UN	Unmarried
US	United States
UW	Unmarried Woman
WA	Who Acquired Title As
WD	Widow or Widower
WF	Wife
WH	His Wife
WI	Wife
WR	Widower
WW	Wife and Wife
XX	Wholly Exempt

PARTIAL_INT_IND9 codes

CODE	DESCRIPTION
1	Ground Lease
2	Multi parcels, one 100 OWNERSHIP interest- others different interest (%) less than 100%.
3	Multi parcels with differing ownership interest (%), each being LESS that 100% interest.
4	Unsure whether transfer is a Partial Interest
5	Actual percentage is unclear.
6	1-25% interest
7	26-50% interest
8	51-75% interest
9	76-99% interest

SALE_PRICE28 codes

CODE	DESCRIPTION
1	Qualifies as a comparable sale as defined by the county.
2	Liens Exceed Value or Assumption of Loan. Liens/Loans involved in the transaction exceed market value.
3	Sales Price computed from the Transfer Tax, Transfer Tax not keyed.
4	Sales Price amount or Transfer Tax unreadable.
5	Unable to calculate Sales Price from given Transfer Tax.
6	Non-arms length transaction.
7	Sales Price or Transfer Tax rounded by county prior to computation.
8	Sold for Taxes.
10	Transfer Tax on document indicated as EXEMPT.
11	Document states price as "0", "None", "No Consideration".
12	Sales Price computed using current Excise Tax Rate based on city name (WA).
13	Full amount computed from Transfer Tax or Excise Tax.
14	Full amount stated on Document.
15	Partial amount computed from Transfer Tax.
16	Sales price computed from Transfer Tax.
17	Comparable Market Value.
18	Exchange (HI).
19	Full amount from assessment file, when available.
20	Document states that Price/Transfer Tax is not a matter of public record.
21	From recorded Affidavit of Value or Verified.
23	Unable to compute.
28	Amount of redemption. Only used for Redemption Deeds. (DocType = “RD”).
29	Sales Price computed from transfer tax based on either full consideration or assessed value (NE and Kenosha WI only).
30	Judgment Amount.
40	Sales Price from Excise Tax Rate (WA only ).
41	Price/Transfer Tax not public record.
43	Estimated Sales Price.
44	Assessor Qualified Sale (Not used for comps).

TRAN_TYPE11 codes

CODE	TransactionID Begins With	DESCRIPTION
1	1 or 6	Non-Arms length transactions with valid TITLE COMPANY NAME (no accomodations)
2	1 or 6	Arms-length Residential transactions (Purchase/Resales)
3	1 or 6	New Construction Residential transactions
4	1 or 6	REO and Trustee Deeds
5	1 or 6	Insured NON-Residential Grant Deeds
1	2 or 7	HELOCS - both Purchase Money and Non-Purchase
2	2 or 7	REFI LOANS and 2ND TRUST DEEDS - both Purchase Money and Non-Purchase
3	2 or 7	RESALE PURCHASE MONEY LOANS - subset of TRANSACTION TYPE 2
4	2 or 7	CONSTRUCTION LOANS - both Purchase Money and Non-Purchase (LOAN TYPE "B")
5	2 or 7	NEW RESIDENTIAL PURCHASE MONEY LOANS - subset of TRANSACTION TYPE 3
6	2 or 7	NON-RESIDENTIAL Mortgages - both Purchase Money and Non-Purchase