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

Franklin A. Macaulay

EMP-0122500 · Employee · projected from the master template

employee_id
EMP-0122500
seq
122,500
first_name
Franklin
last_name
Macaulay
middle_initial
A
full_name
Franklin A. Macaulay
work_email
franklin.a.macaulay@tesseracourt.com
work_phone
+1-846-284-8453
home_address_line1
1788 Quarry Lane
job_title
Senior Research Scientist
job_code
RD-02-0
job_family
Research & Development
flsa_status
exempt
job_level
2
job_level_name
Senior Specialist
job_level_code
IC3
is_people_manager
no
is_executive
no
department_code
RD
department_name
Research & Development
department_function
Technology
cost_center
CC-1900
location_code
JP-TYO
location_city
Tokyo
location_region
Tokyo
location_country
Japan
location_country_code
JP
location_timezone
Asia/Tokyo
manager_id
EMP-0018605
manager_seq
18,605
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2020-07-21
tenure_years
6.15
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1980-08-04
age
46
gender
Male
ethnicity
White
base_salary_cents
13,835,058
base_salary
$138,351
currency
JPY
bonus_target_pct
7%
bonus_target
$9,685
equity_units
150
compa_ratio
1.002
band_min_cents
8,118,000
band_mid_cents
9,900,000
band_max_cents
12,276,000
department_ordinal
14
location_ordinal
21
employment_status_ordinal
0
performance_rating
3
engagement_score
51
flight_risk_score
53
tenure_days
2,184

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0122500-2EMP-0122500Franklin A. Macaulay2026-03-29PromotionPerformance calibration outcome6.31%
CMP-0122500-0EMP-0122500Franklin A. Macaulay2025-09-01PromotionAnnual merit cycle5.7%
CMP-0122500-1EMP-0122500Franklin A. Macaulay2025-06-09Off-cycle adjustmentBenchmark below market P508.24%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0122500-0EMP-0122500Franklin A. MacaulayPTOPaid time off14.10
BAL-0122500-1EMP-0122500Franklin A. MacaulaySICKSick leave70
BAL-0122500-2EMP-0122500Franklin A. MacaulayPARENTParental leave59.10
BAL-0122500-3EMP-0122500Franklin A. MacaulayBEREAVBereavement leave3.50
BAL-0122500-4EMP-0122500Franklin A. MacaulayJURYJury duty70
BAL-0122500-5EMP-0122500Franklin A. MacaulayUNPAIDUnpaid leave of absence21.10
BAL-0122500-6EMP-0122500Franklin A. MacaulayVOLVolunteer day1.40
BAL-0122500-7EMP-0122500Franklin A. MacaulaySABSabbatical21.10

Benefit enrollments (3)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0122500-1EMP-0122500Franklin A. MacaulayDEN-STDDental - StandardDentalactive
BEN-0122500-2EMP-0122500Franklin A. Macaulay401K-ROTHRoth 401(k) - 4% matchRetirementactive
BEN-0122500-0EMP-0122500Franklin A. MacaulayMED-PPO-EEPPO Medical - Employee onlyMedicalactive

Training (3)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0122500-2EMP-0122500Franklin A. MacaulayPRO-430Presentation SkillsProfessionalno
TRN-0122500-1EMP-0122500Franklin A. MacaulayTEC-301Cloud Architecture FoundationsTechnicalno
TRN-0122500-0EMP-0122500Franklin A. MacaulayCMP-150Workplace Safety & ErgonomicsComplianceyes

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0122500-0048EMP-0122500Franklin A. MacaulayRUN-00482026-07-132026-07-17$8,186
PAY-0122500-0047EMP-0122500Franklin A. MacaulayRUN-00472026-06-282026-07-02$5,765
PAY-0122500-0046EMP-0122500Franklin A. MacaulayRUN-00462026-06-132026-06-17$5,765
PAY-0122500-0045EMP-0122500Franklin A. MacaulayRUN-00452026-05-292026-06-02$5,765
PAY-0122500-0044EMP-0122500Franklin A. MacaulayRUN-00442026-05-142026-05-18$5,765
PAY-0122500-0043EMP-0122500Franklin A. MacaulayRUN-00432026-04-292026-05-03$5,765
PAY-0122500-0042EMP-0122500Franklin A. MacaulayRUN-00422026-04-142026-04-18$8,186
PAY-0122500-0041EMP-0122500Franklin A. MacaulayRUN-00412026-03-302026-04-03$5,765
PAY-0122500-0040EMP-0122500Franklin A. MacaulayRUN-00402026-03-152026-03-19$5,765
PAY-0122500-0039EMP-0122500Franklin A. MacaulayRUN-00392026-02-282026-03-04$5,765

See all 48 →