Re: Payroll

Payment is on monthly attendance basis,
full day or half day attendance absence can be marked
Casula leave -6, Sick Leave-6 & Paid Leave -30 will be provided
leave taken in exess of above will be dedcuted from salary (loss of pay)

Leave under each of above head will be credited to respective A/c only at
the end of calender year ie 31st December. Employee can carry forward PL up
to 180 days , Sick leave up to 15 days, Casual leave cannot be caarried
forward.

Payheadmaster table stores pay details as per appoitnment order
Structure
ID (PK), EmployeeCode (FK), Basic, Da, & other pay heads including
profession tax and other deductions

at present one LOP (loss of pay days) field is provided in above table and
no of days leave to be deducted updated in that field and pay head under
each head is worked.

There will be defferent profession tax applicable for defferecent states.
Profession tax slab is pre defined and can be called for each branch or
employee wise also

There will be 3-4 grades in basic salary and modification in salary master
will happen April month of every year

Apart from monthly salary following will be paid occationally
Paid leave encashment,Leave Travel allowance, Medical expenses
reimburshment(non taxable), statutory bonus, performacne incentives, all of
above must be added total yearly salary . Our financila year is April to
March

Hope I have provided all the required information

Please guide me

Ramesh

"Fred" <Fred@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F58B28A0-A098-456A-B489-7EFEC9188B74@xxxxxxxxxxxxxxxx
A core question is: what level of detail is going into the DB? For
example:

- punch-in and punch-out times from time clocks. (e.g. Access is doing
the
hours calculations)
- total hours, holidays, sick days etc.
- just pay for the pay period.

Also could yu clarify what your payheadmaster table is?


"SHETTY" wrote:

Dear Friends

I am planning to design a database for maintaing payroll information. At
present i am using database where in I am unable to maintain historic
data
like details of previous months. I have payheadmaster and employee master
table. Reports and payslips are generated through querries from master
table itself. data changes will be made in master table itself

Can anyone guide me how to create a database where in I can
maintain/store a
data for elapsed previous months also. Report for any given period. There
will not be major changes in the payhead and employee data month after
month
, changes may be to the extent of 2%
So I think it may not be good design if a store salary releated
information
for everymonth and every employee. Is there any other way where I can
list
only the changes in pay head data

thanks

Ramesh





.

Relevant Pages

  • Re: Payroll
    ... would be to do it without using any database implementation terminology. ... The update to pay table will be based on the attendance leave status etc. ... It sounds like payheadmaster has one record per employee or may actually ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Payroll
    ... It sounds like payheadmaster has one record per employee or may actually be ... It souds like your pay and pay records are a once-per month summary. ... There will be 3-4 grades in basic salary and modification in salary master ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Payroll
    ... The update to pay table will be based on the attendance leave status etc. ... It sounds like payheadmaster has one record per employee or may actually ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Pay roll coding
    ... employee master -record of all employees ... As i told there will be slight changes in the pay heads ... proportionatelty fro each pay head associated with that employee ...
    (microsoft.public.access.modulesdaovba)
  • Re: Lorong 29 Qigong Gossips - True or Not??
    ... Real politician does not run away to funkhole downunder ... I used to learn Meditation 25 years ago, from Master Wong ... Sadly there is this S. P. Huat who make you pay n pay for every new stuff ... could break bricks and wooden sticks with qi after 4 weeks. ...
    (soc.culture.singapore)
Loading