EDB Data Dictionary
APPOINTMENT FLSA STATUS INDICATOR
HOURS TOWARD CAREER STATUS ELIGIBILITY - TOTAL AT MONTH BEGIN
HOURS TOWARD BENEFITS ELIGIBILITY - TOTAL
NUMBER OF REGISTERED UC STUDENT UNITS
PRIMARY BELI STATUS QUALIFICATION CODE
PRIMARY BELI STATUS QUALIFICATION EFF DATE
RETIREMENT/FICA DERIVATION INDICATOR
SECONDARY BELI STATUS QUALIFICATION CODE
SECONDARY BELI STATUS QUALIFICATION EFF DATE
System Number: EDB2005
User Access Name: 2005-7
Programming Name: APPT_FLSA_IND IN PPPAPP
Revision Date: 06/19/00
Comments
Name: APPOINTMENT FLSA STATUS INDICATOR
Type: NUMERIC
Length: 1
Format
N/A
General Description
Code indicating whether the appointment Title Code-EDB (EDB2006) is exempt from the Fair Labor Standards Act regulations regarding overtime.
Code Interpretation
0 - Non-exempt from Fair Labor Standards Act regulations 1 - Exempt from Fair Labor Standards Act regulations
System Number: EDB5142
User Access Name: 5142-8
Programming Name: HRS_BEN_ELIG_TOT IN PPPPCM
Revision Date: 06/21/01
Comments
Source(s): PPP390, PPP130 Use(s): PPP711 (copy member CPWSXECP) Location(s):
Name: HOURS TOWARD BENEFITS ELIGIBILITY - TOTAL
Type: NUMERIC
Length: 9
Format
nnnnnnn.nn
General Description
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.
Code Interpretation
N/A
System Number: EDB0426
User Access Name:0426-2
Programming Name: HRS_CAR_ELIG_TOT IN PPPPCM
Revision Date:06/21/01
Comments
Source(s): PPP390, PPP130 Use(s): PPP711 (copy member CPWSXECP) Location(s):
Name: HOURS TOWARD CAREER STATUS ELIGIBILITY - TOTAL AT MONTH BEGIN
Type: NUMERIC
Length: 9
Format
nnnnnnn.nn
General Description
The total number of hours that qualify toward eligibility for career status, as of the beginning of the current process month.
Code Interpretation
N/A
System Number: EDB0237
User Access Name: 0237-4
Programming Name: REGISTERD_UNITS IN PPPPER
Revision Date: PUBL. 06/21/01
Comments
Location(s): N/A
Name: NUMBER OF REGISTERED UC STUDENT UNITS
Type: ALPHANUMERIC
Length: 3
Format
N/A
General Description
Code indicating the number of UC class units in which an employee who is a UC student is registered.
Code Interpretation
00.0 - Not registered for any UC class units
00.1-50.0 - Number of UC class units for which registered
88.8 - Graduate student enrolled and registered
for dissertation advisement only
99.9 - Number of UC class units for which registered not available
System Number: EDB0240
User Access Name: 0240-4
Programming Name: PRI_STAT_QUAL_CODE IN PPPBEL
Revision Date: 09/29/08
Comments
Location(s): BCS4203 - Primary BELI Status Qualification Code
Name: PRIMARY BELI STATUS QUALIFICATION CODE
Type: ALPHANUMERIC
Length: 2
Format
N/A
General Description
Code indicating a condition which causes the value of an individual's Benefits Eligibility Level Indicator-Assigned (EDB 0360) to appear to be "out of compliance."
Code Interpretation
20 - Averaged appointment percent employee (academic) 25 - Academic Student Employee/Graduate Student Researcher 30 - Extended sick leave recipient 40 - Employee rehabilitation 60 - Seasonal employee 70 - Phased retiree 90 - Sabbatical/Leave for professional renewal
Previous Code Values (prior to 08/2003):
10 - Appointee with ending date for funding purposes only 50 - Split student/non-student appointee ineligible for benefits 80 - "Grandfathered" employee
System Number: EDB0241
User Access Name: 0241-5
Programming Name: PRI_STAT_QUAL_DATE IN PPPBEL
Revision Date: PUBL. 07/01/92
Comments
Location(s): BCS4204 - Primary BELI Status Qualification Code Eff Date
Name: PRIMARY BELI STATUS QUALIFICATION EFF DATE
Type: NUMERIC
Length: 6
Format
MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update
General Description
Code indicating the effective month, day, and year of the Primary BELI Status Qualification Code (EDB 0240).
Code Interpretation
N/A
System Number: EDB0238
User Access Name: 0238-5
Programming Name: RET_FICA_DERIVE IN PPPPAY
Revision Date: PUBL. MM/DD/YY
Comments
Location(s): N/A
Name: RETIREMENT/FICA DERIVATION INDICATOR
Type: ALPHANUMERIC
Length: 1
Format
N/A
General Description
Code indicating whether the Retirement System Code (EDB 0122) and the FICA Eligibility Code (EDB 0120) should be automatically derived by the system.
Code Interpretation
N - Do not derive EDB0122 and EDB0120
Y - Derive EDB0122 and EDB0120
L - Derive EDB0122 and EDB0120 using special derivation
rules for UCRP members who, in 1976, made a lifetime election not
to be coordinated with FICA.
R - Do not derive EDB0122 and EDB0120; employee is a rehired annuitant
who has waived re-entry rights
1 - Derive EDB0122 and EDB0120 using special derivation rules
for a rehire whose prior Retirement/FICA Derivation Indicator
had a value of "Y"
2 - Derive EDB0122 and EDB0120 using special derivation rules
for a rehire whose prior Retirement/FICA Derivation Indicator
had a value of "L"
3 - Derive EDB0122 and EDB0120 using special derivation rules
for a rehire whose prior Retirement/FICA Derivation Indicator
had a value of "N"
4 - Derive EDB0122 and EDB0120 using special derivation rules
for a rehire whose prior Retirement/FICA Derivation Indicator
had a value of "R"
System Number: EDB0242
User Access Name: 0242-6
Programming Name: SEC_STAT_QUAL_CODE IN PPPBEL
Revision Date: 05/15/15
Comments
Location(s): BCS4205 - Secondary BELI Status Qualification Code
Name: SECONDARY BELI STATUS QUALIFICATION CODE
Type: ALPHANUMERIC
Length: 2
Format
N/A
General Description
Code indicating the employee’s full-time or part time status with regard to the measurement periods required by the Affordable Care Act.
Code Interpretation
51 - Full-time (manually set) 52 - Interlocation Transfer (manually set) 61 - Full-time Standard 62 - Part-time Standard 63 - Full-time Initial 64 - Part-time Initial 71 - Full-time Initial to Full-time Standard 72 - Full-time Initial to Part-time Standard 73 - Part-time Initial to Full-time Standard 74 - Part-time Initial to Part-time Standard 75 - Full-time Standard to Part-time Standard 76 - Full-time Standard to Full-time Standard 77 - Part-time Standard to Part-time Standard 78 - Part-time Standard to Full-time Standard 98 - Ineligible 17.5 Hours Standard 99 - No Hours
Previous Code Values (prior to 5/2015):
99 - Reserved
Previous Code Values (prior to 11/2014):
20 - Averaged appointment percent employee (academic) 25 - Academic Student Employee/Graduate Student Researcher 30 - Extended sick leave recipient 40 - Employee rehabilitation 60 - Seasonal employee 70 - Phased retiree 90 - Sabbatical/Leave for professional renewal
Previous Code Values (prior to 08/2003):
10 - Appointee with ending date for funding purposes only 50 - Split student/non-student appointee ineligible for benefits 80 - "Grandfathered" employee
System Number: EDB0243
User Access Name: 0243-7
Programming Name: SEC_STAT_QUAL_DATE IN PPPBEL
Revision Date: PUBL. 07/01/92
Comments
Location(s): BCS4206 - Secondary BELI Status Qualification Code Date
Name: SECONDARY BELI STATUS QUALIFICATION EFF DATE
Type: NUMERIC
Length: 6
Format
MM/DD/YY - Inquiry Only; MMDDYY - Entry/Update
General Description
Date indicating the effective month, day, and year of the current Secondary BELI Status Qualification Code (EDB 0242).
Code Interpretation
N/A