| objid | appointment | 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 |
| start_time | appointment | start_time | Appointment start time | 29 |
| end_time | appointment | end_time | Appointment end time | 30 |
| duration | appointment | duration | Length of the appointment in seconds | 6 |
| cell_text | appointment | cell_text | Contains a concatination of locally-selected fields for display by Schedule Tracker. Default is appointment sub_type with start time and end time | |
| 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 | |