Re: [SL] Payroll (Draft DB Schema for US)

[Chris T. <ch...@me...>]

I have designed something that amost fits what you are talking about.  
See the attachment for more info.

Vicki Reeves wrote:

> I'm thinking that an international payroll might be possible if it 
> included lots of ways to adjust withholdings.
>
> For example, choices for each withholding might include:
> * will this formula operate against gross (stage 1) or against 'almost 
> net' which would be the total after all stage 1 adjustments are 
> completed?

Yes-- the before_tax flag can be used for this purpose.  This is 
primarily a US centric thing though (my implimentatation, that is).

>
> * will this withholding be a percentage, a set amount or a user 
> defined formula? User defined formulas could allow for things like 
> ((gross - 241) * 0.125)
>
Formulas are not really supported.  For custom formulas, I suggest using 
stored procedures as I am doing in this example for federal income taxes 
(US).

> * is this withholding applied every payperiod or event triggered? 
> Perhaps this could be used to allow for once a month withholdings when 
> the payroll is prepared weekly, etc.
>
Not supported at all in this draft.  Not sure what the applications are, 
but would be really easy to add if necessary.

> * what will be the title of this withholding?
>
Supported.  Also, is this globally appropriate (i.e. affects everyone) 
or per employee.
Eventually may need to make this country specific and add something into 
the employee table to handle it.

> * to what vendor and account will this withholding relate?
>
Good point, had forgotten about vendor.  Will add this.

> Since the withholdings are very flexable and you would be able to 
> setup as many as necessary, this should take care of the tax type 
> requirements of wherever and allow for things like garnishments, 
> insurance, etc.

supported globally and per employee.

>
> Something similar could be used to allow for additions such as 
> payments of child care allowances, commissions, etc.

Allowances might have to be handled differetly.  Anyway, this rough 
draft only handles payroll witholding and not the calculation of the 
gross ammt.  I would suggest offering separate checks for tax-free 
benefits, though if these are kept as a per-employee balance, it is not 
a problem.

This system uses wage bracket percentage-method for calculating the 
federal income tax witholdings and does not include the tax tables.   It 
is just a set of ideas at this point...

Best Wishes,
Chris Travers