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

Frederick C. Malhotra

EMP-0270186 · Employee · projected from the master template

employee_id
EMP-0270186
seq
270,186
first_name
Frederick
last_name
Malhotra
middle_initial
C
full_name
Frederick C. Malhotra
work_email
frederick.c.malhotra@tesseracourt.com
work_phone
+1-553-200-0091
home_address_line1
2238 Orchard Path
job_title
Senior Account Executive
job_code
SLS-02-0
job_family
Sales
flsa_status
exempt
job_level
2
job_level_name
Senior Specialist
job_level_code
IC3
is_people_manager
no
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
US-CHI
location_city
Chicago
location_region
Illinois
location_country
United States
location_country_code
US
location_timezone
America/Chicago
manager_id
EMP-0035015
manager_seq
35,015
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2019-10-25
tenure_years
6.89
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1980-07-20
age
46
gender
Male
ethnicity
White
base_salary_cents
10,638,441
base_salary
$106,384
currency
USD
bonus_target_pct
7%
bonus_target
$7,447
equity_units
150
compa_ratio
0.943
band_min_cents
8,118,000
band_mid_cents
9,900,000
band_max_cents
12,276,000
department_ordinal
1
location_ordinal
4
employment_status_ordinal
0
performance_rating
3
engagement_score
60
flight_risk_score
81
tenure_days
2,454

Performance reviews (4)

review_idemployee_idemployee_namecycle_coderatingrating_labelpotential
REV-0270186-0EMP-0270186Frederick C. MalhotraFY-CUR-H12Needs improvementLow potential
REV-0270186-1EMP-0270186Frederick C. MalhotraFY-PRV-EOY4Exceeds expectationsLow potential
REV-0270186-2EMP-0270186Frederick C. MalhotraFY-PRV-H12Needs improvementLow potential
REV-0270186-3EMP-0270186Frederick C. MalhotraFY-P2-EOY4Exceeds expectationsModerate potential

Goals (3)

goal_idemployee_idemployee_nametitlecategoryprogress_pctstatus
GOL-0270186-2EMP-0270186Frederick C. MalhotraImprove customer satisfaction score to 4.6People and culture54%at risk
GOL-0270186-1EMP-0270186Frederick C. MalhotraComplete the ISO recertificationInnovation100%achieved
GOL-0270186-0EMP-0270186Frederick C. MalhotraPublish the operating handbook for the functionOperational excellence44%at risk

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0270186-0EMP-0270186Frederick C. MalhotraPTOPaid time off14.10
BAL-0270186-1EMP-0270186Frederick C. MalhotraSICKSick leave70
BAL-0270186-2EMP-0270186Frederick C. MalhotraPARENTParental leave59.10
BAL-0270186-3EMP-0270186Frederick C. MalhotraBEREAVBereavement leave3.50
BAL-0270186-4EMP-0270186Frederick C. MalhotraJURYJury duty70
BAL-0270186-5EMP-0270186Frederick C. MalhotraUNPAIDUnpaid leave of absence21.10
BAL-0270186-6EMP-0270186Frederick C. MalhotraVOLVolunteer day1.40
BAL-0270186-7EMP-0270186Frederick C. MalhotraSABSabbatical21.10

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0270186-0048EMP-0270186Frederick C. MalhotraRUN-00482026-07-132026-07-17$6,294
PAY-0270186-0047EMP-0270186Frederick C. MalhotraRUN-00472026-06-282026-07-02$4,433
PAY-0270186-0046EMP-0270186Frederick C. MalhotraRUN-00462026-06-132026-06-17$4,433
PAY-0270186-0045EMP-0270186Frederick C. MalhotraRUN-00452026-05-292026-06-02$4,433
PAY-0270186-0044EMP-0270186Frederick C. MalhotraRUN-00442026-05-142026-05-18$4,433
PAY-0270186-0043EMP-0270186Frederick C. MalhotraRUN-00432026-04-292026-05-03$4,433
PAY-0270186-0042EMP-0270186Frederick C. MalhotraRUN-00422026-04-142026-04-18$6,294
PAY-0270186-0041EMP-0270186Frederick C. MalhotraRUN-00412026-03-302026-04-03$4,433
PAY-0270186-0040EMP-0270186Frederick C. MalhotraRUN-00402026-03-152026-03-19$4,433
PAY-0270186-0039EMP-0270186Frederick C. MalhotraRUN-00392026-02-282026-03-04$4,433

See all 48 →