Endpoints / ember-pier-3541 / employees / EMP-0214848

Gerald B. Malhotra

EMP-0214848 · Employee · projected from the master template

employee_id: EMP-0214848
seq: 214,848
first_name: Gerald
last_name: Malhotra
middle_initial: B
full_name: Gerald B. Malhotra
work_email: gerald.b.malhotra@northline.com
work_phone: +1-432-229-2978
home_address_line1: 8041 Cedar Hollow
job_title: Junior Operations Specialist
job_code: OPS-00-1
job_family: Operations
flsa_status: non-exempt
job_level: 0
job_level_name: Associate
job_level_code: IC1
is_people_manager: no
is_executive: no
department_code: OPS
department_name: Operations
department_function: Operations
cost_center: CC-3000
location_code: US-AUS
location_city: Austin
location_region: Texas
location_country: United States
location_country_code: US
location_timezone: America/Chicago
manager_id: EMP-0027420
manager_seq: 27,420
direct_report_count: 0
org_depth: 8
employment_type: Full-time regular
work_arrangement: On-site
employment_status: active
hire_date: 2025-04-20
tenure_years: 1.4
termination_date: —
termination_reason: —
termination_voluntary: —
leave_type: —
date_of_birth: 1977-06-02
age: 49
gender: Male
ethnicity: Hispanic or Latino
base_salary_cents: 5,442,009
base_salary: $54,420
currency: USD
bonus_target_pct: 3%
bonus_target: $1,633
equity_units: 0
compa_ratio: 1.17
band_min_cents: 4,756,000
band_mid_cents: 5,800,000
band_max_cents: 7,192,000
department_ordinal: 2
location_ordinal: 3
employment_status_ordinal: 0
performance_rating: 5
engagement_score: 61
flight_risk_score: 97
tenure_days: 76

Goals (2)

goal_id	employee_id	employee_name	title	category	progress_pct	status
GOL-0214848-0	EMP-0214848	Gerald B. Malhotra	Stand up the partner enablement programme	People and culture	84%	on track
GOL-0214848-1	EMP-0214848	Gerald B. Malhotra	Launch the customer self-service portal	Growth	60%	at risk

Time off requests (2)

request_id	employee_id	employee_name	leave_type	start_date	end_date	business_days
TOR-0214848-0	EMP-0214848	Gerald B. Malhotra	Bereavement leave	2025-10-08	2025-10-09	2
TOR-0214848-1	EMP-0214848	Gerald B. Malhotra	Bereavement leave	2025-09-28	2025-10-05	8

Leave balances (8)

balance_id	employee_id	employee_name	leave_type_code	leave_type	accrued_days
BAL-0214848-0	EMP-0214848	Gerald B. Malhotra	PTO	Paid time off	4.2
BAL-0214848-1	EMP-0214848	Gerald B. Malhotra	SICK	Sick leave	2.1
BAL-0214848-2	EMP-0214848	Gerald B. Malhotra	PARENT	Parental leave	17.5
BAL-0214848-3	EMP-0214848	Gerald B. Malhotra	BEREAV	Bereavement leave	1
BAL-0214848-4	EMP-0214848	Gerald B. Malhotra	JURY	Jury duty	2.1
BAL-0214848-5	EMP-0214848	Gerald B. Malhotra	UNPAID	Unpaid leave of absence	6.2
BAL-0214848-6	EMP-0214848	Gerald B. Malhotra	VOL	Volunteer day	0.4
BAL-0214848-7	EMP-0214848	Gerald B. Malhotra	SAB	Sabbatical	6.2

Benefit enrollments (2)

enrollment_id	employee_id	employee_name	plan_code	plan_name	category	status
BEN-0214848-1	EMP-0214848	Gerald B. Malhotra	VIS-STD	Vision	Vision	active
BEN-0214848-0	EMP-0214848	Gerald B. Malhotra	MED-HDHP-EE	HDHP + HSA - Employee only	Medical	active

Recent payslips (6)

payslip_id	employee_id	employee_name	payroll_run_id	period_end	pay_date	gross_pay
PAY-0214848-0048	EMP-0214848	Gerald B. Malhotra	RUN-0048	2025-07-04	2025-07-08	$2,676
PAY-0214848-0047	EMP-0214848	Gerald B. Malhotra	RUN-0047	2025-06-19	2025-06-23	$2,268
PAY-0214848-0046	EMP-0214848	Gerald B. Malhotra	RUN-0046	2025-06-04	2025-06-08	$2,268
PAY-0214848-0045	EMP-0214848	Gerald B. Malhotra	RUN-0045	2025-05-20	2025-05-24	$2,268
PAY-0214848-0044	EMP-0214848	Gerald B. Malhotra	RUN-0044	2025-05-05	2025-05-09	$2,268
PAY-0214848-0043	EMP-0214848	Gerald B. Malhotra	RUN-0043	2025-04-20	2025-04-24	$2,268