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

Hiroshi Ogawa

EMP-0013760 · Employee · projected from the master template

employee_id
EMP-0013760
seq
13,760
first_name
Hiroshi
last_name
Ogawa
middle_initial
—
full_name
Hiroshi Ogawa
work_email
hiroshi.ogawa@northline.com
work_phone
+1-347-284-8426
home_address_line1
9727 Beacon Hill Road
job_title
Sales Manager
job_code
SLS-04-0
job_family
Sales
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
HQ-BOS
location_city
Boston
location_region
Massachusetts
location_country
United States
location_country_code
US
location_timezone
America/New_York
manager_id
EMP-0003265
manager_seq
3,265
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Remote
employment_status
active
hire_date
2025-04-28
tenure_years
1.38
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1978-06-23
age
48
gender
Male
ethnicity
White
base_salary_cents
15,014,169
base_salary
$150,142
currency
USD
bonus_target_pct
12%
bonus_target
$18,017
equity_units
600
compa_ratio
0.997
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
1
location_ordinal
0
employment_status_ordinal
0
performance_rating
3
engagement_score
62
flight_risk_score
43
tenure_days
68

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0013760-0EMP-0013760Hiroshi OgawaPTOPaid time off3.70
BAL-0013760-1EMP-0013760Hiroshi OgawaSICKSick leave1.90
BAL-0013760-2EMP-0013760Hiroshi OgawaPARENTParental leave15.60
BAL-0013760-3EMP-0013760Hiroshi OgawaBEREAVBereavement leave0.90
BAL-0013760-4EMP-0013760Hiroshi OgawaJURYJury duty1.90
BAL-0013760-5EMP-0013760Hiroshi OgawaUNPAIDUnpaid leave of absence5.60
BAL-0013760-6EMP-0013760Hiroshi OgawaVOLVolunteer day0.40
BAL-0013760-7EMP-0013760Hiroshi OgawaSABSabbatical5.60

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0013760-0EMP-0013760Hiroshi OgawaMED-PPO-FAMPPO Medical - FamilyMedicalactive
BEN-0013760-1EMP-0013760Hiroshi OgawaDEN-STDDental - StandardDentalpending

Training (3)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0013760-1EMP-0013760Hiroshi OgawaPRO-410Business WritingProfessionalno
TRN-0013760-0EMP-0013760Hiroshi OgawaLDR-230Inclusive LeadershipLeadershipno
TRN-0013760-2EMP-0013760Hiroshi OgawaWEL-510Financial Wellness BasicsWellbeingno

Recent payslips (5)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0013760-0048EMP-0013760Hiroshi OgawaRUN-00482025-07-042025-07-08$10,760
PAY-0013760-0047EMP-0013760Hiroshi OgawaRUN-00472025-06-192025-06-23$6,256
PAY-0013760-0046EMP-0013760Hiroshi OgawaRUN-00462025-06-042025-06-08$6,256
PAY-0013760-0045EMP-0013760Hiroshi OgawaRUN-00452025-05-202025-05-24$6,256
PAY-0013760-0044EMP-0013760Hiroshi OgawaRUN-00442025-05-052025-05-09$6,256

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0091902SullivanSharmaSullivan A. Sharmasullivan.a.sharma@northline.comJunior Account Executive0
EMP-0091903RasmusHagenRasmus A. Hagenrasmus.a.hagen@northline.comSenior Account Executive2
EMP-0091904HiroshiSerranoHiroshi A. Serranohiroshi.a.serrano@northline.comAccount Executive1
EMP-0091905ObiGuptaObi A. Guptaobi.a.gupta@northline.comAssociate Account Executive0
EMP-0091906AnnekeSebastianAnneke A. Sebastiananneke.a.sebastian@northline.comAssociate Account Executive0
EMP-0091907CharlotteGrimaldiCharlotte A. Grimaldicharlotte.a.grimaldi@northline.comJunior Account Executive0
EMP-0091908JoannaScarboroughJoanna A. Scarboroughjoanna.a.scarborough@northline.comAccount Executive II1
EMP-0091909BernardGomesBernard A. Gomesbernard.a.gomes@northline.comAccount Executive II1
EMP-0091910CallumSantoroCallum A. Santorocallum.a.santoro@northline.comAssociate Account Executive0