Alistair C. Castellanos
EMP-0254761 · Employee · projected from the master template
- employee_id
- EMP-0254761
- seq
- 254,761
- first_name
- Alistair
- last_name
- Castellanos
- middle_initial
- C
- full_name
- Alistair C. Castellanos
- work_email
- alistair.c.castellanos@tesseracourt.com
- work_phone
- +1-272-257-5721
- home_address_line1
- 9696 Stonebridge Avenue
- job_title
- Senior Operations Specialist
- job_code
- OPS-02-0
- job_family
- Operations
- flsa_status
- exempt
- job_level
- 2
- job_level_name
- Senior Specialist
- job_level_code
- IC3
- is_people_manager
- no
- is_executive
- no
- department_code
- OPS
- department_name
- Operations
- department_function
- Operations
- cost_center
- CC-3000
- location_code
- US-RDU
- location_city
- Raleigh
- location_region
- North Carolina
- location_country
- United States
- location_country_code
- US
- location_timezone
- America/New_York
- manager_id
- EMP-0033301
- manager_seq
- 33,301
- direct_report_count
- 0
- org_depth
- 8
- employment_type
- Full-time regular
- work_arrangement
- Remote
- employment_status
- terminated
- hire_date
- 2020-11-02
- tenure_years
- 5.87
- termination_date
- 2025-12-03
- termination_reason
- Involuntary - reduction in force
- termination_voluntary
- no
- leave_type
- —
- date_of_birth
- 1988-09-10
- age
- 38
- gender
- Male
- ethnicity
- Asian
- base_salary_cents
- 10,184,571
- base_salary
- $101,846
- currency
- USD
- bonus_target_pct
- 7%
- bonus_target
- $7,129
- equity_units
- 150
- compa_ratio
- 1.106
- band_min_cents
- 8,118,000
- band_mid_cents
- 9,900,000
- band_max_cents
- 12,276,000
- department_ordinal
- 2
- location_ordinal
- 8
- employment_status_ordinal
- 2
- performance_rating
- 3
- engagement_score
- 56
- flight_risk_score
- 18
- tenure_days
- 1,857
Recent payslips (34)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0254761-0034 | EMP-0254761 | Alistair C. Castellanos | RUN-0034 | 2025-12-16 | 2025-12-20 | $4,244 |
| PAY-0254761-0033 | EMP-0254761 | Alistair C. Castellanos | RUN-0033 | 2025-12-01 | 2025-12-05 | $4,244 |
| PAY-0254761-0032 | EMP-0254761 | Alistair C. Castellanos | RUN-0032 | 2025-11-16 | 2025-11-20 | $4,244 |
| PAY-0254761-0031 | EMP-0254761 | Alistair C. Castellanos | RUN-0031 | 2025-11-01 | 2025-11-05 | $4,244 |
| PAY-0254761-0030 | EMP-0254761 | Alistair C. Castellanos | RUN-0030 | 2025-10-17 | 2025-10-21 | $6,026 |
| PAY-0254761-0029 | EMP-0254761 | Alistair C. Castellanos | RUN-0029 | 2025-10-02 | 2025-10-06 | $4,244 |
| PAY-0254761-0028 | EMP-0254761 | Alistair C. Castellanos | RUN-0028 | 2025-09-17 | 2025-09-21 | $4,244 |
| PAY-0254761-0027 | EMP-0254761 | Alistair C. Castellanos | RUN-0027 | 2025-09-02 | 2025-09-06 | $4,244 |
| PAY-0254761-0026 | EMP-0254761 | Alistair C. Castellanos | RUN-0026 | 2025-08-18 | 2025-08-22 | $4,244 |
| PAY-0254761-0025 | EMP-0254761 | Alistair C. Castellanos | RUN-0025 | 2025-08-03 | 2025-08-07 | $4,244 |