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 3
Number of Registered UC Student Units 135 3
Senior Management Severance Pay Exception Indicator 138 1
Senior Management Severance Override Contribution Rate 139 1
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
Supplemental Life Insurance Coverage Effective Date 310 6
Supplemental Life Insurance Plan Code 316 1
Supplemental 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
Basic Life Insurance Effective Date 333 6
Filler 339 5
Primary BELI Status Qualification Code 344 2
Primary BELI Status Qualification Effective Date 346 6
Secondary BELI Status Qualification Code 352 2
Secondary BELI Status Qualification Effective Date 354 6
Temporary Disability Insurance Code-UC Paid 360 1
Medical Contribution Base-Current Year 361 3
Medical Contribution Base-Next Year 364 3
START Reduction Percent 367 2
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
Recently Separated Veteran Date 420 4
Basic Life Insurance 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-Total 499 9
Hours Toward Benefits Eligibility-Total 508 9
Last Day on Pay Status 517 6
SPP-Total Interest-Sr Mgmt 523 9
SPP-Total Contribution-Interest Posted-Sr Mgmt 532 9
SPP-Changed Date-Sr Mgmt 541 6
SPP X Month Contribution-No Interest Paid-Sr Mgmt 547 9
SPP Current Month Contribution 556 9
SPP-Total Interest-HS 565 9
SPP-Total Contribution-Interest Posted-HS 574 9
SPP-Changed Date-HS 583 6
SPP X Month Contribution-No Interest Paid-HS 589 9
HSPP Current Month Contributions 598 9
Supplemental Disability Indicator 607 1
Supplemental Disability Waiting Period 608 3
Supplemental Disability Salary Base 611 5
Supplemental Disability Coverage Eff Date 616 6
Title Code - Primary 622 4
START Begin Date 626 6
START End Date 632 6
Short Term Disability Ins Cov Eff Date 638 6
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
Health Care Reimbursement Account Indicator 721 1
HCRA Annual Amount 722 5
HCRA Termination Date 727 6
HCRA Year-to-Date Deductions 733 9
Filler 742 19