https://api.airtable.com/v0/app9HaZb0Ht4KmICK/tblhTr6U3Tr2x4tZp?view=viwAl323GmKtqTy9r
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recc7qDP2hwits5oX','','','39245','Vilon Ho','Approved','2024-05-27','','Hi Rong Ji, Hazri, \r\n\r\nI had discussed with Jean to have Yue En to transfer to QA and Risk Management division under Jaime Wong to act as the Data Intelligence HC to support our business transformation.','','0','','0','','','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec4TSzlLBML5Uz4R','Design','Creative Design','30439','Albert Yong','Approved','2023-11-21','2023-11-24','Infor: Creative Service Desk, Dec 2023','','0','','0','5','5','','Creative Designer,Senior Creative Designer') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recRXwiRpbsI3bwXs','Design','Creative Design','31697','Alex Teoh','Approved','2023-12-06','2023-12-06','MNL, US hr, 5 Creative Designers, (request by Alex)','','0','','0','5','5','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rect48eal8CtBilzU','Design','Creative Design','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','GoTo, Jan 2024','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('reci6ROKd5lcBF27x','Design','Creative Design','31331','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 60 days (20%)_Dec 2023, Hire 11 HC','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec0RKJSvw2Md8Our','Design','Creative Design','31330','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 30 days (50%)_Dec 2023, Hire 29 HC','','0','','0','8','8','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recYP2hqp3sMKykzc','Design','Creative Design','32712','Ash Li Tan','Approved','2023-12-20','2023-12-22','MNL, transition customer: Northwind, Fourkites, COREHigherEd, SFE Partners and Equiteq, iSpot.','','0','','0','5','5','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recL9tkf6m1g0UKxk','Design','Creative Design','34734','Rong Ji Sai','Approved','2024-02-09','','Backfill: Xie Hui Yen, Aziq Dahlan, Geraldine Tan','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recjdU46tq7FAq3V9','Design','Creative Design','34925','Albert Yong','Approved','2024-02-16','','Backfill: Jun Yee Woon, Syahirah Aqbal','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recAebZEYVYhEQS01','Design','Creative Design','35213','Albert Yong','Approved','2024-02-22','','MNL, Infor & Bench (12) \nAPAC: Creative 7 HC, UIUX 3 HC, AMER: Creative 2 HC','','0','','0','9','9','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recbZrS5mLwTGlTHX','Design','Creative Design','36760','Rong Ji Sai','Approved','2024-03-25','','MNL, US hr, RELX - Elsevier, Design 4.5 , Content 2, MPC 2','','0','','0','5','5','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recKNILZXJUp2D2WF','Design','UI/UX Design','30439','Albert Yong','Approved','2023-11-21','2023-11-24','Infor: Creative Service Desk, Dec 2023','','0','','0','2','2','','UIUX Designer') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recqwT3pBsOcMK3Ox','Design','UI/UX Design','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','GoTo, Jan 2024','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec94m4mTNY3tMkyx','Design','UI/UX Design','35213','Albert Yong','Approved','2024-02-22','','MNL, Infor & Bench (12) \nAPAC: Creative 7 HC, UIUX 3 HC, AMER: Creative 2 HC','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recsYr1OgiytLY1H5','Design','Video Design','30439','Albert Yong','Approved','2023-11-21','2023-11-24','Infor: Creative Service Desk, Dec 2023','','0','','0','4','4','','Video Editor') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec5Z7uL1yrTaBkaM','Design','Video Design','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','GoTo, Jan 2024','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec2FEaf15AVs1VgM','Strategic Planning','Strategic Planning','30609','Vilon Ho','Approved','2023-11-23','2023-11-24','FARO','','0','','0','1','1','','Strategic Planning Manager') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recB93CXR1LF3XyzQ','Strategic Planning','Strategic Planning','31181','Vilon Ho','Approved','2023-11-30','2023-12-04','Hyland: SCM role to integrate into their Lead to Cash model by managing nurture strategy on Marketo (email)','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recDrVcLFo7ty09Ar','Strategic Planning','Strategic Planning','35061','Vilon Ho','Approved','2024-02-19','','Smart communication','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('reczNs21F4Fwue4N6','Strategic Planning','Strategic Planning','36468','Kelvin Lim','Approved','2024-03-18','','1 HC SCM, Emburse','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rectNyEFJP716pkmA','Strategic Planning','Strategic Planning','36881','Kelvin Lim','Approved','2024-03-27','','2 HC SCM, Emburse (additional)','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recP05rUVPKwWZRSn','Strategic Planning','Strategic Planning','37995','Kelvin Lim','Approved','2024-04-26','','3 HC, SCM, (Deepwatch, Multiplan, Employ, Certinia)','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec71PthK4BWlS7qM','Content','Content','30614','Jacqueline Toyad','Approved','2023-11-23','2023-11-24','Content, Infor: Creative Service Desk, Dec 2023','','0','','0','8','8','','Content Writer,Senior Content Writer,Content Specialist') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recCnggdMx6ngkUtF','Content','Content','30622','Jacqueline Toyad','Approved','2023-11-23','2023-11-24','Content','','0','','0','4','4','','Content Writer,Senior Content Writer') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('reciWwhnYlcK053ce','Content','Content','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','GoTo, Jan 2024','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recOItrI21exLFD9q','Content','Content','31331','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 60 days (20%)_Dec 2023, Hire 11 HC','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('reciD0z5scxYzSGPJ','Content','Content','31330','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 30 days (50%)_Dec 2023, Hire 29 HC','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recvA7S5LSUacqRMQ','Content','Content','32267','Justin Tan','Approved','2023-12-13','2023-12-13','DAS42 0.5','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec4MQ2VOkgTWYwUL','Content','Content','32367','Jacqueline Toyad','Approved','2023-12-14','2023-12-14','Backfill for Vikram (AI principal)','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec2Q1VnuGMBKZj8A','Content','Content','34730','Rong Ji Sai','Approved','2024-02-09','','Backfill: Charmaine Sze','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec8mHHuCwnJVK5qo','Content','Content','35452','Jacqueline Toyad','Approved','2024-02-27','','MNL, Content Ramp up hiring, no need hiring ticket for hiring','','0','','0','15','15','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recXvphfNbI7ly6DL','Content','Content','36543','Jacqueline Toyad','Approved','2024-03-19','','Content 3HC\n\nLiferay - 0.5\nSymplr - 0.5\nDevo - 0.5\nRackspace - 0.5\nProcessUnity 0.5\nJelly Vision - 0.5','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recwbPXAmUSBKt4bh','Content','Content','36545','Jacqueline Toyad','Approved','2024-03-19','','Content 1 HC','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recmcA2h1luZSyhxd','Content','Content','36760 copy','Rong Ji Sai','Approved','2024-03-25','','MNL, US hr, RELX - Elsevier, Design 4.5 , Content 2, MPC 2','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec5imJpslKXnypWH','Content','Content','36819','Jacqueline Toyad','Approved','2024-03-26','','1 HC Content, GoTo.','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recJhTsTVaUR8e93N','Content','Content','37169','Jacqueline Toyad','Approved','2024-04-03','','2 HC Content, Emburse','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recXrZPsfoF7RGY60','Campaigns','SEM','30705','Chloe Sia Rui Xin','Approved','2023-11-24','2023-11-24','Campaigns','','0','','0','2','2','','Performance Marketing Manager ,Performance Marketing Specialist') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recSAsUGsGFW34cnZ','Campaigns','SEM','34101','Chloe Sia Rui Xin','Approved','2024-01-23','','Backfill - SEM, Xin Ying Lim','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recjNJpaze9JnTysr','Campaigns','SEO','30705','Chloe Sia Rui Xin','Approved','2023-11-24','2023-11-24','Campaigns','','0','','0','3','3','','SEO Specialist,SEO Manager') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec45DVBT2N1v13l5','Campaigns','SEO','34733','Rong Ji Sai','Approved','2024-02-09','','Backfill: Kent Lee (L3)','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec4OdwLhwntCjnXe','Campaigns','Digital Campaigns','30705','Chloe Sia Rui Xin','Approved','2023-11-24','2023-11-24','Campaigns','','0','','0','5','5','','Digital Campaign Specialist') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec4GgPgTj8gXquMd','Campaigns','Digital Campaigns','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','GoTo, Jan 2024','','0','','0','4','4','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recE6tVX0hHctcTDV','Campaigns','Digital Campaigns','31331','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 60 days (20%)_Dec 2023, Hire 11 HC','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recLW2gDUat17lgiq','Campaigns','Digital Campaigns','31330','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 30 days (50%)_Dec 2023, Hire 29 HC','','0','','0','4','4','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec1ja1jl2HoThcJk','Campaigns','Digital Campaigns','34101','Chloe Sia Rui Xin','Approved','2024-01-23','','Backfill - Campaigns -Farees Faizal, Jee Teng Siow','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recsKRhY57aXPaOGF','Campaigns','Digital Campaigns','35384','Jeremy Loh','Approved','2024-02-26','','MNL, US hr, affiliate marketing- GoTo','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recN56eUsfaSg7xEa','Governance','Governance','30763','Siew Mee Yong','Approved','2023-11-27','2023-11-27','Gov','','0','','0','4','4','','Client Delivery Director ,Client Delivery Associate Director') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recbN6gQ7k7X1cTh9','Governance','Governance','31297','Rong Ji Sai','Approved','2023-12-01','2023-12-01','Infor: Campaign Service Desk, Jan 204','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rectLQOewdconahJw','Governance','Governance','31331','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 60 days (20%)_Dec 2023, Hire 11 HC','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec8KIaC4iXn0ZK7L','Governance','Governance','31330','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 30 days (50%)_Dec 2023, Hire 29 HC','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec1dSmhdatT9VG4h','Governance','Governance','34751','Balqis Osman','Approved','2024-02-09','','Intern, Gov','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec9G0H6a51RBUfwV','Governance','Governance','34752','Rong Ji Sai','Approved','2024-02-09','','Backfill: Yan Teh, Daphne Cheah, Therine Goh','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recRnwjdg0utyWbCu','Marketing Ops','Developer','31000 copy','Zi Yan Tung','Approved','2023-11-28','2023-11-28','7 MarOps and 1 Developer','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recJE29LHfVE2sKbE','Marketing Ops','Developer','31180','Zi Yan Tung','Approved','2023-11-30','2023-11-30','Faro + WK, 1 Sitecore Developer','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec80AU7BhVwfNG8W','Marketing Ops','Developer','34104','Zi Yan Tung','Approved','2024-01-23','','Backfill:\nDev: \n- Wong Kin Ming - Jan 17, Wed','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recSfLYsEBuydtxdB','Marketing Ops','Developer','37819','Zi Yan Tung','Approved','2024-04-22','','MNL, US hr, 2 HC Dev (AEM Dev)\n1 x AEM Front-end Developer\n1 x AEM Backend Developer','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recakmeHsYQcK8rO6','Marketing Ops','Marketing Ops','31000','Zi Yan Tung','Approved','2023-11-28','2023-11-28','7 MarOps and 1 Developer','','0','','0','7','7','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recDg1el1lafrBnzx','Marketing Ops','Marketing Ops','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','GoTo, Jan 2024','','0','','0','4','4','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recnGFUpPe5m7yHKl','Marketing Ops','Marketing Ops','31331','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 60 days (20%)_Dec 2023, Hire 11 HC','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('reckSYebd5b1c3AlB','Marketing Ops','Marketing Ops','31330','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 30 days (50%)_Dec 2023, Hire 29 HC','','0','','0','9','9','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recGiCvLVkcFFnfCS','Marketing Ops','Marketing Ops','32279','Michelle Liew','Approved','2023-12-13','2023-12-14','MNL, US hr, Marketing Ops 1 HC','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recIBcRj2n1BkMxhu','Marketing Ops','Marketing Ops','32772','Michelle Liew','Approved','2023-12-21','2023-12-22','MNL, 1 HC E-commerce Manager','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recK0w98mvDAR2NPh','Marketing Ops','Marketing Ops','34104','Zi Yan Tung','Approved','2024-01-23','','Backfill\nMarOps:\n- Elni Fatieny - April 12, Fri\n- Najwa Yahya - April 2, Tue\n- Kevyn Lee - Feb 28, Wed\n- Yew Weng Cheng - Feb 28, Wed','','0','','0','4','4','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recOYJMW64S1CgeuK','Marketing Ops','Marketing Ops','34655','Zi Yan Tung','Approved','2024-02-07','','MNL, 2 HC Mar Ops- GoTo.\n\n1) Email Marketing Manager - Marketo, Pendo\n2) Marketing Operations Manager - Pendo Admin','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recLLaluLcVgKMuJi','Marketing Ops','Marketing Ops','37878','Zi Yan Tung','Approved','2024-04-23','','3 HC, Sr Mar Ops Mgr (Architect), Eloqua','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rect9aVCYyBPbsd2K','Coordinator','Coordinator','31280','Zachary Joseph','Approved','2023-12-01','2023-12-01','6sense EMEA Onboarding','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recPsJC75pldGbyny','Coordinator','Coordinator','31745','Alex Teoh','Approved','2023-12-06','2023-12-06','MNL, US hr, 7/8 MPC, bench (request by Alex)','','0','','0','6','6','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recRglCpdc4gsdSCV','Coordinator','Coordinator','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec8LuszKJhwcN0DB','Coordinator','Coordinator','31331','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 60 days (20%)_Dec 2023, Hire 11 HC','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recDJFTSKxLzXqdyO','Coordinator','Coordinator','31330','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 30 days (50%)_Dec 2023, Hire 29 HC','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recf1mPrOU9Xy8A1D','Coordinator','Coordinator','33476','Ash Li Tan','Approved','2024-01-09','2024-01-10','MNL, US hr, 6sense onboarding specialist.','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec1cnibBOxh91Ijp','Coordinator','Coordinator','33623','Zachary Joseph','Approved','2024-01-12','2024-01-16','3 FTEs for Infor\r\nNew Email Campaign Service Desk (1 or possible 2 FTE)\r\nNicholas Yow additional resource (1 FTE)\r\n\r\n\r\nGoTo (Urgent)\r\n1 FTE - possibly placing Victor Lai new joiner here. Pending buyout and offer acceptance\r\n\r\nAv-Ovo (coming in fast)\r\n0.3 FTE or 0.5 FTE\r\nLink to ticket: https://spark.2x.marketing/request-summary.php?id=1122\r\n\r\nTLF (replace exiting resource Governance become MPC) (End Feb)\r\n0.3 or 0.5 FTE\r\nLink to ticket: https://spark.2x.marketing/request-summary.php?id=1043\r\n\r\nQlik (mid Feb)\r\nSharepoint Migration (0.5FTE)\r\nPO Process Admin (FTE)\r\nPO Process Admin (0.5 FTE)\r\nLink to ticket: https://spark.2x.marketing/request-summary.php?id=1157\r\n\r\nPhoenix (KIV Farhan Azman)\r\nShared service 125 hours per month\r\nLink to tickt: https://spark.2x.marketing/request-summary.php?id=1174\r\n\r\n6sense EMEA (Feb or March) -\r\n1 FTE or 2 FTE. No promising cdds yet\r\nAlready requested in WFM\r\n\r\nSandler\r\n0.5FTE social media - to replace existing resource\r\nLink to ticket: N/A\r\n\r\nSAP (Feb)\r\n1 FTE - to replace existing resource\r\nLink to ticket: N/A\r\n\r\nFARO (Feb or March)\r\n1 FTE - to replace existing resource\r\nLink to ticket: N/A\r\n\r\nCellebrite (Feb or March)\r\n1 FTE - to add on\r\nLink to ticket: N/A\r\n\r\nTotal = 11.5 FTEs (12 FTEs)','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recPt5j0yNm4KnyOt','Coordinator','Coordinator','34650','Zachary Joseph','Approved','2024-02-07','','Backfill, 3 HC Coordinator. Temara Inigo, Tejas Menon, Adli Wahab','','0','','0','3','3','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recUf5rxejYYdYGWK','Coordinator','Coordinator','35273','Zachary Joseph','Approved','2024-02-23','','MNL, US hr, MPC, Budget Admin- GoTo','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recTXxPKmNYmXvvkF','Coordinator','Coordinator','35746','Zachary Joseph','Approved','2024-03-05','','MNL, US hr, MPC, Event Program Manager-GoTo','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recvbiRque2vNjrA0','Coordinator','Coordinator','35865','Zachary Joseph','Approved','2024-03-06','','MNL, US hr, Emburse.\n1) Organic Social Media Manager\n2) Sales Enablement Manager','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec2Wu2WuTsloK1vz','Coordinator','Coordinator','36760 copy copy','Rong Ji Sai','Approved','2024-03-25','','MNL, US hr, RELX - Elsevier, Design 4.5 , Content 2, MPC 2','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recji0vJ9c9h8rM9e','Coordinator','Coordinator','38266','Zachary Joseph','Approved','2024-05-03','','MNL, US hr, Anaplan 1 Senior Web PM, 1 Junior Web PM','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec8LOQaiddAEopVX','Analytics','Analytics','31297','Rong Ji Sai','Approved','2023-12-01','2023-12-01','Infor: Campaign Service Desk, Jan 204','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recR1dHRJfSWI8wFH','Analytics','Analytics','31330','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 30 days (50%)_Dec 2023, Hire 29 HC','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recZl8i8wQoabFdmI','Analytics','Analytics','31331','Rong Ji Sai','Approved','2023-12-02','2023-12-02','Proactive Hiring: Pipeline 60 days (20%)_Dec 2023, Hire 11 HC','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recCLm2oNLs2otSS4','Analytics','Analytics','31886','Michelle Liew','Approved','2023-12-07','2023-12-07','GoTo, Jan 2024','','0','','0','6','6','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec9yfLIVWI7HZ2WM','Analytics','Analytics','32301','Jean Wei Shum','Approved','2023-12-13','2023-12-13','1. Required 1 Senior Analyst\r\n\r\n*Note this is not a client swap request, it is a swap request for an L4 to handle what Jean is doing now.','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recmDihENLwxHtot1','Analytics','Analytics','32435','Farzana Faizal','Approved','2023-12-15','2023-12-15','4 resources','','0','','0','4','4','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recrO0oUiwZbDumtp','Analytics','Analytics','33710','Ash Li Tan','Approved','2024-01-15','2024-01-19','MNL, US hr, 2 HC Analyst','','0','','0','2','2','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recDboVrABSnVKsFr','Analytics','Analytics','34732','Farzana Faizal','Approved','2024-02-09','','Backfill: Wafiy Wizan, Nashruddin Yusoff, Adam Harith, Habibullah Faizal','','0','','0','4','4','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rece1IBzeEPnQucXy','Finance','Finance','34418','Jasmine Wong','Approved','2024-02-01','','1 HC Finance','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recOtU95r2b0cD89S','3X','3X','34494','Jennifer Wang','Approved','2024-02-04','','3X, based US, 1 HC Customer Marketing Manager','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recymj7nn9ikxOnOD','HR','HRSS','34508','Rihan Kumar','Approved','2024-02-05','','Please refer to approval email as attached','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('reckv061DmeSXHMic','HR','Recruitment','36163','Ili Zahani','Approved','2024-03-12','','HR, Recruitment, 1 HC','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec4NlwwdRmUkqHme','HR','HR Ops','37369','Rhitu Menon','Approved','2024-04-08','','Backfill: Rajsimran\'s','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recMp4WTnAs96peyY','WFM','WFM','35572','Rong Ji Sai','Approved','2024-03-01','','2 HC WFM Associate (L1) & 2 HC WFM Specialist (L3)','','0','','0','4','4','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('rec03SR4AVTws4g3o','6sense','6sense','35261','Keith Robert','Approved','2024-02-23','','support the 6sense Health Check Assessments:\n\n0.25 FTE Data Analyst\n0.25 FTE Digital Campaigns/Ads\n0.25 FTE Mar Ops\n0.25 FTE MPC - Coordination work\n0.25 FTE Strategist (this role is similar to what Will Waugh is doing)','','0','','0','','','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)
INSERT INTO hc_demand (_airtableID,_family,_category,_wiseID,_requester,_stage,_requestDate,_approvedDate,_remarks,_externalHiredNames,_externalHiredHC,_internalFilledNames,_internalFilledHC,_requestedHC,_externalHC,_internalHC,_jobRoles) VALUES ('recCHzGRiqR2U8fcS','6sense','6sense','37440','Keith Robert','Approved','2024-04-09','','New Role: Partner Service Program Manager','','0','','0','1','1','','') ON DUPLICATE KEY UPDATE _family = VALUES(_family),_category = VALUES(_category),_wiseID = VALUES(_wiseID),_requester = VALUES(_requester),_stage = VALUES(_stage),_requestDate = VALUES(_requestDate),_approvedDate = VALUES(_approvedDate),_remarks = VALUES(_remarks),_externalHiredNames = VALUES(_externalHiredNames),_externalHiredHC = VALUES(_externalHiredHC),_internalFilledNames = VALUES(_internalFilledNames),_internalFilledHC = VALUES(_internalFilledHC),_requestedHC = VALUES(_requestedHC),_externalHC = VALUES(_externalHC),_internalHC = VALUES(_internalHC),_jobRoles = VALUES(_jobRoles)