Endpoints / load-j1yko-0036 / employees / EMP-0145760

Ikenna A. Sandoval

EMP-0145760 · Employee · projected from the master template

employee_id: EMP-0145760
seq: 145,760
first_name: Ikenna
last_name: Sandoval
middle_initial: A
full_name: Ikenna A. Sandoval
work_email: ikenna.a.sandoval@tesseracourt.com
work_phone: +1-595-294-9472
home_address_line1: 5410 Foundry Row
job_title: Junior Supply Chain Planner
job_code: SCM-00-1
job_family: Supply Chain
flsa_status: non-exempt
job_level: 0
job_level_name: Associate
job_level_code: IC1
is_people_manager: no
is_executive: no
department_code: SCM
department_name: Supply Chain
department_function: Operations
cost_center: CC-3400
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-0021190
manager_seq: 21,190
direct_report_count: 0
org_depth: 8
employment_type: Full-time regular
work_arrangement: Hybrid
employment_status: active
hire_date: 2026-04-18
tenure_years: 0.41
termination_date: —
termination_reason: —
termination_voluntary: —
leave_type: —
date_of_birth: 1985-10-13
age: 41
gender: Male
ethnicity: Asian
base_salary_cents: 5,530,994
base_salary: $55,310
currency: USD
bonus_target_pct: 3%
bonus_target: $1,659
equity_units: 0
compa_ratio: 0.938
band_min_cents: 4,756,000
band_mid_cents: 5,800,000
band_max_cents: 7,192,000
department_ordinal: 12
location_ordinal: 4
employment_status_ordinal: 0
performance_rating: 3
engagement_score: 67
flight_risk_score: 2
tenure_days: 88

Leave balances (8)

balance_id	employee_id	employee_name	leave_type_code	leave_type	accrued_days
BAL-0145760-0	EMP-0145760	Ikenna A. Sandoval	PTO	Paid time off	4.8
BAL-0145760-1	EMP-0145760	Ikenna A. Sandoval	SICK	Sick leave	2.4
BAL-0145760-2	EMP-0145760	Ikenna A. Sandoval	PARENT	Parental leave	20.3
BAL-0145760-3	EMP-0145760	Ikenna A. Sandoval	BEREAV	Bereavement leave	1.2
BAL-0145760-4	EMP-0145760	Ikenna A. Sandoval	JURY	Jury duty	2.4
BAL-0145760-5	EMP-0145760	Ikenna A. Sandoval	UNPAID	Unpaid leave of absence	7.2
BAL-0145760-6	EMP-0145760	Ikenna A. Sandoval	VOL	Volunteer day	0.5
BAL-0145760-7	EMP-0145760	Ikenna A. Sandoval	SAB	Sabbatical	7.2

Benefit enrollments (3)

enrollment_id	employee_id	employee_name	plan_code	plan_name	category	status
BEN-0145760-0	EMP-0145760	Ikenna A. Sandoval	MED-PPO-ES	PPO Medical - Employee + spouse	Medical	active
BEN-0145760-2	EMP-0145760	Ikenna A. Sandoval	401K-STD	401(k) - 4% match	Retirement	active
BEN-0145760-1	EMP-0145760	Ikenna A. Sandoval	DEN-STD	Dental - Standard	Dental	active

Training (4)

training_record_id	employee_id	employee_name	course_code	course_title	category	is_mandatory
TRN-0145760-0	EMP-0145760	Ikenna A. Sandoval	ONB-020	Systems & Tooling Bootcamp	Onboarding	yes
TRN-0145760-2	EMP-0145760	Ikenna A. Sandoval	LDR-240	Executive Presence	Leadership	no
TRN-0145760-3	EMP-0145760	Ikenna A. Sandoval	PRO-420	Negotiation Essentials	Professional	no
TRN-0145760-1	EMP-0145760	Ikenna A. Sandoval	CMP-140	Anti-Bribery & Corruption	Compliance	yes

Recent payslips (6)

payslip_id	employee_id	employee_name	payroll_run_id	period_end	pay_date	gross_pay
PAY-0145760-0048	EMP-0145760	Ikenna A. Sandoval	RUN-0048	2026-07-14	2026-07-18	$2,719
PAY-0145760-0047	EMP-0145760	Ikenna A. Sandoval	RUN-0047	2026-06-29	2026-07-03	$2,305
PAY-0145760-0046	EMP-0145760	Ikenna A. Sandoval	RUN-0046	2026-06-14	2026-06-18	$2,305
PAY-0145760-0045	EMP-0145760	Ikenna A. Sandoval	RUN-0045	2026-05-30	2026-06-03	$2,305
PAY-0145760-0044	EMP-0145760	Ikenna A. Sandoval	RUN-0044	2026-05-15	2026-05-19	$2,305
PAY-0145760-0043	EMP-0145760	Ikenna A. Sandoval	RUN-0043	2026-04-30	2026-05-04	$2,305