Callum Malhotra
EMP-0058470 · Employee · projected from the master template
- employee_id
- EMP-0058470
- seq
- 58,470
- first_name
- Callum
- last_name
- Malhotra
- middle_initial
- —
- full_name
- Callum Malhotra
- work_email
- callum.malhotra@northline.com
- work_phone
- +1-218-283-8306
- home_address_line1
- 5738 Lantern Way
- job_title
- Product Manager II
- job_code
- PRD-01-1
- job_family
- Product
- flsa_status
- exempt
- job_level
- 1
- job_level_name
- Specialist
- job_level_code
- IC2
- is_people_manager
- no
- is_executive
- no
- department_code
- PRD
- department_name
- Product
- department_function
- Technology
- cost_center
- CC-1200
- 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-0010045
- manager_seq
- 10,045
- direct_report_count
- 0
- org_depth
- 8
- employment_type
- Contractor
- work_arrangement
- Hybrid
- employment_status
- terminated
- hire_date
- 2022-11-24
- tenure_years
- 3.81
- termination_date
- 2024-07-30
- termination_reason
- Resignation - compensation
- termination_voluntary
- yes
- leave_type
- —
- date_of_birth
- 1983-10-28
- age
- 43
- gender
- Male
- ethnicity
- Asian
- base_salary_cents
- 10,641,196
- base_salary
- $106,412
- currency
- USD
- bonus_target_pct
- 5%
- bonus_target
- $5,321
- equity_units
- 50
- compa_ratio
- 1.143
- band_min_cents
- 6,232,000
- band_mid_cents
- 7,600,000
- band_max_cents
- 9,424,000
- department_ordinal
- 9
- location_ordinal
- 1
- employment_status_ordinal
- 2
- performance_rating
- 3
- engagement_score
- 92
- flight_risk_score
- 75
- tenure_days
- 614
Performance reviews (3)
| review_id | employee_id | employee_name | cycle_code | rating | rating_label | potential |
|---|---|---|---|---|---|---|
| REV-0058470-0 | EMP-0058470 | Callum Malhotra | FY-CUR-H1 | 3 | Meets expectations | Low potential |
| REV-0058470-1 | EMP-0058470 | Callum Malhotra | FY-PRV-EOY | 3 | Meets expectations | Low potential |
| REV-0058470-2 | EMP-0058470 | Callum Malhotra | FY-PRV-H1 | 4 | Exceeds expectations | Moderate potential |
Recent payslips (26)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0058470-0026 | EMP-0058470 | Callum Malhotra | RUN-0026 | 2024-08-08 | 2024-08-12 | $4,434 |
| PAY-0058470-0025 | EMP-0058470 | Callum Malhotra | RUN-0025 | 2024-07-24 | 2024-07-28 | $4,434 |
| PAY-0058470-0024 | EMP-0058470 | Callum Malhotra | RUN-0024 | 2024-07-09 | 2024-07-13 | $5,764 |
| PAY-0058470-0023 | EMP-0058470 | Callum Malhotra | RUN-0023 | 2024-06-24 | 2024-06-28 | $4,434 |
| PAY-0058470-0022 | EMP-0058470 | Callum Malhotra | RUN-0022 | 2024-06-09 | 2024-06-13 | $4,434 |
| PAY-0058470-0021 | EMP-0058470 | Callum Malhotra | RUN-0021 | 2024-05-25 | 2024-05-29 | $4,434 |
| PAY-0058470-0020 | EMP-0058470 | Callum Malhotra | RUN-0020 | 2024-05-10 | 2024-05-14 | $4,434 |
| PAY-0058470-0019 | EMP-0058470 | Callum Malhotra | RUN-0019 | 2024-04-25 | 2024-04-29 | $4,434 |
| PAY-0058470-0018 | EMP-0058470 | Callum Malhotra | RUN-0018 | 2024-04-10 | 2024-04-14 | $5,764 |
| PAY-0058470-0017 | EMP-0058470 | Callum Malhotra | RUN-0017 | 2024-03-26 | 2024-03-30 | $4,434 |