EDB Manual Reference - Data Element/Screen Cross Reference

EDB DATA ELEMENT/SCREEN CROSS REFERENCE TABLE

Looking for a specific data element? Use the find command in your web browser. For information on how to use the find command, select here to view our helpful hints page.

SCREEN LABEL

DE #

DATA DICTIONARY NAME

DATA VALUES/COMMENTS

SCREEN

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

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 or PPS Home Department Table (PPP0411) on Document Direct-RDS. Users that have FS QDB access can go to the Financial System Reports at http://ofsr.ais.ucla.edu/reports/default.asp and login using their QDB password. A list of reports will be presented that includes the Campus Organizational Hierarchy.

EPER

Amount/Value

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

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

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 foreign country table (PPP0428).

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. See specialty code table.

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

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

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

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 or PPS Home Department Table (PPP011) on RDS. Users that have FS QDB access can go to the Financial System Reports at http://ofsr.ais.ucla.edu/reports/default.asp and login using their QDB password. A list of reports will be presented that includes the Campus Organizational Hierarchy.

EAPP
EAPC
IAPS
IAPT
IAPP

Description

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

See DOS code table.

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

A4 = 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
K4 = Skilled Crafts
LX = Professional Librarians
NX = Registered Nurses
PA = Police Officers
RX = Research Support Professionals
SX = Service
TX = Systemwide Technical
Z4 = 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

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

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

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

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

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

EPER
All
Detail
Screens in IEDB & IDDB

Home Dept Addr

N/A

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

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

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

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

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 UCLA.

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

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

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	CF = Release - per diem
AB = Look for another job	CH = Layoff, severance & recall/rehire rights
AC = Self-employment	CI = Layoff, no severance or recall
AD = Dissatisfied with job	CG = Layoff with severance
AE = Pregnancy - did not desire leave	DA = Released - Before obtaining regular status
AF = Family and/or child care	EA = Termination - lack of performance
AG = Health	EB = Termination - misconduct
AH = Attend school	EC = Resignation - quit without notice
AI = Military service	ED = Termination - job abandonment
AJ = Failed to return from leave	EE = Termination - never started employment
AK = Resign - Other	EF = Termination - no longer certified/licensed
AM = Moved out of area	EG = Settlement-do not rehire (employee agrees not to return)
AN = No reason given	GA = Medical separation
BA = Contract or grant expired	I4 = System Derived - Inactive for 4 consecutive months
BB = Appointment/contract appt. expired	JA = Change to Emeritus status
BC = Visa/work authorization expired	KA = Death
CA = Layoff with recall/rehire rights	LA = Other termination
CB = Release - limited employee	RA = Retirement
CC = Release - other casual employee (on call)	RD = Retirement - compulsory for SMGs & regents officers
CD = Release - casual restricted employee	RF = Retirement - faculty
CE = Release - graduation/no longer student	RF = Retirement - faculty

ESEP
IGEN

Sex

0108

Sex Code

F = Female M = Male

EPD1
IGEN

SP Prenote Cycle

0229

SurePay Prenote Pay Cycle Code

B1 = Biweekly one
B2 = Biweekly two
MO = Monthly Current
XX = Special

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 tax treaty chart.)

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
P = Positive by tape or FTP
N = Positive by tape or FTP
E = Exception - not via online PTR
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

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

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

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

Refer to Alien - Employment Overview & Eligibility 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

UC Contribution amount if applicable

IINS

Vision Empl Cost

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	Summer
AmerReads	A	D
BruinCorp	B	E
Com Serv	C	G
Federal	F	H
President's	P	R

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

Footer

EDB MANUAL, REFERENCE

EDB DATA ELEMENT/SCREEN CROSS REFERENCE TABLE