objid | case | objid | Case internal record number | 3 (UNIQUE) |
id_number | case | id_number | Unique case number assigned based on auto-numbering definition | |
title | case | title | Case or service call title; summary of case details | |
condition | condition | condition | The condition of the case | |
wipbin_title | wipbin | title | Name of the case's wipbin | |
queue_title | queue | title | Name of the case's queue | |
login_name | e(user) | login_name | Database login of the user | |
originator_phone | f(employee) | phone | Phone number of the case originator | |
owner_phone | h(employee) | phone | Phone number of the case owner | |
case_type | a(gbst_elm) | title | Call type of case: This is a Clarify-defined pop up list | |
case_priority | b(gbst_elm) | title | Response priority of case: This is a Clarify-defined pop up list | |
case_severity | c(gbst_elm) | title | Response severity of case: This is a Clarify-defined pop up list | |
instance_name | site_part | instance_name | Name of the part instance the case is about | |
contract_type | contract | type | The specific nature of the contract-standard. This is a user-defined pop up list with default name of CONTRACT_TYPE | |
site_name | site | name | Name of the site reporting the case | |
site_id | site | site_id | Unique identifier of the site reporting the case | |
address | address | address | Line 1 of site address which includes street number, street name, office, building, or suite number, etc | |
address_2 | address | address_2 | Line 2 of the site address which typically includes office, building, or suite number, etc | |
city | address | city | The city for the specified address | |
state | address | state | The state for the specified address | |
zip_code | address | zipcode | The state for the specified address | |
first_name | contact | first_name | First name of the case contact | |
last_name | contact | last_name | Last name of the case contact | |
contact_phone | contact | phone | Phone number of the case contact | |