(Note to Print, select landscape page 11 x 8 1/2 with .25 top, left and right margins)

EDB DATA ELEMENT/SCREEN CROSS REFERENCE TABLE

SCREEN LABEL DE # DATA DICTIONARY NAME DATA VALUES/COMMENTS SCREEN
*
N/A
N/A
 Indicates oldest month of accumulated hours IHRS
%
% Full
2012
Percent Full Time
 Percent of Time an employee is expected to work in an appointment. EAPP
EAPC
IAPS
IAPT
IAPP
1MO OLD RED AMT
5526
1 Month Old Reduction Amount
 Portion of the retirement gross exempt from employee retirement contributions for the pay period ending one month ago. INBI
1MO OLD RTR GRS
5521
1 Month Old Retirement Gross
 Total gross earnings subject to employee retirement contributions for the pay period ending one month ago. INBI
1MO OLD RTR RTE
5531
1 Month Old Retirement Rate
 Used to calculate employees' retirement contribution one month ago. INBI
1MTH DCP RATE
5511
1 Month Old DCP Rate
 Used to calculate the Defined Contribution Plan (DCP) portion of an employee's retirement contribution one month ago. INBI
2MO OLD RED AMT
5527
2 Months Old Reduction Amount
 Portion of the retirement gross exempt from employee retirement contributions for the pay period ending two months ago. INBI
2MO OLD RTR GRS
5522
2 Months Old Retirement Gross
 Total gross earnings subject to employee retirement contributions for the pay period ending two months ago. INBI
2MO OLD RTR RTE
5532
2 Months Old Retirement Rate
 Used to calculate employees' retirement contribution two months ago. INBI
2MTH DCP RATE
5514
2 Months Old DCP Rate
 Used to calculate the DCP portion of an employee's retirement contribution two months ago. INBI
3MO OLD RED AMT
5528
3 Months Old Reduction Amount
 Portion of the retirement gross exempt from employee retirement contributions for the pay period ending three months ago. INBI
3MO OLD RTR GRS
5523
3 Months Old Retirement Gross
 Total gross earnings subject to employee retirement contributions for the pay period ending three months ago. INBI
3MO OLD RTR RTE
5533
3 Months Old Retirement Rate
 Used to calculate employees retirement contribution three months ago. INBI
3MTH DCP RATE
5515
3 Months Old DCP Rate
 Used to calculate the DCP portion of an employee's retirement contribution three months ago. INBI
4MO OLD RED AMT
5529
4 Months Old Reduction Amount
 Portion of the retirement gross exempt from employee retirement contributions for the pay period ending four months ago. INBI
4MO OLD RTR GRS
5524
4 Months Old Retirement Gross
 Total gross earnings subject to employee retirement contributions for the pay period ending four months ago. INBI
4MO OLD RTR RTE
5534
4 Months Old Retirement Rate
 Used to calculate employees' retirement contribution four months ago. INBI
4MTH DCP RATE
5542
4 Months Old DCP Rate
 Used to calculate the DCP portion of an employee's retirement contribution four months ago. INBI
Accrl Key
8101
Leave History Accrual Key
 PBBRSD where:
P = Personnel Program Code
BB = Bargaining Unit Code
R = Representation Code
S = Special Handling Code
D = Distribution Unit Code		 ILAH
Accrued Hours: Sick
8106
Leave History Sick Hours Accrued
 Leave history of the sick hours accrued per accrual period. ILAH
Accrued Hours: Vac
8105
Leave History Vacation Hours Accrued
 Leave history of the vacation hours accrued per accrual period. ILAH
Actions

Appt Actions

Dist Actions


2033

2047


Appointment Action

Distribution Action
 01 Hire
02 Rehire
04 Merit Increase (On-Line)
06 Separation
07 Leave With Pay
08 Leave Without Pay
09 Change in Leave Return Date
10 Promotion
11 Demotion
12 Lateral Transfer
13 Additional Employment
14 Academic Status Change
15 Visa Status Change
16 Change in Percent Full Time
17 Appointment Renewal
18 Change in Fund Source
19 Change in Home Department
20 Other (Employee Action)
21 Intercampus Action
23 Change in BELI - Assigned
24 Change in Leave Plan
25 Mass Title Code Change
26 Add Stipend
27 System Merit Increase (batch)
28 Range Adjustment (batch)
30 Mass Purge (batch)
33 Manual Range Adjustment (On-Line)
34 Terminal Appointment
35 Transfer - Campus/UCOP
36 Transfer - Campus/Lab/State
37 Reclassification Downward
38 Reclassification Upward
39 Reclassification Lateral
40 Other Appointment Action
41 Six Month Increase
42 Exceptional/Equity Increase
43 Change in Rate - Other
44 Limited Increase
45 Change in Negotiated Salary (HS Comp)
46 Change in Percent Full Time
47 Mass Account/Fund Change (batch)
48 Add Stipend
49 Mass Distribution Unit Change (batch)
50 Other Distribution Action
51 Transfer To/From Med Center
52 Limited to Career		 EAPP
EAPC
AD&D Coverage
0281
Accidental Death & Dismemberment Coverage Code
 S = Self Only
F = Family coverage (Employee, spouse and eligible children)
M = Modified Family (Employee and eligible children)		 EINS
IINS
AD&D Cov Eff Date
AD&D Eff Date
0282
Accidental Death & Dismemberment Coverage Effective Date
   EINS
IINS
AD&D Empl Cost
N/A
N/A
 The employee's cost for AD&D insurance per month. IINS
AD&D Prin Sum
0280
AD&D Principal Sum
 Expressed in thousands of coverage EINS
IINS
Address
Addr
1107
1207
1307
1407
Bond Owner Address-Street (Part 1)
 The Bond Owner's Address. EBND
IBND
1108
1208
1308
1408
Bond Owner Address-Street (Part 2)
1109
1209
1309
1409
Bond Owner Address-City
1110
1210
1310
1410
Bond Owner Address-State
1111
1211
1311
1411
Bond Owner Address-
Postal Code-Zip
Age 1/1
0254
Age on January 1
 Employee age as of January 1-used for age based premium calculations. IINS
Alt Tax Treaty Income Code
1171
Alternate Tax Treaty Income Code
 18 = Compensation for teaching
19 = Compensation for research		 EALN
IALN
Alt YTD Tax Treaty Grs
5538
YTD Alternate Tax Treaty Gross
 Field is reserved for future use. IALN
INBI
Alternate Dept Code
0235
Alternate Department Code
 The department code of a department requesting access to an employee's record. See Campus Organizational Hierarchy table at: http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity. EPER
Amount/Value
N/A
N/A
 Dollar or % amount of deduction as applicable;
blank = dollar amount
PCT = Percentage based deduction
PREP = Prepayment dollar amount
CALC = Calculation based on earnings
PARM = Dollar amount taken from the parameter table		 IDED
IRET
Ann/Hr Rt
2014
Appointment Pay Rate
 The employee's pay rate expressed in an annual or hourly amount. EAPP
EAPC
IAPP
IAPS
IAPT
Anticipated Ret Date
0765
Anticipated Retirement Date
 The date an employee is expected to retire. ESEP
IGEN
Appt
2001
Appointment Number
 This is the Appointment Number identifying an employee's specified appointment. EAPP
EAPC
IAPT
IAPS
IAPP
Appt Begin

Begin Dt
2002
Appointment Begin Date
EAPP
EAPC
IAPP
IAPS
IAPT
Appt End

End Dt
2003
Appointment End Date
EAPP
EAPC
IAPT
IAPS
IAPP
Assigned BELI
Asgn BELI

Derived BELI

Effective Date
0360


0375

0341
Benefits Eligibility Indicator (Assigned)


Derived BELI

BELI Effective Date
 1 = Career Benefits
2 = Limited Benefits, No Ret, 12+ mths appt
3 = Limited Benefits, No Ret, < 12 mths appt
4 = Core Benefits Only
5 = No Benefits
6 = No Benefits, Casual Restricted/Student
7 = No Benefits, Per Diem
8 = No Benefits, By Agreement
9 = No Benefits, Without Salary
? = Separated employee, system derived
U = Average Hours = 0, with appointments
X = Average Hours = 0, no appointments		 EINS
EPER
IINS
IGEN
Auto/Homeowners Ded Ind
0185
Auto/Homeowners Insurance Deduction Indicator
 Y = Process deductions
N = Do not process deductions
blank = Process deductions		 EMIS
Avg Hr/Wk
5132
Average Hours Week
 The number of average hours on pay status per week, excluding overtime and differentials. IHRS
INBI
Award Amount
0746
Award Amount
 The dollar amount of staff award received by the employee. EAWD
Award Date
0744
Award Date
 Effective date of award. EAWD
Award Source
0745
Award Source
 The fund number of the FAU supporting a staff award received by the employee. EAWD
Award Type
0743
Award Type Code
 The type of award received by the employee.
EIA = Executive Incentive Award
IAP = Staff Incentive Award Program (cash award)
MIA = Management Incentive Award (cash award)
PDA = Professional Development Award
LAA = Local Academic Award
LEA = Local Staff Employee Award
SPA = Staff Special Performance Award		 EAWD
Background Check Code
0740
Background Check Code
 The type of background check conducted.
01 = Previous employer's reference
02 = Criminal conviction record check
03 = Financial disclosure
04 = Security clearance
05 = Police Officer background check
06 = Professional license/certificate verification
07 = Educational degree check
08 = DMV driving record check		 EBCC
Background Check Date
0741
Background Check Date
 Date background check conducted. EBCC
Balance Type
N/A
N/A
 Gross-to-Net Balance Type IDED
Basis/
Paid Over

Bas/Pd Ovr
2010/
2011
Appointment Basis Code/
Paid Over Code
 9 = 9 months
10 = 10 months
11 = 11 months
12 = 12 months		 EAPP
EAPC
IAPP
IAPT
BELI Status Qualifiers:
Primary
Date
Secondary
Date
Qual
0240
0241
0242
0243
Primary BELI Status Qualifier Code
Primary BELI Status Qualifier Date
Secondary BELI Status Qualifier Code
Secondary BELI Status Qualifier Date
 Code and effective date of a condition which causes the value of an individual's Benefits Eligibility Level Indicator-Assigned (EDB 0360) to appear to be out of compliance. Primary Qualifier/Secondary Qualifier values:

10 - Appointment with ending date for funding purposes only
20 - Averaged appointment percent employee (academic)
30 - Extended sick leave recipient
40 - Employee rehabilitation (formally approved)
50 - Split student/non-student
60 - Seasonal Employee
70 - Phased Retiree
80 - "Grandfathered" employee
90 - Sabbatical/Leave for professional renewal		 EPER
EINS
IINS
Bond/Ded Amt Cd
Den Cd
1103
1204
1304
1404
Bond Denomination Code
 Defines the denomination of the bond being purchased by the employee.
4 = 100.00
5 = 200.00
6 = 500.00
7 = 1000.00 		EBND
IBND
Bond Owner
1105
1205
1305
1405
Bond Owner Name (Part 1)
EBND
IBND
1106
1206
1306
1406
Bond Owner Name (Part 2)
BRSC
N/A
Benefit Rate Selection Code
 Reserved for future use. EINS
IINS
Building
Campus Address Building
0309
Address-Campus Building
EPD1
IPER
By
8024
Leave Accrual Period Bypass
 Reserved for future use. ILAH
Campus Mail Addr
0307
Address-Campus-Campus Name
 The employee's campus mailing address. IPER
Campus Phone 1
0310
Campus Phone 1
 The employee's campus telephone number. EPD1
IPER
Check Disposition
Pay Disp
0201
Pay Disposition Code
 1-nnnnn = Campus Mail to department (nnnnn = 4 digit dept code followed by a 0)
2 = An employee signed up for Surepay who is not yet pre-noting
3-nnnnn = Department pickup (nnnnn = 4 digit dept code followed by a 0)
8 = Surepay		 ECHK
IGEN
IGNL
Checking/Savings Indicator

Bank Account Number
SP Bnk Acct Code/Number
0226

0225
SurePay Checking/Savings Code

SurePay Bank Account Number
 C = Checking, S = Savings

Employee's bank account number.		 ECHK
IGNL
Citizenship
Citizen
0109
Citizenship Status Code
 A = Non-Resident Alien with no tax treaty, from Japan, Korea, Canada or Mexico
C = US Citizen
E = Non-Resident Alien with tax treaty
N = Non-Resident Alien with no tax treaty
R = Resident Alien
X = Non Resident UC employee working outside the US		 EALN
EPD1
IALN
IGEN
Co-Own
B/C
1113
1213
1313
1413
Bond Beneficiary/Co-owner Indicator
 B = Beneficiary
C = Co=owner
blank = No Beneficiary or Co-Owner		 EBND
IBND
Co-Own/Ben Name
1114
1214
1314
1414
Bond Beneficiary/Co-owner Name (Part 1)
 The name of the beneficiary to co-owner of the bond. EBND
IBND
1115
1215
1315
1415
Bond Beneficiary/Co-owner Name (Part 2)
Corp Credit Card Status
0168
Corporate Credit Card Status
 Reserved for future use. EMIS
IPER
Corp Credit Card Date
0169
Corporate Credit Card Date
 Reserved for future use. EMIS
IPER
Corp Credit Card Type
0133
Corporate Credit Card Type
 Reserved for future use. EMIS
IPER
Country of Residence
0143
Country of Residency
 See country code table. EALN
IALN
CURR DCP RATE
5508
Current Month DCP Rate
 Percentage rate that was used to calculate the DCP portion of an employee's retirement contribution in the current month. INBI
CURR MO RTR GRS
5520
Current Month Retirement Gross
 Total gross earnings for the current month's pay period which are subject to employee retirement contributions. INBI
CURR MO RTR RTE
5530
Current Month Retirement Rate
 Used to calculate employees' retirement contribution. INBI
CURR-MO-RED AMT
5525
Current Month Reduction Amount
 Portion of the current month's pay period retirement gross which was exempted from employee retirement contributions. INBI
---Current---
As of
0616
Work Study Limit-Last Change Date
 The date on which the associated Work Study Limit (EDB 615) was established. IFNW
Current Specialty Code
0707
0708
0709
Current Specialty Code 1
Current Specialty Code 2
Current Specialty Code 3
 Current area of specialization. EPD2
Cyc
8023
Leave Accrual Period Cycle Type
 B = Biweekly
M = Monthly		 ILAH
Date of Birth
0107
Date of Birth
 Employee's date of birth (mm/dd/yy) EEID
EPD1
IGEN
Date of Hire
0113
Date of Employment
 The employee's most recent date of hire. EPER
IGEN
DCP Plan Code
0129
Defined Contribution Plan Code
 S = Savings
E = Equity
G = Insurance Co Contract
B = Bond
M = Money Market
A = Multi Asset		 ERET
IRET
Dental Cov Eff Date
0274
Dental Plan Coverage Effective Date
   EINS
IINS
Dental Empl Cost
N/A
N/A
 Employee plan cost if applicable. IINS
Dental Opt Out Code
0378
Dental Plan Opt Out Code
 X = Opted not to participate
C = Canceled
D = De-enrolled from coverage
blank = No action to be taken		 EINS
IINS
Dental Plan
0272
Dental Plan Code
 D1 = Delta Dental
D3 = PMI
blank = no coverage		 EINS
IINS
Dental Plan Contr
N/A
N/A
 UC Contribution amount if applicable IINS
Dental Plan Coverage
0273
Dental Plan Coverage Code
 U = One party coverage = Employee only
UU = Two Party = Employee + one dependent
UUU = Family
blank = no coverage		 EINS
IINS
Dental Plan Provider
0654
Dental Provider ID
 For PMI participants only. See PMI plan booklet. EINS
Dep Life Empl Cost
N/A
N/A
 Employee plan cost IINS
Dep Number
0632
Dependent Number
 051 = Spouse
052 + > = Child (numbered in sequence)		 EDEP
Department
Dept
0614
Work Study Department Code
 Code indicating the department to which the associated Work Study Limit entry applies. Values:

blank - all departments (generic limit)
UNLIM - all departments (no limit enforced)
xxxxxx - where "xxxxxx" is a specific department (departmental limit)		 EWSP
IFNW
Dependent Birth Date
0634
Dependent Birth Date
EDEP
IMEM
Dependent Coverage Effective Dates
Medical
Dental
Optical
Legal
0639
0640
0641
0642
Dependent Coverage Effective Dates
EDEP
IMEM
Dependent Dis
0638
Dependent Disabled Code
 N = No
Y = Yes		 EDEP
IMEM
Dependent Relation
0635
Dependent Relation to Employee
 A = Adult Dependent Relative
C = Child (natural or adopted)
D = Domestic Partner
G = Grandchild
K = Child/Grandchild of Domestic Partner
O = Other
P = Stepchild
S = Spouse
W = Legal Ward		 EDEP
IMEM
Dependent Sex
0637
Dependent Sex Code
 F = Female
M = Male		 EDEP
IMEM
Dependent SSN
0636
Dependent SSN
EDEP
IMEM
Dependent Life Cov Eff Date
Dep Life Cov Eff Date
0188
Dependent Life Coverage Effective Date
EINS
IINS
Dependent Life Plan
Dep Life Coverage
0278
Dependent Life Insurance Plan
 Y = Basic
B = Both Spouse + children
S = Spouse Only
C = Children only
blank = not enrolled		 EINS
IINS
Dept
Dept Cd
2032
Appointment Department
 See Campus Organizational Hierarchy table at: http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity. EAPP
EAPC
IAPS
IAPT
IAPP
Description
N/A
N/A
 Deduction Name from campus GTN Table IRET
IDED
Disability
Hdcp Status
0352
Handicapped Status Code
 H = Handicapped
N = Not Handicapped		 EPD1
IGEN
Disability Coverage Effective Date
UCDI/EMP PD DIS Eff Date
0453/
0233
UC Disability Coverage Date and/or Employee Paid Disability Coverage Date
 Dates are the same for employees who have Employee Paid Disability. EINS
IINS
Disability Salary Base
UCDI/EPD Sal Base
0232
Employee Paid Disability Salary Base
 The employee's monthly salary rate rounded up to the nearest dollar. EINS
IINS
Disability Wait Per
UCDI/EMP PD DIS Coverage
0123/
0231
UC Disability Coverage Code/Employee Paid Disability Plan Waiting Period
 A / 000 = UC Disability / no Employee Paid Disability (EPD)
A / 007 = UC Disability / 7 day waiting period for EPD
A / 030 = UC Disability / 30 day waiting period for EPD
A/ 090 = UC Disability/90 day waiting period for EPD
A /180 = UC Disability / 180 day waiting period for EPD
blank = not eligible for coverage/000		 EINS
IINS
Dist
Dis
2041
Distribution Number
 Uniquely identifies a distribution associated with an appointment. EAPP
EAPC
IAPP
IAPT
Dis %
2052
Time-Distribution (Anticipated)
 Anticipated time chargeable to the distribution. EAPP
EAPC
IAPT
IAPP
DOS
2056
Description of Service Code
   EAPP
EAPC
IAPT
IAPP
DUC
D
2059
Distribution Unit Code
 Reserved for future use. EAPP
EAPC
IAPP
IAPT
Dur
2004
Duration of Appointment Code
 I = Indefinite
N = Non-Tenure
T = Tenure
S = Security of employment
blank = none of the above		 EAPP
EAPC
IAPP
IAPT
Education Level Code
Educ Level
0116
Education Level
N = No academic credentials
H = High School or equivalent
T = Trade or craft certificate
A = Associate degree
B = Bachelor's degree
M = Master's degree
P = Professional degree
D = Doctorate		 EPD2
IPER
Education Level Year
Educ Level Yr
0117
Education Level - Year
 Year the employee's highest level of education was attained. EPD2
IPER
Effective Date
Eff Dt
0361
BELI Date
 Date the coverage described by the BELI Code is effective. EINS
IINS
Emplmt Status
0144
Employment Status Code
 A = Active
N = Leave Without Pay
P = Leave With Pay
S = Separated
I = Inactive		 All
Detail
Screens
Employee Distribution Unit Code
EDUC
0257
Employee Distribution Unit Code
 Reserved for future use. EPER
IGEN
Employee ID
ID
0003
Employee Identification Number
EEID
All
Detail
Screens
Employee Organization Home Address Disclosure
Empl Org Hm Addr Discl
0214
Employee Organization Home Address Disclosure Code
 0 or blank = Release home address
1 = Do not release home address		 EPER
IPER
Employee Paid Life Cov Eff Date
Life Eff Date
0277
Life Insurance Coverage Effective Date
EINS
IINS
Employee Paid Life Plan
Life Coverage
0276
Life Insurance Plan Code
 1 = 1 times annual salary base
2 = 2 times annual salary base
3 = 3 times annual salary base
4 = 4 times annual salary base
Flat = Flat rated		 EINS
IINS
Employee Paid Life Salary Base
Sal Base
0275
Life Insurance Salary Base
Annual salary in thousands based on insurance regulations. EINS
IINS
Employee Relations Code
EREL
0160
Employee Relations Code
 A = Manager, not confidential
B = Manager, confidential
C = Supervisor, not confidential
D = Supervisor, confidential
E = All others, not confidential
F = All others, confidential
G = Not covered by HEERA (out of state)
H = Student in academic title. covered by HEERA
I = Student in academic title, not covered by HEERA		 EPER
IGEN
Employee Representation Code
EREP
0295
Employee Representation Code
 C = Covered
U = Uncovered
S = Supervisor (Uncovered)
? = Indeterminate		 EPER
IGEN
Employee Service Credit From Date
0720
Employee Service Credit From Date
 Reserved for future use. EPD1
Employee Service Credit
0719
Employee Service Credit Months
 Reserved for future use. EPD1
Employee Special Handling Code
0256
Employee Special Handling Code
 Reserved for future use. ESH EPER
IGEN
Employee Unit Code
EUC
0255
Employee Unit Code
 A5 = Academic Senate
BX = Academic Student Employee
CX = Clerical & Allied Services
EX = Patient Care Technical
FX = Non-Senate Academic Research Professionals
GS = Printing Trades
HX = Residual Patient Care Professionals
IX = Non-Academic Senate Instructional
K5 = Skilled Crafts
LX = Professional Librarians
NX = Registered Nurses
PA = Police Officers
RX = Research Support Professionals
SX = Service
TX = Systemwide Technical
Z5 = Readers and Tutors
99 = Indeterminate - no unit
?? = Indeterminate - Title Code indeterminate		 EPER
IGEN
End Date
8022
Leave Accrual Period End Date
ILAH
ETD Grs Tax Trty
5539
Employee to Date Tax Treaty Gross
 The amount of tax exempt gross paid to an employee since the beginning of employment. IALN
INBI
Ethnic ID
0112
Ethnic Origin Code
 F = Other White
A = Black/African-American
2 = Chinese/Chinese-American
B = Japanese/Japanese-American
L = Filipino/Philippino
R = Pakistani/East Indian
X = Other Oriental
C = American Indian/Native American
E = Mexican/Mexican-American/Chicano
5 = Latin American/Latino
W = Other Spanish/Spanish-American
U = Unknown		 EPD1
IGEN
Executive Life Change
0358
Executive Life Change
 R = Reinstate participation
X = Change to non-participation		 EELI
Executive Life Change Date
0359
Executive Life Change Date
 Date change to Executive Life participation becomes effective. EELI
Executive Life Cov Dat
0452
Executive Life Coverage Effective Date
EELI
IINS
Executive Life Indicator
0356
Executive Life Indicator
 0 = Not eligible
2 = Eligible, 2 x annual salary, participating
X = Eligible, not participating		 EELI
Executive Life Salary Base
0357
Executive Life Salary
 Annual salary rate rounded to the next highest thousand. EELI
Executive Severance Flag
1122
Executive Severance Flag
 Eligibility for and level of participation in the Executive severance pay plan.
blank = Not eligible
A = Eligible, Grade A
B = Eligible, Grade B
C = Eligible, Grade C
D = Eligible, Grade D
E = Eligible, Grade E		  
Extension to the 8 Year Rule


Units
0733


0734
Extension 8 Year Rule


Extension 8 Year Time Type
 The number of quarters, semesters, months of additional time added to the 8 year service limit.

Q = Quarters
S = Semesters
M = Months		 EAPC
F/V
2013
Fixed/Variable Indicator
 F = Fixed
V = Variable		 EAPP
EAPC
IAPP
IAPT
FCP TST TAX GRS
5541
Taxable Gross-Month to Date-CPS
 The total gross earnings paid during the current month to date that are subject to federal taxation or reporting. INBI
FCP TST TOT GRS
5540
Total Gross-Month to Date-CPS
The total gross earnings paid during the current month to date. INBI
---Federal Funds---
RA
0603
Federal FYTD Gross-Research Asst
 Fiscal year-to-date total of Research Assistant earnings paid under federal funds to an individual classified as a student for purposes of financial aid. IFNA
---Federal Funds---
TA
0604
Federal FYTD Gross-Teaching Asst
 Fiscal year-to-date total of Teaching Assistant earnings paid under federal funds to an individual classified as a student for purposes of financial aid. IFNA
---Federal Funds---
Other
0605
Federal FYTD Gross-Other
 Fiscal year-to-date total of earnings other than Work Study, Research Assistant, or Teaching Assistant paid under federal funds to an individual classified as a student for purposes of financial aid. IFNA
Federal Tax Marital Status

Allowances
Fed Tx Marit/Allw
0127

0128
Federal Tax-Marital Status Code

Federal Tax-Withholding Allowances
 S = Single M = Married

Number of federal withholding allowances claimed by the employee.		 ETAX
EALN
IALN
IGEN
Federal Tax Maximum Withholding
Fed Tx Max
0320
Federal Tax-Maximum Withholding Allowances
 Maximum allowances an employee may claim as specified by the IRS. ETAX
EALN
IGEN
IALN
FICA Eligibility Code
FICA/Medcr
0120
FICA/Medicare Eligibility Code
 E = Eligible for OASDI/Medicare
M = Eligible for Medicare Only
N = Not Eligible		 ERET
EALN
IALN
IGEN
IRET
Fiscal Year
FY
IFNW
0612
Work Study Fiscal Year
 The fiscal year to which the associated Work Study Limit entry applies. The format is YYZZ where: YY is the last two digits of the calendar year in which the fiscal year begins and ZZ is the last two digits of the calendar year in which the fiscal year ends. For example: "9293" equals fiscal year 1992-1993. EWSP
Foreign Addr
1119
1120
1118
Foreign Address Postal Code
Foreign Address Province
Foreign Address Country
 See Foreign Country table for country codes. EPD1
IPER
Foreign Addr Ind
0291
Foreign Address Indicator
 A = US Address
F = Foreign address		 EPD1
IPER
IALN
FTE
2051
Full Time Equivalent
 The percentage of the budgeted position which the distribution represents. EAPP
EAPC
IAPT
IAPP
Future Institution Code
0702
Future Service Institution Code
 Reserved for future use. ESEP
FWT GROSS QTD
5512
Federal Withholding Tax Gross QTD
 The total gross earnings paid during the current calendar quarter which are subject to federal taxation or reporting. INBI
FWT Grs
5502
Federal Withholding Tax Gross YTD
 The total gross earnings paid during the calendar year which are subject to federal taxation or reporting. INBI
FY
0602
Financial Aid Fiscal Year
 The fiscal year of the associated Financial Aid Earnings entry. The format is YYZZ where: YY is the last two digits of the calendar year in which the fiscal year begins and ZZ is the last two digits of the calendar year in which the fiscal year ends. For example: "9293" equals fiscal year 1992-1993. IFNA
FYTD-RET-GROSS
5543
Fiscal Year to Date Retirement Gross
 Total gross earnings subject to employee retirement contributions for the fiscal year to date. INBI
FYTD WSP Gross
0619
Work Study FYTD Gross
 Fiscal year-to-date total of Work Study earnings for the associated Work Study Limit key and Work Study Limit. IFNW
Grade
2008
Salary Grade
 The grade level of an employee’s title code, if the title code is associated with a grade. See campus Title and Pay Plan. EAPP
EAPC
IAPS
IAPP
IAPT
GTN No
N/A
N/A
 Gross-to-Net Deduction number (see GTN Table) plus the balance type:
G = Deduction Amount
Y = Year-to-Date Deduction
S = Suspended Balance
Q = Quarter-to-Date Deduction Amount
D = Declining Balance
F = Fiscal Year-to-Date Deduction Amount
U = User Defined Balance		 IRET
IDED
H%
8104
Leave History Hours Code
 H = Time reported in hours
blank = Time reported in %		 ILAH
Health Eff Date
0294
Medical Coverage Effective Date
EINS
IINS
Health Opt Out Code
0377
Medical Opt Out Code
 X = Opted not to participate
C = Canceled
D = De-enrolled
blank = No action to be taken		 EINS
IINS
Health Plan Contr
N/A
N/A
 UC Contribution amount if applicable IINS
Health Plan Coverage Code
0293
Medical Plan Coverage Code
 1st character = Employee only
2nd character = Two Party = Employee + one dependent
3rd character = Family
U = uninsured by Medicare
M = insured by Medicare
blank = no coverage 		IINS
Health Plan Description
0292
Medical Plan Code
 CM = Core Medical
FP = PacifiCare
HG = FHP Takecare
HN = Health Net
KS = Kaiser South
PH = Prudential High Option
UC = UC Care		 EINS
IINS
Health Plan Empl Cost
N/A
N/A
 Employee plan cost if applicable IINS
Health Plan Provider ID
0653
Medical Provider ID
 For Health Net participants only. See Health Net insurance plan booklet. EINS
Highest Degree Institution Code
0701
Highest Degree Institution Code
 See School Code table at http://www.ucop.edu/irc/dd/cps/cps0921.html. EPD2
Highest Degree Specialty Code
0710
Highest Degree Specialty Code
 See Specialty Code table. EPD2
Home Department
Hm Dept
0114
Home Department Code
 See Campus Organizational Hierarchy table at: http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity.

 

 EPER
All
Detail
Screens in IEDB & IDDB
Home Dept Addr
N/A
N/A
 See Campus Organizational Hierarchy table at: http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity. IPER
Home Phone
Hm Phone
0210
Home Phone Number
EPD1
IPER
Honor Date
0714
Honor Date
 Date the employee received the honor for academic achievement. EHON
Honor Type
0713
Honor Type Code
 Honor received by an academic employee for academic achievement.
DAN = Danforth Fellow

NAS = Natl Academy of Sciences
FUL = Fulbright Award NIM = Natl Institute of Medicine
GUG = Guggenheim Award NOB = Nobel Prize
MAC = MacArthur Fellow PAC = Packard Fellow
NAE = Natl Academy of Engineering PROF = University Professor
NAED = National Academy of Education PYI = Presidential Young Investigator
EHON
Hours Toward Accrl
8103
Leave History Hours Toward Accrual
 The number of hours on pay status that count toward leave accrual. ILAH
HRS on Pay Stat:Curr Month
5119
Current Month Hours on Pay Status
 Includes all hours defined in the DOS code table as counting towards hours on pay status. This excludes overtime, differentials, etc. IHRS
INBI
HRS on Pay Stat:Jan
5120
Hours on Pay Status-January
IHRS
INBI
HRS on Pay Stat:Feb
5121
Hours on Pay Status-February
IHRS
INBI
HRS on Pay Stat:Mar
5122
Hours on Pay Status-March
IHRS
INBI
HRS on Pay Stat:Apr
5123
Hours on Pay Status-April
IHRS
INBI
HRS on Pay Stat:May
5124
Hours on Pay Status-May
IHRS
INBI
HRS on Pay Stat:Jun
5125
Hours on Pay Status-June
IHRS
INBI
HRS on Pay Stat:Jul
5126
Hours on Pay Status-July
IHRS
INBI
HRS on Pay Stat:Aug
5127
Hours on Pay Status-August
IHRS
INBI
HRS on Pay Stat:Sep
5128
Hours on Pay Status-September
IHRS
INBI
HRS on Pay Stat:Oct
5129
Hours on Pay Status-October
IHRS
INBI
HRS on Pay Stat:Nov
5130
Hours on Pay Status-November
IHRS
INBI
HRS on Pay Stat:Dec
5131
Hours on Pay Status-December
IHRS
INBI
Hours Toward Benefits Eligibility - Total Hrs at Month Begin
5142
Hours Toward Benefits Eligibility - Total
 The total number of hours that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc. IHR2
Hours Toward Benefits Eligibility - Current Month
5143
Hours Toward Benefits Eligibility - Current Month
 The total number of hours reported in the current month that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc. IHR2
Hours Toward Benefits Eligibility - January
5144
Hours Toward Benefits Eligibility - January
 The total number of hours reported in January that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - February
5145
Hours Toward Benefits Eligibility - February
 The total number of hours reported in February that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - March
5146
Hours Toward Benefits Eligibility - March
 The total number of hours reported in March that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - April
5147
Hours Toward Benefits Eligibility - April
 The total number of hours reported in April that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - May
5148
Hours Toward Benefits Eligibility - May
 The total number of hours reported in May that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - June
5149
Hours Toward Benefits Eligibility - June
 The total number of hours reported in June that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - July
5150
Hours Toward Benefits Eligibility - July
 The total number of hours reported in July that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - August
5151
Hours Toward Benefits Eligibility - August
 The total number of hours reported in August that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - September
5152
Hours Toward Benefits Eligibility - September
 The total number of hours reported in September that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - October
5153
Hours Toward Benefits Eligibility - October
 The total number of hours reported in October that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - November
5154
Hours Toward Benefits Eligibility - November
 The total number of hours reported in November that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Benefits Eligibility - December
5155
Hours Toward Benefits Eligibility - December
 The total number of hours reported in December that qualify toward eligibility for retirement and benefits.  This excludes overtime, differential, hours worked as casual restricted, per diem, etc.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - Total Hrs at Month Begin
0426
Hours Toward Career Status Eligibility - Total
 The total number of hours that qualify toward eligibility for career status, as of the beginning of the current process month. IHR2
Hours Toward Career Status Eligibility - Current Month
5156
Hours Toward Career Status Eligibility - Current Month
 The total number of hours reported in the current month that qualify toward eligibility for retirement and benefits.  IHR2
Hours Toward Career Status Eligibility - January
5157
Hours Toward Career Status Eligibility - January
 The total number of hours reported in January that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - February
5158
Hours Toward Career Status Eligibility - February
 The total number of hours reported in February that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - March
5159
Hours Toward Career Status Eligibility - March
 The total number of hours reported in March that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - April
5160
Hours Toward Career Status Eligibility - April
 The total number of hours reported in April that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - May
5161
Hours Toward Career Status Eligibility - May
 The total number of hours reported in May that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - June
5162
Hours Toward Career Status Eligibility - June
 The total number of hours reported in June that qualify toward eligibility for career status.   Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - July
5163
Hours Toward Career Status Eligibility - July
 The total number of hours reported in July that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - August
5164
Hours Toward Career Status Eligibility - August
 The total number of hours reported in August that qualify toward eligibility for career status.   Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - September
5165
Hours Toward Career Status Eligibility - September
 The total number of hours reported in September that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - October
5166
Hours Toward Career Status Eligibility - October
 The total number of hours reported in October that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - November
5167
Hours Toward Career Status Eligibility - November
 The total number of hours reported in November that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
Hours Toward Career Status Eligibility - December
5168
Hours Toward Career Status Eligibility - December
 The total number of hours reported in December that qualify toward eligibility for career status.  Note:  The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). IHR2
I-9 Date
0284
I-9 Signature Date
 The date an employee signs the I-9 form. EPD2
IALN
IGEN
Insurance Reduction Code
Ins Red
0299
Insurance Reduction Code
 Y or blank = Full participation, taxable gross is reduced.
N = No participation		 EINS
IINS
Job Group ID
0461
Job Group ID
 Job Group number derived by the system for Affirmative Action reporting purposes. EPER
L/Acct/CC/Fund/Proj/Sub
2043
2044
2065
2046
2066
2048
Expenditure Account Location Number
Account Number
Cost Center
Fund Number
Project
Subaccount Number
EAPP
IAPT
IAPP
LAD
0103
Last Action Date - EDB
 The effective date of the Last Action Taken Code-EDB. All
Detail
Screens
Last Day on Pay
0189
Last Day on Pay
The last day on pay status prior to a separation. ESEP
Last MN RTN 15
5536
Month of Last GTN Routine 15
 Code indicating the last payroll processing month in which Special Calculation Routine 15 was invoked for a payroll activity record. INBI
Last Sabbatical Credit Balance
0735
Last Sabbatical Credit Balance
 The remaining sabbatical credit carried forward after leave usage is subtracted from the employee's total accrued sabbatical credit. ELVE
Leave of Absence Action Code
0001
Employee Action
 07 = Leave With Pay
08 = Leave Without Pay		 ELVE
Leave of Absence Begin Date
LOA/Beg
0137
Leave of Absence Begin Date
   ELVE
EUCI
IGEN
IAPP
IAPS
IAPT
Leave of Absence Return
LOA Return
0138
Leave of Absence Return Date
  ELVE
EUCI
IAPS
IAPT
IGEN
IAPP
Leave of Absence Type
LOA Type
0139
Leave of Absence Type Code
 01 = Sabbatical at full salary
02 = Sabbatical at partial salary
03 = Sabbatical in residence/full salary
04 = Pregnancy disability
05 = Extended Illness
06 = Government/Public Service
07 = Professional Development
08 = Personal
09 = Workers' Compensation
10 = Furlough
11 = Military
12 = Special research
13 = Administration
14 = Sabbatical in residence/partial salary
15 = Family and Medical Leave without pay
16 = Family and Medical Leave with pay
99 = Other (as specified in personnel file)		 ELVE
EUCI
IAPS
IGEN
IAPP
IAPT
Legal Contr
N/A
N/A
 UC Contribution amount if applicable IINS
Legal Coverage
0354
Legal Plan Coverage Code
U = Single = Employee only
UU = Family		 EINS
IINS
Legal Description
0353
Legal Plan Code
 J1 = Prudential Legal Services EINS
IINS
Legal Cov Eff Date
0355
Legal Coverage Effective Date
   EINS
IINS
Legal Empl Cost
N/A
N/A
 Employee plan cost IINS
License/Certificate Code
0711
License Certificate Code
 AAT Asst. Animal Technician Cert.
ARC Architectural License
ATH Natl. Athletic Trainer Assoc.
AUD Audiologist Certificate
BAR California State Bar
CCD Ca Permit-Directr Children Ctr
CDL Ca Drivers License
CLT Clinical Lab Technologist Lic.
CSW Clinical Social Worker License
DDD Dental Specialty Brd Diplomate
DDS Dental Examiners Board License
ENG Professional Engineering Lic
FCC FCC Radiotelephone Operator
HYG Dental Hygienist License
LAN Lab Animal Technologist Cert.
LAT Lab Animal Technician Cert.
LLT Clin Lab Tech Trainee License
LND Landscape Architect License
LVN Vocational Nurse License
MDA Physician's Assistant Cert.
MDD Physician's Med Spec Diplomate
MDL Physician's Medical Board Lic.
MRA Medical Record Admin. Reg.
MRT Medical Record Technician Cert
MUS Natl. Assoc Music Therapy Reg.
NUC Nuclear Medicine Technologist
OCC Amer Occupational Therapy Asoc
OPT Optometry License
ORT Orthoptist Certificate
PCF Pest Control Field Rep License
PCO Pest Control Operator License
PHM Ca Board Of Pharmacy License
PHY Physical Therapist License
PRA Prosthetist/Orthotist Asst
PRO Prosthetist/Orthotist Cert.
PST Post Certification
PSY Psychiatric Technician License
RAD Radiologic Technology Cert.
RDA Registered Dental Assistant
RDI Registered Dietitian
REC Recreation Therapist Regis.
RES Respiratory Therapy Regis.
RNA Nurse Anesthetist Cert.
RNI Nurse Interim Permit
RNL Registered Nurse License
RNP Nurse Practitioner Cert.
RYY Radiation Therapy Technolog
SPE Speech Pathologist Cert
VET Veterinary Medicine License		 ELIC
License/Certificate Renewal Date
0712
License Certificate Renewal Date
 Date license or certificate must be renewed. ELIC
