Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: BZ Dusk
  
 
 
 BZ Dusk
 To: BZ Dusk
  
 
 
 BZ Dusk
 Tags
Subject: RE: What about this..+ question for Mr. Rene also
Thread ID: 34012 Message ID: 34058 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Projects and Design
Date: Monday, December 08, 2003 5:23:12 AM         
   


Hi!

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?)

1. Regular holiday - 250% of regular wage
2. Regular holiday with OT - 250%+50% ot premium
3. Regular holiday and restday - 250% of regular wage
4. Regular holiday and restday with OT - 250%+50%
5. Rest day or special holiday - 150% of regular wage
6. Rest day and special holiday - 150% of regular wage
7. OT on regular day - 150% of regular wage
8. Night premium - 115% of regular wage

Mr. Rene what do you mean by:

"...each date are tagged with a certain coding scheme using a field that will help in determing some sort of calculation"

Also, please look at rule no. 4 - If the regular holiday falls on employee's restday and he works on that particular day and also had OT, the formula is 250% regular wage+ 50% ot premium.

Rule nos 5&6: no difference.

Therefore I cannot simply say that the rate of regular holiday is A, while special is B, ot is C, rest day is D.

How can I determine that such employee must fall under what rule?


Thanks in advance.



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