app.background_checks
TablaSeguridad a nivel de fila activa
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.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| 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.Hace referencia a app.organizations.id |
| engagement_id | uuid | No | Engagement the check is for.Hace referencia a 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 | Sí | When the provider completed the check; NULL while Pending. |
| deleted_at | timestamp with time zone | Sí | 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 | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |