PREMPSTATE

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 PR299 ZP296


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.4 HR18.5 HR18.6 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PES-COMPANY
Element: Company Hr		Numeric 4
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.4 HR18.5
HR18.6
PES-EMPLOYEE
Element: Employee		Numeric 9
Contains 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
HR17.2 HR17.3
HR17.4 HR17.5
HR17.6 HR17.7
HR17.8 HR17.9
HR18.1 HR18.2
HR18.4 HR18.5
HR18.6
PES-STATE
Element: State		Alpha 2
This 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
HR17.2 HR17.3
HR17.4 HR17.5
HR17.6 HR17.7
HR17.8 HR17.9
HR18.1 HR18.2
HR18.4 HR18.5
HR18.6
PES-PRIV-DIS-PLAN
Element: Priv Dis Plan		Alpha 1
Contains the value that indicates if the employer offers a private disability plan.
HR17.7
PES-DIS-PLAN-NBR
Element: Dis Plan Nbr		Alpha 14
Contains the value that identifies the disability plan assigned to the employee.
HR16.2 HR17.7
PES-OCC-CODE
Element: Occ Code		Alpha 6
Contains the employee's occupational code.
HR16.2 HR17.5
PES-GEO-AREA-CODE
Element: Geo Area Code		Alpha 2
Contains the geographic area code that identifies where the employee works.
HR16.2 HR16.4
HR16.7 HR18.1
PES-BRANCH-CODE
Element: Branch Code		Alpha 3
Contains 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
Element: Seasonal Code		Alpha 2
Contains 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
Element: Wage Plan Code		Alpha 1
Contains 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
Element: Plant Code		Alpha 15
Contains the plant location numbers used to report Illinois state unemployment insurance wages.
HR16.8
PES-ENTITY-CODE
Element: Entity Code		Numeric 2
Contains the 2-digit code that represents a location (filing entity).
HR17.3 HR18.4
PR292
PES-ESTAB-REPORT
Element: Estab Report		Alpha 1
Contains the establishment number (the last digit of the employer's account number) for employers reporting by this method.
PES-ER-HLTH-INS
Element: Er Hlth Ins		Numeric 1
Contains the numeric value that identifies the employer's health insurance plan.
HR17.9
PES-EE-HLTH-INS
Element: Ee Hlth Ins		Numeric 1
Contains the numeric value that identifies the type of health insurance the employee has.
HR17.9
PES-UNIT-NUMBER
Element: Unit Number		Numeric 5
Contains the unit number defined for the employee.
HR17.2 HR17.3
HR18.2


PREMPSTATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PESSET1 COMPANY
EMPLOYEE
STATE
...
HR11.1 HR16.1
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
HR170 HR18.1
HR18.2 HR18.4
HR18.5 HR18.6
HR211 HR70.1
PA115 PR13.1
PR292 PR296


PREMPSTATE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:30:34 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.