INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'df6d05b2-3a30-44a5-9cec-84022c982d5e',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    599689,
    '2025-08-25',
    '2025-08-31',
    '[{\"task\": {\"uuid\": \"d5a88a6c-9504-44d0-b590-f9d7533d2dae\", \"value\": \"Wrote test cases\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"7e896a7e-c3c7-4976-9d31-e14a6876cde8\", \"value\": \"12:00\", \"isLocked\": false}, \"Fri-Aug-29\": {\"uuid\": \"f0da0175-e995-4066-9df6-e6876575224b\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Aug-25\": {\"uuid\": \"12af79d0-4d07-447d-a88f-769452e65d09\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Aug-30\": {\"uuid\": \"b19ae461-b459-4ded-86cd-15a3558f65a0\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Aug-31\": {\"uuid\": \"d528bc0b-da48-46c7-b445-9dc1c9a74c96\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-28\": {\"uuid\": \"7d09d994-140d-4fc5-a603-5a46c49ccafa\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Aug-26\": {\"uuid\": \"69fbd9d9-8edc-4445-995a-359deb88d52b\", \"value\": \"04:00\", \"isLocked\": true}, \"Wed-Aug-27\": {\"uuid\": \"9dcb6f80-be49-4e1b-b145-b53314d341df\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"6662831b-296b-4460-990f-3b281536fc13\", \"value\": \"Worked on EA log analysis\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e6052d22-0ae6-40ad-b6d0-61ca8e0585d1\", \"value\": \"22:00\", \"isLocked\": false}, \"Fri-Aug-29\": {\"uuid\": \"a8bec1eb-6ced-45ff-8865-6e45808b84ea\", \"value\": \"09:00\", \"isLocked\": false}, \"Mon-Aug-25\": {\"uuid\": \"b4e6e4f0-e257-4499-9696-685537c67c7c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Aug-30\": {\"uuid\": \"7e633509-086b-4f85-a75a-324f3b2c029a\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Aug-31\": {\"uuid\": \"dc667dbf-4c8c-4408-b348-eebe16b62a4b\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Aug-28\": {\"uuid\": \"15c88b6b-68c1-48f2-944b-ab1ac8e54205\", \"value\": \"08:00\", \"isLocked\": false}, \"Tue-Aug-26\": {\"uuid\": \"17552ee8-a7c5-4e32-b2ee-7afe23cbbf04\", \"value\": \"05:00\", \"isLocked\": true}, \"Wed-Aug-27\": {\"uuid\": \"5aa3f559-d90c-4274-8d53-edae97b57c2c\", \"value\": \"00:00\", \"isLocked\": true}}]',
    34.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-08-29 12:24:49',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e2f373ab-05dd-45bb-94ef-f61d3431c114',
    '1dd6938b-e12f-4496-bbfe-c3e6dc3da4ec',
    578210,
    '2025-11-10',
    '2025-11-16',
    '[{\"task\": {\"uuid\": \"7245bbe8-519e-4836-9be9-78ebc6a4d453\", \"value\": \"BM-600 - Completed Optimization for View Transactions\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"f21f544d-ca25-4803-860e-9b5d13fa8a9c\", \"value\": \"32:00\", \"isLocked\": false}, \"Fri-Nov-14\": {\"uuid\": \"7e62246d-3d29-43b8-8e5c-241c399ebbf2\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Nov-10\": {\"uuid\": \"010dc92f-097a-48e2-afcf-3bad36913863\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Nov-15\": {\"uuid\": \"3361d4ca-bf2e-4b33-bbb3-d8e0281f49f8\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Nov-16\": {\"uuid\": \"41edd00e-211c-4e4a-b321-c24b1b030a39\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Nov-13\": {\"uuid\": \"b3337c98-0f48-42d0-97f1-5885c2a36c04\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Nov-11\": {\"uuid\": \"636b0150-55d5-440a-adab-418610b36c1b\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Nov-12\": {\"uuid\": \"5b9442de-74c9-4979-95fd-84aa62142c92\", \"value\": \"08:00\", \"isLocked\": true}}]',
    32.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-11-17 04:39:29',
    '1dd6938b-e12f-4496-bbfe-c3e6dc3da4ec',
    NULL,
    '1dd6938b-e12f-4496-bbfe-c3e6dc3da4ec'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e379d0bd-1d13-43c6-98a2-212f09af5308',
    '0612778c-0d59-4879-b108-617d5c51501f',
    426216,
    '2024-07-08',
    '2024-07-14',
    '[{\"task\": {\"uuid\": \"a582c6fd-811b-46d4-9689-c21ef10877e2\", \"value\": \"Reading the document for LCD screen design. \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"a56818ca-f718-485d-b217-e0af9ef7e961\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"75905331-9a94-42c0-9bfb-f9aea3cdac18\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"dca8fc74-bcac-4e30-9afc-70e2bb091cbf\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"33f7d254-fefd-4318-ae6f-9fd0a5bb969a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"f1558222-4f6d-478d-a457-96a635c7e0bc\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"86a70a01-ce88-41ec-ba6b-9b57cbc95022\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"0d713783-6eb7-44d3-99cc-a9f7aee1ba64\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"210010e8-64f2-4364-975c-f4fd9dea8c79\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"424d146a-763a-44d5-b437-e6a9502afba7\", \"value\": \"reading the document for LCD screen design.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e197357c-456f-4d7c-af15-c8d65dcf3c25\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"6412b05e-5fa9-48a1-819b-adb6b4be3dec\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"48129b96-0113-4f53-a377-1d79b9365f56\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"739b1acc-2a8c-4342-8d7c-7a3b942cff0d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"73a67499-2522-43db-bb41-d0ed4309d9c5\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"5f2a4099-f58f-496c-a378-5de436c13f5b\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"b4924152-c25c-4f52-802e-46a7b341b274\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"88d354ed-e1d5-4a33-82ff-2af29ccde8f7\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"7348760a-54d3-4b7a-a49f-c97ddbfe83dd\", \"value\": \"Understanding the Use of the tool AppWizard for screen design.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"e06b0ad7-8329-4481-a683-e5b7d360297d\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"ab91d169-e741-4275-a094-ddcfc789582d\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"aac32dbb-c3cb-43f0-ad21-19bf666601bb\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"4327d70f-ff0c-4eaf-8b69-3df26ca385ea\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"0dd1903d-fe86-4e0e-a2d4-dc88776a0145\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"0401ff30-257c-4e75-bbd6-fbe98539c14f\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"7c48631d-c6ea-4872-9605-24c5a905d019\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"7e347d59-56ca-423b-b99b-27b1586664c9\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"528963d5-5933-4c90-a3ba-eb7f89bd6bbd\", \"value\": \"generating sample code of scrren design for different interface. serial stc\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"30700102-5196-45e0-bc66-dde4b042811c\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Jul-12\": {\"uuid\": \"eff67392-49ad-4b3a-b345-c33601963c37\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jul-08\": {\"uuid\": \"7049c73a-c58c-413b-b0cf-55a334e150da\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-13\": {\"uuid\": \"70cb0665-adda-4409-9b9e-4e62763c6d85\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jul-14\": {\"uuid\": \"a6c2b4bd-5247-4781-8184-c78f269c3786\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jul-11\": {\"uuid\": \"bfb47e9a-bc5f-4d23-976e-345dd33c7065\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Jul-09\": {\"uuid\": \"632e3ff9-106f-4c90-aa44-d4803ef6bc56\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-10\": {\"uuid\": \"b6fe973b-9243-491b-80fb-d8c7c37a7c39\", \"value\": \"00:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-07-19 10:53:46',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e4371180-64fb-43bb-b1c7-337a671136f3',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    839760,
    '2024-01-22',
    '2024-01-28',
    '[{\"task\": {\"uuid\": \"c2030f0e-0ba1-4b91-b25c-431fe6544aeb\", \"value\": \"Fixes for LOG FOLDER CUSTOMER NAME\'s array\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"140e078b-4880-48f4-aac4-228dd92d5088\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"f4261424-8dc8-4fc0-bc41-2ad85fde2534\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"03e22099-a236-4d90-83d2-3b29ea023d1b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"d928266a-8863-4498-8606-bf1cad29b3ec\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"20313938-4b47-48a7-a086-52f7b4c86b0d\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"28c57102-a1f4-4c45-8ec5-595c39b7c0a6\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"afa8c827-79f9-4a0c-9970-151b94888fab\", \"value\": \"02:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"89f1b460-dee5-473f-af8c-7e1ceadc03ab\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"585443f4-fdf5-445b-a43a-3b6a5ffbd34e\", \"value\": \"Fixes for Reset Password and Forgot Password Page\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"fed1b20f-2cc3-4b4e-ac6d-aa8030952214\", \"value\": \"06:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"49e62844-b3d6-4788-b092-33f305e50597\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"320199e4-bd69-432e-be73-54edf61ed9fb\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"713ab818-c662-4366-973c-1ff575ec5654\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"0c4b7e4b-610c-430d-8978-d11ac4c83a13\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"ea8b4406-b5b5-43b1-9998-5ac14bd4a4dc\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"02ffffde-42fb-4f1b-8c74-9de29d676bbb\", \"value\": \"06:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"0f84f007-1a2d-4db4-9764-03f027e29ef2\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"a449bf44-5961-4d28-8346-15a07afda2b6\", \"value\": \"Fixes for Reset Password and Forgot Password Page\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"40c9ac01-1605-491a-87a7-38bcd669b7eb\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"ef3938a1-8148-4fb5-8236-1a611c856ab0\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"230d5b52-596a-4c36-8ffd-7ed12f8866ae\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"9a2004b9-7ffd-4e96-a140-5dae09eb47f8\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"81ff63c4-22c3-44ec-83a3-b76fb10e96ce\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"4522a64d-2f59-4de9-b2fc-6f2529a9dcdc\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"cb1ad528-e37c-45ef-ad97-94036bb963cd\", \"value\": \"02:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"447eafe3-f55a-41fa-b5bc-8527ef2fe42d\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"6e4a7766-84ec-493b-8e30-2ef8d0e60942\", \"value\": \"Fixes for ENEL Customer seeder\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"5a487958-fad2-404a-bf2e-fab4db46d3a9\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Jan-26\": {\"uuid\": \"415f77a9-059c-4489-a93c-909ac4258dc7\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jan-22\": {\"uuid\": \"8373d13f-df4a-40d1-b0fd-1d3c1a24ac0a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jan-27\": {\"uuid\": \"2e78eab1-7236-41e1-9ce6-73d18924161a\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-28\": {\"uuid\": \"3a2cc5a8-664f-4651-b62e-28b6d25ce0bd\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-25\": {\"uuid\": \"83e30a56-e4e0-44fc-9b8a-bf2b8f92b2fd\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jan-23\": {\"uuid\": \"0fd32b4f-8198-4e19-bd46-b44409aefeee\", \"value\": \"01:00\", \"isLocked\": false}, \"Wed-Jan-24\": {\"uuid\": \"64da0c55-a461-4911-9d5b-4dc100ac51f7\", \"value\": \"00:00\", \"isLocked\": false}}]',
    11.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-01-24 06:59:19',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    '2024-01-24 00:00:00',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e6f00927-eac9-4e41-bc10-b32b3a2b890c',
    'e80e47fe-b12d-491d-bd6f-71a707d5d2cc',
    495757,
    '2025-11-03',
    '2025-11-09',
    '[{\"task\": {\"uuid\": \"fc516ff9-5eae-4fb2-81e6-1e0f19b9446a\", \"value\": \"Login\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"564ddaf7-7d77-4016-9f66-093e60d03748\", \"value\": \"00:00\", \"isLocked\": false}, \"Fri-Nov-07\": {\"uuid\": \"e825b2a2-5e34-458d-a62b-b0af64a036cd\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Nov-03\": {\"uuid\": \"6dd93a50-138f-4241-9e71-7920d84ce7f0\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Nov-08\": {\"uuid\": \"52b12a9f-2a5c-40d3-bfd9-9c49ddb7f711\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Nov-09\": {\"uuid\": \"6b290c83-908f-43f5-b422-4f55e27a4288\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Nov-06\": {\"uuid\": \"7968ee8e-c718-4972-8edb-13aff24ae6ad\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Nov-04\": {\"uuid\": \"b35229c4-6dc9-49ad-94d7-63e70c2a0281\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Nov-05\": {\"uuid\": \"c1f2295c-579d-4d7a-a5d1-152efdec9ece\", \"value\": \"00:00\", \"isLocked\": false}}]',
    0.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-11-05 14:58:42',
    'e80e47fe-b12d-491d-bd6f-71a707d5d2cc',
    NULL,
    'e80e47fe-b12d-491d-bd6f-71a707d5d2cc'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e971a599-5e9a-493c-a7e7-c27ba7156d93',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    894027,
    '2025-11-03',
    '2025-11-09',
    '[{\"task\": {\"uuid\": \"1a1a09bd-b9b6-4536-8b8f-e0eae78f3bc2\", \"value\": \"Mail to employees TS and Leave\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"19a724f7-3e80-4e98-98fb-06125cf11203\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Nov-07\": {\"uuid\": \"518f913c-5e2a-40e8-83f5-033656c34203\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Nov-03\": {\"uuid\": \"e6bc80bb-6522-414f-9628-c436b8670ff2\", \"value\": \"01:00\", \"isLocked\": false}, \"Sat-Nov-08\": {\"uuid\": \"f1434caf-7bc0-4c14-bb2f-328b361a2615\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Nov-09\": {\"uuid\": \"5edbc2b1-0756-4447-86df-52f2f091c8fe\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Nov-06\": {\"uuid\": \"1db9cb04-e6df-4879-902f-e367600b4450\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Nov-04\": {\"uuid\": \"1fc144f4-323d-403f-af76-4051829c3ddc\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Nov-05\": {\"uuid\": \"13e397bc-66f5-4e3a-b251-2fd4636b7317\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"973f6c3a-43a3-4b0a-83d0-579da48f6eb9\", \"value\": \"Hardware and Quality Interview done\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"aef29b70-e25c-4018-8d11-feb3ca012e5c\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Nov-07\": {\"uuid\": \"a6de5c3b-141a-4a2e-ad09-e3d918ea5f6a\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Nov-03\": {\"uuid\": \"b4dbc322-b5de-4faf-beac-d762e3df8652\", \"value\": \"02:00\", \"isLocked\": false}, \"Sat-Nov-08\": {\"uuid\": \"9ecadcb0-099c-42e4-806b-7b6a2557c06f\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Nov-09\": {\"uuid\": \"a61fd441-d7a0-4f7b-a9ac-a39431d3280d\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Nov-06\": {\"uuid\": \"8c158b8f-e9c1-4c30-b39c-932a644381e2\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Nov-04\": {\"uuid\": \"9d46fbf4-8a64-42a1-8e82-62271443a074\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Nov-05\": {\"uuid\": \"413a4791-37a7-4c6f-9e6f-86359e706b97\", \"value\": \"00:00\", \"isLocked\": false}}, {\"task\": {\"uuid\": \"e857c9dd-66e1-405d-b685-a4c74602d382\", \"value\": \"Application mail to Neha Parmar for regular updating TS in vodichron\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"ab247361-be5e-4af1-9360-206c3fa35423\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Nov-07\": {\"uuid\": \"8e3cfb17-c9d7-4887-8254-64a7f1475360\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Nov-03\": {\"uuid\": \"a0835024-89e7-4d43-8e8a-a5c8cb3631d4\", \"value\": \"01:00\", \"isLocked\": false}, \"Sat-Nov-08\": {\"uuid\": \"a163347f-d228-4e86-ab7f-a2d315899242\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Nov-09\": {\"uuid\": \"ae4e7808-10e7-4c93-9f31-d88880deede7\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Nov-06\": {\"uuid\": \"4a1a9f75-0b35-42a4-99f8-fb91bad087ba\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Nov-04\": {\"uuid\": \"4e08ca2e-594e-44d0-a06d-3e4405ffc81e\", \"value\": \"00:00\", \"isLocked\": false}, \"Wed-Nov-05\": {\"uuid\": \"ea9c2cf1-32bf-4364-a939-5a42476edac9\", \"value\": \"00:00\", \"isLocked\": false}}]',
    4.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-11-03 10:32:48',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-03 00:00:00',
    'bf936c19-eec2-42f2-b39c-4025d761ef81'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'e9855d0f-15e3-4f56-b4de-51aaccb5c12c',
    '0612778c-0d59-4879-b108-617d5c51501f',
    948886,
    '2024-07-01',
    '2024-07-07',
    '[{\"task\": {\"uuid\": \"ec4f19cb-b050-41e1-8ad5-e314b830397e\", \"value\": \"Understanding and taking overview of the LCD display.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"bde5e62f-16cf-4981-8aa3-4b9fdcbefe84\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"715b5d06-3014-4930-9034-dad2cbdcaaef\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jul-01\": {\"uuid\": \"6bdc84d5-d4d2-46c3-a374-f0faa7a083fa\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"b0698272-72f5-44c4-85d4-e997069737c5\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jul-07\": {\"uuid\": \"0af30e9b-d247-4c95-9397-c3a318782b52\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jul-04\": {\"uuid\": \"8f39e343-7a50-4989-bc82-a36e284858a1\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jul-02\": {\"uuid\": \"1056c642-be0e-488a-aedf-10a0fc1f8ec6\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"9100cdc9-861d-42cc-97c4-bbc94d9b7217\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"87017cb3-0ba6-4fce-bb54-7826c049d336\", \"value\": \"Find and study the tools used for the LCD display screen design.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"91f48838-da81-4276-86e4-ee89e0f7e2fc\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"4c75754e-e1fb-4662-8f81-be23ace02d51\", \"value\": \"00:00\", \"isLocked\": false}, \"Mon-Jul-01\": {\"uuid\": \"0c813236-da60-4a2d-9eec-e5582d83695d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"d6ff6ff5-b802-4c60-b892-36d079d87ee0\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jul-07\": {\"uuid\": \"d93d3e02-93cc-4c5a-9ac8-e376a625fb0c\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jul-04\": {\"uuid\": \"d1159cee-cde6-4efa-a426-84dfd5e38667\", \"value\": \"00:00\", \"isLocked\": false}, \"Tue-Jul-02\": {\"uuid\": \"af20fb15-2e4f-41de-934e-d8ee8c01bb6d\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"ae106583-cb21-4cbe-8427-27bb3e491371\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ff2e475c-467a-4078-bdde-9b88ac4f7d49\", \"value\": \"Created sample code using QE tool for Screen design. understanding Features\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"25bbc891-598a-45fc-be7b-deb788669184\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Jul-05\": {\"uuid\": \"d05f6f2b-248a-4340-9248-d3f602f55153\", \"value\": \"08:00\", \"isLocked\": false}, \"Mon-Jul-01\": {\"uuid\": \"96137aaa-8fb0-4275-975c-ea432023ed6d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jul-06\": {\"uuid\": \"7bba7191-09e5-4ba5-8ddc-310548e84f59\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jul-07\": {\"uuid\": \"7ac8ca69-3cdb-4402-be6e-41028c845360\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jul-04\": {\"uuid\": \"f286e408-50e1-44da-950f-3a09d5174abf\", \"value\": \"08:00\", \"isLocked\": false}, \"Tue-Jul-02\": {\"uuid\": \"44af552a-d4ad-4427-a859-a95856d7103a\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Jul-03\": {\"uuid\": \"33831b0b-26b3-4dbe-bf42-029bf8fe0393\", \"value\": \"00:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-07-05 10:10:36',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'ea965a80-1336-4ae6-9a41-de35d9e496db',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    637112,
    '2025-03-10',
    '2025-03-16',
    '[{\"task\": {\"uuid\": \"f1030a65-529c-4531-bb8d-c9a3304e0bda\", \"value\": \"Setting update panel added provision for different  users and fix issues\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"8e17e8bc-e3d2-49a0-a72a-5f0c9441b626\", \"value\": \"40:00\", \"isLocked\": false}, \"Fri-Mar-14\": {\"uuid\": \"8da2987a-567e-42d9-8349-10897b3f1e59\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Mar-10\": {\"uuid\": \"2dec97ec-207c-466e-b613-af05581cdf7e\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Mar-15\": {\"uuid\": \"03061d87-e5d0-4d2e-9868-88e8e125475a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Mar-16\": {\"uuid\": \"a52fc473-da55-47e9-8284-4689aee1d78a\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Mar-13\": {\"uuid\": \"23765a0c-cac2-4956-ba22-cfc90e15dc83\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Mar-11\": {\"uuid\": \"ae822d9c-716d-4645-b928-a3207f5f6703\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Mar-12\": {\"uuid\": \"84c4288d-a958-4d05-bf2f-9d4728ceb875\", \"value\": \"08:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-03-17 10:19:32',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'ebedb437-a385-4ee1-9b9a-49ee511179ed',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    900876,
    '2025-05-26',
    '2025-06-01',
    '[{\"task\": {\"uuid\": \"30208735-ec8d-40c1-9817-c69a5139ed23\", \"value\": \"unit test case for reporting module\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"050f8ca5-4a23-438d-afff-ec9e54c437be\", \"value\": \"34:00\", \"isLocked\": false}, \"Fri-May-30\": {\"uuid\": \"669c2efa-2a7d-4ec7-ae47-bf95d539aaa8\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-May-26\": {\"uuid\": \"1d169416-e06d-4808-8fab-deccf3d00951\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-31\": {\"uuid\": \"5792f1a8-27ca-4927-9079-786db632ad2a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-01\": {\"uuid\": \"0f6fc738-a033-4fef-9306-81f6aeba785c\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-29\": {\"uuid\": \"d1eacf86-a4d8-41ad-94af-4e121288ef93\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-May-27\": {\"uuid\": \"4e3e3374-42f4-4990-b188-6889da375958\", \"value\": \"09:00\", \"isLocked\": true}, \"Wed-May-28\": {\"uuid\": \"1ca27cb8-b337-4710-8ec5-f9c55249f6ee\", \"value\": \"09:00\", \"isLocked\": true}}]',
    34.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-06-03 13:23:01',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'edb55d25-4f46-4862-86cc-a47f2977129a',
    '0612778c-0d59-4879-b108-617d5c51501f',
    143404,
    '2025-01-13',
    '2025-01-19',
    '[{\"task\": {\"uuid\": \"ddd8a5d0-78d4-403c-9ae0-120d45ba2511\", \"value\": \"correcting and closing the review comment on PRD cap-sense and external spe\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1d3dddf8-207c-4641-8a7c-42ad248cfd71\", \"value\": \"32:00\", \"isLocked\": false}, \"Fri-Jan-17\": {\"uuid\": \"2d0efc1c-fbf1-42b0-a8f7-c71b66743789\", \"value\": \"08:00\", \"isLocked\": false}, \"Mon-Jan-13\": {\"uuid\": \"aad3b7fe-3e60-4e1d-abd0-5a5027efd7c6\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jan-18\": {\"uuid\": \"64bcd8e5-5030-40a2-a6f3-b140623574eb\", \"value\": \"00:00\", \"isLocked\": false}, \"Sun-Jan-19\": {\"uuid\": \"921f6887-5eda-4f09-87ec-36ca0d9835ad\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-16\": {\"uuid\": \"8e2314fc-8e91-4432-b478-0df5abeba85a\", \"value\": \"08:00\", \"isLocked\": false}, \"Tue-Jan-14\": {\"uuid\": \"cf8f7301-cf27-4a2f-a3f9-06da388e8d55\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jan-15\": {\"uuid\": \"952949c2-0a81-4de0-8340-44530bb2bcf7\", \"value\": \"00:00\", \"isLocked\": false}}]',
    32.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-01-16 04:25:07',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'eee586d6-e71a-4a02-92ee-1a1632b91d00',
    'ffd826ce-5585-4a76-9b57-6821a68619e3',
    367208,
    '2024-04-08',
    '2024-04-14',
    '[{\"task\": {\"uuid\": \"c95eb771-df9e-4736-a872-f4379b1064c5\", \"value\": \"Multitasking code with RTOS implimenting debug.c in UART 5\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"0a95dc9a-9877-4e51-b702-6391265d764a\", \"value\": \"09:30\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"a33b8c98-e16e-4a2c-9cb3-32481b1ef4e6\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"735451b0-c0c4-4538-aa5d-1cbd31ebb377\", \"value\": \"09:30\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"df66c7ac-9ded-4770-a3f2-e1fe1e39e468\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"a13a1ab9-b461-40ad-9867-ad7abc26ad05\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"31952fba-dda1-4daf-b214-337197e02fd2\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"398af46c-0544-4388-b3df-6ca1c53a5b26\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"8c96ca64-ab29-46de-a932-2399c673a9b6\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"7aca3430-9859-4b71-b119-a0c34f5c19f6\", \"value\": \"Implimenting debug.c in all the pheripheral and tested it\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"d7aef52b-d05a-4b0b-9ece-51f0a219f90e\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"e334dec7-d4ae-46db-a517-e8c9ea5f0455\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"2052ae7b-9904-4a3c-878d-89d5ea94dd97\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"79d27d15-06df-42f6-8fa4-5e32a80d7e85\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"37ecf039-3eb2-4f91-add0-a5df0b19ae1b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"113215f7-62f4-480a-afe9-188f9746557b\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"9953c8e2-a769-4fb5-8b44-09af24f41d78\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"7492d6a3-8d36-49bc-ac3b-a153b0fd21fd\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"2f2dd2d1-6226-429f-90f9-2b9f596b46af\", \"value\": \"Sprint4 deliverable cheking and updating\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"33ceb8fb-d558-42bc-9649-583796bea183\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"f2911a97-0425-4c3e-bbe9-f51cfeb48d4d\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"4f53560e-00fb-4427-a681-aa1d6009a9d8\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"a1996ff1-dad0-4937-90cc-e6f11544d045\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"f9843eca-ac42-4bde-86a3-765c22586156\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"c1eb01ac-5d6e-42ed-a32e-a10495255355\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"8241202f-de9e-4acd-be6e-e8e02ecc0d95\", \"value\": \"02:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"35f61b62-2c64-4919-a7d2-4e2aae39f1e1\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"e76f3b37-d410-435b-8a19-539a3733e948\", \"value\": \"MOM updated\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"9a74ba82-8afb-410b-b2c0-ea3a48e39d26\", \"value\": \"01:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"c3f74fc1-84b3-4762-91db-cb94cd6c6f59\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"9a27d4a1-405b-4c84-839d-10f62ce1ca4b\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"8b4e0287-c99a-4f21-a49a-6b0b28569ad1\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"cc2133d7-c0ce-4f71-abf7-cde86acc2cab\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"019d3317-40dc-4663-90c2-67c474b00ce4\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"72f12173-b7ee-4633-a788-d8f03ba2a293\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"4bb47400-6242-4811-bd75-d6da5d2d5c60\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"578648e7-4f78-432d-a7a0-8517446ab4fa\", \"value\": \"Code for watchdog timer and tested it in code \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"7331938f-4372-4c1d-8975-ca9504b6868a\", \"value\": \"09:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"87b3f3af-2b02-4461-a5e4-c9a0a255ff2c\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"ab94effc-f233-4fa3-bd44-b070430d3633\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"0a1314aa-cad3-4f1b-b90e-afeb30cf8984\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"596f05ed-4ab4-4136-a7e3-e93f874501ec\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"d57c8aad-ae6a-4c13-a557-44133c1846b8\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"7bbbe0ff-1a42-497d-a536-301f351e0cc3\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"a205d864-5f58-4737-b45f-cc59b2bd39f6\", \"value\": \"09:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"4322b4d4-5c30-4b76-bd46-47e56c3bce19\", \"value\": \"code for RS485 transmit and tested \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"3dd3a3e9-45bb-45ca-a2ca-92ddc48d5f0c\", \"value\": \"08:30\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"6dbdfa6c-7197-4420-86eb-4d0added91ca\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"29d340b2-2d88-407d-876a-41f22f231679\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"42086f47-16f0-4bbe-b3c8-3f5c9687ba0a\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"c4578497-a7a5-41af-aa07-6eb1e6a7a61b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"9c7b28f2-2e21-4f7c-bd4a-3c779b0bf680\", \"value\": \"08:30\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"b9d05b66-0312-4eb6-a2a5-5278d85d73b3\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"b1743aad-79ec-4ede-861b-f1e84c0e9f91\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"67987c80-d747-462f-b930-29ab50fcb0ef\", \"value\": \"code for RS485 receive along with accuracy code worked on excitation curren\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b271acd4-cad1-462f-b3e6-2893cfb99b58\", \"value\": \"09:30\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"9994f820-4c79-4fc4-8553-94df272ca6ec\", \"value\": \"09:30\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"0b65d95a-f575-4d59-ba36-3512e353b58c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"88cd0663-2dbd-422a-86c0-bc5921f043b4\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"ae729d08-6460-4ad1-889e-d8e6743e5134\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"2647400f-d789-4855-91ab-f829e33277d4\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"4199489d-7880-4ed9-9d50-9ca94d7a61a1\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"d94f3ec9-02a9-42e0-a157-172008c04d36\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"05fd5de8-1991-4a9d-b919-e3276663a805\", \"value\": \"ADC code with readings along with 485 code \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"1e71cb74-07d0-4bc2-9de7-66e7f5e7a61b\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"708393f9-c9f8-41d6-abe8-028b69b31a5c\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"6fbb0f98-e5b9-48e0-9742-cf71fa36ea7e\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"135a7b61-b177-4a4c-8901-f989b3c85e52\", \"value\": \"08:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"b1ca60d9-a70a-495c-a91e-4d02bcc8883b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"b8fb8089-7de3-4ede-9084-130925fbce8f\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"bec3333a-5df9-4692-b43e-134cfeb78ff5\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"190bb637-2f1f-41e2-a59b-cbc03ab397c3\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"6423a358-14e1-4b98-b6e7-872283813eb4\", \"value\": \"Multitasking code testing with documentation ADC code with documentation \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"024c70b8-64b6-40ff-ba68-3dd0f55d38b9\", \"value\": \"09:00\", \"isLocked\": false}, \"Fri-Apr-12\": {\"uuid\": \"b5ebbf07-8a22-4ed8-bb8a-f91aa57e0752\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-08\": {\"uuid\": \"18f23e97-b78f-4ce2-8dd4-3359a195d119\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-13\": {\"uuid\": \"7889beb0-4716-4a2a-a24d-d9ecf1aa5037\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-14\": {\"uuid\": \"40e728f3-0ed9-45b0-b4ae-6c28380d70bd\", \"value\": \"09:00\", \"isLocked\": true}, \"Thu-Apr-11\": {\"uuid\": \"59c110b6-5e83-428c-b4d2-70ff71aa31f4\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-09\": {\"uuid\": \"f6e1b75e-ed59-4fa4-8f8a-da17fa63e3b2\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-10\": {\"uuid\": \"ae906f06-e0fd-44e4-b23a-3b2415a94503\", \"value\": \"00:00\", \"isLocked\": true}}]',
    64.30,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-04-17 05:12:50',
    'ffd826ce-5585-4a76-9b57-6821a68619e3',
    NULL,
    'ffd826ce-5585-4a76-9b57-6821a68619e3'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f273add1-b54b-4ce3-b55c-2f74aea25708',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    906262,
    '2024-06-17',
    '2024-06-23',
    '[{\"task\": {\"uuid\": \"b3dfbcb5-eec0-46d4-b888-395c8ec11f93\", \"value\": \"Setting Update Panel\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b620a552-b5da-4852-9935-348167c69fd1\", \"value\": \"40:00\", \"isLocked\": false}, \"Fri-Jun-21\": {\"uuid\": \"618fa84c-7a3a-40c0-a00f-ef8cfb1af47c\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jun-17\": {\"uuid\": \"3d6308bd-5bbb-4329-984a-d9691863e71d\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jun-22\": {\"uuid\": \"5b46ecb4-52c8-4bda-a422-df630f8c1803\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-23\": {\"uuid\": \"90ea4e3d-b6b7-4d35-ae13-d57813a26c99\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jun-20\": {\"uuid\": \"a33b0109-ca99-4fd9-938e-877ece11943e\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Jun-18\": {\"uuid\": \"ca922b05-e914-43d5-bb9b-1499e545927f\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jun-19\": {\"uuid\": \"ff9b1c91-97d9-42a0-9261-c479d83108a7\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"546e5920-f1d4-46f4-ac45-c1e75bb485e8\", \"value\": \"Firmware Matrix And Rollout package\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"685bc272-b786-4a5c-b47f-0f5275a347ef\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-Jun-21\": {\"uuid\": \"f7955770-6a7f-4771-91c3-cee68b8e3c2b\", \"value\": \"01:00\", \"isLocked\": true}, \"Mon-Jun-17\": {\"uuid\": \"f2a8419b-66bc-4103-9271-e73ece54c3dc\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Jun-22\": {\"uuid\": \"4de061de-00d9-4847-a8df-fc7efc932c6c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jun-23\": {\"uuid\": \"549ed307-ccf8-4864-872a-44136f031902\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jun-20\": {\"uuid\": \"ae57f848-9421-4b33-8808-774867a212f3\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jun-18\": {\"uuid\": \"a400e555-0ee0-4dad-9d15-96a744b027ab\", \"value\": \"01:00\", \"isLocked\": true}, \"Wed-Jun-19\": {\"uuid\": \"d325423a-7d75-43ed-800c-a4880aaad6eb\", \"value\": \"00:00\", \"isLocked\": true}}]',
    42.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-06-30 13:43:02',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f2adda1c-be3f-42b9-a1e3-ee6efa956a4e',
    '0612778c-0d59-4879-b108-617d5c51501f',
    170601,
    '2025-01-06',
    '2025-01-12',
    '[{\"task\": {\"uuid\": \"c3d0b271-9203-4bdf-8d1f-3fb2d9b0fff5\", \"value\": \"Correction and closing the review comment on the PRD are (RTC buzzer LCD)\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"8fff1c0e-d9e3-4e7c-8b00-c1cd20090bfd\", \"value\": \"40:00\", \"isLocked\": false}, \"Fri-Jan-10\": {\"uuid\": \"6cbcd9f4-8964-4a59-b355-fa776d889167\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jan-06\": {\"uuid\": \"ae675430-0136-485d-b784-a98346dfa69c\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jan-11\": {\"uuid\": \"8d18cd72-34c1-4ab4-a3e8-6d0ed1955a81\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Jan-12\": {\"uuid\": \"c1ffb0d2-8971-4623-b053-080d379346ae\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Jan-09\": {\"uuid\": \"10a33058-36a7-43d9-bcb5-b0aa0ebeec7d\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Jan-07\": {\"uuid\": \"a5b64a62-8ef1-4891-920f-faac7e422bb1\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jan-08\": {\"uuid\": \"d9ea19fb-edb6-48c2-ad15-f5ce0139311c\", \"value\": \"08:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-01-16 04:23:27',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f709f74a-63f3-4016-ace7-51661e269470',
    '0612778c-0d59-4879-b108-617d5c51501f',
    120401,
    '2024-04-22',
    '2024-04-28',
    '[{\"task\": {\"uuid\": \"44fcfdc2-48d2-4458-97b9-d0e545e590b7\", \"value\": \"understanding CTSU drivr layer for initial setting.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"17b2bedc-5abe-4749-86a7-8b463c8272be\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Apr-26\": {\"uuid\": \"328ae644-ae10-4152-9e65-8db1b592b2e5\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-22\": {\"uuid\": \"62547ae8-dea8-4a09-b6cd-c8ca58e922cd\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Apr-27\": {\"uuid\": \"93117814-a0db-4824-bdd0-9aa9cfbdfeb3\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-28\": {\"uuid\": \"a32e73b4-3155-426d-9f73-ff5cbc9fbcfe\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-25\": {\"uuid\": \"2ab3dd04-c870-4ab9-bb39-3a642b78631d\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-23\": {\"uuid\": \"cb553210-80d5-40cb-8d2f-111faa6e29c1\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Apr-24\": {\"uuid\": \"b258a8f7-4349-462d-958b-20c4aca51f6d\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"f9c2ede9-48bf-4d50-931b-4f959297378c\", \"value\": \"Understanding CTSU Initial correction process.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"60bb064d-d5fd-4445-ae75-7e9c86b745d0\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-Apr-26\": {\"uuid\": \"3042c99e-91b4-464c-8173-83dfd3285ede\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-Apr-22\": {\"uuid\": \"1a198225-9584-421c-b0a4-069fd036462f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-27\": {\"uuid\": \"4024b806-d128-4180-998a-4e10fe27ad1c\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-28\": {\"uuid\": \"c0676e78-c4fd-468b-9f29-7fc8bcd4d6df\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-25\": {\"uuid\": \"9c288305-9767-4d7b-b75c-ab4e29e5cf62\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Apr-23\": {\"uuid\": \"1aa146fe-17cc-4155-88d9-19a465c80a57\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-24\": {\"uuid\": \"3d825573-6087-4106-9c5e-a8d99465ab2f\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"ea920360-8bd6-4702-bbf7-1b33c7404a09\", \"value\": \"understanding and making design step document capsense.\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"02dd3f72-b99d-4c4f-a232-99823c33c24d\", \"value\": \"16:00\", \"isLocked\": false}, \"Fri-Apr-26\": {\"uuid\": \"ce8fe647-8857-44e8-8520-d5ed6c1b28f9\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Apr-22\": {\"uuid\": \"155834e8-8328-4c7d-ba01-a70f36b4e4a1\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-Apr-27\": {\"uuid\": \"d88dd242-d8c5-439d-90f9-50c6b82e034e\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-28\": {\"uuid\": \"ca93febb-a6ff-4985-9ab7-4541d2358942\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-Apr-25\": {\"uuid\": \"b052cc8c-a435-4163-baf3-ee48c6de4086\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Apr-23\": {\"uuid\": \"920f3905-5e14-4426-98fb-8b3b5fa70ce4\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-Apr-24\": {\"uuid\": \"50796344-74c3-489c-9342-7c26f70a0f01\", \"value\": \"00:00\", \"isLocked\": true}}]',
    40.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2024-05-03 07:54:53',
    '0612778c-0d59-4879-b108-617d5c51501f',
    NULL,
    '0612778c-0d59-4879-b108-617d5c51501f'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f7224a93-646d-49df-bf9c-b90536394a9a',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    603890,
    '2025-01-20',
    '2025-01-26',
    '[{\"task\": {\"uuid\": \"d324934c-adfb-4d94-8765-7ecfcfed4edb\", \"value\": \"CAN Analyzer tool\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"cda098ec-cc9f-4a66-906a-b7b6bae8e2fc\", \"value\": \"32:00\", \"isLocked\": false}, \"Fri-Jan-24\": {\"uuid\": \"d9ebff44-44a5-4290-ae00-34db34309bad\", \"value\": \"08:00\", \"isLocked\": true}, \"Mon-Jan-20\": {\"uuid\": \"2f14d442-54d7-4226-948a-32a5bc4a339f\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Jan-25\": {\"uuid\": \"b4a6ebe0-2ea7-4a8c-bd6c-21ad343ae989\", \"value\": \"08:00\", \"isLocked\": true}, \"Sun-Jan-26\": {\"uuid\": \"699740c9-ffd8-42a2-99dc-7538ec2c4ded\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Jan-23\": {\"uuid\": \"42a9b4a1-2e3d-4d7a-b1fe-5eaea89b61cc\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-Jan-21\": {\"uuid\": \"ac5533d7-b685-4bf0-8ce8-89f9a828684d\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Jan-22\": {\"uuid\": \"c6559bd3-f5cc-4936-840c-885fc00f17cb\", \"value\": \"00:00\", \"isLocked\": true}}]',
    32.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-01-27 07:27:37',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f80c369e-08b0-43aa-b3e4-fad452d9542c',
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    245597,
    '2025-05-12',
    '2025-05-18',
    '[{\"task\": {\"uuid\": \"426560ec-8d9f-44f9-9f05-d05da3e38f2b\", \"value\": \"Quotation work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"19a6f0ff-da89-4963-b2af-9328bb3b95f8\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"8f6b987e-841f-48f6-8268-5c4cda6f4744\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"23df4016-98d2-4a16-904a-18b74db2c400\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"0739f986-0313-4b61-a921-9c76241121d4\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"f7436a1d-3e50-4bfd-84a9-a117fdc59d7b\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"a2d26e3d-3d1e-42e6-b67f-088cdacd1d9c\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1cf456cf-cfd7-4d3c-bb1b-efd017686074\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"c40de271-609f-40ad-99d6-5e0adf64a00a\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"80af8f57-db7f-41ce-95fe-6572d0f664b9\", \"value\": \"Quotation work \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"99aef0b6-7666-4a26-b652-2c9e862000cd\", \"value\": \"05:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"fa906a55-2fe5-41a7-bf6f-b6ffad830682\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"cd88522e-547f-4fb9-840c-e97be98bf7e9\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"84ad7fa4-3b99-48b4-8ca9-8f049c07cf3f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"cd3baa97-6dd0-44e7-bd28-0bbc6594a001\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"1f591a03-e1a8-4754-9764-4a2e9bc1f57a\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1a5657b1-3377-4b65-b402-52f0450a4640\", \"value\": \"05:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"f79afdfa-9f60-465d-bf02-ca3426821fea\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"098bcae8-064e-484f-900d-8f0cd54bf3d2\", \"value\": \"template wotk\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"47bb1bcc-c8fe-4757-b9e8-732b5bfd529f\", \"value\": \"03:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"416809e4-3deb-4a70-93f6-ed43681a8883\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"2fac96de-8549-4656-979f-cba8f7e6d8fb\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"e5b4defe-88a5-44e9-a368-52b8fc479266\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"7068b2b6-b425-43b3-846f-54a79aa6d023\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"e53b742c-e534-417e-84ab-2f6f00986a8e\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1726fa5e-0ddb-404f-90ce-3fc3f5dbcf6d\", \"value\": \"03:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"baf5ab9c-ff1c-4b7a-997f-f3886215e57a\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"b496aad3-cd0f-4a47-948c-b0a955e6cf10\", \"value\": \"purchase order \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"200c97ea-be99-487f-b01d-bfa2c4db39f8\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"908f760d-6c1f-428c-97a2-1b8fb22429c3\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"9321d6ac-7e84-478c-8c1c-09e1e2a8f9af\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"5645746a-89e5-4e89-a7a7-03e18d59ff12\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"50a2559c-fc8a-4ca3-8987-6fe3e9ff84ab\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"5c61a086-5bb3-477f-9201-a8db8501581c\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"396067c5-f5f4-4666-92ad-7db9c2f3c53d\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"853e1bc3-2377-414b-ab48-be7b2eaf68c9\", \"value\": \"08:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"2ca5cc30-5155-4d19-819b-2c34d7a176f4\", \"value\": \"Quotation and order process\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"47fa76cd-7484-465a-b62e-a7c39f927341\", \"value\": \"08:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"8df8e31a-add5-4931-9da6-e7879e7913b8\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"23209f42-31ff-4f95-aa3c-27396bd3e2ff\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"aaeba2eb-91fa-4166-a399-2528fea5d308\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"bb55038d-d191-458d-b37a-e86eda0aa76d\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"54c7eed5-d0f1-42fd-b5d2-761e343c70b0\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"22bd47ff-7c93-4e11-828f-bfc2826314d7\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"6fee12ae-3572-4e3b-ac43-38d67c42eef0\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"30dd3f94-51e9-42f7-befa-901e35b0233a\", \"value\": \"flight work process\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"a6a1ebb2-85c1-4c2d-8e2e-8c395f3c7a21\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"7c484000-1483-4653-813e-abc4901f5038\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"a78d11be-e1df-4ac7-b53c-40d3315979e9\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"92cbfb59-96eb-4a32-9413-6ca11d630bb5\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"ef06cdb8-ed39-4683-aedd-829c2cad6ed8\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"75388dd8-028f-4163-aba7-07118f93af51\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"81923e6a-8b77-42cb-9e64-a4920be901f6\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"59676e3a-0152-434b-bd70-8af64c14c95f\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"842332bd-a6b9-4172-8e2c-99786afa727e\", \"value\": \"Expenses work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"b7568149-bf41-4892-8a90-1badf3b13966\", \"value\": \"02:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"a3b59e29-dcde-4c74-bfa5-829cf25f30cf\", \"value\": \"02:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"c288e54a-e393-413a-b481-7f6dcc7a8a87\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"0615dfbc-d350-4507-a9bd-d8f6b209938d\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"b84fbef7-a532-4ca6-b79a-c055516f25f6\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"805fcdbd-4d48-4c71-b8df-b7d55cd1d778\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"b606adfa-6b42-4881-8993-1b16f18ceee1\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"c9772ce2-2afc-4f3f-9a15-9896cb577fb2\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"caf87633-94f3-4a10-aff9-9ae18195d494\", \"value\": \"Quotation work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"6ac10580-efae-48d4-9806-c347f2d1d7fa\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"9492b6eb-8296-401b-91a2-50dffa6edb7b\", \"value\": \"04:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"1bdc9ebf-df9b-45fe-979f-331b170e109f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"a79a8ba5-cb4f-4a2b-a2df-0ee6d3af04c0\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"34608971-a989-40d9-8354-032fa0fcae14\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"92967bab-126b-413f-8122-755695b33f10\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"17bebdac-cd77-481d-8f9c-a6de90885731\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"f4aa39f2-2ed2-414d-a5cf-8d64f1830379\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"8ee3c9f5-7d4b-4e7d-a4e3-c2fa660d409e\", \"value\": \"template and quotation work\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"d35fe7ce-f003-4065-89d3-c203f17a6472\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"79a0f9c8-dd3b-494b-911b-6e1f61bdb128\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"9984f0b7-f314-4717-9ab7-f53e716a4e3f\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"c0a5c127-fc33-42a5-be27-2d37d39d0275\", \"value\": \"04:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"183ebdbf-a5b7-464d-a125-534143431306\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"511b9877-23ac-4f99-84fa-de1fcb163f5d\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"a40f9904-b0cb-4489-bc12-5562769713a3\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"b5c8f471-c58b-407d-99dd-f1722f09f453\", \"value\": \"00:00\", \"isLocked\": true}}, {\"task\": {\"uuid\": \"194a8b81-87e3-494f-a3dc-18095229a947\", \"value\": \"file work \", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"0357a125-0e0c-476c-af53-788e99494310\", \"value\": \"04:00\", \"isLocked\": false}, \"Fri-May-16\": {\"uuid\": \"ca72fe2a-ec41-4e18-8233-a41421c1a139\", \"value\": \"00:00\", \"isLocked\": true}, \"Mon-May-12\": {\"uuid\": \"c071dfca-7240-441d-b9e0-6dd3e31ed03e\", \"value\": \"00:00\", \"isLocked\": true}, \"Sat-May-17\": {\"uuid\": \"2a61a8e1-72e5-4cfb-89cb-78d4c646d2a8\", \"value\": \"04:00\", \"isLocked\": true}, \"Sun-May-18\": {\"uuid\": \"1e4aed22-fccb-49ab-91b6-7ca4d21147f5\", \"value\": \"00:00\", \"isLocked\": true}, \"Thu-May-15\": {\"uuid\": \"5530efa7-b425-429c-9a99-af25f8ded9fe\", \"value\": \"00:00\", \"isLocked\": true}, \"Tue-May-13\": {\"uuid\": \"1baba9e0-b801-4122-ae7b-9903d47d1d42\", \"value\": \"00:00\", \"isLocked\": true}, \"Wed-May-14\": {\"uuid\": \"35c8f400-28b2-4f96-af31-ebda97af9c4f\", \"value\": \"00:00\", \"isLocked\": true}}]',
    48.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-05-20 05:46:58',
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    NULL,
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26'
  );
