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

Franklin Lehmann

EMP-0025700 · Employee · projected from the master template

employee_id
EMP-0025700
seq
25,700
first_name
Franklin
last_name
Lehmann
middle_initial
full_name
Franklin Lehmann
work_email
franklin.lehmann@tesseracourt.com
work_phone
+1-558-252-5200
home_address_line1
8316 Foundry Row
job_title
Data Manager
job_code
DAT-04-0
job_family
Data & Analytics
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
DAT
department_name
Data & Analytics
department_function
Technology
cost_center
CC-1600
location_code
US-ATL
location_city
Atlanta
location_region
Georgia
location_country
United States
location_country_code
US
location_timezone
America/New_York
manager_id
EMP-0005864
manager_seq
5,864
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
on leave
hire_date
2025-06-22
tenure_years
1.23
termination_date
termination_reason
termination_voluntary
leave_type
Parental leave
date_of_birth
1974-12-14
age
52
gender
Male
ethnicity
White
base_salary_cents
15,955,113
base_salary
$159,551
currency
USD
bonus_target_pct
12%
bonus_target
$19,146
equity_units
600
compa_ratio
0.934
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
10
location_ordinal
6
employment_status_ordinal
1
performance_rating
2
engagement_score
96
flight_risk_score
61
tenure_days
387

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0025700-1EMP-0025700Franklin Lehmann2026-05-27Cost-of-living adjustmentPerformance calibration outcome3.24%
CMP-0025700-0EMP-0025700Franklin Lehmann2026-04-13Cost-of-living adjustmentInternal equity correction3.78%
CMP-0025700-2EMP-0025700Franklin Lehmann2025-11-23Retention awardPromotion to next level5.22%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0025700-0EMP-0025700Franklin LehmannPTOPaid time off14.10
BAL-0025700-1EMP-0025700Franklin LehmannSICKSick leave70
BAL-0025700-2EMP-0025700Franklin LehmannPARENTParental leave59.10
BAL-0025700-3EMP-0025700Franklin LehmannBEREAVBereavement leave3.50
BAL-0025700-4EMP-0025700Franklin LehmannJURYJury duty70
BAL-0025700-5EMP-0025700Franklin LehmannUNPAIDUnpaid leave of absence21.10
BAL-0025700-6EMP-0025700Franklin LehmannVOLVolunteer day1.40
BAL-0025700-7EMP-0025700Franklin LehmannSABSabbatical21.10

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0025700-1EMP-0025700Franklin LehmannDEN-FAMDental - FamilyDentalactive
BEN-0025700-0EMP-0025700Franklin LehmannMED-HDHP-FAMHDHP + HSA - FamilyMedicalactive

Training (4)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0025700-0EMP-0025700Franklin LehmannCMP-101Code of ConductComplianceyes
TRN-0025700-2EMP-0025700Franklin LehmannTEC-320Data Fluency for Non-AnalystsTechnicalno
TRN-0025700-1EMP-0025700Franklin LehmannLDR-201First-Time Manager FundamentalsLeadershipno
TRN-0025700-3EMP-0025700Franklin LehmannONB-010Benefits Enrollment WalkthroughOnboardingyes

Recent payslips (26)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0025700-0048EMP-0025700Franklin LehmannRUN-00482026-07-132026-07-17$11,435
PAY-0025700-0047EMP-0025700Franklin LehmannRUN-00472026-06-282026-07-02$6,648
PAY-0025700-0046EMP-0025700Franklin LehmannRUN-00462026-06-132026-06-17$6,648
PAY-0025700-0045EMP-0025700Franklin LehmannRUN-00452026-05-292026-06-02$6,648
PAY-0025700-0044EMP-0025700Franklin LehmannRUN-00442026-05-142026-05-18$6,648
PAY-0025700-0043EMP-0025700Franklin LehmannRUN-00432026-04-292026-05-03$6,648
PAY-0025700-0042EMP-0025700Franklin LehmannRUN-00422026-04-142026-04-18$11,435
PAY-0025700-0041EMP-0025700Franklin LehmannRUN-00412026-03-302026-04-03$6,648
PAY-0025700-0040EMP-0025700Franklin LehmannRUN-00402026-03-152026-03-19$6,648
PAY-0025700-0039EMP-0025700Franklin LehmannRUN-00392026-02-282026-03-04$6,648

See all 26

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0186347SolveigSadowskiSolveig B. Sadowskisolveig.b.sadowski@tesseracourt.comStaff Data Analyst3
EMP-0186348RosalindFujimotoRosalind B. Fujimotorosalind.b.fujimoto@tesseracourt.comStaff Data Analyst3
EMP-0186349NicoleRuizNicole B. Ruiznicole.b.ruiz@tesseracourt.comAssociate Data Analyst0
EMP-0186350TheresaFontaineTheresa B. Fontainetheresa.b.fontaine@tesseracourt.comSenior Data Analyst II2
EMP-0186351TessaRosalesTessa B. Rosalestessa.b.rosales@tesseracourt.comSenior Data Analyst II2
EMP-0186352WillaFernandesWilla B. Fernandeswilla.b.fernandes@tesseracourt.comPrincipal Data Analyst3
EMP-0186353FatimaRochaFatima B. Rochafatima.b.rocha@tesseracourt.comSenior Data Analyst2
EMP-0186354EstebanFairbanksEsteban B. Fairbanksesteban.b.fairbanks@tesseracourt.comStaff Data Analyst3
EMP-0186355HenrikRidgewayHenrik B. Ridgewayhenrik.b.ridgeway@tesseracourt.comAssociate Data Analyst0