HR511 – Employee Conversion
- System
- Human Resources (HR)
- Type
- Batch program
- Updates
- 58 tables
- References
- 82 tables
HR511 (Employee Conversion) is a Lawson Human Resources batch program. It updates APPJOBHIST, BNCHANGE, BNGRPCHG, BNTAEMPBAL, C6EMDDMSTR, CKPOINT, CMASSIGN, CMCHANGE and 50 more and references ACACCTCAT, APPLICANT, BENEFIT, BNBEN, BNEMPGRNT, BNTAEMPBAL, C6PRDDEF, C6STATE and 74 more.
About HR511
Run Employee Conversion (HR511) to - import employee data from a non-Lawson application into HR11.1 (Employee) in the Lawson Human Resources application, and - import current Level 2 through Level 5 position and job records into PA13.1 (Multiple Positions, Jobs). Current records are records that do not have an end date. **Processing Effect This program takes fields from a comma-separated value (CSV) file and updates the associated employee files as if the employee were added on HR11.1 and PA13.1. Use the Add function in the CSV file only for initial employee creation. If an employee record already exists with the same employee number, the system overrides the original employee record. Use the Change function in the CSV file to update existing employee data, such as deductions, benefits, personnel actions, and so on, with data from a non-Lawson system. To clear out a current field value on an existing employee record, you fill the field with special characters and use the Change function. This tells the program you would like the field cleared. The special characters required are asterisks for alpha fields, and 9s for numeric or date fields. Make sure the number of characters entered is the maximum allowed for that field. Leaving the field blank in the input file results in the field being unchanged from it's current value. The program loads all employee fields found in HR11.1 and PA13.1 and performs all the edits of HR11.1 and PA13.1. If the record has errors, an error message prints on the report. The program allows creation of oneautomatic deposit account to be used as the default ACH record. The minimum required fields are: - Function Code - Company - Employee Last Name - Employee First Name - Employee Number (The Employee Number is required if the Auto Employee Flagis set to No. The Auto Employee Flag is set in HR00.1 (Company). - Effective Date (PEP-EFFECT-DATE) - Position Level The PEP-EFFECT-DATE determines when a position or job takes effect. ThePEP-EFFECT DATE is always used--even if you do not use formal positions. You can view the effective date on PA13.1 (Multiple Positions, Jobs)
More information: The Personnel Administration system uses the HR511 PEP-EFFECT-DATE field todetermine: - Whether the position is active. If a position is being converted, theposition needs to be an active position in the Position (PAPOSITION) file as of this effective date. You can use PA02.1 (Position) to determine whether a position is active. - Whether the corresponding schedule, grade, and/or step, if being converted,exist as of the effective date. If a schedule, grade and/or step are being converted, then the corresponding record needs to exist as of this effective date. You can use PA95.1 (Grade Range Schedule) or PR16.1 (Step and Grade Schedule) to determine the effective date of the grade range schedule and stepand grade schedule. - Whether a pay plan in the Overtime Pay Plan (PROVERTIME) file exists as ofthe effective date. If pay plan is being converted, a record must exist as of this effective date. You can view the pay plan date in PR21.1 (Pay Plan). - Whether it is appropriate for an employee with a payment status of NN (NoPay/No Benefits) or NB (No Pay/Benefits) to have time records. If employees payment status changes to NN or NB, and time records exist with a date after than effective date, then an error will occur. Payment status is defined on the employee status codes. You can view an employee's status on HR11.1 (Employee). The HR511 PEP-EFFECT-DATE field also updates the following: 1. The Employee Multiple Pos, Jobs (PAEMPPOS) file. If you use the PersonnelAdministration system, the this file is used, even if you do not use formal positions. You can view information from the PAEMPPOS file in PA13.1 (MultiplePositions, Jobs). When records are created in the PAEMPPOS file the following occur: - If the most recent PAEMPPOS date is earlier than the PEP-EFFECT-DATE, thena new PAEMPPOS record with this EFFECT-DATE is created. An end date (PEP-EFFECT-DATE minus 1) is calculated and written to the prior PAEMPPOS record. - If the most recent PAEMPPOS date has the same date as the PEP-EFFECT-DATE,then PAEMPPOS record is changed. - If most recent PAEMPPOS date is later than the PEP-EFFECT-DATE, then thechange is considered retroactive, and the treatment of the most recent PAEMPPOS is determined by the default history correction method selected for the company. You can view the default correction method on Company (HR00.1) on the Personnel, Special Processing tab. In addition, if a pay step is used, the Personnel Administration system usesPEP-EFFECT-DATE to retrieve the correct pay rate and update the PAEMPPOS file. 2. The HR History (HRHISTORY) file. The HRHISTORY EFFECT-DATE field isupdated for any fields logged to history. History is logged if you select Yesin the Update History field of HR511 and if you selected Yes in the History fields of HR10.1 (Data Item Attributes). You can view the HRHISTORY-EFFECT DATE on HR54.1 (Employee HistoryCorrection) or by using the Drill Around feature. 3. The Employee Payrate History (PRRATEHIST) file. The PRRATEHIST EFFECT-DATEis updated if pay rate is logged to history. 4. The deduction start date if required deductions are created. ThePEP-EFFECT-DATE is used as the start date for the deduction. You can view thededuction start date on PR14.1 (Employee Deduction). 5. The Benefit Group Changes (BNGRPCHG) file. If employee group membershipchanges, then the PEP-EFFECT-DATE is written to the Benefit Group Changes (BNGRPCHG) file.
Updated files (58)
| Table | Description | System |
|---|---|---|
| APPJOBHIST | Applicant Job History | PA |
| BNCHANGE | Benefit Changes | BN |
| BNGRPCHG | Benefit Group Change | BN |
| BNTAEMPBAL | Emp Vacation Buy/Sell Balance | LP |
| C6EMDDMSTR | No description in the Lawson data dictionary | C6 |
| CKPOINT | No description in the Lawson data dictionary | — |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMCHANGE | No description in the Lawson data dictionary | CW |
| CMCONTRACT | No description in the Lawson data dictionary | CW |
| CWCHANGE | Employee Contract Change Audit | CW |
| CWCONTRACT | Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay… | CW |
| EMDEDMASTR | Employee Deduction | PR |
| EMPCODES | Emp/App Personnel Codes | PA |
| EMPLOYEE | Employee | HR |
| HISTERR | Contains history errors moved using HR54.1 (Employee History Correction) and PA54.1 (Personnel Action History… | HR |
| HRCTRYCODE | Contains country-specific codes: Ethnicity, (name) Prefix, and (name) suffix. | HR |
| HREMPUSF | Employee/Applicant User Fields | HR |
| HRHISTORY | HR History | HR |
| HRSUPER | Supervisors | HR |
| INEMPLOYEE | No description in the Lawson data dictionary | C6 |
| MILITARY | Military Service History | PA |
| ONETMDED | Payroll One-time Deduction | PR |
| PAASSIGNED | Assigned Resources | PA |
| PACOMMENTS | Personnel Comments | PA |
| PAEEEORACE | Personnel Administration Equal Opportunity Race | PA |
| PAEMPAPP | No description in the Lawson data dictionary | PA |
| PAEMPAPTST | Contains employee test information. | PA |
| PAEMPLOYEE | Employee Personnel Information | HR |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAERECRUIT | No description in the Lawson data dictionary | PA |
| PAMEDICAL | Emp Medical and Work Desc Code | PA |
| PAPEPAUDIT | Retroactive Pos, Job Changes | PA |
| PAPOSCHG | Position Changes | PA |
| PATHFIND | Employee Report Writer Paths | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| PERSACTHST | Personnel Action History | PA |
| PERSACTION | Personnel Action | PA |
| PERSGROUP | Employee Group Header | HR |
| PGEMPLOYEE | Employee Group Employees | HR |
| PREMDEDHST | Employee Deduction History | PR |
| PRRATEHIST | Employee Rate History | HR |
| PRREGPARM | No description in the Lawson data dictionary | PR |
| PRSYSTEM | HR Company and Process Levels | HR |
| PRTAXLOC | No description in the Lawson data dictionary | PR |
| PWEMPLY | No description in the Lawson data dictionary | PW |
| PWSUPER | No description in the Lawson data dictionary | PW |
| QUARTDED | Quarterly Deduction | PR |
| QUARTWAGE | Quarterly Wage | PR |
| REVIEW | Employee Performance Review | PA |
| STANDTIME | Payroll Standard Time Record | PR |
| TAEEGROUP | Absence Plan Employee Group | LP |
| TAEEMASTER | Employee Absence Plan | LP |
| TAEMPSERV | Employee LP Service Record | LP |
| TAENROLL | No description in the Lawson data dictionary | LP |
| TALOSHRS | No description in the Lawson data dictionary | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TIMERECORD | Employee Time Records | PR |
Referenced files (82)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| APPLICANT | Applicant | PA |
| BENEFIT | Employee Benefit | BN |
| BNBEN | No description in the Lawson data dictionary | BN |
| BNEMPGRNT | Emp Stock Option Grant | BN |
| BNTAEMPBAL | Emp Vacation Buy/Sell Balance | LP |
| C6PRDDEF | No description in the Lawson data dictionary | C6 |
| C6STATE | No description in the Lawson data dictionary | C6 |
| C6TAXGRP | No description in the Lawson data dictionary | C6 |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMCONTRACT | No description in the Lawson data dictionary | CW |
| CMCONTRULE | No description in the Lawson data dictionary | CW |
| CMEMPTRANS | No description in the Lawson data dictionary | CW |
| CUCODES | Currency Codes | IF |
| CWASSIGN | No description in the Lawson data dictionary | CW |
| CWCONTRACT | Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay… | CW |
| CWCONTRULE | No description in the Lawson data dictionary | CW |
| CWDISTRIB | No description in the Lawson data dictionary | CW |
| CWEMPTRANS | No description in the Lawson data dictionary | CW |
| DEDCODE | Deduction | PR |
| DEPTCODE | Department | HR |
| EMDEPEND | Employee Dependent | HR |
| EMDISTMAST | Emp Acct Distribution Override | PR |
| EMPFLEXDOL | Employee Flex Dollars | BN |
| EMSTATUS | Employee/Applicant Status | HR |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMAUDIT | The GM audit file tracks when labor distribution record status changes occur and when labor distribution records are… | GM |
| GMEFFORT | Actual Grant Effort | GM |
| GMLABDIST | Grant Labor Distribution | GM |
| GMRETDIST | Grant Retro Labor Distribution | GM |
| GMTRANEFRT | Grant Effort Transaction | GM |
| HREMPRCVR | No description in the Lawson data dictionary | HR |
| HRLTMRULE | No description in the Lawson data dictionary | HR |
| HRSECLEV | Employee Security Level | HR |
| HRUSERFLDS | HR User Fields | HR |
| HRWRKSCHD | Contains the parent record for a work schedule or is the parent record for a K12 teacher contract work schedule. | HR |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JOBCODE | Job Code Parameters | HR |
| LPLINK | LP Link Plan Table | LP |
| PABUDGET | Budget | PA |
| PADICT | HR Systems Data Dictionary | HR |
| PADICT2 | HR Systems Data Dict Detail | HR |
| PAENCUMBER | No description in the Lawson data dictionary | PA |
| PAINSTRUCT | Instructor Information | PA |
| PAPOSITION | Positions | PA |
| PAPOSRULE | Position Rules | PA |
| PASCRTY | Data Item Attribute Parameters | HR |
| PATSTSETUP | Contains test setup information. | PA |
| PCODES | Human Resource Code | HR |
| PCODESDTL | Contains contact information detail (address and phone number) for specific types of PCODES. | HR |
| PERSACTYPE | Personnel Action Code | PA |
| PGSELECT | Emp Group Selection Criteria | HR |
| PLAN | PL Group Detail | BN |
| PRBUSGRP | No description in the Lawson data dictionary | PR |
| PRMONITOR | No description in the Lawson data dictionary | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPAYCODE | Pay Code | PR |
| PRPROVINCE | This file contains province codes and descriptions. | PR |
| PRQCENTGRP | No description in the Lawson data dictionary | PR |
| PRQUALIFY | Required Code Select Criteria | PR |
| PRRATES | Alternate Pay Rates | PR |
| PRSAGDTL | Step & Grade Schedule Detail | HR |
| PRSAGHEAD | Step & Grade Schedule Header | HR |
| PRSTATE | States | PR |
| PRTAXAUTH | Tax Authority | PR |
| PRTAXLEVY | Payroll Tax Levy | PR |
| REQCODE | Required Deduction Code Header | PR |
| SYSTEMCODE | System Code | IF |
| TAACCRUAL | Absence Plan Accrual Rule | LP |
| TAEMPTRANS | This file contains the accrual plan transactions for each plan structure for an employee. | LP |
| TAGENLEDGR | LP General Ledger Rule | LP |
| TALIMIT | Absence Plan Limit Rule | LP |
| TALOSHRS | No description in the Lawson data dictionary | LP |
| TAPAYROLL | Absence Plan Payroll Rule | LP |
| TAPLAN | Absence Plan | LP |
| TASERVCODE | Absence Plan Service Code | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TATABLE | No description in the Lawson data dictionary | LP |
| TAXGROUP | Payroll Tax Reporting Group | PR |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (16)
ACAC, ACTA, API4, HLTM, HRCL, HRHI, HRLO, HRST, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU