Paul Mayer
09-14-2006, 12:17 AM
A number of software developers that have created back office applications that collect time such as time clocks have asked how to interface with PayWindow to post the hours each week to the database.
Our database files are Microsoft Access databases and if you can program your application to poke data into an Access database, then you can do this. The full layout of the database can be found here http://zpay.com/downloads/paywindow-database-manual.pdf.
We use the file extension of "dxi" so our customers do not open random "mdb" files on their computer.
The Table in company database you will access is: dbMainEmployee
The sEmpCode data field is a a text item that is the employee ID. You would use this to match your data with the employee ID that you want to post to.
Data fields to post your "total" hours to in the dbMainEmployee table are:
Department 1 (normal for most companies would just be this department):
fHourRegular - Regular pay hours
fHourOvertime1 - Overtime rate one hours
fHourOvertime2 - Overtime rate two hours
We allow up to five different departments and pay rates so the next four sets would be used for each department.
Department 2:
fHourRegular2
fHourOvertime3
fHourOvertime4
Department 3:
fHourRegular3
fHourOvertime5
fHourOvertime6
Department 4:
fHourRegular4
fHourOvertime7
fHourOvertime8
Department 5:
fHourRegular5
fHourOvertime9
fHourOvertime10
And the last three hour entries are sick hours, vacation hours and holiday hours.
FHourSick
fHourVacation
fHourHoliday
And finally we have the data field for total commissions to be paid to an employee.
fCommission
Our database files are Microsoft Access databases and if you can program your application to poke data into an Access database, then you can do this. The full layout of the database can be found here http://zpay.com/downloads/paywindow-database-manual.pdf.
We use the file extension of "dxi" so our customers do not open random "mdb" files on their computer.
The Table in company database you will access is: dbMainEmployee
The sEmpCode data field is a a text item that is the employee ID. You would use this to match your data with the employee ID that you want to post to.
Data fields to post your "total" hours to in the dbMainEmployee table are:
Department 1 (normal for most companies would just be this department):
fHourRegular - Regular pay hours
fHourOvertime1 - Overtime rate one hours
fHourOvertime2 - Overtime rate two hours
We allow up to five different departments and pay rates so the next four sets would be used for each department.
Department 2:
fHourRegular2
fHourOvertime3
fHourOvertime4
Department 3:
fHourRegular3
fHourOvertime5
fHourOvertime6
Department 4:
fHourRegular4
fHourOvertime7
fHourOvertime8
Department 5:
fHourRegular5
fHourOvertime9
fHourOvertime10
And the last three hour entries are sick hours, vacation hours and holiday hours.
FHourSick
fHourVacation
fHourHoliday
And finally we have the data field for total commissions to be paid to an employee.
fCommission