UPDATE salary_category_detail SET status=0 WHERE  id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20);
INSERT INTO salary_category_detail (salary_type, salary_type_short) VALUES ('Workers', 'W');
INSERT INTO salary_category_detail (salary_type, salary_type_short) VALUES ('Retail', 'R');
INSERT INTO salary_category_detail (salary_type, salary_type_short) VALUES ('Management/Officers', 'MO');
INSERT INTO proll_reference_data (cid, ref_id, description, reference_code, status) VALUES (48, 11, 'Apprentice', 'Apprentice', 1);
INSERT INTO proll_reference_data (cid, ref_id, description, reference_code, status) VALUES (48, 11, 'PF Employee', 'PF Employee', 1);
INSERT INTO proll_reference_data (cid, ref_id, description, reference_code, status) VALUES (48, 12, 'Piece Rate', 'Piece Rate', 1);
INSERT INTO proll_reference_data (cid, ref_id, description, reference_code, status) VALUES (48, 12, 'Advance Salary', 'Advance Salary', 1);