app.onboarding_item_status
View
Onboarding progress per item, derived: the latest verification, whether the item passes or carries over from the same party's earlier engagement with the org, and whether an expiry reminder is due. Rows follow the onboarding item read rule; reviewer notes are not projected.
| Column | Type | Nullable | Description |
|---|---|---|---|
| onboarding_item_id | uuid | Yes | Item. |
| org_id | uuid | Yes | Org. |
| engagement_id | uuid | Yes | Engagement. |
| onboarding_requirement_id | uuid | Yes | Requirement. |
| name | text | Yes | Requirement name. |
| item_kind | app.onboarding_item_kind | Yes | Kind of item. |
| is_blocking | boolean | Yes | True when the item blocks Active. |
| verification_method | app.verification_method | Yes | Automatic or Reviewer. |
| submitted_at | timestamp with time zone | Yes | When the party submitted it. |
| latest_outcome | app.verification_outcome | Yes | Outcome of the latest verification; NULL before any. |
| expires_on | date | Yes | Expiry of the latest verification. |
| passes | boolean | Yes | True when the latest verification passed and has not expired. |
| carried_over | boolean | Yes | True when the item does not pass itself but a verified item for the same requirement carries over. |
| reminder_due | boolean | Yes | True when the expiry reminder window has opened. |