| case_objid | victimcase(case) | objid | Case internal record number | 3 (UNIQUE) |
| case_id | victimcase(case) | id_number | Unique case number assigned based on auto-numbering definition | 4 |
| case_title | victimcase(case) | title | Case title | 2 |
| type | gse_type(gbst_elm) | objid | Type of case | |
| priority | gse_priority(gbst_elm) | objid | Case priority | |
| severity | gse_severity(gbst_elm) | objid | Case severity | |
| is_supercase | victimcase(case) | is_supercase | Indicates whether the case is a super or a victim case; i.e., 0=normal or victim case, 1=supercase | |
| contact_objid | contact | objid | Contact internal record number | |
| first_name | contact | first_name | Contact first name | 15 |
| last_name | contact | last_name | Contact last name | 14 |
| e_mail | contact | e_mail | Contact primary e-mail address | |
| phone | contact | phone | Contact phone number which includes area code, number, and extension | |
| contact_title | contact | title | Contact's professional title | |
| fax_number | contact | fax_number | Contact's fax number which includes area code, number, and extension | |
| role_objid | contact_role | objid | Contact_role internal record number | |
| role_name | contact_role | role_name | Role name of contact | |
| site_objid | site | objid | Site internal record number | |
| site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
| site_name | site | name | Site name | |
| address_objid | address | objid | Address internal record number | |
| address | address | address | Line 1 of address which includes street number, street name, office, building, or suite number, etc | |
| address2 | address | address_2 | Line 2 of 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 | |
| zipcode | address | zipcode | The zip or other postal code for the specified address | |
| country_objid | country | objid | Country internal record number | |
| country | country | name | Name of the specific country | |
| user_objid | user | objid | Case owner's Internal record number | |
| login_name | user | login_name | User login name | |
| condition_objid | condition | objid | Condition internal record number | |
| condition | condition | title | Title of condition | 7 |
| case_currq2queue | queue | objid | The queue the case is currently dispatched to | 18 |
| case_soln2workaround | workaround | objid | Workaround that is applicable to the case | |
| case_prod2site_part | site_part | objid | Installed part the caller is calling about | |
| case_prt2part_info | mod_level | objid | Problem part revision selected for the case | |
| entitlement2contract | contract | objid | Contract for the part the caller is reporting | |
| case_victim2case | supercase(case) | objid | Super case owner of the case | |
| type_title | gse_type(gbst_elm) | title | Type of case | 37 |
| priority_title | gse_priority(gbst_elm) | title | Priority of case | 35 |
| severity_title | gse_severity(gbst_elm) | title | Severity of case | 36 |
| country_code | country | code | Country code used in telephone numbers for that country | |