c_acctyp_id

INTEGER

Access_
Type::id

Identifies the unique (to the table) numeric ID.

c_available

INTEGER

Displays as a check box to indicate that the analyst is available.

c_cm_id1

INTEGER

Contact_
Method
::id

Foreign key to the id field of the ct_mth table, this identifies the low priority of the contact method.

c_cm_id2

INTEGER

Contact_
Method::id

Foreign key to the id field of the ct_mth table, this identifies the next level of low priority for the contact method.

c_cm_id3

INTEGER

Contact_
Method::id

Foreign key to the id field of the ct_mth table, this identifies the standard level of priority for the contact method.

c_cm_id4

INTEGER

Contact_
Method::id

Foreign key to the id field of the ct_mth table, this identifies the high level of priority for the contact method.

c_domain

INTEGER

Domain
:id

Foreign key to the id field of the dmn table, this is the Data Partition.

c_email_
service

nvarchar
30

(Not used by CA SDM) Identifies the pointer to the access type email service (such as, PROFS, and so on).

c_nx_ref_1

byte(16)

Foreign key to the contact_uuid field of the ca_contact table, this is a user-defined field.

c_nx_ref_2

byte(16)

Foreign key to the contact_uuid field of the ca_contact table, this is a user-defined field.

c_nx_ref_3

byte(16)

Foreign key to the contact_uuid field of the ca_contact table, this is a user-defined field.

c_nx_
string1

nvarchar
(40)

Identifies the emergency Workshift 4 Smag fields.

c_nx_
string2

nvarchar
(40)

Allows for a user-defined string field.

c_nx_
string3

nvarchar
(40)

Allows for a user-defined string field.

c_nx_
string4

nvarchar
(40)

Allows for a user-defined string field.

c_nx_
string5

nvarchar
(40)

Allows for a user-defined string field.

c_nx_
string6

nvarchar
(40)

Allows for a user-defined string field.

c_parent

byte(16)

(Not used in CA SDM) Foreign key to the contact_uuid field of the ca_contact table.

c_schedule

nvarchar
30

Bop_
Workshift
::persid

Foreign key to the persistent_id field of the bpwshft table, this is the Analyst's workshift for Auto Assignment.

c_service
_type

nvarchar
30

Service_
Desc::
code

Foreign key to the code field of the srv_desc table, this identifies the Classic Service Type.

c_timezone

nvarchar
(12)

Timezone
::code

Foreign key to the code field of the tz table, this defines the Timezone.

c_val_req

INTEGER

Specifies a Force validation of the userid.

c_vendor

byte(16)

ca_
company
::company
_uuid

Foreign key to the id filed of the ca_company table, this represents the Vendor.

c_ws_id1

nvarchar
30

Bop_
Workshift
::persid

Foreign key to the persistent_id field of the bpwshft table, this represents a workshift ID.

c_ws_id2

nvarchar
30

Bop_Work
shift::
persid

Foreign key to the persistent_id field of the bpwshft table, this represents a workshift ID.

c_ws_id3

nvarchar
30

Bop_Work
shift::
persid

Foreign key to the persistent_id field of the bpwshft table, this represents a workshift ID.

c_ws_id4

nvarchar
30

Bop_Work
shift::
persid

Foreign key to the persistent_id field of the bpwshft table, this represents a workshift ID.

contact_
uuid

byte(16)

Primary key of this table.

global_
queue_id

INTEGER

Global_
Queue_
Names::id

Specifies the pointer to the global queue.

ldap_dn

nvarchar
(512)

Identifies the ldap dn value for this usp_contact.