PES_TimesheetDetailsPending

This table contains data for every timesheet entry in the system.

Column	Data Type	Description
tsl_UID	int	A unique identifier. Every record in the table has a unique ID. This value associates a timesheet entry with the PES_Timesheet LineItem.
tsl_Date	smalldatetime	This is the date of an entry.
tsl_Hours	float	This is the number of hours for an entry.

A record exists for every timesheet entry in the system. If you do not use timesheet details, you can access this table directly. If you need access to detail items, you will need to use a macro.

MACRO: PES_MACRO_ TIMESHEET_DETAIL_PENDING. For example:

SELECT * FROM PES_TimesheetDetailsPending
WHERE (tsl_Date > '1/01/2006')
AND (tsl_Date < '12/31/2006')

The macro uses slightly different field names. The tdl_Duration corresponds to the tsl_Hours and the tdl_Day corresponds to the tsl_Date in the above table. For example (using the macro):

SELECT * FROM PES_MACRO_TIMESHEET_DETAIL_PENDING(tdpm, tdl_Day >= '1/01/2006'
AND tdl_Day <= '12/31/2006', tdl_Duration,tdl_Day,Description