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

Hamish A. Wagner

EMP-0140500 · Employee · projected from the master template

employee_id
EMP-0140500
seq
140,500
first_name
Hamish
last_name
Wagner
middle_initial
A
full_name
Hamish A. Wagner
work_email
hamish.a.wagner@tesseracourt.com
work_phone
+1-777-223-2383
home_address_line1
581 Aspen Ridge
job_title
Staff Operations Specialist
job_code
OPS-03-1
job_family
Operations
flsa_status
exempt
job_level
3
job_level_name
Staff / Principal
job_level_code
IC4
is_people_manager
no
is_executive
no
department_code
OPS
department_name
Operations
department_function
Operations
cost_center
CC-3000
location_code
IN-HYD
location_city
Hyderabad
location_region
Telangana
location_country
India
location_country_code
IN
location_timezone
Asia/Kolkata
manager_id
EMP-0020605
manager_seq
20,605
direct_report_count
0
org_depth
8
employment_type
Part-time regular
work_arrangement
Remote
employment_status
active
hire_date
2016-12-13
tenure_years
9.75
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1979-07-20
age
47
gender
Male
ethnicity
Hispanic or Latino
base_salary_cents
6,414,979
base_salary
$64,150
currency
INR
bonus_target_pct
10%
bonus_target
$6,415
equity_units
450
compa_ratio
1.18
band_min_cents
10,988,000
band_mid_cents
13,400,000
band_max_cents
16,616,000
department_ordinal
2
location_ordinal
19
employment_status_ordinal
0
performance_rating
3
engagement_score
54
flight_risk_score
55
tenure_days
3,501

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0140500-0EMP-0140500Hamish A. Wagner2026-05-03Merit increaseGeographic differential update11.88%
CMP-0140500-1EMP-0140500Hamish A. Wagner2017-03-06Market adjustmentBenchmark below market P5012.03%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0140500-0EMP-0140500Hamish A. WagnerPTOPaid time off14.10
BAL-0140500-1EMP-0140500Hamish A. WagnerSICKSick leave7.10
BAL-0140500-2EMP-0140500Hamish A. WagnerPARENTParental leave59.40
BAL-0140500-3EMP-0140500Hamish A. WagnerBEREAVBereavement leave3.50
BAL-0140500-4EMP-0140500Hamish A. WagnerJURYJury duty7.10
BAL-0140500-5EMP-0140500Hamish A. WagnerUNPAIDUnpaid leave of absence21.20
BAL-0140500-6EMP-0140500Hamish A. WagnerVOLVolunteer day1.40
BAL-0140500-7EMP-0140500Hamish A. WagnerSABSabbatical21.20

Benefit enrollments (4)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0140500-0EMP-0140500Hamish A. WagnerMED-PPO-FAMPPO Medical - FamilyMedicalactive
BEN-0140500-3EMP-0140500Hamish A. WagnerLIFE-SUPSupplemental life (3x salary)Lifeactive
BEN-0140500-1EMP-0140500Hamish A. WagnerDEN-STDDental - StandardDentalactive
BEN-0140500-2EMP-0140500Hamish A. Wagner401K-STD401(k) - 4% matchRetirementactive

Training (5)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0140500-4EMP-0140500Hamish A. WagnerCMP-150Workplace Safety & ErgonomicsComplianceyes
TRN-0140500-2EMP-0140500Hamish A. WagnerPRO-401Structured Problem SolvingProfessionalno
TRN-0140500-1EMP-0140500Hamish A. WagnerLDR-220Leading Through ChangeLeadershipno
TRN-0140500-0EMP-0140500Hamish A. WagnerCMP-120Data Privacy & GDPR EssentialsComplianceyes
TRN-0140500-3EMP-0140500Hamish A. WagnerWEL-501Mental Health First AidWellbeingno

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0140500-0048EMP-0140500Hamish A. WagnerRUN-00482026-07-142026-07-18$4,277
PAY-0140500-0047EMP-0140500Hamish A. WagnerRUN-00472026-06-292026-07-03$2,673
PAY-0140500-0046EMP-0140500Hamish A. WagnerRUN-00462026-06-142026-06-18$2,673
PAY-0140500-0045EMP-0140500Hamish A. WagnerRUN-00452026-05-302026-06-03$2,673
PAY-0140500-0044EMP-0140500Hamish A. WagnerRUN-00442026-05-152026-05-19$2,673
PAY-0140500-0043EMP-0140500Hamish A. WagnerRUN-00432026-04-302026-05-04$2,673
PAY-0140500-0042EMP-0140500Hamish A. WagnerRUN-00422026-04-152026-04-19$4,277
PAY-0140500-0041EMP-0140500Hamish A. WagnerRUN-00412026-03-312026-04-04$2,673
PAY-0140500-0040EMP-0140500Hamish A. WagnerRUN-00402026-03-162026-03-20$2,673
PAY-0140500-0039EMP-0140500Hamish A. WagnerRUN-00392026-03-012026-03-05$2,673

See all 48 →