Overview › Resources › First American › Assessor Open Lien

Assessor Open Lien — data dictionary

Open mortgage / lien position derived from assessor + recorder. · 84 fields · source FA Assessor Open Lien Data Dictionary Layout v24 20250714 (v24 · 2025-07-14).

Tier B/C leverage — open-lien count and balances feed LTV.

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	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).
OldApnIndicator	varchar(1)	No Display		Type of APN in the OldAPN field (O = OldAPN, A = AlternateAPN,P = Parent, S = SubDiv/Split).
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)	Public Display		Street Address: 123 S MAIN ST # 4
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.
SitusLatitude	float(12)	Restricted Display		FA standard latitude of the property.
SitusLongitude	float(12)	Restricted Display		FA standard longitude of the property.
SitusGeoStatusCode	varchar(1)	Restricted Display	GEO_STATUS	Code describing the accuracy of the lat/long.
OPEN LIEN INFORMATION (UP TO 4)
TotalOpenLienNbr	int(1)	Restricted Display		Total number of open liens on the property.
TotalOpenLienAmt	int(11)	Restricted Display		Total amount of open liens on the property.
Mtg1TransactionId	bigint(11)	No Display		First American unique number assigned to the mortgage.
Mtg1RecordingDate	varchar(8)	Restricted Display		Date on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
Mtg1LoanAmt	int(11)	Restricted Display		The amount of the mortgage on the recorded document.
Mtg1Lender	varchar(30)	Restricted Display		The name of the lender issuing the mortgage.
Mtg1PrivateLender	varchar(1)	Restricted Display		First American flag indicating the loan is issued by a private party.
Mtg1Term	numeric(3)	Restricted Display		Mortgage term in months.
Mtg1LoanDueDate	varchar(8)	Restricted Display		Maturity date or the final due date of the loan.
Mtg1AdjRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Adjustable Rate Rider.
Mtg1LoanType	varchar(10)	Restricted Display	LOAN_TYPE	Document type used to issue the mortgage.
Mtg1TypeFinancing	varchar(10)	Restricted Display	FIN_TYPE	Mortgage financing type.
Mtg1LienPosition	int(1)	Restricted Display		Position of the lien.
Mtg2TransactionId	bigint(11)	No Display		First American unique number assigned to the mortgage.
Mtg2RecordingDate	varchar(8)	Restricted Display		Date on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
Mtg2LoanAmt	int(11)	Restricted Display		The amount of the mortgage on the recorded document.
Mtg2Lender	varchar(30)	Restricted Display		The name of the lender issuing the mortgage.
Mtg2PrivateLender	varchar(1)	Restricted Display		First American flag indicating the loan is issued by a private party.
Mtg2Term	numeric(3)	Restricted Display		Mortgage term in months.
Mtg2LoanDueDate	varchar(8)	Restricted Display		Maturity date or the final due date of the loan.
Mtg2AdjRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Adjustable Rate Rider.
Mtg2LoanType	varchar(10)	Restricted Display	LOAN_TYPE	Document type used to issue the mortgage.
Mtg2TypeFinancing	varchar(10)	Restricted Display	FIN_TYPE	Mortgage financing type.
Mtg2LienPosition	int(1)	Restricted Display		Position of the lien.
Mtg3TransactionId	bigint(11)	No Display		First American unique number assigned to the mortgage.
Mtg3RecordingDate	varchar(8)	Restricted Display		Date on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
Mtg3LoanAmt	int(11)	Restricted Display		The amount of the mortgage on the recorded document.
Mtg3Lender	varchar(30)	Restricted Display		The name of the lender issuing the mortgage.
Mtg3PrivateLender	varchar(1)	Restricted Display		First American flag indicating the loan is issued by a private party.
Mtg3Term	numeric(3)	Restricted Display		Mortgage term in months.
Mtg3LoanDueDate	varchar(8)	Restricted Display		Maturity date or the final due date of the loan.
Mtg3AdjRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Adjustable Rate Rider.
Mtg3LoanType	varchar(10)	Restricted Display	LOAN_TYPE	Document type used to issue the mortgage.
Mtg3TypeFinancing	varchar(10)	Restricted Display	FIN_TYPE	Mortgage financing type.
Mtg3LienPosition	int(1)	Restricted Display		Position of the lien.
Mtg4TransactionId	bigint(11)	No Display		First American unique number assigned to the mortgage.
Mtg4RecordingDate	varchar(8)	Restricted Display		Date on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
Mtg4LoanAmt	int(11)	Restricted Display		The amount of the mortgage on the recorded document.
Mtg4Lender	varchar(30)	Restricted Display		The name of the lender issuing the mortgage.
Mtg4PrivateLender	varchar(1)	Restricted Display		First American flag indicating the loan is issued by a private party.
Mtg4Term	numeric(3)	Restricted Display		Mortgage term in months.
Mtg4LoanDueDate	varchar(8)	Restricted Display		Maturity date or the final due date of the loan.
Mtg4AdjRider	varchar(1)	Restricted Display		Flag Indicating the Mortgage has a Adjustable Rate Rider.
Mtg4LoanType	varchar(10)	Restricted Display	LOAN_TYPE	Document type used to issue the mortgage.
Mtg4TypeFinancing	varchar(10)	Restricted Display	FIN_TYPE	Mortgage financing type.
Mtg4LienPosition	int(1)	Restricted Display		Position of the lien.
ADDITIONAL FA PROCESSING INFORMATION
FATimeStamp	varchar(8)	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.
ESTIMATED FIELDS (Premium Addon---Not Part of Standard Super File)
Mtg1EstPaymentAmount	varchar(15)	Restricted Display		Estimated Payment Amount for the lien in first position based upon lien amount only, no escrow or pre-payment are factored into the calculation
Mtg2EstPaymentAmount	varchar(15)	Restricted Display		Estimated Payment Amount for the lien in second position based upon lien amount only, no escrow or pre-payment are factored into the calculation
Mtg3EstPaymentAmount	varchar(15)	Restricted Display		Estimated Payment Amount for the lien in third position based upon lien amount only, no escrow or pre-payment are factored into the calculation
Mtg4EstPaymentAmount	varchar(15)	Restricted Display		Estimated Payment Amount for the lien in fourth position based upon lien amount only, no escrow or pre-payment are factored into the calculation
Mtg1EstLoanBalance	int(11)	Restricted Display		Estimated remaining balance for the lien in first position based upon lien amount only, no escrow or pre-payment are factored into the calculation. Amount is calculated by using either the actual interest rate or the estimated interest rate and the loan term.
Mtg2EstLoanBalance	int(11)	Restricted Display		Estimated remaining balance for the lien in second position based upon lien amount only, no escrow or pre-payment are factored into the calculation. Amount is calculated by using either the actual interest rate or the estimated interest rate and the loan term.
Mtg3EstLoanBalance	int(11)	Restricted Display		Estimated remaining balance for the lien in third position based upon lien amount only, no escrow or pre-payment are factored into the calculation. Amount is calculated by using either the actual interest rate or the estimated interest rate and the loan term.
Mtg4EstLoanBalance	int(11)	Restricted Display		Estimated remaining balance for the lien in fourth position based upon lien amount only, no escrow or pre-payment are factored into the calculation. Amount is calculated by using either the actual interest rate or the estimated interest rate and the loan term.
Mtg1EstInterestRate	varchar(6)	Restricted Display		Interest Rate for the Lien in first position (Estimated when not available).
Mtg2EstInterestRate	varchar(6)	Restricted Display		Interest Rate for the Lien in second position (Estimated when not available).
Mtg3EstInterestRate	varchar(6)	Restricted Display		Interest Rate for the Lien in third position (Estimated when not available).
Mtg4EstInterestRate	varchar(6)	Restricted Display		Interest Rate for the Lien in fourth position (Estimated when not available).

