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

Franklin Coelho

EMP-0015844 · Employee · projected from the master template

employee_id
EMP-0015844
seq
15,844
first_name
Franklin
last_name
Coelho
middle_initial
—
full_name
Franklin Coelho
work_email
franklin.coelho@tesseracourt.com
work_phone
+1-302-215-1591
home_address_line1
8011 Linden Way
job_title
Manager, Sales
job_code
SLS-04-1
job_family
Sales
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
US-SEA
location_city
Seattle
location_region
Washington
location_country
United States
location_country_code
US
location_timezone
America/Los_Angeles
manager_id
EMP-0003893
manager_seq
3,893
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2023-08-03
tenure_years
3.12
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1985-09-04
age
41
gender
Male
ethnicity
Asian
base_salary_cents
18,008,555
base_salary
$180,086
currency
USD
bonus_target_pct
12%
bonus_target
$21,610
equity_units
600
compa_ratio
0.919
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
1
location_ordinal
7
employment_status_ordinal
0
performance_rating
2
engagement_score
53
flight_risk_score
64
tenure_days
1,076

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0015844-0EMP-0015844Franklin Coelho2025-11-13Equity refreshContractual step increase8.53%
CMP-0015844-1EMP-0015844Franklin Coelho2025-06-13Off-cycle adjustmentRetention risk identified by manager6.98%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0015844-0EMP-0015844Franklin CoelhoPTOPaid time off14.10
BAL-0015844-1EMP-0015844Franklin CoelhoSICKSick leave70
BAL-0015844-2EMP-0015844Franklin CoelhoPARENTParental leave59.10
BAL-0015844-3EMP-0015844Franklin CoelhoBEREAVBereavement leave3.50
BAL-0015844-4EMP-0015844Franklin CoelhoJURYJury duty70
BAL-0015844-5EMP-0015844Franklin CoelhoUNPAIDUnpaid leave of absence21.10
BAL-0015844-6EMP-0015844Franklin CoelhoVOLVolunteer day1.40
BAL-0015844-7EMP-0015844Franklin CoelhoSABSabbatical21.10

Benefit enrollments (5)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0015844-3EMP-0015844Franklin CoelhoLIFE-1XBasic life insurance (1x salary)Lifeactive
BEN-0015844-4EMP-0015844Franklin CoelhoLEGAL-PLANGroup legal planOtheractive
BEN-0015844-0EMP-0015844Franklin CoelhoMED-PPO-FAMPPO Medical - FamilyMedicalactive
BEN-0015844-1EMP-0015844Franklin CoelhoVIS-STDVisionVisionactive
BEN-0015844-2EMP-0015844Franklin Coelho401K-STD401(k) - 4% matchRetirementactive

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0015844-0048EMP-0015844Franklin CoelhoRUN-00482026-07-132026-07-17$12,906
PAY-0015844-0047EMP-0015844Franklin CoelhoRUN-00472026-06-282026-07-02$7,504
PAY-0015844-0046EMP-0015844Franklin CoelhoRUN-00462026-06-132026-06-17$7,504
PAY-0015844-0045EMP-0015844Franklin CoelhoRUN-00452026-05-292026-06-02$7,504
PAY-0015844-0044EMP-0015844Franklin CoelhoRUN-00442026-05-142026-05-18$7,504
PAY-0015844-0043EMP-0015844Franklin CoelhoRUN-00432026-04-292026-05-03$7,504
PAY-0015844-0042EMP-0015844Franklin CoelhoRUN-00422026-04-142026-04-18$12,906
PAY-0015844-0041EMP-0015844Franklin CoelhoRUN-00412026-03-302026-04-03$7,504
PAY-0015844-0040EMP-0015844Franklin CoelhoRUN-00402026-03-152026-03-19$7,504
PAY-0015844-0039EMP-0015844Franklin CoelhoRUN-00392026-02-282026-03-04$7,504

See all 48 →

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0097643MagnusByrneMagnus A. Byrnemagnus.a.byrne@tesseracourt.comAssociate Account Executive0
EMP-0097644AmbroseNwachukwuAmbrose A. Nwachukwuambrose.a.nwachukwu@tesseracourt.comAccount Executive1
EMP-0097645KennethBrunoKenneth A. Brunokenneth.a.bruno@tesseracourt.comPrincipal Account Executive3
EMP-0097646LeonardNorringtonLeonard A. Norringtonleonard.a.norrington@tesseracourt.comPrincipal Account Executive3
EMP-0097647KwesiBouchardKwesi A. Bouchardkwesi.a.bouchard@tesseracourt.comSenior Account Executive II2
EMP-0097648WillaNightingaleWilla A. Nightingalewilla.a.nightingale@tesseracourt.comPrincipal Account Executive3
EMP-0097649FatimaBoatengFatima A. Boatengfatima.a.boateng@tesseracourt.comAssociate Account Executive0
EMP-0097650MarisolNguyenMarisol A. Nguyenmarisol.a.nguyen@tesseracourt.comSenior Account Executive II2
EMP-0097651HenrikBhattHenrik A. Bhatthenrik.a.bhatt@tesseracourt.comPrincipal Account Executive3