To extract data from Human Resource Writer reports in CSV format using the inquiry tool

  1. Access Human Resource Writer Inquiry (HR70.1).
  2. Enter the appropriate parameters for the report. Use the following guidelines to enter field values:
    Suppress Individual

    Select whether or not to suppress printing an individual record if no qualified detail information is found for that individual. The value you enter in this field overrides the value selected in the Suppress Individual field on Human Resource Writer Detail Criteria (HR65.8).

    Select X to print only individuals for whom no detail is found. For example, you might use X to list all individuals for whom a deduction for union dues was not taken.

    Company

    Select the company on which you want to inquire. The company you select in this field overrides a company defined on Human Resource Writer Population Selection (HR65.5).

    Employee or Applicant

    You can specify a range of employees or applicants to include in the inquiry.

  3. Process the inquiry by choosing OK or pressing Enter. Human Resource Writer Inquiry Window (HR70.2) will appear and present the report's output.
  4. Click CSV Export at the bottom of the form. Human Resource Writer Inquiry Window (HR70.3) will appear and list the headings of all columns included in the report. At this point, you can elect to extract CSV data from all columns, or just for selected ones.
  5. Process the extraction by choosing OK or pressing Enter. The message "Export Complete" will appear and the location of the file on the Lawson server will be displayed after the "File Is:" label. An example of the location message is "File Is: /apps/print/john/47344/1", where john is the user name for the creator of the report, and 47344 is the number assigned by Lawson. This sample path would indicate that the CSV data has been created as a file named "1" that resides in the path "/apps/print/john/47344".