Requests and for ITIL installations, also contains Incidents and Problems
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) Numeric ID |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| ref_num | nvarchar(30) | not null | User visible reference number |
| summary | nvarchar(240) | with null | summary text |
| description | nvarchar(4000) | with null | Textual description of this call request |
| status | nvarchar(12) | with null | Status. Foreign key to the code field of the cr_stat table. |
| active_flag | integer | not null | 0 = inactive, 1 = active |
| open_date | integer | with null | Timestamp of when this Request was created |
| time_spent_sum | integer | with null | Sum of activity time spent |
| 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 this Request was closed |
| resolve_date | integer | with null | Timestamp of when this Request was resolved |
| rootcause | integer | with null | Root Cause. Foreign key to the id field of the rootcause table. |
| 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. |
| group_id | byte(16) | with null | Assigned to Group. Foreign key to the contact_uuid field of the ca_contact table. |
| customer | byte(16) | not null | Affected End User. Foreign key to the contact_uuid field of the ca_contact table. |
| charge_back_id | nvarchar(12) | with null | User defined string field |
| affected_rc | byte(16) | with null | Asset. Foreign key to the id field of the ca_owned_resource table |
| support_lev | nvarchar(30) | with null | Classic Service Type. Foreign key to the code field of the srv_desc table. |
| category | nvarchar(30) | with null | Category. Foreign key to the persistent_id field of the prob_ctg table. |
| solution | nvarchar(30) | with null | Deprecated. Foreign key to the persistent_id field of the crsol table for old Request solutions. |
| impact | integer | with null | Impact. Foreign key to the enum field of the impact table. |
| priority | integer | not null | Priority. Foreign key to the enum field of the pri table. |
| urgency | integer | with null | Urgency. Foreign key to the enum field of the urgncy table. |
| severity | integer | with null | Severity. Foreign key to the enum field of the sevrty table. |
| extern_ref | nvarchar(30) | with null | Deprecated. the trouble ticket associated with this request |
| last_act_id | nvarchar(12) | with null | Persid of last activity |
| cr_tticket | integer | with null | Deprecated. |
| parent | nvarchar(30) | with null | Foreign key to the persistent_id field of the call_req table to allow for hierarchical Request groupings (e.g. "parent/child"). |
| template_name | nvarchar(30) | with null | Template. Foreign key to the template_name field of the cr_tpl table. |
| sla_violation | integer | with null | If defined, flags request as template 1=request has violated its sla |
| predicted_sla_viol | integer | with null | 1=request 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 Request |
| call_back_flag | integer | with null | The call back flag value for this Request. |
| event_token | nvarchar(30) | with null | Used by TNGeh_writer for message matching |
| sched_token | nvarchar(128) | with null | Job scheduling token |
| type | nvarchar(10) | with null | Request type. Foreign key to the crt table |
| 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 |
| problem | nvarchar(30) | with null | Foreign key to the persistent_id field of the call_req table to allow for linking this incident to a problem |
| incident_priority | integer | with null | The computed incident priority if this is an ITIL incident. |
| change | integer | with null | Associated Change Order. Foreign key to the id field of the chg table. |
Product Name: Unicenter Service Desk
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | view_audit_group view_audit_assignee view_audit_status view_audit_priority |