Table | cm_co_jobs |
|---|---|
Description | Per-CO Job Records |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
co_id | integer, foreign key | CO Record ID | cm_cos:id |
|
job_type | varchar(2) | Job Type |
|
|
| job_type_fk | integer | Foreign key value associated with Job Type | eg: cm_org_identity_sources:id | |
| job_mode | varchar(16) | Job Type-specific mode | ||
status | varchar(2) | Job Status |
|
|
| register_summary | varchar(256) | Summary description for status at time of job registration | ||
| start_summary | varchar(256) | Summary description for status at time of job start | ||
| finish_summary | varchar(256) | Summary description for status at time of job completion | ||
| queue_time | timestamp | Time Job was queued | ||
| start_time | timestamp | Time Job was started | ||
| complete_time | timestamp | Time Job was completed |