Lionel Vandenberg
EMP-0022880 · Employee · projected from the master template
- employee_id
- EMP-0022880
- seq
- 22,880
- first_name
- Lionel
- last_name
- Vandenberg
- middle_initial
- —
- full_name
- Lionel Vandenberg
- work_email
- lionel.vandenberg@windrowreach.com
- work_phone
- +1-681-270-7058
- home_address_line1
- 1962 Lantern Way
- job_title
- Manager, Customer Support
- job_code
- CS-04-1
- job_family
- Customer Support
- flsa_status
- exempt
- job_level
- 4
- job_level_name
- Manager
- job_level_code
- M1
- is_people_manager
- yes
- is_executive
- no
- department_code
- CS
- department_name
- Customer Support
- department_function
- Revenue
- cost_center
- CC-2400
- location_code
- BR-SAO
- location_city
- Sao Paulo
- location_region
- Sao Paulo
- location_country
- Brazil
- location_country_code
- BR
- location_timezone
- America/Sao_Paulo
- manager_id
- EMP-0005046
- manager_seq
- 5,046
- direct_report_count
- 9
- org_depth
- 7
- employment_type
- Full-time regular
- work_arrangement
- Remote
- employment_status
- on leave
- hire_date
- 2024-07-18
- tenure_years
- 2.16
- termination_date
- —
- termination_reason
- —
- termination_voluntary
- —
- leave_type
- Unpaid leave of absence
- date_of_birth
- 1975-09-07
- age
- 51
- gender
- Male
- ethnicity
- Asian
- base_salary_cents
- 7,090,203
- base_salary
- $70,902
- currency
- BRL
- bonus_target_pct
- 12%
- bonus_target
- $8,508
- equity_units
- 600
- compa_ratio
- 0.82
- band_min_cents
- 12,136,000
- band_mid_cents
- 14,800,000
- band_max_cents
- 18,352,000
- department_ordinal
- 3
- location_ordinal
- 23
- employment_status_ordinal
- 1
- performance_rating
- 3
- engagement_score
- 31
- flight_risk_score
- 65
- tenure_days
- 770
Compensation history (3)
| compensation_event_id | employee_id | employee_name | effective_date | event_type | reason | percent_change |
|---|---|---|---|---|---|---|
| CMP-0022880-2 | EMP-0022880 | Lionel Vandenberg | 2025-10-23 | Annual bonus | Annual merit cycle | 10.32% |
| CMP-0022880-0 | EMP-0022880 | Lionel Vandenberg | 2024-11-26 | Internal transfer adjustment | Annual merit cycle | 12.25% |
| CMP-0022880-1 | EMP-0022880 | Lionel Vandenberg | 2024-10-07 | Retention award | Promotion to next level | 12.41% |
Leave balances (8)
| balance_id | employee_id | employee_name | leave_type_code | leave_type | accrued_days | taken_days |
|---|---|---|---|---|---|---|
| BAL-0022880-0 | EMP-0022880 | Lionel Vandenberg | PTO | Paid time off | 14.1 | 0 |
| BAL-0022880-1 | EMP-0022880 | Lionel Vandenberg | SICK | Sick leave | 7 | 0 |
| BAL-0022880-2 | EMP-0022880 | Lionel Vandenberg | PARENT | Parental leave | 59.1 | 0 |
| BAL-0022880-3 | EMP-0022880 | Lionel Vandenberg | BEREAV | Bereavement leave | 3.5 | 0 |
| BAL-0022880-4 | EMP-0022880 | Lionel Vandenberg | JURY | Jury duty | 7 | 0 |
| BAL-0022880-5 | EMP-0022880 | Lionel Vandenberg | UNPAID | Unpaid leave of absence | 21.1 | 0 |
| BAL-0022880-6 | EMP-0022880 | Lionel Vandenberg | VOL | Volunteer day | 1.4 | 0 |
| BAL-0022880-7 | EMP-0022880 | Lionel Vandenberg | SAB | Sabbatical | 21.1 | 0 |
Benefit enrollments (4)
| enrollment_id | employee_id | employee_name | plan_code | plan_name | category | status |
|---|---|---|---|---|---|---|
| BEN-0022880-1 | EMP-0022880 | Lionel Vandenberg | DEN-STD | Dental - Standard | Dental | active |
| BEN-0022880-2 | EMP-0022880 | Lionel Vandenberg | 401K-STD | 401(k) - 4% match | Retirement | active |
| BEN-0022880-0 | EMP-0022880 | Lionel Vandenberg | MED-HDHP-FAM | HDHP + HSA - Family | Medical | active |
| BEN-0022880-3 | EMP-0022880 | Lionel Vandenberg | LIFE-1X | Basic life insurance (1x salary) | Life | active |
Training (2)
| training_record_id | employee_id | employee_name | course_code | course_title | category | is_mandatory |
|---|---|---|---|---|---|---|
| TRN-0022880-0 | EMP-0022880 | Lionel Vandenberg | CMP-101 | Code of Conduct | Compliance | yes |
| TRN-0022880-1 | EMP-0022880 | Lionel Vandenberg | LDR-201 | First-Time Manager Fundamentals | Leadership | no |
Recent payslips (48)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0022880-0048 | EMP-0022880 | Lionel Vandenberg | RUN-0048 | 2026-08-26 | 2026-08-30 | $5,081 |
| PAY-0022880-0047 | EMP-0022880 | Lionel Vandenberg | RUN-0047 | 2026-08-11 | 2026-08-15 | $2,954 |
| PAY-0022880-0046 | EMP-0022880 | Lionel Vandenberg | RUN-0046 | 2026-07-27 | 2026-07-31 | $2,954 |
| PAY-0022880-0045 | EMP-0022880 | Lionel Vandenberg | RUN-0045 | 2026-07-12 | 2026-07-16 | $2,954 |
| PAY-0022880-0044 | EMP-0022880 | Lionel Vandenberg | RUN-0044 | 2026-06-27 | 2026-07-01 | $2,954 |
| PAY-0022880-0043 | EMP-0022880 | Lionel Vandenberg | RUN-0043 | 2026-06-12 | 2026-06-16 | $2,954 |
| PAY-0022880-0042 | EMP-0022880 | Lionel Vandenberg | RUN-0042 | 2026-05-28 | 2026-06-01 | $5,081 |
| PAY-0022880-0041 | EMP-0022880 | Lionel Vandenberg | RUN-0041 | 2026-05-13 | 2026-05-17 | $2,954 |
| PAY-0022880-0040 | EMP-0022880 | Lionel Vandenberg | RUN-0040 | 2026-04-28 | 2026-05-02 | $2,954 |
| PAY-0022880-0039 | EMP-0022880 | Lionel Vandenberg | RUN-0039 | 2026-04-13 | 2026-04-17 | $2,954 |
Direct reports (9)
| employee_id | first_name | last_name | full_name | work_email | job_title | job_level |
|---|---|---|---|---|---|---|
| EMP-0176706 | Lars | Dubois | Lars B. Dubois | lars.b.dubois@windrowreach.com | Support Specialist | 1 |
| EMP-0176707 | Mikhail | Rasmussen | Mikhail B. Rasmussen | mikhail.b.rasmussen@windrowreach.com | Senior Support Specialist | 2 |
| EMP-0176708 | Bianca | Dlamini | Bianca B. Dlamini | bianca.b.dlamini@windrowreach.com | Senior Support Specialist | 2 |
| EMP-0176709 | Ondine | Rahman | Ondine B. Rahman | ondine.b.rahman@windrowreach.com | Support Specialist II | 1 |
| EMP-0176710 | Eleanor | Devereux | Eleanor B. Devereux | eleanor.b.devereux@windrowreach.com | Junior Support Specialist | 0 |
| EMP-0176711 | Victor | Puentes | Victor B. Puentes | victor.b.puentes@windrowreach.com | Senior Support Specialist II | 2 |
| EMP-0176712 | Genevieve | Davenport | Genevieve B. Davenport | genevieve.b.davenport@windrowreach.com | Junior Support Specialist | 0 |
| EMP-0176713 | Umberto | Pinheiro | Umberto B. Pinheiro | umberto.b.pinheiro@windrowreach.com | Junior Support Specialist | 0 |
| EMP-0176714 | Santiago | Dalgaard | Santiago B. Dalgaard | santiago.b.dalgaard@windrowreach.com | Principal Support Specialist | 3 |