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

Simon Ekstrom

EMP-0011997 · Employee · projected from the master template

employee_id
EMP-0011997
seq
11,997
first_name
Simon
last_name
Ekstrom
middle_initial
—
full_name
Simon Ekstrom
work_email
simon.ekstrom@northline.com
work_phone
+1-658-211-1192
home_address_line1
820 Lantern Way
job_title
Marketing Manager
job_code
MKT-04-0
job_family
Marketing
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
MKT
department_name
Marketing
department_function
Revenue
cost_center
CC-2200
location_code
HQ-BOS
location_city
Boston
location_region
Massachusetts
location_country
United States
location_country_code
US
location_timezone
America/New_York
manager_id
EMP-0002912
manager_seq
2,912
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2023-06-05
tenure_years
3.28
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1977-01-25
age
49
gender
Male
ethnicity
White
base_salary_cents
14,046,384
base_salary
$140,464
currency
USD
bonus_target_pct
12%
bonus_target
$16,856
equity_units
600
compa_ratio
0.961
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
5
location_ordinal
0
employment_status_ordinal
0
performance_rating
3
engagement_score
72
flight_risk_score
82
tenure_days
761

Performance reviews (3)

review_idemployee_idemployee_namecycle_coderatingrating_labelpotential
REV-0011997-0EMP-0011997Simon EkstromFY-CUR-H14Exceeds expectationsHigh potential
REV-0011997-1EMP-0011997Simon EkstromFY-PRV-EOY2Needs improvementModerate potential
REV-0011997-2EMP-0011997Simon EkstromFY-PRV-H12Needs improvementLow potential

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0011997-0EMP-0011997Simon EkstromPTOPaid time off14.10
BAL-0011997-1EMP-0011997Simon EkstromSICKSick leave70
BAL-0011997-2EMP-0011997Simon EkstromPARENTParental leave59.10
BAL-0011997-3EMP-0011997Simon EkstromBEREAVBereavement leave3.50
BAL-0011997-4EMP-0011997Simon EkstromJURYJury duty70
BAL-0011997-5EMP-0011997Simon EkstromUNPAIDUnpaid leave of absence21.10
BAL-0011997-6EMP-0011997Simon EkstromVOLVolunteer day1.40
BAL-0011997-7EMP-0011997Simon EkstromSABSabbatical21.10

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0011997-0048EMP-0011997Simon EkstromRUN-00482025-07-042025-07-08$10,067
PAY-0011997-0047EMP-0011997Simon EkstromRUN-00472025-06-192025-06-23$5,853
PAY-0011997-0046EMP-0011997Simon EkstromRUN-00462025-06-042025-06-08$5,853
PAY-0011997-0045EMP-0011997Simon EkstromRUN-00452025-05-202025-05-24$5,853
PAY-0011997-0044EMP-0011997Simon EkstromRUN-00442025-05-052025-05-09$5,853
PAY-0011997-0043EMP-0011997Simon EkstromRUN-00432025-04-202025-04-24$5,853
PAY-0011997-0042EMP-0011997Simon EkstromRUN-00422025-04-052025-04-09$10,067
PAY-0011997-0041EMP-0011997Simon EkstromRUN-00412025-03-212025-03-25$5,853
PAY-0011997-0040EMP-0011997Simon EkstromRUN-00402025-03-062025-03-10$5,853
PAY-0011997-0039EMP-0011997Simon EkstromRUN-00392025-02-192025-02-23$5,853

See all 48 →

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0076035DesmondFalconerDesmond Falconerdesmond.falconer@northline.comAssociate Marketing Specialist0
EMP-0076036EliasRinaldiElias Rinaldielias.rinaldi@northline.comSenior Marketing Specialist II2
EMP-0076037AlisonEriksenAlison Eriksenalison.eriksen@northline.comMarketing Specialist1
EMP-0076038RussellReyesRussell Reyesrussell.reyes@northline.comMarketing Specialist II1
EMP-0076039BlessingDuranBlessing Duranblessing.duran@northline.comJunior Marketing Specialist0
EMP-0076040EloiseRedmondEloise Redmondeloise.redmond@northline.comMarketing Specialist1
EMP-0076041LeilaDraperLeila Draperleila.draper@northline.comJunior Marketing Specialist0
EMP-0076042MarceloRamsayMarcelo Ramsaymarcelo.ramsay@northline.comAssociate Marketing Specialist0
EMP-0076043WeiDimitrovWei Dimitrovwei.dimitrov@northline.comAssociate Marketing Specialist0