Mortgage Property Aggregate Mortgage Property Aggregate Delete History

Mortgage Property Aggregate

Field Name Description Data Type
Property identification
CID Unique property identifier / composite ID.

Example:
'060004759687'
 string
CountyFipsCode Federal Information Processing Standard code for the county.

Example:
'06107'
 string
ParcelNumber Assessor's parcel number for the property.

Example:
'219-190-001-000'
 string
PropertyType General classification of the property (e.g., Residential, Commercial).

Example:
'Residential'
 string
PropertySubType More granular property classification.

Example:
'Single Family Residence'
 string
Property address
UnparsedAddress Full street address in a single string.

Example:
'38641 BALCH PARK RD'
 string
UnitType Type of unit (e.g., Apt, Suite, Unit).

Example:
NULL
 string
UnitNumber Unit or apartment number.

Example:
NULL
 string
City City where the property is located.

Example:
'SPRINGVILLE'
 string
StateOrProvince Two-letter state or province abbreviation.

Example:
'CA'
 string
PostalCode Five-digit ZIP / postal code.

Example:
'93265'
 string
PostalCodePlus4 Four-digit ZIP+4 extension.

Example:
'9763'
 string
StreetNumber Numeric portion of the street address.

Example:
'38641'
 string
StreetDirPrefix Directional prefix of the street (e.g., N, S, E, W).

Example:
NULL
 string
StreetName Name of the street.

Example:
'BALCH PARK'
 string
StreetSuffix Street suffix type (e.g., Road, Ave, Blvd).

Example:
'Road'
 string
StreetDirSuffix Directional suffix of the street.

Example:
NULL
 string
CarrierRoute USPS carrier route code.

Example:
'H002'
 string
CountyOrParish Name of the county or parish.

Example:
'Tulare'
 string
Geographic coordinates
Latitude Geographic latitude of the property.

Example:
36.17432000
 number
Longitude Geographic longitude of the property.

Example:
-118.79834900
 number
LatLongPrecision Precision level of the geocoded coordinates.

Example:
'Street'
 string
CensusTract Census tract identifier for the property location.

Example:
'061070027.011033'
 string
Property characteristics
NumberOfUnitsTotal Total number of units in the property.

Example:
0
 number
OccupantType Indicates who occupies the property (Owner, Tenant, Vacant).

Example:
'Owner'
 string
YearBuilt Year the structure was originally built.

Example:
1978
 number
Tax & valuation
TaxAssessedYear Year of the most recent tax assessment.

Example:
2025
 number
TaxAssessedValue Assessed value for tax purposes (in USD).

Example:
255839
 number
MarketValueYear Year of the most recent market valuation.

Example:
NULL
 number
MarketValue Estimated market value of the property (in USD).

Example:
0
 number
Sale information
SalesPrice Recorded sale price of the property (in USD).

Example:
NULL
 number
SalesPriceCode Qualifier for the sales price (e.g., exact, estimated, county rounded).

Example:
'County Rounded'
 string
TitleCompanyName Name of the title company that handled the transaction.

Example:
'FIRST AMERICAN TITLE COMPANY'
 string
SaleRecordingDate Date the sale was officially recorded.

Example:
NULL
 date
IntraFamilyYn Indicates if the transaction was between family members.

Example:
FALSE
 boolean
CashPurchaseYn Indicates if the property was purchased with cash (no mortgage).

Example:
FALSE
 boolean
DistressedSaleYn Indicates if the sale was a distressed sale (foreclosure, short sale).

Example:
FALSE
 boolean
Buyer information
BuyerFnameMname1 First/middle name of the primary buyer.

Example:
NULL
 string
BuyerLnameOrCorpName1 Last name or corporate name of the primary buyer.

Example:
NULL
 string
BuyerType1 Entity type of the primary buyer (Individual, Corporation, Trust, etc.).

Example:
NULL
 string
BuyerFnameMname2 First/middle name of the secondary buyer.

Example:
NULL
 string
BuyerLnameOrCorpName2 Last name or corporate name of the secondary buyer.

Example:
NULL
 string
Seller information
SellerFnameMname1 First/middle name of the primary seller.

Example:
NULL
 string
SellerLnameOrCorpName1 Last name or corporate name of the primary seller.

Example:
NULL
 string
SellerType1 Entity type of the primary seller.

Example:
NULL
 string
SellerFnameMname2 First/middle name of the secondary seller.

Example:
NULL
 string
SellerLnameOrCorpName2 Last name or corporate name of the secondary seller.

Example:
NULL
 string
SellerType2 Entity type of the secondary seller.

Example:
NULL
 string
Mortgage flags
ResidentialYn Indicates if the mortgage is for a residential property.

Example:
TRUE
 boolean
ConstructionLoanYn Indicates if the mortgage is a construction loan.

Example:
FALSE
 boolean
StandaloneYn Indicates if this is a standalone mortgage (not linked to a sale).

Example:
FALSE
 boolean
EquityCreditLineYn Indicates if the mortgage is a home equity line of credit (HELOC).

Example:
FALSE
 boolean
PurchaseMoneyMortgageYn Indicates if the mortgage was used to purchase the property.

Example:
FALSE
 boolean
Mortgage details
MortgageDocumentNumber Recording document number for the mortgage.

Example:
'2011-0049532'
 string
MortgageRecordingDate Date the mortgage was officially recorded.

Example:
'2011-08-25'
 date
