app.access_review_campaigns
TableRow level security on
Access review campaigns (Section 8.4): reviewers confirm or remove each member's role. One Active campaign per org; it completes when every item is decided, and deleting an Active campaign cancels it.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org. A row never moves to another org.References app.organizations.id |
| name | text | No | Campaign name, for example Q4 Access Review. |
| due_on | date | No | Date reviewers are asked to finish by. |
| auto_remove_unreviewed | boolean | No | When true, roles still unreviewed after access_reviews.grace_days are removed automatically. Starts from the org setting access_reviews.remove_unreviewed. |
| campaign_state | text | No | Active, Complete (every item decided) or Canceled (deleted while Active). Set by the database. |
| opened_at | timestamp with time zone | No | When the campaign opened and its items were taken; the grace period counts from here. |
| closed_at | timestamp with time zone | Yes | When the campaign completed or was canceled; NULL while Active. |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |