Issues.
| 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 | Reference number |
| summary | nvarchar(240) | with null | summary text |
| description | nvarchar(4000) | with null | Text description of the |
| status | nvarchar(12) | with null | Status. Foreign key to the code field of the isstat table. |
| active_flag | integer | not null | 0 = inactive, 1 = active |
| start_date | integer | with null | Date processing started |
| open_date | integer | with null | date entered |
| 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 when this Issue was closed |
| resolve_date | integer | with null | Timestamp when this Issue 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) | with 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 isscat table. |
| priority | integer | not null | Priority. Foreign key to the enum field of the pri table. |
| need_by | integer | with null | The need by value for this Issue. |
| est_comp_date | integer | with null | The estimated completion date value for this Issue. |
| actual_comp_date | integer | with null | Actual Completion Date timestamp |
| est_cost | integer | with null | The estimated cost value for this Issue. |
| actual_cost | integer | with null | Actual Cost of this issue |
| justification | nvarchar(240) | with null | The justification value for this Issue. |
| backout_plan | nvarchar(240) | with null | The backout plan value for this Issue. |
| impact | integer | with null | Impact. Foreign key to the enum field of the impact table. |
| parent | nvarchar(30) | with null | Parent. Foreign key to the persistent_id field of the iss table. |
| effort | nvarchar(240) | with null | The effort value for this Issue. |
| 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 iss_tpl table. |
| sla_violation | integer | with null | 1=has violated its sla |
| predicted_sla_viol | integer | with null | 1=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 | Unique (to the table) Numeric ID |
| call_back_date | integer | with null | The call back timestamp for this Issue |
| call_back_flag | integer | with null | The call back flag value for this Issue |
| 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 Issue. |
| service_num | nvarchar(30) | with null | The service num value for this Issue. |
| 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 Issue. |
| 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 Issue 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 | The flag1 value for this Issue. |
| flag2 | integer | with null | The flag2 value for this Issue. |
| flag3 | integer | with null | The flag3 value for this Issue. |
| flag4 | integer | with null | The flag4 value for this Issue. |
| flag5 | integer | with null | The flag5 value for this Issue. |
| flag6 | integer | with null | The flag6 value for this Issue. |
| 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
Relationships:
| Primary Key | Related Table | Related Column |
| id | view_issue |