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

Franklin Xiong

EMP-0034500 · Employee · projected from the master template

employee_id
EMP-0034500
seq
34,500
first_name
Franklin
last_name
Xiong
middle_initial
—
full_name
Franklin Xiong
work_email
franklin.xiong@tesseracourt.com
work_phone
+1-495-251-5160
home_address_line1
4904 Elmwood Place
job_title
Sales Manager
job_code
SLS-04-0
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-AUS
location_city
Austin
location_region
Texas
location_country
United States
location_country_code
US
location_timezone
America/Chicago
manager_id
EMP-0007624
manager_seq
7,624
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2020-12-13
tenure_years
5.75
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1979-02-26
age
47
gender
Male
ethnicity
Asian
base_salary_cents
16,039,336
base_salary
$160,393
currency
USD
bonus_target_pct
12%
bonus_target
$19,247
equity_units
600
compa_ratio
0.979
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
1
location_ordinal
3
employment_status_ordinal
0
performance_rating
3
engagement_score
75
flight_risk_score
27
tenure_days
2,040

Compensation history (1)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0034500-0EMP-0034500Franklin Xiong2021-09-01Annual bonusPerformance calibration outcome5.83%

Performance reviews (4)

review_idemployee_idemployee_namecycle_coderatingrating_labelpotential
REV-0034500-0EMP-0034500Franklin XiongFY-CUR-H12Needs improvementHigh potential
REV-0034500-1EMP-0034500Franklin XiongFY-PRV-EOY3Meets expectationsHigh potential
REV-0034500-2EMP-0034500Franklin XiongFY-PRV-H12Needs improvementModerate potential
REV-0034500-3EMP-0034500Franklin XiongFY-P2-EOY3Meets expectationsHigh potential

Goals (2)

goal_idemployee_idemployee_nametitlecategoryprogress_pctstatus
GOL-0034500-0EMP-0034500Franklin XiongReduce third-party spend by 12%Customer60%at risk
GOL-0034500-1EMP-0034500Franklin XiongClose the top five audit findingsRisk and compliance89%on track

Time off requests (2)

request_idemployee_idemployee_nameleave_typestart_dateend_datebusiness_days
TOR-0034500-0EMP-0034500Franklin XiongVolunteer day2026-10-122026-10-187
TOR-0034500-1EMP-0034500Franklin XiongParental leave2026-09-152026-09-162

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0034500-0EMP-0034500Franklin XiongPTOPaid time off14.10
BAL-0034500-1EMP-0034500Franklin XiongSICKSick leave7.10
BAL-0034500-2EMP-0034500Franklin XiongPARENTParental leave59.40
BAL-0034500-3EMP-0034500Franklin XiongBEREAVBereavement leave3.50
BAL-0034500-4EMP-0034500Franklin XiongJURYJury duty7.10
BAL-0034500-5EMP-0034500Franklin XiongUNPAIDUnpaid leave of absence21.20
BAL-0034500-6EMP-0034500Franklin XiongVOLVolunteer day1.40
BAL-0034500-7EMP-0034500Franklin XiongSABSabbatical21.20

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0034500-0EMP-0034500Franklin XiongMED-PPO-EEPPO Medical - Employee onlyMedicalactive
BEN-0034500-1EMP-0034500Franklin XiongDEN-STDDental - StandardDentalactive

Training (3)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0034500-1EMP-0034500Franklin XiongCMP-101Code of ConductComplianceyes
TRN-0034500-0EMP-0034500Franklin XiongPRO-420Negotiation EssentialsProfessionalno
TRN-0034500-2EMP-0034500Franklin XiongLDR-201First-Time Manager FundamentalsLeadershipno

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0034500-0048EMP-0034500Franklin XiongRUN-00482026-07-142026-07-18$11,495
PAY-0034500-0047EMP-0034500Franklin XiongRUN-00472026-06-292026-07-03$6,683
PAY-0034500-0046EMP-0034500Franklin XiongRUN-00462026-06-142026-06-18$6,683
PAY-0034500-0045EMP-0034500Franklin XiongRUN-00452026-05-302026-06-03$6,683
PAY-0034500-0044EMP-0034500Franklin XiongRUN-00442026-05-152026-05-19$6,683
PAY-0034500-0043EMP-0034500Franklin XiongRUN-00432026-04-302026-05-04$6,683
PAY-0034500-0042EMP-0034500Franklin XiongRUN-00422026-04-152026-04-19$11,495
PAY-0034500-0041EMP-0034500Franklin XiongRUN-00412026-03-312026-04-04$6,683
PAY-0034500-0040EMP-0034500Franklin XiongRUN-00402026-03-162026-03-20$6,683
PAY-0034500-0039EMP-0034500Franklin XiongRUN-00392026-03-012026-03-05$6,683

See all 48 →

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0265547MagnusPrasadMagnus C. Prasadmagnus.c.prasad@tesseracourt.comAssociate Account Executive0
EMP-0265548AmbroseDandekarAmbrose C. Dandekarambrose.c.dandekar@tesseracourt.comAssociate Account Executive0
EMP-0265549KennethPierceKenneth C. Piercekenneth.c.pierce@tesseracourt.comAssociate Account Executive0
EMP-0265550TheresaCostaTheresa C. Costatheresa.c.costa@tesseracourt.comAccount Executive II1
EMP-0265551TessaPetterssonTessa C. Petterssontessa.c.pettersson@tesseracourt.comAccount Executive II1
EMP-0265552LucianCoelhoLucian C. Coelholucian.c.coelho@tesseracourt.comJunior Account Executive0
EMP-0265553FatimaPereiraFatima C. Pereirafatima.c.pereira@tesseracourt.comAccount Executive II1
EMP-0265554EstebanChristensenEsteban C. Christensenesteban.c.christensen@tesseracourt.comSenior Account Executive II2
EMP-0265555ErikaParrishErika C. Parrisherika.c.parrish@tesseracourt.comSenior Account Executive2