What file layout and keys would a schedule dataset use?
Integration detail on how a generated schedule dataset could be laid out as JSONL or Parquet tables with stable keys, version links and task files that point at starting state.
A schedule dataset works best as a set of related tables with stable keys, delivered as JSONL for readability or Parquet for volume. Agree the exact schema in scoping; the layout below is a typical starting point.
**Tables**
- `accounts`: `account_id`, `product_code`, `start_date`, `frequency`, `status` - `schedules`: `schedule_id`, `account_id`, `version`, `status`, `supersedes_id`, `change_reason`, `created_at` - `instalments`: `instalment_id`, `schedule_id`, `due_date`, `amount`, `state`, `settled_by_payment_id` - `payments`: `payment_id`, `account_id`, `received_at`, `amount`, `type` - `instructions`: `instruction_id`, `account_id`, `schedule_id`, `next_date`, `amount` - `cases`: `case_id`, `account_id`, `request_type`, `approver_role`, `outcome` - `policies`: `policy_id`, `product_code`, `rule_key`, `value`, `text`
**Task files**
- `tasks.jsonl`: `task_id`, `prompt`, `start_snapshot`, `allowed_tools`, `expected_outcome`, `checks`
**Conventions**
- Dates in ISO 8601 with an explicit timezone. - Money as integer minor units with a currency code. - Every foreign key resolves inside the release, and a validation script can confirm that. - Snapshots are named, so `start_snapshot` can be restored by the environment reset.
Ask for the validation script early. Broken keys are the most common reason a loaded dataset behaves differently from its description.
Stable keys and explicit version links let you load the dataset into your own store or replay it inside an environment.
- Audience:
- Agent developers
- Content type:
- Integration
- Buyer question:
- What can be generated
Content release: r-a220eb6e099b243b
Related questions
- Can a release include policies, exceptions and refusals, not just records?
- Which record types should I request in a generated schedule pack?
- What would a simulated utility payment-plan environment hold?
- What can a generated schedule dataset or environment contain?
- Which entities should I ask for in a schedule dataset or environment?
- How could schedule records be laid out in JSONL and Parquet files?