(Note to Print, select landscape page 11 x 8 1/2 with .25 top, left and right margins)
EDB DATA ELEMENT/SCREEN CROSS REFERENCE TABLE
| SCREEN LABEL | DE # | DATA DICTIONARY NAME | DATA VALUES/COMMENTS | SCREEN | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* |
N/A |
N/A |
Indicates oldest month of accumulated hours | IHRS | ||||||||||||
%
% Full |
2012 |
Percent Full
Time |
Percent of Time an employee is expected to work in an appointment. | EAPP EAPC IAPS IAPT IAPP |
||||||||||||
1MO
OLD RED AMT |
5526 |
1 Month Old
Reduction Amount |
Portion of the retirement gross exempt from employee retirement contributions for the pay period ending one month ago. | INBI | ||||||||||||
1MO
OLD RTR GRS |
5521 |
1 Month Old
Retirement Gross |
Total gross earnings subject to employee retirement contributions for the pay period ending one month ago. | INBI | ||||||||||||
1MO
OLD RTR RTE |
5531 |
1 Month Old
Retirement Rate |
Used to calculate employees' retirement contribution one month ago. | INBI | ||||||||||||
1MTH
DCP RATE |
5511 |
1 Month Old
DCP Rate |
Used to calculate the Defined Contribution Plan (DCP) portion of an employee's retirement contribution one month ago. | INBI | ||||||||||||
2MO
OLD RED AMT |
5527 |
2 Months Old
Reduction Amount |
Portion of the retirement gross exempt from employee retirement contributions for the pay period ending two months ago. | INBI | ||||||||||||
2MO
OLD RTR GRS |
5522 |
2 Months Old
Retirement Gross |
Total gross earnings subject to employee retirement contributions for the pay period ending two months ago. | INBI | ||||||||||||
2MO
OLD RTR RTE |
5532 |
2 Months Old
Retirement Rate |
Used to calculate employees' retirement contribution two months ago. | INBI | ||||||||||||
2MTH
DCP RATE |
5514 |
2 Months Old
DCP Rate |
Used to calculate the DCP portion of an employee's retirement contribution two months ago. | INBI | ||||||||||||
3MO
OLD RED AMT |
5528 |
3 Months Old
Reduction Amount |
Portion of the retirement gross exempt from employee retirement contributions for the pay period ending three months ago. | INBI | ||||||||||||
3MO
OLD RTR GRS |
5523 |
3 Months Old
Retirement Gross |
Total gross earnings subject to employee retirement contributions for the pay period ending three months ago. | INBI | ||||||||||||
3MO
OLD RTR RTE |
5533 |
3 Months Old
Retirement Rate |
Used to calculate employees retirement contribution three months ago. | INBI | ||||||||||||
3MTH
DCP RATE |
5515 |
3 Months Old
DCP Rate |
Used to calculate the DCP portion of an employee's retirement contribution three months ago. | INBI | ||||||||||||
4MO
OLD RED AMT |
5529 |
4 Months Old
Reduction Amount |
Portion of the retirement gross exempt from employee retirement contributions for the pay period ending four months ago. | INBI | ||||||||||||
4MO
OLD RTR GRS |
5524 |
4 Months Old
Retirement Gross |
Total gross earnings subject to employee retirement contributions for the pay period ending four months ago. | INBI | ||||||||||||
4MO
OLD RTR RTE |
5534 |
4 Months Old
Retirement Rate |
Used to calculate employees' retirement contribution four months ago. | INBI | ||||||||||||
4MTH
DCP RATE |
5542 |
4 Months Old
DCP Rate |
Used to calculate the DCP portion of an employee's retirement contribution four months ago. | INBI | ||||||||||||
Accrl
Key |
8101 |
Leave History
Accrual Key |
PBBRSD where: P = Personnel Program Code BB = Bargaining Unit Code R = Representation Code S = Special Handling Code D = Distribution Unit Code |
ILAH | ||||||||||||
Accrued
Hours: Sick |
8106 |
Leave History
Sick Hours Accrued |
Leave history of the sick hours accrued per accrual period. | ILAH | ||||||||||||
Accrued
Hours: Vac |
8105 |
Leave History
Vacation Hours Accrued |
Leave history of the vacation hours accrued per accrual period. | ILAH | ||||||||||||
Actions Appt Actions Dist Actions |
2033 2047 |
Appointment Action Distribution Action |
01 Hire 02 Rehire 04 Merit Increase (On-Line) 06 Separation 07 Leave With Pay 08 Leave Without Pay 09 Change in Leave Return Date 10 Promotion 11 Demotion 12 Lateral Transfer 13 Additional Employment 14 Academic Status Change 15 Visa Status Change 16 Change in Percent Full Time 17 Appointment Renewal 18 Change in Fund Source 19 Change in Home Department 20 Other (Employee Action) 21 Intercampus Action 23 Change in BELI - Assigned 24 Change in Leave Plan 25 Mass Title Code Change 26 Add Stipend 27 System Merit Increase (batch) 28 Range Adjustment (batch) 30 Mass Purge (batch) 33 Manual Range Adjustment (On-Line) 34 Terminal Appointment 35 Transfer - Campus/UCOP 36 Transfer - Campus/Lab/State 37 Reclassification Downward 38 Reclassification Upward 39 Reclassification Lateral 40 Other Appointment Action 41 Six Month Increase 42 Exceptional/Equity Increase 43 Change in Rate - Other 44 Limited Increase 45 Change in Negotiated Salary (HS Comp) 46 Change in Percent Full Time 47 Mass Account/Fund Change (batch) 48 Add Stipend 49 Mass Distribution Unit Change (batch) 50 Other Distribution Action 51 Transfer To/From Med Center 52 Limited to Career |
EAPP EAPC |
||||||||||||
AD&D
Coverage |
0281 |
Accidental Death
& Dismemberment Coverage Code |
S = Self Only F = Family coverage (Employee, spouse and eligible children) M = Modified Family (Employee and eligible children) |
EINS IINS |
||||||||||||
AD&D
Cov Eff Date AD&D Eff Date |
0282 |
Accidental Death
& Dismemberment Coverage Effective Date |
EINS IINS |
|||||||||||||
AD&D
Empl Cost |
N/A |
N/A |
The employee's cost for AD&D insurance per month. | IINS | ||||||||||||
AD&D
Prin Sum |
0280 |
AD&D Principal
Sum |
Expressed in thousands of coverage | EINS IINS |
||||||||||||
Address Addr |
1107 1207 1307 1407 |
Bond Owner Address-Street
(Part 1) |
The Bond Owner's Address. | EBND IBND |
||||||||||||
1108 1208 1308 1408 |
Bond Owner Address-Street
(Part 2) |
|||||||||||||||
1109 1209 1309 1409 |
Bond Owner Address-City |
|||||||||||||||
1110 1210 1310 1410 |
Bond Owner Address-State |
|||||||||||||||
1111 1211 1311 1411 |
Bond Owner Address- Postal Code-Zip |
|||||||||||||||
Age
1/1 |
0254 |
Age on January
1 |
Employee age as of January 1-used for age based premium calculations. | IINS | ||||||||||||
Alt
Tax Treaty Income Code |
1171 |
Alternate Tax
Treaty Income Code |
18 = Compensation for teaching 19 = Compensation for research |
EALN IALN |
||||||||||||
Alt
YTD Tax Treaty Grs |
5538 |
YTD Alternate
Tax Treaty Gross |
Field is reserved for future use. | IALN INBI |
||||||||||||
Alternate
Dept Code |
0235 |
Alternate Department
Code |
The department code of a department requesting access to an employee's record. See Campus Organizational Hierarchy table at: http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity. | EPER | ||||||||||||
Amount/Value
|
N/A |
N/A |
Dollar or % amount of deduction
as applicable; blank = dollar amount PCT = Percentage based deduction PREP = Prepayment dollar amount CALC = Calculation based on earnings PARM = Dollar amount taken from the parameter table |
IDED IRET |
||||||||||||
Ann/Hr
Rt |
2014 |
Appointment
Pay Rate |
The employee's pay rate expressed in an annual or hourly amount. | EAPP EAPC IAPP IAPS IAPT |
||||||||||||
Anticipated
Ret Date |
0765 |
Anticipated
Retirement Date |
The date an employee is expected to retire. | ESEP IGEN |
||||||||||||
Appt |
2001 |
Appointment
Number |
This is the Appointment Number identifying an employee's specified appointment. | EAPP EAPC IAPT IAPS IAPP |
||||||||||||
Appt
Begin Begin Dt |
2002 |
Appointment
Begin Date |
EAPP EAPC IAPP IAPS IAPT |
|||||||||||||
Appt
End End Dt |
2003 |
Appointment
End Date |
EAPP EAPC IAPT IAPS IAPP |
|||||||||||||
Assigned
BELI Asgn BELI Derived BELI Effective Date |
0360 0375 0341 |
Benefits Eligibility
Indicator (Assigned) Derived BELI BELI Effective Date |
1 = Career Benefits 2 = Limited Benefits, No Ret, 12+ mths appt 3 = Limited Benefits, No Ret, < 12 mths appt 4 = Core Benefits Only 5 = No Benefits 6 = No Benefits, Casual Restricted/Student 7 = No Benefits, Per Diem 8 = No Benefits, By Agreement 9 = No Benefits, Without Salary ? = Separated employee, system derived U = Average Hours = 0, with appointments X = Average Hours = 0, no appointments |
EINS EPER IINS IGEN |
||||||||||||
Auto/Homeowners
Ded Ind |
0185 |
Auto/Homeowners
Insurance Deduction Indicator |
Y = Process deductions N = Do not process deductions blank = Process deductions |
EMIS | ||||||||||||
Avg
Hr/Wk |
5132 |
Average Hours
Week |
The number of average hours on pay status per week, excluding overtime and differentials. | IHRS INBI |
||||||||||||
Award
Amount |
0746 |
Award Amount |
The dollar amount of staff award received by the employee. | EAWD | ||||||||||||
Award
Date |
0744 |
Award Date |
Effective date of award. | EAWD | ||||||||||||
Award
Source |
0745 |
Award Source |
The fund number of the FAU supporting a staff award received by the employee. | EAWD | ||||||||||||
Award
Type |
0743 |
Award Type Code |
The type of award received by
the employee. EIA = Executive Incentive Award IAP = Staff Incentive Award Program (cash award) MIA = Management Incentive Award (cash award) PDA = Professional Development Award LAA = Local Academic Award LEA = Local Staff Employee Award SPA = Staff Special Performance Award |
EAWD | ||||||||||||
Background
Check Code |
0740 |
Background Check
Code |
The type of background check conducted. 01 = Previous employer's reference 02 = Criminal conviction record check 03 = Financial disclosure 04 = Security clearance 05 = Police Officer background check 06 = Professional license/certificate verification 07 = Educational degree check 08 = DMV driving record check |
EBCC | ||||||||||||
Background
Check Date |
0741 |
Background Check
Date |
Date background check conducted. | EBCC | ||||||||||||
Balance
Type |
N/A |
N/A |
Gross-to-Net Balance Type | IDED | ||||||||||||
Basis/ Paid Over Bas/Pd Ovr |
2010/ 2011 |
Appointment
Basis Code/ Paid Over Code |
9 = 9 months 10 = 10 months 11 = 11 months 12 = 12 months |
EAPP EAPC IAPP IAPT |
||||||||||||
BELI
Status Qualifiers: Primary Date Secondary Date Qual |
0240 0241 0242 0243 |
Primary BELI
Status Qualifier Code Primary BELI Status Qualifier Date Secondary BELI Status Qualifier Code Secondary BELI Status Qualifier Date |
Code and effective date of a condition
which causes the value of an individual's Benefits Eligibility Level Indicator-Assigned
(EDB 0360) to appear to be out of compliance. Primary Qualifier/Secondary
Qualifier values: 10 - Appointment with ending date for funding purposes only 20 - Averaged appointment percent employee (academic) 30 - Extended sick leave recipient 40 - Employee rehabilitation (formally approved) 50 - Split student/non-student 60 - Seasonal Employee 70 - Phased Retiree 80 - "Grandfathered" employee 90 - Sabbatical/Leave for professional renewal |
EPER EINS IINS |
||||||||||||
Bond/Ded
Amt Cd Den Cd |
1103 1204 1304 1404 |
Bond Denomination
Code |
Defines the denomination of the
bond being purchased by the employee. 4 = 100.00 5 = 200.00 6 = 500.00 7 = 1000.00 |
EBND IBND |
||||||||||||
Bond
Owner |
1105 1205 1305 1405 |
Bond Owner Name
(Part 1) |
EBND IBND |
|||||||||||||
1106 1206 1306 1406 |
Bond Owner Name
(Part 2) |
|||||||||||||||
BRSC |
N/A |
Benefit Rate
Selection Code |
Reserved for future use. | EINS IINS |
||||||||||||
Building Campus Address Building |
0309 |
Address-Campus
Building |
EPD1 IPER |
|||||||||||||
By |
8024 |
Leave Accrual
Period Bypass |
Reserved for future use. | ILAH | ||||||||||||
Campus
Mail Addr |
0307 |
Address-Campus-Campus
Name |
The employee's campus mailing address. | IPER | ||||||||||||
Campus
Phone 1 |
0310 |
Campus Phone
1 |
The employee's campus telephone number. | EPD1 IPER |
||||||||||||
Check
Disposition Pay Disp |
0201 |
Pay Disposition
Code |
1-nnnnn = Campus Mail to department
(nnnnn = 4 digit dept code followed by a 0) 2 = An employee signed up for Surepay who is not yet pre-noting 3-nnnnn = Department pickup (nnnnn = 4 digit dept code followed by a 0) 8 = Surepay |
ECHK IGEN IGNL |
||||||||||||
Checking/Savings
Indicator Bank Account Number SP Bnk Acct Code/Number |
0226 0225 |
SurePay Checking/Savings
Code SurePay Bank Account Number |
C = Checking, S = Savings Employee's bank account number. |
ECHK IGNL |
||||||||||||
Citizenship Citizen |
0109 |
Citizenship
Status Code |
A = Non-Resident Alien with no
tax treaty, from Japan, Korea, Canada or Mexico C = US Citizen E = Non-Resident Alien with tax treaty N = Non-Resident Alien with no tax treaty R = Resident Alien X = Non Resident UC employee working outside the US |
EALN EPD1 IALN IGEN |
||||||||||||
Co-Own B/C |
1113 1213 1313 1413 |
Bond Beneficiary/Co-owner
Indicator |
B = Beneficiary C = Co=owner blank = No Beneficiary or Co-Owner |
EBND IBND |
||||||||||||
Co-Own/Ben
Name |
1114 1214 1314 1414 |
Bond Beneficiary/Co-owner
Name (Part 1) |
The name of the beneficiary to co-owner of the bond. | EBND IBND |
||||||||||||
1115 1215 1315 1415 |
Bond Beneficiary/Co-owner
Name (Part 2) |
|||||||||||||||
Corp
Credit Card Status |
0168 |
Corporate Credit
Card Status |
Reserved for future use. | EMIS IPER |
||||||||||||
Corp
Credit Card Date |
0169 |
Corporate Credit
Card Date |
Reserved for future use. | EMIS IPER |
||||||||||||
Corp
Credit Card Type |
0133 |
Corporate Credit
Card Type |
Reserved for future use. | EMIS IPER |
||||||||||||
Country
of Residence |
0143 |
Country of Residency |
See country code table. | EALN IALN |
||||||||||||
CURR
DCP RATE |
5508 |
Current Month
DCP Rate |
Percentage rate that was used to calculate the DCP portion of an employee's retirement contribution in the current month. | INBI | ||||||||||||
CURR
MO RTR GRS |
5520 |
Current Month
Retirement Gross |
Total gross earnings for the current month's pay period which are subject to employee retirement contributions. | INBI | ||||||||||||
CURR
MO RTR RTE |
5530 |
Current Month
Retirement Rate |
Used to calculate employees' retirement contribution. | INBI | ||||||||||||
CURR-MO-RED
AMT |
5525 |
Current Month
Reduction Amount |
Portion of the current month's pay period retirement gross which was exempted from employee retirement contributions. | INBI | ||||||||||||
---Current--- As of |
0616 |
Work Study Limit-Last
Change Date |
The date on which the associated Work Study Limit (EDB 615) was established. | IFNW | ||||||||||||
Current
Specialty Code |
0707 0708 0709 |
Current Specialty
Code 1 Current Specialty Code 2 Current Specialty Code 3 |
Current area of specialization. | EPD2 | ||||||||||||
Cyc |
8023 |
Leave Accrual
Period Cycle Type |
B = Biweekly M = Monthly |
ILAH | ||||||||||||
Date
of Birth |
0107 |
Date of Birth |
Employee's date of birth (mm/dd/yy) | EEID EPD1 IGEN |
||||||||||||
Date
of Hire |
0113 |
Date of Employment |
The employee's most recent date of hire. | EPER IGEN |
||||||||||||
DCP
Plan Code |
0129 |
Defined Contribution
Plan Code |
S = Savings E = Equity G = Insurance Co Contract B = Bond M = Money Market A = Multi Asset |
ERET IRET |
||||||||||||
Dental
Cov Eff Date |
0274 |
Dental Plan
Coverage Effective Date |
EINS IINS |
|||||||||||||
Dental
Empl Cost |
N/A |
N/A |
Employee plan cost if applicable. | IINS | ||||||||||||
Dental
Opt Out Code |
0378 |
Dental Plan
Opt Out Code |
X = Opted not to participate C = Canceled D = De-enrolled from coverage blank = No action to be taken |
EINS IINS |
||||||||||||
Dental
Plan |
0272 |
Dental Plan
Code |
D1 = Delta Dental D3 = PMI blank = no coverage |
EINS IINS |
||||||||||||
Dental
Plan Contr |
N/A |
N/A |
UC Contribution amount if applicable | IINS | ||||||||||||
Dental
Plan Coverage |
0273 |
Dental Plan
Coverage Code |
U = One party coverage = Employee
only UU = Two Party = Employee + one dependent UUU = Family blank = no coverage |
EINS IINS |
||||||||||||
Dental
Plan Provider |
0654 |
Dental Provider
ID |
For PMI participants only. See PMI plan booklet. | EINS | ||||||||||||
Dep
Life Empl Cost |
N/A |
N/A |
Employee plan cost | IINS | ||||||||||||
Dep
Number |
0632 |
Dependent Number |
051 = Spouse 052 + > = Child (numbered in sequence) |
EDEP | ||||||||||||
Department Dept |
0614 |
Work Study Department
Code |
Code indicating the department
to which the associated Work Study Limit entry applies. Values: blank - all departments (generic limit) UNLIM - all departments (no limit enforced) xxxxxx - where "xxxxxx" is a specific department (departmental limit) |
EWSP IFNW |
||||||||||||
Dependent
Birth Date |
0634 |
Dependent Birth
Date |
EDEP IMEM |
|||||||||||||
Dependent
Coverage Effective Dates Medical Dental Optical Legal |
0639 0640 0641 0642 |
Dependent Coverage
Effective Dates |
EDEP IMEM |
|||||||||||||
Dependent
Dis |
0638 |
Dependent Disabled
Code |
N = No Y = Yes |
EDEP IMEM |
||||||||||||
Dependent
Relation |
0635 |
Dependent Relation
to Employee |
A = Adult Dependent Relative C = Child (natural or adopted) D = Domestic Partner G = Grandchild K = Child/Grandchild of Domestic Partner O = Other P = Stepchild S = Spouse W = Legal Ward |
EDEP IMEM |
||||||||||||
Dependent
Sex |
0637 |
Dependent Sex
Code |
F = Female M = Male |
EDEP IMEM |
||||||||||||
Dependent
SSN |
0636 |
Dependent SSN |
EDEP IMEM |
|||||||||||||
Dependent
Life Cov Eff Date Dep Life Cov Eff Date |
0188 |
Dependent Life
Coverage Effective Date |
EINS IINS |
|||||||||||||
Dependent
Life Plan Dep Life Coverage |
0278 |
Dependent Life
Insurance Plan |
Y = Basic B = Both Spouse + children S = Spouse Only C = Children only blank = not enrolled |
EINS IINS |
||||||||||||
Dept
Dept Cd |
2032 |
Appointment
Department |
See Campus Organizational Hierarchy table at: http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity. | EAPP EAPC IAPS IAPT IAPP |
||||||||||||
Description |
N/A |
N/A |
Deduction Name from campus GTN Table | IRET IDED |
||||||||||||
Disability Hdcp Status |
0352 |
Handicapped
Status Code |
H = Handicapped N = Not Handicapped |
EPD1 IGEN |
||||||||||||
Disability
Coverage Effective Date UCDI/EMP PD DIS Eff Date |
0453/ 0233 |
UC Disability
Coverage Date and/or Employee Paid Disability Coverage Date |
Dates are the same for employees who have Employee Paid Disability. | EINS IINS |
||||||||||||
Disability
Salary Base UCDI/EPD Sal Base |
0232 |
Employee Paid
Disability Salary Base |
The employee's monthly salary rate rounded up to the nearest dollar. | EINS IINS |
||||||||||||
Disability
Wait Per UCDI/EMP PD DIS Coverage |
0123/ 0231 |
UC Disability
Coverage Code/Employee Paid Disability Plan Waiting Period |
A / 000 = UC Disability / no Employee
Paid Disability (EPD) A / 007 = UC Disability / 7 day waiting period for EPD A / 030 = UC Disability / 30 day waiting period for EPD A/ 090 = UC Disability/90 day waiting period for EPD A /180 = UC Disability / 180 day waiting period for EPD blank = not eligible for coverage/000 |
EINS IINS |
||||||||||||
Dist Dis |
2041 |
Distribution
Number |
Uniquely identifies a distribution associated with an appointment. | EAPP EAPC IAPP IAPT |
||||||||||||
Dis
% |
2052 |
Time-Distribution
(Anticipated) |
Anticipated time chargeable to the distribution. | EAPP EAPC IAPT IAPP |
||||||||||||
DOS |
2056 |
Description
of Service Code |
EAPP EAPC IAPT IAPP |
|||||||||||||
DUC D |
2059 |
Distribution
Unit Code |
Reserved for future use. | EAPP EAPC IAPP IAPT |
||||||||||||
Dur |
2004 |
Duration of
Appointment Code |
I = Indefinite N = Non-Tenure T = Tenure S = Security of employment blank = none of the above |
EAPP EAPC IAPP IAPT |
||||||||||||
Education
Level Code Educ Level |
0116 |
Education Level
|
N = No academic credentials H = High School or equivalent T = Trade or craft certificate A = Associate degree B = Bachelor's degree M = Master's degree P = Professional degree D = Doctorate |
EPD2 IPER |
||||||||||||
Education
Level Year Educ Level Yr |
0117 |
Education Level
- Year |
Year the employee's highest level of education was attained. | EPD2 IPER |
||||||||||||
Effective
Date Eff Dt |
0361 |
BELI Date |
Date the coverage described by the BELI Code is effective. | EINS IINS |
||||||||||||
Emplmt
Status |
0144 |
Employment Status
Code |
A = Active N = Leave Without Pay P = Leave With Pay S = Separated I = Inactive |
All Detail Screens |
||||||||||||
Employee
Distribution Unit Code EDUC |
0257 |
Employee Distribution
Unit Code |
Reserved for future use. | EPER IGEN |
||||||||||||
Employee
ID ID |
0003 |
Employee Identification
Number |
EEID All Detail Screens |
|||||||||||||
Employee
Organization Home Address Disclosure Empl Org Hm Addr Discl |
0214 |
Employee Organization
Home Address Disclosure Code |
0 or blank = Release home address 1 = Do not release home address |
EPER IPER |
||||||||||||
Employee
Paid Life Cov Eff Date Life Eff Date |
0277 |
Life Insurance
Coverage Effective Date |
EINS IINS |
|||||||||||||
Employee
Paid Life Plan Life Coverage |
0276 |
Life Insurance
Plan Code |
1 = 1 times annual salary base 2 = 2 times annual salary base 3 = 3 times annual salary base 4 = 4 times annual salary base Flat = Flat rated |
EINS IINS |
||||||||||||
Employee
Paid Life Salary Base Sal Base |
0275 |
Life Insurance
Salary Base |
Annual salary in thousands based on insurance regulations. | EINS IINS |
||||||||||||
Employee
Relations Code EREL |
0160 |
Employee Relations
Code |
A = Manager, not confidential
B = Manager, confidential C = Supervisor, not confidential D = Supervisor, confidential E = All others, not confidential F = All others, confidential G = Not covered by HEERA (out of state) H = Student in academic title. covered by HEERA I = Student in academic title, not covered by HEERA |
EPER IGEN |
||||||||||||
Employee
Representation Code EREP |
0295 |
Employee Representation
Code |
C = Covered U = Uncovered S = Supervisor (Uncovered) ? = Indeterminate |
EPER IGEN |
||||||||||||
Employee
Service Credit From Date |
0720 |
Employee Service
Credit From Date |
Reserved for future use. | EPD1 | ||||||||||||
Employee
Service Credit |
0719 |
Employee Service
Credit Months |
Reserved for future use. | EPD1 | ||||||||||||
Employee
Special Handling Code |
0256 |
Employee Special
Handling Code |
Reserved for future use. | ESH EPER IGEN |
||||||||||||
Employee
Unit Code EUC |
0255 |
Employee Unit
Code |
A5 = Academic Senate BX = Academic Student Employee CX = Clerical & Allied Services EX = Patient Care Technical FX = Non-Senate Academic Research Professionals GS = Printing Trades HX = Residual Patient Care Professionals IX = Non-Academic Senate Instructional K5 = Skilled Crafts LX = Professional Librarians NX = Registered Nurses PA = Police Officers RX = Research Support Professionals SX = Service TX = Systemwide Technical Z5 = Readers and Tutors 99 = Indeterminate - no unit ?? = Indeterminate - Title Code indeterminate |
EPER IGEN |
||||||||||||
End
Date |
8022 |
Leave Accrual
Period End Date |
ILAH | |||||||||||||
ETD
Grs Tax Trty |
5539 |
Employee to
Date Tax Treaty Gross |
The amount of tax exempt gross paid to an employee since the beginning of employment. | IALN INBI |
||||||||||||
Ethnic
ID |
0112 |
Ethnic Origin
Code |
F = Other White A = Black/African-American 2 = Chinese/Chinese-American B = Japanese/Japanese-American L = Filipino/Philippino R = Pakistani/East Indian X = Other Oriental C = American Indian/Native American E = Mexican/Mexican-American/Chicano 5 = Latin American/Latino W = Other Spanish/Spanish-American U = Unknown |
EPD1 IGEN |
||||||||||||
Executive
Life Change |
0358 |
Executive Life
Change |
R = Reinstate participation X = Change to non-participation |
EELI | ||||||||||||
Executive
Life Change Date |
0359 |
Executive Life
Change Date |
Date change to Executive Life participation becomes effective. | EELI | ||||||||||||
Executive
Life Cov Dat |
0452 |
Executive Life
Coverage Effective Date |
EELI IINS |
|||||||||||||
Executive
Life Indicator |
0356 |
Executive Life
Indicator |
0 = Not eligible 2 = Eligible, 2 x annual salary, participating X = Eligible, not participating |
EELI | ||||||||||||
Executive
Life Salary Base |
0357 |
Executive Life
Salary |
Annual salary rate rounded to the next highest thousand. | EELI | ||||||||||||
Executive
Severance Flag |
1122 |
Executive Severance
Flag |
Eligibility for and level of participation
in the Executive severance pay plan. blank = Not eligible A = Eligible, Grade A B = Eligible, Grade B C = Eligible, Grade C D = Eligible, Grade D E = Eligible, Grade E |
|||||||||||||
Extension
to the 8 Year Rule Units |
0733 0734 |
Extension 8
Year Rule Extension 8 Year Time Type |
The number of quarters, semesters,
months of additional time added to the 8 year service limit. Q = Quarters S = Semesters M = Months |
EAPC | ||||||||||||
F/V
|
2013 |
Fixed/Variable
Indicator |
F = Fixed V = Variable |
EAPP EAPC IAPP IAPT |
||||||||||||
FCP
TST TAX GRS |
5541 |
Taxable Gross-Month
to Date-CPS |
The total gross earnings paid during the current month to date that are subject to federal taxation or reporting. | INBI | ||||||||||||
FCP
TST TOT GRS |
5540 |
Total Gross-Month
to Date-CPS |
The total gross earnings paid during the current month to date. | INBI | ||||||||||||
---Federal
Funds--- RA |
0603 |
Federal FYTD
Gross-Research Asst |
Fiscal year-to-date total of Research Assistant earnings paid under federal funds to an individual classified as a student for purposes of financial aid. | IFNA | ||||||||||||
---Federal
Funds--- TA |
0604 |
Federal FYTD
Gross-Teaching Asst |
Fiscal year-to-date total of Teaching Assistant earnings paid under federal funds to an individual classified as a student for purposes of financial aid. | IFNA | ||||||||||||
---Federal
Funds--- Other |
0605 |
Federal FYTD
Gross-Other |
Fiscal year-to-date total of earnings other than Work Study, Research Assistant, or Teaching Assistant paid under federal funds to an individual classified as a student for purposes of financial aid. | IFNA | ||||||||||||
Federal
Tax Marital Status Allowances Fed Tx Marit/Allw |
0127 0128 |
Federal Tax-Marital
Status Code Federal Tax-Withholding Allowances |
S = Single M = Married Number of federal withholding allowances claimed by the employee. |
ETAX EALN IALN IGEN |
||||||||||||
Federal
Tax Maximum Withholding Fed Tx Max |
0320 |
Federal Tax-Maximum
Withholding Allowances |
Maximum allowances an employee may claim as specified by the IRS. | ETAX EALN IGEN IALN |
||||||||||||
FICA
Eligibility Code FICA/Medcr |
0120 |
FICA/Medicare
Eligibility Code |
E = Eligible for OASDI/Medicare
M = Eligible for Medicare Only N = Not Eligible |
ERET EALN IALN IGEN IRET |
||||||||||||
Fiscal
Year FY IFNW |
0612 |
Work Study Fiscal
Year |
The fiscal year to which the associated Work Study Limit entry applies. The format is YYZZ where: YY is the last two digits of the calendar year in which the fiscal year begins and ZZ is the last two digits of the calendar year in which the fiscal year ends. For example: "9293" equals fiscal year 1992-1993. | EWSP | ||||||||||||
Foreign
Addr |
1119 1120 1118 |
Foreign Address
Postal Code Foreign Address Province Foreign Address Country |
See Foreign Country table for country codes. | EPD1 IPER |
||||||||||||
Foreign
Addr Ind |
0291 |
Foreign Address
Indicator |
A = US Address F = Foreign address |
EPD1 IPER IALN |
||||||||||||
FTE |
2051 |
Full Time Equivalent |
The percentage of the budgeted position which the distribution represents. | EAPP EAPC IAPT IAPP |
||||||||||||
Future
Institution Code |
0702 |
Future Service
Institution Code |
Reserved for future use. | ESEP | ||||||||||||
FWT
GROSS QTD |
5512 |
Federal Withholding
Tax Gross QTD |
The total gross earnings paid during the current calendar quarter which are subject to federal taxation or reporting. | INBI | ||||||||||||
FWT
Grs |
5502 |
Federal Withholding
Tax Gross YTD |
The total gross earnings paid during the calendar year which are subject to federal taxation or reporting. | INBI | ||||||||||||
FY
|
0602 |
Financial Aid
Fiscal Year |
The fiscal year of the associated Financial Aid Earnings entry. The format is YYZZ where: YY is the last two digits of the calendar year in which the fiscal year begins and ZZ is the last two digits of the calendar year in which the fiscal year ends. For example: "9293" equals fiscal year 1992-1993. | IFNA | ||||||||||||
FYTD-RET-GROSS |
5543 |
Fiscal Year
to Date Retirement Gross |
Total gross earnings subject to employee retirement contributions for the fiscal year to date. | INBI | ||||||||||||
FYTD
WSP Gross |
0619 |
Work Study FYTD
Gross |
Fiscal year-to-date total of Work Study earnings for the associated Work Study Limit key and Work Study Limit. | IFNW | ||||||||||||
Grade |
2008 |
Salary Grade |
The grade level of an employees title code, if the title code is associated with a grade. See campus Title and Pay Plan. | EAPP EAPC IAPS IAPP IAPT |
||||||||||||
GTN
No |
N/A |
N/A |
Gross-to-Net Deduction number
(see GTN Table) plus the balance type: G = Deduction Amount Y = Year-to-Date Deduction S = Suspended Balance Q = Quarter-to-Date Deduction Amount D = Declining Balance F = Fiscal Year-to-Date Deduction Amount U = User Defined Balance |
IRET IDED |
||||||||||||
H% |
8104 |
Leave History
Hours Code |
H = Time reported in hours blank = Time reported in % |
ILAH | ||||||||||||
Health
Eff Date |
0294 |
Medical Coverage
Effective Date |
EINS IINS |
|||||||||||||
Health
Opt Out Code |
0377 |
Medical Opt
Out Code |
X = Opted not to participate C = Canceled D = De-enrolled blank = No action to be taken |
EINS IINS |
||||||||||||
Health
Plan Contr |
N/A |
N/A |
UC Contribution amount if applicable | IINS |
||||||||||||
Health
Plan Coverage Code |
0293 |
Medical Plan
Coverage Code |
1st character = Employee only 2nd character = Two Party = Employee + one dependent 3rd character = Family U = uninsured by Medicare M = insured by Medicare blank = no coverage |
IINS | ||||||||||||
Health
Plan Description |
0292 |
Medical Plan
Code |
CM = Core Medical FP = PacifiCare HG = FHP Takecare HN = Health Net KS = Kaiser South PH = Prudential High Option UC = UC Care |
EINS IINS |
||||||||||||
Health
Plan Empl Cost |
N/A |
N/A |
Employee plan cost if applicable | IINS | ||||||||||||
Health
Plan Provider ID |
0653 |
Medical Provider
ID |
For Health Net participants only. See Health Net insurance plan booklet. | EINS | ||||||||||||
Highest
Degree Institution Code |
0701 |
Highest Degree
Institution Code |
See School Code table at http://www.ucop.edu/irc/dd/cps/cps0921.html. | EPD2 | ||||||||||||
Highest
Degree Specialty Code |
0710 |
Highest Degree
Specialty Code |
See Specialty Code table. | EPD2 | ||||||||||||
Home
Department Hm Dept |
0114 |
Home Department
Code |
See Campus Organizational Hierarchy
table at:
http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity.
|
EPER All Detail Screens in IEDB & IDDB |
||||||||||||
Home
Dept Addr |
N/A |
N/A |
See Campus Organizational Hierarchy table at: http://santafe.ucr.edu/goldentree/GoldenTree.asp?Tree=Activity. | IPER | ||||||||||||
Home
Phone Hm Phone |
0210 |
Home Phone Number |
EPD1 IPER |
|||||||||||||
Honor
Date |
0714 |
Honor Date |
Date the employee received the honor for academic achievement. | EHON | ||||||||||||
Honor
Type |
0713 |
Honor Type Code |
Honor received by an academic
employee for academic achievement.
|
EHON | ||||||||||||
Hours
Toward Accrl |
8103 |
Leave History
Hours Toward Accrual |
The number of hours on pay status that count toward leave accrual. | ILAH | ||||||||||||
HRS
on Pay Stat:Curr Month |
5119 |
Current Month
Hours on Pay Status |
Includes all hours defined in the DOS code table as counting towards hours on pay status. This excludes overtime, differentials, etc. | IHRS INBI |
||||||||||||
HRS
on Pay Stat:Jan |
5120 |
Hours on Pay
Status-January |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Feb |
5121 |
Hours on Pay
Status-February |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Mar |
5122 |
Hours on Pay
Status-March |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Apr |
5123 |
Hours on Pay
Status-April |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:May |
5124 |
Hours on Pay
Status-May |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Jun |
5125 |
Hours on Pay
Status-June |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Jul |
5126 |
Hours on Pay
Status-July |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Aug |
5127 |
Hours on Pay
Status-August |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Sep |
5128 |
Hours on Pay
Status-September |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Oct |
5129 |
Hours on Pay
Status-October |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Nov |
5130 |
Hours on Pay
Status-November |
IHRS INBI |
|||||||||||||
HRS
on Pay Stat:Dec |
5131 |
Hours on Pay
Status-December |
IHRS INBI |
|||||||||||||
Hours
Toward Benefits Eligibility - Total Hrs at Month Begin |
5142 |
Hours Toward
Benefits Eligibility - Total |
The total number of hours that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - Current Month |
5143 |
Hours Toward
Benefits Eligibility - Current Month |
The total number of hours reported in the current month that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - January |
5144 |
Hours Toward
Benefits Eligibility - January |
The total number of hours reported in January that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - February |
5145 |
Hours Toward
Benefits Eligibility - February |
The total number of hours reported in February that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - March |
5146 |
Hours Toward
Benefits Eligibility - March |
The total number of hours reported in March that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - April |
5147 |
Hours Toward
Benefits Eligibility - April |
The total number of hours reported in April that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - May |
5148 |
Hours Toward
Benefits Eligibility - May |
The total number of hours reported in May that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - June |
5149 |
Hours Toward
Benefits Eligibility - June |
The total number of hours reported in June that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - July |
5150 |
Hours Toward
Benefits Eligibility - July |
The total number of hours reported in July that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - August |
5151 |
Hours Toward
Benefits Eligibility - August |
The total number of hours reported in August that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours have been totaled (i.e. month end has been run). | IHR2 | ||||||||||||
Hours
Toward Benefits Eligibility - September |
5152 |
Hours Toward
Benefits Eligibility - September |
The total number of hours reported in September that qualify toward eligibility for retirement and benefits. This excludes overtime, differential, hours worked as casual restricted, per diem, etc. Note: The asterisk (*) indicates the most recent month of the rolling twelve month period for which the hours h |