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

Lucian A. Mercado

EMP-0133904 · Employee · projected from the master template

employee_id
EMP-0133904
seq
133,904
first_name
Lucian
last_name
Mercado
middle_initial
A
full_name
Lucian A. Mercado
work_email
lucian.a.mercado@tesseracourt.com
work_phone
+1-786-268-6858
home_address_line1
8301 Beacon Hill Road
job_title
Junior Marketing Specialist
job_code
MKT-00-1
job_family
Marketing
flsa_status
exempt
job_level
0
job_level_name
Associate
job_level_code
IC1
is_people_manager
no
is_executive
no
department_code
MKT
department_name
Marketing
department_function
Revenue
cost_center
CC-2200
location_code
ES-MAD
location_city
Madrid
location_region
Madrid
location_country
Spain
location_country_code
ES
location_timezone
Europe/Madrid
manager_id
EMP-0019873
manager_seq
19,873
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2025-12-13
tenure_years
0.76
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1985-02-02
age
41
gender
Male
ethnicity
Native Hawaiian or Other Pacific Islander
base_salary_cents
5,535,807
base_salary
$55,358
currency
EUR
bonus_target_pct
3%
bonus_target
$1,661
equity_units
0
compa_ratio
1.066
band_min_cents
4,756,000
band_mid_cents
5,800,000
band_max_cents
7,192,000
department_ordinal
5
location_ordinal
17
employment_status_ordinal
0
performance_rating
3
engagement_score
44
flight_risk_score
98
tenure_days
214

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0133904-0EMP-0133904Lucian A. Mercado2026-02-21Annual bonusCounter-offer approved by CHRO4.91%
CMP-0133904-1EMP-0133904Lucian A. Mercado2026-02-03Role changeRetention risk identified by manager3.04%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0133904-0EMP-0133904Lucian A. MercadoPTOPaid time off11.70
BAL-0133904-1EMP-0133904Lucian A. MercadoSICKSick leave5.90
BAL-0133904-2EMP-0133904Lucian A. MercadoPARENTParental leave49.20
BAL-0133904-3EMP-0133904Lucian A. MercadoBEREAVBereavement leave2.90
BAL-0133904-4EMP-0133904Lucian A. MercadoJURYJury duty5.90
BAL-0133904-5EMP-0133904Lucian A. MercadoUNPAIDUnpaid leave of absence17.60
BAL-0133904-6EMP-0133904Lucian A. MercadoVOLVolunteer day1.20
BAL-0133904-7EMP-0133904Lucian A. MercadoSABSabbatical17.60

Benefit enrollments (5)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0133904-2EMP-0133904Lucian A. Mercado401K-ROTHRoth 401(k) - 4% matchRetirementactive
BEN-0133904-0EMP-0133904Lucian A. MercadoMED-HDHP-FAMHDHP + HSA - FamilyMedicalactive
BEN-0133904-3EMP-0133904Lucian A. MercadoSTDShort-term disabilityDisabilityactive
BEN-0133904-4EMP-0133904Lucian A. MercadoFSA-HCHealthcare FSASavingsactive
BEN-0133904-1EMP-0133904Lucian A. MercadoDEN-STDDental - StandardDentalactive

Recent payslips (15)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0133904-0048EMP-0133904Lucian A. MercadoRUN-00482026-07-142026-07-18$2,722
PAY-0133904-0047EMP-0133904Lucian A. MercadoRUN-00472026-06-292026-07-03$2,307
PAY-0133904-0046EMP-0133904Lucian A. MercadoRUN-00462026-06-142026-06-18$2,307
PAY-0133904-0045EMP-0133904Lucian A. MercadoRUN-00452026-05-302026-06-03$2,307
PAY-0133904-0044EMP-0133904Lucian A. MercadoRUN-00442026-05-152026-05-19$2,307
PAY-0133904-0043EMP-0133904Lucian A. MercadoRUN-00432026-04-302026-05-04$2,307
PAY-0133904-0042EMP-0133904Lucian A. MercadoRUN-00422026-04-152026-04-19$2,722
PAY-0133904-0041EMP-0133904Lucian A. MercadoRUN-00412026-03-312026-04-04$2,307
PAY-0133904-0040EMP-0133904Lucian A. MercadoRUN-00402026-03-162026-03-20$2,307
PAY-0133904-0039EMP-0133904Lucian A. MercadoRUN-00392026-03-012026-03-05$2,307

See all 15 →