app.background_checks
TableRow level security on
Background checks run through the provider (Checkr), which handles FCRA disclosure, authorization and adverse action (Section 4.4.4, Section 14.9). XOS stores only the result and the provider reference, never the report.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.engagements on insert; never accepted from the caller and never changed.References app.organizations.id |
| engagement_id | uuid | No | Engagement the check is for.References app.engagements.id |
| provider | text | No | Provider; Checkr. |
| provider_reference | text | No | The provider's report reference. |
| result | app.background_check_result | No | Result as the provider reports it. |
| completed_at | timestamp with time zone | Yes | When the provider completed the check; NULL while Pending. |
| 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 |