HR Safe Space
Endpoints / ember-pier-3541 / employees / EMP-0020073

Rafael Prescott

EMP-0020073 · Employee · projected from the master template

employee_id
EMP-0020073
seq
20,073
first_name
Rafael
last_name
Prescott
middle_initial
full_name
Rafael Prescott
work_email
rafael.prescott@northline.com
work_phone
+1-220-273-7351
home_address_line1
181 Hollybrook Drive
job_title
Manager, Marketing
job_code
MKT-04-1
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-RDU
location_city
Raleigh
location_region
North Carolina
location_country
United States
location_country_code
US
location_timezone
America/New_York
manager_id
EMP-0004528
manager_seq
4,528
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Remote
employment_status
active
hire_date
2025-05-30
tenure_years
1.29
termination_date
termination_reason
termination_voluntary
leave_type
date_of_birth
1974-02-09
age
52
gender
Male
ethnicity
White
base_salary_cents
10,514,164
base_salary
$105,142
currency
USD
bonus_target_pct
12%
bonus_target
$12,617
equity_units
600
compa_ratio
0.903
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
5
location_ordinal
8
employment_status_ordinal
0
performance_rating
5
engagement_score
89
flight_risk_score
72
tenure_days
36

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0020073-0EMP-0020073Rafael PrescottPTOPaid time off20
BAL-0020073-1EMP-0020073Rafael PrescottSICKSick leave10
BAL-0020073-2EMP-0020073Rafael PrescottPARENTParental leave8.30
BAL-0020073-3EMP-0020073Rafael PrescottBEREAVBereavement leave0.50
BAL-0020073-4EMP-0020073Rafael PrescottJURYJury duty10
BAL-0020073-5EMP-0020073Rafael PrescottUNPAIDUnpaid leave of absence30
BAL-0020073-6EMP-0020073Rafael PrescottVOLVolunteer day0.20
BAL-0020073-7EMP-0020073Rafael PrescottSABSabbatical30

Recent payslips (3)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0020073-0048EMP-0020073Rafael PrescottRUN-00482025-07-042025-07-08$7,535
PAY-0020073-0047EMP-0020073Rafael PrescottRUN-00472025-06-192025-06-23$4,381
PAY-0020073-0046EMP-0020073Rafael PrescottRUN-00462025-06-042025-06-08$4,381

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0148720ShreyaTremblayShreya A. Tremblayshreya.a.tremblay@northline.comAssociate Marketing Specialist0
EMP-0148721AmirKhanAmir A. Khanamir.a.khan@northline.comAssociate Marketing Specialist0
EMP-0148722OmarTikhonovOmar A. Tikhonovomar.a.tikhonov@northline.comJunior Marketing Specialist0
EMP-0148723JocelynKaurJocelyn A. Kaurjocelyn.a.kaur@northline.comPrincipal Marketing Specialist3
EMP-0148724EliasThackerayElias A. Thackerayelias.a.thackeray@northline.comStaff Marketing Specialist3
EMP-0148725PatrickKaminskiPatrick A. Kaminskipatrick.a.kaminski@northline.comJunior Marketing Specialist0
EMP-0148726RussellTanakaRussell A. Tanakarussell.a.tanaka@northline.comJunior Marketing Specialist0
EMP-0148727ReginaldJoshiReginald A. Joshireginald.a.joshi@northline.comJunior Marketing Specialist0
EMP-0148728EloiseSzaboEloise A. Szaboeloise.a.szabo@northline.comAssociate Marketing Specialist0