HR65.1 - HR Writer Title Creation The "HR Writer" consists of all the screens of HR65. Use HR65.1 (HR Writer Title Creation) to create inquiries or reports using employee and applicant data from the Lawson Human Resources, Personnel, Payroll, Benefits, Time Accrual, and Time and Attendance systems. The HR Writer consists of several setup screens that progressively narrow the scope of the data reported. You can define a report or inquiry in as little as two screens or as many as eight screens, each having several options. This gives you control of the simplicity or complexity of the report or inquiry. In addition to the setup done in this program, the HR Writer includes several run-time options for data selection and display in both HR70.1 (HR Writer Inquiry Request) and HR170 (HR Writer Report Request). TOPICS The data available to the HR Writer is organized by topics within types. The basic structure of a report or inquiry consists of Employee, History or Applicant type master topic(s) and one detail topic. A master topic consists of data items for which an employee or applicant has only one value. This is generally data from HR11.1 (Employee) or PA31.1 (Applicant). A detail topic consists of a set of related data items (usually from the same database file) for which an employee or applicant can have many values stored. For example, E1 (Employee Master) is a master topic because an employee is assigned only one process level, primary address, salary class, and so on, while PD (Payment Deductions) is a detail topic because an employee has many payments that include many deductions. Refer to the Human Resources Procedures Manual for a detailed explanation of each topic, including a list of included data items. Updated Files PWAUTHOR - Used to update the last title number. PWSELECT - When you delete a title, the corresponding records in this file are also deleted. PWTITLE - The primary file maintained by this program. PWTITLETOP - Used to display fields from the detail topic. Referenced Files PADICT2 - Used to create log records. PWSELECT - When you delete a title, the corresponding records in this file are also deleted. PWTOPIC - Used to validate the master topic. HR65.2 - HR Writer Format Item Selection Use HR65.2 (HR Writer Format Item Selection) to select the fields of data you want to include in the report or inquiry. Data items available for selection display in the Items To Select fields in the bottom half of the screen. Initially, the data items that display are based on the detail topic you select in HR65.1 (HR Writer Title Creation), or the first topic under the type defined for the report or inquiry. To select items from a different topic, select a different topic. To select the desired items, select screen function Add or Change, then select or type X next to the item(s) you want to select. You can select a maximum of 15 data items from different topics for each title. After you select the items and press OK, the items display as Selected Items in the top half of the screen. HR65.2 is the last screen required to define a report; the remaining screens are optional. Use HR65.3 (HR Writer Format Item Order) to organize the appearance of the report or inquiry, to reduce the length of a field, or to define summary totals. Use HR65.4 (HR Writer Print Order) to sort the data in an order other than employee, or applicant. Use HR65.5 (HR Writer Population Selection) and HR65.6 (HR Writer Population Criteria) to define criteria that determines the population of employees or applicants that display. Use HR65.7 (HR Writer Detail Selection) and HR65.8 (HR Writer Detail Criteria) if employee or applicant detail selection criteria are desired. Use HR67.1 (HR Writer Compute Statement) to define compute statements to use in HR Writer reports. Updated Files PWSELECT - When you delete a title, the corresponding records in this file are also deleted. PWTITLE - The primary file maintained by this program. PWTITLETOP - Updated by this program. Referenced Files HRUSERFLDS - Used to display fields. PADICT - Used to get data item information from the dictionary. PADICT2 - Used to get data item information from the dictionary. PWAUTHOR - Used to validate the author. PWCOMPUTE - Used to access user-defined compute statements. PWSELECT - When you delete a title, the corresponding records in this file are also deleted. PWTITLETOP - Updated by this program. PWTOPIC - Used to display fields from the master topic. HR65.3 - HR Writer Format Item Order Use HR65.3 (HR Writer Format Item Order) to organize the appearance of the report or inquiry, and to identify the numeric, non-date data items you want to total. The data items you select in HR65.2 (HR Writer Format Item Selection) display in the lower half of the screen with column numbers that are based on the order in which you selected them in HR65.2. To change the order in which they display on the report, change the column numbers. To remove an item from the report format, select screen function Change and clear the X next to the item you want to remove. Each time you make a change, the format line and the list of items display in the new order. In this screen you identify the numeric, non-date data items you want to total. For example, rate of pay. In HR65.4 (HR Writer Print Order) you identify the point at which you want the totals to print. For example, at the department level. The As of Date field lets you extract historical information based on the "as of" date rather than what is currently on the employee record (if different). If the employment date of an employee is after the "as of" date, the employee does not appear on the report. HR70.1 (HR Writer Inquiry Request) displays 70 characters. If an inquiry format line exceeds 70 characters, command buttons let you move the viewing area right or left to view the entire inquiry. HR170 (HR Writer Report Request) produces a report that prints up to 190 characters per line. Standard printers support 132 characters. Each report is one line across the top of the page with two spaces between columns. Each data item has a pre-determined size but you can reduce the width of a field to fit more fields on the report. Updated Files PWTITLE - The primary file maintained by this program. Referenced Files PADICT - Used to get data item information from the dictionary. PWAUTHOR - Used to validate the author. PWCOMPUTE - Used to access user-defined compute statements. HR65.4 - HR Writer Print Order Use HR65.4 (Print Order) to define a sort order and totaling options for the reports. You can choose to print a report in an order based on data items other than those printed on the report. For example, you can choose to print the report in process level or department order even if you do not select Process Level or Department in HR65.2 (HR Writer Format Item Selection) as fields to appear on the report. In HR65.3 (HR Writer Format Item Order) you identify the numeric, non-date data items you want to total. In HR65.4 you indicate the level at which you want the totals to print, for example, process level, location, employee, and so on. If you do not indicate a level at which to print the totals, no totals print on the report even though you selected a total option for the data item in HR65.3. Sort order applies to HR70.1 (HR Writer Inquiry Request) and HR170 (HR Writer Report Request). Totaling options apply only to HR170. Updated Files PWTITLE - The primary file updated by this program. Referenced Files HRUSERFLDS - Used to display fields. PADICT - Used to get data item information from the dictionary. PADICT2 - Used to get data item information from the dictionary. PWAUTHOR - Used to validate the author. PWTITLETOP - Used to validate the detail topic. PWTOPIC - Used to validate the master topic. HR65.5 - HR Writer Population Selection Use HR65.5 (HR Writer Population Selection) to define a specific population of employees or applicants that you want to include in the report or inquiry. The items you select to define the population may be different than the data items you choose to print on the report in HR65.2 (HR Writer Format Item Selection) or those you choose for sorting in HR65.4 (HR Writer Print Order). To define population, select data items from the list displayed on the bottom half of the screen. The data items that display are based on the topic selected in the Topic field. You can change the displayed items by selecting a different topic. The topics available for selection are based on the report type defined in HR65.1 (HR Writer Title Creation). To run the same report for a different population of individuals, you can override the company, and further define other selection criteria at run time in HR70.1 (HR Writer Inquiry Request) and HR170 (HR Writer Report Request). If you want to run a report for different combinations of parameters, you can leave this screen blank and define parameters in HR70.1 or HR170 at run time. After you select data items to define the population, use HR65.6 (HR Writer Population Criteria) to define criteria for the selected items. For example, if you select Rate of Pay as a population selection, use HR65.6 (HR Writer Population Criteria) to define the rate of pay. This can be a specific rate or a range of rates. Updated Files PWSELECT - Contains selection criteria. PWTITLE - The primary file updated by this program. Referenced Files HRUSERFLDS - Used to display fields. PADICT - Used to get data item information from the dictionary. PADICT2 - Used to get data item information from the dictionary. PWAUTHOR - Used to validate the author. PWSELECT - Contains selection criteria. PWTITLETOP - Used to validate the detail topic. PWTOPIC - Used to validate the master topic. HR65.6 - HR Writer Population Criteria Use HR65.6 (HR Writer Population Criteria) to define criteria for the data items you select in HR65.5 (HR Writer Population Selection) to determine the population included in the report or inquiry. The data items you select in HR65.5 display on the top half of the screen. You can then define Include or Exclude ranges and assign item groups to the items. Item groups with the same number identify sets of selection criteria for "and" conditions. That is, an individual must meet all the criteria for an item group to be included in the report. Item groups with different numbers identify sets of selection criteria for "or" conditions. That is, an employee must meet all criteria in at least one item group in order to be included in the report. Refer to the Human Resources Procedures Manual for more information on item groups. In HR70.1 (HR Writer Inquiry Request) and HR170 (HR Writer Report Request), you can override the company or define additional criteria to further narrow the population selection criteria. You can use a wildcard ("*") for alpha fields. The wildcard must be entered at the beginning of the field, and the end of the field must be left blank. For example, you can enter AN* to search for job codes that start with AN. You cannot enter *ING to search for job codes that end with ING. Updated Files PERSACTION - PWSELECT - Contains selection criteria. PWTITLE - The primary file maintained by this program. Referenced Files PADICT - Used to get data item information from the dictionary. PWAUTHOR - Used to validate the author. HR65.7 - HR Writer Detail Selection Use HR65.7 (HR Writer Detail Selection) to select the detail data items that determine the detail data you want to include in the report. The detail topic you defined for the report in HR65.1 (HR Writer Title Creation) determines the detail data items that display for selection. Refer to the Human Resources Procedures Manual for a complete list of data items by topic. After you select the data items, use HR65.8 (HR Writer Detail Criteria) to define values for the selected data items. Updated Files PWSELECT - The detail file updated by this screen. PWTITLE - The primary file updated by this screen. Referenced Files HRUSERFLDS - PADICT - Used to retrieve data item information from the dictionary. PADICT2 - Used to get data item information from the dictionary. PWAUTHOR - Used to validate the author. PWSELECT - The detail file updated by this screen. HR65.8 - HR Writer Detail Criteria Use HR65.8 (HR Writer Detail Criteria) to define values for the detail data items you selected in HR65.7 (HR Writer Detail Selection). In other words, on this screen, you determine which detail records to include in the report. The data items you select in HR65.7 display on the top half of the screen. On the bottom half of the screen, you enter include or exclude ranges and values, and assign item groups to the items. When selecting detail for your report, you may want to include only information pertaining to certain dates. For example, to include only payments within a quarter, you can enter values in the Date Range field or you can enter Include in the Include/Exclude field and a date range in the Beginning Value and Ending Value fields on this screen. Entering a date range in this screen, in HR70.1 (HR Writer Inquiry), or HR170 (HR Writer Report Request) rather than under the detail criteria makes the report generation more efficient because the system does not have to read all records in the file to pick out the records to include. You can override the Date Range and Suppress Individual fields defined as detail criteria, in HR70.1 (HR Writer Inquiry Request) and HR170 (HR Writer Report Request) at run time. Use the Item Group field to create "and" or "or" conditions. Item groups with the same number are used to identify selection criteria as "and" conditions. An individual must meet all criteria in the item group to be included in the report. Use item groups with different numbers to identify selection criteria as "or" conditions. That is, an individual must meet all the criteria in at least one item group to be included on the report. You can use a wildcard ("*") for alpha fields. The wildcard must be entered at the beginning of the field, and the end of the field must be left blank. For example, you can enter AN* to search for job codes that start with AN. You cannot enter *ING to search for job codes that end with ING. For an example of how the include/exclude function works, refer to the Lawson Human Resources Procedures Manual. Updated Files PERSACTION - PWSELECT - Contains selection criteria. PWTITLE - The primary file updated by this program. Referenced Files PADICT - Used to get data item information from the dictionary. PWAUTHOR - Used to validate the author. INVOKED Programs HRFN |