This table provides extensions to the ca_contact table that are used only by Unicenter Service Desk products
| Column Name | Column Datatype | Column Null Option | Column Comment |
| contact_uuid | byte(16) | not null | Primary key of this table |
| c_acctyp_id | integer | with null | Unique (to the table) Numeric ID |
| c_email_service | nvarchar(30) | with null | Not used in Service Desk. Pointer to access type email service (PROFS, etc) |
| c_cm_id1 | integer | with null | Contact Method. Foreign key to the id field of the ct_mth table |
| c_cm_id2 | integer | with null | Contact Method. Foreign key to the id field of the ct_mth table |
| c_cm_id3 | integer | with null | Contact Method. Foreign key to the id field of the ct_mth table |
| c_cm_id4 | integer | with null | Contact Method. Foreign key to the id field of the ct_mth table |
| c_ws_id1 | nvarchar(30) | with null | Workshift. Foreign key to the persistent_id field of the bpwshft table |
| c_ws_id2 | nvarchar(30) | with null | Workshift. Foreign key to the persistent_id field of the bpwshft table |
| c_ws_id3 | nvarchar(30) | with null | Workshift. Foreign key to the persistent_id field of the bpwshft table |
| c_ws_id4 | nvarchar(30) | with null | Workshift. Foreign key to the persistent_id field of the bpwshft table |
| c_nx_string1 | nvarchar(40) | with null | User defined string field |
| c_nx_string2 | nvarchar(40) | with null | User defined string field |
| c_nx_string3 | nvarchar(40) | with null | User defined string field |
| c_nx_string4 | nvarchar(40) | with null | User defined string field |
| c_nx_string5 | nvarchar(40) | with null | User defined string field |
| c_nx_string6 | nvarchar(40) | with null | User defined string field |
| c_nx_ref_1 | byte(16) | with null | User defined contact field. Foreign key to the contact_uuid field of the ca_contact table |
| c_nx_ref_2 | byte(16) | with null | User defined contact field. Foreign key to the contact_uuid field of the ca_contact table |
| c_nx_ref_3 | byte(16) | with null | User defined contact field. Foreign key to the contact_uuid field of the ca_contact table |
| c_parent | byte(16) | with null | Not used in Service Desk. Foreign key to the contact_uuid field of the ca_contact table |
| c_vendor | byte(16) | with null | Vedndor. Foreign key to the id filed of the ca_company table |
| c_domain | integer | with null | Data Partition. Foreign key to the id field of the dmn table |
| c_service_type | nvarchar(30) | with null | Classic Service Type. Foreign key to the code field of the srv_desc table. |
| c_timezone | nvarchar(30) | with null | Timezone. Foreign key to the code field of the tz table |
| c_val_req | integer | with null | Force validation of userid |
| c_schedule | nvarchar(30) | with null | Analysts workshift for auto-assignment. Foreign key to the persistent_id field of the bpwshft table. |
| c_available | integer | with null | Checkbox indicating analyst is available |
| global_queue_id | integer | with null | Pointer to global queue |
| ldap_dn | nvarchar(512) | with null | The ldap dn value for this usp_contact. |
Product Name: Unicenter Service Desk
Table Type: Table