CSV Reports - including blank columns

 1 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Chris G
New Member
Posts: 1
New Member
    Let me open by saying, I do not have direct access to a Lawson system - I am supporting users of another system that relies on getting data from Lawson HR/Payroll for regular employee updates.
    My purpose for posting is so that I can obtain the data needed to communicate better with my customers, and help them get the information they need more quickly.

    The system I work with makes use of employee demographics (ID's, Name, Employ Date, Separation Date, Home address, Phone, and then fields like work location, department, job title, job class, etc.)

    I would:
     A - like to understand how this information is put into a report, that can later extract to a CSV
     B - like to know how I might insert blank columns, if the HR/Payroll (data entry form layout) doesn't include a certain field.

    Example:  ID,Name, Date Hired, Date Separated, DRIVERS LICENSE NUMBER, Home address, Home Phone, Department, Job Title, MARITAL STATUS
    (Items in BOLD are not available fields in my Lawson system (for example))

    How can I create a report, and how can the report include the COLUMNS for the information I don't have (as a placeholder).

    Thank you for this group, I'm sure I'll get the help I'm looking for.

    Paul Berkowitz
    Basic Member
    Posts: 14
    Basic Member
      Chris,
      The fields you are looking for are in the following table : employee , paemployee, DRIVERS LICENSE NUMBER is stored in Empcodes where code = "DL", JOB_CODE, DEPTCODE (name of the Department)
      MARITAL STATUS is in paemployee as TRUE_MAR_STAT, postion description is in PAPOSITIONs. Question, can an employee have multiple positions at the same time in the organization. If yes
      you need paemppos

      Vvarious tools can be used by the person gathering the data that has access to the HR Tables. My preferred method is writing sql code so I control insert blank columns as needed.

      let me know if you need more