Life Empl Cost
N/A
N/A
 Employee plan cost IINS
Limit
---Current---
Limit
0615
Work Study Limit
 Maximum gross pay which may be charged to the Work Study funds for the associated Work Study Limit key (EDB 615). EWSP
IFNW
Lost Hours: Vac
8025
Leave Accrual Period Vacation Lost
 Number of vacation hours above the allowable maximum as of the close of the accrual period. ILAH
Lv
2018
Leave Accrual Code
Leave Code Annual Vac Annual Sick
A,G 15 days 12 days
B,H 18 days 12 days
C,J 21 days 12 days
D,K 24 days 12 days
E 24 days None
F None 12 days
N None None
EAPP
EAPC
IAPT
IAPP
Lv Accr Hrs: Compensatory Balance
5110
Compensatory Time Hours Balance
   IHRS
ILAH
INBI
Lv Accr Hrs: Vacation Maximum
5136
Vacation Leave Maximum Hours
 Maximum number of vacation leave hours based on the employee's leave accrual code. IHRS
ILAH
INBI
Lv Accr Hrs: Vacation Balance
5185
Vacation Hours Balance
   IHRS
ILAH
INBI
Lv Accr Hrs: Sick Leave Balance
5186
Sick Leave Hours Balance
   IHRS
ILAH
INBI
LVC
8102
Leave History Plan Code
Leave Code Annual Vac Annual Sick
A,G 15 days 12 days
B,H 18 days 12 days
C,J 21 days 12 days
D,K 24 days 12 days
E 24 days None
F None 12 days
N None None
ILAH
Mailcode
0311
Phone 2
 At UCLA, this element number is used for the campus mailcode. EPD1
IPER
Medcr Ded
6009Y
Medicare Tax YTD
 Year-to-date Medicare deduction. INBI
Medcr Grs
5510
Medicare Gross YTD
 Total gross earnings paid in a calendar year subject to Medicare contributions. INBI
Medicr GRS QTD
5517
Medicare Gross-QTD
 Total gross earnings paid in the current calendar quarter subject to Medicare contributions. INBI
Merit Rate Increase Percent
0153
Merit Percent
 Percent of merit increase received by the employee, expressed as nn.nn. EPER
Name
0105
0106
Name-Employee
Name-Suffix
 Last name, comma, first name, space, middle initial.
Suffix
For example: Doe,John A
Jr
 EEID
All
Detail
Screens
NDIP Gross YTD
5504
NDIP Gross-YTD
Total gross earnings paid during the calendar year under the Non-Qualified Defined Income Plan. INBI
---Non-Federal Funds---
RA
0606
Non-Federal FYTD Gross-Research Asst
 Fiscal year-to-date total of Research Assistant earnings paid under non-federal funds to an individual classified as a student for purposes of financial aid. IFNA
---Non-Federal Funds---
TA
0607
Non-Federal FYTD Gross-Teaching Asst
 Fiscal year-to-date total of Teaching Assistant earnings paid under non-federal funds to an individual classified as a student for purposes of financial aid. IFNA
---Non-Federal Funds---
Other
0608
Non-Federal FYTD Gross-Other
 Fiscal year-to-date total of earnings other than Work Study, Research Assistant, or Teaching Assistant paid under non-federal funds to an individual classified as a student for purposes of financial aid. IFNA
Non-Resident Alien Tax Form Indicator
Form 8233 Indicator
0167
Form 8233 Indicator
 Y = Yes, Form 8233 Filed
N or blank = No, Form 8233 not filed		 EALN
IALN
Non UC Hlth Exp
1175
Non-UC Health Ins Expiration Date
 Date on which a non-resident alien employee's coverage under a non-UC health plan expires. EALN
IALN
Non-UC Prior Service Code
0118
Prior Service Code
 The employee's service status prior to the most recent University employment.
A = Industry I = Calif Inst of Technology
B = Student J = USC
C = State of California K = State Univ/College
D = DOE Lab L = Other Calif College/Univ
E = Other Governmental M = Other College/Univ Grp I
F = Self-Employed N = Other College/Univ Grp II
G = Not Employed O = Other College/Univ Grp III
H = Stanford P = Other College/Univ - All Other US
R = Other College/Univ - Foreign		 EPD2
IPER
Normal PTO Max
5138
Paid Time Off Maximum Hours-Normal
 Maximum number of paid time off hours available to an individual under normal personnel policy. INBI
Normal SKL Max
5137
Sick Leave Maximum Hours-Normal
 Maximum number of sick leave hours available to an individual under normal personnel policy. INBI
NTX Grs
5507
Federal Non-Taxable Gross YTD
 Total gross earnings paid in a calendar year not subject to federal withholding tax & reporting. INBI
Nx Sal Rev Typ
0135
Next Salary Review Type Code
 1 = Eligible for six-month increase
2 = Eligible for Merit increase
3 = Eligible for SPA
4 = Eligible for Trainee increase
5 = No Salary review		 EPER
IGEN
Nx Sal Rev
0136
Next Salary Review Date
   EPER
IGEN
OASDI Gross QTD
5513
OASDI (Old Age Survivors Disability Insurance) Gross QTD
 Total gross earnings paid in the current calendar quarter subject to employee and employer OASDI contributions. INBI
OASDI Grs
5503
OASDI Gross YTD
 Total gross earnings paid during the calendar year subject to employee and employer OASDI contributions. INBI
Oath Signature Date
0705
Oath Signature Date
 The date an employee signs the Oath. EPD2
IGEN
Optical Coverage
Vision Coverage
0348
Optical Plan Coverage Code
 U = Single = Employee only
UU = Two Party = Employee + one dependent
UUU = Family		 EINS
IINS
Optical Cov Eff Date
Vision Eff Date
0349
Optical Plan Coverage Effective Date
   EINS
IINS
Optical Plan
Vision Description
0347
Optical Plan
 VI = Vision Care EINS
IINS
Optical Opt Out
Vision Opt Out Code
0379
Optical Opt Out Code
 X = Opted out
D = De-enrolled
blank = no action to be taken		 EINS
IINS
Original Hire Date
0704
Original Hire Date
 Date of first appointment at UCR. EPER
Other Inc
5519
Other Income
 Any tax reportable non-wage income which is paid by Accounts Payable or the University's disability insurance carrier. INBI
Other State Name
0186
State in which UC is registered to collect taxes if employee is resident of that state for tax purposes. Consult Payroll Services. ETAX
EALN
Other State Tax CA Res
0170
Other State CA Res
 See Out of State Withholding form. Consult Payroll Services.
N = Non-resident of CA earning compensation in another state and subject to the other state withholding
R = Resident of CA earning compensation in another state and subject to the other state withholding
blank = Not subject to other state withholding		 ETAX
EALN
Owner SSN
1104
1204
1304
1404
Bond Owner Social Security Number
   EBND
IBND
PAF Gen No
Gen No
0104
PAF Generation Number
 Identifies the most recently created Personnel Action Form for an employee. EAPP
IAPT
IAPP
IGEN
IAPS
Pay Begin
2053
Pay Begin Date
 Distribution begin date. EAPP
EAPC
IAPT
IAPP
Pay End
2054
Pay End Date
 Distribution end date. EAPP
EAPC
IAPT
IAPP
Pd Time Off Bal
5187
Paid Time Off Hours Balance-Current
 Number of hours that an individual has available for use as PTO. INBI
Permanent Address
Perm Addr
0204
0205
0206
0207
0208
Address-Permanent-Line One
Address-Permanent-Line Two
Address-Permanent-City
Address-Permanent-State
Address-Permanent-Zip
 The address designated by the individual as the permanent address. EPD1
IALN
IPER
Pgm
2007
Personnel Program Code
 A = Academic
1 = Professional and Staff Support
2 = Management and Senior Professional
Values Prior to 7/1/96:
E = Executive
M = MAP
P = A&PS
S = Staff
A = Academic		 EAPP
EAPC
IAPP
IAPT
Pr ID
0147
Previous Identification Number
   IGEN
