Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Allan Cerrudo
  Where is Allan Cerrudo?
 Las Pinas City
 Philippines
 Allan Cerrudo
 To: BZ Dusk
  
 
 
 BZ Dusk
 Tags
Subject: RE: What about this..+ question for Mr. Rene also
Thread ID: 34012 Message ID: 34100 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Projects and Design
Date: Tuesday, December 09, 2003 3:49:30 AM         
   


> >
> > > Is it possible to have a table for this list for user to choose from during data entry on Calendar file Mr. Rene told me? (The table will be some sort of formula table?)
> >
> > yes u can. i think u should assign codes for each holiday or premium and when u assign a date in the calendar file to be a holiday, it should correspond to the list of holidays existing in your table. then it'll call for the formula. but on my case i havent use a calendar file. i just used a table recording the percentage part of the formula for each holiday because all of these has common factor (regular wage) and do the computation thru coding. but u could also save the whole formula in this table so that it is modifiable.
> >
> > > How can I determine that such employee must fall under what rule?
> >
> > i think in that case, your employee table must have a field specifying which group the employee belongs to which rule #.
> >
> >
> >
> > -Lucy Alice
> > "I love this foXITE!"
>
> Hi again!
>
> What if I don't want it pre-defined in the calendar file? What I mean is, I want to have a formula table based on the list I stated then just automatically locate what rule will apply "during" payroll processing.
>
> Example: Employee A worked on Regular holiday and worked overtime also. Now during payroll processing, it will just automatically locate what rule.
>

According to my experience ... I Classify the days into

Regular Day
Rest Day
Legal Hol
Spcl Hol
RestDay fall on Legal Hol
Restday fall on Spcl Hol

then divide each day ...
1. Regular Day 1st 8 hr (not an OT)

2. Regular Day OT (beyond 8 hrs)

3. RestDay 1st 8 hr
4. RestDay OT (beyond 8 hrs)

5. Legal Hol 1st 8 hr
6. Legal Hol OT (beyond 8 hr)

7. Spcl Hol 1st 8 hr
8. Spcl Hol OT (beyond 8 hr)

9. RD on LH 1st hr
10 RD on LH beyond 8hr

11. RD on SH
12.RD on SH beyond 8hr

In your timekeeping system... you can have 12 fields.

In your payroll system...

Define 12 rates hard coded or in table

1. 100 % of Rate per Hour
2. 125 % of Rate per Hour
..
..

Allan
Cetorn




ENTIRE THREAD

Holiday/Overtime/Restday rates (Payroll system) Posted by BZ Dusk @ 12/6/2003 7:10:55 AM
Let us share our experiences with you, live! Posted by Rene Relucio @ 12/6/2003 8:56:24 AM
Pls share them even if i was not able to attend... Posted by BZ Dusk @ 12/6/2003 5:57:47 PM
RE: Pls share them even if i was not able to at... Posted by Rene Relucio @ 12/8/2003 3:57:46 AM
What about this...... Posted by BZ Dusk @ 12/8/2003 4:28:57 AM
RE: What about this...... Posted by Lucy Alice Pilanga @ 12/8/2003 4:42:41 AM
RE: What about this..+ question for Mr. Rene also Posted by BZ Dusk @ 12/8/2003 5:03:10 AM
RE: What about this..+ question for Mr. Rene also Posted by BZ Dusk @ 12/8/2003 5:23:12 AM
RE: What about this..+ question for Mr. Rene also Posted by Lucy Alice Pilanga @ 12/8/2003 6:08:26 AM
RE: What about this..+ question for Mr. Rene also Posted by BZ Dusk @ 12/8/2003 5:48:31 PM
RE: What about this..+ question for Mr. Rene also Posted by Lucy Alice Pilanga @ 12/9/2003 3:31:48 AM
RE: What about this..+ question for Mr. Rene also Posted by Allan Cerrudo @ 12/9/2003 3:49:30 AM
RE: What about this..+ question for Mr. Rene also Posted by BZ Dusk @ 12/10/2003 8:20:26 AM