Human Resources – Lawson HR tables and programs
Human Resources (HR) in Lawson S3 v10 MSP6 has 79 tables, 333 online screens and 63 batch programs.
Tables (79)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| BNATXLIMIT | ALF | No description in the Lawson data dictionary | TAX-STATUS, EFFECT-DATE | 5 |
| BNLIMITS | BNL | Benefit Limits | YEAR | 9 |
| DEPTCODE | DPT | Department | COMPANY, PROCESS-LEVEL, DEPARTMENT | 15 |
| DEPTSEGBLK | DSG | Department Segment Block | COMPANY, PROCESS-LEVEL, DEPARTMENT | 4 |
| EMDEPEND | EMD | Employee Dependent | COMPANY, EMPLOYEE, SEQ-NBR | 62 |
| EMPALTNAME | EAN | No description in the Lawson data dictionary | COMPANY, EMPLOYEE | 26 |
| EMPBOD | EMB | No description in the Lawson data dictionary | COMPANY, EMPLOYEE | 8 |
| EMPLOYEE | EMP | Employee | COMPANY, EMPLOYEE | 152 |
| EMPPICKLST | EPL | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, TYPE, SELECT-VALUE | 5 |
| EMSTATUS | EMS | Employee/Applicant Status | COMPANY, EMP-STATUS | 14 |
| FAMSTSHIST | FSH | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, FAMILY-STATUS, EFFECT-DATE | 15 |
| HISTERR | HER | Contains history errors moved using HR54.1 (Employee History Correction) and PA54.1 (Personnel Action History… | COMPANY, EMPLOYEE, OBJ-ID, EFFECT-DATE, ACTION-CODE, ACTION-NBR, FLD-NBR, SEQ-NBR | 33 |
| HRCONTNBR | HCN | No description in the Lawson data dictionary | COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, SEQ-NBR | 16 |
| HRCORRESP | HCP | No description in the Lawson data dictionary | COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, SEQ-NBR | 50 |
| HRCTRYCODE | CTC | Contains country-specific codes: Ethnicity, (name) Prefix, and (name) suffix. | TYPE, COUNTRY-CODE, HRCTRY-CODE | 10 |
| HRDEPBEN | HDB | Dependent Benefits | COMPANY, EMPLOYEE, DEPENDENT, PLAN-TYPE, PLAN-CODE, EMP-START, START-DATE | 16 |
| HREMPRCVR | LEM | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, WORKASSIGNMENT, ACTION-CODE | 247 |
| HREMPUSF | HEU | Employee/Applicant User Fields | COMPANY, EMP-APP, EMPLOYEE, FIELD-KEY | 12 |
| HRETHRCVR | LIT | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, ACTION-CODE, TYPE, LTM-OBJ-ID | 18 |
| HRHISTORY | HRH | HR History | COMPANY, EMPLOYEE, OBJ-ID, FLD-NBR, BEG-DATE, SEQ-NBR | 22 |
| HRIADIM | HID | No description in the Lawson data dictionary | DATA-MART-NAME, DIM-TYPE | 19 |
| HRIAMBR | HIM | No description in the Lawson data dictionary | DATA-MART-NAME, DIM-TYPE, MEMBER-TYPE, SEQ-NBR | 17 |
| HRINTDELTA | LID | No description in the Lawson data dictionary | COMPANY, RECORD-TYPE, LTM-OBJ-ID, WORKASSIGNMENT, RCVR-FORM-NAME | 10 |
| HRINTFDICT | LTF | No description in the Lawson data dictionary | FLD-NBR | 7 |
| HRINTRFACE | LTI | No description in the Lawson data dictionary | COMPANY, TOPIC, FLD-NBR | 4 |
| HRJOBRCVR | LJB | No description in the Lawson data dictionary | COMPANY, JOB-CODE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE | 73 |
| HRLTMDATA | LTD | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | 83 |
| HRLTMEMPOS | LPP | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | 43 |
| HRLTMJOBCD | LTJ | No description in the Lawson data dictionary | COMPANY, JOB-CODE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | 22 |
| HRLTMPOS | LPO | No description in the Lawson data dictionary | COMPANY, POSITION, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | 30 |
| HRLTMRULE | LTR | No description in the Lawson data dictionary | COMPANY | 36 |
| HRLTMSUPER | LSP | No description in the Lawson data dictionary | COMPANY, CODE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | 21 |
| HRNAMERCVR | LNR | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID | 32 |
| HROCCUPCD | HOP | No description in the Lawson data dictionary | COMPANY, JOB-CODE, COUNTRY-CODE, OCCUPTN-CODE | 10 |
| HRPOSFLDS | HRP | Position User Fields | TYPE, FIELD-KEY | 16 |
| HRPOSRCVR | LPV | No description in the Lawson data dictionary | COMPANY, POSITION, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE | 60 |
| HRPOSUSD | HPD | Position User Field Type | COMPANY, TYPE, OBJ-ID, EFFECT-DATE, FIELD-KEY | 17 |
| HRPOSVAL | HVL | Position User Field Values | TYPE, FIELD-KEY, CODE | 8 |
| HRSECLEV | HSL | Employee Security Level | USERNAME | 2 |
| HRSUPER | HSU | Supervisors | COMPANY, CODE | 21 |
| HRSUPRCVR | LSU | No description in the Lawson data dictionary | COMPANY, SUPERVISOR, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE | 31 |
| HRUSERFLDS | HRU | HR User Fields | FIELD-KEY | 15 |
| HRUSFRCVR | LUF | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, TYPE, LTM-DATE-STAMP, LTM-TIME-STAMP, PCT-OBJ-ID, LTM-OBJ-ID | 29 |
| HRUTILITY | HUT | HR Utility | SYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBER | 13 |
| HRWRKDTL | WSD | Contains the detail for a work schedule or the K12 teacher contract work schedule. | COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE, WORK-PERIOD, DATE | 21 |
| HRWRKSCHD | WSC | Contains the parent record for a work schedule or is the parent record for a K12 teacher contract work schedule. | COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE | 27 |
| JOBCLASS | JCL | Job Class | COMPANY, JOB-CLASS | 3 |
| JOBCODE | JBC | Job Code Parameters | COMPANY, JOB-CODE | 58 |
| PADICT | PAD | HR Systems Data Dictionary | FLD-NBR | 24 |
| PADICT2 | PA2 | HR Systems Data Dict Detail | TOPIC, FLD-NBR | 6 |
| PAEMPGOAL | PGO | Employee Goals | COMPANY, EMPLOYEE, SEQ-NBR | 24 |
| PAEMPLOYEE | PEM | Employee Personnel Information | COMPANY, EMPLOYEE | 144 |
| PAEMPPOS | PEP | Employee Multiple Pos, Jobs | COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE | 43 |
| PASCRTY | PAS | Data Item Attribute Parameters | COMPANY, COUNTRY-CD-REQ, PROCESS-LEVEL, FLD-NBR | 12 |
| PATHFIND | PTF | Employee Report Writer Paths | COMPANY, EMPLOYEE, FLD-NBR, POS-LEVEL | 10 |
| PCODES | PCO | Human Resource Code | TYPE, CODE | 14 |
| PCODESDTL | PDD | Contains contact information detail (address and phone number) for specific types of PCODES. | TYPE, CODE | 41 |
| PCODESTYPE | PCS | No description in the Lawson data dictionary | TYPE | 6 |
| PERSGROUP | PRG | Employee Group Header | COMPANY, GROUP-NAME | 12 |
| PGEMPLOYEE | PGE | Employee Group Employees | COMPANY, GROUP-NAME, EMPLOYEE | 7 |
| PGSELECT | PGS | Emp Group Selection Criteria | COMPANY, GROUP-NAME, EMPLOYEE, SEQ-NBR | 18 |
| PRPROCGRP | PRP | Payroll Process Group | COMPANY, PROC-GROUP, PROCESS-LEVEL | 3 |
| PRRATEHIST | PRH | Employee Rate History | COMPANY, EMPLOYEE, BEG-DATE, SEQ-NBR | 20 |
| PRSAGDTL | SGD | Step & Grade Schedule Detail | COMPANY, SCHEDULE, EFFECT-DATE, PAY-GRADE, PAY-STEP | 9 |
| PRSAGHEAD | SGH | Step & Grade Schedule Header | COMPANY, INDICATOR, SCHEDULE, EFFECT-DATE | 14 |
| PRSYSTEM | PRS | HR Company and Process Levels | COMPANY, PROCESS-LEVEL | 129 |
| PSGRELATE | PSR | Pay Class/Pay Sum Grp Relation | COMPANY, PAY-CLASS, PAY-SUM-GRP | 5 |
| PWAUTHOR | PWA | HR Report Writer Author | AUTHOR-NAME | 4 |
| PWCOMPUTE | PWC | HR Writer Compute Statements | AUTHOR-NAME, COLUMN-NAME | 33 |
| PWSELECT | PWS | HR Writer Selection Criteria | AUTHOR-NAME, TITLE-NBR, SELECT-TYPE, SEQ-NBR | 11 |
| PWTITLE | PWT | HR Report Writer Title | AUTHOR-NAME, TITLE | 31 |
| PWTITLETOP | PTT | HR Report Writer Title Topic | AUTHOR-NAME, TITLE, TOPIC | 4 |
| PWTOPIC | PWP | HR Report Writer Topics | TYPE, TOPIC | 5 |
| SYSRULES | SYR | No description in the Lawson data dictionary | TASK, SYSTEM, KEY1, KEY2, KEY3, KEY4, KEY5 | 19 |
| ZCUSTMAP | ZCM | No description in the Lawson data dictionary | COMPANY, CODE-1, CODE-2, MAP-ALPHA, MAP-NUM | 29 |
| ZEECONTACT | ZEC | No description in the Lawson data dictionary | COMPANY, EMPLOYEE | 8 |
| ZHLINRATES | ZHL | No description in the Lawson data dictionary | COMPANY, PLAN-CODE, COV-OPTION, EMP-STATUS | 7 |
| ZINTHOURS | ZIH | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, LOATYPE | 9 |
| ZPENDPCP | ZCP | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, SEQ-NBR | 8 |
Online screens (333)
| Screen | Description | Updates | References |
|---|---|---|---|
| ES01.1 | Comments | 1 | 0 |
| ES02.1 | Employee Personal Selects | 1 | 2 |
| ES02.2 | Absence Plan Balances Rule | 1 | 5 |
| ES02.3 | Hours to Days Conversion Rule | 1 | 2 |
| ES03.1 | Time Off Request Rules | 1 | 3 |
| ES10.1 | Family Status Change History | 1 | 2 |
| HACV.1 | Activity Selection Invoke | 0 | 1 |
| HAP2.1 | Applicant Option 2 Selection Invoke | 0 | 1 |
| HAP3.1 | Applicant Option 4 Selection Invoke | 23 | 32 |
| HAPL.1 | Applicant Selection Invoke | 0 | 1 |
| HATC.1 | Attend Code Selection Invoke | 0 | 1 |
| HAXX.1 | Activity - Acct Category Selection Invoke | 0 | 2 |
| HBAC.1 | Bank Account Selection Invoke | 0 | 1 |
| HBNK.1 | Bank Code Selection Invoke | 0 | 1 |
| HCRE.1 | Action Reason Code Selects | 23 | 33 |
| HCTC.1 | HRCTRYCODE Select Invoke | 0 | 2 |
| HCUC.1 | Currency Selection Invoke | 0 | 1 |
| HCVO.1 | Coverage Option Selection Invoke | 0 | 1 |
| HDCL.1 | Deduction Class Selection Invoke | 0 | 1 |
| HDDC.1 | Deduction Selection Invoke | 0 | 1 |
| HDPT.1 | Department Select Invoke | 0 | 1 |
| HEMD.1 | Dependent Selection Invoke | 0 | 2 |
| HEMP.1 | Fam Agg Emp Selection Invoke | 0 | 1 |
| HEMS.1 | Employee Status Select Invoke | 0 | 1 |
| HEP2.1 | Employee Option 2 Selection Invoke | 0 | 1 |
| HEP3.1 | Employee Option 3 Selection Invoke | 0 | 1 |
| HEP4.1 | Employee Option 4 Selection Invoke | 23 | 32 |
| HFLP.1 | Flex Plan Selection Invoke | 0 | 1 |
| HGDT.1 | Account Selection Invoke | 0 | 2 |
| HGLM.1 | Account Selection Invoke | 0 | 2 |
| HGLN.1 | Account Unit Selection Invoke | 0 | 2 |
| HGLS.1 | Dist Comp Selection Invoke | 0 | 1 |
| HHCN.1 | Additional Contacts Select Invoke | 0 | 1 |
| HHSU.1 | Supervisor Select Invoke | 0 | 2 |
| HINT.1 | Instrycd Select Invoke | 0 | 1 |
| HJBC.1 | Job Code Select Invoke | 0 | 1 |
| HJCL.1 | Job Class Selection Invoke | 0 | 1 |
| HLTM.1 | Lawson Talent Management Feed | 5 | 16 |
| HOSH.1 | OSHA Selection Invoke | 0 | 2 |
| HPAE.1 | Contact Selection Invoke | 0 | 2 |
| HPAT.1 | Action Code Selection Invoke | 0 | 1 |
| HPBG.1 | Prbusgrp Select Invoke | 0 | 1 |
| HPCD.1 | Pay Code Selection Invoke | 0 | 1 |
| HPCL.1 | Pay Class Selection Invoke | 0 | 1 |
| HPCO.1 | PCODES Select Invoke | 0 | 1 |
| HPJR.1 | Requisition Selection Invoke | 0 | 1 |
| HPLC.1 | Plan Class Selection Invoke | 0 | 1 |
| HPLM.1 | Plan Name Selection Invoke | 0 | 1 |
| HPLN.1 | Plan Code Selection Invoke | 0 | 2 |
| HPOS.1 | Position Selection Invoke | 23 | 32 |
| HPPV.1 | Prstate Select Invoke | 0 | 1 |
| HPQC.1 | Prqcentgrp Select Invoke | 23 | 33 |
| HPRG.1 | Employee Group Selection Invoke | 0 | 1 |
| HPRO.1 | Activity Selection Invoke | 0 | 1 |
| HPRS.1 | Process Level Select Invoke | 23 | 32 |
| HPRX.1 | Prtaxauth Select Invoke | 0 | 1 |
| HPSA.1 | Prstate Select Invoke | 0 | 1 |
| HPSG.1 | Pay Summary Group Selection Invoke | 0 | 1 |
| HPXC.1 | Tax Category Selection Invoke | 0 | 1 |
| HR00.1 | Company | 86 | 97 |
| HR00.2 | Canada Payroll Account Numbers | 1 | 3 |
| HR00.3 | Quebec Enterprise Numbers | 1 | 3 |
| HR01.1 | Process Level | 86 | 95 |
| HR02.1 | Department | 7 | 12 |
| HR03.1 | Employee Status Codes | 1 | 2 |
| HR03.2 | Country Specific Human Resource Codes | 1 | 2 |
| HR04.2 | Human Resource Codes | 6 | 17 |
| HR04.3 | Human Resource Codes | 6 | 16 |
| HR04.4 | Alphanumeric User Fields | 5 | 13 |
| HR04.5 | Numeric User Fields | 5 | 13 |
| HR04.6 | Date User Fields | 5 | 13 |
| HR04.7 | User Fields Value List | 6 | 16 |
| HR04.8 | Human Resource Codes | 6 | 16 |
| HR04.9 | Human Resource Codes | 2 | 7 |
| HR05.1 | Job Classes | 1 | 2 |
| HR06.1 | Job Code | 13 | 22 |
| HR06.2 | Job Code Salary Ranges | 1 | 3 |
| HR06.4 | Canada Workers Compensation Class Override | 1 | 4 |
| HR07.1 | Supervisor | 5 | 6 |
| HR08.1 | Processing Groups | 1 | 1 |
| HR09.1 | User Data Item Security | 1 | 0 |
| HR10.1 | Data Item Attributes | 1 | 4 |
| HR10.2 | Position Item Attributes | 1 | 4 |
| HR10.3 | Required Fields by Country | 1 | 5 |
| HR10.4 | Required User Fields | 2 | 3 |
| HR11.1 | Employee | 110 | 123 |
| HR11.2 | Compensation Analysis | 53 | 67 |
| HR11.3 | Grant Management | 0 | 5 |
| HR11.4 | Employee Assignment Inquiry | 52 | 67 |
| HR12.1 | Employee Security | 2 | 2 |
| HR13.1 | Dependent | 8 | 20 |
| HR13.2 | Dependent Benefits | 2 | 10 |
| HR13.3 | Dependent Benefits | 2 | 10 |
| HR13.4 | Dependent Benefits | 2 | 10 |
| HR14.1 | Alternate Pay Rates | 2 | 8 |
| HR15.1 | User Fields | 17 | 36 |
| HR15.2 | Alphanumeric User Fields | 1 | 5 |
| HR15.3 | Job Code User Fields | 1 | 5 |
| HR16.1 | State Reporting Information | 0 | 2 |
| HR16.2 | State Reporting Information - Alaska | 1 | 3 |
| HR16.3 | State Reporting Information - Arizona | 1 | 3 |
| HR16.4 | State Reporting Information - Arkansas | 1 | 3 |
| HR16.5 | State Reporting Information - California | 1 | 3 |
| HR16.6 | State Reporting Information | 1 | 3 |
| HR16.7 | State Reporting Information - Florida | 1 | 3 |
| HR16.8 | State Reporting Information - Illinois | 1 | 3 |
| HR17.1 | State Reporting Information - Indiana | 1 | 4 |
| HR17.2 | State Reporting Information - Iowa | 1 | 4 |
| HR17.3 | State Reporting Information - Massachusetts | 1 | 4 |
| HR17.4 | State Reporting Information - Minnesota | 1 | 4 |
| HR17.5 | State Reporting Information - Missouri | 1 | 4 |
| HR17.6 | State Reporting Information - North Carolina | 1 | 4 |
| HR17.7 | State Reporting Information - New Jersey | 1 | 4 |
| HR17.8 | State Reporting Information - Ohio | 1 | 4 |
| HR17.9 | State Reporting Information - Oregon | 1 | 4 |
| HR18.1 | State Reporting Information - Pennsylvania | 1 | 3 |
| HR18.2 | State Reporting Information - Texas | 1 | 3 |
| HR18.3 | State Reporting Information - Wyoming | 1 | 3 |
| HR18.4 | State Reporting Information - Michigan | 1 | 3 |
| HR18.5 | State Reporting Information - Puerto Rico | 2 | 3 |
| HR18.6 | State Reporting Information - New Mexico | 1 | 3 |
| HR20.1 | Additional Contact Numbers | 1 | 5 |
| HR21.1 | Work Schedule | 3 | 3 |
| HR22.1 | Job Occupation Codes | 1 | 5 |
| HR25.1 | Grant Management Pay Code | 1 | 2 |
| HR26.2 | Job Code Alpha User Field Set Up | 4 | 3 |
| HR26.3 | Job Code Numeric User Field Set Up | 4 | 3 |
| HR26.4 | Job Code Date User Field Set Up | 4 | 3 |
| HR26.5 | Value List | 1 | 2 |
| HR28.1 | Employee Ethnicity | 52 | 67 |
| HR30.1 | Correspondence Tracking | 1 | 11 |
| HR40.1 | Employee Name in Alt Language | 1 | 2 |
| HR40.2 | Dual Names for Employees | 1 | 2 |
| HR50.1 | Interface Rules | 2 | 5 |
| HR51.2 | Employee Interface Data | 1 | 16 |
| HR51.3 | Position Interface Data | 1 | 6 |
| HR51.4 | Job Code Interface Data | 1 | 3 |
| HR51.5 | Supervisor Interface Data | 1 | 3 |
| HR51.6 | Emp Position Interface Data | 1 | 10 |
| HR51.7 | Employee Status Mapping | 1 | 2 |
| HR51.8 | WFM Interface Data | 1 | 14 |
| HR52.2 | Talent Management Interface Data | 1 | 12 |
| HR52.3 | Talent Mngmt Position Data | 1 | 2 |
| HR52.4 | Talent Mngmt Jobcode Data | 1 | 1 |
| HR52.5 | Talent Mngmt Supervisor Data | 1 | 1 |
| HR52.6 | Talent Mngmt Emp Position Data | 1 | 7 |
| HR54.1 | Employee History Correction | 23 | 33 |
| HR55.1 | Employee Group Definition | 6 | 29 |
| HR55.2 | Employee Groups By Employees | 8 | 31 |
| HR55.3 | Employee Groups By Criteria | 6 | 12 |
| HR60.1 | Human Resource Writer Authors | 1 | 2 |
| HR64.1 | Human Resource Writer Title Update | 4 | 0 |
| HR65.1 | Human Resource Writer Title Creation | 4 | 3 |
| HR65.2 | Human Resource Writer Format Item Selection | 3 | 9 |
| HR65.3 | Human Resource Writer Format Item Order | 1 | 3 |
| HR65.4 | Human Resource Writer Print Order | 1 | 7 |
| HR65.5 | Human Resource Writer Population Selection | 2 | 8 |
| HR65.6 | Human Resource Writer Population Criteria | 3 | 2 |
| HR65.7 | Human Resource Writer Detail Selection | 2 | 6 |
| HR65.8 | Human Resource Writer Detail Criteria | 3 | 2 |
| HR67.1 | Human Resource Writer Compute Statement | 2 | 3 |
| HR68.1 | Human Resource Writer Data Item Security | 1 | 5 |
| HR70.1 | Human Resource Writer Inquiry | 1 | 105 |
| HR70.2 | Human Resource Writer Inquiry Window | 0 | 4 |
| HR70.3 | Human Resource Writer Inquiry Window | 0 | 3 |
| HR79.2 | Pay Rate Change Calculator | 0 | 4 |
| HR80.1 | Job Occupation Type | 6 | 16 |
| HR80.2 | Union | 6 | 16 |
| HR80.3 | Bargaining Unit | 6 | 16 |
| HR80.4 | Badge Code | 6 | 16 |
| HR80.5 | Mail Group | 6 | 16 |
| HR80.6 | Hire Source | 6 | 16 |
| HR80.7 | User Level | 6 | 16 |
| HR80.8 | Relationship | 6 | 16 |
| HR80.9 | Primary Care Physician | 6 | 16 |
| HR81.1 | Education Degree | 6 | 16 |
| HR81.2 | Education Subject | 6 | 16 |
| HR81.3 | Education Institution | 6 | 16 |
| HR81.4 | Competency | 6 | 16 |
| HR81.5 | Competency and Certification Source | 6 | 16 |
| HR81.6 | Certification | 6 | 16 |
| HR81.7 | Company Property | 6 | 16 |
| HR81.8 | Emergency Medical | 6 | 16 |
| HR81.9 | Work Restriction | 6 | 16 |
| HR82.1 | Working Condition | 6 | 16 |
| HR82.2 | Work Requirement | 6 | 16 |
| HR82.3 | Parking Lot | 6 | 16 |
| HR82.4 | Relocation | 6 | 16 |
| HR82.5 | Benefit | 6 | 16 |
| HR82.6 | Qualification | 6 | 16 |
| HR82.7 | Proficiency | 6 | 16 |
| HR82.8 | User Field | 6 | 16 |
| HR82.9 | Association | 6 | 16 |
| HR83.1 | Review Type | 6 | 16 |
| HR83.2 | Performance Rating | 6 | 16 |
| HR83.3 | Applicant Rating | 6 | 16 |
| HR83.4 | Interview Rating | 6 | 16 |
| HR83.5 | Personnel Action Reason | 6 | 16 |
| HR83.6 | Review Type | 6 | 16 |
| HR83.7 | Benefit Reason Code | 6 | 16 |
| HR83.8 | Requisition Status | 6 | 16 |
| HR83.9 | Reason Code | 6 | 16 |
| HR84.1 | Position Reason Code | 6 | 16 |
| HR84.2 | Budget Reason Code | 6 | 16 |
| HR84.3 | Requisition Cost | 6 | 16 |
| HR84.4 | Supervisor User Field 1 | 6 | 16 |
| HR84.5 | Supervisor User Field 2 | 6 | 16 |
| HR84.6 | Supervisor User Field 3 | 6 | 16 |
| HR84.7 | Supervisor User Field 4 | 6 | 16 |
| HR84.8 | Supervisor User Field 5 | 6 | 16 |
| HR84.9 | Incident Status | 6 | 16 |
| HR85.1 | Incident Outcome | 6 | 16 |
| HR85.2 | Incident Category | 6 | 16 |
| HR85.3 | Incident | 6 | 16 |
| HR85.4 | Illness | 6 | 16 |
| HR85.5 | Body Part | 6 | 16 |
| HR85.6 | Incident Cost Category | 6 | 16 |
| HR85.7 | Incident Cost Type | 6 | 16 |
| HR85.8 | Accommodations | 6 | 16 |
| HR86.1 | Incident Follow Up Category | 6 | 16 |
| HR86.2 | Incident Follow Up Type | 6 | 16 |
| HR86.3 | Incident Follow Up Outcome | 6 | 16 |
| HR86.4 | Test Type | 6 | 16 |
| HR86.5 | Test Correspondence | 6 | 16 |
| HR86.6 | Test Source | 6 | 16 |
| HR86.7 | Test User Field 2 | 6 | 16 |
| HR86.8 | Test User Field 3 | 6 | 16 |
| HR86.9 | Test Eligibility Override Reason | 6 | 16 |
| HR87.1 | Test Reason | 6 | 16 |
| HR87.2 | Test Notification Type | 6 | 16 |
| HR87.3 | Test Refusal Reason | 6 | 16 |
| HR87.4 | Incident Severity | 6 | 16 |
| HR87.5 | Incident User 2 | 6 | 16 |
| HR87.6 | Incident User 3 | 6 | 16 |
| HR87.7 | Grievance and Disciplinary Action Category | 6 | 16 |
| HR87.8 | Grievance and Disciplinary Action Status | 6 | 16 |
| HR87.9 | Grievance and Disciplinary Action Outcome | 6 | 16 |
| HR88.1 | Grievance and Disciplinary Action Step Category | 6 | 16 |
| HR88.2 | Grievance and Disciplinary Action Step Type | 6 | 16 |
| HR88.3 | Grievance and Disciplinary Action Step Outcome | 6 | 16 |
| HR88.4 | Human Resource Codes - Disability | 6 | 16 |
| HR88.5 | Human Resource Codes - Religion | 6 | 16 |
| HR88.6 | Contract Type | 6 | 16 |
| HR88.7 | Census Metropolitan Area | 6 | 16 |
| HR89.1 | HR Codes - Work Eligibility Document Type | 6 | 16 |
| HR89.2 | HR Codes - Work Eligibility Document Description | 6 | 16 |
| HR89.3 | Human Resource Codes - Work Eligibility Status | 6 | 16 |
| HR89.4 | Human Resource Codes - Travel Doc Application Status | 6 | 16 |
| HR89.5 | Human Resource Codes - Travel Document | 6 | 16 |
| HR89.6 | Human Resource Codes - Contact Number Type | 6 | 16 |
| HR89.7 | HR Codes - Official Languages - Bilingual Region | 6 | 16 |
| HR89.8 | Sharp Device | 6 | 16 |
| HR89.9 | Brand of Device | 6 | 16 |
| HR90.1 | Comments | 3 | 10 |
| HR90.2 | Payment Comments | 2 | 3 |
| HR91.1 | Ethnicity | 1 | 2 |
| HR91.2 | Name Title | 1 | 2 |
| HR91.3 | Name Suffix | 1 | 2 |
| HR91.4 | Citizenship | 1 | 2 |
| HR91.5 | Job Occupation Code | 1 | 2 |
| HR91.6 | Veteran Code | 1 | 2 |
| HR91.7 | Objective Status | 6 | 16 |
| HR92.1 | Day Codes | 6 | 16 |
| HR92.2 | Leave Status | 6 | 16 |
| HR92.3 | Leave Reason | 6 | 16 |
| HR93.1 | Employee Audit Inquiry | 0 | 5 |
| HR93.2 | Pay Rate Audit Inquiry | 0 | 4 |
| HR93.3 | Applicant Audit Inquiry | 0 | 4 |
| HR93.4 | Supervisor Audit Inquiry | 0 | 4 |
| HR93.5 | Employee Deduction Audit Inquiry | 0 | 7 |
| HR93.6 | Job Code Audit Inquiry | 0 | 4 |
| HR93.7 | Position Audit Inquiry | 0 | 4 |
| HR93.8 | Employee Leave Plan Audit Inquiry | 1 | 9 |
| HR93.9 | Employee Leave of Absence Audit Inquiry | 1 | 5 |
| HR94.1 | Employee Direct Deposit Audit Inquiry | 0 | 6 |
| HRBD.1 | PR BOD Maintenance | 1 | 2 |
| HRCL.1 | Calc Compa Ratio - Pct of Rng | 0 | 4 |
| HREF.1 | Reference Selection Invoke | 0 | 2 |
| HRGP.1 | Deduction Class Selection Invoke | 0 | 1 |
| HRHI.1 | History Retrieval Routine | 0 | 2 |
| HRLO.1 | History Logging Routine | 2 | 1 |
| HRQC.1 | Required Code Selection Invoke | 0 | 1 |
| HRS1.1 | Select Control | 23 | 33 |
| HRSC.1 | Select Control | 23 | 33 |
| HS08.1 | Goal Management Tracking | 1 | 6 |
| HS08.2 | Goal Management Tracking | 1 | 0 |
| HS09.1 | Performance Mgmt Lock Out | 1 | 1 |
| HS10.1 | Direct Report Inquiry | 0 | 9 |
| HS10.2 | Direct Report Inquiry | 0 | 9 |
| HS16.1 | EMSS Length of Service Rules | 1 | 2 |
| HS17.1 | LP Balances on Paychecks | 1 | 7 |
| HS19.1 | Employee Paid Time Off Request Balances | 0 | 9 |
| HS19.2 | Employee Paid Time Off Request | 2 | 6 |
| HSGD.1 | Pay Step Selection Invoke | 0 | 2 |
| HSGH.1 | Schedule Selection Invoke | 0 | 1 |
| HTAP.1 | Job Code Select Invoke | 0 | 1 |
| HTRL.1 | Reason Class Selection Invoke | 0 | 1 |
| HVTB.1 | Vendor Selection Invoke | 0 | 1 |
| HWCA.1 | CA Workers Comp Select Invoke | 0 | 1 |
| HWCC.1 | Workers Comp Class Selection Invoke | 0 | 1 |
| HWSC.1 | Work Schedule Selection Invoke | 0 | 1 |
| LT01.1 | HRM Receiver Error View | 4 | 3 |
| LT10.1 | HRM Interface Data Items | 3 | 4 |
| LT11.1 | HRM Employee Interface | 2 | 2 |
| LT11.2 | HRM Position Interface | 1 | 0 |
| LT11.3 | HRM Job Code Interface | 1 | 0 |
| LT11.4 | HRM Supervisor Interface | 1 | 0 |
| LT11.5 | HRM User Field Interface | 14 | 30 |
| LT11.6 | HRM PosLevel/Work Assignment Mapping | 1 | 2 |
| LT11.7 | HRM Position User Field Interface | 1 | 7 |
| LT12.1 | HRM Dual Name Interface | 1 | 0 |
| LT13.1 | HRM Employee Interface History | 1 | 1 |
| LT13.2 | HRM Position Interface History | 1 | 0 |
| LT13.3 | HRM Job Code Interface History | 1 | 0 |
| LT13.4 | HRM Supervisor Interface History | 1 | 0 |
| LT13.5 | HRM User Field Interface History | 14 | 30 |
| LT13.6 | HRM Ethnicity Interface History | 1 | 5 |
| LT13.7 | HRM Pos UserFld Interface History | 1 | 7 |
| LT13.8 | HRM Dual Name Interface History | 1 | 0 |
| LT22.1 | HRM Employee Interface | 0 | 3 |
| LT22.2 | HRM Position Interface | 0 | 3 |
| LT22.3 | HRM Job Code Interface | 0 | 3 |
| LT22.4 | HRM Supervisor Interface | 0 | 3 |
| LT22.5 | HRM Employee User Field Interface | 0 | 9 |
| LT22.7 | HRM Position User Field Interface | 0 | 8 |
| LT28.1 | HRM Ethnicity Interface | 1 | 5 |
| PR21.1 | Pay Plan | 3 | 3 |
| PR21.2 | Pay Period Inquiry | 0 | 4 |
| PR21.3 | Pay Period Standard Cost Hours | 1 | 2 |
| PR21.4 | Nonstandard Pay and Work Period Entry | 3 | 3 |
| ZH10.1 | ZEECONTACT Maintenance | 1 | 2 |
| ZH12.1 | ZPENDPCP Maintenance | 1 | 4 |
| ZH12.2 | Zpendpcp Maint | 1 | 4 |
Batch programs (63)
| Program | Description | Updates | References |
|---|---|---|---|
| HR100 | Lawson Delivered Files Purge | 8 | 1 |
| HR105 | Employee Audit Report | 1 | 10 |
| HR125 | Employee Audit Purge | 4 | 6 |
| HR130 | Correspondence Purge | 2 | 1 |
| HR155 | Employee Group Update | 8 | 27 |
| HR156 | Employee Group Company Update | 8 | 27 |
| HR170 | Human Resource Writer Report Request | 2 | 104 |
| HR200 | Company Listing | 2 | 18 |
| HR201 | Process Level Listing | 1 | 9 |
| HR202 | Department Listing | 1 | 3 |
| HR203 | Employee Status Code Listing | 1 | 2 |
| HR204 | Human Resource Code Listing | 1 | 5 |
| HR205 | Job Class Listing | 1 | 2 |
| HR206 | Job Code Listing | 1 | 13 |
| HR207 | Supervisor Listing | 1 | 6 |
| HR208 | Processing Group Listing | 1 | 2 |
| HR209 | User Data Item Security Listing | 1 | 1 |
| HR210 | Data Item Attribute Listing | 1 | 7 |
| HR211 | Employee Listing | 1 | 33 |
| HR212 | Employee Security Listing | 1 | 3 |
| HR213 | Dependent Listing | 2 | 15 |
| HR217 | Work Eligibility Listing | 1 | 16 |
| HR220 | Additional Contact Listing | 1 | 12 |
| HR221 | Work Schedule Report | 1 | 6 |
| HR222 | Job Occupation Codes Listing | 1 | 7 |
| HR226 | Job Code User Field Listing | 1 | 2 |
| HR228 | Employee Ethnicity Listing | 1 | 10 |
| HR230 | Correspondence Tracking Listng | 1 | 2 |
| HR250 | Grant Management Pay Code Listing | 1 | 3 |
| HR255 | Employee Group Listing | 3 | 6 |
| HR403 | Country Specific Human Resource Code List | 1 | 2 |
| HR506 | Job Code Conversion | 14 | 21 |
| HR507 | Supervisor Conversion | 6 | 6 |
| HR511 | Employee Conversion | 58 | 82 |
| HR513 | Dependent Conversion | 9 | 20 |
| HR514 | Alternate Rates Conversion | 3 | 8 |
| HR515 | User Field Conversion | 19 | 38 |
| HR521 | Employee History Conversion | 2 | 10 |
| HR708 | Grant Management Company Updates | 2 | 0 |
| HR709 | Update Name Search Fields | 2 | 0 |
| HR710 | EEO-1 Job Category Update | 2 | 5 |
| HR711 | Update Employee Last4 SSN | 2 | 1 |
| HR751 | Workforce Management Extract | 2 | 3 |
| HR951 | Initial Interface Load | 1 | 3 |
| HS208 | Goal Management Report | 1 | 10 |
| HS703 | LPMH Employee and Job Profile Extract | 1 | 12 |
| HS705 | Emp Work Force Mgmt Extract | 1 | 11 |
| LT101 | HRM Receiver Update | 86 | 91 |
| LT103 | HRM RCVR History Change,Delete | 8 | 1 |
| LT111 | HRM Receiver Update | 87 | 93 |
| LT210 | HRM Interface Data Item Listing | 1 | 3 |
| LT213 | Interface Audit Export | 2 | 9 |
| PR221 | Pay Plan Listing | 1 | 4 |
| PR521 | Nonstandard Pay and Work Period CSV Load | 43 | 80 |
| ZH100 | Axiom Interfaces | 1 | 0 |
| ZH156 | Employee Group Company Update | 7 | 28 |
| ZH230 | PPH Big Bad Edit | 1 | 30 |
| ZH500 | Employee Data Extract | 2 | 26 |
| ZH510 | Update PCP from ZPENDPCP | 54 | 67 |
| ZH535 | HR11 Ben Date 3 Recalc-Update | 2 | 2 |
| ZH568 | Reed Employee Census Interface | 1 | 10 |
| ZH601 | VOE file to EquiFax Vendor | 1 | 0 |
| ZH602 | ACA files to Vendor HealthFx | 3 | 1 |
Other tables used by Human Resources programs (262)
ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ACCOMMIT, ACCOMMITX, ACTRLIMIT, ADDRDATA, APCOMPANY, APPJOBHIST, APPLICANT, APVENGROUP, APVENTABLE, ATCLASS, ATCLASSHDR, ATTENDCODE, ATTENDHIST, BANKACCT, BANKFILE, BENEFICRY, BENEFIT, BNACCOUNTS, BNBEN, BNCHANGE, BNCOMMENTS, BNCOMPANY, BNCOVDFT, BNCOVERAGE, BNCOVOPT, BNEMPEXER, BNEMPGRNT, BNGRPCHG, BNINVEST, BNPRMOPT, BNSIMDTL, BNSIMHDR, BNSTKGNT, BNTAEMPBAL, BNTRANS, BNWAIT, BONDBENSEQ, C6BANKM, C6EMDDMSTR, C6EMPADDRT, C6PRDDEF, C6PRDDTL, C6STATE, C6TAXGRP, CAVACMSTR, CMASSIGN, CMCHANGE, CMCONTRACT, CMCONTRULE, CMEMPTRANS, CMPAYCYC, CODA, COMPHIST, CONTRDETL, CUCODES, CWASSIGN, CWCHANGE, CWCONTRACT, CWCONTRULE, CWDISTRIB, CWEMPTRANS, DCCLASS, DEDCODE, DEPBEN, EMACHDEPST, EMDEDMASTR, EMDISTMAST, EMPACHDIST, EMPAUTO, EMPCODES, EMPCOMMENT, EMPFLEXDOL, EMPFLEXREM, EMPINVEST, EMPVISA, EMTAMASTR, EMTATRANS, EMTATRNSUM, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBTRANS, FBYETR, FLEXDOLLAR, FLEXPLAN, GLADDRESS, GLCHART, GLCHARTDTL, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLNAMES, GLSYSTEM, GMAUDIT, GMEFFORT, GMLABDIST, GMRETDIST, GMTRANEFRT, INEMPLOYEE, INSTCTRYCD, INTERVIEW, JOBAUTH, JOBRELATE, LPEMPLEAVE, LPLINK, LPPENDREQ, MILITARY, OCCURTYPE, ONETMDED, OSHA, PAACTREAS, PAAEEORACE, PAASSIGNED, PAATTRIB, PABUDGET, PACANHDR, PACLASSPOS, PACOMMENTS, PACOMPPROF, PACOURSE, PAEEEORACE, PAEMERGCNT, PAEMPAPP, PAEMPAPTST, PAEMPCOSTS, PAEMPTRACK, PAENCUMBER, PAERECRUIT, PAFOLLOWUP, PAGRDI, PAGRDISTEP, PAINCICOST, PAINSTRUCT, PAJOBINTRS, PAJOBREQ, PAMEDICAL, PAOFFLANG, PAPEPAUDIT, PAPOSCHG, PAPOSERR, PAPOSITION, PAPOSRULE, PAPREREQ, PAPROFILE, PAPROMAP, PAREGISTER, PAREQAPP, PAREQCOST, PAREQLOG, PAREQOFFER, PARTBEN, PARTICIPNT, PATESTOVER, PATRACK, PATRNHIST, PATSTRESLT, PATSTSETUP, PAYCLASS, PAYDEDUCTN, PAYMASTR, PAYSUMGRP, PERSACTHST, PERSACTION, PERSACTYPE, PLAN, PLANCLASS, PLANMASTER, PRBATCH, PRBUSGRP, PRCHECK, PRDEDACCTS, PRDEDDTL, PRDISTRIB, PREMDEDHST, PREMIUM, PREMPGARN, PREMPSTATE, PRHOURS, PRMONITOR, PROTPAYPRD, PROTWRKPRD, PROVERTIME, PRPAYCODE, PRPENDTIME, PRPENPAY, PRPROVINCE, PRQCENTGRP, PRQUALIFY, PRRATES, PRREGDICT, PRREGPARM, PRSHIFTHDR, PRSHIFTTBL, PRSTATE, PRTAXAUTH, PRTAXCAT, PRTAXID, PRTAXLEVY, PRTAXLOC, PRTIME, PRWEEKS, PWEMPLY, PWSUPER, QUARTDED, QUARTWAGE, REFERENC, REQCODE, RESTRANS, REVGOALDTL, REVIEW, SBBEN, STANDTIME, SUBCKPOINT, SYSTEMCODE, TAACCRUAL, TACALC, TAEEGROUP, TAEEMASTER, TAELIGIBLE, TAEMPSERV, TAEMPTRANS, TAENROLL, TAFORMULAS, TAFORMULAX, TAGENLEDGR, TALIMIT, TALOSHRS, TAPAYROLL, TAPLAN, TAREASCLSS, TAREASCODE, TAREASONS, TASERVCLSS, TASERVCODE, TASERVICE, TASERVRULE, TASTRUCTUR, TATABLE, TATABLEX, TAXGROUP, TAXIDEXMP, TIMERECORD, TIPPAY, TREXCEPT, TRSGBLCK, VESTHOURS, VESTSCHDDT, WCCLASS, WCCLASSOVR, WFSETUP, ZACTRLIMIT