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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PESSET1COMPANY, EMPLOYEE, STATEPrimaryHR11.1, HR16.1, HR16.2, HR16.3, HR16.4, HR16.5, HR16.6, HR16.7 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPES-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredPES-COMPANY → EMP-COMPANY, PES-EMPLOYEE → EMP-EMPLOYEE
StatePRSTATERequiredPES-STATE → PSA-STATE

Programs

Updated by (23)

Referenced by (9)