-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathspm_db.sql
3672 lines (3654 loc) · 310 KB
/
spm_db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- create spm_db DB
drop schema if exists spm_db;
create schema spm_db;
use spm_db;
-- Table structure for table `access_control`
-- DROP TABLE IF EXISTS `access_control`;
-- CREATE TABLE IF NOT EXISTS `access_control` (
-- `Access_ID` int NOT NULL,
-- `Access_Control_Name` varchar(20) NOT NULL,
-- PRIMARY KEY (`Access_ID`)
-- );
-- Table structure for table `role`
DROP TABLE IF EXISTS `role`;
CREATE TABLE IF NOT EXISTS `role` (
`Role_Name` varchar(20) NOT NULL,
`Role_Desc` longtext NOT NULL,
PRIMARY KEY (`Role_Name`)
);
-- insert data into role
INSERT INTO `role` VALUES('Account Manager', 'The Account Manager acts as a key point of contact between an organisation and its clients. He/She possesses thorough product knowledge and oversees product and/or service sales. He works with customers to identify their wants and prepares reports by collecting, analysing, and summarising sales information. He contacts existing customers to discuss and give recommendations on how specific products or services can meet their needs. He maintains customer relationships to strategically place new products and drive sales for long-term growth. He works in a fast-paced and dynamic environment, and travels frequently to clients'' premises for meetings. He is familiar with client relationship management and sales tools. He is knowledgeable of the organisation''s products and services, as well as trends, developments and challenges of the industry domain. The Sales Account Manager is a resourceful, people-focused and persistent individual, who takes rejection as a personal challenge to succeed when given opportunity. He appreciates the value of long lasting relationships and prioritises efforts to build trust with existing and potential customers. He exhibits good listening skills and is able to establish rapport with customers and team members alike easily.');
INSERT INTO `role` VALUES('Admin Executive', 'Admin Executive will act as the point of contact for all employees, providing administrative support and managing their queries. Main duties include managing office stock, preparing regular reports (e.g. expenses and office budgets) and organizing company records. If you have previous experience as an Office Administratoror similar administrative role, we''d like to meet you. ');
INSERT INTO `role` VALUES('Call Centre', 'Call Centre Executive is responsible for providing assistance to customers by addressing their queries and requests. He/She advises customers on appropriate products and services based on their needs. He is responsible for the preparation of customer documentation. In the case of complex customer requests, he escalates them to senior officers. He is able to abide by safety and/or security standards in the workplace.\r\n\r\nThe Call Centre Executive pays strong attention to details to verify and process documentation. He also shows initiative and quick decision-making skills to provide excellent personalised customer services and support. He is comfortable with various stakeholder interactions whilst working in shifts and possesses adequate computer literacy to process customer documentation. ');
INSERT INTO `role` VALUES('Consultancy Director', 'The Director defines and articulates the organisation''s strategy for securing technical wins with prospective clients. He/She focuses on developing key growth strategies, tactics and action plans required to achieve revenue and/or sales targets. He advises the team on developing prototypes to ensure feasibility of solutions, and oversees the delivery of in-depth presentations and product demonstrations to clients. He solves complex problems and evaluates clients needs with different perspectives. He works in a fast-paced and dynamic environment, and travels frequently to clients'' premises for technical sales pitches and meetings. He is familiar with client relationship management and sales tools. He possesses deep product and technical knowledge, and is knowledgeable of the trends, developments and challenges of the industry domain. The Director is target-driven and client centric, and has the ability to foster collaboration between stakeholders. He has a deep understanding of key business industries and knowledge of products and services in the market. He is strongly committed to developing talent and inspires his team members to pursue a common vision.');
INSERT INTO `role` VALUES('Consultant', 'The Consultant is responsible for providing Sales technical expertise to the sales team and clients during the sales process. He/She delivers presentations and technical demonstrations of the organisation''s products to prospective clients. He translates the client''s business requirements into technical specifications and requirements, and provides technical inputs for proposals, tenders, bids and any relevant documents. He uses prescribed guidelines or policies to analyse and solve problems. He works in a fast-paced and dynamic environment, and travels frequently to clients'' premises for technical sales pitches and meetings. He is familiar with client relationship management and sales tools. He possesses deep product and technical knowledge, and is knowledgeable of the trends, developments and challenges of the industry domain. The Sakes Consultant displays effective listening skills and is inquisitive in nature. He possesses deep technical and domain knowledge, pays attention to detail, and has strong analytical and problem-solving capabilities. He has a service-oriented personality and is a team player who works towards developing solutions collaboratively.');
INSERT INTO `role` VALUES('Developer', 'The Developer leads important projects and possesses capability to make breakthroughs in design, development, testing, debugging and implementing software applications or specialised utility programs in support of end users'' needs on platforms. He/She plans and coordinates regular updates and recommends improvements to existing applications. He identifies and resolves issues which have organisation wide and long-term impact. He identifies security risks, creates requirements to capture security issues, and performs initial threat modelling to ensure coding standards meets security requirements. He develops and maintains the software configuration management plan and oversees the building, verification and implementation of software releases. He provides guidance and technical support to the quality testing teams. He works in a team setting and is proficient in programming languages required by the organisation. He is familiar with software development tools and standards, as well as the relevant software platforms on which the solution is deployed on. The Developer is imaginative and creative in exploring a range of application designs and solutions. He is able to engage and support others in the team, readily put forth his ideas in a clear and compelling manner.');
INSERT INTO `role` VALUES('Engineering Director', 'The Engineering Director is responsible for spearheading the strategic planning, design and implementation of complex engineering solutions to meet customers requirements. He/She drives direction and strategy for the development and execution of engineering projects, and ensures alignment to the organisational strategy, vision and mission. He formulates strategies and frameworks to drive workplace health, safety, risk and environmental management in accordance with local and international regulations. He develops the organisations technology roadmap and drives continuous improvement strategies. In addition, he leverages his deep technical expertise and industry experience to develop technical capabilities and domain expertise for the organisation. He is a professional engineer, specialising in mechanical, electrical, control and instrumentation, civil, structural or geotechnical engineering disciplines.\r\n\r\nHe is the organisations technical expert who advises senior management and business partners on complex engineering matters. He maintains and builds strong links with the external engineering community and establishes best practises in the implementation of engineering standards and design. He is a strategic and creative thinker, demonstrates exceptional leadership and problem-solving skills, and establishes strategic partnerships.');
INSERT INTO `role` VALUES('Finance Executive', 'The Finance Executive supports the finance department in carrying out the responsibilities of the accounting department. He/She is involved in work that is specific to accounts receivable, accounts payable, tax filing, data compilation, billing, payroll or other accounting tasks. In some instances, he may work specifically with accruals, fixed assets accounting or the monthly and yearly finalisation of accounts for audit purposes. The Accounts Executive/Accounts Assistant may also assist with the preparation of trial balance, basic financial statements and simple consolidated financial statements. He may be called on to participate in ad-hoc finance-related projects and systems testing when necessary.');
INSERT INTO `role` VALUES('Finance Director', 'The Finance Director is the business partner for all the business units in an organisation. He/She serves as the organisations go-to person for all matters related to accounting. He provides technical accounting advice to various stakeholders to maximise organisation''s value and minimise risks in accordance with external and internal accounting guidance. The Business Controller/Finance Director demonstrates excellent people skills to facilitate the on-going business relationships and find new business opportunities. He also play a critical role in financial planning and analysis supporting key management decisions which includes involvement in providing operational risk management support to the business and ensuring proper business performance management through profitability and operational analysis. In addition, he is involved in recruitment, performance management, appraisal and identifying training and development needs for the business units in an organisation.');
INSERT INTO `role` VALUES('Finance Manager', 'The Finance Manager is the lead finance business partner for the organisation and has responsibilities covering all aspects of financial management, performance management, financial accounting, budgeting, corporate reporting etc. He/she has sound technical as well as management skills and be able to lead a team consisting of finance professionals with varied, in-depth or niche technical knowledge and abilities; consolidating their work and ensuring its quality and accuracy, especially for reporting purposes. The Finance Manager is expected to provide sound financial advice and counsel on working capital, financing or the financial position of the organisation by synthesising internal and external data and studying the economic environment. He often has a key role in implementing best practices in order to identify and manage all financial and business risks and to meet the organisation''s desired business and fiscal goals. He is expected to have a firm grasp of economic and business trends and to implement work improvement projects that are geared towards quality, compliance and efficiency in finance.');
INSERT INTO `role` VALUES('HR Director', 'TheHR Director is responsible for establishing the overall talent management strategies and frameworks to identify, prepare and position the right talent to drive organisational success. He/She formulates career development frameworks and programmes to provide fulfilling career opportunities to employees in the organisation. He liaises with senior business stakeholders to formulate robust succession plans for business-critical roles in the organisation, ensuring future viability and alignment with business plans and direction. He is responsible for establishing retirement and exit policies and guidelines, and evaluating the business impact of redundancy, retirement and exit decisions. He also guides and advises senior business leaders in the management and communication of sensitive talent decisions. As a department head, he is responsible for setting the direction and articulating goals and objectives for the team, and driving the integration of Skills Frameworks across the organisation''s talent management plans.\r\n\r\nThe HR Director is a forward-thinking and influential leader who is able to integrate knowledge across diverse domains to make robust decisions and address multi-faceted issues effectively. He has the desire to motivate employees and develop talent capabilities both within the team and across the organisation, and demonstrates sensitivity and diplomacy when interacting with stakeholders at various levels.');
INSERT INTO `role` VALUES('HR Executive', 'HR Team executes planned talent outreach and engagement activities to source for potential candidates and maintains an optimal experience for employees. He/She conducts the initial screening of potential candidates, administers assessments and prepares employment contracts as per guidelines. He tracks the conversion success rate for each sourcing channel and provides administrative and logistical support during onboarding. He administers employee engagement surveys and collates responses and feedback while ensuring confidentiality of information provided.\r\n\r\nHR Team Executive enjoys working in a team environment and interacts proactively with various stakeholders. He has a service-oriented mindset and can adapt to various forms of technology within his work space to enhance his work. ');
INSERT INTO `role` VALUES('IT Analyst', 'IT Analyst performs routine infrastructure operations and maintenance activities. He/She assists with monitoring infrastructure performance. He checks for problems in existing systems and modifies work processes by following defined procedures, processes and quality standards. He is required to be on standby with on-call availability with varied shifts including nights, weekends and holidays. He works in a team setting and is proficient in infrastructure systems and network-related tools and techniques required by the organisation. He is also familiar with the relevant software platforms on which the database is deployed. The Associate Infrastructure Support Engineer is able to solve issues quickly and effectively as they arise. He is able to methodically identify the cause of the issue, evaluate it and develop a solution in collaboration with the team. He is able to communicate effectively and displays high service level standards.');
INSERT INTO `role` VALUES('IT Director', 'The IT Director drives the vision and strategy for the IT Operations and Support functions. He/She sets the direction for systems and database administration, day-to-day IT support and operations, data centre operations and system and quality assurance through the delivery of services as per business requirements; controls costs and manages vendors. He is responsible for formulating strategies for service level agreements. He ensures compliance with organisation''s quality standards, international standards and government regulations. He is a leader with the energy and commitment to drive large teams toward achieving service level excellence. He is familiar with enterprise architecture frameworks, database administration and systems, and application monitoring tools. The Head of Operations and Support has a broad sense of perspective with the ability to influence key internal and external stakeholders. He is strategic in his approach to managing resources and developing capabilities within the team. He is effective in setting direction aligned to the strategic positioning of the business and the IT functions overall. He is able to impress upon the team the need to continuously improve service levels and increase efficiencies.');
INSERT INTO `role` VALUES('Junior Engineer', 'The Junior Engineerapplies engineering principles and techniques to optimise the equipment and systems within the manufacturing facility. He/She provides technical guidance and direction for the installation of equipment and systems. He develops plans for the maintenance of equipment and systems, and recommends engineering solutions to troubleshoot faults. The Junior Engineerinnovates equipment and systems, and contributes to manufacturing equipment and systems improvement projects by conducting feasibility assessments and tests on new technologies. He is also expected to manage energy resources and utilities by developing solutions to optimise machine availability and energy efficiency. The Junior Engineermust ensure compliance with Standard Operating Procedures (SOPs), Health, Safety and Environment (HSE) regulations and Current Good Manufacturing Practices (CGMPs) within his purview. He develops guidelines and conducts equipment qualification and validation in line with biopharmaceuticals manufacturing regulatory requirements. \r\n\r\nThe Junior Engineershould possess an enquiring and analytical mind and have a knack for investigating issues, analysing multifaceted engineering problems and developing solutions. He must also be a strong team player who can guide and mentor others, and communicate technical advices and solutions to colleagues beyond the team.');
INSERT INTO `role` VALUES('L&D Executuve', 'The L&D Executive assists in procuring training programmes and documenting learning needs in the \r\norganisation, maintaining organisations'' learning systems and provides administrative support in conducting learning programmes. He/She manages resources and logistics for delivering learning programmes and collects data from learning evaluation surveys to measure learning programmes effectiveness. He supports the conduct of assessments to identify high-potential talent in the organisation, and documents assessment records and succession plans for critical roles identified. He also responds to employee queries that are related to assessments and learning programmes. He is responsible for maintaining exit and retirement records.\r\n\r\nTheL&D Executive enjoys working in a team environment and interacts proactively with various stakeholders. He is eager to explore and analyse problems, and is able to communicate information in a clear and concise manner to meet others'' needs at the workplace.');
INSERT INTO `role` VALUES('Ops Planning Exec', 'The Operation Planning Executive upports plant operations by coordinating day-to-day production activities, as well as maintenance and turnaround schedules and activities, for production shift teams, so as to meet production plans and schedules.');
INSERT INTO `role` VALUES('Sales Director', 'The Sales Director determines sales targets, markets and product offering. He/She focuses on revenue target setting accountability, sales strategy and career development of others, liaising with professional staff and other managers on the medium- to long-term sales planning. He develops, communicates and implements the operational strategy, regularly leads important sales initiatives and has ultimate accountability for the sales function. He oversees the preparation and presentation of technical proposals and ensures that the complete plans are feasible within cost, time, and environmental constraints. He drives product differentiation and optimises the use of resources, evaluates partnership effectiveness, and advises on corrective action. He solves complex problems and adopts new perspectives to drive sales. He works in a fast-paced and dynamic environment, and travels to clients'' premises for sales pitches and negotiations. He is familiar with client relationship management and sales tools, as well as sales operations and business practices. He knowledgeable of the trends, developments and challenges of the industry domain. The Sales Director is creative and self-motivated, and is dedicated to growing the business. He contributes his expertise to product development and brainstorming of marketing campaigns, as needed. He is a competent decision maker who exhibits flexibility amidst a rapidly changing environment. He strives to train talent and build successful teams.');
INSERT INTO `role` VALUES('Sales Manager', 'The Sales Manager is responsible for managing the organisation''s sales growth. By analysing client segmentation and competitor landscape, he/she develops sales strategies. He supports lead generation, and conducts business and contract negotiations to increase client acquisition and boost retention. \r\n\r\nInnovative and resourceful, he demonstrates initiative in identifying new opportunities both locally and regionally and converting them into actual sales. He builds good rapport with new and existing clients by pro-actively anticipating clients'' needs and identifying business solutions to meet those needs. He networks extensively outside of the office to stay in close contact with the key industry stakeholders.');
INSERT INTO `role` VALUES('Senior Engineer', 'The Senior Engineer applies advanced engineering principles and techniques to troubleshoot complex engineering problems encountered within the manufacturing facility and provides expert technical advice to guide the installation and maintenance of equipment and systems. He/She is expected to lead the technical cross-collaboration with the Process Development/Manufacturing Science and Technology (PD/MSAT) department in order to identify appropriate biopharmaceuticals manufacturing equipment and optimise their functionalities. The Senior Engineer leads manufacturing equipment and systems innovation projects by guiding feasibility assessments and tests on new technologies. He is expected to review and approve solutions and initiatives to optimise machine availability while managing energy and utility use. He sets parameters for equipment qualification and validation in line with biopharmaceuticals manufacturing regulatory requirements. The Principal/Engineer must ensure compliance with Standard Operating Procedures (SOPs), Health, Safety and Environment (HSE) regulations and Current Good Manufacturing Practices (CGMPs) within his purview.\r\n\r\nThe Engineering and Maintenance Principal/Engineer carries the responsibility of the in-house technical expert. He should possess a deep passion for analysing and resolving multifaceted engineering problems and be able to apply advanced critical and analytical thinking skills to deal with immediate situations. He should have a developmental and amiable approach in his interactions working as part of a team while guiding and mentoring others. He must also be able to communicate engineering concepts in a manner that will be understood by others within and beyond the team.');
INSERT INTO `role` VALUES('Solutioning Director', 'The Solutioning Director defines and articulates the organisation''s strategy for securing technical wins with prospective clients. He/She focuses on developing key growth pre-sales strategies, tactics and action plans required to achieve revenue and/or sales targets. He advises the team on developing prototypes to ensure feasibility of solutions, and oversees the delivery of in-depth presentations and product demonstrations to clients. He solves complex problems and evaluates clients needs with different perspectives. He works in a fast-paced and dynamic environment, and travels frequently to clients'' premises for technical sales pitches and meetings. He is familiar with client relationship management and sales tools. He possesses deep product and technical knowledge, and is knowledgeable of the trends, developments and challenges of the industry domain. The Pre-Sales Director is target-driven and client centric, and has the ability to foster collaboration between stakeholders. He has a deep understanding of key business industries and knowledge of products and services in the market. He is strongly committed to developing talent and inspires his team members to pursue a common vision.');
INSERT INTO `role` VALUES('Support Engineer', 'The Support Engineer undertakes complex projects related to system provisioning, installations, configurations as well as monitoring and maintenance of systems. He/She applies highly developed specialist knowledge and skills in systems administration and works toward continuous optimisation of system performance. He implements system improvements and instructs other IT staff in the resolution of most complex issues. He is required to be on standby with on-call availability with varied shifts including nights, weekends and holidays to resolve systems related incidents. He works in a team setting and is proficient in Infrastructure systems and Network related tools and techniques required by the organisation. He is also familiar with the relevant platforms on which the database is deployed on. The Support Team is able to quickly and effectively solve issues as they arise. He is able to methodically identify the cause of the issue, evaluate it and develop a solution in collaboration with the team. He is able to communicate effectively and displays high service level standards.');
-- Table structure for table `skill`
DROP TABLE IF EXISTS `skill`;
CREATE TABLE IF NOT EXISTS `skill` (
`Skill_Name` varchar(50) NOT NULL,
`Skill_Desc` longtext NOT NULL,
PRIMARY KEY (`Skill_Name`)
);
-- insert data into skill
INSERT INTO `skill` VALUES('Account Management', 'Manage, maintain and grow the sales and relationships with a specific customer or set of accounts. This includes in-depth customer engagement, relationship-building and provision of quality solutions and service to address customers'' needs efficiently and generate revenue.');
INSERT INTO `skill` VALUES('Accounting and Tax Systems', 'Implement accounting or tax software systems in the organisation');
INSERT INTO `skill` VALUES('Accounting Standards', 'Apply financial reporting framework prescribed by the relevant governing body to ensure all transactions meet regulatory requirements');
INSERT INTO `skill` VALUES('Applications Development', 'Develop applications based on the design specifications; encompassing coding, testing, debugging, documenting and reviewing and/or refining it across the application development stages in accordance with defined standards for development and security. The complexity of the application may range from a basic application to a context-aware and/or augmented reality application that incorporates predictive behaviour analytics, geo-spatial capabilities and other appropriate algorithms. The technical skill includes the analysis and possibly the reuse, improvement, reconfiguration, addition or integration of existing and/or new application components.');
INSERT INTO `skill` VALUES('Applications Integration', 'Integrate data or functions from one application program with that of another application program - involves development of an integration plan, programming and the identification and utilisation of appropriate middleware to optimise the connectivity and performance of disparate applications across target environments');
INSERT INTO `skill` VALUES('Applications Support and Enhancement', 'Provide ongoing technical support and improvements to users of applications. This includes technical guidance and assistance related to the installation and maintenance of applications, fixing and resolution of application problems or disruptions, and response to change requests that will enhance the operations and usage of an application');
INSERT INTO `skill` VALUES('Audit Compliance', 'Ensure compliance with corporate policies and guidelines');
INSERT INTO `skill` VALUES('Audit Frameworks', 'Develop quality assurance frameworks to meet regulatory requirements');
INSERT INTO `skill` VALUES('Automated Equipment and Control Configuration', 'Configure automated equipment and control systems to support biopharmaceuticals and manufacturing processes');
INSERT INTO `skill` VALUES('Budgeting', 'Prepare organisational budgets to support short- and long-term business plans through forecasting, allocation and financial policy setting.');
INSERT INTO `skill` VALUES('Business Acumen', 'Assess the impact of changes in the business organisation, environment, and industry');
INSERT INTO `skill` VALUES('Business Development', 'Develop and implement plans to enhance organisation''s business performance and growth');
INSERT INTO `skill` VALUES('Business Environment Analysis', 'Analyse data pertaining to the business landscape and environment, including competitor-analysis, trends and developments in laws and regulations and the impact on the business');
INSERT INTO `skill` VALUES('Business Needs Analysis', 'Identify and scope business requirements and priorities through rigorous information gathering and analysis as well as clarification of the solutions, initiatives and programmes to enable effective delivery. This also involves the development of a compelling and defensible business case and the articulation of the potential impact of the solution to the business');
INSERT INTO `skill` VALUES('Business Negotiation', 'Conduct negotiations to establish win-win outcomes for the organisation');
INSERT INTO `skill` VALUES('Business Presentation Delivery', 'Perform required tasks to prepare and present information in various business settings involving preparation, understanding of audience, delivery and tailoring of messages to be conveyed');
INSERT INTO `skill` VALUES('Business Requirements Mapping', 'Map business requirements to existing processes to identify gaps or opportunities for possible solutions and evaluate impact of solutions against requirements to propose adjustments as needed ');
INSERT INTO `skill` VALUES('Business Risk Management', 'Forecast and assess existing and potential IT risks which impact the operation and/or profitability to the business as well as the development and roll out of company-wide strategies and processes to mitigate risk, minimise their impact or effectively manage such business risks');
INSERT INTO `skill` VALUES('Call Centre Management', 'Implement and manage call centre operations to address queries and needs of customers');
INSERT INTO `skill` VALUES('Collaboration', 'Manage relationships and work collaboratively and effectively with others to achieve goals');
INSERT INTO `skill` VALUES('Communication', 'Convey and exchange thoughts, ideas and information effectively through various mediums and approaches');
INSERT INTO `skill` VALUES('Configuration Tracking', 'Track systematically and manage changes and revisions in software projects to ensure that all changes are accounted for and to protect assets against unauthorized change, diversion and inappropriate use');
INSERT INTO `skill` VALUES('Customer Acquisition Management', 'Develop customer acquisition strategies as well as foster customer relationships to attract new customers');
INSERT INTO `skill` VALUES('Customer Relationship Management', 'Initiate and drive activities to enhance customer relationships and brand loyalty for the organisation');
INSERT INTO `skill` VALUES('Data Analytics', 'Apply data extraction and analytic methods to analyse and evaluate financial and non-financial information and provide business intelligence');
INSERT INTO `skill` VALUES('Database Administration', 'Perform Installation, coordination and upgrading of databases and database servers, performance monitoring and troubleshooting. This includes monitoring user access to database and optimisation of database performance, planning for backup and recovery, archived data maintenance and reporting');
INSERT INTO `skill` VALUES('Developing People', 'Empower others to learn and develop their capabilities to enhance their performance and achieve personal or professional goals');
INSERT INTO `skill` VALUES('Digital Fluency', 'Leverage digital technology tools, systems, and software across work processes and activities to solve problems, drive efficiency and facilitate information sharing');
INSERT INTO `skill` VALUES('Employee Communication Management', 'Formulate overall employee communication strategies and facilitate conversations to ensure effective and timely dissemination of pertinent information to employees');
INSERT INTO `skill` VALUES('Employee Engagement Management', 'Drive employee engagement programmes to facilitate commitment from employees to organisational values, vision and objectives');
INSERT INTO `skill` VALUES('Finance Business Partnering', 'Generate finance-related insights to support the business in a strategic manner');
INSERT INTO `skill` VALUES('Financial Acumen', 'Exercise financial insight to establish budgets for human resource (HR) activities and monitor HR operations and outcomes against financial plans');
INSERT INTO `skill` VALUES('Financial Closing', 'Carry out month-end closing and reconciliation to ensure financial records are maintained properly');
INSERT INTO `skill` VALUES('Financial Management', 'Ensure healthy finance to aid business growth and operations');
INSERT INTO `skill` VALUES('Financial Planning', 'Evaluate and develop budget in line with organisation''s strategies and plans');
INSERT INTO `skill` VALUES('Financial Reporting', 'Prepare general-purpose financial statements and disclosure notes in accordance with applicable financial reporting framework');
INSERT INTO `skill` VALUES('Financial Statements Analysis', 'Analyse financial statements in accordance with the applicable frameworks');
INSERT INTO `skill` VALUES('Financial Transactions', 'Prepare business documentation and cash balances');
INSERT INTO `skill` VALUES('Human Resource Advisory', 'Deliver human resource (HR) advisory and consultancy services to internal and external clients to meet their requirements');
INSERT INTO `skill` VALUES('Human Resource Practices Implementation', 'Implement of human resource (HR) practices by integrating local and international requirements, guidelines and best practices');
INSERT INTO `skill` VALUES('Human Resource Strategy Formulation', 'Establish human resource (HR) strategies and priorities that are aligned with current and future business needs');
INSERT INTO `skill` VALUES('Human Resource Systems Management', 'Establish and manage effective and efficient human resource (HR) management systems');
INSERT INTO `skill` VALUES('Infrastructure Deployment', 'Set up, deploy and decommission infrastructure components and associated equipment in accordance to a set plan and established safety and/or quality procedures. This includes the assessment and preparation of appropriate site locations, infrastructure, the development of an installation plan, layout at the site, the testing of on-site systems, infrastructure components, equipment and the correction of issues and/or malfunctions');
INSERT INTO `skill` VALUES('Infrastructure Support', 'Provide services to end users by systematically identifying, classifying and troubleshooting technical issues and incidents that disrupt and impact their day-to-day business activities, within a specified timeframe. This also includes implementing an end-to-end problem management process to analyse underlying problems, advising on infrastructure related upgrades and improvements and developing user guides and training materials');
INSERT INTO `skill` VALUES('Learning and Development Programme Management', 'Establish and implement learning and development programmes and channels to facilitate employees'' growth and capability building');
INSERT INTO `skill` VALUES('Learning Needs Analysis', 'Identify the learning needs of the learners'' workplace, department or division in accordance to the Learning Needs Analysis Framework');
INSERT INTO `skill` VALUES('Network Administration and Maintenance', 'Monitor network in order to provide for optimum levels of network performance and minimisation of downtime. This includes detection, isolation, recovery and limitation of the impact of failures on the network as well as provision of support to system users through ongoing maintenance information sharing and training');
INSERT INTO `skill` VALUES('Onboarding', 'Facilitate onboarding programmes to enable the integration and engagement of new hires into the organisation');
INSERT INTO `skill` VALUES('Organisational Design', 'Develop and facilitate the implementation of organisational design to ensure its effectiveness and alignment with stakeholders'' priorities');
INSERT INTO `skill` VALUES('People and Performance Management', 'Establish and implement performance management and remuneration strategies in the organisation to drive business results');
INSERT INTO `skill` VALUES('Pricing Strategy', 'Analyse product, organisational and market factors, trends, pricing scenarios and valuation models to develop effective pricing strategies for products and solutions ');
INSERT INTO `skill` VALUES('Problem Management', 'Manage the lifecycle of problems to prevent problems and incidents from occurring, eliminate recurring incidents and minimise impact of unavoidable incidents');
INSERT INTO `skill` VALUES('Problem Solving', 'Generate effective and efficient solutions to solve problems and capitalise on new opportunities');
INSERT INTO `skill` VALUES('Product Management', 'Create and manage a product roadmap, involving the ideating, planning, forecasting, marketing and management of a product or a suite of products throughout stages of its lifecycle, from its conceptualisation to market entrance and eventual phasing-out. This includes the creation of a new product idea or concept and definition of the product strategy based on a projection of its potential benefits to the customer as well as the review of product performance against milestones and targets set ');
INSERT INTO `skill` VALUES('Professional and Business Ethics', 'Foster strong ethical standards and resolve ethical conflicts in accordance with the relevant principles and processes');
INSERT INTO `skill` VALUES('Project Management', 'Execute projects by managing stakeholder engagement, resources, budgets and resolving problems');
INSERT INTO `skill` VALUES('Regulatory Compliance', 'Comply with policies, procedures, and external regulations');
INSERT INTO `skill` VALUES('Regulatory Risk Assessment', 'Analyse the impact of latest global regulatory developments and relevant laws on overall audit and/or engagement strategies');
INSERT INTO `skill` VALUES('Regulatory Strategy', 'Align regulatory activities with business strategies');
INSERT INTO `skill` VALUES('Sales Closure', 'Perform numerical calculations and execute selling strategies to complete sales of products and services to the satisfaction of customers');
INSERT INTO `skill` VALUES('Sales Strategy', 'Develop a sales strategy, plan and targets, considering market potential, industry trends and various internal and external business factors as well as the evaluation and further refinement of the sales strategy');
INSERT INTO `skill` VALUES('Security Administration', 'Administer, configure and update of security programmes and mechanisms, including the application of system patches to ensure that enterprise assets are adequately protected against threats. This also includes the authorisation, management and monitoring of access control permissions and/or rights to various IT facilities');
INSERT INTO `skill` VALUES('Sense Making', 'Leverage sources of qualitative and quantitative information and data to recognise patterns, spot opportunities, infer insights and inform decisions');
INSERT INTO `skill` VALUES('Service Level Management', 'Plan, monitor and manage service provisions for the achievement of agreed service level targets');
INSERT INTO `skill` VALUES('Skills Framework Adoption', 'Drive the adoption, integration and implementation of Skills Frameworks and their components in business and human resources activities throughout the organisation');
INSERT INTO `skill` VALUES('Software Configuration', 'Configure software products, analytics and modelling solutions, and apply and/or modify scripts and automation tools to integrate and deploy releases to various platforms and operating environments ');
INSERT INTO `skill` VALUES('Software Design', 'Create and refine the overall plan for the design of software, including the design of functional specifications starting from the defined business requirements as well as the consideration and incorporation of various controls, functionality and interoperability of different elements into a design blueprint or model which describes the overall architecture in hardware, software, databases, and third party frameworks that the software will use or interact with');
INSERT INTO `skill` VALUES('Software Testing', 'Assess and test the overall effectiveness and performance of an application, involving the setting up of suitable testing conditions, definition of test cases and/or technical criteria ');
INSERT INTO `skill` VALUES('Solution Architecture', 'Design or refine a solution blueprint or structure to guide the development of IT solutions in hardware, software, processes or related components, to meet current and future business needs. The solution architecture developed may lead to broad or specific changes to IT services, operating models and processes, and should provide a framework to guide the development and modification of solutions');
INSERT INTO `skill` VALUES('Solutions Design Thinking', 'Solutions Design Thinking');
INSERT INTO `skill` VALUES('SOP Development and Implementation', 'Develop Standard Operating Procedures (SOPs) and implement procedures to ensure that process operational tasks for all modes of plant operation are performed correctly and consistently in accordance with regulatory and organisational objectives');
INSERT INTO `skill` VALUES('Stakeholder Management', 'Manage stakeholder expectations to ensure continuous levels of engagement by identifying and addressing needs, setting service standards and resolving issues in accordance with organisational procedures');
INSERT INTO `skill` VALUES('Strategy Planning', 'Develop organisational strategies and policies by analysing the impact of internal and external influencing factors and seeking consultation from relevant stakeholders.');
INSERT INTO `skill` VALUES('System Integration', 'Develop and implement a roadmap and specific integration solutions to facilitate integration of various ICT components and optimise inter-operability of systems and their interfaces. This includes the integration of various architectural components such as networks, servers, system platforms and their interfaces');
INSERT INTO `skill` VALUES('Talent Management', 'Drive talent management strategies and programmes to identify, develop, review and retain talent to meet the current and future organisational needs');
INSERT INTO `skill` VALUES('Tax Computation', 'Compute Goods and Services Tax, and tax liabilities');
INSERT INTO `skill` VALUES('Tax Implications', 'Assess tax implication of changes in tax laws');
INSERT INTO `skill` VALUES('Technology Application', 'Integrate technologies into operations of the organisation to optimise efficiency and effectiveness of processes');
INSERT INTO `skill` VALUES('Technology Integration', 'Integrate new and emerging technology products, services and developments to enhance human resource (HR) operations and service delivery');
INSERT INTO `skill` VALUES('Technology Road Mapping', 'Plan short-term and long-term goals with specific technology solutions to help meet those goals in order to make capital out of future market needs');
INSERT INTO `skill` VALUES('User Interface Design', 'Design user interfaces for machines and software, incorporating visual, technical and functional elements that facilitate ease of access, understanding and usage. This would involve adding, removing, modifying or enhancing elements to make the user''s interaction with the product as seamless as possible');
-- Table structure for table `staff`
DROP TABLE IF EXISTS `staff`;
CREATE TABLE IF NOT EXISTS `staff` (
`Staff_ID` int NOT NULL AUTO_INCREMENT,
`Staff_FName` varchar(50) NOT NULL,
`Staff_LName` varchar(50) NOT NULL,
`Dept` varchar(50) NOT NULL,
`Country` varchar(50) NOT NULL,
`Email` varchar(50) NOT NULL,
`Role` int NOT NULL,
PRIMARY KEY (`Staff_ID`)
);
-- insert data into staff
INSERT INTO `staff` VALUES(130001, 'John', 'Sim', 'Chariman', 'Singapore', 'jack.sim@allinone.com.sg', 1);
INSERT INTO `staff` VALUES(130002, 'Jack', 'Sim', 'CEO', 'Singapore', 'jack.sim@allinone.com.sg', 1);
INSERT INTO `staff` VALUES(140001, 'Derek', 'Tan', 'Sales', 'Singapore', 'Derek.Tan@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(140002, 'Susan', 'Goh', 'Sales', 'Singapore', 'Susan.Goh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140003, 'Janice', 'Chan', 'Sales', 'Singapore', 'Janice.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140004, 'Mary', 'Teo', 'Sales', 'Singapore', 'Mary.Teo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140008, 'Jaclyn', 'Lee', 'Sales', 'Singapore', 'Jaclyn.Lee@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(140015, 'Oliva', 'Lim', 'Sales', 'Singapore', 'Oliva.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140025, 'Emma', 'Heng', 'Sales', 'Singapore', 'Emma.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140036, 'Charlotte', 'Wong', 'Sales', 'Singapore', 'Charlotte.Wong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140078, 'Amelia', 'Ong', 'Sales', 'Singapore', 'Amelia.Ong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140102, 'Eva', 'Yong', 'Sales', 'Singapore', 'Eva.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140103, 'Sophia', 'Toh', 'Sales', 'Singapore', 'Sophia.Toh@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(140108, 'Liam', 'The', 'Sales', 'Singapore', 'Liam.The@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140115, 'Noah', 'Ng', 'Sales', 'Singapore', 'Noah.Ng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140525, 'Oliver', 'Tan', 'Sales', 'Singapore', 'Oliver.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140736, 'William', 'Fu', 'Sales', 'Singapore', 'William.Fu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140878, 'James', 'Tong', 'Sales', 'Singapore', 'James.Tong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140879, 'Siti', 'Abdullah', 'Sales', 'Singapore', 'Siti.Abdullah@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(140880, 'Heng', 'Chan', 'Sales', 'Singapore', 'Heng.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140881, 'Rina', 'Tan', 'Sales', 'Singapore', 'Rina.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140882, 'Boun', 'Souk', 'Sales', 'Singapore', 'Boun.Souk@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140883, 'Aung', 'Kyaw', 'Sales', 'Singapore', 'Aung.Kyaw@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140886, 'Thuy', 'Nguyen', 'Sales', 'Singapore', 'Thuy.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140887, 'Rajesh', 'Kumar', 'Sales', 'Singapore', 'Rajesh.Kumar@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140888, 'Koh', 'Lim', 'Sales', 'Singapore', 'Koh.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140889, 'Somchai', 'Somboon', 'Sales', 'Singapore', 'Somchai.Somboon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140890, 'Seng', 'Lee', 'Sales', 'Singapore', 'Seng.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140891, 'Anh', 'Tran', 'Sales', 'Singapore', 'Anh.Tran@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140892, 'Ratana', 'Chen', 'Sales', 'Singapore', 'Ratana.Chen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140893, 'Bui', 'Nguyen', 'Sales', 'Singapore', 'Bui.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140894, 'Rahim', 'Khalid', 'Sales', 'Singapore', 'Rahim.Khalid@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(140895, 'Dewi', 'Putri', 'Sales', 'Singapore', 'Dewi.Putri@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140898, 'Sokha', 'Seng', 'Sales', 'Singapore', 'Sokha.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140900, 'Tuan', 'Nguyen', 'Sales', 'Singapore', 'Tuan.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140901, 'Bao', 'Luu', 'Sales', 'Singapore', 'Bao.Luu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140903, 'Amara', 'Singh', 'Sales', 'Malaysia', 'Amara.Singh@allinone.com.my', 2);
INSERT INTO `staff` VALUES(140904, 'Srey', 'Mao', 'Sales', 'Malaysia', 'Srey.Mao@allinone.com.my', 2);
INSERT INTO `staff` VALUES(140905, 'Phuc', 'Le', 'Sales', 'Malaysia', 'Phuc.Le@allinone.com.my', 2);
INSERT INTO `staff` VALUES(140908, 'Arifin', 'Saputra', 'Sales', 'Malaysia', 'Arifin.Saputra@allinone.com.my', 2);
INSERT INTO `staff` VALUES(140909, 'Siti', 'Salleh', 'Sales', 'Malaysia', 'Siti.Salleh@allinone.com.my', 2);
INSERT INTO `staff` VALUES(140910, 'Rina', 'Siriporn', 'Sales', 'Indonesia ', 'Rina.Siriporn@allinone.com.id', 2);
INSERT INTO `staff` VALUES(140911, 'Minh', 'Ly', 'Sales', 'Indonesia ', 'Minh.Ly@allinone.com.id', 2);
INSERT INTO `staff` VALUES(140912, 'Chandara', 'Kim', 'Sales', 'Indonesia ', 'Chandara.Kim@allinone.com.id', 2);
INSERT INTO `staff` VALUES(140917, 'Heng', 'Phan', 'Sales', 'Indonesia ', 'Heng.Phan@allinone.com.id', 2);
INSERT INTO `staff` VALUES(140918, 'Nara', 'Khun', 'Sales', 'Indonesia ', 'Nara.Khun@allinone.com.id', 2);
INSERT INTO `staff` VALUES(140919, 'Priya', 'Malik', 'Sales', 'Indonesia ', 'Priya.Malik@allinone.com.id', 2);
INSERT INTO `staff` VALUES(140923, 'Ngoc', 'Trinh', 'Sales', 'Vietnam', 'Ngoc.Trinh@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(140924, 'Manoj', 'Kumar', 'Sales', 'Vietnam', 'Manoj.Kumar@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(140925, 'Anh', 'Pham', 'Sales', 'Vietnam', 'Anh.Pham@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(140926, 'Somsak', 'Somsri', 'Sales', 'Vietnam', 'Somsak.Somsri@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(140927, 'Chin', 'Lim', 'Sales', 'Hong Kong', 'Chin.Lim@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140928, 'Sok', 'Chhay', 'Sales', 'Hong Kong', 'Sok.Chhay@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140929, 'Tat', 'Nguyen', 'Sales', 'Hong Kong', 'Tat.Nguyen@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140933, 'Hlaing', 'Sithu', 'Sales', 'Hong Kong', 'Hlaing.Sithu@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140934, 'Santhi', 'Perumal', 'Sales', 'Hong Kong', 'Santhi.Perumal@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140935, 'Hakim', 'Siregar', 'Sales', 'Hong Kong', 'Hakim.Siregar@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140937, 'Sirirat', 'Chaiyaporn', 'Sales', 'Hong Kong', 'Sirirat.Chaiyaporn@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140938, 'Chinh', 'Tran', 'Sales', 'Hong Kong', 'Chinh.Tran@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(140940, 'Siti', 'Ahmad', 'Sales', 'Singapore', 'Siti.Ahmad@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140941, 'Chandra', 'Rai', 'Sales', 'Singapore', 'Chandra.Rai@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140942, 'Ratana', 'Keo', 'Sales', 'Singapore', 'Ratana.Keo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140944, 'Yee', 'Lim', 'Sales', 'Singapore', 'Yee.Lim@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(140945, 'Wai', 'Yong', 'Sales', 'Singapore', 'Wai.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140947, 'Thi', 'Pham', 'Sales', 'Singapore', 'Thi.Pham@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(140948, 'Nara', 'Sok', 'Sales', 'Singapore', 'Nara.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150008, 'Eric', 'Loh', 'Solutioning', 'Singapore', 'Eric.Loh@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(150065, 'Noah', 'Goh', 'Engineering', 'Singapore', 'Noah.Goh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150075, 'Liam', 'Tan', 'Engineering', 'Singapore', 'Liam.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150076, 'Oliver', 'Chan', 'Engineering', 'Singapore', 'Oliver.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150085, 'Michael', 'Ng', 'Engineering', 'Singapore', 'Michael.Ng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150095, 'Alexander', 'The', 'Engineering', 'Singapore', 'Alexander.The@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150096, 'Ethan', 'Tan', 'Engineering', 'Singapore', 'Ethan.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150115, 'Jaclyn', 'Lee', 'Engineering', 'Singapore', 'Jaclyn.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150118, 'William', 'Teo', 'Engineering', 'Singapore', 'William.Teo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150125, 'Mary', 'Teo', 'Engineering', 'Singapore', 'Mary.Teo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150126, 'Oliva', 'Lim', 'Engineering', 'Singapore', 'Oliva.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150138, 'Daniel', 'Fu', 'Engineering', 'Singapore', 'Daniel.Fu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150142, 'James', 'Lee', 'Engineering', 'Singapore', 'James.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150143, 'John', 'Lim', 'Engineering', 'Singapore', 'John.Lim@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(150148, 'Jack', 'Heng', 'Engineering', 'Singapore', 'Jack.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150155, 'Derek', 'Wong', 'Engineering', 'Singapore', 'Derek.Wong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150162, 'Jacob', 'Tong', 'Engineering', 'Singapore', 'Jacob.Tong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150163, 'Logan', 'Loh', 'Engineering', 'Singapore', 'Logan.Loh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150165, 'Oliver', 'Tan', 'Engineering', 'Singapore', 'Oliver.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150166, 'William', 'Fu', 'Engineering', 'Singapore', 'William.Fu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150168, 'Jackson', 'Tan', 'Engineering', 'Singapore', 'Jackson.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150175, 'Aiden', 'Tan', 'Engineering', 'Singapore', 'Aiden.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150192, 'Emma', 'Heng', 'Engineering', 'Singapore', 'Emma.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150193, 'Charlotte', 'Wong', 'Engineering', 'Singapore', 'Charlotte.Wong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150198, 'Amelia', 'Ong', 'Engineering', 'Singapore', 'Amelia.Ong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150205, 'Eva', 'Yong', 'Engineering', 'Singapore', 'Eva.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150208, 'James', 'Tong', 'Engineering', 'Singapore', 'James.Tong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150215, 'Michael', 'Lee', 'Engineering', 'Singapore', 'Michael.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150216, 'Ethan', 'Lim', 'Engineering', 'Singapore', 'Ethan.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150232, 'John', 'Loh', 'Engineering', 'Singapore', 'John.Loh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150233, 'Jack', 'Tan', 'Engineering', 'Singapore', 'Jack.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150238, 'Derek', 'Tan', 'Engineering', 'Singapore', 'Derek.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150245, 'Benjamin', 'Tan', 'Engineering', 'Singapore', 'Benjamin.Tan@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(150258, 'Daniel', 'Heng', 'Engineering', 'Singapore', 'Daniel.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150265, 'Jaclyn', 'Tong', 'Engineering', 'Singapore', 'Jaclyn.Tong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150275, 'Mary', 'Fu', 'Engineering', 'Singapore', 'Mary.Fu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150276, 'Oliva', 'Loh', 'Engineering', 'Singapore', 'Oliva.Loh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150282, 'Jacob', 'Wong', 'Engineering', 'Singapore', 'Jacob.Wong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150283, 'Logan', 'Ong', 'Engineering', 'Singapore', 'Logan.Ong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150288, 'Jackson', 'Yong', 'Engineering', 'Singapore', 'Jackson.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150295, 'Aiden', 'Toh', 'Engineering', 'Singapore', 'Aiden.Toh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150318, 'Emma', 'Tan', 'Engineering', 'Singapore', 'Emma.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150342, 'Charlotte', 'Tan', 'Engineering', 'Singapore', 'Charlotte.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150343, 'Amelia', 'Tan', 'Engineering', 'Singapore', 'Amelia.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150345, 'William', 'Heng', 'Engineering', 'Singapore', 'William.Heng@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(150348, 'Eva', 'Goh', 'Engineering', 'Singapore', 'Eva.Goh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150355, 'Sophia', 'Chan', 'Engineering', 'Singapore', 'Sophia.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150356, 'James', 'Wong', 'Engineering', 'Singapore', 'James.Wong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150398, 'John', 'Ong', 'Engineering', 'Singapore', 'John.Ong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150422, 'Jack', 'Yong', 'Engineering', 'Singapore', 'Jack.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150423, 'Derek', 'Toh', 'Engineering', 'Singapore', 'Derek.Toh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150428, 'Benjamin', 'The', 'Engineering', 'Singapore', 'Benjamin.The@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150435, 'Lucas', 'Ng', 'Engineering', 'Singapore', 'Lucas.Ng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150445, 'Ethan', 'Loh', 'Engineering', 'Singapore', 'Ethan.Loh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150446, 'Daniel', 'Tan', 'Engineering', 'Singapore', 'Daniel.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150488, 'Jacob', 'Tan', 'Engineering', 'Singapore', 'Jacob.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150512, 'Logan', 'Tan', 'Engineering', 'Singapore', 'Logan.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150513, 'Jackson', 'Goh', 'Engineering', 'Singapore', 'Jackson.Goh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150518, 'Aiden', 'Chan', 'Engineering', 'Singapore', 'Aiden.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150525, 'Samuel', 'Teo', 'Engineering', 'Singapore', 'Samuel.Teo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150555, 'Jaclyn', 'Wong', 'Engineering', 'Singapore', 'Jaclyn.Wong@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(150565, 'Benjamin', 'Ong', 'Engineering', 'Singapore', 'Benjamin.Ong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150566, 'Oliva', 'Ong', 'Engineering', 'Singapore', 'Oliva.Ong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150585, 'Samuel', 'Tan', 'Engineering', 'Singapore', 'Samuel.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150608, 'Emma', 'Yong', 'Engineering', 'Singapore', 'Emma.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150615, 'Sophia', 'Toh', 'Engineering', 'Singapore', 'Sophia.Toh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150632, 'Charlotte', 'Toh', 'Engineering', 'Singapore', 'Charlotte.Toh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150633, 'Amelia', 'The', 'Engineering', 'Singapore', 'Amelia.The@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150638, 'Eva', 'Ng', 'Engineering', 'Singapore', 'Eva.Ng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150645, 'Sophia', 'Tan', 'Engineering', 'Singapore', 'Sophia.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150655, 'Lucas', 'Goh', 'Engineering', 'Singapore', 'Lucas.Goh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150695, 'William', 'Tan', 'Engineering', 'Singapore', 'William.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150705, 'Samuel', 'The', 'Engineering', 'Singapore', 'Samuel.The@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150765, 'Liam', 'Teo', 'Engineering', 'Singapore', 'Liam.Teo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150776, 'Lucas', 'Yong', 'Engineering', 'Singapore', 'Lucas.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150796, 'Susan', 'Goh', 'Engineering', 'Singapore', 'Susan.Goh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150826, 'Liam', 'The', 'Engineering', 'Singapore', 'Liam.The@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150845, 'Henry', 'Tan', 'Engineering', 'Singapore', 'Henry.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150866, 'Henry', 'Chan', 'Engineering', 'Singapore', 'Henry.Chan@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(150916, 'Susan', 'Ng', 'Engineering', 'Singapore', 'Susan.Ng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150918, 'Henry', 'Toh', 'Engineering', 'Singapore', 'Henry.Toh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150935, 'Susan', 'Lee', 'Engineering', 'Singapore', 'Susan.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150938, 'Janice', 'Chan', 'Engineering', 'Singapore', 'Janice.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150968, 'Noah', 'Ng', 'Engineering', 'Singapore', 'Noah.Ng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(150976, 'Noah', 'Lee', 'Engineering', 'Singapore', 'Noah.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151008, 'Alexander', 'Teo', 'Engineering', 'Singapore', 'Alexander.Teo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151055, 'Liam', 'Fu', 'Engineering', 'Singapore', 'Liam.Fu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151056, 'Alexander', 'Fu', 'Engineering', 'Singapore', 'Alexander.Fu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151058, 'Janice', 'Tan', 'Engineering', 'Singapore', 'Janice.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151118, 'Oliver', 'Lim', 'Engineering', 'Singapore', 'Oliver.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151146, 'Janice', 'Lim', 'Engineering', 'Singapore', 'Janice.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151198, 'Michael', 'Tong', 'Engineering', 'Singapore', 'Michael.Tong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151266, 'Noah', 'Tong', 'Engineering', 'Singapore', 'Noah.Tong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151288, 'Mary', 'Heng', 'Engineering', 'Singapore', 'Mary.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151407, 'Oliver', 'Loh', 'Engineering', 'Singapore', 'Oliver.Loh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151408, 'Philip', 'Lee', 'Engineering', 'Singapore', 'Philip.Lee@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(151410, 'Phuong', 'Dinh', 'Engineering', 'Singapore', 'Phuong.Dinh@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(151411, 'Bao', 'Nguyen', 'Engineering', 'Singapore', 'Bao.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151412, 'Wati', 'Halim', 'Engineering', 'Singapore', 'Wati.Halim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151413, 'Seng', 'Soeun', 'Engineering', 'Singapore', 'Seng.Soeun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151414, 'Yun', 'Lee', 'Engineering', 'Indonesia ', 'Yun.Lee@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151415, 'Aung', 'Tun', 'Engineering', 'Singapore', 'Aung.Tun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151416, 'Vannak', 'Chen', 'Engineering', 'Malaysia', 'Vannak.Chen@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151417, 'Pich', 'Sun', 'Engineering', 'Singapore', 'Pich.Sun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151418, 'Chandara', 'Khun', 'Engineering', 'Vietnam', 'Chandara.Khun@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151419, 'Heng', 'Heng', 'Engineering', 'Singapore', 'Heng.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151420, 'Siti', 'Ismail', 'Engineering', 'Singapore', 'Siti.Ismail@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151425, 'Thuy', 'Phan', 'Engineering', 'Hong Kong', 'Thuy.Phan@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151426, 'Trung', 'Trinh', 'Engineering', 'Singapore', 'Trung.Trinh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151427, 'Rahul', 'Sharma', 'Engineering', 'Singapore', 'Rahul.Sharma@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151428, 'Champa', 'Thao', 'Engineering', 'Singapore', 'Champa.Thao@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151430, 'Rithy', 'Chheng', 'Engineering', 'Singapore', 'Rithy.Chheng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151431, 'Mani', 'Raj', 'Engineering', 'Singapore', 'Mani.Raj@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151432, 'Sokunthea', 'Phan', 'Engineering', 'Singapore', 'Sokunthea.Phan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151433, 'Mani', 'Devi', 'Engineering', 'Indonesia ', 'Mani.Devi@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151435, 'Somnang', 'Suon', 'Engineering', 'Singapore', 'Somnang.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151436, 'Samsul', 'Rahman', 'Engineering', 'Malaysia', 'Samsul.Rahman@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151438, 'Rath', 'Phan', 'Engineering', 'Singapore', 'Rath.Phan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151439, 'Ji', 'Han', 'Engineering', 'Vietnam', 'Ji.Han@allinone.com.vn', 3);
INSERT INTO `staff` VALUES(151440, 'Sok', 'Pich', 'Engineering', 'Singapore', 'Sok.Pich@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151441, 'Minh', 'Hoang', 'Engineering', 'Singapore', 'Minh.Hoang@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(151443, 'Anil', 'Kumar', 'Engineering', 'Hong Kong', 'Anil.Kumar@allinone.com.hk', 3);
INSERT INTO `staff` VALUES(151444, 'Chinh', 'Le', 'Engineering', 'Singapore', 'Chinh.Le@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151446, 'Seng', 'Seng', 'Engineering', 'Singapore', 'Seng.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151447, 'Nanda', 'Kesavan', 'Engineering', 'Singapore', 'Nanda.Kesavan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151448, 'Amirah', 'Ahmad', 'Engineering', 'Singapore', 'Amirah.Ahmad@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151450, 'Sokly', 'Sok', 'Engineering', 'Singapore', 'Sokly.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151451, 'Trung', 'Pham', 'Engineering', 'Singapore', 'Trung.Pham@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151452, 'Rithya', 'Suon', 'Engineering', 'Indonesia ', 'Rithya.Suon@allinone.com.id', 3);
INSERT INTO `staff` VALUES(151456, 'Phuc', 'Vo', 'Engineering', 'Singapore', 'Phuc.Vo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151457, 'Chandra', 'Pandey', 'Engineering', 'Malaysia', 'Chandra.Pandey@allinone.com.my', 3);
INSERT INTO `staff` VALUES(151458, 'Manoj', 'Singh', 'Engineering', 'Singapore', 'Manoj.Singh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151459, 'Phalla', 'Yong', 'Engineering', 'Vietnam', 'Phalla.Yong@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151464, 'Chhaya', 'Sou', 'Engineering', 'Singapore', 'Chhaya.Sou@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151465, 'Soma', 'Lim', 'Engineering', 'Singapore', 'Soma.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151466, 'Siv', 'Sun', 'Engineering', 'Hong Kong', 'Siv.Sun@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151467, 'Vannak', 'Mao', 'Engineering', 'Singapore', 'Vannak.Mao@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151468, 'Kumara', 'Seng', 'Engineering', 'Singapore', 'Kumara.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151469, 'Sok', 'Heng', 'Engineering', 'Singapore', 'Sok.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151470, 'Siti', 'Saad', 'Engineering', 'Singapore', 'Siti.Saad@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151471, 'Chanh', 'Ly', 'Engineering', 'Singapore', 'Chanh.Ly@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(151472, 'Anh', 'Truong', 'Engineering', 'Singapore', 'Anh.Truong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151476, 'Hakim', 'Rahman', 'Engineering', 'Indonesia ', 'Hakim.Rahman@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151477, 'Priya', 'Kaur', 'Engineering', 'Singapore', 'Priya.Kaur@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151479, 'Narong', 'Chen', 'Engineering', 'Malaysia', 'Narong.Chen@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151480, 'Rin', 'Sok', 'Engineering', 'Singapore', 'Rin.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151481, 'Phuc', 'Lam', 'Engineering', 'Vietnam', 'Phuc.Lam@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151482, 'Sok', 'Chin', 'Engineering', 'Singapore', 'Sok.Chin@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151483, 'Chandara', 'Kong', 'Engineering', 'Singapore', 'Chandara.Kong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151484, 'Phanith', 'Sok', 'Engineering', 'Hong Kong', 'Phanith.Sok@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151485, 'Heng', 'Sim', 'Engineering', 'Singapore', 'Heng.Sim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151487, 'Nanda', 'Devan', 'Engineering', 'Singapore', 'Nanda.Devan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151488, 'Pich', 'Phan', 'Engineering', 'Singapore', 'Pich.Phan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151489, 'Anil', 'Sarawat', 'Engineering', 'Singapore', 'Anil.Sarawat@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151491, 'Nguyen', 'Tuan', 'Engineering', 'Singapore', 'Nguyen.Tuan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151492, 'Bao', 'Kim', 'Engineering', 'Singapore', 'Bao.Kim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151493, 'Boun', 'Sok', 'Engineering', 'Indonesia ', 'Boun.Sok@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151494, 'Soma', 'Khun', 'Engineering', 'Singapore', 'Soma.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151495, 'Samsul', 'Saifullah', 'Engineering', 'Malaysia', 'Samsul.Saifullah@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151496, 'Rina', 'Li', 'Engineering', 'Singapore', 'Rina.Li@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151498, 'Mani', 'Prasad', 'Engineering', 'Vietnam', 'Mani.Prasad@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151499, 'Koh', 'Seng', 'Engineering', 'Singapore', 'Koh.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151500, 'Arifin', 'Siregar', 'Engineering', 'Singapore', 'Arifin.Siregar@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151502, 'Kumari', 'Devi', 'Engineering', 'Hong Kong', 'Kumari.Devi@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151503, 'Narong', 'Khun', 'Engineering', 'Singapore', 'Narong.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151505, 'Thi', 'Lam', 'Engineering', 'Singapore', 'Thi.Lam@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151506, 'Vannak', 'Sok', 'Engineering', 'Singapore', 'Vannak.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151507, 'Phuong', 'Nguyen', 'Engineering', 'Singapore', 'Phuong.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151508, 'Srey', 'Makara', 'Engineering', 'Singapore', 'Srey.Makara@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151509, 'Hlaing', 'Kyaw', 'Engineering', 'Singapore', 'Hlaing.Kyaw@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151510, 'Anh', 'Ly', 'Engineering', 'Indonesia ', 'Anh.Ly@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151512, 'Chin', 'Heng', 'Engineering', 'Singapore', 'Chin.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151513, 'Nara', 'Yong', 'Engineering', 'Malaysia', 'Nara.Yong@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151514, 'Somchai', 'Phan', 'Engineering', 'Singapore', 'Somchai.Phan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151515, 'Rath', 'Sim', 'Engineering', 'Vietnam', 'Rath.Sim@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151517, 'Chinh', 'Tran', 'Engineering', 'Singapore', 'Chinh.Tran@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151518, 'Yee', 'Liu', 'Engineering', 'Singapore', 'Yee.Liu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151519, 'Heng', 'Chhour', 'Engineering', 'Hong Kong', 'Heng.Chhour@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151520, 'Sokunthea', 'Soy', 'Engineering', 'Singapore', 'Sokunthea.Soy@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151521, 'Champa', 'Thach', 'Engineering', 'Singapore', 'Champa.Thach@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151523, 'Rahim', 'Ramli', 'Engineering', 'Singapore', 'Rahim.Ramli@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151524, 'Hakim', 'Hassan', 'Engineering', 'Singapore', 'Hakim.Hassan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151525, 'Trung', 'Le', 'Engineering', 'Singapore', 'Trung.Le@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151526, 'Seng', 'Chhour', 'Engineering', 'Singapore', 'Seng.Chhour@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151527, 'Narong', 'Mao', 'Engineering', 'Indonesia ', 'Narong.Mao@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151528, 'Phuc', 'Phung', 'Engineering', 'Singapore', 'Phuc.Phung@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151531, 'Chandara', 'Sin', 'Engineering', 'Malaysia', 'Chandara.Sin@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151533, 'Soma', 'San', 'Engineering', 'Singapore', 'Soma.San@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151534, 'Siv', 'Savuth', 'Engineering', 'Vietnam', 'Siv.Savuth@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151535, 'Vannak', 'Soun', 'Engineering', 'Singapore', 'Vannak.Soun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151536, 'Kumara', 'Suon', 'Engineering', 'Singapore', 'Kumara.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151537, 'Sok', 'Mao', 'Engineering', 'Hong Kong', 'Sok.Mao@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151539, 'Siti', 'Yusof', 'Engineering', 'Singapore', 'Siti.Yusof@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151540, 'Chanh', 'Sin', 'Engineering', 'Singapore', 'Chanh.Sin@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151541, 'Anh', 'Tran', 'Engineering', 'Singapore', 'Anh.Tran@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151543, 'Priya', 'Krishnan', 'Engineering', 'Singapore', 'Priya.Krishnan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151544, 'Nanda', 'Lal', 'Engineering', 'Singapore', 'Nanda.Lal@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151545, 'Rithy', 'Khun', 'Engineering', 'Singapore', 'Rithy.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151546, 'Mani', 'Choudhury', 'Engineering', 'Indonesia ', 'Mani.Choudhury@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151547, 'Koh', 'Loo', 'Engineering', 'Singapore', 'Koh.Loo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151548, 'Arifin', 'Bakar', 'Engineering', 'Malaysia', 'Arifin.Bakar@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151549, 'Kumari', 'Pillai', 'Engineering', 'Singapore', 'Kumari.Pillai@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151550, 'Narong', 'Chua', 'Engineering', 'Vietnam', 'Narong.Chua@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151556, 'Thi', 'Ling', 'Engineering', 'Singapore', 'Thi.Ling@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151558, 'Vannak', 'Seng', 'Engineering', 'Singapore', 'Vannak.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151559, 'Nara', 'Loo', 'Engineering', 'Hong Kong', 'Nara.Loo@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151560, 'Somchai', 'Kong', 'Engineering', 'Singapore', 'Somchai.Kong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151561, 'Rath', 'Khun', 'Engineering', 'Singapore', 'Rath.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151562, 'Chinh', 'Nguyen', 'Engineering', 'Singapore', 'Chinh.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151563, 'Yee', 'Chong', 'Engineering', 'Singapore', 'Yee.Chong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151564, 'Heng', 'Phal', 'Engineering', 'Singapore', 'Heng.Phal@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151567, 'Sokunthea', 'Seng', 'Engineering', 'Singapore', 'Sokunthea.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151568, 'Champa', 'Pheap', 'Engineering', 'Indonesia ', 'Champa.Pheap@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151570, 'Rahim', 'Harun', 'Engineering', 'Singapore', 'Rahim.Harun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151571, 'Hakim', 'Sulaiman', 'Engineering', 'Malaysia', 'Hakim.Sulaiman@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151573, 'Trung', 'Nguyen', 'Engineering', 'Singapore', 'Trung.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151574, 'Seng', 'Sao', 'Engineering', 'Vietnam', 'Seng.Sao@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151575, 'Narong', 'Savoeun', 'Engineering', 'Singapore', 'Narong.Savoeun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151576, 'Phuc', 'Luong', 'Engineering', 'Singapore', 'Phuc.Luong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151578, 'Chandara', 'Tith', 'Engineering', 'Hong Kong', 'Chandara.Tith@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151579, 'Soma', 'Voeun', 'Engineering', 'Singapore', 'Soma.Voeun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151580, 'Siv', 'Sothea', 'Engineering', 'Singapore', 'Siv.Sothea@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151581, 'Vannak', 'Samnang', 'Engineering', 'Singapore', 'Vannak.Samnang@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151582, 'Kumara', 'Sareth', 'Engineering', 'Singapore', 'Kumara.Sareth@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151583, 'Sok', 'Kheng', 'Engineering', 'Singapore', 'Sok.Kheng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151584, 'Siti', 'Yusuf', 'Engineering', 'Singapore', 'Siti.Yusuf@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151585, 'Chanh', 'Tith', 'Engineering', 'Indonesia ', 'Chanh.Tith@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151589, 'Anh', 'Van', 'Engineering', 'Singapore', 'Anh.Van@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151590, 'Priya', 'Kumar', 'Engineering', 'Malaysia', 'Priya.Kumar@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151591, 'Nanda', 'Kesavan', 'Engineering', 'Singapore', 'Nanda.Kesavan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151593, 'Rithy', 'Sok', 'Engineering', 'Vietnam', 'Rithy.Sok@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151595, 'Mani', 'Devi', 'Engineering', 'Singapore', 'Mani.Devi@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151596, 'Koh', 'Seng', 'Engineering', 'Singapore', 'Koh.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151597, 'Arifin', 'Saputra', 'Engineering', 'Hong Kong', 'Arifin.Saputra@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(151598, 'Kumari', 'Pillai', 'Engineering', 'Singapore', 'Kumari.Pillai@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151600, 'Narong', 'Chua', 'Engineering', 'Singapore', 'Narong.Chua@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(151601, 'Thi', 'Ling', 'Engineering', 'Singapore', 'Thi.Ling@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151602, 'Vannak', 'Seng', 'Engineering', 'Singapore', 'Vannak.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151603, 'Phuong', 'Truong', 'Engineering', 'Singapore', 'Phuong.Truong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151605, 'Srey', 'Suon', 'Engineering', 'Singapore', 'Srey.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151606, 'Hlaing', 'Myat', 'Engineering', 'Indonesia ', 'Hlaing.Myat@allinone.com.id', 2);
INSERT INTO `staff` VALUES(151607, 'Anh', 'Vo', 'Engineering', 'Singapore', 'Anh.Vo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151608, 'Chin', 'Chen', 'Engineering', 'Malaysia', 'Chin.Chen@allinone.com.my', 2);
INSERT INTO `staff` VALUES(151609, 'Nara', 'Loo', 'Engineering', 'Singapore', 'Nara.Loo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151610, 'Somchai', 'Kong', 'Engineering', 'Vietnam', 'Somchai.Kong@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(151611, 'Rath', 'Khun', 'Engineering', 'Singapore', 'Rath.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151612, 'Chinh', 'Nguyen', 'Engineering', 'Singapore', 'Chinh.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(151613, 'Yee', 'Chong', 'Engineering', 'Hong Kong', 'Yee.Chong@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(160008, 'Sally', 'Loh', 'HR', 'Singapore', 'Sally.Loh@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160065, 'John', 'Tan', 'HR', 'Singapore', 'John.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160075, 'James', 'Tan', 'HR', 'Singapore', 'James.Tan@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(160076, 'Jack', 'Goh', 'HR', 'Singapore', 'Jack.Goh@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160118, 'Derek', 'Chan', 'HR', 'Singapore', 'Derek.Chan@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160135, 'Jaclyn', 'Ong', 'HR', 'Singapore', 'Jaclyn.Ong@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160142, 'Benjamin', 'Teo', 'HR', 'Singapore', 'Benjamin.Teo@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160143, 'Lucas', 'Lee', 'HR', 'Singapore', 'Lucas.Lee@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160145, 'Mary', 'Wong', 'HR', 'Singapore', 'Mary.Wong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160146, 'Oliva', 'Yong', 'HR', 'Singapore', 'Oliva.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160148, 'Henry', 'Lim', 'HR', 'Singapore', 'Henry.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160155, 'Alexander', 'Heng', 'HR', 'Singapore', 'Alexander.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160188, 'Emma', 'Toh', 'HR', 'Singapore', 'Emma.Toh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160212, 'Charlotte', 'The', 'HR', 'Singapore', 'Charlotte.The@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160213, 'Amelia', 'Ng', 'HR', 'Singapore', 'Amelia.Ng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160218, 'Eva', 'Tan', 'HR', 'Singapore', 'Eva.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160225, 'Sophia', 'Fu', 'HR', 'Singapore', 'Sophia.Fu@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160258, 'Michael', 'Tong', 'HR', 'Singapore', 'Michael.Tong@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160282, 'Ethan', 'Loh', 'HR', 'Singapore', 'Ethan.Loh@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160283, 'Somchai', 'Kong', 'HR', 'Singapore', 'Somchai.Kong@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160284, 'Rath', 'Khun', 'HR', 'Singapore', 'Rath.Khun@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160286, 'Chinh', 'Nguyen', 'HR', 'Singapore', 'Chinh.Nguyen@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160287, 'Yee', 'Chong', 'HR', 'Singapore', 'Yee.Chong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160288, 'Heng', 'Phal', 'HR', 'Singapore', 'Heng.Phal@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160289, 'Sokunthea', 'Seng', 'HR', 'Singapore', 'Sokunthea.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160290, 'Champa', 'Pheap', 'HR', 'Singapore', 'Champa.Pheap@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160291, 'Rahim', 'Harun', 'HR', 'Singapore', 'Rahim.Harun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160293, 'Hakim', 'Sulaiman', 'HR', 'Singapore', 'Hakim.Sulaiman@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160294, 'Trung', 'Nguyen', 'HR', 'Singapore', 'Trung.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160295, 'Seng', 'Sao', 'HR', 'Singapore', 'Seng.Sao@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160296, 'Narong', 'Savoeun', 'HR', 'Singapore', 'Narong.Savoeun@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160297, 'Phuc', 'Luong', 'HR', 'Singapore', 'Phuc.Luong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160298, 'Chandara', 'Tith', 'HR', 'Singapore', 'Chandara.Tith@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160299, 'Soma', 'Voeun', 'HR', 'Singapore', 'Soma.Voeun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160300, 'Siv', 'Sothea', 'HR', 'Singapore', 'Siv.Sothea@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160301, 'Vannak', 'Samnang', 'HR', 'Singapore', 'Vannak.Samnang@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160302, 'Kumara', 'Sareth', 'HR', 'Singapore', 'Kumara.Sareth@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(160303, 'Sok', 'Kheng', 'HR', 'Singapore', 'Sok.Kheng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160304, 'Siti', 'Yusuf', 'HR', 'Singapore', 'Siti.Yusuf@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160305, 'Chanh', 'Tith', 'HR', 'Singapore', 'Chanh.Tith@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160306, 'Anh', 'Van', 'HR', 'Singapore', 'Anh.Van@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(160307, 'Priya', 'Kumar', 'HR', 'Singapore', 'Priya.Kumar@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160308, 'Nanda', 'Kesavan', 'HR', 'Singapore', 'Nanda.Kesavan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160313, 'Rithy', 'Sok', 'HR', 'Singapore', 'Rithy.Sok@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160314, 'Mani', 'Devi', 'HR', 'Singapore', 'Mani.Devi@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160315, 'Koh', 'Seng', 'HR', 'Singapore', 'Koh.Seng@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160316, 'Arifin', 'Saputra', 'HR', 'Singapore', 'Arifin.Saputra@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160317, 'Kumari', 'Pillai', 'HR', 'Singapore', 'Kumari.Pillai@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160318, 'Narong', 'Chua', 'HR', 'Singapore', 'Narong.Chua@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(160323, 'Thi', 'Ling', 'HR', 'Singapore', 'Thi.Ling@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160324, 'Vannak', 'Seng', 'HR', 'Singapore', 'Vannak.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160325, 'Phuong', 'Truong', 'HR', 'Singapore', 'Phuong.Truong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160326, 'Srey', 'Suon', 'HR', 'Singapore', 'Srey.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160328, 'Hlaing', 'Myat', 'HR', 'Singapore', 'Hlaing.Myat@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(160329, 'Anh', 'Vo', 'HR', 'Singapore', 'Anh.Vo@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160330, 'Chin', 'Chen', 'HR', 'Singapore', 'Chin.Chen@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160331, 'Nara', 'Loo', 'HR', 'Singapore', 'Nara.Loo@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160332, 'Somchai', 'Kong', 'HR', 'Singapore', 'Somchai.Kong@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160333, 'Rath', 'Khun', 'HR', 'Singapore', 'Rath.Khun@allinone.com.sg', 4);
INSERT INTO `staff` VALUES(160334, 'Chinh', 'Nguyen', 'HR', 'Singapore', 'Chinh.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160335, 'Yee', 'Chong', 'HR', 'Singapore', 'Yee.Chong@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(160336, 'Heng', 'Phal', 'HR', 'Singapore', 'Heng.Phal@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160337, 'Sokunthea', 'Seng', 'HR', 'Singapore', 'Sokunthea.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160338, 'Champa', 'Pheap', 'HR', 'Singapore', 'Champa.Pheap@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(160339, 'Rahim', 'Harun', 'HR', 'Singapore', 'Rahim.Harun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170166, 'David', 'Yap', 'Finance', 'Singapore', 'David.Yap@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(170208, 'Daniel', 'Tan', 'Finance', 'Singapore', 'Daniel.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170215, 'Mary', 'Wong', 'Finance', 'Singapore', 'Mary.Wong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170216, 'Jaclyn', 'Ong', 'Finance', 'Singapore', 'Jaclyn.Ong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170232, 'Jacob', 'Tan', 'Finance', 'Singapore', 'Jacob.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170233, 'Logan', 'Goh', 'Finance', 'Singapore', 'Logan.Goh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170238, 'Jackson', 'Chan', 'Finance', 'Singapore', 'Jackson.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170245, 'Aiden', 'Teo', 'Finance', 'Singapore', 'Aiden.Teo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170655, 'Samuel', 'Lee', 'Finance', 'Singapore', 'Samuel.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(170866, 'Susan', 'Lim', 'Finance', 'Singapore', 'Susan.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171008, 'Janice', 'Heng', 'Finance', 'Singapore', 'Janice.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171009, 'Nanda', 'Kesavan', 'Finance', 'Singapore', 'Nanda.Kesavan@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(171010, 'Rithy', 'Sok', 'Finance', 'Singapore', 'Rithy.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171011, 'Mani', 'Devi', 'Finance', 'Singapore', 'Mani.Devi@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171012, 'Koh', 'Seng', 'Finance', 'Singapore', 'Koh.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171013, 'Arifin', 'Saputra', 'Finance', 'Singapore', 'Arifin.Saputra@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171014, 'Kumari', 'Pillai', 'Finance', 'Singapore', 'Kumari.Pillai@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(171015, 'Narong', 'Chua', 'Finance', 'Singapore', 'Narong.Chua@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171016, 'Thi', 'Ling', 'Finance', 'Singapore', 'Thi.Ling@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171017, 'Vannak', 'Seng', 'Finance', 'Singapore', 'Vannak.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171018, 'Phuong', 'Truong', 'Finance', 'Singapore', 'Phuong.Truong@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(171022, 'Srey', 'Suon', 'Finance', 'Singapore', 'Srey.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171023, 'Hlaing', 'Myat', 'Finance', 'Singapore', 'Hlaing.Myat@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171024, 'Anh', 'Vo', 'Finance', 'Singapore', 'Anh.Vo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171026, 'Chin', 'Chen', 'Finance', 'Singapore', 'Chin.Chen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171027, 'Nara', 'Loo', 'Finance', 'Singapore', 'Nara.Loo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171029, 'Somchai', 'Kong', 'Finance', 'Singapore', 'Somchai.Kong@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(171030, 'Rath', 'Khun', 'Finance', 'Singapore', 'Rath.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171031, 'Chinh', 'Nguyen', 'Finance', 'Singapore', 'Chinh.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171032, 'Yee', 'Chong', 'Finance', 'Singapore', 'Yee.Chong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171033, 'Heng', 'Phal', 'Finance', 'Singapore', 'Heng.Phal@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171034, 'Sokunthea', 'Seng', 'Finance', 'Singapore', 'Sokunthea.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171035, 'Champa', 'Pheap', 'Finance', 'Singapore', 'Champa.Pheap@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171036, 'Rahim', 'Harun', 'Finance', 'Singapore', 'Rahim.Harun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171038, 'Hakim', 'Sulaiman', 'Finance', 'Singapore', 'Hakim.Sulaiman@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171039, 'Trung', 'Nguyen', 'Finance', 'Singapore', 'Trung.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171041, 'Seng', 'Sao', 'Finance', 'Singapore', 'Seng.Sao@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171042, 'Narong', 'Savoeun', 'Finance', 'Singapore', 'Narong.Savoeun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171043, 'Phuc', 'Luong', 'Finance', 'Singapore', 'Phuc.Luong@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(171044, 'Chandara', 'Tith', 'Finance', 'Singapore', 'Chandara.Tith@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171045, 'Soma', 'Voeun', 'Finance', 'Singapore', 'Soma.Voeun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171046, 'Siv', 'Sothea', 'Finance', 'Singapore', 'Siv.Sothea@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171047, 'Vannak', 'Samnang', 'Finance', 'Singapore', 'Vannak.Samnang@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(171048, 'Kumara', 'Sareth', 'Finance', 'Singapore', 'Kumara.Sareth@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180001, 'Ernst', 'Sim', 'Consultancy', 'Singapore', 'Ernst.Sim@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(180002, 'Rithy', 'Chheng', 'Consultancy', 'Singapore', 'Rithy.Chheng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180003, 'Mani', 'Raj', 'Consultancy', 'Singapore', 'Mani.Raj@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180004, 'Sokunthea', 'Phan', 'Consultancy', 'Singapore', 'Sokunthea.Phan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180005, 'Mani', 'Devi', 'Consultancy', 'Singapore', 'Mani.Devi@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180006, 'Somnang', 'Suon', 'Consultancy', 'Singapore', 'Somnang.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180010, 'Samsul', 'Rahman', 'Consultancy', 'Singapore', 'Samsul.Rahman@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180011, 'Rath', 'Phan', 'Consultancy', 'Singapore', 'Rath.Phan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180012, 'Ji', 'Han', 'Consultancy', 'Singapore', 'Ji.Han@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(180013, 'Sok', 'Pich', 'Consultancy', 'Singapore', 'Sok.Pich@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180014, 'Minh', 'Hoang', 'Consultancy', 'Singapore', 'Minh.Hoang@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180015, 'Anil', 'Kumar', 'Consultancy', 'Singapore', 'Anil.Kumar@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180019, 'Chinh', 'Le', 'Consultancy', 'Singapore', 'Chinh.Le@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180020, 'Seng', 'Seng', 'Consultancy', 'Singapore', 'Seng.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180021, 'Nanda', 'Kesavan', 'Consultancy', 'Singapore', 'Nanda.Kesavan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180022, 'Amirah', 'Ahmad', 'Consultancy', 'Singapore', 'Amirah.Ahmad@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180023, 'Sokly', 'Sok', 'Consultancy', 'Singapore', 'Sokly.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180025, 'Trung', 'Pham', 'Consultancy', 'Singapore', 'Trung.Pham@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180026, 'Rithya', 'Suon', 'Consultancy', 'Singapore', 'Rithya.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180027, 'Phuc', 'Vo', 'Consultancy', 'Singapore', 'Phuc.Vo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180029, 'Chandra', 'Pandey', 'Consultancy', 'Singapore', 'Chandra.Pandey@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(180030, 'Manoj', 'Singh', 'Consultancy', 'Singapore', 'Manoj.Singh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180032, 'Phalla', 'Yong', 'Consultancy', 'Singapore', 'Phalla.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180033, 'Chhaya', 'Sou', 'Consultancy', 'Singapore', 'Chhaya.Sou@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180034, 'Soma', 'Lim', 'Consultancy', 'Singapore', 'Soma.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180036, 'Siv', 'Sun', 'Consultancy', 'Singapore', 'Siv.Sun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180037, 'Vannak', 'Mao', 'Consultancy', 'Singapore', 'Vannak.Mao@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(180038, 'Kumara', 'Seng', 'Consultancy', 'Singapore', 'Kumara.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190003, 'Sok', 'Heng', 'Solutioning', 'Singapore', 'Sok.Heng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190004, 'Siti', 'Saad', 'Solutioning', 'Singapore', 'Siti.Saad@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190005, 'Chanh', 'Ly', 'Solutioning', 'Singapore', 'Chanh.Ly@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190006, 'Anh', 'Truong', 'Solutioning', 'Singapore', 'Anh.Truong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190008, 'Hakim', 'Rahman', 'Solutioning', 'Singapore', 'Hakim.Rahman@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190009, 'Priya', 'Kaur', 'Solutioning', 'Singapore', 'Priya.Kaur@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190010, 'Narong', 'Chen', 'Solutioning', 'Singapore', 'Narong.Chen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190014, 'Rin', 'Sok', 'Solutioning', 'Singapore', 'Rin.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190015, 'Phuc', 'Lam', 'Solutioning', 'Singapore', 'Phuc.Lam@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190016, 'Sok', 'Chin', 'Solutioning', 'Singapore', 'Sok.Chin@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190017, 'Chandara', 'Kong', 'Solutioning', 'Singapore', 'Chandara.Kong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190018, 'Phanith', 'Sok', 'Solutioning', 'Singapore', 'Phanith.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190019, 'Heng', 'Sim', 'Solutioning', 'Singapore', 'Heng.Sim@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(190021, 'Nanda', 'Devan', 'Solutioning', 'Singapore', 'Nanda.Devan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190022, 'Pich', 'Phan', 'Solutioning', 'Singapore', 'Pich.Phan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190024, 'Anil', 'Sarawat', 'Solutioning', 'Singapore', 'Anil.Sarawat@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190025, 'Nguyen', 'Tuan', 'Solutioning', 'Singapore', 'Nguyen.Tuan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190026, 'Bao', 'Kim', 'Solutioning', 'Singapore', 'Bao.Kim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190027, 'Boun', 'Sok', 'Solutioning', 'Singapore', 'Boun.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190028, 'Soma', 'Khun', 'Solutioning', 'Singapore', 'Soma.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190029, 'Samsul', 'Saifullah', 'Solutioning', 'Singapore', 'Samsul.Saifullah@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190030, 'Rina', 'Li', 'Solutioning', 'Singapore', 'Rina.Li@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190031, 'Mani', 'Prasad', 'Solutioning', 'Singapore', 'Mani.Prasad@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190032, 'Koh', 'Seng', 'Solutioning', 'Singapore', 'Koh.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190033, 'Arifin', 'Siregar', 'Solutioning', 'Singapore', 'Arifin.Siregar@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190035, 'Kumari', 'Devi', 'Solutioning', 'Singapore', 'Kumari.Devi@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190036, 'Narong', 'Khun', 'Solutioning', 'Singapore', 'Narong.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190037, 'Siti', 'Abdullah', 'Solutioning', 'Singapore', 'Siti.Abdullah@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(190038, 'Heng', 'Chan', 'Solutioning', 'Singapore', 'Heng.Chan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190040, 'Rina', 'Tan', 'Solutioning', 'Singapore', 'Rina.Tan@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190041, 'Boun', 'Souk', 'Solutioning', 'Singapore', 'Boun.Souk@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190042, 'Aung', 'Kyaw', 'Solutioning', 'Singapore', 'Aung.Kyaw@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190043, 'Thuy', 'Nguyen', 'Solutioning', 'Singapore', 'Thuy.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190044, 'Rajesh', 'Kumar', 'Solutioning', 'Singapore', 'Rajesh.Kumar@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190045, 'Koh', 'Lim', 'Solutioning', 'Singapore', 'Koh.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190046, 'Somchai', 'Somboon', 'Solutioning', 'Singapore', 'Somchai.Somboon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190047, 'Seng', 'Lee', 'Solutioning', 'Singapore', 'Seng.Lee@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190048, 'Anh', 'Tran', 'Solutioning', 'Singapore', 'Anh.Tran@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190049, 'Ratana', 'Chen', 'Solutioning', 'Singapore', 'Ratana.Chen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190050, 'Bui', 'Nguyen', 'Solutioning', 'Singapore', 'Bui.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190051, 'Rahim', 'Khalid', 'Solutioning', 'Singapore', 'Rahim.Khalid@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190052, 'Dewi', 'Putri', 'Solutioning', 'Singapore', 'Dewi.Putri@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190054, 'Sokha', 'Seng', 'Solutioning', 'Singapore', 'Sokha.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190055, 'Tuan', 'Nguyen', 'Solutioning', 'Singapore', 'Tuan.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190056, 'Bao', 'Luu', 'Solutioning', 'Singapore', 'Bao.Luu@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190057, 'Amara', 'Singh', 'Solutioning', 'Singapore', 'Amara.Singh@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190058, 'Srey', 'Mao', 'Solutioning', 'Singapore', 'Srey.Mao@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190059, 'Phuc', 'Le', 'Solutioning', 'Singapore', 'Phuc.Le@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(190064, 'Arifin', 'Saputra', 'Solutioning', 'Singapore', 'Arifin.Saputra@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190065, 'Siti', 'Salleh', 'Solutioning', 'Malaysia', 'Siti.Salleh@allinone.com.my', 2);
INSERT INTO `staff` VALUES(190066, 'Rina', 'Siriporn', 'Solutioning', 'Malaysia', 'Rina.Siriporn@allinone.com.my', 2);
INSERT INTO `staff` VALUES(190067, 'Minh', 'Ly', 'Solutioning', 'Malaysia', 'Minh.Ly@allinone.com.my', 3);
INSERT INTO `staff` VALUES(190068, 'Chandara', 'Kim', 'Solutioning', 'Malaysia', 'Chandara.Kim@allinone.com.my', 2);
INSERT INTO `staff` VALUES(190069, 'Heng', 'Phan', 'Solutioning', 'Indonesia ', 'Heng.Phan@allinone.com.id', 2);
INSERT INTO `staff` VALUES(190070, 'Nara', 'Khun', 'Solutioning', 'Indonesia ', 'Nara.Khun@allinone.com.id', 3);
INSERT INTO `staff` VALUES(190074, 'Priya', 'Malik', 'Solutioning', 'Indonesia ', 'Priya.Malik@allinone.com.id', 2);
INSERT INTO `staff` VALUES(190075, 'Ngoc', 'Trinh', 'Solutioning', 'Indonesia ', 'Ngoc.Trinh@allinone.com.id', 2);
INSERT INTO `staff` VALUES(190076, 'Manoj', 'Kumar', 'Solutioning', 'Indonesia ', 'Manoj.Kumar@allinone.com.id', 2);
INSERT INTO `staff` VALUES(190077, 'Anh', 'Pham', 'Solutioning', 'Vietnam', 'Anh.Pham@allinone.com.vn', 3);
INSERT INTO `staff` VALUES(190078, 'Somsak', 'Somsri', 'Solutioning', 'Vietnam', 'Somsak.Somsri@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(190079, 'Chin', 'Lim', 'Solutioning', 'Vietnam', 'Chin.Lim@allinone.com.vn', 2);
INSERT INTO `staff` VALUES(190080, 'Sok', 'Chhay', 'Solutioning', 'Hong Kong', 'Sok.Chhay@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(190082, 'Tat', 'Nguyen', 'Solutioning', 'Hong Kong', 'Tat.Nguyen@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(190086, 'Hlaing', 'Sithu', 'Solutioning', 'Hong Kong', 'Hlaing.Sithu@allinone.com.hk', 3);
INSERT INTO `staff` VALUES(190087, 'Santhi', 'Perumal', 'Solutioning', 'Hong Kong', 'Santhi.Perumal@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(190088, 'Hakim', 'Siregar', 'Solutioning', 'Hong Kong', 'Hakim.Siregar@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(190089, 'Sirirat', 'Chaiyaporn', 'Solutioning', 'Hong Kong', 'Sirirat.Chaiyaporn@allinone.com.hk', 2);
INSERT INTO `staff` VALUES(190091, 'Chinh', 'Tran', 'Solutioning', 'Singapore', 'Chinh.Tran@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190092, 'Siti', 'Ahmad', 'Solutioning', 'Singapore', 'Siti.Ahmad@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190093, 'Chandra', 'Rai', 'Solutioning', 'Singapore', 'Chandra.Rai@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(190094, 'Ratana', 'Keo', 'Solutioning', 'Singapore', 'Ratana.Keo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190095, 'Yee', 'Lim', 'Solutioning', 'Singapore', 'Yee.Lim@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190096, 'Wai', 'Yong', 'Solutioning', 'Singapore', 'Wai.Yong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190097, 'Thi', 'Pham', 'Solutioning', 'Singapore', 'Thi.Pham@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(190098, 'Nara', 'Sok', 'Solutioning', 'Singapore', 'Nara.Sok@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210001, 'Peter', 'Yap', 'IT', 'Singapore', 'Peter.aypallinone.com.sg', 3);
INSERT INTO `staff` VALUES(210017, 'Rithy', 'Sok', 'IT', 'Singapore', 'Kumara.Sareth@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210018, 'Mani', 'Devi', 'IT', 'Singapore', 'Rithy.Sok@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(210019, 'Koh', 'Seng', 'IT', 'Singapore', 'Mani.Devi@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210020, 'Arifin', 'Saputra', 'IT', 'Singapore', 'Koh.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210021, 'Kumari', 'Pillai', 'IT', 'Singapore', 'Arifin.Saputra@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210022, 'Narong', 'Chua', 'IT', 'Singapore', 'Kumari.Pillai@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210023, 'Thi', 'Ling', 'IT', 'Singapore', 'Narong.Chua@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210024, 'Vannak', 'Seng', 'IT', 'Singapore', 'Thi.Ling@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210025, 'Phuong', 'Truong', 'IT', 'Singapore', 'Vannak.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210026, 'Srey', 'Suon', 'IT', 'Singapore', 'Phuong.Truong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210027, 'Hlaing', 'Myat', 'IT', 'Singapore', 'Srey.Suon@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210028, 'Anh', 'Vo', 'IT', 'Singapore', 'Hlaing.Myat@allinone.com.sg', 3);
INSERT INTO `staff` VALUES(210029, 'Chin', 'Chen', 'IT', 'Singapore', 'Anh.Vo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210030, 'Nara', 'Loo', 'IT', 'Singapore', 'Chin.Chen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210031, 'Somchai', 'Kong', 'IT', 'Singapore', 'Nara.Loo@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210032, 'Rath', 'Khun', 'IT', 'Singapore', 'Somchai.Kong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210033, 'Chinh', 'Nguyen', 'IT', 'Singapore', 'Rath.Khun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210034, 'Yee', 'Chong', 'IT', 'Singapore', 'Chinh.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210035, 'Heng', 'Phal', 'IT', 'Singapore', 'Yee.Chong@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210036, 'Sokunthea', 'Seng', 'IT', 'Singapore', 'Heng.Phal@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210037, 'Champa', 'Pheap', 'IT', 'Singapore', 'Sokunthea.Seng@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210038, 'Rahim', 'Harun', 'IT', 'Singapore', 'Champa.Pheap@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210039, 'Hakim', 'Sulaiman', 'IT', 'Singapore', 'Rahim.Harun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210040, 'Trung', 'Nguyen', 'IT', 'Singapore', 'Hakim.Sulaiman@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210041, 'Seng', 'Sao', 'IT', 'Singapore', 'Trung.Nguyen@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210042, 'Narong', 'Savoeun', 'IT', 'Singapore', 'Seng.Sao@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210043, 'Phuc', 'Luong', 'IT', 'Singapore', 'Narong.Savoeun@allinone.com.sg', 2);
INSERT INTO `staff` VALUES(210044, 'Chandara', 'Tith', 'IT', 'Singapore', 'Phuc.Luong@allinone.com.sg', 2);
-- Table structure for table `role_listing`
DROP TABLE IF EXISTS `role_listing`;
CREATE TABLE IF NOT EXISTS `role_listing` (
`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`Role_Name` varchar(20) NOT NULL REFERENCES role(Role_Name),
`Start_Date` date NOT NULL,
`End_Date` date NOT NULL,
`Manager_ID` int NOT NULL REFERENCES staff(Staff_ID),
`Country` varchar(50) NOT NULL,
CONSTRAINT unique_combination_constraint UNIQUE (`Role_Name`, `Start_Date`, `End_Date`, `Manager_ID`, `Country`)
);
-- insert data into role_listing
INSERT INTO `role_listing` VALUES(34, 'Call Centre', '2023-10-26', '2023-11-11', 190077, 'Malaysia');
INSERT INTO `role_listing` VALUES(35, 'Consultancy Director', '2023-10-26', '2023-12-06', 151410, 'Indonesia');
INSERT INTO `role_listing` VALUES(36, 'Consultant', '2023-10-26', '2023-12-28', 150866, 'Indonesia');
-- Table structure for table `application`
DROP TABLE IF EXISTS `application`;
CREATE TABLE IF NOT EXISTS `application` (
`id` int NOT NULL AUTO_INCREMENT,
`Listing_ID` int NOT NULL REFERENCES role_listing(id),
`Staff_ID` int NOT NULL REFERENCES staff(Staff_ID),
`App_Desc` longtext,
`App_Date` date NOT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `application` VALUES(3, 36, 140002, 'As an experienced consultant, I bring a unique blend of expertise, strategic thinking, and exceptional problem-solving skills to every project I undertake. With a passion for delivering measurable results and driving impactful change, I am dedicated to helping organizations achieve their goals and overcome their challenges.\n\nMy professional background includes a successful track record in providing consultancy services across various industries, including but not limited to finance, technology, and marketing. I have been entrusted with advising clients of all sizes, from startups to Fortune 500 companies, offering valuable insights and innovative strategies to optimize processes, improve efficiency, and enhance overall performance.\n\nOne of my key strengths lies in my ability to quickly understand complex business environments and identify areas for improvement. I have a sound analytical mindset, combined with a strong expertise in data analysis and research, allowing me to accurately assess client needs and develop comprehensive recommendations tailored to their specific circumstances.\n\nI am known for my excellent communication skills, which enable me to effectively articulate ideas and concepts to clients at all levels of the organization. I am equally comfortable providing clear instructions to operational staff as I am presenting findings and proposals to C-level executives. My ability to build strong, professional relationships allows me to establish trust with clients and collaborate seamlessly with stakeholders to drive successful outcomes.\n\nIn addition to my technical skills, I am a continuous learner, always staying up to date with the latest industry trends and best practices. I actively seek opportunities to expand my knowledge and skill set through professional development courses and certifications, ensuring that I am equipped with the most relevant information and tools to deliver top-notch consultancy services.\n\nOverall, I am a highly motivated and results-driven consultant with a deep passion for helping organizations succeed. With my combination of industry expertise, excellent problem-solving abilities, and strong interpersonal skills, I am confident in my ability to make a positive impact and deliver exceptional value to any consulting project I am involved in.', '2023-10-26');
INSERT INTO `application` VALUES(4, 35, 140002, 'As a Director in engineering, I am a dynamic individual with a strong background in technical expertise and leadership skills. With a keen eye for detail and a strategic mindset, I am dedicated to ensuring project success while fostering a collaborative and innovative work environment. I possess excellent interpersonal and communication skills, allowing me to effectively communicate with cross-functional teams and stakeholders at all levels. Leveraging my extensive industry knowledge and experience, I thrive in driving efficiency, implementing best practices, and making informed decisions to achieve optimal results. My passion for engineering, coupled with my ability to inspire and motivate teams, makes me a valuable asset in the role of Director.', '2023-10-26');
INSERT INTO `application` VALUES(5, 34, 140002, 'As a Call Centre Executive, I am a customer-focused professional with a passion for delivering exceptional service. With a strong background in handling customer inquiries, resolving issues, and managing high call volumes, I am dedicated to ensuring customer satisfaction at all times. I possess excellent communication and problem-solving skills, allowing me to effectively handle challenging situations and provide accurate information to customers. I am highly organized and detail-oriented, ensuring that all customer interactions are documented accurately and efficiently. My ability to multitask and work well under pressure enables me to meet and exceed performance targets, while maintaining a positive and professional attitude. As a Call Centre Executive, I am committed to creating positive customer experiences and contributing to the overall success of the team.', '2023-10-26');
INSERT INTO `application` VALUES(6, 36, 140893, 'Self-description for a Consultant Role:\n\nAs an experienced consultant, I bring a unique blend of expertise, strategic thinking, and exceptional problem-solving skills to every project I undertake. With a passion for delivering measurable results and driving impactful change, I am dedicated to helping organizations achieve their goals and overcome their challenges.\n\nMy professional background includes a successful track record in providing consultancy services across various industries, including but not limited to finance, technology, and marketing. I have been entrusted with advising clients of all sizes, from startups to Fortune 500 companies, offering valuable insights and innovative strategies to optimize processes, improve efficiency, and enhance overall performance.\n\nOne of my key strengths lies in my ability to quickly understand complex business environments and identify areas for improvement. I have a sound analytical mindset, combined with a strong expertise in data analysis and research, allowing me to accurately assess client needs and develop comprehensive recommendations tailored to their specific circumstances.\n\nI am known for my excellent communication skills, which enable me to effectively articulate ideas and concepts to clients at all levels of the organization. I am equally comfortable providing clear instructions to operational staff as I am presenting findings and proposals to C-level executives. My ability to build strong, professional relationships allows me to establish trust with clients and collaborate seamlessly with stakeholders to drive successful outcomes.\n\nIn addition to my technical skills, I am a continuous learner, always staying up to date with the latest industry trends and best practices. I actively seek opportunities to expand my knowledge and skill set through professional development courses and certifications, ensuring that I am equipped with the most relevant information and tools to deliver top-notch consultancy services.\n\nOverall, I am a highly motivated and results-driven consultant with a deep passion for helping organizations succeed. With my combination of industry expertise, excellent problem-solving abilities, and strong interpersonal skills, I am confident in my ability to make a positive impact and deliver exceptional value to any consulting project I am involved in.', '2023-10-26');
-- Table structure for table `role_skill`
DROP TABLE IF EXISTS `role_skill`;
CREATE TABLE IF NOT EXISTS `role_skill` (
`Role_Name` varchar(20) NOT NULL REFERENCES role(Role_Name),
`Skill_Name` varchar(50) NOT NULL REFERENCES skill(Skill_Name),
PRIMARY KEY (`Role_Name`,`Skill_Name`)
);
-- insert data into role_skill
INSERT INTO `role_skill` VALUES('Account Manager', 'Account Management');
INSERT INTO `role_skill` VALUES('Account Manager', 'Budgeting');
INSERT INTO `role_skill` VALUES('Account Manager', 'Business Development');
INSERT INTO `role_skill` VALUES('Account Manager', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('Account Manager', 'Business Negotiation');
INSERT INTO `role_skill` VALUES('Account Manager', 'Collaboration');
INSERT INTO `role_skill` VALUES('Account Manager', 'Communication');
INSERT INTO `role_skill` VALUES('Account Manager', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Account Manager', 'Pricing Strategy');
INSERT INTO `role_skill` VALUES('Account Manager', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Account Manager', 'Product Management');
INSERT INTO `role_skill` VALUES('Account Manager', 'Sales Strategy');
INSERT INTO `role_skill` VALUES('Account Manager', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Admin Executive', 'Collaboration');
INSERT INTO `role_skill` VALUES('Admin Executive', 'Communication');
INSERT INTO `role_skill` VALUES('Admin Executive', 'Customer Relationship Management');
INSERT INTO `role_skill` VALUES('Admin Executive', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Admin Executive', 'Solutions Design Thinking');
INSERT INTO `role_skill` VALUES('Admin Executive', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Admin Executive', 'Technology Integration');
INSERT INTO `role_skill` VALUES('Call Centre', 'Call Centre Management');
INSERT INTO `role_skill` VALUES('Call Centre', 'Collaboration');
INSERT INTO `role_skill` VALUES('Call Centre', 'Communication');
INSERT INTO `role_skill` VALUES('Call Centre', 'Customer Relationship Management');
INSERT INTO `role_skill` VALUES('Call Centre', 'Digital Fluency');
INSERT INTO `role_skill` VALUES('Call Centre', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Call Centre', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Call Centre', 'Technology Application');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Account Management');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Budgeting');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Business Development');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Communication');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'People and Performance Management');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Problem Management');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Product Management');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Project Management');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Sales Strategy');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Consultancy Director', 'Strategy Planning');
INSERT INTO `role_skill` VALUES('Consultant', 'Account Management');
INSERT INTO `role_skill` VALUES('Consultant', 'Business Development');
INSERT INTO `role_skill` VALUES('Consultant', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('Consultant', 'Collaboration');
INSERT INTO `role_skill` VALUES('Consultant', 'Communication');
INSERT INTO `role_skill` VALUES('Consultant', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Consultant', 'Problem Management');
INSERT INTO `role_skill` VALUES('Consultant', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Consultant', 'Product Management');
INSERT INTO `role_skill` VALUES('Consultant', 'Project Management');
INSERT INTO `role_skill` VALUES('Consultant', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Developer', 'Applications Development');
INSERT INTO `role_skill` VALUES('Developer', 'Applications Integration');
INSERT INTO `role_skill` VALUES('Developer', 'Applications Support and Enhancement');
INSERT INTO `role_skill` VALUES('Developer', 'Business Environment Analysis');
INSERT INTO `role_skill` VALUES('Developer', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('Developer', 'Business Requirements Mapping');
INSERT INTO `role_skill` VALUES('Developer', 'Business Risk Management');
INSERT INTO `role_skill` VALUES('Developer', 'Collaboration');
INSERT INTO `role_skill` VALUES('Developer', 'Communication');
INSERT INTO `role_skill` VALUES('Developer', 'Configuration Tracking');
INSERT INTO `role_skill` VALUES('Developer', 'Database Administration');
INSERT INTO `role_skill` VALUES('Developer', 'Problem Management');
INSERT INTO `role_skill` VALUES('Developer', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Developer', 'Product Management');
INSERT INTO `role_skill` VALUES('Developer', 'Project Management');
INSERT INTO `role_skill` VALUES('Developer', 'Software Configuration');
INSERT INTO `role_skill` VALUES('Developer', 'Software Design');
INSERT INTO `role_skill` VALUES('Developer', 'Software Testing');
INSERT INTO `role_skill` VALUES('Developer', 'Solution Architecture');
INSERT INTO `role_skill` VALUES('Developer', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Developer', 'System Integration');
INSERT INTO `role_skill` VALUES('Developer', 'User Interface Design');
INSERT INTO `role_skill` VALUES('Engineering Director', 'Budgeting');
INSERT INTO `role_skill` VALUES('Engineering Director', 'Communication');
INSERT INTO `role_skill` VALUES('Engineering Director', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Engineering Director', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Engineering Director', 'Technology Road Mapping');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Accounting and Tax Systems');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Accounting Standards');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Audit Compliance');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Collaboration');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Communication');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Financial Closing');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Financial Management');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Financial Reporting');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Financial Transactions');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Professional and Business Ethics');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Project Management');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Sense Making');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Tax Computation');
INSERT INTO `role_skill` VALUES('Finance Executive', 'Tax Implications');
INSERT INTO `role_skill` VALUES('Finance Director', 'Accounting and Tax Systems');
INSERT INTO `role_skill` VALUES('Finance Director', 'Audit Compliance');
INSERT INTO `role_skill` VALUES('Finance Director', 'Communication');
INSERT INTO `role_skill` VALUES('Finance Director', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Finance Director', 'Finance Business Partnering');
INSERT INTO `role_skill` VALUES('Finance Director', 'Financial Management');
INSERT INTO `role_skill` VALUES('Finance Director', 'Financial Planning');
INSERT INTO `role_skill` VALUES('Finance Director', 'Financial Reporting');
INSERT INTO `role_skill` VALUES('Finance Director', 'Professional and Business Ethics');
INSERT INTO `role_skill` VALUES('Finance Director', 'Regulatory Strategy');
INSERT INTO `role_skill` VALUES('Finance Director', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Finance Director', 'Tax Implications');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Accounting and Tax Systems');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Accounting Standards');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Audit Compliance');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Audit Frameworks');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Business Acumen');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Collaboration');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Communication');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Finance Business Partnering');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Financial Management');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Financial Planning');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Financial Reporting');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Financial Statements Analysis');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Professional and Business Ethics');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Project Management');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Regulatory Compliance');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Regulatory Risk Assessment');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Finance Manager', 'Tax Implications');
INSERT INTO `role_skill` VALUES('HR Director', 'Business Acumen');
INSERT INTO `role_skill` VALUES('HR Director', 'Communication');
INSERT INTO `role_skill` VALUES('HR Director', 'Developing People');
INSERT INTO `role_skill` VALUES('HR Director', 'Employee Communication Management');
INSERT INTO `role_skill` VALUES('HR Director', 'Financial Acumen');
INSERT INTO `role_skill` VALUES('HR Director', 'Human Resource Advisory');
INSERT INTO `role_skill` VALUES('HR Director', 'Human Resource Practices Implementation');
INSERT INTO `role_skill` VALUES('HR Director', 'Human Resource Strategy Formulation');
INSERT INTO `role_skill` VALUES('HR Director', 'Organisational Design');
INSERT INTO `role_skill` VALUES('HR Director', 'Project Management');
INSERT INTO `role_skill` VALUES('HR Director', 'Skills Framework Adoption');
INSERT INTO `role_skill` VALUES('HR Director', 'Talent Management');
INSERT INTO `role_skill` VALUES('HR Director', 'Technology Integration');
INSERT INTO `role_skill` VALUES('HR Executive', 'Collaboration');
INSERT INTO `role_skill` VALUES('HR Executive', 'Communication');
INSERT INTO `role_skill` VALUES('HR Executive', 'Digital Fluency');
INSERT INTO `role_skill` VALUES('HR Executive', 'Employee Communication Management');
INSERT INTO `role_skill` VALUES('HR Executive', 'Employee Engagement Management');
INSERT INTO `role_skill` VALUES('HR Executive', 'Human Resource Practices Implementation');
INSERT INTO `role_skill` VALUES('HR Executive', 'Human Resource Systems Management');
INSERT INTO `role_skill` VALUES('HR Executive', 'Onboarding');
INSERT INTO `role_skill` VALUES('HR Executive', 'Skills Framework Adoption');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Collaboration');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Communication');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Infrastructure Deployment');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Infrastructure Support');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Network Administration and Maintenance');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Problem Solving');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Project Management');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Service Level Management');
INSERT INTO `role_skill` VALUES('IT Analyst', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('IT Director', 'Business Acumen');
INSERT INTO `role_skill` VALUES('IT Director', 'Communication');
INSERT INTO `role_skill` VALUES('IT Director', 'Financial Acumen');
INSERT INTO `role_skill` VALUES('IT Director', 'Human Resource Advisory');
INSERT INTO `role_skill` VALUES('IT Director', 'Human Resource Strategy Formulation');
INSERT INTO `role_skill` VALUES('IT Director', 'Human Resource Systems Management');
INSERT INTO `role_skill` VALUES('IT Director', 'Project Management');
INSERT INTO `role_skill` VALUES('IT Director', 'Skills Framework Adoption');
INSERT INTO `role_skill` VALUES('IT Director', 'Technology Integration');
INSERT INTO `role_skill` VALUES('Junior Engineer', 'Collaboration');
INSERT INTO `role_skill` VALUES('Junior Engineer', 'Communication');
INSERT INTO `role_skill` VALUES('Junior Engineer', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Junior Engineer', 'Sense Making');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Collaboration');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Communication');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Employee Communication Management');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Human Resource Practices Implementation');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Human Resource Systems Management');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Learning and Development Programme Management');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Learning Needs Analysis');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Problem Solving');
INSERT INTO `role_skill` VALUES('L&D Executuve', 'Skills Framework Adoption');
INSERT INTO `role_skill` VALUES('Ops Planning Exec', 'Collaboration');
INSERT INTO `role_skill` VALUES('Ops Planning Exec', 'Communication');
INSERT INTO `role_skill` VALUES('Ops Planning Exec', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Ops Planning Exec', 'Project Management');
INSERT INTO `role_skill` VALUES('Ops Planning Exec', 'SOP Development and Implementation');
INSERT INTO `role_skill` VALUES('Sales Director', 'Account Management');
INSERT INTO `role_skill` VALUES('Sales Director', 'Budgeting');
INSERT INTO `role_skill` VALUES('Sales Director', 'Business Development');
INSERT INTO `role_skill` VALUES('Sales Director', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('Sales Director', 'Business Negotiation');
INSERT INTO `role_skill` VALUES('Sales Director', 'Collaboration');
INSERT INTO `role_skill` VALUES('Sales Director', 'Communication');
INSERT INTO `role_skill` VALUES('Sales Director', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Sales Director', 'People and Performance Management');
INSERT INTO `role_skill` VALUES('Sales Director', 'Pricing Strategy');
INSERT INTO `role_skill` VALUES('Sales Director', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Sales Director', 'Product Management');
INSERT INTO `role_skill` VALUES('Sales Director', 'Project Management');
INSERT INTO `role_skill` VALUES('Sales Director', 'Sales Strategy');
INSERT INTO `role_skill` VALUES('Sales Director', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Sales Director', 'Strategy Planning');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Budgeting');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Business Negotiation');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Business Presentation Delivery');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Collaboration');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Communication');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Customer Acquisition Management');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Customer Relationship Management');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Sales Closure');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Strategy Planning');
INSERT INTO `role_skill` VALUES('Sales Manager', 'Technology Integration');
INSERT INTO `role_skill` VALUES('Senior Engineer', 'Automated Equipment and Control Configuration');
INSERT INTO `role_skill` VALUES('Senior Engineer', 'Collaboration');
INSERT INTO `role_skill` VALUES('Senior Engineer', 'Communication');
INSERT INTO `role_skill` VALUES('Senior Engineer', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Account Management');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Budgeting');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Business Development');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Communication');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Data Analytics');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'People and Performance Management');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Problem Management');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Product Management');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Project Management');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Sales Strategy');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Solutioning Director', 'Strategy Planning');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Business Needs Analysis');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Collaboration');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Communication');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Configuration Tracking');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Infrastructure Support');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Network Administration and Maintenance');
INSERT INTO `role_skill` VALUES('Support Engineer', 'People and Performance Management');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Problem Management');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Problem Solving');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Project Management');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Security Administration');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Service Level Management');
INSERT INTO `role_skill` VALUES('Support Engineer', 'Stakeholder Management');
INSERT INTO `role_skill` VALUES('Support Engineer', 'System Integration');
-- Table structure for table `staff_skill`
DROP TABLE IF EXISTS `staff_skill`;
CREATE TABLE IF NOT EXISTS `staff_skill` (