New call-to-action
Results 1 to 2 of 2

Thread: Creating a UX to Define Payroll Periods

  1. #1
    Member Stephen Schell's Avatar
    Real Name
    Stephen Schell
    Join Date
    Nov 2006
    Woodstock, Ontario

    Default Creating a UX to Define Payroll Periods


    I am creating a UX to define Payroll Periods in a MYSQL table.

    I have defined the following fields:

    Payroll_Year (N) (A 4 digit number that is the year the pay is deposited to the employee's bank account.)
    Payroll_Period (N) (values such as 1 to 52 defining each payroll period of the year)
    Payroll_ Year_PAY_Period (N) (a calculated field which is Payroll_Year *100 + Payroll_Period. This is used as a control to ensure that each pay period is unique. An example might be 201501 for the first pay period in 2015.)
    Payroll_Start_Date (D) (First Date of Payroll Period)
    Payroll_Pay_Date (Date the employees get their money deposited to their bank accounts. This is a calculated date based on the length of the payroll period (7 or 14 days) plus the days after the pay period ends until money flows into the employees bank account.)

    Each record represents a pay period in the pay year

    I have 2 questions
    1. Is this a good approach to this type of problem? Is there a better way to track this?

    2. If so, how do I calculate the value of Pay_Period? It would need to increment up by 1 for each pay period in the current year. When the Payroll_Pay_Date trips into the next year, PayRoll_Year would increase by one and Pay_Period would revert back to a value of 1. The process would then repeat for the new year.

    Any help would be appreciated.

  2. #2
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001

    Default Re: Creating a UX to Define Payroll Periods

    Hi Stephen,

    I realize it's been a while since you posted this.
    Have you reached a final solution?

    I have a couple clients that pay every 2 weeks, and to make things more fun, their pay period starts on Saturday, and they hold back 2 weeks.
    I created this little utility to help their payroll department and employees determine payroll information.
    If you want to take a look, , let me know if this is something could help.


Similar Threads

  1. Update tables for specific time periods
    By Amin in forum QReportBuilder
    Replies: 4
    Last Post: 10-09-2008, 07:30 PM
  2. Payroll??
    By wsrcd in forum QReportBuilder
    Replies: 4
    Last Post: 05-28-2008, 12:43 PM
  3. Posting Time Periods
    By John Dodson in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-08-2006, 12:14 PM
  4. Payroll
    By John Nelson in forum Alpha Five Version 5
    Replies: 3
    Last Post: 03-05-2004, 11:21 AM
  5. Lost periods on export
    By A. R. Sale in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-20-2002, 05:22 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts