HR Safe Space
Endpoints / load-j1yko-0036 / employees / EMP-0207996

Ambrose B. Aguilar

EMP-0207996 · Employee · projected from the master template

employee_id
EMP-0207996
seq
207,996
first_name
Ambrose
last_name
Aguilar
middle_initial
B
full_name
Ambrose B. Aguilar
work_email
ambrose.b.aguilar@tesseracourt.com
work_phone
+1-525-248-4885
home_address_line1
3751 Mill Pond Road
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
CA-VAN
location_city
Vancouver
location_region
British Columbia
location_country
Canada
location_country_code
CA
location_timezone
America/Vancouver
manager_id
EMP-0028105
manager_seq
28,105
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2018-05-24
tenure_years
8.31
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1978-10-01
age
48
gender
Male
ethnicity
Asian
base_salary_cents
13,698,490
base_salary
$136,985
currency
CAD
bonus_target_pct
10%
bonus_target
$13,698
equity_units
450
compa_ratio
0.907
band_min_cents
10,988,000
band_mid_cents
13,400,000
band_max_cents
16,616,000
department_ordinal
5
location_ordinal
11
employment_status_ordinal
0
performance_rating
3
engagement_score
79
flight_risk_score
93
tenure_days
2,973

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0207996-0EMP-0207996Ambrose B. Aguilar2023-12-17Market adjustmentPromotion to next level10.2%
CMP-0207996-1EMP-0207996Ambrose B. Aguilar2020-06-30Internal transfer adjustmentPerformance calibration outcome1.84%

Performance reviews (4)

review_idemployee_idemployee_namecycle_coderatingrating_labelpotential
REV-0207996-0EMP-0207996Ambrose B. AguilarFY-CUR-H13Meets expectationsModerate potential
REV-0207996-1EMP-0207996Ambrose B. AguilarFY-PRV-EOY3Meets expectationsModerate potential
REV-0207996-2EMP-0207996Ambrose B. AguilarFY-PRV-H14Exceeds expectationsModerate potential
REV-0207996-3EMP-0207996Ambrose B. AguilarFY-P2-EOY3Meets expectationsHigh potential

Goals (1)

goal_idemployee_idemployee_nametitlecategoryprogress_pctstatus
GOL-0207996-0EMP-0207996Ambrose B. AguilarEstablish a quarterly business review cadencePeople and culture100%achieved

Time off requests (4)

request_idemployee_idemployee_nameleave_typestart_dateend_datebusiness_days
TOR-0207996-2EMP-0207996Ambrose B. AguilarSick leave2026-07-242026-07-241
TOR-0207996-3EMP-0207996Ambrose B. AguilarVolunteer day2026-06-212026-06-277
TOR-0207996-1EMP-0207996Ambrose B. AguilarBereavement leave2025-12-282026-01-015
TOR-0207996-0EMP-0207996Ambrose B. AguilarBereavement leave2025-07-282025-08-0610

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0207996-0EMP-0207996Ambrose B. AguilarPTOPaid time off14.10
BAL-0207996-1EMP-0207996Ambrose B. AguilarSICKSick leave70
BAL-0207996-2EMP-0207996Ambrose B. AguilarPARENTParental leave59.10
BAL-0207996-3EMP-0207996Ambrose B. AguilarBEREAVBereavement leave3.50
BAL-0207996-4EMP-0207996Ambrose B. AguilarJURYJury duty70
BAL-0207996-5EMP-0207996Ambrose B. AguilarUNPAIDUnpaid leave of absence21.10
BAL-0207996-6EMP-0207996Ambrose B. AguilarVOLVolunteer day1.40
BAL-0207996-7EMP-0207996Ambrose B. AguilarSABSabbatical21.10

Benefit enrollments (5)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0207996-2EMP-0207996Ambrose B. Aguilar401K-STD401(k) - 4% matchRetirementactive
BEN-0207996-0EMP-0207996Ambrose B. AguilarMED-PPO-EEPPO Medical - Employee onlyMedicalactive
BEN-0207996-3EMP-0207996Ambrose B. AguilarLIFE-1XBasic life insurance (1x salary)Lifeactive
BEN-0207996-1EMP-0207996Ambrose B. AguilarDEN-STDDental - StandardDentalactive
BEN-0207996-4EMP-0207996Ambrose B. AguilarPETPet insuranceOtheractive

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0207996-0048EMP-0207996Ambrose B. AguilarRUN-00482026-07-132026-07-17$9,132
PAY-0207996-0047EMP-0207996Ambrose B. AguilarRUN-00472026-06-282026-07-02$5,708
PAY-0207996-0046EMP-0207996Ambrose B. AguilarRUN-00462026-06-132026-06-17$5,708
PAY-0207996-0045EMP-0207996Ambrose B. AguilarRUN-00452026-05-292026-06-02$5,708
PAY-0207996-0044EMP-0207996Ambrose B. AguilarRUN-00442026-05-142026-05-18$5,708
PAY-0207996-0043EMP-0207996Ambrose B. AguilarRUN-00432026-04-292026-05-03$5,708
PAY-0207996-0042EMP-0207996Ambrose B. AguilarRUN-00422026-04-142026-04-18$9,132
PAY-0207996-0041EMP-0207996Ambrose B. AguilarRUN-00412026-03-302026-04-03$5,708
PAY-0207996-0040EMP-0207996Ambrose B. AguilarRUN-00402026-03-152026-03-19$5,708
PAY-0207996-0039EMP-0207996Ambrose B. AguilarRUN-00392026-02-282026-03-04$5,708

See all 48 →