PREMPSTATE – Employee State

System
Payroll (PR)
Prefix
PES
Primary key
COMPANY, EMPLOYEE, STATE
Fields
16
Updated by
23 programs
Referenced by
9 programs

PREMPSTATE is the Employee State table in Lawson Payroll (prefix PES). It is indexed by COMPANY, EMPLOYEE, STATE (PESSET1). It is related 1:1 to PRSYSTEM, EMPLOYEE and PRSTATE. It is updated by HR11.1, HR16.2, HR16.3, HR16.4, HR16.5, HR16.6, HR16.7, HR16.8 and 15 more and referenced by HR170, HR211, HR70.1, PR13.1, PR292, PR296, PR297, PR299 and 1 more. The table has 16 fields, 1 index and 3 documented relations.

About PREMPSTATE

Contains information relative to specific states that is used for quarterly reporting.

Fields (16)

Column = COBOL field name without the PES- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PES-COMPANY PK
COMPANY		Numeric 4—HR16.2, HR16.3, HR16.4, HR16.5, HR16.6, HR16.7, HR16.8, HR17.1 +13 more
#PES-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.HR16.2, HR16.3, HR16.4, HR16.5, HR16.6, HR16.7, HR16.8, HR17.1 +13 more
#PES-STATE PK
STATE		Alpha 2This field contains the two-character state code of the address.HR16.2, HR16.3, HR16.4, HR16.5, HR16.6, HR16.7, HR16.8, HR17.1 +13 more
#PES-PRIV-DIS-PLAN
PRIV_DIS_PLAN		Alpha 1Contains the value that indicates if the employer offers a private disability plan.HR17.7
#PES-DIS-PLAN-NBR
DIS_PLAN_NBR		Alpha 14Contains the value that identifies the disability plan assigned to the employee.HR16.2, HR17.7
#PES-OCC-CODE
OCC_CODE		Alpha 6Contains the employee's occupational code.HR16.2, HR17.5
#PES-GEO-AREA-CODE
GEO_AREA_CODE		Alpha 2Contains the geographic area code that identifies where the employee works.HR16.2, HR16.4, HR16.7, HR18.1
#PES-BRANCH-CODE
BRANCH_CODE		Alpha 3Contains the branch code that identifies the location where the employee works.HR16.3, HR16.5, HR16.6, HR17.1, HR17.4, HR17.8
#PES-SEASONAL-CODE
SEASONAL_CODE		Alpha 2Contains the state-defined code that indicates if the employee has in-season or out-of-season wages in the quarter.HR16.4, HR16.6, HR17.1, HR17.6
#PES-WAGE-PLAN-CODE
WAGE_PLAN_CODE		Alpha 1Contains the value that identifies the wage plan code with which the employee is associated.HR16.5, HR17.3, HR17.4, HR18.4, HR18.5, HR18.6
#PES-PLANT-CODE
PLANT_CODE		Alpha 15Contains the plant location numbers used to report Illinois state unemployment insurance wages.HR16.8
#PES-ENTITY-CODE
ENTITY_CODE		Numeric 2Contains the 2-digit code that represents a location (filing entity).HR17.3, HR18.4, PR292
#PES-ESTAB-REPORT
ESTAB_REPORT		Alpha 1Contains the establishment number (the last digit of the employer's account number) for employers reporting by this method.—
#PES-ER-HLTH-INS
ER_HLTH_INS		Numeric 1Contains the numeric value that identifies the employer's health insurance plan.HR17.9
#PES-EE-HLTH-INS
EE_HLTH_INS		Numeric 1Contains the numeric value that identifies the type of health insurance the employee has.HR17.9
#PES-UNIT-NUMBER
UNIT_NUMBER		Numeric 5Contains the unit number defined for the employee.HR17.2, HR17.3, HR18.2

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PESSET1
  1. COMPANY
  2. EMPLOYEE
  3. STATE
PrimaryHR11.1, HR16.1, HR16.2, HR16.3, HR16.4, HR16.5, HR16.6, HR16.7 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPRSTATEPREMPSTATE

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PES-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PES-COMPANY→EMP-COMPANY
PES-EMPLOYEE→EMP-EMPLOYEE
StatePRSTATERequired
PES-STATE→PSA-STATE

Programs

Updated by (23)

Referenced by (9)