Ophelia Tsai
EMP-0004696 · Employee · projected from the master template
- employee_id
- EMP-0004696
- seq
- 4,696
- first_name
- Ophelia
- last_name
- Tsai
- middle_initial
- —
- full_name
- Ophelia Tsai
- work_email
- ophelia.tsai@marrowgrove.com
- work_phone
- +1-976-203-0307
- home_address_line1
- 3600 Orchard Path
- job_title
- Sales Manager
- job_code
- SLS-04-0
- job_family
- Sales
- flsa_status
- exempt
- job_level
- 4
- job_level_name
- Manager
- job_level_code
- M1
- is_people_manager
- yes
- is_executive
- no
- department_code
- SLS
- department_name
- Sales
- department_function
- Revenue
- cost_center
- CC-2000
- 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-0001116
- manager_seq
- 1,116
- direct_report_count
- 9
- org_depth
- 7
- employment_type
- Full-time regular
- work_arrangement
- Hybrid
- employment_status
- active
- hire_date
- 2026-04-07
- tenure_years
- 0.44
- termination_date
- —
- termination_reason
- —
- termination_voluntary
- —
- leave_type
- —
- date_of_birth
- 1999-12-05
- age
- 27
- gender
- Female
- ethnicity
- Hispanic or Latino
- base_salary_cents
- 20,728,570
- base_salary
- $207,286
- currency
- USD
- bonus_target_pct
- 12%
- bonus_target
- $24,874
- equity_units
- 600
- compa_ratio
- 1.002
- band_min_cents
- 12,136,000
- band_mid_cents
- 14,800,000
- band_max_cents
- 18,352,000
- department_ordinal
- 1
- location_ordinal
- 1
- employment_status_ordinal
- 0
- performance_rating
- 3
- engagement_score
- 57
- flight_risk_score
- 80
- tenure_days
- 52
Leave balances (8)
| balance_id | employee_id | employee_name | leave_type_code | leave_type | accrued_days | taken_days |
|---|---|---|---|---|---|---|
| BAL-0004696-0 | EMP-0004696 | Ophelia Tsai | PTO | Paid time off | 2.8 | 0 |
| BAL-0004696-1 | EMP-0004696 | Ophelia Tsai | SICK | Sick leave | 1.4 | 0 |
| BAL-0004696-2 | EMP-0004696 | Ophelia Tsai | PARENT | Parental leave | 12 | 0 |
| BAL-0004696-3 | EMP-0004696 | Ophelia Tsai | BEREAV | Bereavement leave | 0.7 | 0 |
| BAL-0004696-4 | EMP-0004696 | Ophelia Tsai | JURY | Jury duty | 1.4 | 0 |
| BAL-0004696-5 | EMP-0004696 | Ophelia Tsai | UNPAID | Unpaid leave of absence | 4.3 | 0 |
| BAL-0004696-6 | EMP-0004696 | Ophelia Tsai | VOL | Volunteer day | 0.3 | 0 |
| BAL-0004696-7 | EMP-0004696 | Ophelia Tsai | SAB | Sabbatical | 4.3 | 0 |
Benefit enrollments (3)
| enrollment_id | employee_id | employee_name | plan_code | plan_name | category | status |
|---|---|---|---|---|---|---|
| BEN-0004696-1 | EMP-0004696 | Ophelia Tsai | DEN-STD | Dental - Standard | Dental | active |
| BEN-0004696-0 | EMP-0004696 | Ophelia Tsai | MED-PPO-FAM | PPO Medical - Family | Medical | active |
| BEN-0004696-2 | EMP-0004696 | Ophelia Tsai | 401K-STD | 401(k) - 4% match | Retirement | active |
Recent payslips (4)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0004696-0048 | EMP-0004696 | Ophelia Tsai | RUN-0048 | 2026-05-28 | 2026-06-01 | $14,855 |
| PAY-0004696-0047 | EMP-0004696 | Ophelia Tsai | RUN-0047 | 2026-05-13 | 2026-05-17 | $8,637 |
| PAY-0004696-0046 | EMP-0004696 | Ophelia Tsai | RUN-0046 | 2026-04-28 | 2026-05-02 | $8,637 |
| PAY-0004696-0045 | EMP-0004696 | Ophelia Tsai | RUN-0045 | 2026-04-13 | 2026-04-17 | $8,637 |
Direct reports (9)
| employee_id | first_name | last_name | full_name | work_email | job_title | job_level |
|---|---|---|---|---|---|---|
| EMP-0031581 | Noor | Borgen | Noor Borgen | noor.borgen@marrowgrove.com | Senior Account Executive | 2 |
| EMP-0031582 | Cormac | Nielsen | Cormac Nielsen | cormac.nielsen@marrowgrove.com | Junior Account Executive | 0 |
| EMP-0031583 | Alejandro | Blackwood | Alejandro Blackwood | alejandro.blackwood@marrowgrove.com | Principal Account Executive | 3 |
| EMP-0031584 | Rebecca | Navarro | Rebecca Navarro | rebecca.navarro@marrowgrove.com | Account Executive | 1 |
| EMP-0031585 | Nolan | Berg | Nolan Berg | nolan.berg@marrowgrove.com | Account Executive | 1 |
| EMP-0031586 | Veronica | Murray | Veronica Murray | veronica.murray@marrowgrove.com | Principal Account Executive | 3 |
| EMP-0031587 | Bettina | Beaulieu | Bettina Beaulieu | bettina.beaulieu@marrowgrove.com | Account Executive II | 1 |
| EMP-0031588 | Ingrid | Muller | Ingrid Muller | ingrid.muller@marrowgrove.com | Account Executive | 1 |
| EMP-0031589 | Tariq | Banerjee | Tariq Banerjee | tariq.banerjee@marrowgrove.com | Account Executive | 1 |