objid | case | objid | Case internal record number | 3 (UNIQUE) |
id_number | case | id_number | Unique case number assigned based on auto-numbering definition | 4 |
condition | condition | title | Condition of the case | 7 |
status | gse_status(gbst_elm) | title | Status of the case | 8 |
title | case | title | Case or service call title; summary of case details | 2 |
creation_time | case | creation_time | The date and time the case was created | |
first_name | contact | first_name | Contact first name | |
last_name | contact | last_name | Contact last name | |
phone | contact | phone | Contact phone number | |
severity | gse_severity(gbst_elm) | title | Severity of the case | 36 |
type | gse_type(gbst_elm) | title | Type of case | 37 |
is_supercase | case | is_supercase | Indicates whether the case is a super or a victim case; i.e., 0=normal or victim case, 1=supercase | |
cond_objid | condition | objid | Condition internal record number | |
status_objid | gse_status(gbst_elm) | objid | Status internal record number | |
type_objid | gse_type(gbst_elm) | objid | Type internal record number | |
severity_objid | gse_severity(gbst_elm) | objid | Severity internal record number | |
site_objid | site | objid | Site internal record number | |
site_name | site | name | Name of the reporting site | |
site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
condition_code | condition | condition | Code number for condition type | |
contact_objid | contact | objid | Contact internal record number | |