contact_uuid

ca_contact.contact_uuid: A binary-unique identifier for each ca_contact record.

middle_name

ca_contact. middle_name: The middle name of this contact.

alias

ca_contact.alias: The alternate, often informal name for this contact.

last_name

ca_contact.last_name: This contact's surname.

first_name

ca_contact.first_name: This contact's formal first name.

pri_phone_number

ca_contact.pri_phone_number: The contact's primary phone number.

alt_phone_number

ca_contact.alt_phone_number: The contact's alternate phone number.

fax_number

ca_contact.fax_number: The contact's facsimile number.

mobile_phone

ca_contact.mobile_phone: The contact's mobile phone number.

pager_number

ca_contact.pager_number: The number for issuing a page to the contact's page.

email_address

ca_contact.email_address: The contact's email address.

location_uuid

ca_contact.location_uuid: A binary-unique identifier referencing a record in the ca_location table, which indicates the contact's static location.
ca_contact.location_uuid = ca_location.location_uuid

floor_location

ca_contact.floor_location: A contact's floor number.

pager_email_address

ca_contact.pager_email_address: A contact's email address for their pager.

room_location

ca_contact.room_location: The contact's specific room on the floor at the static location.

contact_type

ca_contact.contact_type: An unique integer-identifier, referring to a row in the ca_contact_type table, which indicates the general function of this contact within the service desk application.
ca_contact.contact_type = ca_contact_type.id

inactive

ca_contact.inactive: A boolean indicator of the state of this record, determining its inclusion or exclusion from standard searches within service desk.

creation_user

ca_contact.creation_user: The userid of the contact who created this record.
ca_contact.creation_user = ca_contact.userid

creation_date

ca_contact.creation_date: A timestamp (pdmtime), indicating the date and time this contact was created.

last_update_user

ca_contact.last_update_user: The userid of the contact who last updated this contact record.
ca_contact.last_update_user = ca_contact.userid

last_update_date

ca_contact.last_update_date: A timestamp (pdmtime), indicating the date and time this record was last modified.

version_number

ca_contact.version number: The internal version indicator.

department

ca_contact.department: An integer-unique identifier, referencing a row in the ca_resource_department table, that indicates the contact's department.
ca_contact.department = ca_resource_department.id

comment

ca_contact.comment: A freeform text comment field for analysts to document important facts that influence the handling of this particular contact.

company_uuid

ca_contact.company_uuid: A binary-unique identifier, which references a row in the ca_company table. It indicates this contact's affiliation with a company.
ca_contact.company_uuid = ca_company.company_uuid

organization_uuid

ca_contact.organizaiton_uuid: A binary-unique identifier which references a row in the ca_organization table. It indicates this contact's working organization.
ca_contact.organizaiton_uuid = ca_organization.organization_uuid

admin_organization_uuid

ca_contact.admin_organization_uuid: A binary-unique identifier, which references a row in the ca_organization table. It indicates this contact's administrative organization.
ca_contact.admin_organization_uuid = ca_organization.organization_uuid

alternate_identifier

ca_contact.alternate_identifier: A user-defined identifier, usually an entity used by human resources to uniquely identify this contact.

job_title

ca_contact.job_title: An integer-unique identifier, which references the ca_job_title table. It indicates the standardized job title for this contact.
ca_contact.job_title = ca_job_title.id

job_function

ca_contact.job_function: An integer-unique identifier, which references the ca_job_function table. It indicates a standardized general description of the contact's job function.
ca_contact.job_function = ca_job_function.id

mail_stop

ca_contact.mail_stop: Mail Stop.

cost_center

ca_contact.cost_center: An integer-unique identifier, which references the ca_resource_cost_center table. It indicates this contact's primary cost center.
ca_contact.cost_center = ca_cost_center.id

userid

ca_contact.userid: The user identifier this contact will use for logging into service desk.

supervisor_contact_uuid

ca_contact.supervisor_contact_uuid: A binary-unique identifier, referencing a row in the ca_contact table, that creates a hierarchy of contacts to indicate the reporting structure of each contact.
ca_contact.supervisor_contact_uuid = ca_contact.contact_uuid

exclude_registration

ca_contact.exclude registration: An internal flag.

delete_time

ca_contact.delete_time: A timestamp indicating when the inactive flag was set to 1.

contact_type_name

ca_contact_type.name: A short description of this contact's ca_contact.contact_type.

location_name

ca_location.name: A short description of this contact's static location.

organization

ca_organization.org_name: A short description of this contact's ca_contact.organizaiton_uuid.

admin_organization

ca_organization.org_name: A short description of this contact's organization name.
ca_contact.admin_organization_uuid

service_type

srv_desc.sym: A short description of this contact's usp_contact.c_service_type.
ca_contact.contact_uuid = usp_contact.contact_uuid AND usp_contact.c_service_type = srv_desc.code

state_sym

ca_location.state: An integer-unique identifier, referencing a row in the ca_state_provice table, that indicates the State, Province, or other artificially defined geographic region.
ca_contact.location_uuid = ca_location.location_uuid AND ca_location.state = ca_state_province.id