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) | Record key associated with Job and Job Type |
|
|
| co_person_id | integer, foreign key | CO Person ID this record applies to | cm_co_people:id | |
| org_identity_id | integer, foreign key | Org Identity ID this record applies to | cm_org_identities:id | |
comment | varchar(256) | Description of the job task associated with this job history record |
|
|
| status | varchar(2) | Status of the job task associated with this job history record |
|