How does a schedule workflow appear as linked tables in a reseller's catalogue?
Describes four linked tables, their key fields, foreign keys, delivery formats and a manifest, so a reseller can describe, sample and validate each part of a schedule release.
A schedule workflow usually lands as four linked tables, which suits catalogue listings because each can be described, sampled and priced separately by you.
- `schedules`: `schedule_id`, `account_id`, `product_type`, `start_date`, `frequency`, `status`, `policy_id` - `instalments`: `instalment_id`, `schedule_id`, `due_date`, `amount_due`, `principal`, `interest`, `status` - `amendments`: `amendment_id`, `schedule_id`, `request_type`, `requested_by_role`, `approved_by_role`, `decision`, `effective_date` - `policies`: `policy_id`, `rule_text`, `threshold_value`, `approval_role`, `valid_from`
Foreign keys run from instalments and amendments back to schedules, and from schedules to policies. Keep the identifiers stable across files so that your customers can join them without guessing.
Delivery formats are typically JSONL for event-style records and Parquet for larger tables. A manifest file can list each file, its schema version and row count, so you can validate a drop before it reaches your marketplace.
For evaluation use, an additional `expected_outcomes` file could hold the correct post-amendment schedule for each task, keyed by `amendment_id`.
Ask for a schema document in a sample so your catalogue entries and your customers' loaders match what is delivered. All of it is generated material; keep that statement in the metadata you pass onward.
Four stable, linked tables let you list, sample and validate each layer separately and give customers joins that work first time.
- Audience:
- Licensed resellers
- Content type:
- Integration
- Buyer question:
- What it is and why it matters
Content release: r-a220eb6e099b243b
Related questions
- What does an early lump-sum payment do to a loan schedule?
- What makes a schedule task worth using to test an agent?
- Which systems does an agent touch when changing a schedule?
- Why can't a general agent just recalculate dates and amounts?
- What is payment schedule work and why does it matter for agents?
- How does a payment plan map onto environment state and tool actions?