Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
appt_confirm	LONG	smallint				DIRECT	0=unconfirmed, 1=confirmed, default=0
cell_text	CHAR	varchar		255			Contains a concatenation of locally-selected fields for display by Schedule Tracker.
city	CHAR	varchar		30		SEARCHABLE	City where site is located
district	CHAR	varchar		80		SEARCHABLE	District to which the site belongs
duration	LONG	int	6			DIRECT	Length of appointment in seconds
first_name	CHAR	varchar	15	30		SEARCHABLE	Employee first name
last_name	CHAR	varchar	14	30		SEARCHABLE	Employee last name
login_name	CHAR	varchar	2	30		SEARCHABLE	User login name
objid	LONG	int	3			DIRECT	Internal record number of disptchfe, appointment, employee
region	CHAR	varchar		80		SEARCHABLE	Region to which the site belongs
s_city	CHAR	varchar		30			City where site is located
s_district	CHAR	varchar		80			District to which the site belongs
s_first_name	CHAR	varchar		30			Employee first name
s_last_name	CHAR	varchar		30			Employee last name
s_login_name	CHAR	varchar		30			User login name
s_region	CHAR	varchar		80			Region to which the site belongs
s_site_name	CHAR	varchar		80			Name of the site
s_state	CHAR	varchar		30			State where site is located
s_status	CHAR	varchar		50			Contains a concatenation of locally-selected fields for display by Schedule Tracker.
s_type_name	CHAR	varchar		70			Name of the schedule type - Available, Appointment, or Field Dispatch
site_id	CHAR	varchar		80			Unique site number assigned according to auto-numbering definition
site_name	CHAR	varchar		80		SEARCHABLE	Name of the site
start_time	CLK_TIME	datetime					Time appointment starts or requested eta for field dispatch
state	CHAR	varchar		30		SEARCHABLE	State where site is located
status	CHAR	varchar		50		SEARCHABLE	Contains a concatenation of locally-selected fields for display by Schedule Tracker.
type	CHAR	varchar		32			type of schedule, 0 for Available, 1 for Appointment, 2 for Field Dispatch
type_name	CHAR	varchar		70		SEARCHABLE	Name of the schedule type - Available, Appointment, or Field Dispatch
user_objid	LONG	int				DIRECT	Internal record number of user

SQL:

(select objid, '1' as type, type_elm_title as type_name, type_elm_title as type_name, user_objid, first_name, first_name,
last_name, last_name, district, district, region, region, site_id, site_name, site_name, city, city, state, state, login_name, login_name,
start_time as start_time, duration, 0 as appt_confirm, cell_text, status_elm_title as status, status_elm_title as status
from table_schdl_tracker_sub_v1
where status_lst_title = 'SCHEDULE_STATUS' AND status_elm_rank = 4 AND type_lst_title = 'SCHEDULE_TYPE' AND type_elm_rank = 2
union
select objid, '2' as type, type_elm_title as type_name, type_elm_title as type_name, user_objid, first_name, first_name,
last_name, last_name, district, district, region, region, site_id, site_name, site_name, city, city, state, state, login_name, login_name,
requested_eta as start_time, duration, appt_confirm, cell_text, status_elm_title as status, status_elm_title as status
from table_schdl_tracker_sub_v2
where status_lst_title = 'SCHEDULE_STATUS' AND appt_confirm=status_elm_rank-2 AND type_lst_title = 'SCHEDULE_TYPE' AND type_elm_rank = 3 AND queue_objid IS NULL AND wipbin_objid IS NOT NULL
union
select objid, '2' as type, type_elm_title as type_name, type_elm_title as type_name, user_objid, first_name, first_name,
last_name, last_name, district, district, region, region, site_id, site_name, site_name, city, city, state, state, login_name, login_name,
requested_eta as start_time, duration, appt_confirm, cell_text, status_elm_title as status, status_elm_title as status
from table_schdl_tracker_sub_v3
where status_lst_title = 'SCHEDULE_STATUS' AND appt_confirm=status_elm_rank-2 AND type_lst_title = 'SCHEDULE_TYPE' AND type_elm_rank = 3 AND queue_objid IS NULL AND wipbin_objid IS NOT NULL
union
select objid, '2' as type, type_elm_title as type_name, type_elm_title as type_name, user_objid, first_name, first_name,
last_name, last_name, district, district, region, region, site_id, site_name, site_name, city, city, state, state, login_name, login_name,
requested_eta as start_time, duration, appt_confirm, cell_text, status_elm_title as status, status_elm_title as status
from table_schdl_tracker_sub_v4
where status_lst_title = 'SCHEDULE_STATUS' AND appt_confirm=status_elm_rank-2 AND type_lst_title = 'SCHEDULE_TYPE' AND type_elm_rank = 3 AND shared_pers >= 0
union
select objid, '2' as type, type_elm_title as type_name, type_elm_title as type_name, user_objid, first_name, first_name,
last_name, last_name, district, district, region, region, site_id, site_name, site_name, city, city, state, state, login_name, login_name,
requested_eta as start_time, duration, appt_confirm, cell_text, status_elm_title as status, status_elm_title as status
from table_schdl_tracker_sub_v5
where status_lst_title = 'SCHEDULE_STATUS' AND appt_confirm=status_elm_rank-2 AND type_lst_title = 'SCHEDULE_TYPE' AND type_elm_rank = 3 AND shared_pers >= 0
union
select objid, '0' as type, type_elm_title as type_name, type_elm_title as type_name, user_objid, first_name, first_name, last_name, last_name,
district, district, region, region, site_id, site_name, site_name, city, city, state, state, login_name, login_name,
start_time as start_time, duration, 0 as appt_confirm, item_elm_title as cell_text, status_elm_title as status, status_elm_title as status
from table_schdl_tracker_sub_v6
where appt_objid=-2 AND status_lst_title = 'SCHEDULE_STATUS' AND status_elm_rank = 1 AND type_lst_title = 'SCHEDULE_TYPE' AND type_elm_rank = 1 AND item_lst_title = 'SCHEDULE_ITEM' AND item_elm_rank = 0)