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

Lorraine Mercado

EMP-0025075 · Employee · projected from the master template

employee_id
EMP-0025075
seq
25,075
first_name
Lorraine
last_name
Mercado
middle_initial
—
full_name
Lorraine Mercado
work_email
lorraine.mercado@northline.com
work_phone
+1-731-244-4438
home_address_line1
4138 Juniper Circle
job_title
Manager, Engineering
job_code
ENG-04-1
job_family
Engineering
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
ENG
department_name
Engineering
department_function
Technology
cost_center
CC-1000
location_code
CA-TOR
location_city
Toronto
location_region
Ontario
location_country
Canada
location_country_code
CA
location_timezone
America/Toronto
manager_id
EMP-0005528
manager_seq
5,528
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Remote
employment_status
active
hire_date
2025-05-28
tenure_years
1.3
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1975-06-11
age
51
gender
Female
ethnicity
White
base_salary_cents
14,249,095
base_salary
$142,491
currency
CAD
bonus_target_pct
12%
bonus_target
$17,099
equity_units
600
compa_ratio
0.928
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
0
location_ordinal
10
employment_status_ordinal
0
performance_rating
3
engagement_score
20
flight_risk_score
3
tenure_days
38

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0025075-0EMP-0025075Lorraine MercadoPTOPaid time off2.10
BAL-0025075-1EMP-0025075Lorraine MercadoSICKSick leave10
BAL-0025075-2EMP-0025075Lorraine MercadoPARENTParental leave8.70
BAL-0025075-3EMP-0025075Lorraine MercadoBEREAVBereavement leave0.50
BAL-0025075-4EMP-0025075Lorraine MercadoJURYJury duty10
BAL-0025075-5EMP-0025075Lorraine MercadoUNPAIDUnpaid leave of absence3.10
BAL-0025075-6EMP-0025075Lorraine MercadoVOLVolunteer day0.20
BAL-0025075-7EMP-0025075Lorraine MercadoSABSabbatical3.10

Training (4)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0025075-3EMP-0025075Lorraine MercadoLDR-210Coaching for PerformanceLeadershipno
TRN-0025075-0EMP-0025075Lorraine MercadoTEC-301Cloud Architecture FoundationsTechnicalno
TRN-0025075-1EMP-0025075Lorraine MercadoPRO-430Presentation SkillsProfessionalno
TRN-0025075-2EMP-0025075Lorraine MercadoCMP-110Anti-Harassment & Respectful WorkplaceComplianceyes

Recent payslips (3)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0025075-0048EMP-0025075Lorraine MercadoRUN-00482025-07-042025-07-08$10,212
PAY-0025075-0047EMP-0025075Lorraine MercadoRUN-00472025-06-192025-06-23$5,937
PAY-0025075-0046EMP-0025075Lorraine MercadoRUN-00462025-06-042025-06-08$5,937

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0193739RosaAdeyemiRosa B. Adeyemirosa.b.adeyemi@northline.comSoftware Engineer1
EMP-0193740EmikoMercadoEmiko B. Mercadoemiko.b.mercado@northline.comJunior Software Engineer0
EMP-0193741PietZielinskiPiet B. Zielinskipiet.b.zielinski@northline.comAssociate Software Engineer0
EMP-0193742SigridMcgregorSigrid B. Mcgregorsigrid.b.mcgregor@northline.comSoftware Engineer II1
EMP-0193743WalterZapataWalter B. Zapatawalter.b.zapata@northline.comPrincipal Software Engineer3
EMP-0193744XavierMatsudaXavier B. Matsudaxavier.b.matsuda@northline.comSenior Software Engineer2
EMP-0193745IlanaYildizIlana B. Yildizilana.b.yildiz@northline.comSoftware Engineer1
EMP-0193746WyattMarsdenWyatt B. Marsdenwyatt.b.marsden@northline.comSenior Software Engineer II2
EMP-0193747HanaYamadaHana B. Yamadahana.b.yamada@northline.comJunior Software Engineer0