INSERT INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (157, 'Currency Code', 'Currency_Code', 43, 'SELECT symbol FROM proll_currency pc INNER JOIN proll_employee pe ON pe.default_currency_id=pc.id where pe.id=\'{id}\';', 'Dumy_Currency_Code', 1, NULL, NULL, '000000', 'string', 0);

REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (1, 'Personal Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (11, 'Contact Details ', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (21, 'Contract Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (29, 'Employment Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (38, 'User Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (43, 'Salary Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (52, 'Other Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (61, 'General', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (72, 'Company Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (74, 'Letter Details', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (85, 'Miscellaneous Tags', NULL, 0, NULL, NULL, 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (2, 'Full Name', 'Full_Name', 1, 'SELECT e.name FROM proll_employee e WHERE e.id=\'{id}\' LIMIT 1;', 'Dummy_Full_Name', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (3, 'Father', 'Father_Name', 1, 'SELECT e.f_hname FROM proll_employee e WHERE e.id=\'{id}\' LIMIT 1', 'Dummy_Father_Name', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (4, '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', 'Dummy_ID_Card_No', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (5, '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', 'Dummy_Passport_No', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (6, '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', 'Dummy_Province_of_Domicile', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (7, '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', 'Dummy_City_of_Domicile', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (8, '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', 'Dummy_Gender', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (9, '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', 'Dummy_Country_of_Domicile', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (10, 'Salutation', 'Salutation', 1, 'SELECT prd.description from proll_reference_data prd inner join proll_employee e on e.name_salute=prd.id and e.id=\'{id}\' LIMIT 1;', 'Dummy_Salutation', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (56, 'Employee Signature', 'Employee_Signature', 1, 'SELECT signature_url FROM lc_signature_setup ss WHERE ss.empid=\'{id}\' limit 1', 'Dummy_Employee_Signature', 1, NULL, NULL, '000000', 'file', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (12, '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;', 'Dummy_Permanent_Country', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (13, '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', 'Dummy_Permanent_State_Region', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (14, '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;', 'Dummy_Permanent_Landline_No', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (15, '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;', 'Dummy_Permanent_Mobile_No', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (58, 'Address', 'Address', 11, 'SELECT e.address FROM proll_employee_contact e\r\nWHERE e.address_type=\'permanent\' AND e.emp_id =\'{id}\';', 'Dummy_Address', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (67, '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\'', 'Dummy_Permanent_City', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (68, '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\'', 'Dummy_Mailing_Address', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (22, 'Contract Start Date', 'Contract_Start_Date', 21, 'SELECT contract_start_date FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dummy_Contract_Start_Date', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (23, 'Contract End Date', 'Contract_End_Date', 21, 'SELECT contract_end_date FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dummy_Contract_End_Date', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (24, 'Contract Value', 'Contract_Value', 21, 'SELECT contract_value FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dummy_Contract_Value', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (25, 'Payment Frequency', 'Payment_Frequency', 21, 'SELECT payment_frequency FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dummy_Payment_Frequency', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (27, 'Working Days', 'Working_Days', 21, 'SELECT working_days FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dummy_Working_Days', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (28, 'Extension Type', 'Extension_Type', 21, 'SELECT extension_type FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;', 'Dummy_Extension_Type', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (57, 'Custom Template Body', 'Custom_Template_Body', 21, 'SELECT lcr.description FROM lc_requests lcr WHERE lcr.empid=\'{id}\' AND lcr.request_letter_type=\'Custom\'', 'Dummy_Custom_Template_Body', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (59, 'Custom Letter Subject', 'Custom_Letter_Subject', 21, 'SELECT lcr.subject FROM lc_requests lcr WHERE lcr.empid=\'{id}\' AND lcr.request_letter_type=\'Custom\'', 'Dummy_Custom_Letter_Subject', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (60, 'Letter Date', 'Letter_Date', 21, 'SELECT lcr.date FROM lc_requests lcr WHERE lcr.empid=\'{id}\' AND lcr.request_letter_type=\'Custom\'', 'Dummy_Letter_Date', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (30, 'Employee ID', 'Employee_ID', 29, 'SELECT e.empcode FROM proll_employee e\r\n WHERE e.id =\'{id}\' LIMIT 1;', 'Dummy_Employee_ID', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (31, '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;', 'Dummy_Designation', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (32, '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;', 'Dummy_Department', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (33, 'Date of Joining', 'Date_of_Joining', 29, 'SELECT e.doj FROM proll_employee e\r\n WHERE e.id =\'{id}\' LIMIT 1;', 'Dummy_Date_of_Joining', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (34, '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;', 'Dummy_Employment_Status', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (35, 'Official Email', 'Official_Email', 29, 'SELECT e.loginname FROM proll_employee e WHERE e.id=\'{id}\' LIMIT 1', 'Dummy_Official_Email', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (36, 'Probation Period', 'Probation_Period', 29, 'SELECT probation_period FROM proll_employee_info WHERE emp_id=\'{id}\' LIMIT 1', 'Dummy_Probation_Period', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (37, '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;', 'Dummy_Place_of_Posting', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (69, '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}\'', 'Dummy_Branch', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (70, '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}\'', 'Dummy_Branch_City', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (81, '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', 'Dummy_Band', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (39, 'Name', 'User_Name', 38, 'select name from proll_employee where id=\'{authority_id}\'', 'Dummy_User_Name', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (40, '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}\';', 'Dummy_User_Designation', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (41, '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', 'Dummy_User_Department', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (42, 'User Signatures', 'User_Signatures', 38, 'SELECT signature_url FROM lc_signature_setup ss WHERE ss.empid=\'{authority_id}\' limit 1', 'Dummy_User_Signatures', 1, NULL, NULL, '000000', 'file', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (44, 'Basic Salary', 'Basic_Salary', 43, 'SELECT pess.basic_salary FROM proll_employee_salary_summary pess INNER JOIN proll_employee pe ON pe.id=pess.emp_id WHERE pe.id=\'{id}\' limit 1;', 'Dummy_Basic_Salary', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (45, 'Housing Allowance', 'Housing_Allowance', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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;', 'Dummy_Housing_Allowance', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (46, 'Car Allowance', 'Car_Allowance', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Car_Allowance', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (47, 'Mobile Allowance', 'Mobile_Allowance', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Mobile_Allowance', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (48, 'Special Allowance', 'Special_Allowance', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Special_Allowance', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (49, 'Food Allowance', 'Food_Allowance', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Food_Allowance', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (50, 'Transportation Allowance', 'Transportation_Allowance', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Transportation_Allowance', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (51, 'Gross Salary', 'Gross_Salary', 43, 'SELECT pess.gross_salary FROM proll_employee_salary_summary pess INNER JOIN proll_employee pe ON pe.id=pess.emp_id WHERE pe.id=\'{id}\' limit 1;', 'Dummy_Gross_Salary', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (55, 'Net Salary', 'Net_Salary', 43, 'SELECT cbs.net_pay FROM cb_salary_details cbs INNER JOIN proll_employee pe ON pe.empcode=cbs.people_code AND pe.id=\'{id}\' ORDER BY cbs.payroll_date DESC LIMIT 1;', 'Dummy_Net_Salary', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (75, 'Allowance Name ', 'Allowance_Name', 43, NULL, 'Dummy_Allowance_Name', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (76, 'Allowance Amount ', 'Allowance_Amount', 43, NULL, 'Dummy_Allowance_Amount', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (77, 'Benefit Name', 'Benefit_Name', 43, NULL, 'Dummy_Benefit_Name', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (78, 'Benefit Amount', 'Benefit_Amount', 43, NULL, 'Dummy_Benefit_Amount', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (80, 'Awarded Amount', 'Awarded_Amount', 43, NULL, 'Dummy_Awarded_Amount', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (144, 'Basic Salary In Words', 'Basic_Salary_In_Words', 43, 'SELECT pess.basic_salary AS final_amount FROM proll_employee_salary_summary pess INNER JOIN proll_employee pe ON pe.id=pess.emp_id WHERE pe.id=\'{id}\' limit 1;', 'Dummy_Basic_Salary_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (145, 'Housing Allowance In Words', 'Housing_Allowance_In_Words', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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;', 'Dummy_Housing_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (146, 'Car Allowance In Words', 'Car_Allowance_In_Words', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Car_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (147, 'Mobile Allowance In Words', 'Mobile_Allowance_In_Words', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Mobile_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (148, 'Special Allowance In Words', 'Special_Allowance_In_Words', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Special_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (149, 'Food Allowance In Words', 'Food_Allowance_In_Words', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Food_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (150, 'Transportation Allowance In Words', 'Transportation_Allowance_In_Words', 43, 'SELECT (CASE WHEN (pesid.override_amount IS NULL OR pesid.override_amount=0) THEN pesid.final_amount ELSE pesid.override_amount END) AS 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', 'Dummy_Transportation_Allowance_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (151, 'Gross Salary In Words', 'Gross_Salary_In_Words', 43, 'SELECT pess.gross_salary AS final_amount  FROM proll_employee_salary_summary pess INNER JOIN proll_employee pe ON pe.id=pess.emp_id WHERE pe.id=\'{id}\' limit 1;', 'Dummy_Gross_Salary_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (152, 'Net Salary In Words', 'Net_Salary_In_Words', 43, 'SELECT cbs.net_pay AS final_amount  FROM cb_salary_details cbs INNER JOIN proll_employee pe ON pe.empcode=cbs.people_code AND pe.id=\'{id}\' ORDER BY cbs.payroll_date DESC LIMIT 1;', 'Dummy_Net_Salary_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (153, 'Allowance Amount In Words', 'Allowance_Amount_In_Words', 43, NULL, 'Dummy_Allowance_Amount_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (154, 'Benefit Amount In Words', 'Benefit_Amount_In_Words', 43, NULL, 'Dummy_Benefit_Amount_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (155, 'Awarded Amount In Words', 'Awarded_Amount_In_Words', 43, NULL, 'Dummy_Awarded_Amount_In_Words', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (53, 'Date of Issuance', 'Date_of_Issuance', 52, 'SELECT NOW() as currentDate;', 'Dummy_Date_of_Issuance', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (54, 'Letter Reference', 'Letter_Reference', 52, NULL, 'Dummy_Letter_Reference', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (79, 'Effective Date', 'Effective_Date', 52, NULL, 'Dummy_Effective_Date', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (71, 'Short Code', 'Short_Code', 72, 'SELECT pc.short_code FROM proll_client pc INNER JOIN lc_setup ls ON ls.company=pc.companyname WHERE ls.id=\'{id}\'', 'Dummy_Short_Code', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (82, 'Company Name', 'Company_Name', 72, 'SELECT companyname from proll_client pc inner join proll_employee pe on pe.cid=pc.id where pe.id=\'{id}\' LIMIT 1', 'Dummy_Company_Name', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (26, 'Reference No', 'Reference_No', 74, 'SELECT reference_no FROM proll_employee_contracts WHERE employee_id=\'{id}\' LIMIT 1;\r\n', 'Dummy_Reference_No', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (62, 'Current Date', 'Current_Date', 74, 'SELECT NOW() as currentDate', 'Dummy_Current_Date', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (63, 'Previous Date', 'Previous_Date', 74, 'select NOW() - INTERVAL 1 DAY as previousDate', 'Dummy_Previous_Date', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (64, 'Future Date', 'Future_Date', 74, 'select NOW() + INTERVAL 1 DAY as futureDate', 'Dummy_Future_Date', 1, NULL, NULL, '000000', 'date', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (66, 'Serial Number', 'Serial_Number', 74, 'SELECT serial_number from lc_setup where id=\'{id}\';', 'Dummy_Serial_Number', 1, NULL, NULL, '000000', 'number', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (73, 'Letter Type', 'Letter_Type', 74, '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;', 'Dummy_Letter_Type', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (84, 'Empty Tag', 'Empty_Tag', 74, 'select " "', 'Dummy_Empty_Tag', 1, NULL, NULL, '000000', 'string', 0);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (83, 'Bank Name', 'Bank_Name', 85, 'select tag_data from lc_uploader_tags_data where emp_id=\'{id}\' and bookmark_id=\'{bookmark_id}\' order by id desc limit 1;', 'Dummy_Bank_Name', 1, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (86, 'Period', 'Period', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (87, 'Date of Extension ', 'Date_of_extension', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (88, 'Start Date of Suspension', 'Start_Date_of_Suspension', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (89, 'End Date of Suspension', 'End_Date_of_Suspension', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (90, 'Absent Date', 'Absent_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (91, 'Showcase letter', 'Showcase_letter', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (92, 'Showcase Letter Reference No', 'Showcase_Letter_Reference_No', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (93, 'Contract Letter Reference No', 'Contract_Letter_Reference_No', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (94, 'New Contract End Date', 'New_Contract_End_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (95, 'Retainership Fee (Extension)', 'Retainership_Fee_Extension', 85, '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_Extension', 1, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (96, 'Retainership Fee', 'Retainership_Fee', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (97, 'Date of Acceptance', 'Date_of_Acceptance', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (98, 'Result Card', 'Result_Card', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (99, 'NO of Documents Submitted', 'NO_of_Documents_Submitted', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (100, 'Internship End Date', 'Internship_End_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (101, 'Internship Extension Date', 'Internship_Extension_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (102, 'Thumb Impression ', 'Thumb_Impression', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (103, 'Witness', 'Witness', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (104, 'Last Working Date', 'Last_Working_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (105, 'Resignation Date', 'Resignation_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (106, 'Salary Period Start Date', 'Salary_Period_Start_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (107, 'Salary Period End Date', 'Salary_Period_End_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (108, 'Client Company Name', 'Client_Company_Name', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (109, 'Incentive Amount', 'Incentive_Amount', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (110, 'Stipend Amount', 'Stipend_Amount', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (111, 'Working hours', 'Working_hours', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (112, 'LM Name', 'LM_Name', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (113, 'Concern Person Name', 'Concern_Person_Name', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (114, 'Client Name', 'Client_Name', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (115, 'Company of Issuer', 'Company_of_Issuer', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (116, 'Degree Title', 'Degree_Title', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (117, 'Internship Start Date', 'Internship_Start_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (118, 'New Designation', 'New_Designation', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (119, 'Band (New)', 'Band_New', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (120, 'Company Name (other)', 'Company_Name_other', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (121, 'Award Amount ', 'Award_Amount_', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (122, 'Client ID ', 'Client_ID', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (123, 'CNIC Issue Date', 'CNIC_Issue_Date', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (124, 'Consulate General ', 'Consulate_General', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (125, 'Country Name ', 'Country_Name', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (126, 'Date From ', 'Date_From', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (127, 'Date To', 'Date_To', 85, '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, NULL, NULL, '000000', 'date', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (128, 'Embassy ', 'Embassy', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (129, 'EOBI', 'EOBI', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (130, 'Father/Husband Name ', 'Father_Husband_Name', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (131, 'GHI & GLI', 'GHI_GLI', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (132, 'New Branch ', 'New_Branch', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (133, 'Old Designation', 'Old_Designation', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (134, 'Previous Release Letter ', 'Previous_Release_Letter', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (135, 'Reason ', 'Reason', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (136, 'Revised Address/Revised Location ', 'Revised_Address_Revised_Location', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (137, 'Revised Designation ', 'Revised_Designation', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (138, 'Revised Salary ', 'Revised_Salary', 85, '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, NULL, NULL, '000000', 'number', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (139, 'Section ', 'Section', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (140, 'Social Security', 'Social_Security', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (141, 'Subject', 'Subject', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (142, 'Tehsil ', 'Tehsil', 85, '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, NULL, NULL, '000000', 'string', 1);
REPLACE INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`, `type`, `is_miscellaneous`) VALUES (143, 'UC', 'UC', 85, '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, NULL, NULL, '000000', 'string', 1);

ALTER TABLE lc_generate_job_details ADD COLUMN is_single_pdf INT(10) NOT NULL DEFAULT '0'; 
ALTER TABLE lc_generate_job_details ADD COLUMN file_name VARCHAR(50) NULL DEFAULT NULL;