Lawrence Castellanos
EMP-0001289 · Employee · projected from the master template
- employee_id
- EMP-0001289
- seq
- 1,289
- first_name
- Lawrence
- last_name
- Castellanos
- middle_initial
- —
- full_name
- Lawrence Castellanos
- work_email
- lawrence.castellanos@marrowgrove.com
- work_phone
- +1-268-264-6459
- home_address_line1
- 5581 Granite Terrace
- job_title
- Senior Manager, Engineering
- job_code
- ENG-05-0
- job_family
- Engineering
- flsa_status
- exempt
- job_level
- 5
- job_level_name
- Senior Manager
- job_level_code
- M2
- is_people_manager
- yes
- is_executive
- no
- department_code
- ENG
- department_name
- Engineering
- department_function
- Technology
- cost_center
- CC-1000
- 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-0000376
- manager_seq
- 376
- direct_report_count
- 5
- org_depth
- 6
- employment_type
- Full-time regular
- work_arrangement
- Hybrid
- employment_status
- terminated
- hire_date
- 2025-09-11
- tenure_years
- 1.01
- termination_date
- 2026-03-15
- termination_reason
- Resignation - compensation
- termination_voluntary
- yes
- leave_type
- —
- date_of_birth
- 1994-11-06
- age
- 32
- gender
- Male
- ethnicity
- White
- base_salary_cents
- 25,898,572
- base_salary
- $258,986
- currency
- USD
- bonus_target_pct
- 15%
- bonus_target
- $38,848
- equity_units
- 1,100
- compa_ratio
- 0.91
- band_min_cents
- 14,432,000
- band_mid_cents
- 17,600,000
- band_max_cents
- 21,824,000
- department_ordinal
- 0
- location_ordinal
- 1
- employment_status_ordinal
- 2
- performance_rating
- 2
- engagement_score
- 37
- flight_risk_score
- 61
- tenure_days
- 185
Recent payslips (14)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0001289-0044 | EMP-0001289 | Lawrence Castellanos | RUN-0044 | 2026-03-29 | 2026-04-02 | $10,791 |
| PAY-0001289-0043 | EMP-0001289 | Lawrence Castellanos | RUN-0043 | 2026-03-14 | 2026-03-18 | $10,791 |
| PAY-0001289-0042 | EMP-0001289 | Lawrence Castellanos | RUN-0042 | 2026-02-27 | 2026-03-03 | $20,503 |
| PAY-0001289-0041 | EMP-0001289 | Lawrence Castellanos | RUN-0041 | 2026-02-12 | 2026-02-16 | $10,791 |
| PAY-0001289-0040 | EMP-0001289 | Lawrence Castellanos | RUN-0040 | 2026-01-28 | 2026-02-01 | $10,791 |
| PAY-0001289-0039 | EMP-0001289 | Lawrence Castellanos | RUN-0039 | 2026-01-13 | 2026-01-17 | $10,791 |
| PAY-0001289-0038 | EMP-0001289 | Lawrence Castellanos | RUN-0038 | 2025-12-29 | 2026-01-02 | $10,791 |
| PAY-0001289-0037 | EMP-0001289 | Lawrence Castellanos | RUN-0037 | 2025-12-14 | 2025-12-18 | $10,791 |
| PAY-0001289-0036 | EMP-0001289 | Lawrence Castellanos | RUN-0036 | 2025-11-29 | 2025-12-03 | $20,503 |
| PAY-0001289-0035 | EMP-0001289 | Lawrence Castellanos | RUN-0035 | 2025-11-14 | 2025-11-18 | $10,791 |
Direct reports (5)
| employee_id | first_name | last_name | full_name | work_email | job_title | job_level |
|---|---|---|---|---|---|---|
| EMP-0005561 | Norman | Valencia | Norman Valencia | norman.valencia@marrowgrove.com | Engineering Manager | 4 |
| EMP-0005562 | Chandra | Kramer | Chandra Kramer | chandra.kramer@marrowgrove.com | Sales Manager | 4 |
| EMP-0005563 | Andres | Underwood | Andres Underwood | andres.underwood@marrowgrove.com | Manager, Sales | 4 |
| EMP-0005564 | Daichi | Kohli | Daichi Kohli | daichi.kohli@marrowgrove.com | Sales Manager | 4 |
| EMP-0005565 | Liesl | Tsai | Liesl Tsai | liesl.tsai@marrowgrove.com | Manager, Sales | 4 |