Call Request call areas. Category of the issue the customer is calling about. May be hierarchical.
| 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) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| sym | nvarchar(30) | not null | Request Area symbolic name |
| 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 |
| description | nvarchar(500) | with null | Text description of call area |
| organization | byte(16) | with null | Organization. Foreign key to the id field of the ca_organization 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 | Group. Foreign key to the contact_uuid field of the ca_contact table. |
| tcode | integer | with null | Deprecated |
| service_type | nvarchar(30) | with null | Classic Service Type. Foreign key to the code field of the srv_desc table. |
| survey | integer | with null | Survey Template. Foreign key to the id field of the survey_tpl table |
| schedule | integer | with null | Deprecated |
| auto_assign | integer | with null | Flag to enable auto assignment |
| owning_contract | integer | with null | Service Contact. Foreign key to the id field of the svc_contract table |
| cr_flag | integer | with null | When set to 1, this status is valid for requests |
| in_flag | integer | with null | When set to 1, this status is valid for incidents |
| pr_flag | integer | with null | When set to 1, this status is valid for problems |
Product Name: Unicenter Service Desk
Table Type: Table