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

Ilana C. Mehta

EMP-0264220 · Employee · projected from the master template

employee_id
EMP-0264220
seq
264,220
first_name
Ilana
last_name
Mehta
middle_initial
C
full_name
Ilana C. Mehta
work_email
ilana.c.mehta@tesseracourt.com
work_phone
+1-704-242-4203
home_address_line1
8106 Marlborough Street
job_title
Operations Specialist
job_code
OPS-01-0
job_family
Operations
flsa_status
non-exempt
job_level
1
job_level_name
Specialist
job_level_code
IC2
is_people_manager
no
is_executive
no
department_code
OPS
department_name
Operations
department_function
Operations
cost_center
CC-3000
location_code
DE-BER
location_city
Berlin
location_region
Berlin
location_country
Germany
location_country_code
DE
location_timezone
Europe/Berlin
manager_id
EMP-0034352
manager_seq
34,352
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2024-07-12
tenure_years
2.18
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1985-09-11
age
41
gender
Female
ethnicity
Asian
base_salary_cents
6,788,622
base_salary
$67,886
currency
EUR
bonus_target_pct
5%
bonus_target
$3,394
equity_units
50
compa_ratio
0.885
band_min_cents
6,232,000
band_mid_cents
7,600,000
band_max_cents
9,424,000
department_ordinal
2
location_ordinal
15
employment_status_ordinal
0
performance_rating
3
engagement_score
78
flight_risk_score
37
tenure_days
733

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0264220-0EMP-0264220Ilana C. Mehta2025-04-26Merit increasePerformance calibration outcome5.87%
CMP-0264220-1EMP-0264220Ilana C. Mehta2025-02-24Off-cycle adjustmentAnnual merit cycle1.95%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0264220-0EMP-0264220Ilana C. MehtaPTOPaid time off14.10
BAL-0264220-1EMP-0264220Ilana C. MehtaSICKSick leave7.10
BAL-0264220-2EMP-0264220Ilana C. MehtaPARENTParental leave59.40
BAL-0264220-3EMP-0264220Ilana C. MehtaBEREAVBereavement leave3.50
BAL-0264220-4EMP-0264220Ilana C. MehtaJURYJury duty7.10
BAL-0264220-5EMP-0264220Ilana C. MehtaUNPAIDUnpaid leave of absence21.20
BAL-0264220-6EMP-0264220Ilana C. MehtaVOLVolunteer day1.40
BAL-0264220-7EMP-0264220Ilana C. MehtaSABSabbatical21.20

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0264220-0EMP-0264220Ilana C. MehtaMED-PPO-ESPPO Medical - Employee + spouseMedicalpending
BEN-0264220-1EMP-0264220Ilana C. MehtaDEN-STDDental - StandardDentalpending

Training (5)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0264220-1EMP-0264220Ilana C. MehtaLDR-201First-Time Manager FundamentalsLeadershipno
TRN-0264220-0EMP-0264220Ilana C. MehtaCMP-101Code of ConductComplianceyes
TRN-0264220-2EMP-0264220Ilana C. MehtaTEC-320Data Fluency for Non-AnalystsTechnicalno
TRN-0264220-3EMP-0264220Ilana C. MehtaONB-010Benefits Enrollment WalkthroughOnboardingyes
TRN-0264220-4EMP-0264220Ilana C. MehtaCMP-130Information Security AwarenessComplianceyes

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0264220-0048EMP-0264220Ilana C. MehtaRUN-00482026-07-142026-07-18$3,677
PAY-0264220-0047EMP-0264220Ilana C. MehtaRUN-00472026-06-292026-07-03$2,829
PAY-0264220-0046EMP-0264220Ilana C. MehtaRUN-00462026-06-142026-06-18$2,829
PAY-0264220-0045EMP-0264220Ilana C. MehtaRUN-00452026-05-302026-06-03$2,829
PAY-0264220-0044EMP-0264220Ilana C. MehtaRUN-00442026-05-152026-05-19$2,829
PAY-0264220-0043EMP-0264220Ilana C. MehtaRUN-00432026-04-302026-05-04$2,829
PAY-0264220-0042EMP-0264220Ilana C. MehtaRUN-00422026-04-152026-04-19$3,677
PAY-0264220-0041EMP-0264220Ilana C. MehtaRUN-00412026-03-312026-04-04$2,829
PAY-0264220-0040EMP-0264220Ilana C. MehtaRUN-00402026-03-162026-03-20$2,829
PAY-0264220-0039EMP-0264220Ilana C. MehtaRUN-00392026-03-012026-03-05$2,829

See all 48 →