Skip to main content
PropertyValue
Dataset codeD18
Section codeS3 — Collections Cases
Endpoint path/exports/S3/D18
Cursor fieldcreated_at
Page size1–1000 (default 500)
AvailabilityAvailable (v1.2)
PaginationVia (variable page size — joined through a parent)
Each row is a snapshot of a borrower deal state change — stage, pipeline, communications pipeline, and PTP / broken-PTP markers at the time of the log.

​
Fields

FieldTypeDescriptionNotes
public_idstringStable per-row identifier (string-cast Mongo _id).Use as the warehouse primary key
log_actionstringLog action code.
deal_stage_idstringStage at log time.
pipelinestringPipeline at log time.
comms_pipelinestringCommunications pipeline at log time.
ptp_date_humanstring | nullPTP date set by a human agent (ISO-8601).
ptp_date_aistring | nullPTP date set by an AI call (ISO-8601).
broken_ptp_date_humanstring | nullWhen the human-set PTP was broken (ISO-8601).
broken_ptp_date_aistring | nullWhen the AI-set PTP was broken (ISO-8601).
do_not_contactbooleanDo-not-contact flag at log time.
created_atstringLog timestamp (ISO-8601).Cursor field

​
Sample row

{
  "public_id": "664b1d3e4f5a6b7081920288",
  "log_action": "stage_transition",
  "deal_stage_id": "stage_negotiation",
  "pipeline": "Early Collections",
  "comms_pipeline": "Standard Outreach",
  "ptp_date_human": "2026-06-05T00:00:00.000Z",
  "ptp_date_ai": null,
  "broken_ptp_date_human": null,
  "broken_ptp_date_ai": null,
  "do_not_contact": false,
  "created_at": "2026-05-22T11:14:06.000Z"
}

​
Pagination characteristics

This dataset is via — it is filtered to your tenant by joining through its parent (borrower_deal_id → BorrowerDeals). On multi-tenant databases a single response may contain fewer rows than your limit even when more data exists. The cursor still advances correctly — keep paging until nextCursor is null. See Pagination → Variable page size.

​
Use cases

  • Deal-state historical reconstruction.
  • SCD-style (slowly-changing-dimension) change capture for the case dimension table.
  • Pipeline transition timing.

Need Help?

Our support team is available Monday-Friday, 9 AM - 6 PM GST. Reach out at support@cleargrid.co or visit our help center.