Change Request categories. Can 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 | Change Category symbolic description |
| code | nvarchar(12) | not null | Primary key of this table |
| 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 | Textual description of this change category |
| 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. |
| children_ok | integer | not null | Handling change category 0=children not allowed, 1=ok |
| service_type | nvarchar(30) | with null | The service type value for this Change_Category. |
| survey | integer | with null | Survey. Foreign key of 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 Contract. Foreign key to the id field of the svc_contract table. |
| cawf_defid | nvarchar(40) | with null | CA Workflow definition id |
Product Name: Unicenter Service Desk
Table Type: Table