LoanAmount Original loan amount (in USD).

Example:
182000
 number
LoanTermMonths Duration of the loan in months.

Example:
'360'
 string
DueDate Maturity / due date of the loan.

Example:
'2041-09-01'
 date
LoanType Type of loan (e.g., Conventional, FHA, VA).

Example:
'Conventional'
 string
TypeFinancing Financing type description.

Example:
NULL
 string
InterestRate Interest rate on the mortgage (percentage).

Example:
4.5
 number
PrepaymentRider Indicates if a prepayment rider exists on the loan.

Example:
NULL
 string
PrepaymentTermPenaltyRider Term or penalty details for prepayment.

Example:
NULL
 string
OriginalDateOfContract Date the original mortgage contract was signed.

Example:
'2011-08-13'
 date
Borrower information
BorrowerFnameMname1 First/middle name of the primary borrower.

Example:
'MARGARET E'
 string
BorrowerLnameOrCorpName1 Last name or corporate name of the primary borrower.

Example:
'WILSON'
 string
BorrowerFnameMname2 First/middle name of the secondary borrower.

Example:
NULL
 string
BorrowerLnameOrCorpName2 Last name or corporate name of the secondary borrower.

Example:
'MARGARET E WILSON LIVING TRUST'
 string
BorrowerVestingCode Vesting code describing how the borrower holds title.

Example:
'Living Trust'
 string
Lender information
LenderNameBeneficiary Name of the lender or beneficiary.

Example:
'JPMORGAN CHASE BANK NA'
 string
LenderDbaName Lender's "doing business as" name.

Example:
NULL
 string
LenderType Type of lending institution (Bank, Credit Union, etc.).

Example:
'Bank'
 string
LenderMailPostalCode Postal code of the lender's mailing address.

Example:
'43240'
 string
LoanOfficerNmlsId NMLS ID of the loan officer.

Example:
NULL
 string
MortgageBrokerNmlsId NMLS ID of the mortgage broker.

Example:
NULL
 string
LoanCompanyNmlsId NMLS ID of the loan company.

Example:
NULL
 string
Loan purpose & metadata
LoanPurpose Purpose of the loan (e.g., Purchase, Refinance).

Example:
NULL
 string
MortgageTransactionId Unique identifier for the mortgage transaction.

Example:
'229475706'
 string
Orphan Indicates if this mortgage record has no matching sale/property record.

Example:
FALSE
 boolean
ModificationTimestamp Timestamp of the last modification to this record.

Example:
'2026-03-19 17:55:21.226'
 date-time

Mortgage Property Aggregate Delete History

Delete history is an audit trail of rows that were removed from the live Mortgage Property Aggregate dataset. It is useful when you need to explain why a mortgage or property row no longer appears in the current aggregate, reconcile downstream systems after cleanup jobs, or investigate orphan records that were later matched and resolved.

How to use it

  • Access: Query the delete-history entity exposed for this product in OData $metadata (entity set name may appear as MortgagePropertyAggregateDeleteHistory or similar). Use the same host and Authorization: Bearer pattern as other Insights entities.
  • Look up by property: Filter on CID, ParcelNumber, CountyFipsCode
  • Look up by transaction: Filter on MortgageTransactionID when you still have the old transaction id (including values prefixed with ORPHAN_).
  • Time windows: Filter on DeletedAt
  • Reason codes: Use DeleteReason to narrow results—for example ORPHAN_RESOLVED when an orphan was linked to a real aggregate row NewMortgageTransactionID NMLS_DELETED or MORTGAGE_DELETED when upstream source data was dropped or superseded.

Example Request: 

GET https://insights.cdatalabs.com/odata/MortgagePropertyAggregateDeleteHistory?$filter=CID eq '060004759687'&$orderby=DeletedAt desc&$top=50
Field Name Description Data Type
DeleteReason Why the row was removed.

Example: 
ORPHAN_RESOLVED, NMLS_DELETED, MORTGAGE_DELETED
 string
DeletedAt Timestamp when the row was archived by cleanup macro.

Example: 
2026-04-03 15:05:26
 date-time
CID CID. Null for orphan rows (no matched CID).

Example: 
470003122185
 string
MortgageTransactionID Transaction ID of the deleted row. Orphans carry an ORPHAN_ prefix.

Example: 
ORPHAN_673a54eddbb5ed30...
 string
NewMortgageTransactionID ORPHAN_RESOLVED only: links to the resolved record in the live aggregate. Null otherwise.

Example: 
502085186
 string
ParcelNumber Assessor Parcel Number (APN). Null for orphans when missing APN is why they were orphaned.

Example: 
113 06200
 string
CountyFipsCode 5-digit county FIPS code.

Example: 
47013
 string
CountyOrParish County name.

Example: 
Campbell
 string
UnparsedAddress Full property street address as received from source.

Example: 
131 E DOGWOOD TRL
 string
City Property city.

Example: 
LA FOLLETTE
 string
State 2-letter state code.

Example: 
TN
 string
MortgageRecordingDate Date the mortgage was recorded with the county recorder.

Example: 
2024-10-31 00:00:00
 date-time
MortgageDocumentNumber Recorder document number assigned by the county at recording.

Example: 
24005257
 string
OriginalDateOfContract Date the mortgage contract was originally signed, prior to recording.

Example: 
2024-10-29 00:00:00
 date-time
Full Detail information Confidential. Not for Distribution.