Pr Name
0313
Name-Employee-Prior
   IGEN
Prenote Cycle/Date
SP Actvn
0228
SP Activation Date
 Date an employee record is converted to active Surepay status. ECHK
IGNL
Prenote Indicator
0227
SurePay Prenote Indicator
 The status of an employee's direct deposit request.
0 = Prenote Waiting Period - employee will be paid by check
1 = Surepay Form has been input - employee will be paid by check
2 = Employee will be paid via SurePay		 ECHK
IGNL
Prim Pay Sched
0152
Deduction Pay Schedule Code
 MO = Monthly Current
BW = Biweekly		 IGEN
IAPS
Primary Title Code
0460
Primary Title
 The primary title for reporting purposes if an employee has more than one title. EPER
---Prior---
As of
0618
Work Study Limit-Prior-Last Change Date
 The value of Work Study Limit-Last Change Date immediately prior to the current value. IFNW
---Prior---
Limit
0617
Work Study Limit-Prior
 The value of Work Study Limit immediately preceding the current value. IFNW
Prior Service Months
Pr Serv Mnths
0146
Prior Service Months
 Total number of months of prior service with the University. EPER
IPER
Prior University Service Institution Code
0703
Prior Service Institution
 School or college that was employee's most recent employer. See school code table at http://www.ucop.edu/irc/dd/cps/cps0921.html. EPD2
Probationary Period End Date
0706
Probationary End Date
   EPER
PRQ
2057
Perquisite Type Code
 1M = one meal
2M = two meals
3M = three meals
1MR = one meal plus room
2MR = two meals plus room
3MR = three meals plus room
R = room, apartment, house		 EAPP
EAPC
IAPT
IAPP
PY Stub PTO Bal
5141
Paid Time Off Hours-Last Stub
 The paid time off hours balance at the time of the last checkwrite. INBI
PY Stub SKL Bal
5140
Sick Leave Hours Balance-Last Stub
 The sick leave balance at the time of the last checkwrite. INBI
PY Stub VAC Bal
5139
Vacation Hours Balance-Last Stub
 The vacation balance at the time of the last checkwrite. INBI
Quarters/Semesters as Teaching Assistant

Units
0725


0726
Q/S as TA


TA Time Type
 The number of quarters or semesters of service accrued as a Teaching Assistant, Teaching Associate and Teaching Fellow toward the services limit established by policy for students.

Q = Quarters
S = Semesters		 EACD
Quarters/Semesters in Unit 18 Titles

Units
0727


0728
Q/S in Unit 18


Unit 18 Time Type
 The number of quarters or semesters of service accrued in titles designated under Unit 18 for collective bargaining purposes.

Q = Quarters
S = Semesters		 EACD
Quarters/Semesters/Months in 8-Year Rule

Units
0729


0730
Q/S/M 8 Year Rule


8 Year Time Type
 The number of quarters, semesters or months accrued in titles of Instructor, Assistant Professor and equivalent titles toward the 8 year service limit.

Q = Quarters
S = Semesters
M = Months		 EACD
Quarters/Semesters/Months on 19900 Funds at Greater Than 50%

Units
0731



0732
Q/S/M on 19900



19900 Time Type
 The number of quarters or semesters (for academic year based appointments) or number of months (for fiscal year based appointments) of service accrued in a title of Professor in Residence, Adjunct Professor or Professor of Clinical series and supported on 19900 funds for more than 50% time. EACD
Rate/Amt
2055
Distribution Rate
 Full time hourly rate, pay period amount, or by agreement amount associated with the distribution. EAPP
EAPC
IAPP
IAPT
Remaining Appt/Dis
N/A
N/A
 Remaining Appointment/Distributions for employee IAPP
IAPS
IAPT
Retir Grs
5505
Retirement Gross YTD
 Total gross earnings for the current year subject to retirement contributions under one of the University's retirement plans. INBI
Retirement System Code
Retirement
0122
Retirement System Code
 N = Not Eligible
H = DCP - Safe Harbor
B = UCRP - No deduction
U = UCRP
1 = UCRP - No deduction due to FY limit
P = PERS
2 = PERS - No deduction due to FY limit
F = FCSRS
3 = FCSRS - No deduction due to FY limit
S = SCERA
4 = SCERA - No deduction due to FY limit
O = OCERS
5 = OCERS - No deduction due to FY limit		 ERET
EALN
IGEN
IALN
IRET
IINS
Room
Campus Address Room
0308
Address-Campus-Room
   EPD1
IPER
Rt
2015
Appointment Rate Code
 A = Annual
H = Hourly
B = By-agreement		 EAPP
EAPC
IAPP
IAPT
Sabbatical Credit Accrued
0737
Sabbatical Credit Accrued
 The number of sabbatical credits accrued since the last sabbatical leave. ELVE
Sabbatical Credit Accrued Through Date
0748
Sabbatical Credit Through Date
 The date through which sabbatical credits have been accrued.  
Sabbatical Credit Date
0736
Sabbatical Credit Date
 Month and year in which sabbatical begins. ELVE
Sabbatical Credit Used
0738
Sabbatical Credit Used
 The number of sabbatical credits required for a requested leave. ELVE
Sch
Sched
2016
Appointment Pay Schedule Code
 BW = Biweekly
MO = Monthly		 EAPP
EAPC
IAPP
IAPT
Separation Date
0140
Separation Date
 Date an employee's employment affiliation with the University ends. ESEP
IGEN
Separation Destination
Sep Dest
0142
Separation Destination Code
A = Industry I = Calif Inst of Technology
B = Student J = USC
C = State of California K = State Univ/College
D = DOE Lab L = Other Calif College/Univ
E = Other Governmental M = Other College/Univ Grp I
F = Self-Employed N = Other College/Univ Grp II
G = Not Employed O = Other College/Univ Grp III
H = Stanford P = Other College/Univ - All Other US
R = Other College/Univ - Foreign
ESEP
IGEN
Separation Reason
Sep Rsn
0141
Separation Reason Code
AA = Accept another job CC = Termination of On-Call employee
AB = Look for another job DA = Released during probationary period
AC = Self-employment EA = Dismissal - lack of performance
AD = Dissatisfied with job EB = Dismissal - misconduct
AE = Pregnancy EC = Dismissal - quit without notice
AF = Marital/domestic duties GA = Medical separation
AG = Health I4 = Inactive for 4 consecutive months
AH = Attend school JA = Change to Emeritus status
AI = Military service KA = Death
AJ = Failed to return from leave

LA = Other

AK = Resign - Other RA = Retirement - regular
BA = Contract or grant expired RB = Retirement - voluntary
BB = Academic appointment expired RC = Retirement - faculty early
CA = Indefinite layoff RD = Retirement - compulsory
CB = Termination of limited employee
ESEP
IGEN
Sex
0108
Sex Code
 F = Female M = Male EPD1
IGEN
SP Prenote Cycle
0229
SurePay Prenote Pay Cycle Code
 MO = Monthly Current
MA = Monthly Arrears
XX = Special Compute		 IGNL
SPC Sick Lv Max
5106
Sick Leave Maximum Hours-Special
 Maximum number of sick leave hours available when the normal maximum has been pre-empted by another personnel policy. INBI
SPCL PTO LV Max
5107
Paid Time Off Maximum Hours-Special
 Maximum number of paid time off hours available when the normal maximum has been pre-empted by another personnel policy. INBI
SPCL VACTN Max
5105
Vacation Leave Maximum Hours-Special
 Maximum number of vacation leave hours available when the normal maximum has been pre-empted by another personnel policy. INBI
Spouse Name
0312
Name-Spouse
   EPD1
IPER
SSN
0111
Social Security Number
   EEID
All
Detail
Screens
State Tax Max
0321
State Tax-Max Withholding Allowances
 The maximum allowances an employee may claim as specified by the State Franchise Tax Board. ETAX
EALN
IALN
IGEN
State Tx Item
0132
State Tax-Itemized Deduction Withholding Allowances
 The additional exemptions claimed for state withholding tax which represents the value of itemized deductions. ETAX
EALN
IGEN
IALN
State Tx Marit/Pers
0130


0131
State Tax-Marital Status Code