Code tables · 4 tables, 96 codes

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

FIN_TYPE8 codes

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

GEO_STATUS10 codes

CODE	DESCRIPTION
5	Record was coded to the 5-digit ZIP code centroid (U.S.) or the first 3-digit Postal Code Level (Canada)
7	Record was coded to the ZIP + 2 centroid
9	Record was coded to the ZIP + 4 centroid (U.S.) or the full 6-digit Postal Code Level (Canada)
A	Record was coded to interpolated rooftop level
B	Record was coded to the rooftop level
D	This object is in "Demonstration" mode and it detected the input of a Zip Code outside the allowable range.
E	Expire
P	Parcel Centroid
R	FA Roof Top
X	Record was not coded

LOAN_TYPE34 codes

CODE	DESCRIPTION
1	Stand Alone First
2	Stand Alone Second
3	ARM (Adjustable Rate Mortgage as of August, 2009)
4	Amount keyed is an Aggregate amount
5	USDA
6	Closed-end Mortgage
7	Assumption
8	Building or Construction Loan
9	Cash (code phased out August 17, 2020)
10	2nd Mortgage made to cover Down Payment
11	Credit Line (Revolving)
12	FHA
13	Fannie Mae/Freddie Mac (Phased out because 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

SALE_PRICE44 codes

CODE	DESCRIPTION
1	Qualifies as a comparable sale as defined by the county.
2	Liens Exceed Value or Assumption of Loan 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.
9	Unable to calculate Sales Price from given Transfer Tax.
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 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.
22	Full amount from assessment file, when available.
23	Unable to compute
24	Comparable Market Value.
25	Full amount stated on Document.
26	Exchange (HI)
27	Full amount computed from Transfer Tax or Excise Tax.
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
31	Liens Exceed Value or Assumption of Loan. Liens/Loans involved in the transaction exceed market value.
32	Sales Price computed from Transfer Tax, Transfer Tax not keyed.
33	Non-arms length transaction.
34	Partial amount computed from Transfer Tax.
35	Sales Price or Transfer Tax rounded by county prior to computation.
36	Sold for Taxes.
37	Transfer Tax on document indicated as EXEMPT.
38	Sales price computed from Transfer Tax.
39	From recorded Affidavit of Value or Verified.
40	Sales Price from Excise Tax Rate (WA only )
41	Price/Transfer Tax not public record.
42	Document states price as "0", "None", "No Consideration".
43	Estimated Sales Price
44	Assessor Qualified Sale (Not used for comps)