HR Safe Space
Endpoints / ember-pier-3541 / employees / EMP-0125728

Magnus A. Mercado

EMP-0125728 · Employee · projected from the master template

employee_id
EMP-0125728
seq
125,728
first_name
Magnus
last_name
Mercado
middle_initial
A
full_name
Magnus A. Mercado
work_email
magnus.a.mercado@northline.com
work_phone
+1-812-234-3401
home_address_line1
3642 Granite Terrace
job_title
Associate Financial Analyst
job_code
FIN-00-0
job_family
Finance
flsa_status
exempt
job_level
0
job_level_name
Associate
job_level_code
IC1
is_people_manager
no
is_executive
no
department_code
FIN
department_name
Finance
department_function
Corporate
cost_center
CC-4000
location_code
IN-HYD
location_city
Hyderabad
location_region
Telangana
location_country
India
location_country_code
IN
location_timezone
Asia/Kolkata
manager_id
EMP-0017518
manager_seq
17,518
direct_report_count
0
org_depth
8
employment_type
Intern
work_arrangement
Remote
employment_status
active
hire_date
2024-01-24
tenure_years
2.64
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1989-03-29
age
37
gender
Male
ethnicity
Hispanic or Latino
base_salary_cents
2,026,323
base_salary
$20,263
currency
INR
bonus_target_pct
3%
bonus_target
$608
equity_units
0
compa_ratio
0.942
band_min_cents
4,756,000
band_mid_cents
5,800,000
band_max_cents
7,192,000
department_ordinal
6
location_ordinal
19
employment_status_ordinal
0
performance_rating
3
engagement_score
80
flight_risk_score
42
tenure_days
529

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0125728-0EMP-0125728Magnus A. Mercado2025-05-01PromotionCounter-offer approved by CHRO3.48%
CMP-0125728-1EMP-0125728Magnus A. Mercado2025-01-12Off-cycle adjustmentPromotion to next level12.66%

Leave balances (8)

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

Benefit enrollments (5)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0125728-0EMP-0125728Magnus A. MercadoMED-PPO-EEPPO Medical - Employee onlyMedicalactive
BEN-0125728-1EMP-0125728Magnus A. MercadoDEN-FAMDental - FamilyDentalactive
BEN-0125728-2EMP-0125728Magnus A. Mercado401K-STD401(k) - 4% matchRetirementactive
BEN-0125728-3EMP-0125728Magnus A. MercadoSTDShort-term disabilityDisabilitypending
BEN-0125728-4EMP-0125728Magnus A. MercadoFSA-DCDependent care FSASavingsactive

Recent payslips (36)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0125728-0048EMP-0125728Magnus A. MercadoRUN-00482025-07-052025-07-09$996
PAY-0125728-0047EMP-0125728Magnus A. MercadoRUN-00472025-06-202025-06-24$844
PAY-0125728-0046EMP-0125728Magnus A. MercadoRUN-00462025-06-052025-06-09$844
PAY-0125728-0045EMP-0125728Magnus A. MercadoRUN-00452025-05-212025-05-25$844
PAY-0125728-0044EMP-0125728Magnus A. MercadoRUN-00442025-05-062025-05-10$844
PAY-0125728-0043EMP-0125728Magnus A. MercadoRUN-00432025-04-212025-04-25$844
PAY-0125728-0042EMP-0125728Magnus A. MercadoRUN-00422025-04-062025-04-10$996
PAY-0125728-0041EMP-0125728Magnus A. MercadoRUN-00412025-03-222025-03-26$844
PAY-0125728-0040EMP-0125728Magnus A. MercadoRUN-00402025-03-072025-03-11$844
PAY-0125728-0039EMP-0125728Magnus A. MercadoRUN-00392025-02-202025-02-24$844

See all 36 →