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

Hamish C. Kapoor

EMP-0270212 · Employee · projected from the master template

employee_id
EMP-0270212
seq
270,212
first_name
Hamish
last_name
Kapoor
middle_initial
C
full_name
Hamish C. Kapoor
work_email
hamish.c.kapoor@tesseracourt.com
work_phone
+1-787-274-7445
home_address_line1
5803 Fernbank Road
job_title
Account Executive II
job_code
SLS-01-1
job_family
Sales
flsa_status
exempt
job_level
1
job_level_name
Specialist
job_level_code
IC2
is_people_manager
no
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
HQ-BOS
location_city
Boston
location_region
Massachusetts
location_country
United States
location_country_code
US
location_timezone
America/New_York
manager_id
EMP-0035018
manager_seq
35,018
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
Remote
employment_status
active
hire_date
2024-08-02
tenure_years
2.12
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1989-02-16
age
37
gender
Male
ethnicity
Asian
base_salary_cents
10,151,301
base_salary
$101,513
currency
USD
bonus_target_pct
5%
bonus_target
$5,076
equity_units
50
compa_ratio
1.043
band_min_cents
6,232,000
band_mid_cents
7,600,000
band_max_cents
9,424,000
department_ordinal
1
location_ordinal
0
employment_status_ordinal
0
performance_rating
3
engagement_score
33
flight_risk_score
64
tenure_days
711

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0270212-1EMP-0270212Hamish C. Kapoor2026-03-21Merit increaseRetention risk identified by manager10.87%
CMP-0270212-0EMP-0270212Hamish C. Kapoor2025-01-08Merit increaseRetention risk identified by manager8.4%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0270212-0EMP-0270212Hamish C. KapoorPTOPaid time off14.10
BAL-0270212-1EMP-0270212Hamish C. KapoorSICKSick leave70
BAL-0270212-2EMP-0270212Hamish C. KapoorPARENTParental leave59.10
BAL-0270212-3EMP-0270212Hamish C. KapoorBEREAVBereavement leave3.50
BAL-0270212-4EMP-0270212Hamish C. KapoorJURYJury duty70
BAL-0270212-5EMP-0270212Hamish C. KapoorUNPAIDUnpaid leave of absence21.10
BAL-0270212-6EMP-0270212Hamish C. KapoorVOLVolunteer day1.40
BAL-0270212-7EMP-0270212Hamish C. KapoorSABSabbatical21.10

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0270212-0EMP-0270212Hamish C. KapoorMED-PPO-EEPPO Medical - Employee onlyMedicalactive
BEN-0270212-1EMP-0270212Hamish C. KapoorDEN-STDDental - StandardDentalactive

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0270212-0048EMP-0270212Hamish C. KapoorRUN-00482026-07-132026-07-17$5,499
PAY-0270212-0047EMP-0270212Hamish C. KapoorRUN-00472026-06-282026-07-02$4,230
PAY-0270212-0046EMP-0270212Hamish C. KapoorRUN-00462026-06-132026-06-17$4,230
PAY-0270212-0045EMP-0270212Hamish C. KapoorRUN-00452026-05-292026-06-02$4,230
PAY-0270212-0044EMP-0270212Hamish C. KapoorRUN-00442026-05-142026-05-18$4,230
PAY-0270212-0043EMP-0270212Hamish C. KapoorRUN-00432026-04-292026-05-03$4,230
PAY-0270212-0042EMP-0270212Hamish C. KapoorRUN-00422026-04-142026-04-18$5,499
PAY-0270212-0041EMP-0270212Hamish C. KapoorRUN-00412026-03-302026-04-03$4,230
PAY-0270212-0040EMP-0270212Hamish C. KapoorRUN-00402026-03-152026-03-19$4,230
PAY-0270212-0039EMP-0270212Hamish C. KapoorRUN-00392026-02-282026-03-04$4,230

See all 48 →