Change Orders
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key of this table |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| chg_ref_num | nvarchar(30) | not null | User visible reference number |
| summary | nvarchar(240) | with null | Change Order summary text |
| description | nvarchar(4000) | with null | Textual description of this Change Order |
| status | nvarchar(12) | with null | Status. Foreign key to the code field of the chgstat table. |
| active_flag | integer | not null | 0 = inactive, 1 = active |
| start_date | integer | with null | Timestamp of when processing started |
| open_date | integer | with null | Timestamp of when this Change Order was created |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Specifies the UUID of the contact who last modified this record |
| close_date | integer | with null | Timestamp of when the Change Order was closed |
| resolve_date | integer | with null | Timestamp of when the Change Order was resolved |
| rootcause | integer | with null | Root Cause. Foreign key to the id field of the rootcause table. |
| est_total_time | integer | with null | Sum of estimated task time |
| actual_total_time | integer | with null | Sum of actual task time |
| log_agent | byte(16) | not null | Reported By. Foreign key to the contact_uuid field of the ca_contact table. |
| assignee | byte(16) | with null | Assignee. Foreign key to the contact_uuid field of the ca_contact table. |
| organization | byte(16) | with null | Organization. Foreign key to the id field of the ca_organization table. |
| group_id | byte(16) | with null | Group. Foreign key to the contact_uuid field of the ca_contact table. |
| affected_contact | byte(16) | not null | Affected End User. Foreign key to the contact_uuid field of the ca_contact table. |
| requestor | byte(16) | not null | Requester. Foreign key to the contact_uuid field of the ca_contact table. |
| category | nvarchar(12) | with null | Category. Foreign key to the code field of the chgctg table. |
| priority | integer | not null | Priority. Foreign key to the enum field of the pri table. |
| need_by | integer | with null | Need By Date timestamp |
| est_comp_date | integer | with null | Estimated Completion Date timestamp |
| actual_comp_date | integer | with null | Actual Completion Date timestamp |
| est_cost | integer | with null | Estimated Cost of this Change Order |
| actual_cost | integer | with null | Actual Cost of this Change Order |
| justification | nvarchar(4000) | with null | The justification value for this Change_Request. |
| backout_plan | nvarchar(4000) | with null | The backout plan value for this Change_Request. |
| impact | integer | with null | Impact. Foreign key to the enum field of the impact table. |
| parent | integer | with null | Foreign key to the id field of the chg table to allow for hierarchical Change Order groupings (e.g. "parent/child"). |
| effort | nvarchar(240) | with null | The effort value for this Change_Request. |
| support_lev | nvarchar(30) | with null | Classic Service Type. Foreign key to the code field of the srv_desc table. |
| template_name | nvarchar(30) | with null | Template. Foreign key to the template_name field of the chg_tpl table. |
| sla_violation | integer | with null | 1=change order has violated its sla |
| predicted_sla_viol | integer | with null | 1=change order has been predicted by neugents |
| macro_predict_viol | integer | with null | that it is likely to violated its sla (boolean) for action macros to predict sla violations |
| created_via | integer | with null | Created via Interface. Foreign key to the id field of the interface table. |
| call_back_date | integer | with null | The call back timestamp for this Change Order |
| call_back_flag | integer | with null | The call back flag value for this Change Order |
| string1 | nvarchar(40) | with null | User defined string field |
| string2 | nvarchar(40) | with null | User defined string field |
| string3 | nvarchar(40) | with null | User defined string field |
| string4 | nvarchar(40) | with null | User defined string field |
| string5 | nvarchar(40) | with null | User defined string field |
| string6 | nvarchar(40) | with null | User defined string field |
| service_date | integer | with null | The service date value for this Change_Request. |
| service_num | nvarchar(30) | with null | The service num value for this Change_Request. |
| product | integer | with null | Product. Foreign key to the id field of the product table |
| actions | nvarchar(750) | with null | The actions value for this Change_Request. |
| type_of_contact | integer | with null | Type of Contact. Foreign key to the id field of the toc table |
| reporting_method | integer | with null | How this Change Order was reported. Foreign key to the id field of the repmeth table |
| person_contacting | integer | with null | The person that contacted us. Foreign key to the id field of the person table |
| flag1 | integer | with null | User defineable integer flag |
| flag2 | integer | with null | User defineable integer flag |
| flag3 | integer | with null | User defineable integer flag |
| flag4 | integer | with null | User defineable integer flag |
| flag5 | integer | with null | User defineable integer flag |
| flag6 | integer | with null | User defineable integer flag |
| user1 | nvarchar(100) | with null | User defineable string field |
| user2 | nvarchar(100) | with null | User defineable string field |
| user3 | nvarchar(100) | with null | User defineable string field |
| cawf_procid | nvarchar(40) | with null | CA Workflow process id |
Product Name: Unicenter Service Desk
Table Type: Table