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

Gloria B. Tsai

EMP-0168576 · Employee · projected from the master template

employee_id: EMP-0168576
seq: 168,576
first_name: Gloria
last_name: Tsai
middle_initial: B
full_name: Gloria B. Tsai
work_email: gloria.b.tsai@northline.com
work_phone: +1-311-282-8220
home_address_line1: 6529 Bayview Crescent
job_title: Junior Software Engineer
job_code: ENG-00-1
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-NYC
location_city: New York
location_region: New York
location_country: United States
location_country_code: US
location_timezone: America/New_York
manager_id: EMP-0022279
manager_seq: 22,279
direct_report_count: 0
org_depth: 8
employment_type: Full-time regular
work_arrangement: Hybrid
employment_status: active
hire_date: 2025-05-12
tenure_years: 1.34
termination_date: —
termination_reason: —
termination_voluntary: —
leave_type: —
date_of_birth: 1984-06-20
age: 42
gender: Female
ethnicity: Hispanic or Latino
base_salary_cents: 6,517,489
base_salary: $65,175
currency: USD
bonus_target_pct: 3%
bonus_target: $1,955
equity_units: 0
compa_ratio: 0.894
band_min_cents: 4,756,000
band_mid_cents: 5,800,000
band_max_cents: 7,192,000
department_ordinal: 0
location_ordinal: 1
employment_status_ordinal: 0
performance_rating: 3
engagement_score: 77
flight_risk_score: 76
tenure_days: 55

Goals (3)

goal_id	employee_id	employee_name	title	category	progress_pct	status
GOL-0168576-0	EMP-0168576	Gloria B. Tsai	Reduce cycle time for the core workflow by 20%	Business results	59%	at risk
GOL-0168576-1	EMP-0168576	Gloria B. Tsai	Improve team engagement score by 8 points	Cost and efficiency	39%	cancelled
GOL-0168576-2	EMP-0168576	Gloria B. Tsai	Achieve 95% on-time delivery for the quarter	Innovation	60%	at risk

Time off requests (4)

request_id	employee_id	employee_name	leave_type	start_date	end_date	business_days
TOR-0168576-3	EMP-0168576	Gloria B. Tsai	Jury duty	2025-08-10	2025-08-16	7
TOR-0168576-0	EMP-0168576	Gloria B. Tsai	Parental leave	2025-04-25	2025-04-27	3
TOR-0168576-1	EMP-0168576	Gloria B. Tsai	Jury duty	2024-09-18	2024-09-21	4
TOR-0168576-2	EMP-0168576	Gloria B. Tsai	Volunteer day	2024-09-15	2024-09-24	10

Leave balances (8)

balance_id	employee_id	employee_name	leave_type_code	leave_type	accrued_days
BAL-0168576-0	EMP-0168576	Gloria B. Tsai	PTO	Paid time off	3
BAL-0168576-1	EMP-0168576	Gloria B. Tsai	SICK	Sick leave	1.5
BAL-0168576-2	EMP-0168576	Gloria B. Tsai	PARENT	Parental leave	12.7
BAL-0168576-3	EMP-0168576	Gloria B. Tsai	BEREAV	Bereavement leave	0.8
BAL-0168576-4	EMP-0168576	Gloria B. Tsai	JURY	Jury duty	1.5
BAL-0168576-5	EMP-0168576	Gloria B. Tsai	UNPAID	Unpaid leave of absence	4.5
BAL-0168576-6	EMP-0168576	Gloria B. Tsai	VOL	Volunteer day	0.3
BAL-0168576-7	EMP-0168576	Gloria B. Tsai	SAB	Sabbatical	4.5

Benefit enrollments (5)

enrollment_id	employee_id	employee_name	plan_code	plan_name	category	status
BEN-0168576-0	EMP-0168576	Gloria B. Tsai	MED-PPO-ES	PPO Medical - Employee + spouse	Medical	pending
BEN-0168576-1	EMP-0168576	Gloria B. Tsai	DEN-FAM	Dental - Family	Dental	active
BEN-0168576-4	EMP-0168576	Gloria B. Tsai	LEGAL-PLAN	Group legal plan	Other	active
BEN-0168576-2	EMP-0168576	Gloria B. Tsai	401K-STD	401(k) - 4% match	Retirement	active
BEN-0168576-3	EMP-0168576	Gloria B. Tsai	STD	Short-term disability	Disability	active

Recent payslips (4)

payslip_id	employee_id	employee_name	payroll_run_id	period_end	pay_date	gross_pay
PAY-0168576-0048	EMP-0168576	Gloria B. Tsai	RUN-0048	2025-07-05	2025-07-09	$3,204
PAY-0168576-0047	EMP-0168576	Gloria B. Tsai	RUN-0047	2025-06-20	2025-06-24	$2,716
PAY-0168576-0046	EMP-0168576	Gloria B. Tsai	RUN-0046	2025-06-05	2025-06-09	$2,716
PAY-0168576-0045	EMP-0168576	Gloria B. Tsai	RUN-0045	2025-05-21	2025-05-25	$2,716