Reference → Data Dictionary → Instance Data Table Summary → PES_TimesheetDetailsPending
This table contains data for every timesheet entry in the system.
|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.
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
Copyright © 2003–2010 Serena Software, Inc. All rights reserved.