| objid | disptchfe | objid | Internal record number of appointment | 3 (UNIQUE) |
| user_objid | user | objid | User internal record number | |
| first_name | employee | first_name | Employee first name | 15 |
| last_name | employee | last_name | Employee last name | 14 |
| region | site | region | Region to which the site belongs | |
| district | site | district | District to which the site belongs | |
| site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
| site_name | site | name | Site name | |
| city | address | city | Site city | |
| state | address | state | Site state | |
| login_name | user | login_name | Login name of user | 12 |
| appointment | disptchfe | appointment | Proposed date/time of scheduled appointment or commitment | |
| duration | disptchfe | duration | Expected amount of time to complete the task in seconds | |
| requested_eta | disptchfe | requested_eta | Requested date and time of field engineer's arrival at dispatch site | |
| appt_confirm | disptchfe | appt_confirm | 0=unconfirmed, 1=confirmed, default=0 | |
| cell_text | disptchfe | cell_text | Contains a concatination of locally-selected fields for display by Schedule Tracker. Default is field case.id_number | |
| queue_objid | queue | objid | queue object ID | |
| wipbin_objid | wipbin | objid | wipbin object ID | |
| status_lst_title | hgse_status(hgsl2hgse) | lst_title | Title of the user defined popup list | |
| status_elm_title | hgse_status(hgsl2hgse) | elm_title | Title of the user defined popup list element | |
| status_elm_rank | hgse_status(hgsl2hgse) | elm_rank | Rank order of the item in its list | |
| type_lst_title | hgse_type(hgsl2hgse) | lst_title | Title of the user defined popup list | |
| type_elm_title | hgse_type(hgsl2hgse) | elm_title | Title of the user defined popup list element | |
| type_elm_rank | hgse_type(hgsl2hgse) | elm_rank | Rank order of the item in its list | |