Idris Prescott
EMP-0037076 · Employee · projected from the master template
- employee_id
- EMP-0037076
- seq
- 37,076
- first_name
- Idris
- last_name
- Prescott
- middle_initial
- —
- full_name
- Idris Prescott
- work_email
- idris.prescott@northline.com
- work_phone
- +1-248-240-4036
- home_address_line1
- 9619 Hollybrook Drive
- job_title
- Staff Marketing Specialist
- job_code
- MKT-03-1
- job_family
- Marketing
- flsa_status
- exempt
- job_level
- 3
- job_level_name
- Staff / Principal
- job_level_code
- IC4
- is_people_manager
- no
- is_executive
- no
- department_code
- MKT
- department_name
- Marketing
- department_function
- Revenue
- cost_center
- CC-2200
- location_code
- IN-HYD
- location_city
- Hyderabad
- location_region
- Telangana
- location_country
- India
- location_country_code
- IN
- location_timezone
- Asia/Kolkata
- manager_id
- EMP-0007668
- manager_seq
- 7,668
- direct_report_count
- 0
- org_depth
- 8
- employment_type
- Part-time regular
- work_arrangement
- On-site
- employment_status
- terminated
- hire_date
- 2017-03-09
- tenure_years
- 9.52
- termination_date
- 2024-05-23
- termination_reason
- Involuntary - conduct
- termination_voluntary
- no
- leave_type
- —
- date_of_birth
- 1974-11-06
- age
- 52
- gender
- Male
- ethnicity
- White
- base_salary_cents
- 4,786,707
- base_salary
- $47,867
- currency
- INR
- bonus_target_pct
- 10%
- bonus_target
- $4,787
- equity_units
- 450
- compa_ratio
- 1.041
- band_min_cents
- 10,988,000
- band_mid_cents
- 13,400,000
- band_max_cents
- 16,616,000
- department_ordinal
- 5
- location_ordinal
- 19
- employment_status_ordinal
- 2
- performance_rating
- 2
- engagement_score
- 21
- flight_risk_score
- 80
- tenure_days
- 2,632
Compensation history (3)
| compensation_event_id | employee_id | employee_name | effective_date | event_type | reason | percent_change |
|---|---|---|---|---|---|---|
| CMP-0037076-2 | EMP-0037076 | Idris Prescott | 2021-03-20 | Promotion | Promotion to next level | 10.52% |
| CMP-0037076-1 | EMP-0037076 | Idris Prescott | 2020-12-26 | Equity refresh | Benchmark below market P50 | 2.33% |
| CMP-0037076-0 | EMP-0037076 | Idris Prescott | 2020-09-21 | Equity refresh | Contractual step increase | 4.33% |
Benefit enrollments (5)
| enrollment_id | employee_id | employee_name | plan_code | plan_name | category | status |
|---|---|---|---|---|---|---|
| BEN-0037076-1 | EMP-0037076 | Idris Prescott | DEN-STD | Dental - Standard | Dental | terminated |
| BEN-0037076-3 | EMP-0037076 | Idris Prescott | LTD | Long-term disability | Disability | terminated |
| BEN-0037076-0 | EMP-0037076 | Idris Prescott | MED-HDHP-FAM | HDHP + HSA - Family | Medical | terminated |
| BEN-0037076-2 | EMP-0037076 | Idris Prescott | 401K-STD | 401(k) - 4% match | Retirement | terminated |
| BEN-0037076-4 | EMP-0037076 | Idris Prescott | LEGAL-PLAN | Group legal plan | Other | terminated |
Recent payslips (21)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0037076-0021 | EMP-0037076 | Idris Prescott | RUN-0021 | 2024-05-25 | 2024-05-29 | $1,994 |
| PAY-0037076-0020 | EMP-0037076 | Idris Prescott | RUN-0020 | 2024-05-10 | 2024-05-14 | $1,994 |
| PAY-0037076-0019 | EMP-0037076 | Idris Prescott | RUN-0019 | 2024-04-25 | 2024-04-29 | $1,994 |
| PAY-0037076-0018 | EMP-0037076 | Idris Prescott | RUN-0018 | 2024-04-10 | 2024-04-14 | $3,191 |
| PAY-0037076-0017 | EMP-0037076 | Idris Prescott | RUN-0017 | 2024-03-26 | 2024-03-30 | $1,994 |
| PAY-0037076-0016 | EMP-0037076 | Idris Prescott | RUN-0016 | 2024-03-11 | 2024-03-15 | $1,994 |
| PAY-0037076-0015 | EMP-0037076 | Idris Prescott | RUN-0015 | 2024-02-25 | 2024-02-29 | $1,994 |
| PAY-0037076-0014 | EMP-0037076 | Idris Prescott | RUN-0014 | 2024-02-10 | 2024-02-14 | $1,994 |
| PAY-0037076-0013 | EMP-0037076 | Idris Prescott | RUN-0013 | 2024-01-26 | 2024-01-30 | $1,994 |
| PAY-0037076-0012 | EMP-0037076 | Idris Prescott | RUN-0012 | 2024-01-11 | 2024-01-15 | $3,191 |