INSERT INTO
  `employee_weekly_timesheets` (
    `uuid`,
    `employeeId`,
    `requestNumber`,
    `weekStartDate`,
    `weekEndDate`,
    `taskDetails`,
    `totalHours`,
    `approvalStatus`,
    `approverId`,
    `approverRole`,
    `approvalDate`,
    `approverComments`,
    `timeSheetStatus`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`
  )
VALUES
  (
    'f8c7b300-0f52-4106-899b-d7a8a626d50f',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    609700,
    '2025-04-07',
    '2025-04-13',
    '[{\"task\": {\"uuid\": \"b0c116c2-e759-444a-8e65-d6d70ff93ec0\", \"value\": \"write junit test cases for Service package of Reporting\", \"isLocked\": false}, \"rowTotal\": {\"uuid\": \"2ebadc19-b065-4c6c-8583-4bfc143d56a6\", \"value\": \"33:00\", \"isLocked\": false}, \"Fri-Apr-11\": {\"uuid\": \"30b3774e-7222-45e5-9ba1-1eecd3f88c74\", \"value\": \"09:00\", \"isLocked\": true}, \"Mon-Apr-07\": {\"uuid\": \"6d9cb9ec-9159-477f-8967-7da95de90a03\", \"value\": \"08:00\", \"isLocked\": true}, \"Sat-Apr-12\": {\"uuid\": \"a224ee25-ac9a-4f8c-8b92-d7d9f7180b57\", \"value\": \"00:00\", \"isLocked\": true}, \"Sun-Apr-13\": {\"uuid\": \"15cc1d4d-074a-4981-92d7-6eedece04a1a\", \"value\": \"00:00\", \"isLocked\": false}, \"Thu-Apr-10\": {\"uuid\": \"bdb35629-15e9-460d-aa6b-367117203097\", \"value\": \"08:00\", \"isLocked\": true}, \"Tue-Apr-08\": {\"uuid\": \"e5f0e415-141d-4299-aaf1-f48abffc158a\", \"value\": \"08:00\", \"isLocked\": true}, \"Wed-Apr-09\": {\"uuid\": \"48b51802-4e65-41d2-b557-1204b190c5ac\", \"value\": \"00:00\", \"isLocked\": true}}]',
    33.00,
    'REQUESTED',
    NULL,
    NULL,
    NULL,
    NULL,
    'REQUESTED',
    '2025-04-14 10:41:54',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    NULL,
    'b7b859f3-e78b-43a6-9752-457104c52024'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: employees
# ------------------------------------------------------------

INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '0612778c-0d59-4879-b108-617d5c51501f',
    'Ajay Jagannath Patil',
    'Male',
    '1994-07-11',
    '9823749292',
    'ajaypatil1107@gmail.com',
    'B+',
    'Married',
    'A/P:-KavathePiran, Tal:-Miraj, Dist:- Sangli,pincode-416416',
    'A/P:-KavathePiran, Tal:-Miraj, Dist:- Sangli,pincode-416416',
    'Father',
    '9850862165',
    'Other',
    '9960706800',
    'ES011',
    'ajay@embedsquare.com',
    '2020-04-21',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '91df356db9b83acbfa959c3a8fc4cf6e:ad646a91ab6573720adc29cada2259c4',
    '6368d9086b7c55ea627f90d2f19cf492:c84163af7d35571d51aca860e86e6ec0',
    'BKID0001609',
    '6d6306c0235fe4c4b1283987d06b7f92:fced90a52dbd3091ea6b66c84c4dfbdd',
    '',
    '',
    NULL,
    'Bachelor degree',
    '4',
    '',
    'Engineering',
    NULL,
    '2024-01-11 13:22:51',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-01-19 05:08:40',
    '0612778c-0d59-4879-b108-617d5c51501f',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '1dd6938b-e12f-4496-bbfe-c3e6dc3da4ec',
    'Amol Rajendra Rokade',
    'Male',
    '1992-10-21',
    '9518501427',
    'amolrokade121@gmail.com',
    '',
    'Married',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES027',
    'amol@embedsquare.com',
    '2023-02-15',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'PHP Developer-Laravel Specialist',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2024-01-11 13:07:07',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-01-12 06:25:28',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '1ee7a8c3-5c40-488a-8809-5da7dbb7737a',
    'Prafulla Gotmare',
    'Male',
    '2002-02-28',
    '9067335045',
    'prafullagotmare@gmail.com',
    'A+',
    'Married',
    '',
    '',
    '',
    '9822387639',
    '',
    '',
    'ES050',
    'praful@embedsquare.com ​You​',
    '2025-08-25',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '120000',
    'Intern',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2025-10-24 07:17:27',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-15 05:02:29',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    'Somnath Maheshinkar Rajure',
    'Male',
    '1988-04-23',
    '8600757311',
    'sachin.rajure@gmail.com',
    'AB+',
    'Married',
    'Gandhi chowk, Main road Ausa. Tal,Ausa Dist.Latur',
    'Keshav Nagar,Mataram nagar,near vithal rukmini mandir,Latur Pincode: 413512',
    'Brother',
    '9766111129',
    'Other',
    '8862026393',
    'ES037',
    'sachin@embedsquare.com',
    '2025-04-21',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Operations Executive',
    'ceb480e3c0a2dd2954a23eb70ffc0206:43b81f4a210976707d89e4d709719517',
    '3d6d059890dc05d40d068d7b1ecf39e9:c3b50a7025211d17d1ead9c7ca6368cb',
    'MAHB0000038',
    '56160b6e503a9d4eec62c09ebd9d4915:c6cbcbfbaf886de88f6f41cb9fa4a0b8',
    '9250d747e2d072b97c44e639d8064c47:8b53b49a64fade8af4ae29939c5a644a',
    '',
    NULL,
    'Bachelor degree',
    '13',
    NULL,
    'Finance',
    NULL,
    '2025-04-22 07:26:55',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2025-04-22 08:30:27',
    '4dc70b3d-7d22-4d22-ba1e-35be17624c26',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '4e19b7df-eca2-42a5-85ef-c2e5b0766e08',
    'Shashank S Reddy',
    'Male',
    '1997-11-14',
    '8050055501',
    'shashanksanjeevreddy@gmail.com',
    'O+',
    'UnMarried',
    'Plot number 276/277, Siddha Dhama, Mahaveer Nagar, near Kothari Bhavan, New Jewargi road, Kalaburagi, Karnataka - 585102',
    'E3/17, Girija Shankar Vihar, Gate number 1, opp Bhagirathi Children\'s hospital, Karve Nagar, Kothrud, Pune, Maharashtra 411052',
    'Sister',
    '8618384559',
    'Other',
    '9588653343',
    'ES038',
    'sreddy@embedsquare.com',
    '2025-04-01',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '49145f3b5d75f38854e4700e4f294a1b:ca03a3a181209b456495743110230956',
    'fc335c3319bf912b38917fddde4d0b91:e5ffc9b67ff35d204111b08d17bb6fff',
    '',
    '71f206b9a12559be8be3912f068c5052:7de8cdc36cedd8955b907968173c1d6e',
    'bbe592620b9527ae8cf85cc71fd49d31:8daf572974dadd0cc9992eb8e9db3049',
    '',
    NULL,
    'Master degree',
    '2',
    NULL,
    'Engineering',
    NULL,
    '2025-05-20 09:16:50',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '4e7d4f14-6fd7-49d9-8f9c-7903dc8d1973',
    'Atharva Babasaheb Aglawe',
    'Male',
    '2003-02-01',
    '8432313115',
    'atharva@embedsqure.com',
    'B+',
    'UnMarried',
    '',
    '',
    'Father',
    '9420026919',
    '',
    '',
    'ES049',
    'atharva@embedsquare.com',
    '2025-08-20',
    'f51968aa-f969-47cf-a0ee-51d4f8e1fb6f',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Intern',
    'a0887ed81b44ec5eb2cb0b967cf43664:615f9d37933af188fa52773a085e34ba',
    '49b90903b0ca568cb41eaa044b2a3c26:1f54d7712058f402bda2b64e735f51f1',
    '',
    'dd3895fb56884b37eb219ae4478abde8:680f5d0f1a3da4d8c7330a0a143124c1',
    'e3d911a2cc62f0fb6319342cb9b33f86:5dc2bc033504bd312719768e4ab1c2f3',
    '',
    NULL,
    'Bachelor degree',
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2025-11-04 10:48:39',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    NULL,
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '53bf67f4-5a40-450f-b160-e1e60f3c27c6',
    'Avinash Biradar',
    'Male',
    '1994-03-01',
    '9545998599',
    'biradaravi2109@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES003',
    'avinash@embedsquare.com',
    '2019-05-06',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2024-01-24 04:30:16',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-03-26 06:42:35',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'Uday Dhadve',
    'Male',
    '1986-04-03',
    '+91 2345678901',
    'uday.worx@gmail.com',
    'B+',
    'Married',
    '123 Main St\n123 Main St\n123 Main St',
    '456 Temp St\n123 Main St\n123 Main St',
    '',
    '',
    '',
    '',
    '0000001',
    'uday@embeds2.com',
    '2023-01-15',
    'System Manager',
    'System Manager',
    '50000',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'Bachelors in Computer Science',
    '',
    '',
    'Engineering',
    '',
    '2023-12-28 07:12:54',
    'system',
    '2024-01-15 23:05:13',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '5cb9d133-cf01-4c46-af9b-d52a9a77927b',
    'AKSHAY KARAN',
    'Male',
    '1986-02-07',
    '9766947172',
    'akshay.0713@gmail.com',
    'O+',
    'Married',
    '1502/04, ASPIRE TOWERS, AMANORA PARK TOWN, HADAPASAR, PUNE-411028',
    '1502/04, ASPIRE TOWERS, AMANORA PARK TOWN, HADAPASAR, PUNE-411028',
    'Mother',
    '9579855744',
    '',
    '',
    'ES022',
    'akshayk@embedsquare.com',
    '2022-03-01',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Technical Support',
    '9294f649012478b5be2ee6f92c6f35a1:ea3a4310825da36866ac32f7b52deb4a',
    '117f48e02d9c7c49abb2cd5309fea072:2209364730bbe161e1e5f870407fa8f1',
    '',
    '3fe648dab63086396ac5780a6812f66d:cc82e37fb963493f265bb1c8bd9cb0cc',
    '7700b95db6bb9e7074385acf89163301:6e9ab24028c41004e29eb5da29909121',
    '',
    NULL,
    'Bachelor degree',
    '0',
    NULL,
    'Engineering',
    NULL,
    '2025-10-27 09:06:39',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    NULL,
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '77ffe6b3-7bcc-45a1-b535-eb3451e79882',
    'Satyam Kumar',
    'Male',
    '1999-10-04',
    '9525872390',
    'satyamkumar.sk786@gmail.com',
    'B+',
    'UnMarried',
    '',
    '',
    'Brother',
    '8747841550',
    '',
    '',
    'ES047',
    'satyam@embedsquare.com',
    '2025-05-30',
    'f51968aa-f969-47cf-a0ee-51d4f8e1fb6f',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '192000',
    'Other',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    'Bachelor degree',
    NULL,
    NULL,
    'Other',
    NULL,
    '2025-10-24 04:55:57',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-10-24 06:47:28',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '8fd26dd9-65c8-4163-87c5-f005d5d0adef',
    'Vishwa Sapre',
    'Female',
    '1999-02-23',
    '9426805739',
    'sapre40vishwa@gmail.com',
    'A+',
    'Married',
    '',
    '',
    'Spouse',
    '8511150460',
    'Mother',
    '9428820244',
    'ES046',
    'vishwa@embedsqaure.com',
    '2025-08-18',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Other',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    'Bachelor degree',
    '3',
    NULL,
    'Engineering',
    NULL,
    '2025-09-01 07:12:05',
    '4af60173-f56f-44fe-a534-25d3a21967df',
    '2025-10-27 11:17:45',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    '9ea4e035-85e0-4e79-85dd-d7af24508391',
    'Shashank B Prajapati',
    'Male',
    '1999-05-11',
    '+919727387043',
    'shashank.spsp14@gmail.com',
    'O+',
    'UnMarried',
    'A-501 Shubhlaxmi Avenue Opp. Bhagwati Farm, Nr. Apollo International School, Tragad Road Chandkheda. Ahmedabad-382470',
    'A-501 Shubhlaxmi Avenue Opp. Bhagwati Farm, Nr. Apollo International School, Tragad Road Chandkheda. Ahmedabad-382470',
    'Other',
    '+91 9727387043',
    'Other',
    '+91 9727387043',
    'ES009',
    'shashank@embedsquare.com',
    '2020-02-12',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '7c7a6139026cf033d7f482878829c1cd:7aa50a0bb616b079d6821d2bc7034105',
    '4fc2f7ca3bdee55f056247caf6a5230d:74b35c80131de707def389cc0a535be4',
    'PUNB0092210',
    'b4929ba89f9af079ff325d44d968bfcd:9f2c5c9682ead2e1073cd815004eecf5',
    '',
    '',
    NULL,
    'Bachelor degree',
    '6',
    NULL,
    'Engineering',
    NULL,
    '2025-02-25 11:45:21',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2025-03-02 14:12:44',
    '9ea4e035-85e0-4e79-85dd-d7af24508391',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'ac236a3b-3093-4921-b876-d1b23873df93',
    'Krushna D Chaudhari',
    'Male',
    '1999-01-29',
    '+918623060863',
    'kdchaudhari755@gmail.com',
    'O-',
    'UnMarried',
    '',
    '',
    'Father',
    '8830496720',
    '',
    '',
    'ES035',
    'krishna@embedsquare.com',
    '2024-12-02',
    '0612778c-0d59-4879-b108-617d5c51501f',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    'Master degree',
    '2',
    NULL,
    'Engineering',
    NULL,
    '2025-03-26 10:01:14',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2025-11-05 05:14:11',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'b7b859f3-e78b-43a6-9752-457104c52024',
    'Neha Parmar',
    'Female',
    '1998-05-27',
    '',
    'nehakparmar27@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES026',
    'nehap@embedsquare.com',
    '2023-01-06',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2024-01-24 04:09:54',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-03-26 06:43:09',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'Snehal Atul Ghangale',
    'Female',
    '1990-03-10',
    '8329686620',
    'snehatul29@gmail.com',
    'A+',
    'Married',
    'C/O Mrs Gangabai Jadhav\n\nJai Shankar Prestige Flat no 2 1st Floor Chavan Nagar Telco Colony Ambegaon Budruk Pune 411046',
    '',
    '',
    '7020263646',
    '',
    '9967993455',
    'ES',
    'snehal.hr@embedsquare.com',
    '2025-10-05',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Hr Executive',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    'Bachelor degree',
    '9',
    NULL,
    'Human Resource',
    NULL,
    '2025-10-08 10:13:53',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-10-28 07:26:17',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'Chetan Bidap',
    'Male',
    '1987-01-01',
    '9898989891',
    'cbidap@gmail.com',
    '0',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '0000001',
    'cbidap@embedsquare.com',
    '2020-12-01',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    '',
    'Director',
    '',
    '',
    '',
    NULL,
    '',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2023-12-28 17:57:33',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    NULL,
    '5bebf1b8-f149-62js-87h3-52540245096b',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'd61998af-4667-42a2-a167-c136b3cc92d2',
    'Minaj Patwegar',
    'Female',
    '2003-07-02',
    '7020425163',
    'minajpatwegar@gmail.com',
    'A+',
    'UnMarried',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES045',
    'minaj@embedsqaure.com',
    '2025-09-01',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Other',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2025-09-11 05:27:25',
    '4af60173-f56f-44fe-a534-25d3a21967df',
    '2025-10-27 12:09:48',
    'd61998af-4667-42a2-a167-c136b3cc92d2',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'e41707fe-ce8f-4156-8ce1-a2d5c8c10070',
    'Alex',
    'Male',
    '1985-01-10',
    '9004085106',
    'alex@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES0091',
    'alex@embedsquare.com',
    '2019-09-11',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Consultant',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2024-01-10 07:04:05',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-01-18 05:10:11',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'e80e47fe-b12d-491d-bd6f-71a707d5d2cc',
    'Kishan Chauhan',
    'Male',
    '1998-02-05',
    '7383971658',
    'kishanchauhankk73@gmail.com',
    'B+',
    'UnMarried',
    '915/4 Ambar Colony Near Feni Hospital,\nThakkar Nagar, Ahmedabad, Gujarat - 382350',
    '915/4 Ambar Colony Near Feni Hospital,\nThakkar Nagar, Ahmedabad, Gujarat - 382350',
    'Brother',
    '7405488091',
    'Brother',
    '7383971658',
    'ES021',
    'kishan@embedsquare.com',
    '2022-01-31',
    '5cb9d133-cf01-4c46-af9b-d52a9a77927b',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Technical Support',
    '2b2c65d3e35859034956b60188c57d8d:eb4bc0153fff1a7e1f1521866d5143df',
    '',
    '',
    '',
    '',
    '',
    NULL,
    'Bachelor degree',
    '0',
    NULL,
    'Engineering',
    NULL,
    '2025-11-04 10:11:17',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-05 04:29:01',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'eca7545f-2c1d-4170-836e-5f863a05db2e',
    'Surya Bhushan Prasad Manjhi',
    'Male',
    '1999-03-04',
    '8651989809',
    'manjhi.suryaa@gmail.com',
    'O+',
    'UnMarried',
    '',
    '',
    'Mother',
    '7464001500',
    '',
    '',
    'ES035',
    'surya@embedsquare.com',
    '2024-06-21',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    'aad9eaeb66ae143244100ab9e66b63cb:c7b15dc5acfa379688d921313cc6c81a',
    '363c7e8e4866b03332d14c0e8cae33df:b9dbed33f00837af76a2e9ea72ed49dd',
    '',
    'd9310b9f8ec5ad5bc3d8a268ea49d786:6990d5b3932bc2cab05d85ad08b16f39',
    '9c12c8e9b8f168e7ecad5c6837158b92:38d290443e2a009934685b89f229bebb',
    '',
    NULL,
    'Bachelor degree',
    'more than 6 months',
    NULL,
    'Engineering',
    NULL,
    '2024-12-12 11:21:19',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'f2858862-37a1-4724-a534-eb7f7e1764d0',
    'Ganesh Sanap',
    'Male',
    '1992-08-31',
    '9762477209',
    'aniketalure@gmail.com',
    'AB+',
    'Married',
    '15,Ramtilak Apartment,Sai Chowk,Sector No.1,Indrayani Nager,Bhosari,Pune-411039',
    '',
    '',
    '',
    '',
    '',
    'ES012',
    'ganesh@embedsquare.com',
    '2020-07-06',
    '5cb9d133-cf01-4c46-af9b-d52a9a77927b',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '1400000 ',
    'Technical Support',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2025-10-11 11:04:31',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-05 05:13:28',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'f51968aa-f969-47cf-a0ee-51d4f8e1fb6f',
    'Rushikesh Palande',
    'Male',
    '2001-02-07',
    '8459972812',
    'rishikesh.palande07@gmail.com',
    'B+',
    'UnMarried',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES040',
    'rushikesh@embedsquare.com',
    '2025-01-20',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Software Engineer',
    '892ac377c03d798c73c7527a6cc2cd1c:17afc0351015db9a3f873f42b787303e',
    '037b8ada4ca442feba6f25e8fef2c932:b62dfea967621c5a8c8938f08e11efce',
    '',
    'e818db27e3e504d55958a2c076515531:34c038d8189a54f234d1f44f568de9a4',
    'ae5768dec0f42eb794e96f21eb2e7beb:689b069568cf9413b412efda2960a8da',
    '',
    NULL,
    'Master degree',
    '1',
    NULL,
    'Engineering',
    NULL,
    '2025-06-25 11:52:28',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    'Atul Joshi',
    'Male',
    '1990-07-17',
    '',
    'uniqatul3@gmail.com',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES020',
    'atul@embedsquare.com',
    '2021-10-25',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Senior Software Engineer',
    '',
    '',
    '',
    '',
    '',
    '',
    NULL,
    NULL,
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2024-01-24 04:23:02',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    '2024-03-26 06:47:44',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'fe15c5a3-2dec-4f83-a33f-313e60e1c6fd',
    'Prafulla Gotmare',
    'Male',
    '2002-02-28',
    '9067335045',
    'prafulla@gmail.com',
    'A+',
    'UnMarried',
    '116 Sumangal Housing soc opp Sancheti public school Nagpur ',
    'F1 BL C4 128/2B Vedant Co-op soc Sus road Pashan Pune 411021',
    'Other',
    '9889576850',
    '',
    '',
    'ES050',
    'praful@embedsquare.com',
    '2025-08-25',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '',
    'Intern',
    'c04419ea3a4bd94cbf2ec4b92b3bfc24:12d84e6b07595ef5b959b5bf77d2bd2f',
    '094275f003f5cbe2eb8ecfc3853cb02c:3a6c70edef35b8110b50abbe03db13c2',
    '',
    '3e6e50efbc0744516b844832a13ffe95:6b6a0cdc3c90f3c48e21181a8a63c015',
    'ff09e305c7a9b4061425db57fd885fba:5c635a5cc148f059101f16a5b7d75f78',
    '',
    NULL,
    'Bachelor degree',
    NULL,
    NULL,
    'Engineering',
    NULL,
    '2025-11-20 10:16:46',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    NULL,
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    'ACTIVE'
  );
INSERT INTO
  `employees` (
    `uuid`,
    `name`,
    `gender`,
    `dateOfBirth`,
    `contactNumber`,
    `personalEmail`,
    `bloodGroup`,
    `maritalStatus`,
    `permanentAddress`,
    `temporaryAddress`,
    `emergencyContactNumber1Of`,
    `emergencyContactNumber1`,
    `emergencyContactNumber2Of`,
    `emergencyContactNumber2`,
    `employeeId`,
    `officialEmailId`,
    `dateOfJoining`,
    `reportingManagerId`,
    `reportingDirectorId`,
    `currentCtc`,
    `designation`,
    `panCardNumber`,
    `bankAccountNumber`,
    `ifscCode`,
    `aadhaarCardNumber`,
    `pfAccountNumber`,
    `bankPassbookImage`,
    `recentPhotograph`,
    `highestEducationalQualification`,
    `totalWorkExperience`,
    `skills`,
    `department`,
    `linkedIn`,
    `createdAt`,
    `createdBy`,
    `updatedAt`,
    `updatedBy`,
    `employmentStatus`
  )
VALUES
  (
    'ffd826ce-5585-4a76-9b57-6821a68619e3',
    'Nitin Kumar Upadhyay',
    'Male',
    '1995-07-24',
    '',
    'upadhyay.nitin.247@gmail.com',
    'O+',
    'UnMarried',
    '',
    '',
    '',
    '',
    '',
    '',
    'ES031',
    'nitin@embedsquare.com',
    '2024-01-15',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    NULL,
    '',
    'Software Engineer',
    '4704429df541a50414384355d0b03b1f:dc6ebfb1b5a1c5a18840e495422e9831',
    '1afcedb0ee08e9b6e230742ccd91c98a:d31e0cd7bba4b172b3ac0a0f46fa6310',
    '',
    '5521bf2045dfa30656cfbb983fc0b4bb:50a2727499061dc8d22041c878af23dc',
    'b661a7a613fc37c8f9458904fcead1e5:49cdce2214167c279173b12f61487ef6',
    '',
    NULL,
    NULL,
    NULL,
    '',
    'Engineering',
    NULL,
    '2024-01-15 11:12:32',
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    NULL,
    '9a8a9a94-ae34-4130-8b4a-8f8a987550ef',
    'ACTIVE'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: migrations
# ------------------------------------------------------------

INSERT INTO
  `migrations` (`name`)
VALUES
  ('00001-create-employees-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00002-create-user-tables.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00003-insert-initial-employee.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00004-insert-initial-user.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00005-create-leave-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00006-create-employee-documents.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00007-create-employee-timesheet.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00008-create-employee-leave-allocation.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00009-create-employee-activity-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00010-create-weekly-timesheet-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00011-create-employee-online-status.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00012-create-user-password-reset-request-.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00013-schedule-event-reset-req-expire.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00014-create-holiday-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00015-create-customer-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00016-create-project-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00017-insert-initial-project.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  (
    '00018-create-customer-resource-allocation-table.js'
  );
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00019-create-customer-access-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00020-create-employee-preference-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00021-create-master-data.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00022-insert-initial-fields.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00023-create-survey-config-table.js');
INSERT INTO
  `migrations` (`name`)
VALUES
  ('00024-create-survey-results-table.js');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: migrations_lock
# ------------------------------------------------------------

INSERT INTO
  `migrations_lock` (`is_locked`)
VALUES
  (0);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: org_holidays
# ------------------------------------------------------------

INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '1a8f325a-3fff-43ae-9e27-ddbcb6a401bd',
    'Ganesh Chaturthi',
    '2025-08-27 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '27c91296-50d4-43a6-852b-c02cb712631f',
    'Mahatma Gandhi Jayanti/ Dussehra',
    '2025-10-02 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '3fe0f1ff-af21-4574-b99c-0c0f99e7a463',
    'New Year\'s Day',
    '2025-01-01 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '4815ece4-2440-4bc2-bcd2-c6fce2dcb4a1',
    'Holi',
    '2025-03-14 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '606aac40-9d0a-4e1b-ba15-aa9bc517f0f6',
    'New Year Day',
    '2024-01-01 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '647416a2-363e-4960-88ec-d89ae16b9590',
    'Rama Navami',
    '2024-04-17 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '6e2dacea-96ab-4881-ab30-f32a42c6c8ff',
    'Diwali',
    '2024-11-01 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '7d11d932-653a-429b-8f07-502a88481eba',
    'Republic Day',
    '2024-01-26 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '7e415603-abc2-43e6-8ad9-029e7d47bb55',
    'Laxmipujan-Diwali',
    '2025-10-21 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '80525b07-18e9-48d3-9d90-7a517096f6d4',
    'Good Friday',
    '2025-04-18 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '8235e09a-f282-490b-bfef-adc13bbe9f6e',
    'Maharashtra day / Labour Day',
    '2024-05-01 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '8247ace2-7531-409a-92a1-dbe47cd1e9a6',
    'Diwali',
    '2025-10-20 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '866ba3a1-a672-4488-8d77-5b45ed786b29',
    'Maha Shivratri',
    '2025-02-26 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '8921584e-a3ea-4515-8eee-d46551ffb1d4',
    'Guru Nanak Jayanti',
    '2024-11-15 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '8f71cef2-7a2a-4d1f-9ea2-849ab38c6b99',
    'Gudi Padwa',
    '2024-04-09 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '921a0619-f614-4ab6-901a-315bd24cb397',
    'Independence Day',
    '2024-08-15 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    '94b124f3-35d6-4ac8-8723-75ac6e6cba54',
    'Navratri',
    '2024-10-11 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'bc386fbe-d157-45f1-b6a6-690807b9efaf',
    'Gandhi Jayanti',
    '2024-10-02 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'c55158be-748d-4686-a911-cd20f56dccfe',
    'Christmas',
    '2024-12-25 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'c9e8c476-9df2-4416-92dd-d7633d9dc7e7',
    'Holi',
    '2024-03-25 00:00:00',
    2024,
    'IN',
    '5bebf1b8-f149-62js-87h3-52540245096b',
    '2024-01-11 20:30:36'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'cfdcadf7-4302-46f8-b1e7-9372cafc92e3',
    'Independence Day',
    '2025-08-15 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'f4724402-0802-4d27-a2bb-004674179b93',
    'Maharashtra Day',
    '2025-05-01 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );
INSERT INTO
  `org_holidays` (
    `uuid`,
    `name`,
    `date`,
    `year`,
    `countryCode`,
    `createdBy`,
    `createdAt`
  )
VALUES
  (
    'fc5c14af-e8b3-48b8-ad24-7810daa5d4ed',
    'Christmas ',
    '2025-12-25 00:00:00',
    2025,
    'IN',
    'bf936c19-eec2-42f2-b39c-4025d761ef81',
    '2025-11-13 07:10:54'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: project_resource_allocation
# ------------------------------------------------------------

INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '291e5628-b121-494d-97f3-9c439dccfa9a',
    'BXBI7A0',
    'X101',
    '7fa1942e-b6f7-4e91-9f18-6003990961ac',
    '53bf67f4-5a40-450f-b160-e1e60f3c27c6',
    '2024-01-01',
    '2024-04-30',
    'Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-25 00:42:15',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-25 00:42:15'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '53d6ca18-ee67-4f97-bc45-e7bb1ca2bd6a',
    'ZYWRILQ',
    'X101',
    'd5854934-a0ec-4997-ab4b-52a6cbca19fa',
    '1dd6938b-e12f-4496-bbfe-c3e6dc3da4ec',
    '2024-01-01',
    '2024-07-31',
    'PHP Developer-Laravel Specialist',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-31 07:36:43',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:32:18'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    '5b91456b-35e2-4600-9a10-9de112b03a36',
    'WNMB5G6',
    'X101',
    'af90f00e-c148-4edc-ba09-72781244d87f',
    '9ea4e035-85e0-4e79-85dd-d7af24508391',
    '2025-02-24',
    '2027-02-02',
    'Software Engineer',
    0,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:13:51',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:13:51'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'ad018b88-9dfd-47aa-a289-c47addb14e59',
    'EGXXTK4',
    'X101',
    'af90f00e-c148-4edc-ba09-72781244d87f',
    '53bf67f4-5a40-450f-b160-e1e60f3c27c6',
    '2025-02-24',
    '2027-02-01',
    'Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:53:49',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 10:53:49'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'cdae39f4-8faf-43f1-baf7-6eae884378a2',
    'B01YF4D',
    'X101',
    'd82ff270-9b0a-4316-b850-a7a926d9075c',
    'b7b859f3-e78b-43a6-9752-457104c52024',
    '2024-01-05',
    '2024-07-31',
    'Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-24 09:51:33',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-24 09:51:33'
  );
INSERT INTO
  `project_resource_allocation` (
    `uuid`,
    `allocationCode`,
    `projectId`,
    `customerId`,
    `employeeId`,
    `startDate`,
    `endDate`,
    `role`,
    `customerApprover`,
    `status`,
    `createdBy`,
    `createdAt`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'ffa1264a-eec5-4b21-9a2a-6fa6a6b57cbc',
    'Y7IE11T',
    'X101',
    'd5854934-a0ec-4997-ab4b-52a6cbca19fa',
    'f598a09a-6a20-4e8b-9fc6-1167a48a1270',
    '2024-01-01',
    '2024-07-01',
    'Senior Software Engineer',
    1,
    'ACTIVE',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2024-01-31 07:36:04',
    'd0092cbf-3a8b-4b07-86f9-789f7d7eb055',
    '2025-02-25 12:32:03'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: projects
# ------------------------------------------------------------

INSERT INTO
  `projects` (
    `uuid`,
    `name`,
    `domain`,
    `description`,
    `location`,
    `status`,
    `projectCode`,
    `labels`,
    `customerId`,
    `priority`,
    `category`,
    `createdAt`,
    `startDate`,
    `endDate`,
    `createdBy`,
    `updatedBy`,
    `updatedAt`
  )
VALUES
  (
    'X101',
    'Default System Project',
    'Default Domain',
    'This is a system-generated project for initial setup.',
    'Default Location',
    'INITIATED',
    '',
    '',
    '',
    'NORMAL',
    '',
    '2023-12-28 07:12:54',
    NULL,
    NULL,
    'system_user_id',
    'system_user_id',
    NULL
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: survey_config
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_password_reset_request
# ------------------------------------------------------------


