HR Safe Space
Endpoints / load-j1yko-0036 / employees / EMP-0261796

Rafael C. Gupta

EMP-0261796 · Employee · projected from the master template

employee_id
EMP-0261796
seq
261,796
first_name
Rafael
last_name
Gupta
middle_initial
C
full_name
Rafael C. Gupta
work_email
rafael.c.gupta@tesseracourt.com
work_phone
+1-619-218-1821
home_address_line1
7161 Foundry Row
job_title
Senior Support Specialist
job_code
CS-02-0
job_family
Customer Support
flsa_status
exempt
job_level
2
job_level_name
Senior Specialist
job_level_code
IC3
is_people_manager
no
is_executive
no
department_code
CS
department_name
Customer Support
department_function
Revenue
cost_center
CC-2400
location_code
US-SEA
location_city
Seattle
location_region
Washington
location_country
United States
location_country_code
US
location_timezone
America/Los_Angeles
manager_id
EMP-0034083
manager_seq
34,083
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2020-03-12
tenure_years
6.51
termination_date
termination_reason
termination_voluntary
leave_type
date_of_birth
1979-01-09
age
47
gender
Male
ethnicity
Black or African American
base_salary_cents
12,654,372
base_salary
$126,544
currency
USD
bonus_target_pct
7%
bonus_target
$8,858
equity_units
150
compa_ratio
1.145
band_min_cents
8,118,000
band_mid_cents
9,900,000
band_max_cents
12,276,000
department_ordinal
3
location_ordinal
7
employment_status_ordinal
0
performance_rating
3
engagement_score
24
flight_risk_score
17
tenure_days
2,316

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0261796-0EMP-0261796Rafael C. Gupta2026-03-09Annual bonusRetention risk identified by manager3.69%
CMP-0261796-2EMP-0261796Rafael C. Gupta2022-10-13Retention awardExpanded scope of responsibility11.93%
CMP-0261796-1EMP-0261796Rafael C. Gupta2021-01-12Retention awardAnnual merit cycle10.22%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0261796-0EMP-0261796Rafael C. GuptaPTOPaid time off14.10
BAL-0261796-1EMP-0261796Rafael C. GuptaSICKSick leave7.10
BAL-0261796-2EMP-0261796Rafael C. GuptaPARENTParental leave59.40
BAL-0261796-3EMP-0261796Rafael C. GuptaBEREAVBereavement leave3.50
BAL-0261796-4EMP-0261796Rafael C. GuptaJURYJury duty7.10
BAL-0261796-5EMP-0261796Rafael C. GuptaUNPAIDUnpaid leave of absence21.20
BAL-0261796-6EMP-0261796Rafael C. GuptaVOLVolunteer day1.40
BAL-0261796-7EMP-0261796Rafael C. GuptaSABSabbatical21.20

Benefit enrollments (4)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0261796-3EMP-0261796Rafael C. GuptaLTDLong-term disabilityDisabilityactive
BEN-0261796-1EMP-0261796Rafael C. GuptaVIS-STDVisionVisionactive
BEN-0261796-2EMP-0261796Rafael C. Gupta401K-STD401(k) - 4% matchRetirementactive
BEN-0261796-0EMP-0261796Rafael C. GuptaMED-PPO-FAMPPO Medical - FamilyMedicalactive

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0261796-0048EMP-0261796Rafael C. GuptaRUN-00482026-07-142026-07-18$7,487
PAY-0261796-0047EMP-0261796Rafael C. GuptaRUN-00472026-06-292026-07-03$5,273
PAY-0261796-0046EMP-0261796Rafael C. GuptaRUN-00462026-06-142026-06-18$5,273
PAY-0261796-0045EMP-0261796Rafael C. GuptaRUN-00452026-05-302026-06-03$5,273
PAY-0261796-0044EMP-0261796Rafael C. GuptaRUN-00442026-05-152026-05-19$5,273
PAY-0261796-0043EMP-0261796Rafael C. GuptaRUN-00432026-04-302026-05-04$5,273
PAY-0261796-0042EMP-0261796Rafael C. GuptaRUN-00422026-04-152026-04-19$7,487
PAY-0261796-0041EMP-0261796Rafael C. GuptaRUN-00412026-03-312026-04-04$5,273
PAY-0261796-0040EMP-0261796Rafael C. GuptaRUN-00402026-03-162026-03-20$5,273
PAY-0261796-0039EMP-0261796Rafael C. GuptaRUN-00392026-03-012026-03-05$5,273

See all 48