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

Ambrose A. Mercado

EMP-0138124 · Employee · projected from the master template

employee_id
EMP-0138124
seq
138,124
first_name
Ambrose
last_name
Mercado
middle_initial
A
full_name
Ambrose A. Mercado
work_email
ambrose.a.mercado@tesseracourt.com
work_phone
+1-368-205-0533
home_address_line1
3862 Stonebridge Avenue
job_title
Junior Supply Chain Planner
job_code
SCM-00-1
job_family
Supply Chain
flsa_status
non-exempt
job_level
0
job_level_name
Associate
job_level_code
IC1
is_people_manager
no
is_executive
no
department_code
SCM
department_name
Supply Chain
department_function
Operations
cost_center
CC-3400
location_code
IE-DUB
location_city
Dublin
location_region
Leinster
location_country
Ireland
location_country_code
IE
location_timezone
Europe/Dublin
manager_id
EMP-0020341
manager_seq
20,341
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2025-03-11
tenure_years
1.51
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1993-04-29
age
33
gender
Undisclosed
ethnicity
White
base_salary_cents
6,115,597
base_salary
$61,156
currency
EUR
bonus_target_pct
3%
bonus_target
$1,835
equity_units
0
compa_ratio
0.99
band_min_cents
4,756,000
band_mid_cents
5,800,000
band_max_cents
7,192,000
department_ordinal
12
location_ordinal
14
employment_status_ordinal
0
performance_rating
3
engagement_score
59
flight_risk_score
50
tenure_days
490

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0138124-2EMP-0138124Ambrose A. Mercado2025-11-24Annual bonusContractual step increase7.86%
CMP-0138124-0EMP-0138124Ambrose A. Mercado2025-10-20Annual bonusRetention risk identified by manager11.13%
CMP-0138124-1EMP-0138124Ambrose A. Mercado2025-05-11Equity refreshPromotion to next level7.93%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0138124-0EMP-0138124Ambrose A. MercadoPTOPaid time off14.10
BAL-0138124-1EMP-0138124Ambrose A. MercadoSICKSick leave70
BAL-0138124-2EMP-0138124Ambrose A. MercadoPARENTParental leave59.10
BAL-0138124-3EMP-0138124Ambrose A. MercadoBEREAVBereavement leave3.50
BAL-0138124-4EMP-0138124Ambrose A. MercadoJURYJury duty70
BAL-0138124-5EMP-0138124Ambrose A. MercadoUNPAIDUnpaid leave of absence21.10
BAL-0138124-6EMP-0138124Ambrose A. MercadoVOLVolunteer day1.40
BAL-0138124-7EMP-0138124Ambrose A. MercadoSABSabbatical21.10

Benefit enrollments (3)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0138124-1EMP-0138124Ambrose A. MercadoDEN-STDDental - StandardDentalpending
BEN-0138124-0EMP-0138124Ambrose A. MercadoMED-HDHP-FAMHDHP + HSA - FamilyMedicalpending
BEN-0138124-2EMP-0138124Ambrose A. Mercado401K-ROTHRoth 401(k) - 4% matchRetirementactive

Recent payslips (33)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0138124-0048EMP-0138124Ambrose A. MercadoRUN-00482026-07-132026-07-17$3,007
PAY-0138124-0047EMP-0138124Ambrose A. MercadoRUN-00472026-06-282026-07-02$2,548
PAY-0138124-0046EMP-0138124Ambrose A. MercadoRUN-00462026-06-132026-06-17$2,548
PAY-0138124-0045EMP-0138124Ambrose A. MercadoRUN-00452026-05-292026-06-02$2,548
PAY-0138124-0044EMP-0138124Ambrose A. MercadoRUN-00442026-05-142026-05-18$2,548
PAY-0138124-0043EMP-0138124Ambrose A. MercadoRUN-00432026-04-292026-05-03$2,548
PAY-0138124-0042EMP-0138124Ambrose A. MercadoRUN-00422026-04-142026-04-18$3,007
PAY-0138124-0041EMP-0138124Ambrose A. MercadoRUN-00412026-03-302026-04-03$2,548
PAY-0138124-0040EMP-0138124Ambrose A. MercadoRUN-00402026-03-152026-03-19$2,548
PAY-0138124-0039EMP-0138124Ambrose A. MercadoRUN-00392026-02-282026-03-04$2,548

See all 33 →