HR Safe Space
Endpoints / vellum-quill-7804 / employees / EMP-0015410

Esperanza Hoffman

EMP-0015410 · Employee · projected from the master template

employee_id
EMP-0015410
seq
15,410
first_name
Esperanza
last_name
Hoffman
middle_initial
—
full_name
Esperanza Hoffman
work_email
esperanza.hoffman@asterhollow.io
work_phone
+1-232-211-1148
home_address_line1
724 Harbor Road
job_title
Marketing Manager
job_code
MKT-04-0
job_family
Marketing
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
MKT
department_name
Marketing
department_function
Revenue
cost_center
CC-2200
location_code
US-AUS
location_city
Austin
location_region
Texas
location_country
United States
location_country_code
US
location_timezone
America/Chicago
manager_id
EMP-0003622
manager_seq
3,622
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2024-09-13
tenure_years
2
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1979-11-04
age
47
gender
Female
ethnicity
White
base_salary_cents
11,802,083
base_salary
$118,021
currency
USD
bonus_target_pct
12%
bonus_target
$14,163
equity_units
600
compa_ratio
0.87
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
5
location_ordinal
3
employment_status_ordinal
0
performance_rating
4
engagement_score
94
flight_risk_score
13
tenure_days
16

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0015410-0EMP-0015410Esperanza HoffmanPTOPaid time off0.90
BAL-0015410-1EMP-0015410Esperanza HoffmanSICKSick leave0.40
BAL-0015410-2EMP-0015410Esperanza HoffmanPARENTParental leave3.70
BAL-0015410-3EMP-0015410Esperanza HoffmanBEREAVBereavement leave0.20
BAL-0015410-4EMP-0015410Esperanza HoffmanJURYJury duty0.40
BAL-0015410-5EMP-0015410Esperanza HoffmanUNPAIDUnpaid leave of absence1.30
BAL-0015410-6EMP-0015410Esperanza HoffmanVOLVolunteer day0.10
BAL-0015410-7EMP-0015410Esperanza HoffmanSABSabbatical1.30

Training (4)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0015410-1EMP-0015410Esperanza HoffmanTEC-310Secure Coding PracticesTechnicalno
TRN-0015410-2EMP-0015410Esperanza HoffmanONB-001New Hire OrientationOnboardingyes
TRN-0015410-0EMP-0015410Esperanza HoffmanCMP-160Insider Trading PolicyComplianceno
TRN-0015410-3EMP-0015410Esperanza HoffmanCMP-120Data Privacy & GDPR EssentialsComplianceyes

Recent payslips (2)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0015410-0048EMP-0015410Esperanza HoffmanRUN-00482024-09-282024-10-02$8,458
PAY-0015410-0047EMP-0015410Esperanza HoffmanRUN-00472024-09-132024-09-17$4,918

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0105061WalterPellegriniWalter A. Pellegriniwalter.a.pellegrini@asterhollow.ioMarketing Specialist1
EMP-0105062GloriaChowdhuryGloria A. Chowdhurygloria.a.chowdhury@asterhollow.ioSenior Marketing Specialist2
EMP-0105063IlanaParekhIlana A. Parekhilana.a.parekh@asterhollow.ioSenior Marketing Specialist2
EMP-0105064WyattChaudhryWyatt A. Chaudhrywyatt.a.chaudhry@asterhollow.ioMarketing Specialist II1
EMP-0105065HanaPadillaHana A. Padillahana.a.padilla@asterhollow.ioSenior Marketing Specialist II2
EMP-0105066GretaChakrabortyGreta A. Chakrabortygreta.a.chakraborty@asterhollow.ioAssociate Marketing Specialist0
EMP-0105067AminaOrtegaAmina A. Ortegaamina.a.ortega@asterhollow.ioPrincipal Marketing Specialist3
EMP-0105068JuliaCamposJulia A. Camposjulia.a.campos@asterhollow.ioMarketing Specialist II1
EMP-0105069HowardOkonkwoHoward A. Okonkwohoward.a.okonkwo@asterhollow.ioAssociate Marketing Specialist0