Title: Holy Cow!
Description: PAYRATEHIST table
Mil0n023 - November 13, 2006 06:49 PM (GMT)
I am running an extract via crystal reports to give me an employees Benefit coverage annually.
Problem is - I have to use the PAYRATEHIST.Pay_Rate field, and we have 3 records where their pay rate is $585,858,585.8585 !!
I am doing the NthLargets N =1 for the Employee Pay Rate and calculating of this - but, with this huge amount somewhere in the application it is calculating of that number! How can I get rid/around this?
cjmart - November 13, 2006 07:26 PM (GMT)
PRRATEHIST is going to give you the pay rate history. Sounds like you just need the current pay rate, so I'm not sure I understand why you aren't pulling this from the EMPLOYEE table. Having said that, I can't think of a reason why you wouldn't be able to use PRRATEHIST, it just adds a level of complexity to the report in trying to isolate the current rate.
As far as the $585,858,585.8585 pay rate, sounds like someone in HR needs to review the employee(s)' records and fix their pay rate.
schroncd - November 13, 2006 07:31 PM (GMT)
Ummm... Uhhh.. Do you guys have any openings for a REALLY well seasoned Lawson Admin? With Pay Rates like that I could be convinced to come in off the road!
Mil0n023 - November 13, 2006 07:56 PM (GMT)
Actually i was trying to pull current from the EMPLOYEE table but a lot of the employee records did not have a pay rate. That is, HR11 shows the pay rate, but when I used that field from the EMPLOYEE table it wasn't showing up?
Very odd.
SAH - November 13, 2006 08:50 PM (GMT)
Are the employees without rates on your report on step and grade schedules? You may want to consider querying the pro-rated salary field (or total pro-rated salary if you have multiple positions with rates) instead of the rate field. And I've the issue with the 585858585 salary previously - I can't find what it relates to though! I'll keep looking for that one - good luck :nix:
KarenPloof - November 13, 2006 10:11 PM (GMT)
If you're using step and grade schedules and want the actual pay rate, it is stored in PAEMPPOS. That file includes all the information you would see on PA13.2, which means you could find many records for a single employee. You would have to select the record(s) with no end date.
Mil0n023 - November 13, 2006 11:06 PM (GMT)
I did a paint screen to delete the records.
I will look at the PAEMPPOS. Thanks,.