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

Kai A. Mercado

EMP-0120004 · Employee · projected from the master template

employee_id
EMP-0120004
seq
120,004
first_name
Kai
last_name
Mercado
middle_initial
A
full_name
Kai A. Mercado
work_email
kai.a.mercado@tesseracourt.com
work_phone
+1-374-202-0269
home_address_line1
9490 Wharf Street
job_title
Principal Data Analyst
job_code
DAT-03-0
job_family
Data & Analytics
flsa_status
exempt
job_level
3
job_level_name
Staff / Principal
job_level_code
IC4
is_people_manager
no
is_executive
no
department_code
DAT
department_name
Data & Analytics
department_function
Technology
cost_center
CC-1600
location_code
IE-DUB
location_city
Dublin
location_region
Leinster
location_country
Ireland
location_country_code
IE
location_timezone
Europe/Dublin
manager_id
EMP-0018328
manager_seq
18,328
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2018-09-28
tenure_years
7.96
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1979-04-20
age
47
gender
Undisclosed
ethnicity
Two or more races
base_salary_cents
17,403,197
base_salary
$174,032
currency
EUR
bonus_target_pct
10%
bonus_target
$17,403
equity_units
450
compa_ratio
0.982
band_min_cents
10,988,000
band_mid_cents
13,400,000
band_max_cents
16,616,000
department_ordinal
10
location_ordinal
14
employment_status_ordinal
0
performance_rating
5
engagement_score
62
flight_risk_score
1
tenure_days
2,847

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0120004-1EMP-0120004Kai A. Mercado2024-02-14Equity refreshRetention risk identified by manager6.62%
CMP-0120004-0EMP-0120004Kai A. Mercado2023-09-07Merit increaseContractual step increase4.19%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0120004-0EMP-0120004Kai A. MercadoPTOPaid time off14.10
BAL-0120004-1EMP-0120004Kai A. MercadoSICKSick leave7.10
BAL-0120004-2EMP-0120004Kai A. MercadoPARENTParental leave59.40
BAL-0120004-3EMP-0120004Kai A. MercadoBEREAVBereavement leave3.50
BAL-0120004-4EMP-0120004Kai A. MercadoJURYJury duty7.10
BAL-0120004-5EMP-0120004Kai A. MercadoUNPAIDUnpaid leave of absence21.20
BAL-0120004-6EMP-0120004Kai A. MercadoVOLVolunteer day1.40
BAL-0120004-7EMP-0120004Kai A. MercadoSABSabbatical21.20

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0120004-0EMP-0120004Kai A. MercadoMED-PPO-FAMPPO Medical - FamilyMedicalactive
BEN-0120004-1EMP-0120004Kai A. MercadoDEN-STDDental - StandardDentalactive

Recent payslips (48)

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

See all 48 →