Malcolm Lopes
EMP-0020002 · Employee · projected from the master template
- employee_id
- EMP-0020002
- seq
- 20,002
- first_name
- Malcolm
- last_name
- Lopes
- middle_initial
- —
- full_name
- Malcolm Lopes
- work_email
- malcolm.lopes@northline.com
- work_phone
- +1-737-299-9970
- home_address_line1
- 4317 Bayview Crescent
- job_title
- Manager, Manufacturing
- job_code
- MFG-04-1
- job_family
- Manufacturing
- flsa_status
- exempt
- job_level
- 4
- job_level_name
- Manager
- job_level_code
- M1
- is_people_manager
- yes
- is_executive
- no
- department_code
- MFG
- department_name
- Manufacturing
- department_function
- Operations
- cost_center
- CC-3200
- 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-0004513
- manager_seq
- 4,513
- direct_report_count
- 9
- org_depth
- 7
- employment_type
- Full-time regular
- work_arrangement
- Remote
- employment_status
- active
- hire_date
- 2025-05-22
- tenure_years
- 1.32
- termination_date
- —
- termination_reason
- —
- termination_voluntary
- —
- leave_type
- —
- date_of_birth
- 1979-11-20
- age
- 47
- gender
- Male
- ethnicity
- Asian
- base_salary_cents
- 13,754,664
- base_salary
- $137,547
- currency
- USD
- bonus_target_pct
- 12%
- bonus_target
- $16,506
- equity_units
- 600
- compa_ratio
- 1.064
- band_min_cents
- 12,136,000
- band_mid_cents
- 14,800,000
- band_max_cents
- 18,352,000
- department_ordinal
- 4
- location_ordinal
- 1
- employment_status_ordinal
- 0
- performance_rating
- 1
- engagement_score
- 47
- flight_risk_score
- 34
- tenure_days
- 45
Leave balances (8)
| balance_id | employee_id | employee_name | leave_type_code | leave_type | accrued_days | taken_days |
|---|---|---|---|---|---|---|
| BAL-0020002-0 | EMP-0020002 | Malcolm Lopes | PTO | Paid time off | 2.5 | 0 |
| BAL-0020002-1 | EMP-0020002 | Malcolm Lopes | SICK | Sick leave | 1.2 | 0 |
| BAL-0020002-2 | EMP-0020002 | Malcolm Lopes | PARENT | Parental leave | 10.4 | 0 |
| BAL-0020002-3 | EMP-0020002 | Malcolm Lopes | BEREAV | Bereavement leave | 0.6 | 0 |
| BAL-0020002-4 | EMP-0020002 | Malcolm Lopes | JURY | Jury duty | 1.2 | 0 |
| BAL-0020002-5 | EMP-0020002 | Malcolm Lopes | UNPAID | Unpaid leave of absence | 3.7 | 0 |
| BAL-0020002-6 | EMP-0020002 | Malcolm Lopes | VOL | Volunteer day | 0.2 | 0 |
| BAL-0020002-7 | EMP-0020002 | Malcolm Lopes | SAB | Sabbatical | 3.7 | 0 |
Recent payslips (3)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0020002-0048 | EMP-0020002 | Malcolm Lopes | RUN-0048 | 2025-07-05 | 2025-07-09 | $9,858 |
| PAY-0020002-0047 | EMP-0020002 | Malcolm Lopes | RUN-0047 | 2025-06-20 | 2025-06-24 | $5,731 |
| PAY-0020002-0046 | EMP-0020002 | Malcolm Lopes | RUN-0046 | 2025-06-05 | 2025-06-09 | $5,731 |
Direct reports (9)
| employee_id | first_name | last_name | full_name | work_email | job_title | job_level |
|---|---|---|---|---|---|---|
| EMP-0148081 | Ambrose | Weinstein | Ambrose A. Weinstein | ambrose.a.weinstein@northline.com | Senior Production Technician | 2 |
| EMP-0148082 | Nicole | Lundgren | Nicole A. Lundgren | nicole.a.lundgren@northline.com | Associate Production Technician | 0 |
| EMP-0148083 | Theresa | Wanjala | Theresa A. Wanjala | theresa.a.wanjala@northline.com | Production Technician II | 1 |
| EMP-0148084 | Kwesi | Lombardi | Kwesi A. Lombardi | kwesi.a.lombardi@northline.com | Associate Production Technician | 0 |
| EMP-0148085 | Willa | Wainwright | Willa A. Wainwright | willa.a.wainwright@northline.com | Senior Production Technician II | 2 |
| EMP-0148086 | Fatima | Lindqvist | Fatima A. Lindqvist | fatima.a.lindqvist@northline.com | Associate Production Technician | 0 |
| EMP-0148087 | Esteban | Vukovic | Esteban A. Vukovic | esteban.a.vukovic@northline.com | Junior Production Technician | 0 |
| EMP-0148088 | Erika | Ledesma | Erika A. Ledesma | erika.a.ledesma@northline.com | Associate Production Technician | 0 |
| EMP-0148089 | Malia | Vidal | Malia A. Vidal | malia.a.vidal@northline.com | Production Technician II | 1 |