Company: Link Technologies
Case No: L12390
Logged By: Sanjay (Link Technologies) on 05 Sep 2011 04:18PM
Priority: Not Applicable
Product: Other
Group: To be assigned
Time Taken: 0.00
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Monday, 05 September 2011 04:18 PM [4616 days since logged date]
Status: Closed
Subject: Reprocessing bio-metric missing time entries
Summary:    
Steps to reprocess bio-metric missing time entries:
1. Clear the time log staging and archive data from the date specified.
--This script will delete the time log and timesheet data
DECLARE @date DATETIME = '2011-01-13' --Change this date to the date you wish to reprocess missing time entries.
DELETE FROM PR_TIMELOG_ARCHIVE WHERE [WORK_DATE] >= @date
DELETE FROM PR_TIMELOG_HD_ARCHIVE WHERE [WORK_DATE] >= @date
DELETE FROM PR_TIMELOG_STAGING WHERE [WORK_DATE] >= @date
DELETE FROM PR_TIMELOG_HD_STAGING WHERE [WORK_DATE] >= @date
DELETE FROM PR_EMP_TIMESHEET WHERE [DATE] >= @date

2. Move all handtime data files from the date specified to time entry PENDING folder
3. Run the ProcessTimesheet.bat batch file to process files from PENDING folder

Audit Notes:
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12390 in the subject line of all emails regarding this issue.

Document size: 0.9 KB
For call complaints, please contact the Managing Director of the company using this form