State Tax-Withholding Allowances
S = Single M = Married H = Head of Household


Number of state withholding allowances claimed by the employee.		 ETAX
EALN
IGEN
IALN
Step
St

O/A
2049

2050
Step

Off/Above Code
 The level of an associated distribution pay rate in a pay range. See campus title and pay plans.

O = Off Scale Academic
P = Off Scale Academic-Red Circle
A = Above Scale Academic
B = Above Scale Academic-Red Circle
R = Red Circle Non-Academic
T = Trainee
L = Longevity
X = Salary Reduction 93/94		 EAPP
EAPC
IAPP
IAPT
Student Status
0119
UC Student Status Code
 1 = Not Registered
2 = Not Registered, Graduate Degree Candidate
3 = Undergraduate Student
4 = Graduate Student
5 = Not registered, graduate degree candidate, other campus
6 = Undergraduate student, other campus
7 = Graduate student, other campus		 EPD1
IGEN
IPER
Surepay Bank Table Key
SP Bank
0230
SurePay Bank Table Key
 See Campus SurePay Bank Table ECHK
IGNL
SWT
6012Y
State Withholding Tax YTD
 The total calendar year to date state withholding tax. INBI
SWT Grs
5506
State Withholding Gross YTD
 Total gross earnings paid during the calendar year subject to State of California taxation and reporting. INBI
Tax Treaty Article No
1173
Tax Treaty Article No
 The number of the article that exempts an employee who is claiming exemption per a tax treaty. (See http://www.ucop.edu/ucophome/cao/paycoord/taxstate.html.) EALN
IALN
Tax Treaty End Date
1172
Tax Treaty End Date
EALN
IALN
Tax Treaty Income Code
1170
Tax Treaty Income Code
 18 = Compensation for teaching
19 = Compensation for research		 EALN
IALN
Tax Treaty Income Limit Tax Treaty Income Limit
1174
The maximum amount of earnings exempt from federal tax that an employee may receive under the provisions of a tax treaty.
EALN
IALN
Terminal Compensatory Time Paid
0721
Terminal CTO Paid
 Amount of accrued compensatory time hours paid at termination. ESEP
Terminal Sick Leave Balance
0722
Terminal Sick Leave Balance
 Amount of sick leave hours accrued at time of termination. ESEP
Terminal Vacation Leave Paid
0723
Terminal Vacation Leave Paid
 Amount of accrued vacation leave hours paid at termination. ESEP
 

Time

2017
Time Reporting Code
 R = Exception time reporting via online PTR
Z = Positive time reporting via online PTR
N = No time reporting
W = Without salary		 EAPP
EAPC
IAPT
IAPP
Title
Title Code
TC
2006
Title Code
 See campus title and pay plans. EAPP
EAPC
IAPS
IAPP
IAPT
Tot Grs
5501
Total Gross YTD
 The total gross earnings paid during the calendar year. INBI
Total Appt/Dis
N/A
N/A
 Total Appointment/Distributions for an employee IAPT
IAPP
Total Sabbatical Credit Balance
0739
Total Sabbatical Credit Balance
 The remaining sabbatical credit balance after current accruals and usage have been recorded. ELVE
Transit
N/A
Transit Routing Number
 Derived from SurePay Bank Table IGNL
TRIP Reduction Percentage

TRIP Duration

TRIP Begin Date
0482

0483

0484
TRIP Percentage

TRIP Duration

TRIP Begin Date
 The percent of time an employee's appointment is reduced under the Time Reduction Incentive Plan program. Values are 10, 15, 20 or 25.

The number of months an employee has elected to reduce their percentage of time under TRIP. Values are 12 or 18 months.

The date the trip period begins in the MM/DD/YY format.		 ELVE
IAPT
TUC/AREP/ASHC
2029

2031

2030
Title Unit Code

Appointment Representation Code

Title Special Handling Code
 Indicates to which Bargaining Unit a Title Code belongs. See Employee Unit Code for list of values.

C = Covered
S = Supervisor (Uncovered)
U = Uncovered

Indicates special handling required for collective bargaining.		 IAPT
IAPP
Typ
2020
Appointment Type Code
 1 = Contract
2 = Regular/Career
3 = Limited
4 = Casual/Restricted
5 = Academic
6 = Per Diem
7 = Partial Year Career
9 = Unex		 EAPP
EAPC
IAPT
IAPP
Type
N/A
N/A
 RED = Reduction, pre-tax deduction
DED = Deduction, post-tax deduction
CON = Contribution		 IRET
IDED
UC Directory Disclosure Hm Phone
0212
Directory Disclosure Indicator 2
 blank = list home phone number
1 = Do not list home phone number		 EPD1
IPER
UC Directory Disclosure Perm Addr
0211
Directory Disclosure Indicator 1
 blank = list home address
1 = Do not list home address		 EPD1
IPER
UC Directory Disclosure Spouse Name
0213
Directory Disclosure Indicator 3
 0 = list spouse's name
1 = Do not list spouse's name		 EPD1
IPER
UC Paid Life Ins Cov Dat
0451
UC Paid Life Insurance Coverage Effective Date

EINS
IINS
UC Paid Life Sal Base
0330
Life Insurance Coverage-UC Paid
 Annual salary in thousands for retirement plan members, max = 50 EINS
IINS
UCDI/EPD Empl Cost
N/A
N/A
 The employee's cost for Employee Paid Disability per month. IINS
UI Code
0121
Unemployment Insurance Coverage Code
 C = Covered
N = Not Covered		 IGEN
UI Gross QTD
5516
Unemployment Insurance Gross QTD
 Total gross earnings subject to Unemployment Insurance benefits contributions for the current quarter. INBI
UI Grs
5509
Unemployment Tax Gross YTD
 Total gross earnings subject to Unemployment Insurance benefit contributions and reporting for the calendar year. INBI
Veteran Disability
Veteran Disability Status Code
0351
Veteran Disability Status Code
 N = Not a Special Disabled Veteran
S = Special Disabled Veteran		 EPD1
IGEN
Veteran
Veteran Status
0350
Veteran Status Code
 N = Not Veteran
V = Veteran		 EPD1
IGEN
Visa Type
0110
Visa Type Code
 See http://www.ucop.edu/ucophome/cao/paycoord/visachart.pdf. for more information. EALN
IGEN
IALN
Visa/Work Permit End Date
0184
Visa/Work Permit End Date
 The date on which an employee's visa or work permit expires. EALN
IALN
IGEN
Vision Contr
N/A
N/A
 UC Contribution amount if applicable IINS
Vision Empl Cost
N/A
N/A
 Employee cost if applicable IINS
WSP
0613
Work Study Program Code
 Code indicating the Work Study Program of the associated Work Study Limit entry. EWSP
IFNW
WSP
W
2062
Work Study Program Code

Program

Acad Yr
AmerReads A
Community Service (FWS) C
Federal Workstudy F
America Counts M
President'sWorkstudy P
SWS Teaching Intern Program S
EAPP
EAPC
IAPP
IAPT
YTD NonWk Hrs
5104
Non-Worked Hours YTD
 The number of paid time hours considered non-worked for the calendar year-to-date. See Description of Service table. IHRS
INBI
YTD OT Hrs
5103
Overtime Hours Worked YTD
 Number of hours worked which are reported as overtime for the calendar year-to-date. IHRS
INBI
YTD Reg Hrs
5102
Regular Hours Worked YTD
Number of regular hours worked for the calendar year-to-date excluding overtime, differentials, or leave time. IHRS
INBI
YTD Safe Harbor Gross
5544
Safe Harbor Gross YTD
 Total gross earnings subject to Safe Harbor reduction for the calendar year. INBI
YTD Tax Treaty Grs
5537
Tax Treaty Gross YTD
 Total amount of tax exempt gross paid to employee under the provisions of a tax treaty for the calendar year. IALN
INBI
YTD TLP ADJ
5535
Non-Cash Fringe Benefits YTD
 Sum of the tax reportable non-cash fringe benefits. INBI
YTD Tot Hrs
5101
Total Hours on Pay Status YTD
 Total number of hours reported on pay status, excluding overtime and differentials, for the calendar year to date. IHRS
INBI