 | 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 [5213 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 Support@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. |