This table provides extensions to the ca_owned_resource table that are used only by Unicenter Service Desk products
| Column Name | Column Datatype | Column Null Option | Column Comment |
| owned_resource_uuid | byte(16) | not null | Primary key. UUID to uniquely identify the owned resource within tables supporting ownership information. |
| nr_prim_skt_id | integer | with null | Pointer to primary search key type |
| nr_pr_id | integer | with null | Enumerated value for this entry - specifies ordering in lists and relative values |
| nr_wrty_st_dt | integer | with null | Warranty start date |
| nr_wrty_end_dt | integer | with null | Warranty end date |
| nr_exp_dt | integer | with null | date license, lease,... Expires |
| nr_sla_id | integer | with null | The sla value for this usp_owned_resource. |
| nr_nx_string1 | nvarchar(40) | with null | User defined string field |
| nr_nx_string2 | nvarchar(40) | with null | User defined string field |
| nr_nx_string3 | nvarchar(40) | with null | User defined string field |
| nr_nx_string4 | nvarchar(40) | with null | User defined string field |
| nr_nx_string5 | nvarchar(40) | with null | User defined string field |
| nr_nx_string6 | nvarchar(40) | with null | User defined string field |
| nr_nx_ref_1 | byte(16) | with null | User defined contact field. Foreign key to the contact_uuid field of the ca_contact table |
| nr_nx_ref_2 | byte(16) | with null | User defined contact field. Foreign key to the contact_uuid field of the ca_contact table |
| nr_nx_ref_3 | byte(16) | with null | User defined contact field. Foreign key to the contact_uuid field of the ca_contact table |
| nr_financial_id | nvarchar(40) | with null | Financial number |
| nr_service_type | nvarchar(30) | with null | Noneditable enum for |
| nr_argis_id | nvarchar(40) | with null | Argis Workflow Asset ID |
| nr_bms | integer | with null | Change impact analyzer status. Foreign key id field of busstat table |
| nr_bmlabel | nvarchar(255) | with null | Change impact analyzer label |
| nr_bm_rep | integer | with null | Change impact analyzer repository. Foreign key to id field of busrep table |
Product Name: Unicenter Service Desk
Table Type: Table