Table

cm_vetting_requests

Description

Per-CO Vetting Requests

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_person_id

integer, foreign key

CO Person ID

cm_co_people:id


vetting_step_idinteger, foreign keyVetting Step IDcm_vetting_steps:idWhen the Vetting Request is in a pending status, the current step

co_job_id

integer, foreign keyCO Job ID

cm_co_jobs:id

When the Vetting Request is queued for processing, the CO Job that is queued to process it

statusvarchar(2)Status
  • ER: Error
  • N: Failed
  • PM: Pending Manual Resolution
  • PR: Pending Result
  • R: Requested
  • X: Canceled
  • Y: Passed

  • No labels