HR Safe Space
Endpoints / load-j1yko-0039 / employees / EMP-0000316

Rafael Caldwell

EMP-0000316 · Employee · projected from the master template

employee_id
EMP-0000316
seq
316
first_name
Rafael
last_name
Caldwell
middle_initial
—
full_name
Rafael Caldwell
work_email
rafael.caldwell@vertexhaven.io
work_phone
+1-221-255-5516
home_address_line1
5771 Orchard Path
job_title
Director, Design
job_code
DES-06-0
job_family
Design
flsa_status
exempt
job_level
6
job_level_name
Director
job_level_code
D1
is_people_manager
yes
is_executive
no
department_code
DES
department_name
Design
department_function
Technology
cost_center
CC-1800
location_code
MX-MEX
location_city
Mexico City
location_region
CDMX
location_country
Mexico
location_country_code
MX
location_timezone
America/Mexico_City
manager_id
EMP-0000107
manager_seq
107
direct_report_count
4
org_depth
5
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2025-09-26
tenure_years
0.97
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1986-11-25
age
40
gender
Male
ethnicity
White
base_salary_cents
14,116,183
base_salary
$141,162
currency
MXN
bonus_target_pct
20%
bonus_target
$28,232
equity_units
2,200
compa_ratio
1.207
band_min_cents
17,630,000
band_mid_cents
21,500,000
band_max_cents
26,660,000
department_ordinal
11
location_ordinal
12
employment_status_ordinal
0
performance_rating
3
engagement_score
96
flight_risk_score
79
tenure_days
265

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0000316-2EMP-0000316Rafael Caldwell2026-05-27Role changeInternal equity correction8.56%
CMP-0000316-1EMP-0000316Rafael Caldwell2026-04-19PromotionInternal equity correction3.53%
CMP-0000316-0EMP-0000316Rafael Caldwell2025-12-06Equity refreshGeographic differential update10.4%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0000316-0EMP-0000316Rafael CaldwellPTOPaid time off14.10
BAL-0000316-1EMP-0000316Rafael CaldwellSICKSick leave70
BAL-0000316-2EMP-0000316Rafael CaldwellPARENTParental leave59.10
BAL-0000316-3EMP-0000316Rafael CaldwellBEREAVBereavement leave3.50
BAL-0000316-4EMP-0000316Rafael CaldwellJURYJury duty70
BAL-0000316-5EMP-0000316Rafael CaldwellUNPAIDUnpaid leave of absence21.10
BAL-0000316-6EMP-0000316Rafael CaldwellVOLVolunteer day1.40
BAL-0000316-7EMP-0000316Rafael CaldwellSABSabbatical21.10

Benefit enrollments (4)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0000316-2EMP-0000316Rafael Caldwell401K-STD401(k) - 4% matchRetirementactive
BEN-0000316-3EMP-0000316Rafael CaldwellLIFE-1XBasic life insurance (1x salary)Lifeactive
BEN-0000316-0EMP-0000316Rafael CaldwellMED-HDHP-FAMHDHP + HSA - FamilyMedicalactive
BEN-0000316-1EMP-0000316Rafael CaldwellDEN-STDDental - StandardDentalactive

Recent payslips (18)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0000316-0048EMP-0000316Rafael CaldwellRUN-00482026-06-172026-06-21$12,940
PAY-0000316-0047EMP-0000316Rafael CaldwellRUN-00472026-06-022026-06-06$5,882
PAY-0000316-0046EMP-0000316Rafael CaldwellRUN-00462026-05-182026-05-22$5,882
PAY-0000316-0045EMP-0000316Rafael CaldwellRUN-00452026-05-032026-05-07$5,882
PAY-0000316-0044EMP-0000316Rafael CaldwellRUN-00442026-04-182026-04-22$5,882
PAY-0000316-0043EMP-0000316Rafael CaldwellRUN-00432026-04-032026-04-07$5,882
PAY-0000316-0042EMP-0000316Rafael CaldwellRUN-00422026-03-192026-03-23$12,940
PAY-0000316-0041EMP-0000316Rafael CaldwellRUN-00412026-03-042026-03-08$5,882
PAY-0000316-0040EMP-0000316Rafael CaldwellRUN-00402026-02-172026-02-21$5,882
PAY-0000316-0039EMP-0000316Rafael CaldwellRUN-00392026-02-022026-02-06$5,882

See all 18 →

Direct reports (4)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0001086DeniseZapataDenise Zapatadenise.zapata@vertexhaven.ioSenior Manager, Design5
EMP-0001087UriahMatsudaUriah Matsudauriah.matsuda@vertexhaven.ioSenior Design Manager5
EMP-0001088HyacinthYildizHyacinth Yildizhyacinth.yildiz@vertexhaven.ioSenior Design Manager5
EMP-0001089ZainabMartelZainab Martelzainab.martel@vertexhaven.ioSenior Manager, Design5