/****** Default Script Date: 08/27/2019 15:39:33 ******/
SET IDENTITY_INSERT [dbo].[TA_Tbl_TerminalBrand] ON
INSERT [dbo].[TA_Tbl_TerminalBrand] ([BrandID], [DisplayName], [KeyValue]) VALUES (1, CONVERT(TEXT, N'Hanvon Face Recognition'), CONVERT(TEXT, N'Hanvon'))
INSERT [dbo].[TA_Tbl_TerminalBrand] ([BrandID], [DisplayName], [KeyValue]) VALUES (2, CONVERT(TEXT, N'Others'), CONVERT(TEXT, N'Others'))
INSERT [dbo].[TA_Tbl_TerminalBrand] ([BrandID], [DisplayName], [KeyValue]) VALUES (3, CONVERT(TEXT, N'Suprema'), CONVERT(TEXT, N'Suprema'))
INSERT [dbo].[TA_Tbl_TerminalBrand] ([BrandID], [DisplayName], [KeyValue]) VALUES (4, CONVERT(TEXT, N'Suprema-Biostar 2'), CONVERT(TEXT, N'Suprema-Biostar 2'))
INSERT [dbo].[TA_Tbl_TerminalBrand] ([BrandID], [DisplayName], [KeyValue]) VALUES (5, CONVERT(TEXT, N'ESSL'), CONVERT(TEXT, N'ESSL'))
INSERT [dbo].[TA_Tbl_TerminalBrand] ([BrandID], [DisplayName], [KeyValue]) VALUES (6, CONVERT(TEXT, N'ZK Teco'), CONVERT(TEXT, N'ZK Teco'))
SET IDENTITY_INSERT [dbo].[TA_Tbl_TerminalBrand] OFF
Go
--Page Table
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (194, N'Menu_Configuration', N'', 0, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (189, N'Organization_Settings', N'', 0, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (187, N'Device_Management', N'', 0, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (204, N'Menu_EMp_Master', N'', 188, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (190, N'Privilege_Management', N'', 0, 13, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (188, N'Employee_Management', N'', 0, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (235, N'Shift_Management', N'', 0, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (236, N'Leave_Permission_Management', N'', 0, 7, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (237, N'ManualTimeEntry', N'', 0, 9, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (192, N'Menu_Reports', N'', 0, 11, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (193, N'Other_useful_features', N'', 0, 14, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (230, N'Menu_Vehicle', N'Masters/TA_UI_MasterTransportationVehicleList.aspx', 12, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (195, N'Menu_LeaveType', N'Masters/TA_UI_MasterLeaveTypeList.aspx', 209, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (177, N'Masters_EmailConfiguration', N'Masters/TA_UI_EmailScheduleList.aspx', 0, 12, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (209, N'Menu_Leave_Master', N'', 236, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (196, N'Menu_LeavePolicy', N'Masters/TA_UI_MasterLeavePolicyList.aspx', 209, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (205, N'Menu_EMp_Report', N'', 188, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (197, N'Menu_LicenseRequistion', N'System Settings/SystemSetting_LicenseRequest.aspx', 107, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (198, N'Menu_Licenseupdater', N'System Settings/SystemSetting_LicenseUpdater.aspx', 107, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (199, N'Menu_LicenseInfo', N'System Settings/SystemSetting_ViewLicenseInfo.aspx', 107, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (231, N'Menu_Route', N'Masters/TA_UI_MasterTransportationRouteList.aspx', 12, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (202, N'ShiftAllocationExport', N'Transactions/TA_UI_Transaction_ShiftExport.aspx', 207, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (203, N'DataReprocessing', N'Transactions/TA_UI_Transaction_DataReprocessing.aspx', 207, 7, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (206, N'Menu_Shift_Master', N'', 235, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (207, N'Menu_Shift_Transaction', N'', 235, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (208, N'Menu_Shift_Reports', N'', 235, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (210, N'Menu_Leave_Transaction', N'', 236, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (211, N'Menu_Leave_Reports', N'', 236, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (212, N'Menu_ME_Transaction', N'', 237, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (213, N'Menu_ME_Reports', N'', 237, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (214, N'Menu_OTCOMPOff', N'', 0, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (215, N'Menu_OnDuty', N'', 0, 8, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (216, N'Menu_Permission_Transaction', N'', 236, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (218, N'Menu_ED_Transaction', N'', 217, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (217, N'Menu_ExportData', N'', 0, 10, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (219, N'Menu_ED_Reports', N'', 217, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (220, N'Menu_ME_Import', N'Transactions/TA_UI_Transactions_ManualEntryImport.aspx', 212, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (221, N'Menu_ME_Export', N'Transactions/TA_UI_Transactions_ManualEntryExport.aspx', 212, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (222, N'Menu_ME_Discrepancy', N'Transactions/TA_UI_Transactions_DiscrepancyList.aspx', 212, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (223, N'Menu_TerminalDB', N'Masters/TA_UI_Master_TerminalDatatype.aspx', 10, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (224, N'Menu_TerminalMaster', N'Masters/TA_UI_Master_Terminal.aspx', 10, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (225, N'Menu_Country', N'Masters/TA_UI_Master_CountryList.aspx', 204, 7, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (226, N'Menu_State', N'Masters/TA_UI_Master_StateList.aspx', 204, 8, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (227, N'Menu_City', N'Masters/TA_UI_Master_CityList.aspx', 204, 9, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (228, N'Menu_Grade', N'Masters/TA_UI_Master_GradeList.aspx', 204, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (229, N'Menu_Region', N'Masters/TA_UI_Master_ReligionList.aspx', 204, 10, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (232, N'Menu_Dev_EmpDetails', N'Reports/TA_UI_XGReportEmployeeDetail.aspx', 147, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (233, N'Menu_Dev_Attendance', N'Reports/TA_UI_XGReportAttendance.aspx', 147, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (234, N'Menu_Dev_AllSwipes', N'Reports/TA_UI_XGReportMovementsEntry.aspx', 147, 7, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (179, N'Menu_Master_Dashboard', N'DashBoard.aspx', 0, 0, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (6, N'Master_Organization', N'Masters/TA_UI_Master_OrganisationLevels.aspx', 189, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (10, N'Master_Terminal', N'', 187, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (15, N'Master_Entrance', N'Masters/TA_UI_Master_Entrance.aspx', 187, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (68, N'Master_Punch', N'Masters/TA_UI_Master_PunchTypes_List.aspx', 187, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (17, N'Master_Designation', N'Masters/TA_UI_Master_TitleFirstList.aspx', 204, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (94, N'Master_Category', N'Masters/TA_UI_Master_EmployeeCategoryList.aspx', 204, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (95, N'Master_Type', N'Masters/TA_UI_Master_EmployeeTypeList.aspx', 204, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (18, N'Master_Employee', N'Masters/TA_UI_Master_Employee.aspx', 204, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (19, N'Master_Shift', N'Masters/TA_UI_Master_ShiftDetails.aspx', 206, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (20, N'Master_Shift_Pattern', N'Masters/TA_UI_Master_ShiftPattern.aspx', 206, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (69, N'Master_Shift_Roster', N'Masters/TA_UI_Master_ShiftRoaster.aspx', 206, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (16, N'Master_Holidays', N'Masters/TA_UI_Master_Holiday.aspx', 194, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (99, N'Master_AttandanceCode', N'Masters/TA_UI_Master_AttandanceCode.aspx', 193, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (100, N'Master_OverTimeType', N'Masters/TA_UI_Master_OverTimeType.aspx', 193, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (12, N'Master_Transportation', N'', 193, 9, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (21, N'Master_User_Groups', N'Masters/TA_UI_Master_groupView.aspx', 190, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (26, N'Transcation_Manual_Time', N'Transactions/TA_UI_Transactions_ManualTimeEntry.aspx', 212, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (98, N'Transcation_ManualTimeEntry_Approval', N'Transactions/TA_UI_Transactions_ManualTimeEntrySanction.aspx', 212, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (22, N'Transaction_Leave_Application', N'Transactions/TA_UI_Transactions_LeaveApplication.aspx', 210, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (173, N'Transaction_OnDuty', N'Transactions/TA_UI_Transactions_OnDutyList.aspx', 215, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (108, N'Transaction_LeavePolicyAllocation', N'Transactions/TA_UI_Transactions_GroupLeavePolicy.aspx', 210, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (96, N'Transaction_BonusLeave', N'Transactions/TA_UI_Transactions_BonusLeaveAllocation.aspx', 210, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (23, N'Transaction_Permission', N'Transactions/TA_UI_Transactions_LeavePermission.aspx', 216, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (248, N'Transaction_Approvals', N'Transactions/TA_UI_Transaction_Sanctions.aspx', 236, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (28, N'Transaction_Shift_Allocation', N'Transactions/TA_UI_Transaction_ShiftAllocation.aspx', 207, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (29, N'Tranaction_Temporary_Shift', N'Transactions/TA_UI_Transaction_TemporaryShiftAllocationadd.aspx', 207, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (60, N'Transaction_Shift_Exchange', N'Transactions/TA_UI_Transaction_ShiftExchangeList.aspx', 207, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (116, N'Caption_ShiftReAllocation', N'Transactions/TA_UI_Transactions_ShiftReAllocation.aspx', 207, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (97, N'Transaction_OverTime_Sanction', N'Transactions/TA_UI_Transactions_OverTimeSanction.aspx', 214, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (102, N'Transaction_SwipesHandling', N'Transactions/TA_UI_Transactions_SwipesHandlingList.aspx', 212, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (27, N'Transcation_Payroll', N'Transactions/TA_UI_Transactions_MonthClosure.aspx', 218, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (62, N'Transaction_Year_Closure', N'Transactions/TA_UI_Transactions_YearClosureAdd.aspx', 218, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (76, N'Transaction_Encashment', N'Transactions/TA_UI_Transaction_Encashment.aspx', 210, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (144, N'Menu_Report_Attendace', N'', 192, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (180, N'Report_GeneralMonthly_Attendance', N'Reports/TA_UI_Report_GeneralMonthlyAttendance.aspx', 144, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (41, N'Report_All_Swipes', N'Reports/TA_UI_Report_MovementsEntry.aspx', 144, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (40, N'Report_Monthly_Attendance', N'Reports/TA_UI_Report_MonthlyAttendance.aspx', 144, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (30, N'Report_Detailed_Attendance', N'Reports/TA_UI_Report_DetailAttendance.aspx', 144, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (105, N'MustoRollReport', N'Reports/TA_UI_report_EmployeeInOut.aspx', 144, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (118, N'Report_SummaryReport', N'Reports/TA_UI_Report_Summary.aspx', 144, 8, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (45, N'Report_Total_Days', N'Reports/TA_UI_Report_TotalDays.aspx', 144, 7, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (39, N'Report_Punctuality', N'Reports/TA_UI_Report_Punctuality.aspx', 144, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (92, N'Report_ManualTimeEntry', N'Reports/TA_UI_Report_ManualTimeEntry.aspx', 213, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (175, N'Report_OnDutyEntry', N'Reports/TA_UI_Report_OnDutyEntry.aspx', 215, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (145, N'Menu_Reports_Entries', N'', 192, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (34, N'Report_Absent', N'Reports/TA_UI_Report_Absentes.aspx', 145, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (33, N'Report_Discrepancy', N'Reports/TA_UI_Report_Discrepancy.aspx', 213, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (37, N'Report_Late_Entry', N'Reports/TA_UI_Report_LateInstance.aspx', 145, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (127, N'Report_LessHoursWorked', N'Reports/TA_UI_Report_LessHoursWorked.aspx', 145, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (147, N'Menu_Reports_Shifts', N'', 192, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (44, N'Report_Shift', N'Reports/TA_UI_Report_Shift.aspx', 208, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (32, N'Report_Employee_Shift_Allocation', N'Reports/TA_UI_Report_EmployeeShiftAllocation.aspx', 208, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (36, N'Report_Overtime', N'Reports/TA_UI_Report_OverTime.aspx', 214, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (35, N'Report_Leave', N'Reports/TA_UI_Report_LeaveApplication.aspx', 211, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (117, N'Report_LeavePolicyNotAllocated', N'Reports/TA_UI_Report_LeavePolicyNotAllocated.aspx', 211, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (183, N'Report_RawData', N'Reports/TA_UI_Report_RawData.aspx', 144, 9, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (89, N'Report_Permission', N'Reports/TA_UI_Report_Permission.aspx', 236, 5, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (42, N'Report_Employee_Details', N'Reports/TA_UI_Report_Employee.aspx', 205, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (84, N'Report_EmployeeHistory', N'Reports/TA_UI_Report_EmployeeHistory.aspx', 205, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (71, N'Report_Payroll', N'Reports/TA_UI_Report_PayRoll.aspx', 219, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (70, N'Report_Year_Closure', N'Reports/TA_UI_Report_YearClosure.aspx', 219, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (79, N'Report_Audit_Trail', N'Reports/TA_UI_Report_AuditTrail.aspx', 147, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (43, N'Report_Document_Expiry', N'Reports/TA_UI_Report_DocumentExpiry.aspx', 147, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (160, N'Report_WeeklyWorkHours', N'Reports/TA_UI_Report_WeeklyWorkHours.aspx', 147, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (171, N'Report_CountFactor_WorkingDays', N'Reports/TA_UI_Report_TotalWorkingDays.aspx', 147, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (47, N'Org_Level_Settings', N'Organization Settings/Organization_levels.aspx', 189, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (51, N'Org_Shift_Settings', N'Organization Settings/Organization_shiftSetting.aspx', 194, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (52, N'Org_Holiday_Setting', N'Organization Settings/Organization_HolidaySetting.aspx', 194, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (50, N'Org_Year_Setting', N'Organization Settings/Organization_YearSetting.aspx', 194, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (103, N'Flexi_Settings_Menu', N'Organization Settings/Organization_EmployeeFlexiEligible.aspx', 204, 6, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (48, N'Org_Temporary_Weekday', N'Organization Settings/Organization_Tempweekdaylist.aspx', 193, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (49, N'Org_Additional_Weeklyoff', N'Organization Settings/Organization_AddlWeekoff.aspx', 193, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (72, N'Org_Login_List', N'Organization Settings/LoginList.aspx', 193, 7, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (53, N'Org_News', N'Organization Settings/Organization_NewsView.aspx', 193, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (54, N'System_Change_Password', N'System Settings/System_ChangePassword.aspx', 190, 2, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (55, N'System_Reset_Password', N'System Settings/System_ResetPassword.aspx', 190, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (104, N'Import_Data', N'System Settings/importEmployee.aspx', 204, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (66, N'System_Export_Data', N'System Settings/ExportData.aspx', 218, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (78, N'System_Audit_Trail', N'System Settings/System_AuditTrail.aspx', 193, 4, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (75, N'System_MultiLingual', N'System Settings/System_Multilingual.aspx', 194, 8, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (107, N'System_LicenseManager', N'', 193, 8, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (109, N'System_DatabaseInformation', N'System Settings/SystemSetting_DatabaseInformation.aspx', 193, 10, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu])  VALUES (246, N'Menu_Master_MyCalendar', N'MyCalendar.aspx', 0, 0.1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu])  VALUES (254, N'Menu_CompOffCreditEntry', N'Transactions/TA_UI_Transactions_ManualCompensationEntry.aspx', 214, 1, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (255, N'NearestShiftAllocation', N'Transactions/TA_UI_Transaction_NearestShiftAllocation.aspx', 207, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (249, N'Menu_help', N'Help/Help.aspx', 0, 15, NULL)
--User Group Table
INSERT  INTO [dbo].[TA_Tbl_Usergroup] ([groupName], [IndividualUsers], [hasSpecialRights], [timeStamp], [isDeleted], [Emp_Id]) VALUES (N'SuperAdmin', 0, NULL, GETDATE(), 0, NULL)
INSERT  INTO [dbo].[TA_Tbl_Usergroup] ([groupName], [IndividualUsers], [hasSpecialRights], [timeStamp], [isDeleted], [Emp_Id]) VALUES (N'IndividualUsers', 1, 0, GETDATE(), 0, N'1')
--User Rights Table
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 144, 192, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 145, 192, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 147, 192, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 19, 206, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 20, 206, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 69, 206, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 28, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 29, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 60, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 76, 210, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 116, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 44, 208, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 32, 208, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 22, 210, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 23, 216, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 248, 236, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 27, 218, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 62, 218, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 96, 210, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 108, 210, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 35, 211, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 89, 236, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 117, 211, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 26, 212, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 97, 214, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 98, 212, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 102, 212, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 92, 213, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 173, 215, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 175, 215, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 10, 187, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 15, 187, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 68, 187, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 17, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 18, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 94, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 95, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 42, 205, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 84, 205, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 103, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 6, 189, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 12, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 99, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 100, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 197, 107, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 47, 189, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 48, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 49, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 50, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 51, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 53, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 72, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 21, 190, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 30, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 36, 214, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 39, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 41, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 40, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 45, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 105, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 118, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 43, 147, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 79, 147, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 71, 219, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 70, 219, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 16, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 52, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 37, 145, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 34, 145, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 33, 213, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 127, 145, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 198, 107, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 66, 218, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 75, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 67, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 77, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 106, 194, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 109, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 54, 190, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 55, 190, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 104, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 107, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 78, 193, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 160, 147, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 171, 147, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 216, 236, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 180, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 183, 144, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 199, 107, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 195, 209, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 196, 209, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 232, 147, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 204, 188, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 205, 188, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 206, 235, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 207, 235, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 208, 235, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 209, 236, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 210, 236, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 211, 236, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 212, 237, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 213, 237, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 218, 217, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 219, 217, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 201, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 202, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 203, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 220, 212, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 221, 212, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 222, 212, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 223, 10, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 224, 10, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 225, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 226, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 227, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 228, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 229, 204, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 230, 12, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 231, 12, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 233, 147, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 234, 147, 0, 0, 0, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 179, 179, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'Superadmin', 1, 177, 177, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 243, 194, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 244, 194, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 245, 194, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 246, 246, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 254, 214, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin', 1, 255, 207, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'SuperAdmin',1,249,249,1,1,1,1,1,GETDATE(),1)
--Employee Table
INSERT  INTO [dbo].[TA_Tbl_Employee] ([UserGroup_Id], [ShiftPattern_Id], [Bus_Id], [Employee_FirstName], [Employee_MiddleName], [Employee_LastName], [Father_name], [Mother_name], [DateofBirth], [DateofBirth_Record], [Blood_Group], [EmailId], [Contact_Address], [Permanent_Address], [Phone_Number], [Mobile_Number], [Gender], [Marital_status], [Nationality], [Religion], [Photo], [Personal_mailid], [Passport_No], [Passport_expirydate], [Visa_No], [Visa_expirydate], [Vehicle_Type], [Vehicle_No], [Anniversary_Date], [Native_Place], [District], [State], [Country], [Spouse_No], [Children_No], [Employee_Code_Id], [DateOfJoining], [Reporting_To], [Leave_Sanc_Authority], [Prev_Experience], [UserName], [Emp_password], [Qual_JoiningTime], [Qual_Employment], [OutDoorJob], [CompOff_Eligible], [OT_Eligible], [ESI_Eligible], [PF_Eligible], [Report_Exclude], [Employee_Status], [SwipeCardNo], [Time_Stamp], [Emp_ID], [Isdeleted], [Hostel], [IsComplete], [IsFlexible], [InActiveDate], [CustomField1], [CustomField2], [CustomField3], [CustomField4], [CustomField5], [Isdeleted_Status], [InActive_Status], [IsImported]) VALUES (1, NULL, NULL, N'Administrator', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'18000000', NULL, NULL, NULL, NULL, N'Admin', N'QL5OWbmiorXf+5GMDoaz1w==', NULL, NULL, 0, 1, 1, 0, 0, 1, 1, N'18000000', GETDATE(), NULL, 0, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0)
--Language Table
INSERT  INTO [dbo].[TA_Tbl_MultiLingual] ([Language_Name], [Resource_File_Name], [IsActive]) VALUES ( N'English', N'Resource_EN', 1)
INSERT  INTO [dbo].[TA_Tbl_MultiLingual] ([Language_Name], [Resource_File_Name], [IsActive]) VALUES ( N'Arabic', N'Resource_AR', 0)
INSERT  INTO [dbo].[TA_Tbl_DateandTimeFormat] ([DateFormat], [TimeFormat], [Time_Stamp], [Emp_Id],[isDomain]) VALUES (N'MM/dd/yyyy', N'hh:mm tt', GETDATE(), 1,1)
INSERT  INTO [dbo].[TA_Tbl_Version] ([DatabaseVersionNo], [DatabaseVersionName], [ApplicationVersionNo], [ApplicationVersionName], [DatabaseVersionDate], [ApplicationVersionDate]) VALUES (1, N'TimeCheck_DB_V3.5', 1, N'TimeCheck_AP_V3.5', GETDATE(), GETDATE())
INSERT  INTO [dbo].[TA_Tbl_Shift] ([Level_Id], [Shift_Name], [Shift_ShortName], [Shift_Description], [Shift_StartTime], [Shift_EndTime], [Shift_FirstHalf_StartTime], [Shift_FirstHalf_EndTime], [Shift_SecondHalf_StartTime], [Shift_SecondHalf_EndTime], [Shift_GraceInTime], [Shift_GraceOutTime], [Shift_BreakStartTime1], [Shift_BreakEndTime1], [Shift_BreakStartTime2], [Shift_BreakEndTime2], [Shift_BreakStartTime3], [Shift_BreakEndTime3], [Shift_MinTimeOT], [Shift_MaxTimeOT], [Shift_WorkingDay_OverTime], [Shift_TotalWorkingHours], [Isdeleted], [Emp_ID], [Shift_FirstHalfWorkingHours], [Shift_SecondHalfWorkingHours], [IsBreakDeducted], [DefaultShift], [ShiftType], [CreatedDate], [ModifiedDate], [24HrsShift]) VALUES (0, N'No Shift', N'NOS', N'No Shift', N'07:00 AM', N'07:00 PM', N'07:00 AM', N'01:00 PM', N'01:00 PM', N'07:00 PM', N'00:05', N'00:05', NULL, NULL, NULL, NULL, NULL, NULL, N'01:00', N'07:30', 1, N'12:00', 0, N'1', N'06:00', N'06:00', 1, 0, 0, NULL, NULL, 0)
INSERT  INTO [dbo].[TA_Tbl_ShiftSettings] ([CompanyId], [MaxHoursBeforeShift], [MaxHoursAfterShift], [ShiftBreak], [ShiftMaxBreakHours], 
[MonthlyWorkingHours], [WeeklyWorkingHours], [EmpID], [HolidayOT], [WeekOffOT], [otOption], [DefaultMonthClosureDate], [IsFlexible], 
[FlexibleFlag], [OTRoundoffEnable], [FullDayAttendanceHrs], [HalfDayAttendanceHrs], [HalfDayAttendance], [FullDayAttendance],
[WeeklyOffStartHours], [IgnoreDuplicatePunch], [PunchInterval], [AfterShiftTime], [BeforeShiftTime], [DefinedWorkhrs], [NoOfSuccessiveDaysInYear],
[CompensationValitityDays], [VaildityCompOffDays], [HalfDayCompOff], [FullDayCompOff], [LateEntry], [EarlyEntry], [EarlyExit], [LateExit], [TimeStamp],
[TimeStamp1], [IsLunchDeduction], [LunchDeductionHours], [Flexi_AfterShiftTime], [Flexi_BeforeShiftTime], [Flexi_DefinedWorkhrs], 
[MaxHoursBeforeShift_24HrsShift], [WeeklyOffStartHours_24HrsShift], [CumulativeWeekStartDay], [CumulativeWeekEndDay], [MonthStartDay], [MonthEndDay],
[Carry_Forward_COff_Year], [isRequestingforCompOff], [LateMinsPerDay] ,[LateDaysPerMonth], [EarlyExitMinsPerDay],[EarlyExitDaysPerMonth],[EnableAbsent] ) 
VALUES (-1, N'02:00', N'02:00', N'', N'', N'', N'', N'1', CAST(1.0 AS Decimal(18, 1)),    CAST(1.0 AS Decimal(18, 1)),    N'WeeklyOff', DATEADD(MONTH,DATEDIFF(MONTH,0,dateadd(month,-1,GETDATE())),-1), 0, 0, 0, N'', N'', 1, 1,
N'16:00', 1, N'00:10', 1, 1, 1, 30,	 0, 90, N'11:00', N'12:00', 1, 1, 1, 1,	 NULL, NULL, 0, N'00:00', 0, 0, 0, N'00:02', N'23:00', N'1', N'7',N'1',N'31',1,0,30,3,20,5,1)
insert into Ta_tbl_EmailScripts (ScriptId,ScriptText,ScriptType) values ('1','<html>  <body direction="<<ltr_rtl>>">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="700" id="AutoNumber2">  <tr bgcolor="#003466">  <td width="100%" height="25"><b><span class="Header">&nbsp;<<lblleaveapplicationform>></span></b>  </td>  </tr>  </table>  <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666" width="700" id="AutoNumber1">  <tr>  <td height="19" width="30%">  <b><font face="Arial" size="2"><<lblemployeeid>></font></b>  </td>  <td height="19" width="70%"><font face="Arial" size="2">&nbsp;<<employeeid>></font></td></tr><tr>  <td height="19"><b><font face="Arial" size="2"><<lblemployeename>></font></b></td>  <td height="19"><font face="Arial" size="2">&nbsp;<<employeename>></font></td></tr><tr>  <td height="19"><b><font face="Arial" size="2"><<lblapplicationdate>></font></b></td>  <td height="19"><font face="Arial" size="2">&nbsp;<<applicationdate>></font></td></tr>  <tr><td height="19"><b><font face="Arial" size="2"><<lblleavetype>></font></b></td>  <td height="19"><font face="Arial" size="2">&nbsp;<<leavetype>></font></td></tr>  <tr><td height="19"><b><font face="Arial" size="2"><<lblnumberdaysapplied>></font></b></td>  <td height="19"><font face="Arial" size="2">&nbsp;<<numberdaysapplied>></font></td></tr>  <tr><td height="19"><b><font face="Arial" size="2"><<lblleavedate>></font></b></td>  <td height="19">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3">  <tr>  <td width="8%"><b><font face="Arial" size="2">&nbsp;<<lblfromdate>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<fromdate>></font></td>  <td width="5%"><b><font face="Arial" size="2">&nbsp;<<lbltodate>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<todate>></font></td></tr></table></td></tr>  <tr><td height="19"><b><font face="Arial" size="2"><<lblsession>></font></b></td>  <td height="19">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="Table1">  <tr><td width="8%"><b><font face="Arial" size="2">&nbsp;<<lblfromsession>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<fromsession>></font></td>  <td width="5%"><b><font face="Arial" size="2">&nbsp;<<lbltosession>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<tosession>></font></td></tr></table></td></tr><tr>  <td height="19"><b><font face="Arial" size="2"><<lblreason>></font></b></td><td height="19">  <font face="Arial" size="2">&nbsp;<<reason>></font></td></tr></table>  <br/><a href=<<LinkData>>><font face="Arial" size="2">Click here for approval</font></a>  </body></html>','New Leave Application Form')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('3','<html>  <body direction="<<ltr_rtl>>">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="700" id="AutoNumber2">  <tr bgcolor="#003466">  <td width="100%">  <span class="Header">&nbsp;<<PermissionForm>></span>  </td>  </tr>  </table>  <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666" width="700" id="AutoNumber1">  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblEmployeeId>></font></b>  </td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<EmployeeId>></font></td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblEmployeeName>> </font></b>  </td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<EmployeeName>></font></td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblPermissionDate>></font></b>  </td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<PermissionDate>></font></td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblNumberOfHoursApplied>></font></b></td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<NumberOfHoursApplied>></font></td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblPermission>></font></b></td>  <td height="19">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3">  <tr>  <td width="14%">      <b><font face="Arial" size="2">&nbsp;<<lblFromTime>> :</font></b></td>  <td width="36%">      <font face="Arial" size="2"><<FromTime>></font></td>  <td width="10%">      <b><font face="Arial" size="2">&nbsp;<<lblToTime>> :</font></b></td>  <td width="40%">      <font face="Arial" size="2"><<ToTime>></font></td>  </tr>  </table>  </td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblReason>></font></b></td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<Reason>></font></td>  </tr>  </table>  <br/>   <a href=<<LinkData>>><font face="Arial" size="2">Click here for approval</font></a>  </body>  </html>','New Permission Form')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('4','<html>  <body direction="<<ltr_rtl>>">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="700" id="AutoNumber2">  <tr bgcolor="#003466">  <td width="100%">  <span class="Header">&nbsp;<<PermissionForm>></span>  </td>  </tr>  </table>  <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666" width="700" id="AutoNumber1">  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblEmployeeId>></font></b>  </td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<EmployeeId>></font>  </td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblEmployeeName>> </font></b>  </td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<EmployeeName>></font></td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblPermissionDate>></font></b>  </td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<PermissionDate>></font></td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblNumberOfHoursApplied>></font></b></td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<NumberOfHoursApplied>></font></td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblPermission>></font></b></td>  <td height="19">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3">  <tr>  <td width="14%">  <b><font face="Arial" size="2">&nbsp;<<lblFromTime>> : </font></b>  </td>  <td width="36%">  <font face="Arial" size="2"><<FromTime>></font></td>  <td width="10%">  <b><font face="Arial" size="2">&nbsp;<<lblToTime>> :</font></b></td>  <td width="40%">  <font face="Arial" size="2"><<ToTime>></font></td>  </tr>  </table>  </td>  </tr>  <tr>  <td height="19">  <b><font face="Arial" size="2"><<lblReason>></font></b></td>  <td height="19">  <font face="Arial" size="2">&nbsp;<<Reason>></font></td>  </tr>  </table>  <br/>   <a href=<<LinkData>>>      <font face="Arial" size="2">Click here for approval</font></a>   </body>  </html>','Permission Modify Form')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('5','<html>  <body direction="<<ltr_rtl>>">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"  bordercolor="#111111" width="700" id="AutoNumber2">  <tr bgcolor="#003466">  <td width="100%"> <b> <span class="Header">&nbsp;<<lblPermissionSanction>></span> </b> </td>  </tr>  </table>  <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666"  width="700" id="AutoNumber1" height="122">  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblEmployeeId>></font></b>  </td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<EmployeeId>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblEmployeeName>></font></b>  </td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<EmployeeName>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblPermissionDate>></font></b>  </td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<PermissionDate>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblNumberOfHoursApplied>></font></b></td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<NumberOfHoursApplied>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblPermission>></font></b></td>  <td width="70%" height="16">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"  bordercolor="#111111" width="100%" id="AutoNumber3">  <tr>  <td width="14%">  <b><font face="Arial" size="2">&nbsp;<<lblFromTime>> :</font></b></td>  <td width="36%">  <font face="Arial" size="2"><<FromTime>></font></td>  <td width="10%">  <b><font face="Arial" size="2">&nbsp;<<lblToTime>> :</font></b></td>  <td width="40%">  <font face="Arial" size="2"><<ToTime>></font></td>  </tr>  </table>  </td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblStatus>></font></b></td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<Status>></font></td>  </tr> <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblReason>></font></b></td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<Reason>></font></td>  </tr> <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblRemarks>></font></b></td>  <td width="70%" height="16">  <font face="Arial"><font size="2">&nbsp;<<Remarks>></font></td>  </tr>  </table>  <br />      <a href=<<LinkData>>><font face="Arial" size="2">Click here for approval</font></a>   </body>  </html>','Permission Application Sanction By Reporting to Person')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('6','<html>  <body direction="<<ltr_rtl>>">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"  bordercolor="#111111" width="700" id="AutoNumber2">  <tr bgcolor="#003466">  <td width="100%">  <span>&nbsp;<<lblPermissionSanction>></span></td>  </tr>  </table>  <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666"  width="700" id="AutoNumber1" height="122">  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblEmployeeId>></font></b>  </td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<EmployeeId>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblEmployeeName>></font></b>  </td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<EmployeeName>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblPermissionDate>></font></b>  </td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<PermissionDate>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblNumberOfHoursApplied>></font></b></td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<NumberOfHoursApplied>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblPermission>></font></b></td>  <td width="70%" height="16">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"  bordercolor="#111111" width="100%" id="AutoNumber3">  <tr>  <td width="10%">  <b><font face="Arial" size="2"><<lblFromTime>> :</font></b></td>  <td width="40%">  <font face="Arial" size="2"><<FromTime>></font></td>  <td width="8%">  <b><font face="Arial" size="2">&nbsp;<<lblToTime>> :</font></b></td>  <td width="40%">  <font face="Arial" size="2"><<ToTime>></font></td>  </tr>  </table>  </td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblStatus>></font></b></td>  <td width="70%" height="16">  <font face="Arial" size="2">&nbsp;<<Status>></font></td>  </tr>  <tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblRemarks>></font></b></td>  <td width="70%" height="16">  <font face="Arial"><font size="2">&nbsp;<<Remarks>></font></td>  </tr>  </table>  </body>  </html>','Forwarded Permission Application Sanction')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('7','<html>  <body direction="<<ltr_rtl>>">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"  bordercolor="#111111" width="700" id="AutoNumber2">  <tr bgcolor="#003466">  <td width="100%"><b>  <span>&nbsp;<<lblLeaveApplicationForm>></span></b></td>  </tr>  </table>  <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666"  width="700" id="AutoNumber1">  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblEmployeeId>> </font></b>  </td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<EmployeeId>></font></td>  </tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblEmployeeName>></font></b>  </td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<EmployeeName>></font></td>  </tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblApplicationDate>> </font></b>  </td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<ApplicationDate>></font></td>  </tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblLeaveType>></font></b></td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<LeaveType>></font>  </td>  </tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblNumberDaysApplied>></font></b></td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<NumberDaysApplied>></font></td>  </tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblLeaveDate>></font></b>  </td>  <td width="70%" height="19">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"  bordercolor="#111111" width="100%" id="AutoNumber3">  <tr>  <td width="8%">  <b><font face="Arial" size="2">&nbsp;<<lblFromDate>> :</font></b></td>  <td width="25%">  <font face="Arial" size="2"><<FromDate>></font></td>  <td width="5%">  <b><font face="Arial" size="2">&nbsp;<<lblToDate>> :</font></b></td>  <td width="25%">  <font face="Arial" size="2"><<ToDate>></font></td>  </tr>  </table>  </td>  </tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblSession>></font></b></td>  <td width="70%" height="19">  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"  bordercolor="#111111" width="100%" id="Table1">  <tr>  <td width="8%">  <b><font face="Arial" size="2">&nbsp;<<lblFromSession>> :</font></b></td>  <td width="25%">  <font face="Arial" size="2"><<FromSession>></font></td>  <td width="5%">  <b><font face="Arial" size="2">&nbsp;<<lblToSession>> :</font></b></td>  <td width="25%">  <font face="Arial" size="2"><<ToSession>></font></td>  </tr>  </table>  </td>  </tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblStatus>></font></b></td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<Status>></font></td>  </tr><tr><td height="19"><b><font face="Arial" size="2"> <<lblreason>> </font></b></td><td height="19"><font face="Arial" size="2">&nbsp;<<reason>> </font></td></tr>  <tr>  <td width="30%" height="19">  <b><font face="Arial" size="2"><<lblRemarks>></font></b><lblremarks>  </td>  <td width="70%" height="19">  <font face="Arial" size="2">&nbsp;<<Remarks>></font></td>  </tr>  </table><br/><font face="Arial" size="2"><a href="<<LinkData>>">Click here for approval</a></font>  </body>  </html>','Leave Application Sanction By Reporting to Person')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('9','<html><body direction="<<ltr_rtl>>">
<table width="750px" style="border: solid 1px black;"   cellspacing="0" cellpadding="0"><tr style="background-color: #d3dbe7;">
<td style="width: 100%;"> <img src="cid:image1" style="float: left;  padding-left: 10px; border: none;">
<a href="http://www.angleritech.com" target="_blank">
<img src="cid:imgCompLogo" align="right" style="float: right; padding-right:10px; padding-top:10px; border: none;" /></a></td></tr>
<tr><td style="background-color: #E0E6EE;"><br />
<table border="0" cellpadding="0" cellspacing="0" style="padding-left: 20px;" bordercolor="#111111" width="700" id="AutoNumber2">
<tr><td     width="100%" style="padding-left: 10px;"><b><font face="Verdana" color="#000">Dear     Admin,</font></b></td></tr>
<tr><td height="12"></td></tr><tr><td width="100%"     style="padding-left: 10px;">
<font face="Verdana" color="#000"     size="2"><<licenserequestdetails>></font></td></tr><tr><td     height="35"></td></tr></table>  
<table border="1" cellpadding="2" style="margin-left: 30px;display:none;"     bordercolor="#666666" width="400 px" id="AutoNumber1">
<tr><td width="80%"     height="19"><font face="Verdana" size="2"><<lblemployee>></font></td>
<td     width="20%" height="19" style="text-align: left;"><b><font face="Verdana"     size="2"><<employee>></font></b></td></tr>
<tr><td height="19"><font     face="Verdana" size="2"><<lblconcurrentusers>> </font>  </td>
<td height="19" style="text-align: left;"><b><font face="Verdana"     size="2"><<concurrentusers>></font></b></td></tr>
<tr><td height="19"><font     face="Verdana" size="2"><<lblterminals>></font></td>
<td height="19"     style="text-align: left;"><b><font face="Verdana"     size="2"><<terminals>></font></b></td></tr>
<tr><td height="19"><font     face="Verdana" size="2"><<lblversion>></font></td><td height="19"     style="text-align: left;">
<b><font face="Verdana"     size="2"><<version>></font></b></td></tr></table>  <table style="width: 100%; padding-left: 20px;">
<tr><td colspan="2"     height="35"></td></tr><tr><td colspan="2" height="19" style="padding-left: 10px;">
<font face="Verdana" color="#000" size="2"><<regards>></font></td></tr><tr><td colspan="2" height="19" style="padding-left: 10px;">
<font face="Verdana" color="#000"     size="2"><<clientname>></font></td></tr></table><br /></td></tr>
<tr style="background-color: #d3dbe7;"><td style="width: 100%; text-align: right;">
<a href="http://www.angleritech.com" target="_blank" style="text-decoration: none; color: #224d6a;padding-right: 10px;">Angler Technologies </a></td></tr></table></body></html>','License Request')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('10','<html><body direction="<<ltr_rtl>>">  
<table width="750px" style="border: solid 1px black;" cellspacing="0" cellpadding="0"><tr style="background-color: #d3dbe7;"> 
<td style="width: 100%;">  <img src="cid:image1" style="float: left; padding-left: 10px; border: none;">
<a href="http://www.angleritech.com" target="_blank"> <img src="cid:imgCompLogo" align="right" style="float: right;    padding-right: 10px; padding-top: 10px; border: none;" /></a></td></tr><tr>  
<td style="background-color: #E0E6EE;"><br />
<table border="0" cellpadding="0" cellspacing="0" style="padding-left: 20px;" bordercolor="#111111" width="700" id="Table1">  
<tr><td width="100%" style="height: 18px" style="padding-left: 10px;">
<font face="Verdana" color="#000"> <<licenserequestusername>>,</font></td></tr>  <tr><td height="12"></td></tr><tr>
<td width="100%" style="padding-left: 10px;"><font face="Verdana" color="#000" size="2"><<licenserequestdetails>></font></td></tr>
<tr><td height="35"></td></tr>  </table>
<table border="1" cellpadding="2" style="margin-left: 30px;display:none;" bordercolor="#666666" width="400" id="Table2"> 
<tr><td width="80%" height="19"><font face="Verdana" size="2"><<lblemployee>></font></td>  
<td width="20%" height="19" style="text-align: left;"><b><font face="Verdana" size="2"><<employee>></font></b></td></tr>  
<tr><td height="19" ><font face="Verdana" size="2"><<lblconcurrentusers>> </font></td>  <td height="19"  style="text-align: left;"><b>
<font face="Verdana" size="2"><<concurrentusers>></font></b></td></tr>  <tr><td height="19" >
<font face="Verdana" size="2"><<lblterminals>></font></td>  <td height="19"  style="text-align: left;"><b>
<font face="Verdana" size="2"><<terminals>></font></b></td>  </tr><tr><td height="19" ><font face="Verdana" size="2"><<lblversion>></font></td> 
<td height="19" style="text-align: left;"><b><font face="Verdana" size="2"><<version>></font></b></td></tr>  </table><br />
<table style="width: 100%; padding-left: 20px;"><tr><td colspan="2" height="35"></td></tr>  <tr>
<td colspan="2" height="19" style="padding-left: 10px;"><font face="Verdana" color="#000" size="2"><<regards>></font></td></tr> 
<tr><td colspan="2" height="19" style="padding-left: 10px;"><font face="Verdana" color="#000" size="2"><<clientname>></font></td>
</tr></table><br />  </td></tr><tr style="background-color: #d3dbe7;"><td style="width: 100%; text-align: right;"> 
<a href="http://www.angleritech.com" target="_blank" style="text-decoration: none; color: #224d6a; padding-right: 10px;">Angler Technologies </a></td>
  </tr></table></body></html>','License Request Client')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('11','<html><body direction="<<ltr_rtl>>"><table width="750px" style="border: solid 1px black;" cellspacing="0" cellpadding="0"><tr style="background-color: #d3dbe7;"> <td style="width: 100%;"><img src="cid:image1" style="float: left; padding-left: 10px; border: none;"><a href="http://www.angleritech.com" target="_blank"><img src="cid:imgCompLogo"  align="right"  style="float: right; padding-right: 10px; padding-top: 10px; border: none;" /></a></td></tr><tr>
<td style="background-color: #E0E6EE;"><br /><table border="0" cellpadding="0" cellspacing="0" style="padding-left: 20px;" bordercolor="#111111" width="700" id="Table1"><tr><td height="12"></td></tr><tr><td width="100%" style="padding-left: 10px;"><font face="Verdana" color="#000"><<licenserequestdetails>></font></td></tr><tr><td height="35"></td></tr></table>
<table border="1" cellpadding="2" style="margin-left: 30px;" bordercolor="#666666" width="400" id="Table2"><tr><td width="80%" height="19"><font face="Verdana" size="2"><<lblemployee>></font></td><td width="20%" height="19" style="text-align: left;"><b><font face="Verdana" size="2"><<employee>></font></b></td></tr><tr><td height="19" ><font face="Verdana" size="2"><<lblconcurrentusers>> </font></td><td height="19"  style="text-align: left;"><b><font face="Verdana" size="2"><<concurrentusers>></font></b></td></tr><tr><td height="19" ><font face="Verdana" size="2"><<lblterminals>></font></td><td height="19"  style="text-align: left;"><b><font face="Verdana" size="2"><<terminals>></font></b></td>
</tr><tr><td height="19" ><font face="Verdana" size="2"><<lblversion>></font></td><td height="19" style="text-align: left;"><b><font face="Verdana" size="2"><<version>></font></b></td></tr></table><br /><table style="width: 100%; padding-left: 20px;"><tr><td colspan="2" height="35"></td></tr><tr><td colspan="2" height="19"><<regards>></td></tr><tr><td colspan="2" height="19"><<clientname>></td></tr></table><br />
</td></tr><tr style="background-color: #d3dbe7;"><td style="width: 100%; text-align: right;"><a href="http://angeritech.com" target="_blank" style="text-decoration: none; color: #224d6a; padding-right: 10px;">Angler Technologies </a></td></tr></table></body></html>','License Activation')
insert into Ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values ('12','<html>  <body direction="<<ltr_rtl>>"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"    bordercolor="#111111" width="700" id="AutoNumber2">    <tr bgcolor="#003466">  <td width="100%" height="25"><span class="Header">&nbsp;<<lblOndutyForm>></span></td>    </tr></table><table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666"    width="700" id="AutoNumber1">    <tr>  <td height="19" width="30%"><b><font face="Arial" size="2"><<lblEmployeeID>></font></b>  </td>  <td height="19" width="70%"><font face="Arial" size="2">&nbsp;<<EmployeeID>></font>  </td>    </tr>    <tr>  <td height="19"><b><font face="Arial" size="2"><<lblEmployeeName>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<EmployeeName>></font>  </td>    </tr>    <tr>  <td height="19"><b><font face="Arial" size="2"><<lblApplicationDate>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<ApplicationDate>></font>  </td>    </tr>    <tr>  <td height="19"><b><font face="Arial" size="2"><<lblODDate>></font></b>  </td>  <td height="19"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"    bordercolor="#111111" width="100%" id="AutoNumber3">    <tr>  <td width="8%"><b><font face="Arial" size="2">&nbsp;<<lblFromDate>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<FromDate>></font></td>  <td width="5%"><b><font face="Arial" size="2">&nbsp;<<lblToDate>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<ToDate>></font></td>    </tr></table>  </td>    </tr>  <tr>  <td height="19"><b><font face="Arial" size="2"><<lblReason>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<Reason>></font>  </td>    </tr>   <tr>  <td height="19"><b><font face="Arial" size="2"><<lblStatus>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<Status>></font>  </td>    </tr></table>  </body>  <br /><font face="Arial" size="2"><a href="<<LinkData>>">Click here for approval </a></font>  </html>','Onduty Application From')
insert into TA_TBL_EmailScripts (ScriptId,ScriptText,ScriptType) values ('13','<html>  <body direction="<<ltr_rtl>>"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"    bordercolor="#111111" width="700" id="AutoNumber2">    <tr bgcolor="#003466">  <td width="100%" height="25"><b><span class="Header">&nbsp;<<lblOndutyForm>></span></b></td>    </tr></table><table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666"    width="700" id="AutoNumber1">    <tr>  <td height="19" width="30%"><b><font face="Arial" size="2"><<lblEmployeeID>></font></b>  </td>  <td height="19" width="70%"><font face="Arial" size="2">&nbsp;<<EmployeeID>></font>  </td>    </tr>    <tr>  <td height="19"><b><font face="Arial" size="2"><<lblEmployeeName>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<EmployeeName>></font>  </td>    </tr>    <tr>  <td height="19"><b><font face="Arial" size="2"><<lblApplicationDate>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<ApplicationDate>></font>  </td>    </tr>    <tr>  <td height="19"><b><font face="Arial" size="2"><<lblODDate>></font></b>  </td>  <td height="19"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse"    bordercolor="#111111" width="100%" id="AutoNumber3">    <tr>  <td width="8%"><b><font face="Arial" size="2">&nbsp;<<lblFromDate>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<FromDate>></font></td>  <td width="5%"><b><font face="Arial" size="2">&nbsp;<<lblToDate>> :</font></b></td>  <td width="25%"><font face="Arial" size="2"><<ToDate>></font></td>    </tr></table>  </td>    </tr>  <tr>  <td height="19"><b><font face="Arial" size="2"><<lblReason>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<Reason>></font>  </td>    </tr><tr>  <td width="30%" height="16">  <b><font face="Arial" size="2"><<lblRemarks>></font></b></td>  <td width="70%" height="16">  <font face="Arial"><font size="2">&nbsp;<<Remarks>></font></td>  </tr>   <tr>  <td height="19"><b><font face="Arial" size="2"><<lblStatus>></font></b>  </td>  <td height="19"><font face="Arial" size="2">&nbsp;<<Status>></font>  </td>    </tr></table>  </body>  <br /><font face="Arial" size="2"><a href="<<LinkData>>">Click here for approval </a></font>  </html>','Onduty Application Modify')
insert into ta_tbl_emailscripts (ScriptId,ScriptText,ScriptType) values(14,'
<font face="Arial" size="2">
Dear <<lblusername>>,
</font>
<br/>
<br/>
<font face="Arial" size="2">Your Timecheck password has been reset successfully.
</font>
<br/>
<br/>
<font face="Arial" size="2">
Note:Use the default password <b>(i.e. welcome)</b> of timecheck for login right now. 
After the successful login into Timecheck, change the password immediately.
</font>
<br/>
<br/>
<font face="Arial" size="2">Regards,</font>
<br/>
<font face="Arial" size="2">TimeCheck</font>','ResetPassword')
insert into TA_TBL_EmailScripts (ScriptId,ScriptText,ScriptType) values (15,'<html>
<body direction="<<ltr_rtl>>">
    <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#666666" width="600" id="AutoNumber1">
	<tr bgcolor="#003466">
            <td width="100%" height="25" colspan=''2''><b><span class="Header">&nbsp;<<lblCompform>></span></b></td>
        </tr>
        <tr>
            <td height="19" width="30%"><b><font face="Arial" size="2"><<lblEmployeeID>></font></b></td>
            <td height="19" width="70%"><font face="Arial" size="2">&nbsp;<<EmployeeID>></font></td>
        </tr>
        <tr>
            <td height="19"><b><font face="Arial" size="2"><<lblEmployeeName>></font></b></td>
            <td height="19"><font face="Arial" size="2">&nbsp;<<EmployeeName>></font></td>
        </tr>
        <tr>
            <td height="19"><b><font face="Arial" size="2"><<lblDutyDate>></font></b></td>
            <td height="19"><font face="Arial" size="2">&nbsp;<<DutyDate>></font></td>
        </tr>
        <tr>
            <td height="19"><b><font face="Arial" size="2"><<lblInTime>></font> / <font face="Arial" size="2"><<lblOutTime>></font></b></td>
            <td height="19"><font face="Arial" size="2">&nbsp;<<Intime>></font> / <font face="Arial" size="2">&nbsp;<<OutTime>></font></td>
        </tr>
        <tr>
            <td height="19"><b><font face="Arial" size="2"><<lblDayWorked>></font> / <font face="Arial" size="2"><<lblWorkedHours>></font></b></td>
            <td height="19"><font face="Arial" size="2">&nbsp;<<DayWorked>></font> / <font face="Arial" size="2">&nbsp;<<WorkedHours>></font></td>
        </tr>
              <tr style=''display:<<disvalue>>''>
                     <td height="19"><b><font face="Arial" size="2"><<lblReason>></font></b></td>
                     <td height="19"><font face="Arial" size="2">&nbsp;<<Reason>></font></td>
              </tr>
        <tr>
            <td height="19"><b><font face="Arial" size="2"><<lblStatus>></font></b></td>
            <td height="19"><font face="Arial" size="2">&nbsp;<<Status>></font></td>
        </tr>
    </table>
</body>
</html>','CompOff Application form')
INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (50, N'Ta_Tbl_yearsetting', N'Organization_YearSetting.aspx', N'../Organization%20Settings/Organization_YearSetting.aspx', N'Year Settings in Configuration', 1, 1)
INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (6, N'TA_Tbl_leveldetails', N'TA_UI_Master_OrganisationLevels.aspx', N'../Masters/TA_UI_Master_OrganisationLevels.aspx', N'Organization Levels in Organization Management', 3, 1)
--Commented on 15-05-2019 06:56 PM
--INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (7, N'TA_Tbl_LeavePolicy', N'TA_UI_MasterLeavePolicyAdd.aspx', N'../Masters/TA_UI_MasterLeavePolicyAdd.aspx', N'Leave Policy Master', 2, 1)
--INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (223, N'TA_Tbl_terminaldatatype', N'TA_UI_Master_TerminalDatatypeAdd.aspx', N'../Masters/TA_UI_Master_TerminalDatatypeAdd.aspx', N'Terminal Data Type in Device Management', 1, 1)
--INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (224, N'TA_Tbl_terminal', N'TA_UI_Master_TerminalAdd.aspx', N'../Masters/TA_UI_Master_TerminalAdd.aspx', N'Terminal Master', 3, 1)
--INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (15, N'TA_Tbl_entrance', N'TA_UI_Master_EntranceAdd.aspx', N'../Masters/TA_UI_Master_EntranceAdd.aspx', N'Entrance Master', 1, 1)
--INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (68, N'TA_Tbl_punchTypes', N'TA_UI_Master_PunchTypes_Add.aspx', N'../Masters/TA_UI_Master_PunchTypes_Add.aspx', N'Punch Types', 2, 1)
INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (17, N'TA_Tbl_Title', N'TA_UI_Master_TitleFirstAdd.aspx', N'../Masters/TA_UI_Master_TitleFirstAdd.aspx', N'Designation', 0, 1)
INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (18, N'TA_Tbl_Employee', N'TA_UI_Master_EmployeeAdd.aspx', N'../Masters/TA_UI_Master_EmployeeAdd.aspx', N'Employee Master', 3, 1)
INSERT [dbo].[Ta_Tbl_PageRedirect] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (28, N'Ta_tbl_permanentshiftallocation', N'TA_UI_Transaction_ShiftAllocationAdd.aspx', N'../Transactions/TA_UI_Transaction_ShiftAllocationAdd.aspx', N'Shift Allocation for Employee', 24, 0)
GO
--Standard Demo
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (50, N'Ta_Tbl_yearsetting', N'Organization_YearSetting.aspx', N'../Organization%20Settings/Organization_YearSetting.aspx', N'Year Settings in Configuration', 1, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (6, N'TA_Tbl_leveldetails', N'TA_UI_Master_OrganisationLevels.aspx', N'../Masters/TA_UI_Master_OrganisationLevels.aspx', N'Organization Levels in Organization Management', 3, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (7, N'TA_Tbl_LeavePolicy', N'TA_UI_MasterLeavePolicyAdd.aspx', N'../Masters/TA_UI_MasterLeavePolicyAdd.aspx', N'Leave Policy Master', 2, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (223, N'TA_Tbl_terminaldatatype', N'TA_UI_Master_TerminalDatatypeAdd.aspx', N'../Masters/TA_UI_Master_TerminalDatatypeAdd.aspx', N'Terminal Data Type in Device Management', 1, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (224, N'TA_Tbl_terminal', N'TA_UI_Master_TerminalAdd.aspx', N'../Masters/TA_UI_Master_TerminalAdd.aspx', N'Terminal Master', 3, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (15, N'TA_Tbl_entrance', N'TA_UI_Master_EntranceAdd.aspx', N'../Masters/TA_UI_Master_EntranceAdd.aspx', N'Entrance Master', 1, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (68, N'TA_Tbl_punchTypes', N'TA_UI_Master_PunchTypes_Add.aspx', N'../Masters/TA_UI_Master_PunchTypes_Add.aspx', N'Punch Types', 2, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (17, N'TA_Tbl_Title', N'TA_UI_Master_TitleFirstAdd.aspx', N'../Masters/TA_UI_Master_TitleFirstAdd.aspx', N'Designation', 0, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (18, N'TA_Tbl_Employee', N'TA_UI_Master_EmployeeAdd.aspx', N'../Masters/TA_UI_Master_EmployeeAdd.aspx', N'Employee Master', 3, 1)
INSERT [dbo].[Ta_Tbl_PageRedirectStandard] ([PageId], [TableName], [Page], [PageFullPath], [Module], [Rows], [Active]) VALUES (28, N'Ta_tbl_permanentshiftallocation', N'TA_UI_Transaction_ShiftAllocationAdd.aspx', N'../Transactions/TA_UI_Transaction_ShiftAllocationAdd.aspx', N'Shift Allocation for Employee', 24, 1)
INSERT [dbo].[TA_Tbl_Level] ([levelName], [parentLevelID], [isDeleted], [timeStamp], [emp_Id]) VALUES (N'Company', 0, 0, GETDATE(), N'1')
INSERT [dbo].[TA_Tbl_Level] ([levelName], [parentLevelID], [isDeleted], [timeStamp], [emp_Id]) VALUES (N'Department', 1, 0, GETDATE(), N'1')
-----Default Leave Types
insert into TA_Tbl_LeaveType VAlues('CL','Casual Leave',0,1,getdate(),0,0,0,'Both',0,0,0,0)
insert into TA_Tbl_LeaveType VAlues('SL','Sick Leave',0,1,getdate(),0,0,0,'Both',0,0,0,0)
insert into TA_Tbl_LeaveType VAlues('ML','Maternity Leave',0,1,getdate(),0,0,0,'Both',0,0,0,0)
insert into TA_Tbl_LeaveType VAlues('EL','Earned Leave',0,1,getdate(),1,0,0,'Both',0,0,0,0)
insert into TA_Tbl_LeaveType VAlues('WFH','Work From Home',0,1,getdate(),0,0,0,'Both',0,1,0,0)
insert into TA_Tbl_LeaveType VAlues('WFO','Work From Office',0,1,getdate(),0,0,0,'Both',0,1,0,0)
insert into TA_Tbl_LeaveType VAlues('PL','Paternity Leave',0,1,getdate(),0,0,0,'Both',0,1,0,0)
insert into TA_Tbl_LeaveType VAlues('COM-L','Commuted Leave',0,1,getdate(),0,0,0,'Both',0,1,0,0)
insert into TA_Tbl_Category values('Staff',0,1,0,'48',8,'08:00',null,null,null)
insert into TA_Tbl_Type values('Permanent',0,1,0,1)
insert into TA_Tbl_Religion values('All','All',0)
--Dashboard Rights tabls
insert into ta_tbl_DashboardData values('AttendanceData','Present',1)
insert into ta_tbl_DashboardData values('AttendanceData','Absent',2)
insert into ta_tbl_DashboardData values('AttendanceData','Approved Leave',3)
insert into ta_tbl_DashboardData values('AttendanceData','Approved Onduty',4)
insert into ta_tbl_DashboardData values('AttendanceData','Punctuality',5)
insert into ta_tbl_DashboardData values('AttendanceData','Attendance Summary',6)
insert into ta_tbl_DashboardData values('ApprovalData','Leave',1)
insert into ta_tbl_DashboardData values('ApprovalData','Onduty',2)
insert into ta_tbl_DashboardData values('ApprovalData','Permission',3)
insert into ta_tbl_DashboardData values('ExceptionData','Late Entry',1)
insert into ta_tbl_DashboardData values('ExceptionData','Early Exit',2)
insert into ta_tbl_DashboardData values('ExceptionData','Shift Not Allocated',3)
insert into ta_tbl_DashboardData values('ExceptionData','Approved Overtime',4)
insert into ta_tbl_DashboardData values('ExceptionData','Discrepancy',5)
insert into ta_tbl_DashboardData values('ExceptionData','Non Processed Record',6)
insert into ta_tbl_DashboardUserrights  values(1,1,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,2,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,3,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,4,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,5,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,6,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,7,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,8,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,9,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,10,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,11,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,12,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,13,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,14,1,1,1,1,1)
insert into ta_tbl_DashboardUserrights  values(1,15,1,1,1,1,1)
--Individual usergroup Dashboard rights
insert into ta_tbl_DashboardUserrights  values(2,1,0,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,2,0,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,3,0,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,4,0,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,5,0,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,6,1,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,7,1,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,8,1,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,9,1,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,10,1,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,11,1,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,12,0,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,13,0,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,14,1,1,0,0,1)
insert into ta_tbl_DashboardUserrights  values(2,15,0,1,0,0,1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 179, 179, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 246, 246, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 208, 235, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 32, 208, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 210, 236, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 22, 210, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 211, 236, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 35, 211, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 216, 236,  1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 23, 216,  1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 89, 236,  0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 173, 215,  1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 175, 215, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 213, 237, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 33, 213, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 144, 192, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 41, 144, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 39, 144, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 40, 144, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 105, 144, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 183, 144, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 145, 192, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 34, 145, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 37, 145, 0, 0, 0, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES (N'IndividualUsers', 2, 55, 190, 1, 1, 1, 1, 0,GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,0,0,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,50,194,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,51,194,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,52,194,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,16,194,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,75,194,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,47,189,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,6,189,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,10,187,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,223,10,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,224,10,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,15,187,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,68,187,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,204,188,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,17,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,228,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,94,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,95,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,104,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,18,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,103,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,225,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,226,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,227,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,229,204,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,205,188,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,42,205,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,84,205,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,206,235,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,19,206,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId]) VALUES ('IndividualUsers',	2,20,206,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,69,206,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,207,235,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,28,207,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,29,207,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,255,207,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,202,207,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,60,207,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,116,207,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])  VALUES ('IndividualUsers',	2,203,207,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,208,235,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,32,208,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,44,208,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,254,214,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,97,214,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,36,214,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,209,236,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,195,209,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,196,209,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,108,210,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,96,210,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,76,210,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,211,236,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,35,211,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,117,211,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,89,236,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,248,236,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,175,215,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,212,237,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,220,212,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,26,212,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,98,212,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,222,212,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,102,212,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,221,212,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,213,237,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,92,213,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,33,213,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,218,217,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,27,218,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,62,218,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,66,218,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,219,217,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,71,219,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,70,219,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,144,192,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,41,144,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,30,144,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,39,144,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,180,144,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,40,144,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,105,144,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,45,144,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,118,144,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,183,144,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,145,192,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,34,145,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,37,145,0,0,0,1,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,127,145,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,147,192,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,160,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,171,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,79,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,265,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,43,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,233,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,232,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,234,147,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,177,177,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,21,190,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,54,190,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,53,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,49,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,48,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,78,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,99,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,100,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,72,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,107,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,197,107,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,198,107,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,199,107,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,12,193,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,230,12,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,231,12,0,0,0,0,0,GETDATE(),1)
INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,109,193,0,0,0,0,0,GETDATE(),1)
--INSERT  INTO [dbo].[TA_Tbl_userRights]([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv],[isDeleted], [timeStamp], [employeeId])   VALUES ('IndividualUsers',	2,249,249,0,0,0,0,0,GETDATE(),1)
/*********************/
insert into ta_tbl_SMSTags values('{Employee ID}','LateEntry',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','LateEntry',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','LateEntry',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Late By Hrs}','LateEntry',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Date}','LateEntry',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee ID}','EarlyExit',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','EarlyExit',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','EarlyExit',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Early Exit Hrs}','EarlyExit',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Date}','EarlyExit',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee ID}','LessHours',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','LessHours',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','LessHours',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Less Hours}','LessHours',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Date}','LessHours',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee ID}','AbsentSingleDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','AbsentSingleDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','AbsentSingleDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Date}','AbsentSingleDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee ID}','AbsentContinuousDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','AbsentContinuousDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','AbsentContinuousDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Date}','AbsentContinuousDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Count}','AbsentContinuousDay',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee ID}','LeaveApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','LeaveApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','LeaveApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Leave From - Leave To}','LeaveApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Leave Type}','LeaveApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{No.of Days}','LeaveApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee ID}','PermissionApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','PermissionApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','PermissionApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Permission From - Permission To}','PermissionApplication',GETDATE())
GO
insert into ta_tbl_SMSTags values('{No.of Hrs}','PermissionApplication',GETDATE())
Go
insert into ta_tbl_SMSTags values('{Employee ID}','OnDuty',GETDATE())
GO
insert into ta_tbl_SMSTags values('{User Name}','OnDuty',GETDATE())
GO
insert into ta_tbl_SMSTags values('{Employee Name}','OnDuty',GETDATE())
GO
insert into ta_tbl_SMSTags values('{OnDuty From - OnDuty To}','OnDuty',GETDATE())
Go
--INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) 
--VALUES (243, N'Menu_SMSConfiguration', N'Masters/SMS_Configuration.aspx', 194, 10, NULL)
--INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) 
--VALUES (244, N'Menu_SMSTemplate', N'Masters/SMS_TemplateList.aspx', 194, 11, NULL)
--INSERT  INTO [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) 
--VALUES (245, N'Menu_SMSLogDetails', N'Masters/SMS_LogDetails.aspx', 194, 12, NULL)
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Late Entry', N'Dear {User Name}, The following employees are late comers today', 1, CAST(0x0000A6EF011D1238 AS DateTime), 1, N'03:00', N'01:00', 0, N'', 0, N'{Employee Name}-{Late By Hrs}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Early Exit', N'Dear {User Name}, The following employees are left before shift end time', 0, CAST(0x0000A68D00B93DE5 AS DateTime), 1, N'00:05', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{Early Exit Hrs}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], [ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Less Hours Worked', N'Dear {User Name}, The following employees are not met the defined work hours,', 0, CAST(0x0000A689012CF23B AS DateTime), 1, N'01:00', N'', 0, N'00:10', 0, N'{Employee ID}-{Employee Name}-{Less Hours}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Absent - Single Day', N'Dear {User Name}, The following employees are absent today', 1, CAST(0x0000A6EF01047AEA AS DateTime), 1, N'00:59', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Continuous Absent', N'Dear {User Name}, The following employees are continously absent from last {count} days', 0, CAST(0x0000A68D00C0CFEA AS DateTime), 1, N'00:20', N'', 0, N'', 4, N'{Employee ID}-{Employee Name}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Leave Application - Apply', N'Dear {User Name}, The below employees applied the leave for below duration,', 0, CAST(0x0000A68E01209068 AS DateTime), 1, N'', N'', 1, N'', 0, N'{Employee ID}-{Employee Name}-{Leave From - Leave To}-{Leave Type}-{No.of Days}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Leave Application - Forward', N'Dear {User Name}, The following employees leave is forward to approval,', 0, CAST(0x0000A681013554FD AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{Leave From - Leave To}-{Leave Type}-{No.of Days}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Leave Application - Approved', N'Dear {User Name}, The below leave was approved,', 0, CAST(0x0000A68101357062 AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{Leave From - Leave To}-{Leave Type}-{No.of Days}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Permission Application - Apply', N'Dear {User Name}, The below employee applied the permission for below date,', 0, CAST(0x0000A68F00C78563 AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{Permission From - Permission To}-{No.of Hrs}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Permission Application - Forward', N'Dear Manikandan', 0, CAST(0x0000A6A900D41391 AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{Permission From - Permission To}-{No.of Hrs}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], [Second_TriggeringTime], 
[ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'Permission Application - Approved', N'Dear {UserName},The following employee permission was approved.', 1, CAST(0x0000A6A900D44EEA AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{Permission From - Permission To}-{No.of Hrs}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], 
[Second_TriggeringTime], [ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'OnDuty - Apply', N'Dear {User Name}, The below employee applied the Onduty for below date,', 0, CAST(0x0000A68F00C78563 AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{OnDuty From - OnDuty To}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], 
[Second_TriggeringTime], [ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'OnDuty - Forward', N'Dear {User Name}, the below employee OnDuty forwarded to approval,', 0, CAST(0x0000A6A900D41391 AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{OnDuty From - OnDuty To}')
INSERT [dbo].[Ta_Tbl_SMSTemplates] ([TemplateName], [Message], [Status], [LastModified], [ModifiedBy], [First_TriggeringTime], 
[Second_TriggeringTime], [ToEmployee], [LessHrsLimitation], [Continue_AbsentDays], [Tags]) VALUES (N'OnDuty - Approved', N'Dear {UserName},The following employee OnDuty was approved.', 1, CAST(0x0000A6A900D44EEA AS DateTime), 1, N'', N'', 0, N'', 0, N'{Employee ID}-{Employee Name}-{OnDuty From - OnDuty To}')
insert into TA_Tbl_Grade values('Grade 1',1,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 2',2,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 3',3,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 4',4,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 5',5,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 6',6,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 7',7,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 8',8,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 9',9,1,GETDATE(),0)
Insert into TA_Tbl_Grade values('Grade 10',10,1,GETDATE(),0)
Insert into Ta_tbl_ReasonForNonProcessedData values(1,'Employee id is not available')
Insert into Ta_tbl_ReasonForNonProcessedData values(2,'Device is not created')
Insert into Ta_tbl_ReasonForNonProcessedData values(3,'Shift is not allocated')
Insert into Ta_tbl_ReasonForNonProcessedData values(4,'Punch Type is not created for this device')
INSERT [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (243, N'Menu_SMSConfiguration', N'Masters/SMS_Configuration.aspx', 194, 10, NULL)
INSERT [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (244, N'Menu_SMSTemplate', N'Masters/SMS_TemplateList.aspx', 194, 11, NULL)
INSERT [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (245, N'Menu_SMSLogDetails', N'Masters/SMS_LogDetails.aspx', 194, 12, NULL)
INSERT [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (267, N'AutoShiftConfiguration', N'Transactions/TA_UI_Transaction_AutoShiftConfiguration.aspx', 207, 3, NULL)
INSERT [dbo].[TA_Tbl_Page] ([pageId], [displayName], [path], [parentId], [orderBy], [ParentIdForSubMenu]) VALUES (271, N'CanteenReport', N'Reports/TA_UI_Report_CanteenReport.aspx', 144, 3, NULL)
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) 
VALUES (N'SuperAdmin', 1, 267, 207, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
INSERT  INTO [dbo].[TA_Tbl_userRights] ([groupName], [groupId], [pageId], [pageGroupId], [addPrv], [modifyPrv], [deletePrv], [viewPrv], [isDeleted], [timeStamp], [employeeId]) 
VALUES (N'SuperAdmin', 1, 271, 144, 1, 1, 1, 1, 0, GETDATE(), CAST(1 AS Decimal(18, 0)))
Insert into ta_tbl_HelpContent values('How to create employees in TimeCheck?',' <p style="text-align: left !important; padding-left: 10px !important;">
                                        Once you have created the details of your organization, the next step is to add up your employees to application.
                                    </p>
                                    <p style="text-align: left !important; padding-left: 10px !important;">Employees can be added to your organization in any of the below two methods:</p>
                                    <ul>
                                        <li><a href="#">Create Employee(s) manually</a></li>
                                        <li><a href="#">Import Employee(s)</a></li>
                                    </ul>
                                    <p style="text-align: left !important; padding-left: 10px !important;">Create Employee(s) manually is a method to add employees manually to application. You can give the users user id and password. They can change their password later.</p>
                                    <ul>
                                        <li>Click Employee Management > Masters > Employee Master</li>
                                        <li>Click ''Add'' Button, it will redirect to add page for create employee manually.</li>
                                    </ul>
                                    <p style="text-align: left !important; padding-left: 10px !important;">''Import Employee(s)''</p>
                                    <ul>
                                        <li>Click Employee Management > Masters > Master Data Import</li>
                                        <li>Download Template file</li>
                                        <li>Fill the document as per information mentioned in the screen and then upload it</li>
                                    </ul>',GETDATE())
Insert into ta_tbl_HelpContent values('Where to configure Overtime in TimeCheck?','<p style="text-align: left !important; padding-left: 10px !important;">
                                    For calculating overtime on working day , you need to configure overtime in below pages.
                                    <ul>
                                        <li>In Employee master, you need to configure overtime eligible as <b>Yes</b></li>
                                        <li>And then in shift master, you need to configure below fields for overtime calculation.
                                            <ul>
                                                <li>Minimum Extra time for overtime </li>
                                                <li>Maximum Extra time for overtime</li>
                                                <li>And Over Time On Working Days</li>
                                            </ul>
                                        </li>
                                        <li>Based on the above configurations the system will calculate overtime.</li>
                                        <li>Note: if any one of above mentioned fields are not configured, that case the system wont calculate Overtime.</li>
                                    </ul>
                                    For calculating overtime on weekly off and Holiday, you need to configure overtime value in below page.
                                    <ul>
                                        <li>Configuration -> Organization Settings -> OT & Comp Off Tab</li>
                                    </ul>
                                </p>',GETDATE())                                    
Insert into ta_tbl_HelpContent values('How to allocate Shift to employees?','<p style="text-align: left !important; padding-left: 10px !important;">
                                    For allocating the shift to employee(s), please proceed the below steps,
                                    <ul>
                                        <li>Click Shift Management > Transaction > Shift Allocation > Add </li>
                                        <li>Choose the Employee selection mode, based on your needs.</li>
                                        <li>If you want to allocate shift for one employee alone, please choose Single option otherwise choose Multiple option for allocation</li>
                                        <li>Based on the employee selection, it will load shift details into shift dropdown.</li>
                                        <li>Pick the Shift and select the weekly off days</li>
                                        <li>And then enter the from and to date</li>
                                        <li>Click Save Button.</li>
                                        Note:Based on the from and to date mentioning, it will allocate the shift to employee(s).
                                    </ul>
                                </p>',GETDATE())
Insert into ta_tbl_HelpContent values('How to update email id to all employees?','<p style="text-align: left !important; padding-left: 10px !important;">
                                    Using CSV / excel file, we can update email id to all employees within few seconds.
                                    For updating email ids to all employee(s), proceed the below steps.
                                    <ul>
                                        <li>Click Employee Management > Masters > Employee Master > Bulk Configuration Button, it will redirect you to one new window for updation. </li>
                                        <li>Click Download Template Button, it will download one excel file in CSV format.</li>
                                        <li>Fill employee Id, Official / person Email id of the employees.</li>
                                        <li>Then save and close the file</li>
                                        <li>Now click choose file button, it will open one new window. Please choose the file where you are saved the filled document.</li>
                                        <li>And then choose the category as Official Email ID / Personal Email ID option. Based on this selection only, the system will refer the data in excel document and update it into database.</li>
                                        <li>Now click upload button. if it successfully updated into database you will receive updated successfully alert message otherwise you will receive some other alert message.</li>
                                    </ul>
                                </p>',GETDATE())
Insert into ta_tbl_HelpContent values('How many employees can able to create in demo version?','<p style="text-align: left !important; padding: 0px 10px !important;">
                                    User can able to create <b>N Number </b>of employees into demo version using Manual creation / Import Master in Timecheck, but they can able to do any transaction / viewing report for <b>5 employees</b> alone in <b>Demo Version</b>.
                                </p>',GETDATE())
Insert into ta_tbl_HelpContent values('How to add devices and Punch Types in TimeCheck?','<p style="text-align: left !important; padding-left: 10px !important;">
                                    To create device:
                                </p>
                                <ul>
                                    <li>Click Device Management > Terminal > Terminal Master</li>
                                    <li>Click ''Add'' Button in list page, it will redirect you to add page for create device manually.</li>
                                    <li>Enter the device ID, Name and select raw data Format (i.e which database the device logs will be saved, that one select here in the dropdown) </li>
                                    <li>Then Click Save Button</li>
                                </ul>
                                <br />
                                <ul>
                                    <li>After creation of devices in terminal master, you need to define which devices are you using as In device and Out device in each door / entrances. Based on this configuration only, we are differentiating each punches as in and out and saved in database.</li>
                                    <li><strong>So whenever you are purchasing / replacing the devices that time you need to create device in terminal master and in Entrance master.</strong></li>
                                </ul>
                                <p style="text-align: left !important; padding-left: 10px !important;">
                                    To Configure In & Out device:
                                </p>
                                <p style="text-align: left !important; padding-left: 10px !important;">
                                    To configure In and Out device of each door / entrance, please proceed the below steps,
                                </p>
                                <ul>
                                    <li>Click Device Management > Entrance Master > Add</li>
                                    <li>Click ''Add'' Button in list page, it will redirect you to add page for create device manually.</li>
                                    <li>Enter the meaningful name in Entrance Name field for your quick access in furture if you have more than one entrance.</li>
                                    <li>Then select the Number of In and Out terminal count of this particular entrance.</li>
                                    <li>Based on the selection, it will load the dropdowns, select device in each dropdowns and then Click save button</li>
                                </ul>
                                <p style="text-align: left !important; padding-left: 10px !important;">
                                    Create Punch Type:
                                </p>
                                <p style="text-align: left !important; padding-left: 10px !important;">
                                    After creation of entrance master, create the punch types for each devices,
                                </p>
                                <ul>
                                    <li>Click Device Management > PunchType Master > Add</li>
                                    <li>Select Device</li>
                                    <li>Select Punch Type</li>
                                    <li>Enter Punch Type value</li>
                                    <li>Click Save Button</li>
                                </ul>',GETDATE())
Insert into ta_tbl_HelpContent values('What is meant by Freescan and Function Key in shift master?','<p style="text-align: left !important; padding: 0px 10px !important;">
                                    Free Scan:<br />
                                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Before doing an punch in device if any key is not pressed by employee, that should be called as Free Scan.
                                    <br />
                                    Function Key:<br />
                                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Before doing an punch in device any key is pressed by employee, that should be called as Function Key.
                                </p>',GETDATE())                                                                
Insert into ta_tbl_HelpContent values('Where to Configure Mail Domain details for Email Triggerring?','<p style="text-align: left !important; padding: 0px 10px !important;">
                                    Mail Configuration :
                                </p>
                                <ul>
                                    <li>Click Device Management > PunchType Master > Add</li>
                                    <li>Select Device</li>
                                    <li>Select Punch Type</li>
                                    <li>Enter Punch Type value</li>
                                    <li>Click Save Button</li>
                                </ul>',GETDATE())	
															