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

Ophelia A. Sterling

EMP-0134088 · Employee · projected from the master template

employee_id: EMP-0134088
seq: 134,088
first_name: Ophelia
last_name: Sterling
middle_initial: A
full_name: Ophelia A. Sterling
work_email: ophelia.a.sterling@northline.com
work_phone: +1-215-246-4624
home_address_line1: 8244 Aspen Ridge
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-SFO
location_city: San Francisco
location_region: California
location_country: United States
location_country_code: US
location_timezone: America/Los_Angeles
manager_id: EMP-0018447
manager_seq: 18,447
direct_report_count: 0
org_depth: 8
employment_type: Full-time regular
work_arrangement: On-site
employment_status: active
hire_date: 2025-05-28
tenure_years: 1.3
termination_date: —
termination_reason: —
termination_voluntary: —
leave_type: —
date_of_birth: 1988-10-09
age: 38
gender: Female
ethnicity: Asian
base_salary_cents: 7,404,239
base_salary: $74,042
currency: USD
bonus_target_pct: 3%
bonus_target: $2,221
equity_units: 0
compa_ratio: 0.955
band_min_cents: 4,756,000
band_mid_cents: 5,800,000
band_max_cents: 7,192,000
department_ordinal: 0
location_ordinal: 2
employment_status_ordinal: 0
performance_rating: 3
engagement_score: 42
flight_risk_score: 2
tenure_days: 39

Goals (2)

goal_id	employee_id	employee_name	title	category	progress_pct	status
GOL-0134088-1	EMP-0134088	Ophelia A. Sterling	Complete the data quality remediation programme	People and culture	63%	at risk
GOL-0134088-0	EMP-0134088	Ophelia A. Sterling	Increase pipeline coverage to 3.5x	Innovation	39%	off track

Time off requests (4)

request_id	employee_id	employee_name	leave_type	start_date	end_date	business_days
TOR-0134088-0	EMP-0134088	Ophelia A. Sterling	Paid time off	2025-06-12	2025-06-17	6
TOR-0134088-2	EMP-0134088	Ophelia A. Sterling	Bereavement leave	2025-06-11	2025-06-15	5
TOR-0134088-3	EMP-0134088	Ophelia A. Sterling	Sick leave	2025-04-12	2025-04-16	5
TOR-0134088-1	EMP-0134088	Ophelia A. Sterling	Jury duty	2025-03-27	2025-04-04	9

Leave balances (8)

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

Benefit enrollments (3)

enrollment_id	employee_id	employee_name	plan_code	plan_name	category	status
BEN-0134088-1	EMP-0134088	Ophelia A. Sterling	VIS-STD	Vision	Vision	active
BEN-0134088-0	EMP-0134088	Ophelia A. Sterling	MED-HDHP-EE	HDHP + HSA - Employee only	Medical	active
BEN-0134088-2	EMP-0134088	Ophelia A. Sterling	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-0134088-0048	EMP-0134088	Ophelia A. Sterling	RUN-0048	2025-07-05	2025-07-09	$3,640
PAY-0134088-0047	EMP-0134088	Ophelia A. Sterling	RUN-0047	2025-06-20	2025-06-24	$3,085
PAY-0134088-0046	EMP-0134088	Ophelia A. Sterling	RUN-0046	2025-06-05	2025-06-09	$3,085