CPS Employee File

Data Element Name Location Length
     
Location Code 1 1 2
Employee ID Number 3 9
Employee Name 12 35
Permanent Address Line 1 47 30
Permanent Address Line 2 77 30
Permanent Address City 107 21
Permanent Address State 128 2
Permanent Address Zip Code 130 5
Number of Registered UC Units 135 3
Filler 138 2
Home Address Disclosure Code 140 1
Social Security Number 141 9
Sex Code 150 1
Date of Birth 151 6
Citizenship Status Code 157 1
Ethnic Origin Code 158 2
Retirement System Code 160 1
FICA Eligibility Code 161 1
Unemployment Insurance Elig Code 162 1
UC Student Status Code 163 1
Previous Employee ID Number 164 9
Prior Service Credit Months 173 3
Filler 176 2
Employee Organization Code1 178 4
Employee Organization Code 2 182 4
Employee Organization Code 3 186 4
Employee Organization Code 4 190 4
Employee Relations Position Type Code 194 1
Employee Relations Confidential Info Code 195 1
Date of Most Recent Hire 196 6
Next Salary Review Date 202 4
Next Salary Review Type 206 1
Employment Status Code 207 1
Visa Type Code 208 2
Merit Percent 210 4
Separation Date 214 6
Separation Reason 220 2
Leave of Absence Begin Date 222 6
Leave of Absence Return Date 228 6
Leave of Absence Type 234 2
DCP Fund Selection Code 236 1
Sick Leave Hours Used 237 4
Sick Leave Hours Balance 241 5
Retirement/FICA Derivation Indicator 246 1
Vacation Leave Hours Used 247 3
Vacation Leave Hours Balance 250 3
Vacation Leave Hours Not Accumulated (Lost) 253 4
Compensatory Time Hours Used 257 3
Compensatory Time Hours Balance 260 4
Overtime Hours Paid 264 5
Overtime Hours Worked 269 5
Overtime Hours Worked Year-to-date 274 6
Monthly Earnings Indicator - January 280 1
Monthly Earnings Indicator - February 281 1
Monthly Earnings Indicator - March 282 1
Monthly Earnings Indicator - April 283 1
Monthly Earnings Indicator - May 284 1
Monthly Earnings Indicator - June 285 1
Monthly Earnings Indicator - July 286 1
Monthly Earnings Indicator - August 287 1
Monthly Earnings Indicator - September 288 1
Monthly Earnings Indicator - October 289 1
Monthly Earnings Indicator - November 290 1
Monthly Earnings Indicator - December 291 1
AD&D Coverage Effective Date 292 6
AD&D Coverage Code 298 1
AD&D Principal Sum 299 3
Dental Plan Coverage Effective Date 302 6
Filler 308 2
Life Insurance Coverage Effective Date 310 6
Life Insurance Plan Code 316 1
Life Insurance Salary Base 317 3
Dependent Life Insurance Plan Code 320 1
Medical Plan Coverage Effective Date 321 6
Medical Plan Code 327 2
Filler 329 1
Medical Plan Coverage Code 330 3
UC Paid Life Insurance Effective Date 333 6
Filler 339 5
Primary BELI Status Qualification Code 344 2
Primary BELI Status Qualification Date 346 6
Secondary BELI Status Qualification Code 352 2
Secondary BELI Status Qualification Date 354 6
Temporary Disability Insurance Code-UC Paid 360 1
Filler 361 8
War/Campaign/Expedition Veteran Status Code 369 1
Vietnam Era Veteran Status Code 370 1
Veteran Disability Status Code 371 1
Handicapped Status Code 372 1
Insurance Reduction Code 373 1
Employee Unit Code 374 2
Employee Special Handling Code 376 1
Employee Distribution Unit Code 377 1
Employee Representation Code 378 1
Executive Life Insurance Effective Date 379 6
Original Hire Date 385 6
Dependent Care Salary Reduction Code 391 1
Filler 392 8
FCP/BCS Employee Selection Flag 400 1
Dental Plan Code 401 2
Dental Plan Coverage Code 403 3
Marital Status Code - Federal Tax 406 1
Marital Status Code - State Tax 407 1
Filler 408 1
Vision Plan Coverage Effective Date 409 6
Vision Plan Code 415 2
Vision Plan Coverage Code 417 3
Filler 420 4
Life Insurance Salary Base - UC Paid 424 3
UCRS Voluntary Short Term Loan Plan 427 1
UCRS Voluntary Long Term Loan Plan 428 1
Legal Plan Code 429 2
Legal Plan Coverage Code 431 3
Legal Plan Coverage Effective Date 434 6
Federal Tax Withholding Allowances 440 3
State Tax Personal Withholding Allowances 443 3
State Tax Itemized Deduction Withholding Allow. 446 3
Executive Life Insurance Indicator 449 1
Executive Life Insurance Salary Base 450 3
Benefits Eligibility Level Indicator - Assigned 453 1
Benefits Eligibility Level Indicator - Derived 454 1
Benefits Eligibility Level Indicator Conflict Date 455 4
Medical Insurance Opt Out Code 459 1
Dental Insurance Opt Out Code 460 1
Vision Insurance Opt Out Code 461 1
Average Hours Worked Per Week 462 4
Dependent Life Insurance Coverage Eff Date 466 6
Total Gross Year To Date 472 9
Taxable Gross Year to Date 481 9
Depcare Deduction Year To Date 490 9
Hours Toward Career Status Eligibility 499 9
Hours Toward Benefits Eligibility 508 9
Last Day on Pay Status 517 6
ESPP Contributions - Interest Paid 523 9
ESPP Total Interest 532 9
ESPP Interest Thru Date 541 6
ESPP Contributions - No Interest Paid 547 9
ESPP Current Month Contributions 556 9
HSSPP Contributions - Interest Paid 565 9
HSSPP Total Interest 574 9
HSSPP Interest Thru Date 583 6
HSSPP Contributions - No Interest Paid 589 9
HSSPP Current Month Contributions 598 9
Employee Paid Disability Insurance Plan Code 607 1
Employee Paid Disability Waiting Period 608 3
Employee Paid Disability Salary Base 611 5
Employee Paid Disability Coverage Eff Date 616 6
Title Code - Primary 622 4
Filler 626 12
Temp Disability Ins - UC Paid - Cov Eff Date 638 6
Fiscal Year-to-Date Taxable Gross 644 9
Home Department Code 653 6
Home Department Name 659 30
Country of Residency Code 689 2
Country of Residency Name 691 30
Filler 721 40