# Delete History data dictionary

> Provides delete-history records that identify when assessor, deed, mortgage, assignment, release, pre-foreclosure, base properties, mortgage property aggregate, sales and transfer, and loan records were removed from the live datasets.

Source: https://docs.cdatalabs.com/insights/delete-history.html  
Last updated: 2026-10-21

Assessor
Deed
Mortgage
Assignment
Release
Pre-Foreclosure
Base Properties
Mortgage Property Aggregate
Sales & Transfer
Loan

### Assessor Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/AssessorDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| RecordId | Record Id. | string |

### Deed Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/DeedDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |

### Mortgage Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/MortgageDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |

### Assignment Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/AssignmentDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| TransactionId | Transaction Id. | string |
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |

### Release Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/ReleaseDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |

### PreForeclosure Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/PreForeclosureDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |

### Base Properties Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/BasePropertiesDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| CID | CID. | string |
| DeletedDate | Deleted Date. | date-time |

### Mortgage Property Aggregate Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/MortgagePropertyAggregateDeleteHistory>

Audit records for rows removed from the live Mortgage Property Aggregate dataset.

| Field Name | Description | Data Type |
| --- | --- | --- |
| DeleteReason | Reason the row was removed. | string |
| DeletedAt | Timestamp when the row was archived. | date-time |
| CID | Constellation identifier; null for unmatched orphan rows. | string |
| MortgageTransactionID | Transaction identifier of the deleted row. | string |
| NewMortgageTransactionID | Resolved transaction identifier when an orphan was matched. | string |
| ParcelNumber | Assessor parcel number. | string |
| CountyFipsCode | Five-digit county FIPS code. | string |
| CountyOrParish | County or parish name. | string |
| UnparsedAddress | Full property street address received from the source. | string |
| City | Property city. | string |
| State | Two-letter state code. | string |
| MortgageRecordingDate | Date the mortgage was recorded. | date-time |
| MortgageDocumentNumber | Document number assigned at recording. | string |
| OriginalDateOfContract | Date the mortgage contract was originally signed. | date-time |

### Sales And Transfer Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/SalesAndTransferDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| Cdltransactionid | Cdltransactionid. | string |
| DeletedDate | Deleted Date. | date-time |

### Loan Delete History

OData endpoint: <https://insights.cdatalabs.com/odata/LoanDeleteHistory>

| Field Name | Description | Data Type |
| --- | --- | --- |
| LoanId | Loan Id. | string |
| DeletedDate | Deleted Date. | date-time |

*Full Detail information
Confidential. Not for Distribution.*
