SELECT eot.assigned_to_id, eot.color_value, eot.element_end_time, DATE_FORMAT(eot.element_end_time, '%H%i%s') AS temp_end_time, (0 + 0) AS temp_end_time_2, eot.element_start_date, eot.element_start_time, DATE_FORMAT(eot.element_start_time, '%H%i%s') AS temp_start_time, (0 + 0) AS temp_start_time_2, eot.end_dates_closed, eot.time_id, tie_in_flex_grid.sub_user_payee_id AS use_assigned_to_id FROM elements_of_time AS eot, tie_in_flex_grid WHERE eot.corp_id = tie_in_flex_grid.corp_id AND eot.time_id = tie_in_flex_grid.time_id AND eot.corp_id = #variables.currentCorpId# AND eot.element_start_date = #CreateODBCDate(FORM.use_date)# AND eot.element_master_status = 1 AND eot.time_template_id NOT IN (#variables.useRosterList#,#variables.useClinicList#) AND tie_in_flex_grid.flex_grid_line_status = 1 AND tie_in_flex_grid.sub_user_payee_id > 0 AND eot.time_template_id = #Trim(FORM.time_template_id)# AND eot.color_value = '#Trim(FORM.color_value)#' AND tie_in_flex_grid.sub_user_payee_id = #Trim(FORM.assigned_to_id)# AND tie_in_flex_grid.sub_user_payee_id IN (#Trim(FORM.assigned_to_id)#) ORDER BY eot.element_start_date, eot.element_start_time, eot.time_id SELECT assigned_to_id AS use_assigned_to_id FROM retMainTime_st.qryGetTimeElements WHERE assigned_to_id <> 1 GROUP BY assigned_to_id ORDER BY assigned_to_id SELECT assigned_to_id AS use_assigned_to_id FROM retSubDates_st.qryGetSubDates WHERE assigned_to_id <> 1 GROUP BY assigned_to_id ORDER BY assigned_to_id SELECT tie_in_flex_grid.sub_user_payee_id AS use_assigned_to_id FROM elements_of_time, tie_in_flex_grid WHERE elements_of_time.corp_id = tie_in_flex_grid.corp_id AND elements_of_time.time_id = tie_in_flex_grid.time_id AND elements_of_time.corp_id = #variables.currentCorpId# AND elements_of_time.element_start_date = #CreateODBCDate(FORM.use_date)# AND elements_of_time.element_master_status = 1 AND elements_of_time.time_template_id = #variables.useRosterList# AND tie_in_flex_grid.flex_grid_line_status = 1 AND tie_in_flex_grid.sub_user_payee_id > 0 AND tie_in_flex_grid.sub_user_payee_id = -1 AND tie_in_flex_grid.sub_user_payee_id = #Trim(FORM.assigned_to_id)# AND tie_in_flex_grid.sub_user_payee_id IN (#Trim(FORM.assigned_to_id)#) GROUP BY use_assigned_to_id ORDER BY use_assigned_to_id SELECT use_assigned_to_id FROM qryGetMainPayeeIds UNION SELECT use_assigned_to_id FROM qryGetSubPayeeIds UNION SELECT use_assigned_to_id FROM qryGetFlexRoster UNION SELECT use_assigned_to_id FROM qryGetSubPayeeAssignments ORDER BY use_assigned_to_id SELECT payee_first_name, payee_last_name, payee_id FROM payee WHERE payee_id IN (#variables.activePayeeList#) ORDER BY payee_last_name, payee_first_name, payee_id The cap number is 2,000 time slots per report (that's a ton). Any value higher than that makes the system
work too hard. Currently you are requesting #variables.tempTotalNumberOfTimeSlots# time slots. We recommend that you either
shrink the range or up the number of seconds between time slots. There are no rules on how many different
reports you may pull, just a rule on how many time slots to show per report.
Use your back button and try again."> SELECT assigned_to_id, color_value, element_end_time, temp_end_time, temp_end_time_2, element_start_date, element_start_time, temp_start_time, temp_start_time_2, end_dates_closed, time_id, assignedToPerson FROM retMainTime_st.qryGetTimeElements WHERE assigned_to_id = 1 AND time_template_id <> #variables.useRosterList# ORDER BY assignedToPerson, element_start_date, element_start_time, time_id SELECT * FROM retMainTime_st.qryGetTimeElements WHERE assigned_to_id = #variables.currentId# ORDER BY element_start_date, element_start_time, time_id SELECT * FROM retMainTime_st.qryGetTimeElements WHERE assigned_to_id = #variables.currentId# AND temp_start_time_2 < #variables.use_starting_time_as_number# ORDER BY element_start_date, element_start_time, time_id SELECT * FROM retMainTime_st.qryGetTimeElements WHERE assigned_to_id = #variables.currentId# AND temp_end_time_2 > #variables.use_ending_time_as_number# AND end_dates_closed = 1 ORDER BY element_start_date, element_start_time, time_id SELECT * FROM retMainTime_st.qryGetTimeElements WHERE assigned_to_id = #variables.currentId# AND temp_start_time_2 < #variables.use_starting_time_as_number# AND temp_end_time_2 > #variables.use_ending_time_as_number# AND end_dates_closed = 1 ORDER BY element_start_date, element_start_time, time_id SELECT * FROM retMainTime_st.qryGetTimeElements WHERE assigned_to_id = #variables.currentId# AND temp_start_time_2 < #variables.use_starting_time_as_number# AND temp_end_time_2 <= #variables.use_ending_time_as_number# AND end_dates_closed = 1 ORDER BY element_start_date, element_start_time, time_id SELECT * FROM retSubDates_st.qryGetSubDates WHERE assigned_to_id = #variables.currentId# ORDER BY sub_start_date, sub_start_time, time_id SELECT * FROM retSubDates_st.qryGetSubDates WHERE assigned_to_id = #variables.currentId# AND temp_sub_start_time_2 < #variables.use_starting_time_as_number# ORDER BY sub_start_date, sub_start_time, time_id SELECT * FROM retSubDates_st.qryGetSubDates WHERE assigned_to_id = #variables.currentId# AND temp_sub_end_time_2 > #variables.use_ending_time_as_number# AND sub_end_dates_closed = 1 ORDER BY sub_start_date, sub_start_time, time_id SELECT * FROM retSubDates_st.qryGetSubDates WHERE assigned_to_id = #variables.currentId# AND temp_sub_start_time_2 < #variables.use_starting_time_as_number# AND temp_sub_end_time_2 > #variables.use_ending_time_as_number# AND sub_end_dates_closed = 1 ORDER BY sub_start_date, sub_start_time, time_id SELECT * FROM retSubDates_st.qryGetSubDates WHERE assigned_to_id = #variables.currentId# AND temp_sub_start_time_2 < #variables.use_starting_time_as_number# AND temp_sub_end_time_2 <= #variables.use_ending_time_as_number# AND sub_end_dates_closed = 1 ORDER BY sub_start_date, sub_start_time, time_id SELECT * FROM qryGetSubPayeeAssignments WHERE use_assigned_to_id = #variables.currentId# ORDER BY element_start_date, element_start_time, time_id SELECT * FROM qryGetSubPayeeAssignments WHERE use_assigned_to_id = #variables.currentId# AND temp_start_time_2 < #variables.use_starting_time_as_number# ORDER BY element_start_date, element_start_time, time_id SELECT * FROM qryGetSubPayeeAssignments WHERE use_assigned_to_id = #variables.currentId# AND temp_end_time_2 > #variables.use_ending_time_as_number# AND end_dates_closed = 1 ORDER BY element_start_date, element_start_time, time_id SELECT * FROM qryGetSubPayeeAssignments WHERE use_assigned_to_id = #variables.currentId# AND temp_start_time_2 < #variables.use_starting_time_as_number# AND temp_end_time_2 > #variables.use_ending_time_as_number# AND end_dates_closed = 1 ORDER BY element_start_date, element_start_time, time_id SELECT * FROM qryGetSubPayeeAssignments WHERE use_assigned_to_id = #variables.currentId# AND temp_start_time_2 < #variables.use_starting_time_as_number# AND temp_end_time_2 <= #variables.use_ending_time_as_number# AND end_dates_closed = 1 ORDER BY element_start_date, element_start_time, time_id SELECT * FROM qryGetMain WHERE 0 = 0 AND ((temp_start_time_2 >= #variables.temp_time# AND temp_start_time_2 < #variables.temp_next_time# AND temp_end_time_2 <= #variables.use_ending_time_as_number#) OR (temp_start_time_2 >= #variables.temp_time# AND temp_start_time_2 < #variables.temp_next_time# AND temp_end_time_2 >= #variables.use_ending_time_as_number#)) AND temp_start_time_2 >= #variables.temp_time# AND temp_start_time_2 < #variables.temp_next_time# AND temp_end_time_2 <= #variables.use_ending_time_as_number# ORDER BY element_start_time, time_id SELECT * FROM qryGetReoccurring WHERE 0 = 0 AND ((temp_sub_start_time_2 >= #variables.temp_time# AND temp_sub_start_time_2 < #variables.temp_next_time# AND temp_sub_end_time_2 <= #variables.use_ending_time_as_number#) OR (temp_sub_start_time_2 >= #variables.temp_time# AND temp_sub_start_time_2 < #variables.temp_next_time# AND temp_sub_end_time_2 >= #variables.use_ending_time_as_number#)) AND temp_sub_start_time_2 >= #variables.temp_time# AND temp_sub_start_time_2 < #variables.temp_next_time# AND temp_sub_end_time_2 <= #variables.use_ending_time_as_number# ORDER BY sub_start_time, time_id SELECT * FROM qryGetExtraMain WHERE 0 = 0 AND ((temp_start_time_2 >= #variables.temp_time# AND temp_start_time_2 < #variables.temp_next_time# AND temp_end_time_2 <= #variables.use_ending_time_as_number#) OR (temp_start_time_2 >= #variables.temp_time# AND temp_start_time_2 < #variables.temp_next_time# AND temp_end_time_2 >= #variables.use_ending_time_as_number#)) AND temp_start_time_2 >= #variables.temp_time# AND temp_start_time_2 < #variables.temp_next_time# AND temp_end_time_2 <= #variables.use_ending_time_as_number# ORDER BY element_start_time, time_id #variables.pageTitle#
Successfully signed in at #URL.message#
Page Settings
Use Date:
(enter the day you want to see)
Time Start/Stop Range:
to (Ex: 6:00 am to 8:00 pm)
Time Slot Block Size:
Template Filter:
[show all elements of time]
Color Code:
Assigned To:
All Unassigned Plus Any Assigned To Me
 

Unassigned Horizontal Time Slots - #FORM.use_date# - Records (#ArrayLen(variables.masterRowArray)#)
Instructor:   #variables.useTimeBlocks_array[h]#  
Unassigned Assign Instructor #variables.masterRowArray[m].temp_assigned_to# #variables.masterRowArray[m].temp_assigned_to# «  
+  
»  


Instructor Assignments - #FORM.use_date# - Records (#qryGetUnionPayeeNames.RecordCount#)
Instructor:   #variables.useTimeBlocks_array[h]#  
#variables.masterLesson_array[j].name# #variables.masterLesson_array[j].name# « «     + » »