PPS MANUAL

UCLA Payroll Services

A guide on the various databases, tables, reports and security features within the Personnel Payroll System (PPS).
PPS MANUAL, SECTION B - HISTORY DATA BASE

B5.0 HDB FIELD/SCREEN CROSS REFERENCE TABLE
 

Screen Label Definition Data Values Screen
%
Appt Time
The appointment percent time. On the HADC and HADF screens, this field also indicates whether the time is fixed or variable.
HADC
HADF
HSUM
% Time The percent of time associated with the sabbatical distribution.
HSLV
Acad. Rank Dt This field is reserved for future use; it currently carries no data.
IAPN
UAPN
Accrued Thru Dt The month and year through which the associated sabbatical credit balance was accrued.
HSLA
Action On the HADC and HADF screens, up to three Personnel Action Codes associated with a distribution will be displayed. 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 = Casual (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
HADC
HADF
IATN
UATN
ADD Coverage

 
ADD Eff Date


 
ADD Principal
Accidental Death & Dismemberment Coverage Code
 
Accidental Death & Dismemberment Coverage Effective Date
 
AD&D Principal Sum expressed in thousands of coverage
ADD Coverage Codes:
S = Self Only
F = Family coverage (Employee, spouse and eligible children)
M = Modified Family (Employee and eligible children)
IBN1
UBN1
Amount The dollar amount of the award.
HAWD
Ann/Hr Rt
Annual/Hourly Rate
The latest annual or hourly pay rate associated with the appointment.
HADC
HADF
HSUM
IAPN
UAPN
Appointment Type Translation of the appointment type.
HADC
HADF
Appt
Appt. No.
Appt. Number
A sequential number for the appointments. On the Personnel History screens the numbers will not correspond to appointment numbers in the EDB.
HADC
HADF
IATN
UATN
Appt Dept
Department Code
The appointment department code and/or department name translated from the Home Department Table.
HADC
HADF
HSUM
IAPN
UAPN
Appt Rep Code Code indicating if the title code on the appointment is covered by a collective bargaining unit. C = Covered
U = Uncovered
S = Supervisor
IAPN
UAPN
Appt Type
Appt Type Code
The appointment type associated with the appointment, e.g. contract, career, limited (casual), casual restricted, academic, per diem, or Unex. 1 = Contract
2 = Regular/Career
3 = Limited (Casual)
4 = Casual/Restricted
5 = Academic
6 = Per Diem
7 = Partial Year Career
9 = Unex
HSUM
IAPN
UAPN
Auto/Home Deduct Auto/Homeowners Insurance Deduction Indicator Y = Process deductions
N = Do not process deductions
blank = Process deductions
IBN1
UBN1
Award The type of award granted to the employee. The code is the same as the Description of Service Code used to pay the award: SPA = Special Performance Award
PDA = Professional Development Award
MIA = MAP Incentive Award
LEA = Local Employee Award
IAP = Incentive Award Program
HAWD
Bas/Pd Ovr
Appt Basis Code
Paid Over Code
Basis is the number of months an academic employee was expected to perform service. Paid Over is the number of months over which an academic employee was expected to be paid. 09 = 9 months
10 = 10 months
11 = 11 months
12 = 12 months
HADC
HADF
IAPN
UAPN
Begin Date
Begin Dt
Appt Begin Date
The begin date of the appointment or the sabbatical leave distribution.
HADC
HADF
HSLV
HSUM
IAPN
UAPN
BELI
BELI-Assigned

BELI - Derived

BELI Eff Date

BELI Change Date

BELI Conflict Date
The Assigned Benefits Eligibility Level Indicator describes the type of benefits for which the employee is eligible and the BELI Effective Date.

The Derived Benefits Eligibility Level Indicator is derived by the PPS and may not be the same as the Assigned BELI code.
 
In most cases, the Assigned BELI code and the Derived Code should be the same.  If not, they are considered to be in conflict and the system would record a BELI Conflict Date.
 

The BELI Change Date is the date the Assigned BELI code changed.
BELI Codes:
1 = Career benefits eligibility
2 = Limited career benefits eligibility- not a member of a retirement system and appointment is for 12 months or more
3 = Limited career benefits eligibility- not a member of a retirement system and appointment is for less than 12 months
4 = Eligible for core benefits only - Average Hours Worked per Week meets minimum eligibility requirement
5 = No benefits eligibility - Average Hours Worked per Week does not meet minimum eligibility requirement
6 = No benefits eligibility - appointments are either Casual/Restricted or are in Titles restricted to students
7 = No benefits eligibility - appointments are Per Diem in nature
8 = No benefits eligibility - "by agreement" appointments
9 = No benefits eligibility - appointment without salary
? = No value assigned
HPER
IBN1
UBN1
Campus Addr
Campus Address
The employee’s campus address.
HPER
IBA1
UBA1
Citizen
Citizen Status
Citizenship status
C = U.S. Citizen
R = Resident Alien
N = Non Resident Alien, wages subject to withholding tax; income reported on form W-2s
E = Non Resident Alien, wages not subject to federal tax withholding; income reported on Form 1042S
A = Non Resident Alien from Canada, Japan, Mexico, or South Korea
X = Non Resident Alien living and working outside the United States; wages not subject to federal and state withholding taxes
HPER
IBA2
UBA2
Core Ben Cover Code indicating the individual's CORE benefits coverage. B = Both CORE Life and Medical
L = CORE Life
M = Medical
blank = None
IBN1
UBN1
Curr Specialty - 1,2,3 Current Specialty Code 1
Current Specialty Code 2
Current Specialty Code 3
Current area of specialization. See Specialty Code table. IBA2
UBA2
D The Distribution Unit Code is a collective bargaining unit code that is not used at this campus. This field will be blank.
HADC
HADF
Date The month and year the award was effective.
HAWD
Date of Birth
Birth Date


HPER
IBA2
UBA2
Degree Field The field in which the highest degree was awarded. See Specialty Code table. IBA2
UBA2
Dental Plan Dental Plan Code
 

For definitions of Coverage, ECED/PCED, and Opt Out, refer to Medical Coverage, etc. below.

D1 = Delta Dental
D3 = PMI
blank = no coverage
IBN2
UBN2
Dep Life Plan

Dep Eff Date

Dependent Life Insurance Plan

Dependent Life Coverage Effective Date

Dependent Life Insurance Plan Codes:
Y = Basic
B = Both Spouse + children
S = Spouse Only
C = Children only
blank = not enrolled
IBN2
UBN2
Dep#
Name
SSN
Rel to Emp
Birthdate
Sex
Disabled Code

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

 
Dependent Disabled Code:
Y = Yes, disabled child, stepchild, grandchild, other child, or child/grandchild of domestic partner
N = No, not disabled
I = Ineligible for Medicare (applies to Adult Dependent Relative
only)
blank = not disabled
IMBR
UMBR
Department Code Distribution Department Code See Home Department Table (PPP0411) on Document Direct-RDS for codes. IDST
UDST
Dis
Dist Number
A sequential number for the distributions. On the Personnel History screens, the numbers will not correspond to the distribution  numbers in the EDB
HADC
HADF
IATN
UATN
Dis %
Distribution Time
The percent of time associated with the distribution.
HADC
HADF
IDST
UDST
Dos
DOS
Descrip of Serv
The Description of Service code indicating the type of pay. See the Description of Service table for definitions.
HADC
HADF
HSLV
IDST
UDST
Dur
Appt Duration
The anticipated duration of the appointment.
HADC
HADF
IAPN
UAPN
Educ Level
Education Level
Education level indicates the highest level of education attained by the individual. A = Associate degree
B = Bachelor's degree
D = Doctorate
H = High School or equivalent
M = Master's degree
N = No academic credentials
P = Professional degree
T = Trade or craft certificate
HPER
IBA2
UBA2
Educ Level Yr
Education Year
The year in which the individual's highest level of education was attained. 1989 is displayed as ‘89’.
HPER
Effective Date The date on which the associated action was effective.
IATN
UATN
Emp Ser Credit The number of months of employment service credit (e.g. for service awards and leave accrual purposes). From The date from which the service credit has been calculated.
HPER
Employment Status Employment Status Code A = Active
N = Leave Without Pay
P = Leave With Pay
S = Separated
I = Inactive
IBA1
UBA1
End Date
End Dt
Appt End Date
The end date of the appointment or sabbatical leave distribution. This date may display as indefinite (99/99/99) for appointments that have ended if the EDB preparer did not explicitly record an end date for the appointment before entering a subsequent appointment.
HSUM
HADC
HADF
HSLV
IAPN
UAPN
EPD Sal Base

EPD Eff Date

EPD Wait Per

Employee Paid Disability Salary Base - The employee's monthly salary rate rounded up to the nearest dollar.

The Effective Date of the Employee Paid Disability coverage.

Employee Paid Disability Plan Waiting Period

000 =  no Employee Paid Disability
007 = 7 day waiting period
030 = 30 day waiting period
090 = 90 day waiting period
180 = 180 day waiting period
blank = no Employee Paid Disability
IBN1
UBN1
EREL/EUC
EREP/ESH/EDUC
EREP/EUC
EREL – the Employee Relations Code indicates the employee’s status in accordance with HEERA (Higher Education Employee Relations Act) regulations.

EUC – the Employee Unit code identifies the collective bargaining unit that represents the employee’s primary title code.

EREP - the Employee Representation Code indicates whether a collective bargaining unit covers the employee.

ESH - The Employee Special Handling and Employee Distribution Unit Codes (EDUC) are not in use at UCLA, and these fields should be blank.
EREL codes:
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

Employee Unit Codes (EUC) & TUC:
A4 = Academic Senate-UCLA
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-UCLA
LX = Professional Librarians
NX = Registered Nurses
PA = Police Officers
RX = Research Support Professionals
SX = Service
TX = Systemwide Technical
87 = Indeterminate Unit
99 = No Unit

Employee Representation Codes (EREP):

C = Covered
U = Uncovered
S = Supervisor
HADC
HADF
HPER
ICBG
Ethnic
Ethnic Origin
The employee’s ethnicity. F = Other White
A = Black/Afro 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
HPER
IBA2
UBA2
Exec Life Plan
Exec Sal Base
Exec Chg Date
Exec Eff Date
Executive Life Insurance Plan Code

Executive Life Salary Base - Annual salary rate rounded to the next highest thousand.


Executive Life Change Date - Date change to Executive Life participation becomes effective.


Executive Life Coverage Effective Date
0 = Not eligible
2 = Eligible, 2 x annual salary, participating
X = Eligible, not participating
IBN2
UBN2
Fixed/Variable Fixed/Variable Indicator F = Fixed
V = Variable
IAPN
UAPN
Foreign Address The employee's permanent foreign address.
IBA2
UBA2
Foreign Country
Province
If the employee has a permanent foreign address, the country code and province will be listed in these fields. See Foreign Country table (PPP0428) on Document Direct-RDS for country codes. IBA2
UBA2
Fte
Full Time Equiv
The Full Time Equivalent field is not in use at this campus and displays as 0.00.
HADC
HADF
IDST
UDST
Future Inst
Future Institution
The college or university which will be the individual’s next employer, if applicable.
HSEP
IBA2
UBA2
Grd
Salary Grade
A salary grade is displayed if the title code is associated with a salary grade or if a grade has been entered in the EDB.
HADC
HADF
IAPN
UAPN
HDCP
Handicapped Status
Code indicating whether an employee is disabled. (blank) = Not Handicapped
N = Not Handicapped
H = Handicapped
HPER
IBA2
UBA2
Highest Degree This code indicates the highest level of education attained by the individual. (blank) = No information
N = No academic credentials
H = High school diploma or equivalent
T = Trade or craft certificate
A = Associate degree
B = Bachelor's degree
M = Master's degree (M.A., M.S.)
P = Professional degree (terminal professional degree at master's level, e.g., M.L.S., J.D., M.S.W.)
D = Doctorate (e.g., Ph.D., D.Sc., M.D., D. Pharm., D.L.S., Ed.D)
HHNR
IBA2
UBA2
Home Department
Home Dept
The one department which has coordinating responsibility for an individual's employment and/or pay disposition. The home department of the employee at the time the action was entered into the EDB.
HAWD
HLOA
HSEP
IBA1
UBA1
I9 Date Date the employee signed the I9 (U.S. Department of Justice Employment Eligibility Verification form.
HPER
Ins Reduction Insurance Reduction Code Y or blank = Full participation, taxable gross is reduced.
N = No participation
IBN1
UBN1
Inst Highest Degree Institution Code See School Code table at http://www.ucop.edu/irc/dd/cps/cps0921.html. IBA2
UBA2
Job Group ID
Job Group Identifier
A job group number assigned to the primary title for Affirmative Action and governmental reporting purposes.
HPER
IBA1
UBA1
Last Action The translation of the last action code recorded for the associated appointment is supposed to be displayed beneath the Last Action field label. Because of inconsistencies in the manner in which action codes are recorded or not recorded by EDB preparers, and the frequent appearance of "Other" action codes derived by the system which are not meaningful, the Last Action may not be accurately reflected on this screen. Research is continuing to address this problem.
HSUM
Last Day
Last Day on Pay
Last Day on Pay Status
The date on which an employee's compensation ends.
HPER
HSEP
IBA1
UBA1
Layoff Seniority Credit Title Code

TUC
Appt Rep

Regular Hours

Last Update

Prior Balance Hours
as of:

Title code, TUC, Appt Rep:   The title code, collective bargaining unit and coverage codes in which hours of layoff seniority credit have been earned.

Regular Hours:
  The number of layoff seniority credit hours earned by the employee since May 1995 in the layoff seniority credit title code.


Last Update:
The date the layoff seniority credit hours on the screen was last updated.


Prior Balance Hours, as of
: These fields are reserved for future use.

ILCR
ULCR

Leave Begin
Leave of Absence Begin Date
The leave of absence begin date.
HLOA
ILEV
ULEV
Leave Reason
Leave of Absence Type code
Translation for the leave of absence type code associated with the leave on the EDB. 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)
HLOA
ILEV
ULEV
Leave Return The date the employee returns from leave of absence.
HLOA
ILEV
ULEV
Leave Status Code
N = Leave Without Pay
P = Leave With Pay
ILEV
ULEV
Leave Type Translation for the leave action code associated with the leave. Change in Leave Return Date
LWOP = Leave Without Pay
Leave with Pay
HLOA
Legal Plan Legal Plan Code J1 = Prudential Legal Services IBN2
UBN2
Life Insurance

Life Ins Eff Date

UC Paid Life Insurance Coverage

UC Paid Life Insurance Coverage Effective Date

Annual salary in thousands for retirement plan members, max = 50 IBN1
UBN1
Life Plan
 

Life Sal Base

Life Eff Date

Employee Paid Life Plan Coverage Code

Employee Paid Life Insurance Salary Base - Annual salary in thousands based on insurance regulations.


Life Insurance Coverage Effective Date
Life Plan Coverage codes:
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
IBN2
UBN2
LV
Leave Accrual
The leave accrual code indicating the employee’s vacation and sick leave accrual eligibility.
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
HADC
HADF
MedicalCoverage
Dental Coverage
Optical Coverage
Legal Coverage
Medical Plan Coverage Code 1st character= Employee only
2nd character=2-Party,Employee+1-dependent
3rd character= Family
U= uninsured by Medicare
M= insured by Medicare
blank= no coverage
IBN2
UBN2
Medical ECED/PCED/DCED


Dental ECED/PCED/DCED


Optical ECED/PCED/DCED

Legal ECED/PCED/DCED

Medical/Dental/Optical/Legal ECED:  The date on which the employee's coverage with the associated insurance carrier became effective.


Medical/Dental/Optical/Legal PCED:
  The date on which the associated coverage level became effective.

Medical/Dental/Optical/Legal DCED:  The date on which coverage for an employee's dependent became effective.

IBN2
UBN2
IMBR
UMBR
Medical Opt Out
Dental Opt Out
Optical Opt Out
Medical Opt Out Code
Dental Opt Out Code
Vision Opt Out Code
X = Opted not to participate
C = Canceled
D = De-enrolled
blank = No action to be taken
IBN2
UBN2
Medical Plan Medical Plan Code CM = Core Medical
FP = PacifiCare
HG = FHP Takecare
HN = Health Net
KS = Kaiser South
PH = Prudential High Option
UC = UC Care
IBN2
UBN2
Most Recent Hire
Most Recent Hire Date
Most Recent Hire Dt
Employee’s most recent date of employment. On the HSEP screen, the most recent hire date prior to the associated separation date.
HADC
HADF
HPER
HSEP
HSUM
IBA1
UBA1
Next Review Date Next Salary Review Date
IBA1
UBA1
Next Review Type 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
A = Asst prof 4 yr appraisal
C = 3 yr reappointment for post 6 yr Lecturer
L = Asst prof 8 yr limit, reg rank
M = Merit for Assoc/Full Prof ranks
O = Merit or promo-Coor, Admin or Specialist series
P = Promotion to Full Professor
R = Asst prof 8 yr limit, non-ladder
S = Advancement to Steps VI, VII, VIII and above scale
T = Asst prof 2 yr term
W = Without salary and without step
IBA1
UBA1
O
Off/Above Scale
Off/Above code indicating that the pay rate is off or above the pay scale for the title. This field was also used to flag rates that were reduced as part of the 1993/94 salary reduction. Off/Above codes are:
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 rate
L = Longevity rate
X = Rate temporarily reduced in 1993-94
Z = Percent time temporarily reducedin1993-94
HADC
HADF
IDST
UDST
Optical Plan Optical Plan - For definitions of Coverage, ECED/PCED, and Opt Out, refer to Medical Coverage, etc. above. VI = Vision Care IBN2
UBN2
OASDI/MEDICARE
FICA Eligibility Code
The employee’s eligibility for FICA deductions. E = Eligible for OASDI and Medicare deductions
M = Eligible for Medicare deductions
N = Not eligible for FICA (OASDI or Medicare)
HPER
IBA1
UBA1
Oath Signature Dt
Oath Signature Date
Date the employee signed the Oath of Allegiance.
HPER
IBA1
UBA1
Original Hire
Original Hire Date
The employee’s first hire date.
HPER
IBA1
UBA1
Pay Beg
Charge Start Date
The distribution begin date.
HADC
HADF
IDST
UDST
Pay End
Charge Stop Date
The distribution end date.
HADC
HADF
IDST
UDST
Perm Addr
Permanent Addr
The employee’s permanent (home) address.
HPER
IBA2
UBA2
Pers Prog
Personnel Program
Personnel Prog
Translation of the personnel program code associated with the title code; e.g. academic, managers and senior professionals, professional and support staff, executive, MAP, A&PS or staff. 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
HADC
HADF
HSUM
IAPN
UAPN
Primary TC
Primary Title
The primary title code and payroll title. If the employee has more than one concurrent title, the system will derive one primary title code. The payroll title associated with the predominate appointment for the employee at the time of separation or leave.
HLOA
HPER
HSEP
IBA1
UBA1
Prior Service Code The employee's service status prior to the most recent University employment. A = Industry
B = Student
C = State of California
D = DOE Lab
E = Other Governmental
F = Self-Employed
G = Not Employed
H = Stanford
I = Calif Inst of Technology
J = USC
K = State Univ/College
L = Other Calif College/Univ
M = Other College/Univ Grp I
N = Other College/Univ Grp II
O = Other College/Univ Grp III
P = Other College/Univ-All Other US
R = Other College/Univ - Foreign
IBA1
UBA1
Prior Service Inst School or college that was employee's most recent employer. See School Code table at http://www.ucop.edu/irc/dd/cps/cps0921.html. IBA1
UBA1
Prior UC/ST Service The number of months of University or State service accumulated by the employee prior to the Employment Service Credit From date described above and not included in the Employment Service Credit field.
HPER
Prob Per End Dt
Probation End Date
The employee’s probationary period ending date.
HPER
IBA1
UBA1
Prq
Perquisite Type
Perquisite deducted for University provided room and board. 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
HADC
HADF
IDST
UDST
Rate/Amt
Dist Pay Rate
The hourly or monthly rate or flat dollar amount to be paid.
HADC
HADF
IDST
UDST
Reason The reason for the employee’s separation.
HSEP
Retirement
Retirement System Code
The employee’s retirement system code. (blank) = No retirement plan
N = Not eligible
H = DCP Casual/Limited  (Safe Harbor)
U = UCRS (University of California Retirement System)
P = PERS (Public Employees' Retirement System)
HPER
IBA1
UBA1
Rt
Appt Rate Code
The rate code which indicates the nature of the rate of pay for the appointment, e.g. Annual, Hourly or By Agreement.
HADC
HADF
IAPN
UAPN
Sabbatical Credit Bal The sabbatical credit balance.
HSLA
Sched
Appt Pay Sched
The pay schedule code indicating whether the employee is paid Monthly or Biweekly. MO = Monthly Current
BW = Biweekly
HADC
HADF
IAPN
UAPN
Sep Dt
Separation Date
The date on which an individual's employment affiliation with the University ends. For most individuals, this is the last day for which compensation is received.
HPER
HADC
HADF
HSEP
HSUM
IBA1
UBA1
Separation Destination Separation Destination Code A = Industry
B = Student
C = State of California
D = DOE Lab
E = Other Governmental
F = Self-Employed
G = Not Employed
H = Stanford
I = Calif Inst of Technology
J = USC
K = State Univ/College
L = Other Calif College/Univ
M = Other College/Univ Grp I
N = Other College/Univ Grp II
O = Other College/Univ Grp III
P = Other College/Univ-All Other US
R = Other College/Univ - Foreign
IBA1
UBA1
Sep Rea
Separation Reason
The reason for the employee’s separation.
AA = To accept another job
AB = To look for another job
AC = Self employment
AD = Dissatisfied with job
AE = Pregnancy, did not desire leave
AF = Marital/domestic duties
AG = Health
AH = To attend school
AI = Military service
AJ = Failed to return from leave
AK = Other
BA = Grant/contract expired
BB = Appointment expired
CA = Indefinite layoff
CB = Termination of limited (casual) employee
CC = Termination of other limited (casual) employee (on Call)
DA = Released during probationary period
EA = Lack of performance
EB = Misconduct
EC = Quit without notice
GA = Medical separation
I4 = Inactive for 4 consecutive months
JA = Change to emeritus status
KA = Death
LA = Other termination (coaches, management program) or separation (per diem nurses, vocational nurses)
RA = Retirement - regular
RB = Retirement - voluntary
RC = Retirement faculty - early
RD = Retirement - compulsory
HPER
IBA1
UBA1
Sex Gender F = Female
M = Male
HPER
IBA2
UBA2
Source The fund number from which the award was paid.
HAWD
Step
Grade
For academic employees, the highest Step value from all distributions associated with the appointment is displayed. For non-academic employees, the grade is displayed for titles that are associated with a grade.
HSUM
Stp
Salary Step
The step or level of the associated pay rate in a pay range.
HADC
HADF
IDST
UDST
Student Status
UC Student Status
The employee’s status as a UC student.
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
HPER
IBA2
UBA2
Sub-Location A code derived by the system from the Full Accounting Unit and the department code with which it is associated.  This code indicates the pay plan structure which governs the pay rate for that appointment. GN = General Campus
MD = Medical Center
OP = Office of the President
EAPC
EAPP
HADC
HADF
HSUM
IAPN
IAPP
IAPS
IAPT
IDER
Term Comp Paid This field is reserved for future use; it currently carries no data.
HSEP
Term Sick Bal This field is reserved for future use; it currently carries no data.
HSEP
Term Vac Paid This field is reserved for future use; it currently carries no data.
HSEP
Time Rpt Code
R = Exception time via online PTR
Z = Positive time via online PTR
P = Positive by tape or FTP
N = Positive by tape or FTP
E = Exception - not via online PTR
W = Without salary
IAPN
UAPN
Title
Title Code
Title Code associated with the appointment.
HADC
HADF
HSUM
IAPN
UAPN
Title Name Short payroll title name translated from the title code.
HADC
HADF
HSUM
TRIP Begin Date
TRIP Duration
TRIP %
TRIP Begin Date
TRIP Duration
TRIP Percentage
The date the trip period began in the MM/DD/YY format.

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

The percent of time an employee's appointment was reduced under the Time Reduction Incentive Plan program. Values are 10, 15, 20 or 25.
IBA2
UBA2
TUC/EREP
Tuc/Sh/Rep
Title Unit
Title Spec Hdlg
The Title Unit Code and Employee Representation Code indicate the collective bargaining unit associated with the employee at the time of the action. The TUC comes from the Employee Unit Code and the EREP comes from the Employee Representation Code at the employee level of the employee’s record (e.g. the data displayed on the IGEN screen in EDB Inquiry). The Special Handling Code is not used currently and the field should be blank. The Representation Code indicates whether in this appointment the employee is covered by the exclusive representative. Definitions for these data values can be found above with EREL/EUC, EREP/ESH/EDUC, EREP/EUC. HADC
HADF
HLOA
IAPN
UAPN
UCTD Code Code indicating the UC paid temporary disability coverage for the employee. A = Covered by UCTD
blank = Employee is not eligible for coverage
IBN1
UBN1
UCTD Eff Date Effective date of the UC paid temporary disability coverage for the employee.
Vet
Veteran Status
The employee’s status as a veteran.  If there is a Recently Separated Veteran Date on the HPER screen, it will appear to the right of the veteran status, otherwise the space is blank. (blank) = Not a Vietnam Era Veteran
N = Not a Vietnam Era Veteran
V = Vietnam Era Veteran

Recent Separated Veteran Date = MM/YY format.
HPER
IBA2
UBA2
Vet HDCP
Veteran Disability
Code indicating whether the employee is a Special Disabled Veteran. (blank) = Not a Special Disabled Veteran
N = Not a Special Disabled Veteran
S = Special Disabled Veteran
HPER
IBA2
UBA2
Visa
Visa Type
Visa End Date
The type of visa held by the employee and the visa end date. Refer to Alien - Employment Overview and Eligibility for more information. HPER
IBA2
UBA2
W
Work Study Prog
The Work Study Program associated with the distribution.
Program Acad Yr Summer
AmerReads A D
BruinCorp B E
Com Serv C G
Federal F H
President's P R
HADC
HADF
IDST
UDST

to top


Previous Next