DAVE_TIME_SCAN_REC_TOTAL Function

To get the time total for the requested date range, use the DAVE time scan record total function.

Parameters

Parameter	Data Type	Comments
rpt_rs_key	TEXT	The row set key provided as an output by the DAVE_TIME_SCAN_SET function.
is_use_day_type	TEXT	Indicate whether the day total should use the reported time card date, overtime date, or earned date. Valid values: Y, REFERENCE, OVERTIME: Use reference date or overtime days N, TIMECARD, or leave blank: Use time card date EARNED: Use Earned date
start_date	DATE	Start date for the period total (optional). Both the start and end dates are required for a specific period total, otherwise the total returns the row set period total.
stop_date	DATE	End date for the period total (optional). Both the start and end dates are required for a specific period total, otherwise the total returns the row set period total.

Outputs

Output	Data Type	Comments
status	TEXT	Request status, possible values are: 'N0_REC_FOUND' 'SUCCESS' 'FAILED'
status_log	TEXT	The log file containing detailed information related to the 'FAILED' status and corresponding process data.
measure	NUMBER	The summed time totals for the date range specified by the start and end dates.