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

Rowan A. Ramsay

EMP-0131876 · Employee · projected from the master template

employee_id
EMP-0131876
seq
131,876
first_name
Rowan
last_name
Ramsay
middle_initial
A
full_name
Rowan A. Ramsay
work_email
rowan.a.ramsay@tesseracourt.com
work_phone
+1-502-287-8780
home_address_line1
9028 Stonebridge Avenue
job_title
Junior Account Executive
job_code
SLS-00-1
job_family
Sales
flsa_status
exempt
job_level
0
job_level_name
Associate
job_level_code
IC1
is_people_manager
no
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
US-CHI
location_city
Chicago
location_region
Illinois
location_country
United States
location_country_code
US
location_timezone
America/Chicago
manager_id
EMP-0019647
manager_seq
19,647
direct_report_count
0
org_depth
8
employment_type
Full-time regular
work_arrangement
Remote
employment_status
active
hire_date
2025-05-05
tenure_years
1.36
termination_date
termination_reason
termination_voluntary
leave_type
date_of_birth
1976-08-07
age
50
gender
Female
ethnicity
Hispanic or Latino
base_salary_cents
7,257,072
base_salary
$72,571
currency
USD
bonus_target_pct
3%
bonus_target
$2,177
equity_units
0
compa_ratio
1.098
band_min_cents
4,756,000
band_mid_cents
5,800,000
band_max_cents
7,192,000
department_ordinal
1
location_ordinal
4
employment_status_ordinal
0
performance_rating
2
engagement_score
62
flight_risk_score
36
tenure_days
435

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0131876-2EMP-0131876Rowan A. Ramsay2026-06-28Market adjustmentBenchmark below market P502.99%
CMP-0131876-0EMP-0131876Rowan A. Ramsay2026-03-03Internal transfer adjustmentRetention risk identified by manager6.49%
CMP-0131876-1EMP-0131876Rowan A. Ramsay2025-05-05Equity refreshCounter-offer approved by CHRO8.35%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0131876-0EMP-0131876Rowan A. RamsayPTOPaid time off14.10
BAL-0131876-1EMP-0131876Rowan A. RamsaySICKSick leave70
BAL-0131876-2EMP-0131876Rowan A. RamsayPARENTParental leave59.10
BAL-0131876-3EMP-0131876Rowan A. RamsayBEREAVBereavement leave3.50
BAL-0131876-4EMP-0131876Rowan A. RamsayJURYJury duty70
BAL-0131876-5EMP-0131876Rowan A. RamsayUNPAIDUnpaid leave of absence21.10
BAL-0131876-6EMP-0131876Rowan A. RamsayVOLVolunteer day1.40
BAL-0131876-7EMP-0131876Rowan A. RamsaySABSabbatical21.10

Benefit enrollments (5)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0131876-1EMP-0131876Rowan A. RamsayDEN-STDDental - StandardDentalactive
BEN-0131876-4EMP-0131876Rowan A. RamsayTUITIONTuition reimbursementDevelopmentactive
BEN-0131876-0EMP-0131876Rowan A. RamsayMED-PPO-ESPPO Medical - Employee + spouseMedicalactive
BEN-0131876-3EMP-0131876Rowan A. RamsayLIFE-1XBasic life insurance (1x salary)Lifeactive
BEN-0131876-2EMP-0131876Rowan A. Ramsay401K-STD401(k) - 4% matchRetirementactive

Recent payslips (29)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0131876-0048EMP-0131876Rowan A. RamsayRUN-00482026-07-132026-07-17$3,568
PAY-0131876-0047EMP-0131876Rowan A. RamsayRUN-00472026-06-282026-07-02$3,024
PAY-0131876-0046EMP-0131876Rowan A. RamsayRUN-00462026-06-132026-06-17$3,024
PAY-0131876-0045EMP-0131876Rowan A. RamsayRUN-00452026-05-292026-06-02$3,024
PAY-0131876-0044EMP-0131876Rowan A. RamsayRUN-00442026-05-142026-05-18$3,024
PAY-0131876-0043EMP-0131876Rowan A. RamsayRUN-00432026-04-292026-05-03$3,024
PAY-0131876-0042EMP-0131876Rowan A. RamsayRUN-00422026-04-142026-04-18$3,568
PAY-0131876-0041EMP-0131876Rowan A. RamsayRUN-00412026-03-302026-04-03$3,024
PAY-0131876-0040EMP-0131876Rowan A. RamsayRUN-00402026-03-152026-03-19$3,024
PAY-0131876-0039EMP-0131876Rowan A. RamsayRUN-00392026-02-282026-03-04$3,024

See all 29