TABLE1
CREATE TABLE [dbo].[ICT_Log_ScannedDocumentTransmission_Branch](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[ParentTblRowID] [int] NULL,
	[ApplTrackingNo] [varchar](20) NULL,
	[ScannedDocumentPath] [nvarchar](max) NULL,
	[FileTypeCategory] [nvarchar](250) NULL,
	[Remarks] [nvarchar](250) NULL,
	[IsActive] [int] NULL,
	[CreatedBy] [varchar](20) NULL,
	[CreatedOn] [datetime] NULL,
 CONSTRAINT [PK_Log_ScannedDocumentTransmission_Branch] PRIMARY KEY CLUSTERED 
(
	[RowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_Branch] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [FileTypeCategory], [Remarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (1, 124881, N'0124881-11/08', N'124881_PRAME_03020321_0.pdf', N'A Scanned Document Re-upload By Branch', N'SUJATHA DOCUMENT UPLOADED', 1, NULL, CAST(N'2023-10-03T14:04:08.937' AS DateTime))
GO
INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_Branch] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [FileTypeCategory], [Remarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (2, 124880, N'0124880-11/08', N'124880_PRAME_03020432_s.pdf', N'A Scanned Document Re-upload By Branch', N'SUJATHA DOCUMENTS UPLOADED', 1, NULL, CAST(N'2023-10-03T14:04:51.107' AS DateTime))
GO
INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_Branch] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [FileTypeCategory], [Remarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (3, 125361, N'0125361-21/08', N'125361_PRAME_03020509_s.pdf', N'A Scanned Document Re-upload By Branch', N'VINNARASI YAYARANI DOCUMENTS UPLOADED', 1, NULL, CAST(N'2023-10-03T14:06:03.263' AS DateTime))
GO
INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_Branch] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [FileTypeCategory], [Remarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (4, 129368, N'0129368-27/09', N'129368_PRAME_03021515_).pdf', N'A Scanned Document Newly Upload By Branch', N'-', 1, NULL, CAST(N'2023-10-03T14:15:19.060' AS DateTime))
GO


TABLE 2

CREATE TABLE [dbo].[ICT_Log_ScannedDocumentTransmission_HO](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[ParentTblRowID] [int] NULL,
	[ApplTrackingNo] [varchar](20) NULL,
	[ScannedDocumentPath] [nvarchar](max) NULL,
	[IsApproved] [int] NULL,
	[ApproveRejectCategory] [nvarchar](250) NULL,
	[ApproveRejectRemarks] [nvarchar](250) NULL,
	[IsActive] [int] NULL,
	[CreatedBy] [varchar](20) NULL,
	[CreatedOn] [datetime] NULL,
 CONSTRAINT [PK_Log_ScannedDocumentTransmission_HO] PRIMARY KEY CLUSTERED 
(
	[RowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_HO] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [IsApproved], [ApproveRejectCategory], [ApproveRejectRemarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (140, 125233, N'0125233-18/08', N'125233_PRAME_05064059_i.pdf', 1, N'', N'-', 1, N'E01958', CAST(N'2023-10-06T11:03:03.827' AS DateTime))
GO
INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_HO] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [IsApproved], [ApproveRejectCategory], [ApproveRejectRemarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (141, 127419, N'0127419-11/09', N'127419_PRAME_05063954_0.pdf', 1, N'', N'-', 1, N'E01958', CAST(N'2023-10-06T11:04:39.750' AS DateTime))
GO
INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_HO] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [IsApproved], [ApproveRejectCategory], [ApproveRejectRemarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (142, 127421, N'0127421-11/09', N'127421_PRAME_05064032_0.pdf', 1, N'', N'-', 1, N'E01958', CAST(N'2023-10-06T11:06:07.560' AS DateTime))
GO
INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_HO] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [IsApproved], [ApproveRejectCategory], [ApproveRejectRemarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (143, 125700, N'0125700-25/08', N'26124303_sed.pdf', 1, N'', N'-', 1, N'E01958', CAST(N'2023-10-06T11:09:08.000' AS DateTime))
GO
INSERT [dbo].[ICT_Log_ScannedDocumentTransmission_HO] ([RowID], [ParentTblRowID], [ApplTrackingNo], [ScannedDocumentPath], [IsApproved], [ApproveRejectCategory], [ApproveRejectRemarks], [IsActive], [CreatedBy], [CreatedOn]) VALUES (144, 125793, N'0125793-28/08', N'26124626_sed.pdf', 1, N'', N'-', 1, N'E01958', CAST(N'2023-10-06T11:10:27.857' AS DateTime))
GO