Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Service Date

Sort:
You are not authorized to post a reply.
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
    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
          You are not authorized to post a reply.