• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Service Date

 3 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
Rirruto
New Member
Posts: 4
New Member
3/15/2013 4:29 PM
Good Afternoon,

I am trying to get the date in which an employee entered their current position, whether it be through a transfer or if they were hired into the position. The date can be seen in PA10.1 Length of Service and is called Service Date. I cannot click on it to find out what table and field I can find it in through Crystal. Can anyone help?

http://img.photobucket.com/albums/v233/Rirruto/image001_zps7e1e0008.png
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
3/15/2013 5:05 PM
CTRL-SHIFT-O will give you the table/field for the field. Check PAEMPPOS. Either START_DATE or BEGIN_DATE...can't remember which name is used in this table but there will only be of those two.
Georgette
Veteran Member
Posts: 52
Veteran Member
3/15/2013 5:42 PM
In LID, run the following command to query on programs.

dburf PROD PA PA10 |lashow

dburf PROD HR HR11 |lashow

Or the following command queries the tables:

dbdoc PROD PA PAEMPPOS |lashow
dbdoc PROD HR EMPLOYEE |lashow

(PROD is the name of our product line, yours may be called something different)

PA10 is a display for values in HR11 (which is the EMPLOYEE table). There are a lot of date fields in the EMPLOYEE table, depending if your organization populates those date fields each time an employee moves to another job/position.
Rirruto
New Member
Posts: 4
New Member
3/15/2013 6:50 PM
Thanks for the replies, I found what I was looking for in table HRHISTORY, FIELD NUMBER 126, HRHISTORY.BEG_DATE