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

Ambrose B. Gupta

EMP-0216620 · Employee · projected from the master template

employee_id
EMP-0216620
seq
216,620
first_name
Ambrose
last_name
Gupta
middle_initial
B
full_name
Ambrose B. Gupta
work_email
ambrose.b.gupta@tesseracourt.com
work_phone
+1-345-270-7004
home_address_line1
6296 Orchard Path
job_title
Support Specialist II
job_code
CS-01-1
job_family
Customer Support
flsa_status
exempt
job_level
1
job_level_name
Specialist
job_level_code
IC2
is_people_manager
no
is_executive
no
department_code
CS
department_name
Customer Support
department_function
Revenue
cost_center
CC-2400
location_code
BR-SAO
location_city
Sao Paulo
location_region
Sao Paulo
location_country
Brazil
location_country_code
BR
location_timezone
America/Sao_Paulo
manager_id
EMP-0029063
manager_seq
29,063
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2023-07-25
tenure_years
3.14
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1992-04-06
age
34
gender
Male
ethnicity
White
base_salary_cents
3,516,652
base_salary
$35,167
currency
BRL
bonus_target_pct
5%
bonus_target
$1,758
equity_units
50
compa_ratio
0.903
band_min_cents
6,232,000
band_mid_cents
7,600,000
band_max_cents
9,424,000
department_ordinal
3
location_ordinal
23
employment_status_ordinal
0
performance_rating
3
engagement_score
49
flight_risk_score
62
tenure_days
1,086

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0216620-0EMP-0216620Ambrose B. Gupta2024-09-15PromotionPromotion to next level4.39%
CMP-0216620-2EMP-0216620Ambrose B. Gupta2024-03-04Annual bonusCounter-offer approved by CHRO12.72%
CMP-0216620-1EMP-0216620Ambrose B. Gupta2023-11-05Role changeCounter-offer approved by CHRO12.18%

Leave balances (8)

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

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0216620-1EMP-0216620Ambrose B. GuptaDEN-STDDental - StandardDentalactive
BEN-0216620-0EMP-0216620Ambrose B. GuptaMED-PPO-EEPPO Medical - Employee onlyMedicalactive

Training (3)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0216620-2EMP-0216620Ambrose B. GuptaTEC-301Cloud Architecture FoundationsTechnicalno
TRN-0216620-1EMP-0216620Ambrose B. GuptaCMP-150Workplace Safety & ErgonomicsComplianceyes
TRN-0216620-0EMP-0216620Ambrose B. GuptaWEL-501Mental Health First AidWellbeingno

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0216620-0048EMP-0216620Ambrose B. GuptaRUN-00482026-07-142026-07-18$1,905
PAY-0216620-0047EMP-0216620Ambrose B. GuptaRUN-00472026-06-292026-07-03$1,465
PAY-0216620-0046EMP-0216620Ambrose B. GuptaRUN-00462026-06-142026-06-18$1,465
PAY-0216620-0045EMP-0216620Ambrose B. GuptaRUN-00452026-05-302026-06-03$1,465
PAY-0216620-0044EMP-0216620Ambrose B. GuptaRUN-00442026-05-152026-05-19$1,465
PAY-0216620-0043EMP-0216620Ambrose B. GuptaRUN-00432026-04-302026-05-04$1,465
PAY-0216620-0042EMP-0216620Ambrose B. GuptaRUN-00422026-04-152026-04-19$1,905
PAY-0216620-0041EMP-0216620Ambrose B. GuptaRUN-00412026-03-312026-04-04$1,465
PAY-0216620-0040EMP-0216620Ambrose B. GuptaRUN-00402026-03-162026-03-20$1,465
PAY-0216620-0039EMP-0216620Ambrose B. GuptaRUN-00392026-03-012026-03-05$1,465

See all 48 →