Service_Contract Table - Used to track relationships between orgs, ticket attr's and svc types. Used for SLA management
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key of this table |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | with null | Deleted flag (0=active 1=inactive/marked as deleted) |
| sym | nvarchar(80) | with null | Symbolic name of level |
| nx_desc | nvarchar(240) | with null | Descriptive Info |
| contract_num | nvarchar(50) | with null | Contract ID |
| svc_owner | byte(16) | with null | service desk person responsible for contract. Foreign key to the contact_uuid field of the ca_contact table |
| svc_advocate | byte(16) | with null | customer advocate for orgs assigned to contract |
| active | integer | with null | 0 = inactive, 1 = active |
| 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 |
| expiration | integer | with null | Contract expiration |
| org_svc_type | nvarchar(30) | with null | Service Type for Organisation |
| dflt_pcat_st | nvarchar(30) | with null | Default Service Type for request area |
| dflt_isscat_st | nvarchar(30) | with null | Default Service Type for issue category |
| dflt_chgcat_st | nvarchar(30) | with null | Default Service Type for change category |
| dflt_pri_st | nvarchar(30) | with null | Default Service Type for priority |
| dflt_nr_st | nvarchar(30) | with null | Default Service Type for asset |
| dflt_cnt_st | nvarchar(30) | with null | Default Service Type for end user |
Product Name: Unicenter Service Desk
Table Type: Table