PREMPSTATE FILE
Employee State
Contains information relative to specific states that is used for quarterly
reporting.
REFERENCED BY
HR170 HR211 HR70.1 PR13.1 PR292 PR296
PR297 PR298
UPDATED BY
HR16.2 HR16.3 HR16.4 HR16.5 HR16.6 HR16.7
HR16.8 HR17.1 HR17.2 HR17.3 HR17.4 HR17.5
HR17.6 HR17.7 HR17.8 HR17.9 HR18.1 HR18.2
HR18.3 HR18.4 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PES-COMPANY Numeric 4 HR16.2 HR16.3
Company The company number represents an HR16.4 HR16.5
established company and is entered on HR16.6 HR16.7
all function codes. HR16.8 HR17.1
HR17.2 HR17.3
HR17.4 HR17.5
HR17.6 HR17.7
HR17.8 HR17.9
HR18.1 HR18.2
HR18.3 HR18.4
PES-EMPLOYEE Numeric 9 HR16.2 HR16.3
Employee Contains the employee number. Each HR16.4 HR16.5
person employed by the company is HR16.6 HR16.7
assigned a unique number. The system HR16.8 HR17.1
uses the employee number to correlate HR17.2 HR17.3
all of the information related to that HR17.4 HR17.5
person. HR17.6 HR17.7
HR17.8 HR17.9
HR18.1 HR18.2
HR18.3 HR18.4
PES-STATE Alpha 2 HR16.2 HR16.3
State or Province This field contains the two-character HR16.4 HR16.5
state code of the address. HR16.6 HR16.7
HR16.8 HR17.1
HR17.2 HR17.3
HR17.4 HR17.5
HR17.6 HR17.7
HR17.8 HR17.9
HR18.1 HR18.2
HR18.3 HR18.4
PES-PRIV-DIS-PLAN Alpha 1 HR17.7
Priv Dis Plan Contains the value that indicates if
the employer offers a private disability
plan.
PES-DIS-PLAN-NBR Alpha 14 HR17.7
Dis Plan Nbr Contains the value that identifies the
disability plan assigned to the
employee.
PES-OCC-CODE Alpha 4 HR16.2 HR17.5
Occ Code Contains the employee's occupational
code.
PES-GEO-AREA-CODE Alpha 2 HR16.2 HR16.7
Geo Area Code Contains the geographic area code that HR18.1 HR18.3
identifies where the employee works.
PES-BRANCH-CODE Alpha 3 HR16.3 HR16.5
Branch Code Contains the branch code that HR17.1 HR17.2
identifies the location where the HR17.4 HR17.8
employee works.
PES-SEASONAL-CODE Alpha 2 HR16.4 HR16.6
Seasonal Code Contains the state-defined code that HR17.1 HR17.6
indicates if the employee has in-season
or out-of-season wages in the quarter.
PES-WAGE-PLAN-CODE Alpha 1 HR16.5 HR18.4
Wage Plan Code Contains the value that identifies the
wage plan code with which the employee
is associated.
PES-PLANT-CODE Alpha 15 HR16.8
Plant Code Contains the plant location numbers
used to report Illinois state
unemployment insurance wages.
PES-ENTITY-CODE Numeric 2 HR17.3
Entity Code Contains the 2-digit code that
represents a location (filing entity).
PES-ESTAB-REPORT Alpha 1 HR17.5
Estab Report Contains the establishment number (the
last digit of the employer's account
number) for employers reporting by this
method.
PES-ER-HLTH-INS Numeric 1 HR17.9
Er Hlth Ins Contains the numeric value that
identifies the employer's health
insurance plan.
PES-EE-HLTH-INS Numeric 1 HR17.9
Ee Hlth Ins Contains the numeric value that
identifies the type of health insurance
the employee has.
PES-UNIT-NUMBER Numeric 5 HR18.2
Unit Number Contains the unit number defined for
the employee.
PREMPSTATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PESSET1 COMPANY HR11.1 HR16.1
EMPLOYEE HR16.2 HR16.3
STATE HR16.4 HR16.5
HR16.6 HR16.7
HR16.8 HR17.1
HR17.2 HR17.3
HR17.4 HR17.5
HR17.6 HR17.7
HR17.8 HR17.9
HR170 HR18.1
HR18.2 HR18.3
HR18.4 HR211
HR70.1 PA115
PR13.1 PR292
PR296 PR297
...
PREMPSTATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PES-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PES-COMPANY -> EMP-COMPANY
PES-EMPLOYEE -> EMP-EMPLOYEE
State PRSTATE Required
PES-STATE -> PSA-STATE
|