Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table

cm_co_job_history_records

Description

Per-CO Job History Records

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 


co_job_id

integer, foreign key

CO Job Record ID

cm_co_jobs:id

 


record_key

varchar(

64

256)

Record key associated with Job and Job Type

 

 


Revised from varchar(64) in Registry v4.4.0

co_person_idinteger, foreign keyCO Person ID this record applies tocm_co_people:id
 

org_identity_idinteger, foreign keyOrg Identity ID this record applies tocm_org_identities:id
 

comment

varchar(256)

Description of the job task associated with this job history record

 

 



statusvarchar(2)Status of the job task associated with this job history record
  • GO: In Progress
  • OK: Complete
  • Q: Queued
  • X: Failed