active

INTEGER

Active_Boolean_ Table::enum

Specifies the status of the contract, as follows:
0—Inactive
1—Active

contract_num

nvarchar(50)

Identifies the Contract ID.

del

INTEGER

Active_Boolean_ Table::enum

Specifies the Deleted flag, as follows:
0—Active
1—Inactive/marked as deleted

dflt_chgcat_st

nvarchar(30)

Service_Desc::code

Defines the default service type for the change category.

dflt_cnt_st

nvarchar(30)

Service_Desc::code

Defines the default service type for the end user.

dflt_isscat_st

nvarchar(30)

Service_Desc::code

Defines the default service type for the issue category.

dflt_nr_st

nvarchar(30)

Service_Desc::code

Defines the default service type for the asset.

dflt_pcat_st

nvarchar(30)

Service_Desc::code

Defines the default service type for the request area.

dflt_pri_st

nvarchar(30)

Service_Desc::code

Defines the default service type for the priority.

expiration

INTEGER

Specifies the Contract expiration date.

id

INTEGER

Primary key of this table.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

Identifies the timestamp of when this record was last modified.

nx_desc

nvarchar
(240)

Specifies descriptive information.

org_svc_type

nvarchar(30)

Service_Desc::code

Defines the service type for the organization.

persid

nvarchar(30)

Persistent ID (SystemObjectName:id).

svc_advocate

byte(16)

ca_contact::uuid

Identifies the customer advocate for the organizations assigned to the contract.

svc_owner

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table, this is the service desk person responsible for contract.

sym

nvarchar(80)

Specifies the symbolic name of the contract level.