Multi-Purpose Payroll Interface

Multi-Purpose Payroll Interface

Field Name / Position / Source of Data / Size / Required for newly eligible / Required for deduction data / Required for retirement system enrollments/
terminations / File from SHBP to Locations / Comments
Payroll location / PLINPLOC / 001-005 / 5 / Y / Y / Y / Y / SHBP Payroll Location Number
Record Type / PLINTYPE / 006-009 / 4 / Y / Y / Y / Y / See attached listing of record types
Employee SSN / PLINSSNO / 010-018 / 9 / Y / Y / Y / Y
Employee ID / PLINEMID / 019-030 / 12 / Y / Optional employee ID from payroll system
Last name / PLINLNAM / 031-065 / 35 / Y / Y / Y / Y
First name / PLINFNAM / 066-090 / 25 / Y / Y / Y / Y
Middle name / PLINMNAM / 091-115 / 25 / Y
Prefix / PLINPNAM / 116-125 / 10 / Y
Suffix / PLINSNAM / 126-135 / 10 / Y
Street Address 1 / PLINADD1 / 136-190 / 55 / Y / Y
Street Address 2 / PLINADD2 / 191-245 / 55 / Y / Y
City / PLINCITY / 246-275 / 30 / Y / Y
State / PLINUSST / 276-277 / 2 / Y / Y
Postal Code / PLINZIPC / 278-292 / 15 / Y / Y
County of residence / PLINCNTR / 293-307 / 15 / Y / Y / Y / 001 - 159 and 160 (out of state) or county name
Country / PLINCTRY / 308-310 / 3 / Y / default to USA
Phone number / PLINPHON / 311-330 / 20 / Y
Date of birth / PLINDTOB / 331-338 / 8 / Y / Y / CCYYMMDD
Sex / PLINSEXX / 339 / 1 / Y / Y / F or M
Unit/School code / PLINUNSC / 340-354 / 15 / Y / Y / Y / Left justified
County of employment / PLINCNTE / 355-369 / 15 / Y / Y / 001 - 159 and 160 (out of state) or county name
SHBP eligible / PLINSHBP / 370 / 1 / Y / Y or N
Retirement system / PLINRETS / 371-375 / 5 / 14990 -ERS, 89929 or 89990 - TRS, 89409 - PSERS, 14960 - LRS, 14930 - SCRS, other
Date of employment/eligibility / PLINDTEM / 376-383 / 8 / Y / CCYYMMDD
Deduction date / PLINDEDT / 384-391 / 8 / Y / Y / CCYYMMDD
Coverage effective date / PLINEFDT / 392-399 / 8 / Y / Y / Y / Y / CCYYMMDD
Coverage termination date / PLINTEDT / 400-407 / 8 / Y / CCYYMMDD
Option / PLINOPTN / 408-409 / 2 / Y / Y / Y / NC – No coverage
See Option Spreadsheet
Type/Tier / PLINCVTP / 410-411 / 2 / Y / Y / Y / See Tier Spreadsheet
Premium / PLINPREM / 412-418 / S9(5)V99 / Y / Y / Y
Deduction amount / PLINDEDA / 419-425 / S9(5)V99 / Y / Y
Subsidized amount / PLINSUBA / 426-432 / S9(5)V99 / Y / County subsidy
Date of death / PLINDCDT / 433-440 / 8 / Y if record type is DCSD / CCYYMMDD
Last date of employment / PLINLEDT / 441-448 / 8 / Y if record type is a termination code / CCYYMMDD
Insufficient earnings for deduction / PLININSI / 449 / 1 / Y / Y / Y or N
Continuing benefit indicator / PLINCBEI / 450 / 1 / Y if retirement location / currently for use by ERS only
SSN of retiree (if ENSD or ENSS) / PLINSSRE / 451-459 / 9 / Y if retirement location / currently for use by ERS only
Monthly State based salary/GHI gross / PLINSBSA / 460-466 / S9(5)V99 / Y
To location / PLINTOPL / 467-471 / 5 / used ONLY when there is a mass location change
Total Record Length - 471
Record type
New employee/hire / NEMP
Newly eligible / NELG
Enroll employee / ENEE
Return from Leave without Pay / ENRE
Transfer in / ENTF
Enrollment into retirement / ENRT
Surviving Spouse enrollment / ENSS
Surviving dependent enrollment / ENSD
Termination
Deceased / DCSD
Discontinue (pend for active - process for retiree / DISC
Laid off / LOFF
To LWOP / LWOP
Retired / RETR
Reduced hours / REHR
Terminated employment / TERM
Transferred to new location / TRAN
Change option / COPT
Change tier / CTIE
Demographic update / MISC
SHBP List / SHBP
Mass Transfer to new location / MASS
Deduction Data Interface / DEDI
Change File Interface / CHGI
Unit/School Code Interface / UNSC
Payroll Location Eligible Employees / PLEE