HR Safe Space
Endpoints / ember-pier-3541 / employees / EMP-0168232

Ophelia B. Gupta

EMP-0168232 · Employee · projected from the master template

employee_id
EMP-0168232
seq
168,232
first_name
Ophelia
last_name
Gupta
middle_initial
B
full_name
Ophelia B. Gupta
work_email
ophelia.b.gupta@northline.com
work_phone
+1-257-283-8372
home_address_line1
4844 Alder Court
job_title
Systems Administrator
job_code
IT-01-0
job_family
Information Technology
flsa_status
exempt
job_level
1
job_level_name
Specialist
job_level_code
IC2
is_people_manager
no
is_executive
no
department_code
IT
department_name
Information Technology
department_function
Technology
cost_center
CC-1400
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-0022240
manager_seq
22,240
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
Remote
employment_status
active
hire_date
2023-12-06
tenure_years
2.77
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1990-11-12
age
36
gender
Female
ethnicity
Asian
base_salary_cents
10,775,717
base_salary
$107,757
currency
USD
bonus_target_pct
5%
bonus_target
$5,388
equity_units
50
compa_ratio
1.192
band_min_cents
6,232,000
band_mid_cents
7,600,000
band_max_cents
9,424,000
department_ordinal
7
location_ordinal
2
employment_status_ordinal
0
performance_rating
4
engagement_score
40
flight_risk_score
41
tenure_days
577

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0168232-0EMP-0168232Ophelia B. Gupta2025-03-30Merit increaseRetention risk identified by manager4.07%
CMP-0168232-2EMP-0168232Ophelia B. Gupta2024-07-27Equity refreshInternal equity correction6.51%
CMP-0168232-1EMP-0168232Ophelia B. Gupta2023-12-12PromotionExpanded scope of responsibility5.12%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0168232-0EMP-0168232Ophelia B. GuptaPTOPaid time off14.10
BAL-0168232-1EMP-0168232Ophelia B. GuptaSICKSick leave70
BAL-0168232-2EMP-0168232Ophelia B. GuptaPARENTParental leave59.10
BAL-0168232-3EMP-0168232Ophelia B. GuptaBEREAVBereavement leave3.50
BAL-0168232-4EMP-0168232Ophelia B. GuptaJURYJury duty70
BAL-0168232-5EMP-0168232Ophelia B. GuptaUNPAIDUnpaid leave of absence21.10
BAL-0168232-6EMP-0168232Ophelia B. GuptaVOLVolunteer day1.40
BAL-0168232-7EMP-0168232Ophelia B. GuptaSABSabbatical21.10

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0168232-0EMP-0168232Ophelia B. GuptaMED-PPO-FAMPPO Medical - FamilyMedicalactive
BEN-0168232-1EMP-0168232Ophelia B. GuptaDEN-FAMDental - FamilyDentalactive

Recent payslips (39)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0168232-0048EMP-0168232Ophelia B. GuptaRUN-00482025-07-042025-07-08$5,837
PAY-0168232-0047EMP-0168232Ophelia B. GuptaRUN-00472025-06-192025-06-23$4,490
PAY-0168232-0046EMP-0168232Ophelia B. GuptaRUN-00462025-06-042025-06-08$4,490
PAY-0168232-0045EMP-0168232Ophelia B. GuptaRUN-00452025-05-202025-05-24$4,490
PAY-0168232-0044EMP-0168232Ophelia B. GuptaRUN-00442025-05-052025-05-09$4,490
PAY-0168232-0043EMP-0168232Ophelia B. GuptaRUN-00432025-04-202025-04-24$4,490
PAY-0168232-0042EMP-0168232Ophelia B. GuptaRUN-00422025-04-052025-04-09$5,837
PAY-0168232-0041EMP-0168232Ophelia B. GuptaRUN-00412025-03-212025-03-25$4,490
PAY-0168232-0040EMP-0168232Ophelia B. GuptaRUN-00402025-03-062025-03-10$4,490
PAY-0168232-0039EMP-0168232Ophelia B. GuptaRUN-00392025-02-192025-02-23$4,490

See all 39 →