Endpoints / hr-probe-check-9f3k2 / employees / EMP-0243192

Raymond B. Ishikawa

EMP-0243192 · Employee · projected from the master template

employee_id: EMP-0243192
seq: 243,192
first_name: Raymond
last_name: Ishikawa
middle_initial: B
full_name: Raymond B. Ishikawa
work_email: raymond.b.ishikawa@windrowreach.com
work_phone: +1-251-259-5987
home_address_line1: 3538 Copper Beech Close
job_title: Associate Software Engineer
job_code: ENG-00-0
job_family: Engineering
flsa_status: exempt
job_level: 0
job_level_name: Associate
job_level_code: IC1
is_people_manager: no
is_executive: no
department_code: ENG
department_name: Engineering
department_function: Technology
cost_center: CC-1000
location_code: CA-TOR
location_city: Toronto
location_region: Ontario
location_country: Canada
location_country_code: CA
location_timezone: America/Toronto
manager_id: EMP-0030267
manager_seq: 30,267
direct_report_count: 0
org_depth: 8
employment_type: Full-time regular
work_arrangement: On-site
employment_status: active
hire_date: 2026-07-27
tenure_years: 0.14
termination_date: —
termination_reason: —
termination_voluntary: —
leave_type: —
date_of_birth: 1986-06-18
age: 40
gender: Male
ethnicity: White
base_salary_cents: 8,444,594
base_salary: $84,446
currency: CAD
bonus_target_pct: 3%
bonus_target: $2,533
equity_units: 0
compa_ratio: 0.978
band_min_cents: 4,756,000
band_mid_cents: 5,800,000
band_max_cents: 7,192,000
department_ordinal: 0
location_ordinal: 10
employment_status_ordinal: 0
performance_rating: 3
engagement_score: 31
flight_risk_score: 35
tenure_days: 32

Goals (3)

goal_id	employee_id	employee_name	title	category	progress_pct	status
GOL-0243192-0	EMP-0243192	Raymond B. Ishikawa	Close the top five audit findings	People and culture	80%	on track
GOL-0243192-1	EMP-0243192	Raymond B. Ishikawa	Cut unplanned attrition in the team by half	Business results	100%	achieved
GOL-0243192-2	EMP-0243192	Raymond B. Ishikawa	Deliver the cost reduction target for the cost centre	Cost and efficiency	49%	at risk

Time off requests (4)

request_id	employee_id	employee_name	leave_type	start_date	end_date	business_days
TOR-0243192-1	EMP-0243192	Raymond B. Ishikawa	Paid time off	2026-12-04	2026-12-04	1
TOR-0243192-0	EMP-0243192	Raymond B. Ishikawa	Unpaid leave of absence	2026-11-03	2026-11-05	3
TOR-0243192-3	EMP-0243192	Raymond B. Ishikawa	Jury duty	2026-07-27	2026-07-29	3
TOR-0243192-2	EMP-0243192	Raymond B. Ishikawa	Unpaid leave of absence	2025-07-31	2025-08-09	10

Leave balances (8)

balance_id	employee_id	employee_name	leave_type_code	leave_type	accrued_days	taken_days
BAL-0243192-0	EMP-0243192	Raymond B. Ishikawa	PTO	Paid time off	1.8	0
BAL-0243192-1	EMP-0243192	Raymond B. Ishikawa	SICK	Sick leave	0.9	0
BAL-0243192-2	EMP-0243192	Raymond B. Ishikawa	PARENT	Parental leave	7.4	0
BAL-0243192-3	EMP-0243192	Raymond B. Ishikawa	BEREAV	Bereavement leave	0.4	0
BAL-0243192-4	EMP-0243192	Raymond B. Ishikawa	JURY	Jury duty	0.9	3
BAL-0243192-5	EMP-0243192	Raymond B. Ishikawa	UNPAID	Unpaid leave of absence	2.6	0
BAL-0243192-6	EMP-0243192	Raymond B. Ishikawa	VOL	Volunteer day	0.2	0
BAL-0243192-7	EMP-0243192	Raymond B. Ishikawa	SAB	Sabbatical	2.6	0

Benefit enrollments (5)

enrollment_id	employee_id	employee_name	plan_code	plan_name	category	status
BEN-0243192-1	EMP-0243192	Raymond B. Ishikawa	DEN-STD	Dental - Standard	Dental	active
BEN-0243192-3	EMP-0243192	Raymond B. Ishikawa	STD	Short-term disability	Disability	active
BEN-0243192-4	EMP-0243192	Raymond B. Ishikawa	PET	Pet insurance	Other	active
BEN-0243192-0	EMP-0243192	Raymond B. Ishikawa	MED-PPO-EE	PPO Medical - Employee only	Medical	active
BEN-0243192-2	EMP-0243192	Raymond B. Ishikawa	401K-STD	401(k) - 4% match	Retirement	active

Recent payslips (3)

payslip_id	employee_id	employee_name	payroll_run_id	period_end	pay_date	gross_pay
PAY-0243192-0048	EMP-0243192	Raymond B. Ishikawa	RUN-0048	2026-08-27	2026-08-31	$4,152
PAY-0243192-0047	EMP-0243192	Raymond B. Ishikawa	RUN-0047	2026-08-12	2026-08-16	$3,519
PAY-0243192-0046	EMP-0243192	Raymond B. Ishikawa	RUN-0046	2026-07-28	2026-08-01	$3,519