Knowledgebase
TimeTrack support > TimeTrack support > Knowledgebase

Search help:


Dual Database

Solution

DUAL Database

For estimation purposes or to simulate a flexibile shift scenario Dual Database option can be added. This option can

  • Simulate 2 shits of 12 hours to 3 shifts of 8 hours.
  • Add or deduct overtimes based on your rules
  • Simulate overtime for a percentage of employees daily for a fixed number of hours
  • etc etc

Please talk to us with your exact scenario and we would be providing you the appropriate solution for you to build up your estimates.

 

  • DTime.set
    • The DTime.set file contains 6 characters. 030015.
    • This means the inpunches in dual will be within 30 mts of shift start and the out punches will be within 15 mts of shit end
    • Shift starts at 08.00. All punches before  7.30 would be randomly changed to   7.30 to  8.00 slab
    • Shift ends   at 16.00. All punches after  16.15 would be randomly changed to  16.00 to 16.15 slab
  • DTimeOT.set
    • The DTimeOT.set file contains 6 characters. 000120.
    • This means that OT prior to Shift Start is not applicable. OT can be maximum 2 hours (120 mts) after Shift Ends.
    • This works with DTime.set
    • Shift starts at 08.00. All punches before  7.30 would be randomly changed to   7.30 to  8.00 slab
    • Shift ends   at 16.00. All punches after  18.15 would be randomly changed to  18.00 to 18.15 slab
  • DOffOTYes.set
    • Actual OT on Offdays would be available in Dual
  • DHolOTYes.set
    • Actual OT on Holidays would be available in Dual
  • 3ShiftD.set (updated on 29/08/2012)
    • Converts two numbers of 12 hour shifts to 3 numbers 8 hour shifts.
    • Shifts have to AA and BB in Admin mode
    • CC Shift has to be added to dual mode
    • Auto shift has to be enabled in dual mode.
    • AA,BB & CC shift has to be made as an applicable auto shift in dual mode
    • No need to update the muster in dual
    • Other shifts are not dual processed and actual punches are taken to dual

How to Test the software

  • Login as Admin
  • Add all employess
  • Do shift Assignemnts, shift rotation etc. 
  • Create a new user named Root. (or any other name not starting with 'o')
  • Delete the database TimeTrackD and AttendanceD
  • Copy TimeTrack.mdb as TimeTrackD.mdb
  • Copy Attendance.mdb as AttendanceD.mdb
  • Login as  Root
  • Adjust the shit timings are per your wish
  • Logout and login as Admin
  • Go to Punch entry menu and enter manual punches or receive data from text file/reader.
  • The actual data can be seen in Admin login and the data as per your DTime setting can be seen in Temp Login

 

KEY WORDS: Dual, DualDatabase, Dual-Database

 

 
Was this article helpful? yes / no
Related articles Auto Shift
Shift Import
Software Slow
Article details
Article ID: 16
Category: Dual Database
Date added: 31/08/2012 08:27:07
Views: 677
Rating (Votes): Article rated 3.5/5.0 (8)

 
« Go back