SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE lc_uploader_tags_data;

TRUNCATE TABLE lc_bookmarks;
INSERT INTO `lc_bookmarks` (`bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) 
VALUES ('Personal Details', NULL, 0, NULL, NULL, 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Full Name', 'Full_Name', 1, 'SELECT e.name FROM proll_employee e WHERE e.id=\'{id}\' LIMIT 1;', 'Dumy_Full_Name', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Father', 'Father_Name', 1, 'SELECT e.f_hname FROM proll_employee e WHERE e.id=\'{id}\' LIMIT 1', 'Dumy_Father_Name', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('ID Card #', 'ID_Card_No', 1, 'SELECT ped.doc_number FROM proll_employee_documents ped INNER JOIN proll_employee pe ON pe.id=ped.emp_id WHERE ped.doc_title=\'ID Card\' AND pe.id=\'{id}\' LIMIT 1', 'Dumy_ID_Card_No', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'number', 0),
 ('Passport #', 'Passport_No', 1, 'SELECT ped.doc_number FROM proll_employee_documents ped INNER JOIN proll_employee pe ON pe.id=ped.emp_id WHERE ped.doc_title=\'Passport\' AND pe.id=\'{id}\' LIMIT 1', 'Dumy_Passport_No', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 1),
 ('Province of Domicile', 'Province_of_Domicile', 1, 'SELECT s.name FROM proll_employee_info pei INNER JOIN states s ON s.id=pei.domicile_state_id WHERE pei.emp_id=\'{id}\' LIMIT 1', 'Dumy_Domicile_Province', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('City of Domicile', 'City_of_Domicile', 1, 'SELECT c.name FROM proll_employee_info pei INNER JOIN cities c ON c.id=pei.domicile_city_id WHERE pei.emp_id=\'{id}\' LIMIT 1', 'Dumy_Domicile_City', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Gender', 'Gender', 1, 'SELECT prd.description FROM proll_reference_data prd INNER JOIN proll_employee_info pei ON pei.gender=prd.id WHERE pei.emp_id=\'{id}\' LIMIT 1', 'Dumy_Gender', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Country of Domicile', 'Country_of_Domicile', 1, 'SELECT c.country FROM proll_employee_info pei INNER JOIN countries c ON c.country_id=pei.domicile_country_id WHERE pei.emp_id=\'{id}\' LIMIT 1', 'Dumy_Domicile_Country', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Salutation', 'Salutation', 1, 'SELECT e.name_salute FROM proll_employee e \r\nWHERE e.id=\'{id}\' LIMIT 1', 'Dumy_Salutation', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Contact Details ', NULL, 0, NULL, NULL, 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Country', 'Permanent_Country', 11, 'SELECT c.country FROM proll_employee_contact e \r\nLEFT JOIN countries c ON c.country_id=e.country_id\r\nWHERE e.address_type=\'permanent\' AND e.emp_id =\'{id}\' LIMIT 1;', 'Dumy_Permanent_Country', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('State/Region', 'Permanent_State_Region', 11, 'SELECT s.name FROM proll_employee_contact e \r\nLEFT JOIN states s ON s.id=e.state_province_id\r\nWHERE e.address_type=\'permanent\' AND e.emp_id =\'{id}\' LIMIT 1;\r\n', 'Dumy_Permanent_State/Region', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Landline #', 'Permanent_Landline_No', 11, 'SELECT e.telephone_no FROM proll_employee_contact e\r\n WHERE e.address_type=\'permanent\' AND e.emp_id =\'{id}\' LIMIT 1;', 'Dumy_Permanent_Landline_No', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'number', 0),
 ('Mobile #', 'Permanent_Mobile_No', 11, 'SELECT e.mobile_number FROM proll_employee_contact e\r\nWHERE e.address_type=\'permanent\' AND e.emp_id =\'{id}\' LIMIT 1;', 'Dumy_Permanent_Mobile_No', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'number', 0),
 ('Contact Details ', NULL, 0, NULL, NULL, 0, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Country', 'Present_Country', 16, 'SELECT c.country FROM proll_employee_contact e \r\nLEFT JOIN countries c ON c.country_id=e.country_id\r\nWHERE e.address_type=\'current\' AND e.emp_id =\'{id}\' LIMIT 1;', 'Dumy_Present_Country', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('State/Region', 'Present_State_Region', 16, 'SELECT s.name FROM proll_employee_contact e \r\nLEFT JOIN states s ON s.id=e.state_province_id\r\nWHERE e.address_type=\'current\' AND e.emp_id =\'{id}\' LIMIT 1;\r\n', 'Dumy_Present_Salutation', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Landline #', 'Present_Landline_No', 16, 'SELECT e.telephone_no FROM proll_employee_contact e\r\nWHERE e.address_type=\'current\' AND e.emp_id =\'{id}\' LIMIT 1;', 'Dumy_Present_Salutation', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'number', 0),
 ('Mobile #', 'Present_Mobile_No', 16, 'SELECT e.mobile_number FROM proll_employee_contact e\r\nWHERE e.address_type=\'current\' AND e.emp_id =\'{id}\' LIMIT 1;', 'Dumy_Present_Salutation', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'number', 0),
 ('Contract Details', NULL, 0, NULL, NULL, 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Contract Start Date', 'Contract_Start_Date', 21, 'SELECT contract_start_date FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dumy_Contract_Start_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Contract End Date', 'Contract_End_Date', 21, 'SELECT contract_end_date FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dumy_Contract_End_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Contract Value', 'Contract_Value', 21, 'SELECT contract_value FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dumy_Contract_Value', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Payment Frequency', 'Payment_Frequency', 21, 'SELECT payment_frequency FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dumy_Payment_Frequency', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Reference No', 'Reference_No', 21, 'SELECT reference_no FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dumy_Reference_No', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Working Days', 'Working_Days', 21, 'SELECT working_days FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dumy_Working_Days', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Extension Type', 'Extension_Type', 21, 'SELECT extension_type FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;', 'Dumy_Extension_Type', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Employment Details', NULL, 0, NULL, NULL, 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Employee ID', 'Employee_ID', 29, 'SELECT e.empcode FROM proll_employee e\r\n WHERE e.id =\'{id}\' LIMIT 1;', 'Dumy_Employee_ID', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'number', 0),
 ('Designation', 'Designation', 29, 'SELECT d.designation_name FROM proll_employee e\r\nLEFT JOIN proll_client_designation d ON e.designation=d.designation_id\r\n WHERE e.id =\'{id}\' LIMIT 1;', 'Dumy_Designation', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Department', 'Department', 29, 'SELECT d.department_name FROM proll_employee e\r\nLEFT JOIN department_hierarchy d ON e.department_id=d.id\r\n WHERE e.id =\'{id}\' LIMIT 1;', 'Dumy_Department', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Date of Joining', 'Date_of_Joining', 29, 'SELECT e.doj FROM proll_employee e\r\n WHERE e.id =\'{id}\' LIMIT 1;', 'Dumy_Date_of_Joining', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Employment Status', 'Employment_Status', 29, 'SELECT d.description FROM proll_employee e\r\nLEFT JOIN proll_reference_data d ON e.contract_status=d.id\r\nWHERE e.id=\'{id}\' LIMIT 1;', 'Dumy_Employment_Status', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Official Email', 'Official_Email', 29, 'SELECT e.loginname FROM proll_employee e WHERE e.id=\'{id}\' LIMIT 1', 'Dumy_Official_Email', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Probation Period', 'Probation_Period', 29, 'SELECT probation_period FROM proll_employee_info WHERE emp_id=\'{id}\' LIMIT 1', 'Dumy_Probation_Period', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Place of Posting', 'Place_of_Posting', 29, 'SELECT b.loc_desc FROM proll_employee e\r\nLEFT JOIN proll_client_location b ON e.loc_id=b.loc_id\r\n WHERE e.id=\'{id}\' limit 1;', 'Dumy_Place_of_Posting', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('User Details', NULL, 0, NULL, NULL, 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'string', 0),
 ('Name', 'User_Name', 38, 'select name from proll_employee where id=\'{authority_id}\'', 'Dumy_User_Name', 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'string', 0),
 ('Designation', 'User_Designation', 38, 'SELECT d.designation_name FROM proll_employee e\r\nLEFT JOIN proll_client_designation d ON e.designation=d.designation_id \r\nWHERE e.id =\'{authority_id}\';', 'Dumy_User_Designation', 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'string', 0),
 ('Department', 'User_Department', 38, 'SELECT d.department_name FROM proll_employee e\r\nLEFT JOIN department_hierarchy d ON e.department_id=d.id\r\nWHERE e.id =\'{authority_id}\' LIMIT 1', 'Dumy_User_Department', 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'string', 0),
 ('User Signatures', 'User_Signatures', 38, 'SELECT signature_url FROM lc_signature_setup ss WHERE ss.empid=\'{authority_id}\' limit 1', 'letterCertificate/dummy_signature.jpg', 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'file', 0),
 ('Salary Details', NULL, 0, NULL, NULL, 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'string', 0),
 ('Basic Salary', 'Basic_Salary', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'basic_salary\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Basic_Salary', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Housing Allowance', 'Housing_Allowance', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'housing_allow\' AND pess.emp_id=\'{id}\' limit 1;', 'Dumy_Housing_Allowance', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Car Allowance', 'Car_Allowance', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'car_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Car_Allowance', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Mobile Allowance', 'Mobile_Allowance', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'mobile_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Mobile_Allowance', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Special Allowance', 'Special_Allowance', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'special_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Special_Allowance', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Food Allowance', 'Food_Allowance', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'food_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Food_Allowance', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Transportation Allowance', 'Transportation_Allowance', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'transporation_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Transportation_Allowance', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Gross Salary', 'Gross_Salary', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'gross_salary\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Gross_Salary', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Other Details', NULL, 0, NULL, NULL, 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'string', 0),
 ('Date of Issuance', 'Date_of_Issuance', 52, 'SELECT NOW() as currentDate;', 'Dumy_Date_of_Issuance', 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'date', 0),
 ('Letter Reference', 'Letter_Reference', 52, NULL, 'Dumy_Letter_Reference', 1, '2021-07-12 14:47:51', '2021-07-12 14:47:51', '000000', 'string', 0),
 ('Net Salary', 'Net_Salary', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'net_pay\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Net Salary', 1, '2022-08-25 12:00:44', '2022-08-25 12:00:46', '000000', 'number', 0),
 ('Employee Signature', 'Employee_Signature', 1, 'SELECT signature_url FROM lc_signature_setup ss WHERE ss.empid=\'{id}\' limit 1', 'letterCertificate/dummy_signature.jpg', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'file', 0),
 ('Custom Template Body', 'Custom_Template_Body', 21, 'SELECT lcr.description FROM lc_requests lcr WHERE lcr.empid=\'{id}\' AND lcr.request_letter_type=\'Custom\'', 'Dumy_Custom_Template_Body', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Address', 'Address', 11, 'SELECT e.address FROM proll_employee_contact e\r\nWHERE e.address_type=\'permanent\' AND e.emp_id =\'{id}\';', 'Dumy_Address', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Custom Letter Subject', 'Custom_Letter_Subject', 21, 'SELECT lcr.subject FROM lc_requests lcr WHERE lcr.empid=\'{id}\' AND lcr.request_letter_type=\'Custom\'', 'Dumy_Custom_Template_Body', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Letter Date', 'Letter_Date', 21, 'SELECT lcr.date FROM lc_requests lcr WHERE lcr.empid=\'{id}\' AND lcr.request_letter_type=\'Custom\'', 'Dumy_Custom_Template_Body', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('General', NULL, 0, NULL, NULL, 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Current Date', 'Current_Date', 74, 'SELECT NOW() as currentDate', 'Dumy_Current_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Previous Date', 'Previous_Date', 74, 'select NOW() - INTERVAL 1 DAY as previousDate', 'Dumy_Previous_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Future Date', 'Future_Date', 74, 'select NOW() + INTERVAL 1 DAY as futureDate', 'Dumy_Future_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Letter Details', '', 0, NULL, NULL, 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Serial Number', 'Serial_Number', 78, 'SELECT serial_number from lc_setup where id=\'{id}\';', '000000', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000161', 'number', 0),
 ('Permanent City', 'Permanent_City', 11, 'SELECT c.name FROM proll_employee_contact pec\r\nINNER JOIN proll_employee pe on pe.id=pec.emp_id\r\nINNER JOIN cities c on c.id=pec.city_id\r\nWHERE pe.id=\'{id}\' AND pec.address_type=\'permanent\'', 'Dumy_Permanent_City', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Mailing Address', 'Mailing_Address', 11, 'SELECT pec.address FROM proll_employee_contact pec\r\nINNER JOIN proll_employee pe on pe.id=pec.emp_id\r\nWHERE pe.id=\'{id}\' AND pec.address_type=\'permanent\'', 'Dumy_Mailing_Address', 1, '2021-07-12 14:32:48', '2021-07-12 14:32:49', '000000', 'string', 0),
 ('Branch', 'Branch', 29, 'SELECT pcl.loc_desc FROM proll_client_location pcl\r\nINNER JOIN proll_employee pe on pe.loc_id=pcl.loc_id\r\nWHERE pe.id=\'{id}\'', 'Dumy_Branch', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Branch City', 'Branch_City', 29, 'SELECT c.name FROM proll_client_location pcl\r\nINNER JOIN proll_employee pe on pe.loc_id=pcl.loc_id\r\nINNER JOIN cities c ON c.id=pcl.city_id\r\nWHERE pe.id=\'{id}\'', 'Dumy_Branch_City', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Short Code', 'Short_Code', 91, 'SELECT pc.short_code FROM proll_client pc INNER JOIN lc_setup ls ON ls.company=pc.companyname WHERE ls.id=\'{id}\'', 'Dumy_Short_Code', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Company Details', NULL, 0, NULL, NULL, 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Letter Type', 'Letter_Type', 78, 'SELECT letter_type_short_code from lc_categories lc INNER JOIN lc_setup ls ON ls.id=\'{id}\' WHERE lc.type=\'letter_type\' AND lc.id=ls.letter_type;', 'Dumy_Letter_Type', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Letter Details', NULL, 0, NULL, NULL, NULL, NULL, NULL, '000000', 'string', 0),
 ('Allowance Name ', 'Allowance_Name', 43, NULL, 'Dumy_Allowance Name ', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Allowance Amount ', 'Allowance_Amount', 43, NULL, 'Dumy_Allowance Amount ', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Benefit Name', 'Benefit_Name', 43, NULL, 'Dumy_Benefit Name', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Benefit Amount', 'Benefit_Amount', 43, NULL, 'Dumy_Benefit Amount', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Effective Date', 'Effective_Date', 0, NULL, 'Dumy_Effective Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 0),
 ('Awarded Amount', 'Awarded_Amount', 43, NULL, 'Dumy_Awarded Amount', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 0),
 ('Band', 'Band', 29, 'SELECT unified_band FROM employee_bands eb INNER JOIN proll_employee pe ON pe.emp_band=eb.id WHERE pe.id=\'{id}\' LIMIT 1', 'Dumy_Employee_Band', 1, '2023-05-23 11:54:48', '2023-05-23 11:54:48', '000000', 'string', 1),
 ('Company Name', 'Company_Name', 91, 'SELECT companyname from proll_client pc inner join proll_employee pe on pe.cid=pc.id where pe.id=\'{id}\' LIMIT 1', 'Dumy_Company_Name', 1, '2023-05-23 11:54:48', '2023-05-23 11:54:48', '000000', 'string', 1),
 ('Bank Name', 'Bank_Name', 0, NULL, 'Dumy_Bank_Name', 1, '2023-05-23 11:54:48', '2023-05-23 11:54:48', '000000', 'string', 1),
 ('Empty Tag', 'Empty_Tag', 74, 'select " "', '', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Miscellaneous Tags', NULL, 0, NULL, NULL, 0, '2023-07-03 14:32:48', '2023-07-03 14:32:48', '000000', 'string', 0),
 ('Period', 'Period', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Period', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Date of Extension ', 'Date_of_extension', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Date_of_extension', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Start Date of Suspension', 'Start_Date_of_Suspension', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Start_Date_of_Suspension', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('End Date of Suspension', 'End_Date_of_Suspension', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_End_Date_of_Suspension', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Absent Date', 'Absent_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Absent_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Showcase letter', 'Showcase_letter', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Showcase_letter', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Showcase Letter Reference No', 'Showcase_Letter_Reference_No', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Showcase_Letter_Reference_No', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Contract Letter Reference No', 'Contract_Letter_Reference_No', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Contract_Letter_Reference_No', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('New Contract End Date', 'New_Contract_End_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_New_Contract_End_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Retainership Fee (Extension)', 'Retainership_Fee_Extension', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Retainership_Fee', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Retainership Fee', 'Retainership_Fee', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Retainership_Fee', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Date of Acceptance', 'Date_of_Acceptance', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Date_of_Acceptance', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Result Card', 'Result_Card', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Result_Card', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('NO of Documents Submitted', 'NO_of_Documents_Submitted', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_NO_of_Documents_Submitted', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('Internship End Date', 'Internship_End_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Internship_End_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Internship Extension Date', 'Internship_Extension_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Internship_Extension_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Thumb Impression ', 'Thumb_Impression', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Thumb_Impression', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Witness', 'Witness', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Witness', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Last Working Date', 'Last_Working_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Last_Working_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Resignation Date', 'Resignation_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Resignation_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Salary Period Start Date', 'Salary_Period_Start_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Salary_Period_Start_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Salary Period End Date', 'Salary_Period_End_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Salary_Period_End_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Client Company Name', 'Client_Company_Name', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Client_Company_Name', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Incentive Amount', 'Incentive_Amount', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Incentive_Amount', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('Stipend Amount', 'Stipend_Amount', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Stipend_Amount', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('Working hours', 'Working_hours', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Working_hours', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('LM Name', 'LM_Name', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_LM_Name', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Concern Person Name', 'Concern_Person_Name', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Concern_Person_Name', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Client Name', 'Client_Name', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Client_Name', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Company of Issuer', 'Company_of_Issuer', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Company_of_Issuer', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Degree Title', 'Degree_Title', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Degree_Title', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Internship Start Date', 'Internship_Start_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Internship_Start_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('New Designation', 'New_Designation', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_New_Designation', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Band (New)', 'Band_New', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Band_New', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('Company Name (other)', 'Company_Name_other', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Company_Name_other', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Award Amount ', 'Award_Amount_', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Award_Amount', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('Client ID ', 'Client_ID', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Client_ID', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('CNIC Issue Date', 'CNIC_Issue_Date', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_CNIC_Issue_Date', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Consulate General ', 'Consulate_General', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Consulate_General', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Country Name ', 'Country_Name', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Country_Name', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Date From ', 'Date_From', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Date_From', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Date To', 'Date_To', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Date_To', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'date', 1),
 ('Embassy ', 'Embassy', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Embassy', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('EOBI', 'EOBI', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_EOBI', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Father/Husband Name ', 'Father_Husband_Name', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Father_Husband_Name', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('GHI & GLI', 'GHI_GLI', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_GHI_GLI', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('New Branch ', 'New_Branch', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_New_Branch', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Old Designation', 'Old_Designation', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Old_Designation', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Previous Release Letter ', 'Previous_Release_Letter', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Previous_Release_Letter', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Reason ', 'Reason', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Reason', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Revised Address/Revised Location ', 'Revised_Address_Revised_Location', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Revised_Address_Revised_Location', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Revised Designation ', 'Revised_Designation', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Revised_Designation', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Revised Salary ', 'Revised_Salary', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Revised_Salary', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'number', 1),
 ('Section ', 'Section', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Section', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Social Security', 'Social_Security', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Social_Security', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Subject', 'Subject', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Subject', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Tehsil ', 'Tehsil', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Tehsil', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('UC', 'UC', 181, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_UC', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 1),
 ('Basic Salary In Words', 'Basic_Salary_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'basic_salary\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Basic_Salary_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Housing Allowance In Words', 'Housing_Allowance_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'housing_allow\' AND pess.emp_id=\'{id}\' limit 1;', 'Dumy_Housing_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Car Allowance In Words', 'Car_Allowance_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'car_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Car_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Mobile Allowance In Words', 'Mobile_Allowance_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'mobile_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Mobile_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Special Allowance In Words', 'Special_Allowance_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'special_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Special_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Food Allowance In Words', 'Food_Allowance_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'food_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Food_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Transportation Allowance In Words', 'Transportation_Allowance_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'transporation_allow\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Transportation_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Gross Salary In Words', 'Gross_Salary_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'gross_salary\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Gross_Salary_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Net Salary In Words', 'Net_Salary_In_Words', 43, 'SELECT pesid.final_amount FROM proll_employee_salary_summary pess \r\ninner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id\r\nINNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id\r\nINNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id\r\nWHERE cph.header_key=\'net_pay\' AND pess.emp_id=\'{id}\' limit 1;\r\n', 'Dumy_Net Salary_In_Words', 1, NULL, NULL, '000000', 'string', 0),
 ('Allowance Amount In Words', 'Allowance_Amount_In_Words', 43, NULL, 'Dumy_Allowance Amount_In_Words', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Benefit Amount In Words', 'Benefit_Amount_In_Words', 43, NULL, 'Dumy_Benefit Amount_In_Words', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0),
 ('Awarded Amount In Words', 'Awarded_Amount_In_Words', 43, NULL, 'Dumy_Awarded Amount_In_Words', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000', 'string', 0);
 
 SET FOREIGN_KEY_CHECKS = 1;