• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Corelating Requisitions and Personel Actions

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
topher21
New Member Send Private Message
Posts: 0
New Member
12/11/2007 5:52 PM
I'm using Crystal Reports XI R1 with a regular ODBC connection and am trying to report on promotions for a set period of time and would like to try and find out (via PAJOBREQ) how many of the promotions were replacing existing headcount. I'm having the darndest time linking through between the two tables. Any suggestions in terms of structure/link type?
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
12/11/2007 8:06 PM
What table are you trying to link to PAJOBREQ?
topher21
New Member Send Private Message
Posts: 0
New Member
12/11/2007 8:14 PM
Ultimately, I'd like to get back to PERSACTHST
John Henley
Send Private Message
Posts: 3351
12/11/2007 8:21 PM
I'm not sure you're going to be able to guarantee an exact match/logic.
You can try going from PAJOBREQ to PAREQOFFER first. That will get you the applicant->employee link.
From there you can go to PERSACTHST and isolate the hire actions your company uses, etc. and probably get a good match.
Thanks for using the LawsonGuru.com forums!
John