app.sponsor_proof_of_performance
View
Proof of performance per sponsor entitlement (gate 8): what is owed against what was delivered, NULL-aware. A countable entitlement is met when the counted deliveries reach the quantity owed; an uncountable one when it is marked fulfilled.
| Column | Type | Nullable | Description |
|---|---|---|---|
| sponsor_entitlement_id | uuid | Yes | Entitlement. |
| project_id | uuid | Yes | Project. |
| counterparty_id | uuid | Yes | Sponsor. |
| description | text | Yes | The entitlement. |
| quantity_owed | numeric | Yes | How many are owed; NULL when not countable. |
| due_on | date | Yes | When owed. |
| fulfilled_at | timestamp with time zone | Yes | When it was marked delivered. |
| delivery_count | bigint | Yes | Deliveries recorded. |
| quantity_delivered | numeric | Yes | Sum delivered; NULL when there are no deliveries or any delivery was not counted. |
| last_delivered_on | date | Yes | Most recent delivery. |
| is_met | boolean | Yes | True when the entitlement is delivered in full. |