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

Benjamin Gupta

EMP-0001166 · Employee · projected from the master template

employee_id
EMP-0001166
seq
1,166
first_name
Benjamin
last_name
Gupta
middle_initial
—
full_name
Benjamin Gupta
work_email
benjamin.gupta@tesseracourt.com
work_phone
+1-812-271-7107
home_address_line1
339 Lantern Way
job_title
Director, Legal
job_code
LGL-06-0
job_family
Legal
flsa_status
exempt
job_level
6
job_level_name
Director
job_level_code
D1
is_people_manager
yes
is_executive
no
department_code
LGL
department_name
Legal
department_function
Corporate
cost_center
CC-4400
location_code
US-CHI
location_city
Chicago
location_region
Illinois
location_country
United States
location_country_code
US
location_timezone
America/Chicago
manager_id
EMP-0000363
manager_seq
363
direct_report_count
4
org_depth
5
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2024-06-18
tenure_years
2.24
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1995-01-31
age
31
gender
Male
ethnicity
American Indian or Alaska Native
base_salary_cents
31,660,979
base_salary
$316,610
currency
USD
bonus_target_pct
20%
bonus_target
$63,322
equity_units
2,200
compa_ratio
1.063
band_min_cents
17,630,000
band_mid_cents
21,500,000
band_max_cents
26,660,000
department_ordinal
15
location_ordinal
4
employment_status_ordinal
0
performance_rating
3
engagement_score
57
flight_risk_score
78
tenure_days
756

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0001166-0EMP-0001166Benjamin GuptaPTOPaid time off14.10
BAL-0001166-1EMP-0001166Benjamin GuptaSICKSick leave70
BAL-0001166-2EMP-0001166Benjamin GuptaPARENTParental leave59.10
BAL-0001166-3EMP-0001166Benjamin GuptaBEREAVBereavement leave3.50
BAL-0001166-4EMP-0001166Benjamin GuptaJURYJury duty70
BAL-0001166-5EMP-0001166Benjamin GuptaUNPAIDUnpaid leave of absence21.10
BAL-0001166-6EMP-0001166Benjamin GuptaVOLVolunteer day1.40
BAL-0001166-7EMP-0001166Benjamin GuptaSABSabbatical21.10

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0001166-0048EMP-0001166Benjamin GuptaRUN-00482026-07-132026-07-17$29,023
PAY-0001166-0047EMP-0001166Benjamin GuptaRUN-00472026-06-282026-07-02$13,192
PAY-0001166-0046EMP-0001166Benjamin GuptaRUN-00462026-06-132026-06-17$13,192
PAY-0001166-0045EMP-0001166Benjamin GuptaRUN-00452026-05-292026-06-02$13,192
PAY-0001166-0044EMP-0001166Benjamin GuptaRUN-00442026-05-142026-05-18$13,192
PAY-0001166-0043EMP-0001166Benjamin GuptaRUN-00432026-04-292026-05-03$13,192
PAY-0001166-0042EMP-0001166Benjamin GuptaRUN-00422026-04-142026-04-18$29,023
PAY-0001166-0041EMP-0001166Benjamin GuptaRUN-00412026-03-302026-04-03$13,192
PAY-0001166-0040EMP-0001166Benjamin GuptaRUN-00402026-03-152026-03-19$13,192
PAY-0001166-0039EMP-0001166Benjamin GuptaRUN-00392026-02-282026-03-04$13,192

See all 48 →

Direct reports (4)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0003835SolveigAinsworthSolveig Ainsworthsolveig.ainsworth@tesseracourt.comSenior Legal Manager5
EMP-0003836AmbroseMeyerAmbrose Meyerambrose.meyer@tesseracourt.comSenior Legal Manager5
EMP-0003837KennethZweigKenneth Zweigkenneth.zweig@tesseracourt.comSenior Manager, Legal5
EMP-0003838LeonardMendesLeonard Mendesleonard.mendes@tesseracourt.comSenior Legal Manager5