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

Ophelia A. Vandenberg

EMP-0146232 · Employee · projected from the master template

employee_id: EMP-0146232
seq: 146,232
first_name: Ophelia
last_name: Vandenberg
middle_initial: A
full_name: Ophelia A. Vandenberg
work_email: ophelia.a.vandenberg@northline.com
work_phone: +1-882-258-5848
home_address_line1: 6685 Willow Bend
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: US-AUS
location_city: Austin
location_region: Texas
location_country: United States
location_country_code: US
location_timezone: America/Chicago
manager_id: EMP-0019796
manager_seq: 19,796
direct_report_count: 0
org_depth: 8
employment_type: Full-time regular
work_arrangement: Hybrid
employment_status: active
hire_date: 2025-05-28
tenure_years: 1.3
termination_date: —
termination_reason: —
termination_voluntary: —
leave_type: —
date_of_birth: 1976-07-15
age: 50
gender: Female
ethnicity: White
base_salary_cents: 5,901,636
base_salary: $59,016
currency: USD
bonus_target_pct: 3%
bonus_target: $1,770
equity_units: 0
compa_ratio: 1
band_min_cents: 4,756,000
band_mid_cents: 5,800,000
band_max_cents: 7,192,000
department_ordinal: 0
location_ordinal: 3
employment_status_ordinal: 0
performance_rating: 4
engagement_score: 65
flight_risk_score: 66
tenure_days: 39

Goals (1)

goal_id	employee_id	employee_name	title	category	progress_pct	status
GOL-0146232-0	EMP-0146232	Ophelia A. Vandenberg	Deliver the cost reduction target for the cost centre	People and culture	78%	on track

Time off requests (4)

request_id	employee_id	employee_name	leave_type	start_date	end_date	business_days
TOR-0146232-2	EMP-0146232	Ophelia A. Vandenberg	Paid time off	2025-06-28	2025-07-04	7
TOR-0146232-3	EMP-0146232	Ophelia A. Vandenberg	Paid time off	2025-03-04	2025-03-05	2
TOR-0146232-0	EMP-0146232	Ophelia A. Vandenberg	Sick leave	2024-12-19	2024-12-20	2
TOR-0146232-1	EMP-0146232	Ophelia A. Vandenberg	Paid time off	2024-09-22	2024-09-22	1

Leave balances (8)

balance_id	employee_id	employee_name	leave_type_code	leave_type	accrued_days
BAL-0146232-0	EMP-0146232	Ophelia A. Vandenberg	PTO	Paid time off	2.1
BAL-0146232-1	EMP-0146232	Ophelia A. Vandenberg	SICK	Sick leave	1.1
BAL-0146232-2	EMP-0146232	Ophelia A. Vandenberg	PARENT	Parental leave	9
BAL-0146232-3	EMP-0146232	Ophelia A. Vandenberg	BEREAV	Bereavement leave	0.5
BAL-0146232-4	EMP-0146232	Ophelia A. Vandenberg	JURY	Jury duty	1.1
BAL-0146232-5	EMP-0146232	Ophelia A. Vandenberg	UNPAID	Unpaid leave of absence	3.2
BAL-0146232-6	EMP-0146232	Ophelia A. Vandenberg	VOL	Volunteer day	0.2
BAL-0146232-7	EMP-0146232	Ophelia A. Vandenberg	SAB	Sabbatical	3.2

Benefit enrollments (3)

enrollment_id	employee_id	employee_name	plan_code	plan_name	category	status
BEN-0146232-1	EMP-0146232	Ophelia A. Vandenberg	VIS-STD	Vision	Vision	active
BEN-0146232-2	EMP-0146232	Ophelia A. Vandenberg	401K-ROTH	Roth 401(k) - 4% match	Retirement	active
BEN-0146232-0	EMP-0146232	Ophelia A. Vandenberg	MED-PPO-EE	PPO Medical - Employee only	Medical	active

Recent payslips (3)

payslip_id	employee_id	employee_name	payroll_run_id	period_end	pay_date	gross_pay
PAY-0146232-0048	EMP-0146232	Ophelia A. Vandenberg	RUN-0048	2025-07-05	2025-07-09	$2,902
PAY-0146232-0047	EMP-0146232	Ophelia A. Vandenberg	RUN-0047	2025-06-20	2025-06-24	$2,459
PAY-0146232-0046	EMP-0146232	Ophelia A. Vandenberg	RUN-0046	2025-06-05	2025-06-09	$2,459