(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 h