Joaquin Ruiz
EMP-0004792 · Employee · projected from the master template
- employee_id
- EMP-0004792
- seq
- 4,792
- first_name
- Joaquin
- last_name
- Ruiz
- middle_initial
- —
- full_name
- Joaquin Ruiz
- work_email
- joaquin.ruiz@northline.com
- work_phone
- +1-738-291-9106
- home_address_line1
- 9629 Chestnut Avenue
- job_title
- Senior Manager, IT
- job_code
- IT-05-0
- job_family
- Information Technology
- flsa_status
- exempt
- job_level
- 5
- job_level_name
- Senior Manager
- job_level_code
- M2
- is_people_manager
- yes
- is_executive
- no
- department_code
- IT
- department_name
- Information Technology
- department_function
- Technology
- cost_center
- CC-1400
- location_code
- ES-MAD
- location_city
- Madrid
- location_region
- Madrid
- location_country
- Spain
- location_country_code
- ES
- location_timezone
- Europe/Madrid
- manager_id
- EMP-0001344
- manager_seq
- 1,344
- direct_report_count
- 5
- org_depth
- 6
- employment_type
- Full-time regular
- work_arrangement
- Hybrid
- employment_status
- terminated
- hire_date
- 2020-08-09
- tenure_years
- 6.1
- termination_date
- 2023-11-01
- termination_reason
- End of contract
- termination_voluntary
- no
- leave_type
- —
- date_of_birth
- 1976-01-25
- age
- 50
- gender
- Male
- ethnicity
- Hispanic or Latino
- base_salary_cents
- 13,345,941
- base_salary
- $133,459
- currency
- EUR
- bonus_target_pct
- 15%
- bonus_target
- $20,019
- equity_units
- 1,100
- compa_ratio
- 1.005
- band_min_cents
- 14,432,000
- band_mid_cents
- 17,600,000
- band_max_cents
- 21,824,000
- department_ordinal
- 7
- location_ordinal
- 17
- employment_status_ordinal
- 2
- performance_rating
- 3
- engagement_score
- 31
- flight_risk_score
- 9
- tenure_days
- 1,179
Compensation history (1)
| compensation_event_id | employee_id | employee_name | effective_date | event_type | reason | percent_change |
|---|---|---|---|---|---|---|
| CMP-0004792-0 | EMP-0004792 | Joaquin Ruiz | 2024-09-18 | Retention award | Counter-offer approved by CHRO | 7.26% |
Benefit enrollments (5)
| enrollment_id | employee_id | employee_name | plan_code | plan_name | category | status |
|---|---|---|---|---|---|---|
| BEN-0004792-0 | EMP-0004792 | Joaquin Ruiz | MED-PPO-EE | PPO Medical - Employee only | Medical | terminated |
| BEN-0004792-4 | EMP-0004792 | Joaquin Ruiz | PET | Pet insurance | Other | terminated |
| BEN-0004792-2 | EMP-0004792 | Joaquin Ruiz | 401K-STD | 401(k) - 4% match | Retirement | terminated |
| BEN-0004792-3 | EMP-0004792 | Joaquin Ruiz | LIFE-1X | Basic life insurance (1x salary) | Life | terminated |
| BEN-0004792-1 | EMP-0004792 | Joaquin Ruiz | DEN-FAM | Dental - Family | Dental | terminated |
Recent payslips (8)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0004792-0008 | EMP-0004792 | Joaquin Ruiz | RUN-0008 | 2023-11-12 | 2023-11-16 | $5,561 |
| PAY-0004792-0007 | EMP-0004792 | Joaquin Ruiz | RUN-0007 | 2023-10-28 | 2023-11-01 | $5,561 |
| PAY-0004792-0006 | EMP-0004792 | Joaquin Ruiz | RUN-0006 | 2023-10-13 | 2023-10-17 | $10,566 |
| PAY-0004792-0005 | EMP-0004792 | Joaquin Ruiz | RUN-0005 | 2023-09-28 | 2023-10-02 | $5,561 |
| PAY-0004792-0004 | EMP-0004792 | Joaquin Ruiz | RUN-0004 | 2023-09-13 | 2023-09-17 | $5,561 |
| PAY-0004792-0003 | EMP-0004792 | Joaquin Ruiz | RUN-0003 | 2023-08-29 | 2023-09-02 | $5,561 |
| PAY-0004792-0002 | EMP-0004792 | Joaquin Ruiz | RUN-0002 | 2023-08-14 | 2023-08-18 | $5,561 |
| PAY-0004792-0001 | EMP-0004792 | Joaquin Ruiz | RUN-0001 | 2023-07-30 | 2023-08-03 | $5,561 |
Direct reports (5)
| employee_id | first_name | last_name | full_name | work_email | job_title | job_level |
|---|---|---|---|---|---|---|
| EMP-0021393 | Theodore | Jayaraman | Theodore Jayaraman | theodore.jayaraman@northline.com | IT Manager | 4 |
| EMP-0021394 | Victor | Sullivan | Victor Sullivan | victor.sullivan@northline.com | IT Manager | 4 |
| EMP-0021395 | Genevieve | Iyer | Genevieve Iyer | genevieve.iyer@northline.com | IT Manager | 4 |
| EMP-0021396 | Umberto | Stoltenberg | Umberto Stoltenberg | umberto.stoltenberg@northline.com | IT Manager | 4 |
| EMP-0021397 | Santiago | Ikeda | Santiago Ikeda | santiago.ikeda@northline.com | Manager, Information Technology | 4 |