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

Hamish A. Koenig

EMP-0131700 · Employee · projected from the master template

employee_id
EMP-0131700
seq
131,700
first_name
Hamish
last_name
Koenig
middle_initial
A
full_name
Hamish A. Koenig
work_email
hamish.a.koenig@tesseracourt.com
work_phone
+1-773-292-9226
home_address_line1
2936 Quarry Lane
job_title
Staff Account Executive
job_code
SLS-03-1
job_family
Sales
flsa_status
exempt
job_level
3
job_level_name
Staff / Principal
job_level_code
IC4
is_people_manager
no
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
US-SFO
location_city
San Francisco
location_region
California
location_country
United States
location_country_code
US
location_timezone
America/Los_Angeles
manager_id
EMP-0019628
manager_seq
19,628
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2016-06-12
tenure_years
10.26
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1985-08-12
age
41
gender
Undisclosed
ethnicity
Black or African American
base_salary_cents
20,539,601
base_salary
$205,396
currency
USD
bonus_target_pct
10%
bonus_target
$20,540
equity_units
450
compa_ratio
1.054
band_min_cents
10,988,000
band_mid_cents
13,400,000
band_max_cents
16,616,000
department_ordinal
1
location_ordinal
2
employment_status_ordinal
0
performance_rating
3
engagement_score
26
flight_risk_score
69
tenure_days
3,686

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0131700-2EMP-0131700Hamish A. Koenig2021-07-01Internal transfer adjustmentExpanded scope of responsibility3.1%
CMP-0131700-1EMP-0131700Hamish A. Koenig2018-10-08Retention awardRetention risk identified by manager3.47%
CMP-0131700-0EMP-0131700Hamish A. Koenig2017-01-18Equity refreshPerformance calibration outcome7.23%

Performance reviews (4)

review_idemployee_idemployee_namecycle_coderatingrating_labelpotential
REV-0131700-0EMP-0131700Hamish A. KoenigFY-CUR-H14Exceeds expectationsLow potential
REV-0131700-1EMP-0131700Hamish A. KoenigFY-PRV-EOY4Exceeds expectationsLow potential
REV-0131700-2EMP-0131700Hamish A. KoenigFY-PRV-H12Needs improvementLow potential
REV-0131700-3EMP-0131700Hamish A. KoenigFY-P2-EOY3Meets expectationsLow potential

Goals (2)

goal_idemployee_idemployee_nametitlecategoryprogress_pctstatus
GOL-0131700-1EMP-0131700Hamish A. KoenigPublish the operating handbook for the functionCustomer27%off track
GOL-0131700-0EMP-0131700Hamish A. KoenigEstablish a quarterly business review cadenceGrowth55%at risk

Time off requests (4)

request_idemployee_idemployee_nameleave_typestart_dateend_datebusiness_days
TOR-0131700-0EMP-0131700Hamish A. KoenigPaid time off2026-07-152026-07-173
TOR-0131700-3EMP-0131700Hamish A. KoenigVolunteer day2026-02-242026-03-027
TOR-0131700-1EMP-0131700Hamish A. KoenigSick leave2025-11-222025-11-221
TOR-0131700-2EMP-0131700Hamish A. KoenigPaid time off2025-07-022025-07-021

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0131700-0EMP-0131700Hamish A. KoenigPTOPaid time off14.20
BAL-0131700-1EMP-0131700Hamish A. KoenigSICKSick leave7.10
BAL-0131700-2EMP-0131700Hamish A. KoenigPARENTParental leave59.60
BAL-0131700-3EMP-0131700Hamish A. KoenigBEREAVBereavement leave3.50
BAL-0131700-4EMP-0131700Hamish A. KoenigJURYJury duty7.10
BAL-0131700-5EMP-0131700Hamish A. KoenigUNPAIDUnpaid leave of absence21.30
BAL-0131700-6EMP-0131700Hamish A. KoenigVOLVolunteer day1.47
BAL-0131700-7EMP-0131700Hamish A. KoenigSABSabbatical21.30

Benefit enrollments (3)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0131700-1EMP-0131700Hamish A. KoenigVIS-STDVisionVisionpending
BEN-0131700-2EMP-0131700Hamish A. Koenig401K-ROTHRoth 401(k) - 4% matchRetirementactive
BEN-0131700-0EMP-0131700Hamish A. KoenigMED-HDHP-EEHDHP + HSA - Employee onlyMedicalpending

Training (3)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0131700-0EMP-0131700Hamish A. KoenigTEC-330Applied AI for Business TeamsTechnicalno
TRN-0131700-1EMP-0131700Hamish A. KoenigONB-020Systems & Tooling BootcampOnboardingyes
TRN-0131700-2EMP-0131700Hamish A. KoenigCMP-140Anti-Bribery & CorruptionComplianceyes

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0131700-0048EMP-0131700Hamish A. KoenigRUN-00482026-07-152026-07-19$13,693
PAY-0131700-0047EMP-0131700Hamish A. KoenigRUN-00472026-06-302026-07-04$8,558
PAY-0131700-0046EMP-0131700Hamish A. KoenigRUN-00462026-06-152026-06-19$8,558
PAY-0131700-0045EMP-0131700Hamish A. KoenigRUN-00452026-05-312026-06-04$8,558
PAY-0131700-0044EMP-0131700Hamish A. KoenigRUN-00442026-05-162026-05-20$8,558
PAY-0131700-0043EMP-0131700Hamish A. KoenigRUN-00432026-05-012026-05-05$8,558
PAY-0131700-0042EMP-0131700Hamish A. KoenigRUN-00422026-04-162026-04-20$13,693
PAY-0131700-0041EMP-0131700Hamish A. KoenigRUN-00412026-04-012026-04-05$8,558
PAY-0131700-0040EMP-0131700Hamish A. KoenigRUN-00402026-03-172026-03-21$8,558
PAY-0131700-0039EMP-0131700Hamish A. KoenigRUN-00392026-03-022026-03-06$8,558

See all 48 →