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. |