forked from AndersonGroupPHInternal/HROnline
-
Notifications
You must be signed in to change notification settings - Fork 0
/
jobscript
35 lines (35 loc) · 2.76 KB
/
jobscript
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
UPDATE tbl_application SET POSITION = 'H. R.' WHERE POSITION = 1;
UPDATE tbl_application SET POSITION = 'Marketing Manager' WHERE POSITION = 3;
UPDATE tbl_application SET POSITION = 'IT Helpdesk Team Lead' WHERE POSITION = 4;
UPDATE tbl_application SET POSITION = 'Web developer' WHERE POSITION = 5;
UPDATE tbl_application SET POSITION = 'Customer Service Representative' WHERE POSITION = 6;
UPDATE tbl_application SET POSITION = 'Content Writer' WHERE POSITION = 7;
UPDATE tbl_application SET POSITION = 'Accountant' WHERE POSITION = 8;
UPDATE tbl_application SET POSITION = 'Business Development Manager' WHERE POSITION = 9;
UPDATE tbl_application SET POSITION = 'Telesales Agent' WHERE POSITION = 10;
UPDATE tbl_application SET POSITION = 'Software Developer' WHERE POSITION = 11;
UPDATE tbl_application SET POSITION = 'IT Helpdesk' WHERE POSITION = 12;
UPDATE tbl_application SET POSITION = 'Operations Manager' WHERE POSITION = 13;
UPDATE tbl_application SET POSITION = 'Outbound sales Rep.' WHERE POSITION = 14;
UPDATE tbl_application SET POSITION = 'Senior Net Developer' WHERE POSITION = 15;
UPDATE tbl_application SET POSITION = 'IT Manager' WHERE POSITION = 16;
UPDATE tbl_application SET POSITION = 'Project Manager' WHERE POSITION = 17;
UPDATE tbl_application SET POSITION = 'Senior Software Developer' WHERE POSITION = 18;
UPDATE tbl_application SET POSITION = '.Net Developer' WHERE POSITION = 19;
UPDATE tbl_application SET POSITION = 'Contract Centre Agent' WHERE POSITION = 20;
UPDATE tbl_application SET POSITION = 'Intern' WHERE POSITION = 21;
UPDATE tbl_application SET POSITION = 'Finance Officer' WHERE POSITION = 22;
UPDATE tbl_application SET POSITION = 'Admin Assistant' WHERE POSITION = 23;
UPDATE tbl_application SET POSITION = 'Front End Web and HTML Designer' WHERE POSITION = 24;
UPDATE tbl_application SET POSITION = 'Various Position' WHERE POSITION = 25;
UPDATE tbl_application SET POSITION = 'Reports Analyst' WHERE POSITION = 26;
UPDATE tbl_application SET POSITION = 'HR Manager' WHERE POSITION = 29;
UPDATE tbl_application SET POSITION = 'IT Admin' WHERE POSITION = 30;
UPDATE tbl_application SET POSITION = 'IT Telesales Lead' WHERE POSITION = 31;
UPDATE tbl_application SET POSITION = 'IT Helpdesk Manager' WHERE POSITION = 32;
UPDATE tbl_application SET POSITION = 'Lead Verification Specialist' WHERE POSITION = 33;
UPDATE tbl_application SET POSITION = 'Customer Service Representative - English' WHERE POSITION = 34;
UPDATE tbl_application SET POSITION = 'Customer Service Representative - Mandarin' WHERE POSITION = 35;
UPDATE tbl_application SET POSITION = 'Finance Manager' WHERE POSITION = 36;
UPDATE tbl_application SET POSITION = 'IT Admin' WHERE POSITION = 30;
UPDATE tbl_application SET POSITION = 'IT Telesales Lead' WHERE POSITION = 31;