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

Franklin Guerrero

EMP-0000809 · Employee · projected from the master template

employee_id
EMP-0000809
seq
809
first_name
Franklin
last_name
Guerrero
middle_initial
—
full_name
Franklin Guerrero
work_email
franklin.guerrero@northline.com
work_phone
+1-986-280-8069
home_address_line1
6512 Wharf Street
job_title
Director, Sales
job_code
SLS-06-0
job_family
Sales
flsa_status
exempt
job_level
6
job_level_name
Director
job_level_code
D1
is_people_manager
yes
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
US-PHX
location_city
Phoenix
location_region
Arizona
location_country
United States
location_country_code
US
location_timezone
America/Phoenix
manager_id
EMP-0000250
manager_seq
250
direct_report_count
4
org_depth
5
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2023-02-10
tenure_years
3.59
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1977-11-26
age
49
gender
Male
ethnicity
Asian
base_salary_cents
17,207,365
base_salary
$172,074
currency
USD
bonus_target_pct
20%
bonus_target
$34,415
equity_units
2,200
compa_ratio
0.998
band_min_cents
17,630,000
band_mid_cents
21,500,000
band_max_cents
26,660,000
department_ordinal
1
location_ordinal
9
employment_status_ordinal
0
performance_rating
2
engagement_score
25
flight_risk_score
79
tenure_days
876

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0000809-0EMP-0000809Franklin GuerreroPTOPaid time off14.10
BAL-0000809-1EMP-0000809Franklin GuerreroSICKSick leave70
BAL-0000809-2EMP-0000809Franklin GuerreroPARENTParental leave59.10
BAL-0000809-3EMP-0000809Franklin GuerreroBEREAVBereavement leave3.50
BAL-0000809-4EMP-0000809Franklin GuerreroJURYJury duty70
BAL-0000809-5EMP-0000809Franklin GuerreroUNPAIDUnpaid leave of absence21.10
BAL-0000809-6EMP-0000809Franklin GuerreroVOLVolunteer day1.40
BAL-0000809-7EMP-0000809Franklin GuerreroSABSabbatical21.10

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0000809-0048EMP-0000809Franklin GuerreroRUN-00482025-07-042025-07-08$15,773
PAY-0000809-0047EMP-0000809Franklin GuerreroRUN-00472025-06-192025-06-23$7,170
PAY-0000809-0046EMP-0000809Franklin GuerreroRUN-00462025-06-042025-06-08$7,170
PAY-0000809-0045EMP-0000809Franklin GuerreroRUN-00452025-05-202025-05-24$7,170
PAY-0000809-0044EMP-0000809Franklin GuerreroRUN-00442025-05-052025-05-09$7,170
PAY-0000809-0043EMP-0000809Franklin GuerreroRUN-00432025-04-202025-04-24$7,170
PAY-0000809-0042EMP-0000809Franklin GuerreroRUN-00422025-04-052025-04-09$15,773
PAY-0000809-0041EMP-0000809Franklin GuerreroRUN-00412025-03-212025-03-25$7,170
PAY-0000809-0040EMP-0000809Franklin GuerreroRUN-00402025-03-062025-03-10$7,170
PAY-0000809-0039EMP-0000809Franklin GuerreroRUN-00392025-02-192025-02-23$7,170

See all 48 →

Direct reports (4)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0002651WeiTadesseWei Tadessewei.tadesse@northline.comSenior Sales Manager5
EMP-0002652AbigailJimenezAbigail Jimenezabigail.jimenez@northline.comSenior Sales Manager5
EMP-0002653IreneSuzukiIrene Suzukiirene.suzuki@northline.comSenior Sales Manager5
EMP-0002654AlistairJablonskiAlistair Jablonskialistair.jablonski@northline.comSenior Manager, Operations5