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

Magnus Sparrow

EMP-0049696 · Employee · projected from the master template

employee_id
EMP-0049696
seq
49,696
first_name
Magnus
last_name
Sparrow
middle_initial
—
full_name
Magnus Sparrow
work_email
magnus.sparrow@northline.com
work_phone
+1-281-218-1832
home_address_line1
1857 Ironworks Lane
job_title
Junior Data Analyst
job_code
DAT-00-1
job_family
Data & Analytics
flsa_status
exempt
job_level
0
job_level_name
Associate
job_level_code
IC1
is_people_manager
no
is_executive
no
department_code
DAT
department_name
Data & Analytics
department_function
Technology
cost_center
CC-1600
location_code
CA-VAN
location_city
Vancouver
location_region
British Columbia
location_country
Canada
location_country_code
CA
location_timezone
America/Vancouver
manager_id
EMP-0009070
manager_seq
9,070
direct_report_count
0
org_depth
8
employment_type
Part-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2024-10-06
tenure_years
1.94
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1974-11-11
age
52
gender
Male
ethnicity
White
base_salary_cents
6,948,324
base_salary
$69,483
currency
CAD
bonus_target_pct
3%
bonus_target
$2,085
equity_units
0
compa_ratio
1.172
band_min_cents
4,756,000
band_mid_cents
5,800,000
band_max_cents
7,192,000
department_ordinal
10
location_ordinal
11
employment_status_ordinal
0
performance_rating
4
engagement_score
26
flight_risk_score
12
tenure_days
272

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0049696-1EMP-0049696Magnus Sparrow2025-06-11Merit increaseCounter-offer approved by CHRO3.66%
CMP-0049696-2EMP-0049696Magnus Sparrow2025-05-11Role changePromotion to next level13.29%
CMP-0049696-0EMP-0049696Magnus Sparrow2024-11-10Role changeExpanded scope of responsibility11.36%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0049696-0EMP-0049696Magnus SparrowPTOPaid time off14.10
BAL-0049696-1EMP-0049696Magnus SparrowSICKSick leave70
BAL-0049696-2EMP-0049696Magnus SparrowPARENTParental leave59.10
BAL-0049696-3EMP-0049696Magnus SparrowBEREAVBereavement leave3.50
BAL-0049696-4EMP-0049696Magnus SparrowJURYJury duty70
BAL-0049696-5EMP-0049696Magnus SparrowUNPAIDUnpaid leave of absence21.10
BAL-0049696-6EMP-0049696Magnus SparrowVOLVolunteer day1.40
BAL-0049696-7EMP-0049696Magnus SparrowSABSabbatical21.10

Benefit enrollments (4)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0049696-0EMP-0049696Magnus SparrowMED-PPO-EEPPO Medical - Employee onlyMedicalactive
BEN-0049696-1EMP-0049696Magnus SparrowDEN-FAMDental - FamilyDentalactive
BEN-0049696-2EMP-0049696Magnus Sparrow401K-STD401(k) - 4% matchRetirementactive
BEN-0049696-3EMP-0049696Magnus SparrowLTDLong-term disabilityDisabilityactive

Recent payslips (19)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0049696-0048EMP-0049696Magnus SparrowRUN-00482025-07-042025-07-08$3,416
PAY-0049696-0047EMP-0049696Magnus SparrowRUN-00472025-06-192025-06-23$2,895
PAY-0049696-0046EMP-0049696Magnus SparrowRUN-00462025-06-042025-06-08$2,895
PAY-0049696-0045EMP-0049696Magnus SparrowRUN-00452025-05-202025-05-24$2,895
PAY-0049696-0044EMP-0049696Magnus SparrowRUN-00442025-05-052025-05-09$2,895
PAY-0049696-0043EMP-0049696Magnus SparrowRUN-00432025-04-202025-04-24$2,895
PAY-0049696-0042EMP-0049696Magnus SparrowRUN-00422025-04-052025-04-09$3,416
PAY-0049696-0041EMP-0049696Magnus SparrowRUN-00412025-03-212025-03-25$2,895
PAY-0049696-0040EMP-0049696Magnus SparrowRUN-00402025-03-062025-03-10$2,895
PAY-0049696-0039EMP-0049696Magnus SparrowRUN-00392025-02-192025-02-23$2,895

See all 19 →