No hay datos.
| SessionId | Host | Aplicacion | Usuario | InicioTransaccion | SegundosAbierta | TipoTransaccion | UltimaConsulta |
|---|
| 178 | DWSGDAAPP3 | MicroSQL | ophelia | 5/26/2026 11:26:44 PM | 38097 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 56 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 6:53:27 AM | 11294 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 630 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 7:37:49 AM | 8632 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 816 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 7:37:49 AM | 8632 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 495 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 7:40:27 AM | 8474 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 552 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 7:46:28 AM | 8113 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 698 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 7:50:14 AM | 7887 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 917 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:07:42 AM | 6839 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 675 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 8:07:42 AM | 6839 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 52 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:13:19 AM | 6502 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 241 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 8:16:35 AM | 6306 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 434 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:17:47 AM | 6234 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 842 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 8:20:44 AM | 6057 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 894 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:23:22 AM | 5899 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1247 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:27:05 AM | 5676 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1350 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:28:22 AM | 5599 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 810 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:28:22 AM | 5599 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1215 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:29:40 AM | 5521 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1494 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 8:32:19 AM | 5362 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 834 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:32:34 AM | 5347 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 254 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:32:51 AM | 5330 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 280 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:32:55 AM | 5326 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 646 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:35:33 AM | 5168 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1504 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 8:37:52 AM | 5029 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 224 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:37:52 AM | 5029 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 994 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:40:16 AM | 4885 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 291 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 8:40:52 AM | 4849 | Read/Write | (@p0 varchar(32),@p1 varchar(37),@p2 varchar(9),@p3 varchar(37),@p4 varchar(37),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 748 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:41:05 AM | 4836 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 708 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:43:46 AM | 4675 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 166 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:45:19 AM | 4582 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 667 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:47:38 AM | 4443 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1508 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:53:19 AM | 4102 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 925 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:54:44 AM | 4017 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 921 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:54:44 AM | 4017 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 846 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 8:55:49 AM | 3952 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1542 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 8:55:49 AM | 3952 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1124 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 8:55:49 AM | 3952 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1241 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:03:40 AM | 3481 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1296 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:07:49 AM | 3232 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1486 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:09:47 AM | 3114 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1093 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:11:47 AM | 2994 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 492 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:11:47 AM | 2994 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 201 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:11:50 AM | 2991 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1104 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:11:50 AM | 2991 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1105 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:11:50 AM | 2991 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 199 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:11:50 AM | 2991 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 793 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:11:50 AM | 2991 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 760 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:11:52 AM | 2989 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1625 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:13:20 AM | 2901 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 723 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:14:19 AM | 2842 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1509 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:14:47 AM | 2814 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 803 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:15:28 AM | 2773 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 769 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:15:28 AM | 2773 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1261 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:19:42 AM | 2519 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1713 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:20:05 AM | 2496 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1677 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:20:30 AM | 2471 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1694 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:20:30 AM | 2471 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 780 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:21:25 AM | 2416 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1481 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:21:47 AM | 2394 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1405 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:21:47 AM | 2394 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1638 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:21:55 AM | 2386 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1203 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:22:01 AM | 2380 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1529 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:23:42 AM | 2279 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 797 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:23:47 AM | 2274 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 892 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:24:06 AM | 2255 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1637 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:24:33 AM | 2228 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1101 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:25:03 AM | 2198 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 180 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:25:03 AM | 2198 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 508 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:25:14 AM | 2187 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1633 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:26:06 AM | 2135 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1161 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:27:13 AM | 2068 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1218 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:27:13 AM | 2068 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1545 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:27:13 AM | 2068 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1527 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:27:13 AM | 2068 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1642 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:30:13 AM | 1888 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 155 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:31:07 AM | 1834 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1778 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:31:07 AM | 1834 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 292 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:31:32 AM | 1809 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 262 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:32:46 AM | 1735 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1548 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:34:11 AM | 1650 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 515 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:34:20 AM | 1641 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1357 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:35:16 AM | 1585 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1030 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:36:53 AM | 1488 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1449 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:37:27 AM | 1454 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1631 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:37:27 AM | 1454 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1516 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:37:29 AM | 1452 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 861 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:38:29 AM | 1392 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 344 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:39:23 AM | 1338 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1624 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:39:55 AM | 1306 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1587 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:40:52 AM | 1249 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1891 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:41:52 AM | 1189 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 541 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:42:47 AM | 1134 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 751 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:44:55 AM | 1006 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1794 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:45:12 AM | 989 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1922 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:45:50 AM | 951 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 509 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:46:07 AM | 934 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 950 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:46:09 AM | 932 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1898 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:47:30 AM | 851 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1754 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:49:04 AM | 757 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 896 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:50:13 AM | 688 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 796 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:51:13 AM | 628 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 853 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:52:22 AM | 559 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1657 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:52:28 AM | 553 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1526 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:55:39 AM | 362 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1632 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:55:55 AM | 346 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1473 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:55:55 AM | 346 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1613 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 9:55:55 AM | 346 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1103 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:56:01 AM | 340 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 741 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 9:56:16 AM | 325 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1436 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:57:09 AM | 272 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1810 | DWSGDAAPP1 | MicroSQL | ophelia | 5/27/2026 9:57:36 AM | 245 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 190 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xDCF24DF6FDDD0D4197DB36799C464B02 : Step 5) | DIGITALWARE\SCVSGDA-AGENT | 5/27/2026 9:59:35 AM | 126 | Read/Write |
CREATE PROCEDURE [dbo].[PQRSD]
AS
SET LANGUAGE SPANISH
BEGIN
-- Verificar si la tabla existe
IF OBJECT_ID('dbo.pqrsdConsolidated', 'U') IS NOT NULL
BEGIN
-- Si la tabla existe, eliminar los datos existentes
TRUNCATE TABLE dbo.pqrsdConsolidated;
END
ELSE
BEGIN
-- Si la tabla no existe, crearla
CREATE TABLE dbo.pqrsdConsolidated (
[RADICADO] [varchar](30) NULL,
[FECHA_RADICADO] [varchar](10) NULL,
[HORA_RADICADO] [varchar](8) NULL,
[MEDIO_DE_RECEPCION] [varchar](30) NULL,
[DEPENDENCIA_ASIGNADA] [varchar](100) NULL,
[DEPENDENCIA_DE_RADICACION] [varchar](100) NULL,
[USUARIO_RADICADOR] [varchar](60) NULL,
[TIPO_DE_PQR] [varchar](40) NULL,
[CAUSAL] [varchar](140) NULL,
[DETALLE_CAUSAL] [varchar](140) NULL,
[DETALLE_DESAGREGADO_CAUSAL] [varchar](140) NULL,
[NOMBRE_REMITENTE] [varchar](250) NULL,
[CONDICION_ESPECIAL] [varchar](160) NULL,
[TIPO_PERSONA] [varchar](50) NULL,
[TIPO_DE_DOCUMENTO_REMITENTE] [varchar](80) NULL,
[DOCUMENTO_DE_REMITENTE] [varchar](20) NULL,
[DIRECCION_REMITENTE] [varchar](160) NULL,
[BARRIO_REMITENTE] [varchar](80) NULL,
[CIUDAD_REMITENTE] [varchar](60) NULL,
[DEPARTAMENTO_REMITENTE] [varchar](80) NULL,
[EMAIL_REMITENTE] [varchar](80) NULL,
[TELEFONO_REMITENTE] [varchar](15) NULL,
[CELULAR_REMITENTE] [varchar](15) NULL,
[USUARIO_FOMAG] [varchar](50) NULL,
[ENTE_REMITENTE] [varchar](50) NULL,
[ASUNTO_RADICADO] [varchar](700) NULL,
[FUNCIONARIO_ACTUAL] [varchar](50) NULL,
[DEPENDENCIA_ACTUAL] [varchar](100) NULL,
[FECHA_DE_TRAMITE_PQR] [varchar](10) NULL,
[TRAMITE_PROCEDENTE] [varchar](4) NULL,
[TRAMITE_A_FAVOR_DEL_CONSUMIDOR_O_LA_ENTIDAD] [varchar](30) NULL,
[TRMTE_ACEPTADO_POR_LA_ENTIDAD] [varchar](80) NULL,
[TRMTE_RECHAZADO_POR_LA_ENTIDAD] [varchar](2) NULL,
[TRMTE_REMTDO_A_SUPERFINANCIERA] [varchar](2) NULL,
[TRMTE_RECTIFICADO_POR_ENTIDAD] [varchar](100) NULL,
[TRAMITE_DESISTIDO] [varchar](40) NULL,
[RADICADO_RESPUESTA_FINAL] [varchar](30) NULL,
[FECHA_DE_CONTESTACION] [varchar](10) NULL,
[MEDIO_DE_CONTESTACION] [varchar](30) NULL,
[DEPENDENCIA_QUE_CONTESTA] [varchar](100) NULL,
[USUARIO_QUE_CONTESTA] [varchar](50) NULL,
[ESTADO_ACTUAL] [varchar](10) NOT NULL,
[TOTAL_DIAS_TRAMITE] [int] NULL,
[FECHA_DE_VENCIMIENTO] [varchar](10) NULL,
[MES/AÑO] [varchar](20) NULL,
[ESTADO_DEL_TRAMITE] [varchar](25) NULL,
[GESTION] [varchar](9) NOT NULL,
[PROCESO] [varchar](80) NULL,
[USUARIO_QUE_ARCHIVA] [varchar](50) NULL,
[FECHA_RESPUESTA_PARCIAL] [varchar](30) NULL,
[TIPO DE RESPUESTA] [varchar](20) NULL,
[DIAS_RESPUESTA_PARCIAL] [int] NULL,
[FECHA_DE_VENCIMIENTO_FINAL] [varchar](10) NULL,
[RADICADO_RESPUESTA_PARCIAL] [varchar](30) NULL,
[REVISION] [varchar](140) NULL,
[APROBACION] [varchar](140) NULL,
[AREA] [varchar](100) NULL,
[AñoFil] [int] NULL,
[MesFil] [int] NULL,
[DependenciaFil] [varchar](40) NULL,
[UsuarioFil] [varchar](50) NULL,
[RowNum] [int] NULL,
[TIPO_DE_FRAUDE] [varchar](40) NULL,
[MODALIDAD_DE_FRAUDE] [nvarchar](max) NULL,
[MONTO_RECLAMADO] [varchar](40) NULL,
[MONTO_RECONOCIDO] [varchar](40) NULL
);
END
-- Insertar los datos en la tabla [pqrsdConsolidated_V2]
INSERT INTO [dbo].[pqrsdConsolidated] ([RADICADO], [FECHA_RADICADO], [HORA_RADICADO], [MEDIO_DE_RECEPCION], [DEPENDENCIA_ASIGNADA], [DEPENDENCIA_DE_RADICACION], [USUARIO_RADICADOR], [TIPO_DE_PQR], [CAUSAL], [DETALLE_CAUSAL], [DETALLE_DESAGREGADO_CAUSAL], [NOMBRE_REMITENTE], [CONDICION_ESPECIAL], [TIPO_PERSONA], [TIPO_DE_DOCUMENTO_REMITENTE], [DOCUMENTO_DE_REMITENTE], [DIRECCION_REMITENTE], [BARRIO_REMITENTE], [CIUDAD_REMITENTE], [DEPARTAMENTO_REMITENTE], [EMAIL_REMITENTE], [TELEFONO_REMITENTE], [CELULAR_REMITENTE], [USUARIO_FOMAG], [ENTE_REMITENTE], [ASUNTO_RADICADO], [FUNCIONARIO_ACTUAL], [DEPENDENCIA_ACTUAL], [FECHA_DE_TRAMITE_PQR], [TRAMITE_PROCEDENTE], [TRAMITE_A_FAVOR_DEL_CONSUMIDOR_O_LA_ENTIDAD], [TRMTE_ACEPTADO_POR_LA_ENTIDAD], [TRMTE_RECHAZADO_POR_LA_ENTIDAD], [TRMTE_REMTDO_A_SUPERFINANCIERA], [TRMTE_RECTIFICADO_POR_ENTIDAD], [TRAMITE_DESISTIDO], [RADICADO_RESPUESTA_FINAL], [FECHA_DE_CONTESTACION], [MEDIO_DE_CONTESTACION], [DEPENDENCIA_QUE_CONTESTA], [USUARIO_QUE_CONTESTA], [ESTADO_ACTUAL], [TOTAL_DIAS_TRAMITE], [FECHA_DE_VENCIMIENTO], [MES/AÑO], [ESTADO_DEL_TRAMITE], [GESTION], [PROCESO], [USUARIO_QUE_ARCHIVA], [FECHA_RESPUESTA_PARCIAL], [TIPO DE RESPUESTA], [DIAS_RESPUESTA_PARCIAL], [FECHA_DE_VENCIMIENTO_FINAL], [RADICADO_RESPUESTA_PARCIAL], [REVISION], [APROBACION], [AREA], [AñoFil], [MesFil], [DependenciaFil], [UsuarioFil], [RowNum], [TIPO_DE_FRAUDE], [MODALIDAD_DE_FRAUDE], [MONTO_RECLAMADO], [MONTO_RECONOCIDO])
SELECT
*
FROM
(
SELECT
CAST(RequestFiles.FileNumber AS VARCHAR(30)) AS [RADICADO]
,CAST(RequestFiles.FiledDate AS DATE) AS [FECHA_RADICADO]
,CONVERT(VARCHAR(8), RequestFiles.FiledDate, 108) AS [HORA_RADICADO]
,CAST(CANAL.Name AS VARCHAR(30)) AS [MEDIO_DE_RECEPCION]
,CAST(COALESCE(Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_ASIGNADA]
,CAST(COALESCE(IIF(Users1.UserName='DEFENSOR','GERENCIA DE SERVICIO AL CLIENTE', Dependencies1.Name), Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_DE_RADICACION]
,CAST(CONCAT(Users1.Name, ' ', Users1.Surnames) AS VARCHAR(50)) AS [USUARIO_RADICADOR]
,CAST(PqrsType.Name AS VARCHAR(40)) AS [TIPO_DE_PQR]
,CAST(NameType.Name AS VARCHAR(140)) AS [CAUSAL]
,CAST(ProcedureType.Name AS VARCHAR(140)) AS [DETALLE_CAUSAL]
,CAST(REPLACE(REPLACE(SpecificationType.Name, CHAR(13), ''), CHAR(10), '') AS VARCHAR(140)) AS [DETALLE_DESAGREGADO_CAUSAL]
,CASE
WHEN TipoPersona.Name IN ('Persona Natural', 'Apoderado / Representante Legal')
THEN
CASE
WHEN Contacto.Names IS NOT NULL THEN CONCAT(Contacto.Names, Contacto.Surnames)
WHEN Contacto.Names IS NULL AND Clients.NamesClients IS NOT NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames)
ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(250))
END
WHEN TipoPersona.Name = 'Persona Jurídica'
THEN
CASE
WHEN Contacto.BusinessName IS NOT NULL THEN Contacto.BusinessName
WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NOT NULL THEN Clients.BusinessName
WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL THEN CONCAT(Contacto.Names, Contacto.Surnames)
WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL AND Contacto.Names IS NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames)
END
WHEN TipoPersona.Name = 'Anónimo' THEN 'Anónimo'
ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(250))
END AS [NOMBRE_REMITENTE]
,SpecialCondition.Name AS [CONDICION_ESPECIAL]
,CAST(ISNULL(TipoPersona.Name, TP.Name) AS VARCHAR(40)) AS [TIPO_PERSONA]
,CAST(TIPODOCUMENTOREMITENTE.Name AS VARCHAR(80)) AS [TIPO_DE_DOCUMENTO_REMITENTE]
,ISNULL(Contacto.NumberIdentification, Clients.NumberIdentification) AS [DOCUMENTO_DE_REMITENTE] ---Se actualiza para resolver caso aranda 55437 JULIOCF
,CAST(Contacto.Address AS VARCHAR(160)) AS [DIRECCION_REMITENTE]
,CAST(NeighBorhood.Description AS VARCHAR(80)) AS [BARRIO_REMITENTE]
,CAST(ISNULL(C.Description, CITY.Description) AS VARCHAR(60)) AS [CIUDAD_REMITENTE]
,CAST(ISNULL(D.Description, DEPARTMENT.Description) AS VARCHAR(80)) AS [DEPARTAMENTO_REMITENTE]
--,CAST(ISNULL(Contacto.Email, Clients.Email) AS VARCHAR(80)) AS [EMAIL_REMITENTE]
,CASE
WHEN TipoPersona.Name != 'Anónimo'
THEN CAST(ISNULL(Contacto.Email, Clients.Email) AS VARCHAR(80))
WHEN TipoPersona.Name = 'Anónimo'
AND RequestFilesRespuestaDefinitiva.FileNumber IS NOT NULL
THEN CAST(
ISNULL(ContactoRespDef.Email, ClienteRespDef.Email)
AS VARCHAR(80)
)
WHEN TipoPersona.Name = 'Anónimo'
AND RequestFilesRespuestaParcial.FileNumber IS NOT NULL
THEN CAST(
ISNULL(ContactoRespPar.Email, ClienteRespPar.Email)
AS VARCHAR(80)
)
WHEN TipoPersona.Name = 'Anónimo'
THEN 'servicioalcliente@fiduprevisora.com.co'
END AS [EMAIL_REMITENTE]
,CAST(Contacto.Telephone AS VARCHAR(15)) AS [TELEFONO_REMITENTE]
,CAST(Contacto.Mobile AS VARCHAR(15)) AS [CELULAR_REMITENTE]
,CAST(ISNULL(AffiliateTypeC.Code, AffiliateType.Code) AS VARCHAR(15)) AS [USUARIO_FOMAG]
,CAST(ReceivingInstance.Description AS VARCHAR(50)) AS [ENTE_REMITENTE]
,CAST(REPLACE(REPLACE(RequestFiles.Subject, CHAR(13), ''), CHAR(10), '') AS VARCHAR(700)) AS [ASUNTO_RADICADO]
,CAST(IIF(CONCAT(Users.Name, ' ', Users.Surnames) = '',
CONCAT(Users1.Name, ' ', Users1.Surnames),
CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(50)) AS [FUNCIONARIO_ACTUAL]
,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_ACTUAL]
,CAST(SmartAddicionalRequestFiles.CreationDateSmart AS DATE) AS [FECHA_DE_TRAMITE_PQR]
,CAST(SmartAddicionalRequestFiles.ComingFromProcedure AS VARCHAR(2)) AS [TRAMITE_PROCEDENTE]
,CAST(SmartAddicionalRequestFiles.FavorConsumerProcedure AS VARCHAR(30)) AS [TRAMITE_A_FAVOR_DEL_CONSUMIDOR_O_LA_ENTIDAD]
,CAST(Acceptance.Name AS VARCHAR(80)) AS [TRMTE_ACEPTADO_POR_LA_ENTIDAD]
,CAST(SmartAddicionalRequestFiles.RefusedEntityProcedure AS VARCHAR(2)) AS [TRMTE_RECHAZADO_POR_LA_ENTIDAD]
,CAST(SmartAddicionalRequestFiles.SuperFRemittedProcedure AS VARCHAR(2)) AS [TRMTE_REMTDO_A_SUPERFINANCIERA]
,CAST(rectification.Name AS VARCHAR(100)) AS [TRMTE_RECTIFICADO_POR_ENTIDAD]
,CAST(ComplaintWithdrawal.Description AS VARCHAR(40)) AS [TRAMITE_DESISTIDO]
,CAST(RequestFilesRespuestaDefinitiva.FileNumber AS VARCHAR(30)) AS [RADICADO_RESPUESTA_FINAL]
,CAST(ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate) AS DATE) AS [FECHA_DE_CONTESTACION]
,CAST(MAX(CANAL1.Name) OVER (PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) AS [MEDIO_DE_CONTESTACION]
,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_QUE_CONTESTA]
,CAST(IIF(CONCAT(Users.Name, ' ', Users.Surnames) = '', CONCAT(Users1.Name, ' ', Users1.Surnames), CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(50)) AS [USUARIO_QUE_CONTESTA]
,CASE
WHEN COALESCE(
CASE
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL
AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE)
THEN 'TRAMITADO OPORTUNAMENTE'
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL
AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE)
THEN 'TRAMITADO EXTEMPORALMENTE'
END,
CASE
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL
AND CAST(RequestFiles.ExperationDate AS DATE) < GETDATE() - 1
THEN 'VENCIDO'
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL
--AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) IN (0,1,2,3)
AND DA.[DiasHabiles] IN (0, 1, 2, 3) --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848
THEN 'PROXIMO A VENCER'
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL
--AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) > 3
AND DA.[DiasHabiles] >3 --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848
THEN 'EN TIEMPO'
END
) IN ('VENCIDO', 'TRAMITADO EXTEMPORALMENTE')
THEN 'INOPORTUNO'
ELSE 'OPORTUNO'
END AS [ESTADO_ACTUAL]
,RequestFilesExpirationDate.ProcedureDays AS [TOTAL_DIAS_TRAMITE]
,CAST(RequestFiles.ExperationDate AS DATE)[FECHA_DE_VENCIMIENTO]
,CAST(CONCAT(DATENAME(MONTH, DATEADD(MONTH, MONTH(RequestFiles.FiledDate) - 1, '1900-01-01')), ' - ', YEAR(RequestFiles.FiledDate)) AS VARCHAR(20)) AS [MES/AÑO]
,COALESCE(
CASE
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL
AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE)
THEN 'TRAMITADO OPORTUNAMENTE'
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL
AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE)
THEN 'TRAMITADO EXTEMPORALMENTE'
END,
CASE
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL
AND CAST(RequestFiles.ExperationDate AS DATE) < GETDATE() - 1
THEN 'VENCIDO'
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL
--AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) IN ( 0, 1, 2, 3)
AND DA.[DiasHabiles] IN (0, 1, 2, 3) --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848
THEN 'PROXIMO A VENCER'
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL
--AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) > 3
AND DA.[DiasHabiles] > 3 --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848
THEN 'EN TIEMPO'
END
) AS [ESTADO_DEL_TRAMITE]
,CASE
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL
THEN 'Tramitado'
ELSE 'Pendiente'
END AS [GESTION]
,ESTADO.Name AS [PROCESO]
,CAST(CASE
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL
THEN MAX(IIF(CONCAT(Users2.Name, ' ', Users2.Surnames) = '', NULL, CONCAT(Users2.Name, ' ', Users2.Surnames))) OVER (PARTITION BY RequestFiles.FileNumber)
END AS VARCHAR(50)) AS [USUARIO_QUE_ARCHIVA]
,CAST(RequestFilesRespuestaParcial.FiledDate AS DATE) AS [FECHA_RESPUESTA_PARCIAL]
,CASE
WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL
AND RequestFilesRespuestaDefinitiva.FiledDate IS NULL
THEN 'Respuesta Parcial'
WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL
THEN 'Respuesta Definitiva'
END AS [TIPO_DE_RESPUESTA]
,CASE
WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL AND Users1.UserName ='DEFENSOR'
THEN 8
WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL
THEN 15
END AS [DIAS_RESPUESTA_PARCIAL]
,CAST(RequestFiles.ExperationDate AS DATE) AS [FECHA_DE_VENCIMIENTO_FINAL]
,CAST(RequestFilesRespuestaParcial.FileNumber AS VARCHAR(30)) AS [RADICADO_RESPUESTA_PARCIAL]
,USuarioRevision.Funcionario AS [REVISION]
,USuarioAprobacion.Funcionario AS [APROBACION]
,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [AREA]
,CAST(YEAR(RequestFiles.FiledDate) AS INT) AS [AñoFil]
,CAST(MONTH(RequestFiles.FiledDate) AS INT) AS [MesFil]
,MAX(ISNULL(Dependencies.Code, '0')) OVER (PARTITION BY RequestFiles.FileNumber) AS [DependenciaFil]
,Users.UserName AS [UsuarioFil]
,ROW_NUMBER() OVER (PARTITION BY RequestFiles.FileNumber ORDER BY RequestFiles.FiledDate DESC) AS RowNum
-- Add campos Circular 19
,Circular19.[TIPO_DE_FRAUDE] AS [TIPO_DE_FRAUDE]
,Circular19.[MODALIDAD_DE_FRAUDE] AS [MODALIDAD_DE_FRAUDE]
,Circular19.[MONTO_RECLAMADO] AS [MONTO_RECLAMADO]
,Circular19.[MONTO_RECONOCIDO] AS [MONTO_RECONOCIDO]
FROM dms.dbo.RequestFiles WITH (NOLOCK)
--Unión con RequestFileHistories para obtener la historia más reciente
LEFT JOIN (
SELECT
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS MaxReg
,RequestFileId
,CreationDate
,DependencyId
,CaseId
,UserName
,Status
FROM dms.dbo.RequestFileHistories
WHERE Status NOT IN ('31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7','C143C3ED-F4F1-4524-AD59-80FF0F35CB9C'
,'9337A841-5E78-4C45-B1BE-9607B0833F5C','56D07A62-76F6-4AB3-A26F-E18C949CBA60','59536473-5BE9-4D7D-9CD8-D3FCB7A8D652'
,'9BD808F4-6E9F-4710-B789-19FE1CE8C55A',
--Se agregan los siguientes estados por caso SAC 960781
'4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425'
,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85')
AND (ProcessCode != 'Combinación de Correspondencia - '
AND ProcessName != 'Respuesta Parcial')
AND ProcessCode !='615'
) AS RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id
AND RequestFileHistories.MaxReg = 1
AND RequestFileHistories.DependencyId IS NOT NULL
------ Unión con RequestFileHistories1 para obtener la historia más antigua
LEFT JOIN (
SELECT
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS MinReg
,RequestFileId
,CreationDate
,DependencyId
,UserName
FROM dms.dbo.RequestFileHistories
WHERE ProcessCode !='615'
) AS RequestFileHistories1 ON RequestFileHistories1.RequestFileId=RequestFiles.Id
AND RequestFileHistories1.MinReg = 1
LEFT JOIN OpheliaSuite.dbo.WF_SEGUI_PEN ON WF_SEGUI_PEN.CAS_CONT=RequestFileHistories.CaseId
AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%'
AND FLU_CONT !=100
LEFT JOIN [Stage].[dbo].[Users_Stage] Users ON Users.UserName=ISNULL(WF_SEGUI_PEN.SEG_UENC,RequestFileHistories.UserName)
LEFT JOIN [Stage].[dbo].[Users_Stage] Users1 ON Users1.UserName=RequestFileHistories1.UserName
LEFT JOIN dms.dbo.Dependencies Dependencies3 ON Dependencies3.Id=RequestFileHistories.DependencyId
LEFT JOIN ( --Subconsulta para obtener el nombre de la dependencia asociada al usuario
SELECT
UserId
,Dependencies.Name
,CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.Code END Code
,ROW_NUMBER() OVER (PARTITION BY UserId ORDER BY Code) NUMROW
FROM [Stage].[dbo].[Users_Stage] Users
INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId
INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId
)Dependencies ON Users.Id=Dependencies.UserId AND Dependencies.NUMROW=1
LEFT JOIN dms.dbo.Dependencies Dependencies1 ON Dependencies1.Id=RequestFileHistories1.DependencyId
LEFT JOIN dms.dbo.Dependencies Dependencies4 ON RequestFileHistories.DependencyId = Dependencies4.Id
LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=RequestFileHistories.Status
LEFT JOIN dms.dbo.TypeDetail CANAL ON CANAL.Id=RequestFiles.ChannelId
LEFT JOIN dms.dbo.Clients ON RequestFiles.ClientId=Clients.Id
LEFT JOIN DMS.DBO.Contacts Contacto ON Contacto.Id = RequestFiles.ContactId
LEFT JOIN DMS.dbo.TypeDetail SpecialCondition ON Clients.SpecialConditionId = SpecialCondition.ID
LEFT JOIN dms.dbo.TypeDetail TIPODOCUMENTOREMITENTE ON Clients.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id
LEFT JOIN dms.dbo.GeographicsLocation CITY ON Clients.CityId=CITY.Id
LEFT JOIN dms.dbo.GeographicsLocation C ON Contacto.CityId = C.ID
LEFT JOIN dms.dbo.GeographicsLocation DEPARTMENT ON Clients.DepartamentId=DEPARTMENT.Id
LEFT JOIN dms.dbo.GeographicsLocation D ON Contacto.DepartamentId = D.ID
LEFT JOIN dms.dbo.GeographicsLocation NeighBorhood ON Clients.NeighBorhoodId=NeighBorhood.Id
LEFT JOIN dms.dbo.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId
LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId
LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId
LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId
LEFT JOIN DMS.dbo.PQRSDType PqrsType ON PqrsType.Id=RequestFiles.PqrsTypeId
LEFT JOIN dms.dbo.TypeDetail AffiliateTypeC ON Contacto.AffiliateTypeId = AffiliateTypeC.ID
LEFT JOIN dms.dbo.TypeDetail AffiliateType ON Clients.AffiliateTypeId=CAST(AffiliateType.Id AS VARCHAR(40))
LEFT JOIN dms.dbo.TypeDetail ReceivingInstance ON RequestFiles.ReceivingInstanceId=CAST(ReceivingInstance.Id AS VARCHAR(40))
LEFT JOIN dms.dbo.SmartAddicionalRequestFiles ON SmartAddicionalRequestFiles.RequestFilesId=RequestFiles.Id
LEFT JOIN dms.dbo.TypeDetail Acceptance ON SmartAddicionalRequestFiles.Acceptance=CAST(Acceptance.Id AS VARCHAR(40))
LEFT JOIN dms.dbo.TypeDetail ComplaintWithdrawal ON SmartAddicionalRequestFiles.ComplaintWithdrawal=CAST(ComplaintWithdrawal.Id AS VARCHAR(40))
LEFT JOIN dms.dbo.TypeDetail Rectification ON SmartAddicionalRequestFiles.Rectification = CAST(Rectification .Id AS VARCHAR(40))
LEFT JOIN RequestFilesExpirationDate ON RequestFilesExpirationDate.FileNumber=RequestFiles.FileNumber
LEFT JOIN (--LEFT JOIN con RequestFileHistoriesRevision para obtener la última revisión de la respuesta
SELECT UserName,RequestFileId,ROW_NUMBER() OVER(PARTITION BY RequestFileId ORDER BY CreationDate DESC,RequestFileId,UserName)NumberFile
FROM dms.dbo.RequestFileHistories A
inner JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=a.Status AND ESTADO.name IN ('Respuesta en revisión')
)RequestFileHistoriesRevision ON RequestFiles.Id=RequestFileHistoriesRevision.RequestFileId AND RequestFileHistoriesRevision.NumberFile=1
LEFT JOIN (--LEFT JOIN con RequestFileHistoriesAprobacion para obtener la última aprobación de la respuesta
SELECT UserName,RequestFileId,ROW_NUMBER() OVER(PARTITION BY RequestFileId ORDER BY CreationDate DESC,RequestFileId,UserName)NumberFile
FROM dms.dbo.RequestFileHistories A
inner JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=a.Status AND ESTADO.name IN ('Respuesta aprobada')
)RequestFileHistoriesAprobacion ON RequestFiles.Id=RequestFileHistoriesAprobacion.RequestFileId AND RequestFileHistoriesAprobacion.NumberFile=1
LEFT JOIN dms.dbo.USERS_VW USuarioRevision ON USuarioRevision.UserName= RequestFileHistoriesRevision.UserName
LEFT JOIN dms.dbo.USERS_VW USuarioAprobacion ON USuarioAprobacion.UserName= RequestFileHistoriesAprobacion.UserName
LEFT JOIN (--LEFT JOIN con RequestFilesRespuestaParcial y RequestFilesRespuestaDefinitiva para obtener las respuestas parciales y definitivas
SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,ContactId,ClientId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate ASC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile
FROM dms.dbo.RelatedRequestFiles B
INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id
WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=2)RequestFilesRespuestaParcial ON RequestFiles.Id=RequestFilesRespuestaParcial.ParentId AND RequestFilesRespuestaParcial.NumberFile=1
LEFT JOIN (-- LEFT JOIN con otras respuestas definitivas para obtener la última respuesta definitiva
SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,ContactId,ClientId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate DESC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile
FROM dms.dbo.RelatedRequestFiles B
INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id
WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=1) RequestFilesRespuestaDefinitiva ON RequestFiles.Id=RequestFilesRespuestaDefinitiva.ParentId AND RequestFilesRespuestaDefinitiva.NumberFile=1
-- Contacto respuesta definitiva
LEFT JOIN dms.dbo.Contacts ContactoRespDef ON ContactoRespDef.Id = RequestFilesRespuestaDefinitiva.ContactId
LEFT JOIN dms.dbo.Clients ClienteRespDef ON ClienteRespDef.Id = RequestFilesRespuestaDefinitiva.ClientId
-- Contacto respuesta parcial
LEFT JOIN dms.dbo.Contacts ContactoRespPar ON ContactoRespPar.Id = RequestFilesRespuestaParcial.ContactId
LEFT JOIN dms.dbo.Clients ClienteRespPar ON ClienteRespPar.Id = RequestFilesRespuestaParcial.ClientId
--
LEFT JOIN dms.dbo.TypeDetail CANAL1 ON CANAL1.Id=ISNULL(RequestFilesRespuestaDefinitiva.ChannelId,RequestFilesRespuestaParcial.ChannelId)
LEFT JOIN [Stage].[dbo].[Users_Stage] Users2 ON Users2.UserName=ISNULL(RequestFilesRespuestaParcial.UserName,RequestFilesRespuestaDefinitiva.UserName)
LEFT JOIN DMS.DBO.TypeDetail TipoPersona ON TipoPersona.Id=Clients.PersonTypeId
LEFT JOIN DMS.DBO.TypeDetail TP ON Contacto.TypeContactId = TP.ID
--Consulta adiciona los campos de la actualización circular 19
LEFT JOIN (
SELECT
RequestFilesId,
FraudTypeName.Name AS [TIPO_DE_FRAUDE],
FraudModalityName.Name AS [MODALIDAD_DE_FRAUDE],
FORMAT(ISNULL(ClaimedAmount, 0), 'N0', 'es-CO') AS [MONTO_RECLAMADO],
FORMAT(ISNULL(RecognizedAmount, 0), 'N0', 'es-CO') AS [MONTO_RECONOCIDO]
FROM DMS.DBO.SmartAddicionalRequestFiles
LEFT JOIN DMS.DBO.TypeDetail AS FraudTypeName
ON SmartAddicionalRequestFiles.FraudType = FraudTypeName.Id
AND FraudTypeName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB754'
LEFT JOIN DMS.DBO.TypeDetail AS FraudModalityName
ON SmartAddicionalRequestFiles.FraudModality = FraudModalityName.Id
AND FraudModalityName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB758') AS Circular19 ON RequestFiles.Id = Circular19.RequestFilesId
--Tabla de días habiles para calcular el campo de Estado_Tramite
LEFT JOIN STAGE.DBO.DiasHabiles DA ON RequestFiles.id = DA.id
WHERE
--RequestFilesExpirationDate.FileNumber IS NOT NULL
RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7'
AND ESTADO.name NOT IN ('Anulado','Solicitud de anulación')
) AS CF
WHERE CF.RowNum = 1
--AND [NOMBRE_REMITENTE]= 'Anónimo'
END
--and RADICADO IN
--('20250326345802',
--'20261011094052',
--'20261011050582',
--'20261011187942',
--'20261011160452',
--'20261011015072',
--'20261011013682')
|
| 2069 | DWSGDASQL1 | Python | Opheliasuitebi | 5/27/2026 10:00:02 AM | 99 | Read/Write | (@0 varchar(8000),@1 varchar(8000),@2 varchar(8000))select RequestFiles . FileNumber , convert ( VARCHAR , RequestFiles . FiledDate ) Z from RequestFiles left join RequestFileHistories on RequestFiles . Id = RequestFileHistories . RequestFileId and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @0 ) ) left join TypeDetail on TypeDetail . Id = RequestFileHistories . Status where RequestFileHistories . UserName = @1 and TypeDetail . Name < > @2 |
| 2076 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1) | DIGITALWARE\SCVSGDA-AGENT | 5/27/2026 10:00:05 AM | 96 | Read/Write | CREATE PROCEDURE [dbo].[VentanillaUnica]
AS
/*
SP REFACTORIZADO POR JUAN DIEGO GARZÓN 2/24/2025:
MEJORAS:
- Eliminación de MERGE , CTE y DELETE despues de la consulta principal
- Reducción de tiempos con la utilización del CTE FilteredFileRequestHistories_CTE previo a la consulta principal 2 Minutos 25 Segundos => 30 Segundos
- Reducción de codigo gracias a INTO y DROP TABLE
- Escritura según las buenas prácticas en los alias de los campos
- Modificación de CONVERT por CAST
- Eliminación de valores NULL => 'Aun no se ha registrado numero de radicado' en el campo Radicado
- Eliminación Radicados repetidos en la tabla final
-
*/
BEGIN
-- Verificar si la tabla existe
IF OBJECT_ID('dbo.VentanillaUnicaFinal', 'U') IS NOT NULL
BEGIN
-- Si la tabla existe, eliminar los datos existentes
TRUNCATE TABLE dbo.VentanillaUnicaFinal
END
ELSE
BEGIN
-- Si la tabla no existe, crearla
CREATE TABLE [dbo].[VentanillaUnicaFinal](
[Id Tarea] [varchar](40) NULL,
[Radicado] [varchar](100) NULL,
[Fecha Radicacion] [date] NULL,
[Hora Radicacion] [time](7) NULL,
[Tipo de Documento] [varchar](500) NULL,
[Tipificacion] [varchar](652) NULL,
[Usuario Actual] [nvarchar](511) NULL,
[Vicepresidencia] [varchar](500) NULL,
[Dependencia Actual] [varchar](500) NULL,
[Asunto] [varchar](max) NULL,
[Medio de Recepcion] [varchar](2000) NULL,
[Tipo Remitente] [varchar](2000) NULL,
[Remitente] [varchar](801) NULL,
[Dependencia Radicacion] [varchar](500) NULL,
[Tipo Documento Remitente] [varchar](2000) NULL,
[Documento Remitente] [varchar](20) NULL,
[Direccion Remitente] [varchar](500) NULL,
[Celular] [varchar](50) NULL,
[Telefono] [varchar](50) NULL,
[Tipo Radicado] [varchar](2000) NULL,
[Ciudad] [varchar](500) NULL,
[Departamento] [varchar](500) NULL,
[Email] [varchar](500) NULL,
[Estado Tarea] [varchar](17) NULL,
[Fecha Vencimiento] [date] NULL,
[Usuario Radicador] [varchar](201) NULL,
[Dias Habiles de Respuesta] [int] NULL,
[Proceso] [varchar](2000) NULL,
[AñoFil] [int] NULL,
[MesFil] [int] NULL,
[ProcesoFil] [varchar](40) NULL,
[DependenciaFil] [varchar](40) NULL,
[RN] [int] NOT NULL
)
END
END;
-- Insertar los datos en la tabla [VentanillaUnicaFinal]
INSERT INTO VentanillaUnicaFinal (
[Id Tarea]
,Radicado
,[Fecha Radicacion]
,[Hora Radicacion]
,[Tipo de Documento]
,[Tipificacion]
,[Usuario Actual]
,[Vicepresidencia]
,[Dependencia Actual]
,[Asunto]
,[Medio de Recepcion]
,[Tipo Remitente]
,Remitente
,[Dependencia Radicacion]
,[Tipo Documento Remitente]
,[Documento Remitente]
,[Direccion Remitente]
,[Celular]
,[Telefono]
,[Tipo Radicado]
,[Ciudad]
,[Departamento]
,[Email]
,[Estado Tarea]
,[Fecha Vencimiento]
,[Usuario Radicador]
,[Dias Habiles de Respuesta]
,[Proceso]
,[AñoFil]
,[MesFil]
,[ProcesoFil]
,[DependenciaFil]
,[RN]
)
SELECT
*
FROM
(
SELECT WF_SEGUI_PEN.CAS_CONT AS [Id Tarea],
RequestFiles.FileNumber AS [Radicado],
CAST(RequestFileHistories.CreationDate AS DATE) AS [Fecha Radicacion],
CAST(RequestFileHistories.CreationDate AS TIME) AS [Hora Radicacion],
ISNULL(DocumentType.Name,'No Definido') [Tipo de Documento],
CONCAT(NameType.Name,' ' ,ProcedureType.Name,' ' ,SpecificationType.Name ) AS [Tipificacion],
CONCAT(Users_Stage.Name, ' ',Users_Stage.Surnames) AS [Usuario Actual],
COALESCE(
CASE WHEN DependenciesPrincipal2.Description LIKE 'VICEPRESIDENCIA%'
THEN DependenciesPrincipal2.Description ELSE NULL END
,CASE WHEN DependenciesPrincipal1.Description LIKE 'VICEPRESIDENCIA%'
THEN DependenciesPrincipal1.Description ELSE NULL END
,CASE WHEN DependenciesPrincipal.Description LIKE 'VICEPRESIDENCIA%'
THEN DependenciesPrincipal.Description ELSE NULL END
,CASE WHEN Dependencies.name LIKE 'VICEPRESIDENCIA%'
THEN Dependencies.name ELSE NULL END
) AS [Vicepresidencia],
Dependencies.Name AS [Dependencia Actual],
RequestFiles.Subject AS [Asunto],
CANAL.Name AS [Medio de Recepcion],
TipoRemitente.Name AS [Tipo Remitente],
CASE
WHEN TipoRemitente.Name IN ('Persona Natural', 'Apoderado / Representante Legal')
THEN
CASE
WHEN Contacto.Names IS NOT NULL THEN CONCAT(Contacto.Names, Contacto.Surnames)
WHEN Contacto.Names IS NULL AND Clients.NamesClients IS NOT NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames)
ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(160))
END
WHEN TipoRemitente.Name = 'Persona Jurídica'
THEN
CASE
WHEN Contacto.BusinessName IS NOT NULL THEN Contacto.BusinessName
WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NOT NULL THEN Clients.BusinessName
WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL THEN CONCAT(Contacto.Names, Contacto.Surnames)
WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL AND Contacto.Names IS NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames)
END
ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(160))
END [Remitente],
Dependencies.Name AS [Dependencia Radicacion],
TIPODOCUMENTOREMITENTE.Name AS [Tipo Documento Remitente],
ISNULL(Contacto.NumberIdentification, Clients.NumberIdentification) AS [Documento Remitente],
Clients.Address AS [Direccion Remitente],
Clients.Mobile AS [Celular],
Clients.Phone AS [Telefono],TIPORADICADO.Name AS [Tipo Radicado],
CITY.Description [Ciudad],
DEPARTMENT.Description AS [Departamento],
Clients.Email AS [Email],
CASE WHEN WF_SEGUI_PEN.SEG_FATI >= GETDATE() THEN 'Tareas a tiempo'
WHEN WF_SEGUI_PEN.SEG_FLIM <= GETDATE() THEN 'Tareas vencidas'
ELSE 'Tareas por vencer' END AS [Estado Tarea],
CAST(RequestFiles.ExperationDate AS DATE) AS [Fecha Vencimiento],
CONCAT(Users1.Name,' ', Users1.Surnames ) AS [Usuario Radicador],
DMS_Procedures.ResponseTime AS [Dias Habiles de Respuesta],
PROCESO.Name AS [Proceso],
YEAR(RequestFiles.FiledDate) AS [AñoFil],
MONTH(RequestFiles.FiledDate) AS [MesFil],
ISNULL(ESTADO.Code,0) [ProcesoFil],
ISNULL(Dependencies.Code,0) AS [DependenciaFil],
ROW_NUMBER() OVER (PARTITION BY RequestFiles.FileNumber ORDER BY RequestFileHistories.CreationDate DESC) AS RN
FROM OpheliaSuite.dbo.WF_SEGUI_PEN
INNER JOIN OpheliaSuite.dbo.WF_SEGUI ON WF_SEGUI.CAS_CONT=WF_SEGUI_PEN.CAS_CONT AND WF_SEGUI.SEG_CONT=WF_SEGUI_PEN.SEG_CONT
AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%'
LEFT JOIN DMS.DBO.RequestFileHistories ON RequestFileHistories.CaseId=WF_SEGUI_PEN.CAS_CONT
AND RequestFileHistories.CreationDate = (SELECT MAX(CreationDate) FROM DMS.DBO.RequestFileHistories A WHERE A.CaseId=WF_SEGUI_PEN.CAS_CONT)
LEFT JOIN DMS.DBO.RequestFiles ON RequestFiles.Id=RequestFileHistories.RequestFileId
LEFT JOIN Users_Stage on Users_Stage.UserName = WF_SEGUI_PEN.SEG_UENC
LEFT JOIN (
SELECT
Dependencies.Id
,UserId
,MIN(Dependencies.Name) OVER (PARTITION BY UserId) Name
,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name
THEN Dependencies.Code
END) OVER (PARTITION BY UserId) Code
,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name
THEN Dependencies.TopSection
END) OVER (PARTITION BY UserId) TopSection
,UsersCompany.State
FROM DMS.DBO.Users
INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId
INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId
INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id
AND TypeDetail.Code = (SELECT MIN(TypeDetail.Code)
FROM DMS.DBO.UsersCompany A
INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id
WHERE UsersCompany.UserId=A.UserId
GROUP BY A.UserId )
) Dependencies ON Users_Stage.Id = Dependencies.UserId
LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40)) = RequestFileHistories.Status
LEFT JOIN dms.dbo.TypeDetail PROCESO ON CAST(PROCESO.Id AS VARCHAR(40)) = RequestFileHistories.Status AND PROCESO.Name != 'Digitalizado'
LEFT JOIN DMS.DBO.DocumentType ON DocumentType.Id=RequestFiles.DocumentTypeId
LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId
LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId
LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId
LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId
LEFT JOIN DMS.DBO.TypeDetail CANAL ON CANAL.Id=RequestFiles.ChannelId
LEFT JOIN DMS.DBO.Clients ON RequestFiles.ClientId=Clients.Id
LEFT JOIN DMS.DBO.Contacts Contacto ON RequestFiles.ContactId=Contacto.Id
LEFT JOIN DMS.DBO.TypeDetail TipoRemitente ON TipoRemitente.Id= ISNULL(Contacto.TypeContactId,Clients.PersonTypeId)
LEFT JOIN DMS.DBO.TypeDetail TIPODOCUMENTOREMITENTE ON Clients.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id
LEFT JOIN DMS.DBO.TypeDetail TIPORADICADO ON RequestFiles.RequestTypeId =TIPORADICADO.Id
LEFT JOIN DMS.DBO.GeographicsLocation CITY ON Clients.CityId=CITY.Id
LEFT JOIN DMS.DBO.GeographicsLocation DEPARTMENT ON Clients.DepartamentId=DEPARTMENT.Id
LEFT JOIN DMS.DBO.Users Users1 ON Users1.UserName=RequestFileHistories.UserName
LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal ON DependenciesPrincipal.Id=Dependencies.TopSection
LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal1 ON DependenciesPrincipal1.Id=DependenciesPrincipal.TopSection
LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal2 ON DependenciesPrincipal2.Id=DependenciesPrincipal1.TopSection
) AS C
WHERE RN = 1
|
| 1189 | DWSGDAAPP2 | MicroSQL | ophelia | 5/27/2026 10:00:08 AM | 93 | Read/Write | (@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1684 | DWSGDAAPP4 | Core Microsoft SqlClient Data Provider | ophelia | 5/27/2026 10:00:59 AM | 42 | Read/Write | (@__8__locals1_req_ProceduresStateId_0 uniqueidentifier,@__8__locals1_req_NameTypeId_1 uniqueidentifier,@__8__locals1_req_ProcedureTypeId_2 uniqueidentifier,@__8__locals1_req_SpecificationTypeId_3 uniqueidentifier,@__8__locals1_req_IdTheme_4 uniqueidentifier,@__userActiveStatusId_5 uniqueidentifier)SELECT TOP(1) [d].[Id], [d].[ConfidencialityId], [d].[DependenciesId], [d].[IdBussinnes], [d].[IdTheme], [d].[Name], [d].[NameTypeId], [d].[ProcedureTypeId], [d].[ProceduresStateId], [d].[ProcessVersion], [d].[ResponseTime], [d].[ResponsibleUserId], [d].[SpecificationTypeId], [d].[TimeMeasureId], [d].[TypeAssignmentId], [u].[Id], [u].[CreationDate], [u].[DocumentNumber], [u].[Email], [u].[HandwrittenSignature], [u].[Name], [u].[PositionId], [u].[RolAgora], [u].[StatusId], [u].[Suffix], [u].[Surnames], [u].[UserName], [u].[VoBo], [d0].[Id], [d0].[ChiefDependencesId], [d0].[ClosingDate], [d0].[Code], [d0].[CompaniesId], [d0].[CostCenter], [d0].[DependencyInCharge], [d0].[Description], [d0].[ModificateDate], [d0].[ModificateUser], [d0].[Name], [d0].[State], [d0].[Suffix], [d0].[TopSection], [d0].[Type], [d0].[VersionCCD], [d0].[VersionTRD], [d0].[VersionTVD]
FROM [DMS_Procedures] AS [d]
LEFT JOIN [Users] AS [u] ON [d].[ResponsibleUserId] = [u].[Id]
LEFT JOIN [Dependencies] AS [d0] ON [d].[DependenciesId] = [d0].[Id]
WHERE [d].[ProceduresStateId] = @__8__locals1_req_ProceduresStateId_0 AND [d].[NameTypeId] = @__8__locals1_req_NameTypeId_1 AND [d].[ProcedureTypeId] = @__8__locals1_req_ProcedureTypeId_2 AND [d].[SpecificationTypeId] = @__8__locals1_req_SpecificationTypeId_3 AND [d].[IdTheme] = @__8__locals1_req_IdTheme_4 AND [u].[Id] IS NOT NULL AND [u].[StatusId] = @__userActiveStatusId_5 AND ([u].[RolAgora] <> 'DESVINCULADOS' OR [u].[RolAgora] IS NULL)
ORDER BY CAST(LEN(COALESCE([d].[ProcessVersion], '')) AS int) DESC, [d].[ProcessVersion] DESC |
| 136 | DWSGDAAPP3 | MicroSQL | ophelia | 5/27/2026 10:01:19 AM | 22 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1982 | DWSGDAAPP1 | Core Microsoft SqlClient Data Provider | ophelia | 5/27/2026 10:01:27 AM | 14 | Read/Write | -- =============================================
-- Comany: <Digital Ware>
-- Author: <Yaqueline Lizarazo Diaz>
-- Create date: <2023-05-04>
-- Description: <Inserción tabla requestfiles, registro proveniente tabla temporal RadicateInfo_tmp>
-- Consumidores:
-- =============================================
-- Control Versión
-- Autor Date Description
-- Yaqueline Lizarazo Diaz 2023-05-04 Versión Inicial
-- Yaqueline Lizarazo Diaz 2023-06-15 En la inserción de depencias relacionadas, se asigna usuario que envían en la petición relacionado a esa dependencia.
-- Yaqueline Lizarazo Diaz 2023-07-18 Se modifica insert a la tabla requestfiles para tener en cuenta dos campos nuevos Ip, Captcha.
-- Yaqueline Lizarazo Diaz 2023-08-08 Se modifica insert a la tabla requestfiles para tener en cuenta dos campos nuevos CollaborativeWorkName, CollaborativeWorkBody.
-- Yaqueline Lizarazo Diaz 2023-08-10 Se modifica insert a la tabla requestfiles para tener en cuenta el campo nuevo RepresentativeId.
-- Yaqueline Lizarazo Diaz 2023-12-07 Se modifica insert a la tabla requestfiles para tener en cuenta el campo nuevo ClientRepresentativeRelatedId.
-- Yaqueline Lizarazo Diaz 2024-01-15 Se ajusta inserción tabla requestfileshistories para asignar al campo DependencyId el primer registro de dependencia del usuario
-- tabla userscompany.
-- Yaqueline Lizarazo Diaz 2024-05-10 Se modifica insert a la tabla requestfiles para tener en cuenta el campo nuevo CollaboratorDependencyId.
-- Yaqueline Lizarazo Diaz 2024-06-13 Cuando ocurre una excepción se elimina el registro temporal que se haya podido generar en la tabla [dbo].[RadicateInfo_tmp]
-- Yaqueline Lizarazo Diaz 2025-08-16 Se modifica insert a la tabla requestfiles para tener en cuenta los campos nuevos ValidateCase y RadicateOrion.
-- Gabriel Ordonez 2025-09-05 Se agrega VersionTRD y VersionCCD a RequestFiles y RadicateInfo_tmp
-- =============================================
-- Examples
-- EXEC [DMSGenerateRadicadeSaveRequestFiles_Api] @IdRadicateTmp = '8BF05939-D190-4520-97FD-00032F583BBE'
-- =============================================
CREATE PROCEDURE [dbo].[DMSGenerateRadicadeSaveRequestFiles_Api]
@IdRadicateTmp UNIQUEIDENTIFIER,
@ProcessCode VARCHAR(50) = NULL,
@ProcessName VARCHAR(255) = NULL,
@ConcatRequestRelated VARCHAR(MAX) = NULL,
@ConcatDependenciesRelated VARCHAR(MAX) = NULL,
@UsersName VARCHAR(50),
@RespResult AS UNIQUEIDENTIFIER OUTPUT
AS
BEGIN
BEGIN TRANSACTION
BEGIN TRY
DECLARE @IdReqFile as UNIQUEIDENTIFIER = NEWID();
DECLARE @SplitSep Varchar(10)='|';
DECLARE @SplitSepInd Varchar(10)='-';
DECLARE @DependencyHistories as UNIQUEIDENTIFIER;
DECLARE @UserId as UNIQUEIDENTIFIER = (SELECT TOP 1 Id FROM Users WITH(NOLOCK) WHERE UserName = @UsersName);
IF OBJECT_ID('tempdb..##requestrelatedApi') IS NOT NULL DROP TABLE ##requestrelatedApi;
CREATE TABLE ##requestrelatedApi (
FileNumRelated VARCHAR(100)
);
IF OBJECT_ID('tempdb..##dependenciesrelatedApi') IS NOT NULL DROP TABLE ##dependenciesrelatedApi;
CREATE TABLE ##dependenciesrelatedApi (
DependRelated VARCHAR(100)
);
INSERT INTO [dbo].[RequestFiles]
([Id],[ClientId],[ProcedureId],[FileNumber],[FiledDate],[RequestTypeId],[StatusId],[Subject],[ResponseDate],[DestinyNameId],[ResponseTime]
,[DependencyId],[Pages],[Description],[UserName],[Attachments],[NamesCustomer],[Phone],[ChannelId],[MessageBody],[SenderName],[Postal]
,[ReceiverName],[ReceiverCompany],[ReceiverDependency],[SeriesId],[SubseriesId],[DestinyName],[Reason],[ApproverName],[ResposnseText],[ResponseName]
,[CourrierName],[CourrierNumber],[PqrsTypeId],[Cellphone],[AttachDescription],[OriginId],[CaseId],[DocumentTypeId],[ExperationDate],[ContactId]
,[Location],[DaysPendingManagement],[TermDeadline],[ThemeId],[ReasonId],[PerformanceId],[PQRSDAnalysisDecisionId],[SPCTypeId],[AssumeCost]
,[InformedId],[Observations],[PriorityId],[NotesIncompleteInformation],[SIGEPDirectoryId],[Ruling],[AppealRulingApplies],[AcceptTerms],[ExternalId]
,[MassiveConsecutive],[CrossReferenceNumber],[CrossReferenceResponsibleId],[CrossReferenceDate],[AnnexTypeId],[DocumentDate],[SignatureTypeId]
,[FileName],[AttachmentTypeId],[ReceivingInstanceId],[UsersId],[ComplaintAttached],[ComplaintOrigin],[ReportedSmart],[ReportedAttachedSmart]
,[BeginProcessCE],[Ip],[Captcha],[CollaborativeWorkName],[CollaborativeWorkBody],[RepresentativeId],[ClientRepresentativeRelatedId],[CollaboratorDependencyId],[ValidateCase],
[RadicateOrion],[VersionCCD],[VersionTRD])
SELECT @IdReqFile,[ClientId],[ProcedureId],[FileNumber],[FiledDate],[RequestTypeId],[StatusId],[Subject],[ResponseDate],[DestinyNameId]
,[ResponseTime],[DependencyId],[Pages],[Description],[UserName],[Attachments],[NamesCustomer],[Phone],[ChannelId],[MessageBody]
,[SenderName],[Postal],[ReceiverName],[ReceiverCompany],[ReceiverDependency],[SeriesId],[SubseriesId],[DestinyName],[Reason]
,[ApproverName],[ResposnseText],[ResponseName],[CourrierName],[CourrierNumber],[PqrsTypeId],[Cellphone],[AttachDescription],[OriginId]
,[CaseId],[DocumentTypeId],[ExperationDate],[ContactId],[Location],[DaysPendingManagement],[TermDeadline],[ThemeId],[ReasonId]
,[PerformanceId],[PQRSDAnalysisDecisionId],[SPCTypeId],[AssumeCost],[InformedId],[Observations],[PriorityId],[NotesIncompleteInformation]
,[SIGEPDirectoryId],[Ruling],[AppealRulingApplies],[AcceptTerms],[ExternalId],[MassiveConsecutive],[CrossReferenceNumber],[CrossReferenceResponsibleId]
,[CrossReferenceDate],[AnnexTypeId],[DocumentDate],[SignatureTypeId],[FileName],[AttachmentTypeId],[ReceivingInstanceId],[UsersId]
,[ComplaintAttached],[ComplaintOrigin],[ReportedSmart],[ReportedAttachedSmart],[BeginProcessCE],[Ip],[Captcha],[CollaborativeWorkName],[CollaborativeWorkBody]
,[RepresentativeId],[ClientRepresentativeRelatedId],[CollaboratorDependencyId],[ValidateCase],[RadicateOrion],[VersionCCD],[VersionTRD]
FROM [dbo].[RadicateInfo_tmp]
WHERE [Id] = @IdRadicateTmp;
UPDATE [dbo].[RadicateInfo_tmp]
SET ID = @IdReqFile
WHERE [Id] = @IdRadicateTmp;
SET @IdReqFile = (SELECT Id FROM RequestFiles WITH(NOLOCK) WHERE Id = @IdReqFile)
--SELECT @IdReqFile
IF(@IdReqFile IS NOT NULL)
BEGIN
--Se asigna dependencia que se va setear al registro de requestfileshistories
SET @DependencyHistories = (SELECT TOP 1 DependenceId FROM UsersCompany WITH(NOLOCK) WHERE UserId = @UserId);
--Se inserta registro en RequestFileHistories
INSERT INTO [dbo].[RequestFileHistories]
([Id],[RequestFileId],[Reason],[UserName],[Status],[CreationDate],[DependencyId],[CaseId],[ProcessCode],[ProcessName])
SELECT NEWID(),[Id],(SELECT TOP 1 [Detail] FROM [dbo].[TypeDetail] WHERE [Id] = [StatusId]),[UserName],[StatusId],
GETDATE(),@DependencyHistories,[CaseId],@ProcessCode, @ProcessName
FROM [dbo].[RequestFiles]
WHERE [Id] = @IdReqFile
--Se valida si tiene radicados relacionados e inserta en la tabla RelatedRequestFiles
IF(@ConcatRequestRelated IS NOT NULL)
BEGIN
INSERT INTO ##requestrelatedApi
SELECT * FROM string_split(@ConcatRequestRelated,@SplitSep)
INSERT INTO [dbo].[RelatedRequestFiles]
([Id],[ParentId],[RequestFileId])
SELECT NEWID(),(SELECT TOP 1 [Id] FROM [dbo].[RequestFiles] WHERE [FileNumber] = [FileNumRelated]),@IdReqFile
FROM ##requestrelatedApi
END
--Se valida si tiene dependencias relacionadas e inserta en la tabla RequestFilesDependencies
IF(@ConcatDependenciesRelated IS NOT NULL)
BEGIN
INSERT INTO ##dependenciesrelatedApi
SELECT * FROM string_split(@ConcatDependenciesRelated,@SplitSep)
INSERT INTO [dbo].[RequestFileDependencies]
([Id],[RequestFileId],[DependenciesId],[UserId])
SELECT NEWID(),@IdReqFile,(SELECT TOP 1 [Id] FROM [dbo].[Dependencies] WHERE [Code] = SUBSTRING([DependRelated],1,CHARINDEX(@SplitSepInd,[DependRelated]) - 1)),
(SELECT TOP 1 [Id] FROM [dbo].[Users] WHERE [UserName] = SUBSTRING([DependRelated],CHARINDEX(@SplitSepInd,[DependRelated]) + 1,LEN([DependRelated])))
FROM ##dependenciesrelatedApi
END
END
END TRY
BEGIN CATCH
-- Execute error retrieval routine.
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION
--Se elimina el registro temporal que se pudo haber creado.
DELETE FROM [dbo].[RadicateInfo_tmp] WHERE Id = @IdRadicateTmp;
SELECT 'Error' as Result, 'Transacción anulada. Linea: ' + LTRIM(STR(ERROR_LINE())) + '. Error: ' + ERROR_MESSAGE() as 'Message';
END
END CATCH;
IF @@TRANCOUNT > 0
BEGIN
COMMIT TRANSACTION;
SELECT @RespResult = @IdReqFile
END
END |
| 2052 | DWSGDAAPP3 | | ophelia | 5/27/2026 10:01:29 AM | 12 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 SMALLINT,@_3 VARCHAR(36),@_4 VARCHAR(1),@_5 VARCHAR(11),@_6 DATETIME2(7),@_7 VARCHAR(1),@_8 VARCHAR(4),@_9 INT,@_10 VARCHAR(24))INSERT INTO WF_FPLAN (EMP_CODI,FPL_CONT,PLA_CONT,CAS_CONT,AUD_ESTA,AUD_USUA,AUD_UFAC,FPL_GUAR,PTL_CODI,PTL_VERS,PTL_REGI)
VALUES ( @ , @_1 , @_2 , @_3 , @_4 , @_5 , @_6 , @_7 , @_8 , @_9 , @_10 ) |
| 1628 | DWSGDAAPP2 | | ophelia | 5/27/2026 10:01:33 AM | 8 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(36),@_3 VARCHAR(36),@_4 INT,@_5 INT,@_6 VARCHAR(35),@_7 VARCHAR(1),@_8 DATETIME2(7),@_9 DATETIME2(7),@_10 DATETIME2(7),@_11 DATETIME2(7),@_12 FLOAT,@_13 VARCHAR(1),@_14 VARCHAR(1),@_15 VARCHAR(8),@_16 VARCHAR(8),@_17 VARCHAR(MAX),@_18 VARCHAR(1),@_19 VARCHAR(MAX),@_20 VARCHAR(1),@_21 VARCHAR(1),@_22 VARCHAR(8),@_23 DATETIME2(7),@_24 VARCHAR(1),@_25 INT,@_26 DATETIME2(7),@_27 VARCHAR(13))INSERT INTO WF_SEGUI (EMP_CODI,CAS_CONT,SEG_CONT,SEG_CONA,FLU_CONT,ETA_CONT,
SEG_SUBJ,SEG_PRIO,SEG_FREC,SEG_HREC,SEG_FLIM,SEG_HLIM,SEG_DIAE,SEG_ESTC,
SEG_ABRE,SEG_UORI,SEG_UENC,SEG_COME,SEG_ESTE,SEG_ERRO,SEG_RECO,AUD_ESTA,AUD_USUA,AUD_UFAC,SEG_ALER,SEG_INTE,SEG_FATI,SEG_IPAD)
VALUES ( @ , @_1 , @_2 , @_3 , @_4 , @_5 ,
@_6 , @_7 , @_8 , @_9 , @_10 , @_11 , @_12 , @_13 ,
@_14 , @_15 , @_16 , @_17 , @_18 , @_19 , @_20 , @_21 , @_22 , @_23 , @_24 , @_25 , @_26 , @_27 ) |
| 2035 | DWSGDAAPP2 | | ophelia | 5/27/2026 10:01:33 AM | 8 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 SMALLINT,@_3 VARCHAR(36),@_4 VARCHAR(1),@_5 VARCHAR(13),@_6 DATETIME2(7),@_7 VARCHAR(1),@_8 VARCHAR(4),@_9 INT,@_10 VARCHAR(24))INSERT INTO WF_FPLAN (EMP_CODI,FPL_CONT,PLA_CONT,CAS_CONT,AUD_ESTA,AUD_USUA,AUD_UFAC,FPL_GUAR,PTL_CODI,PTL_VERS,PTL_REGI)
VALUES ( @ , @_1 , @_2 , @_3 , @_4 , @_5 , @_6 , @_7 , @_8 , @_9 , @_10 ) |
| 2081 | DWSGDAAPP2 | | ophelia | 5/27/2026 10:01:34 AM | 7 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 INT,@_3 INT,@_4 INT,@_5 VARCHAR(36),@_6 VARCHAR(36),@_7 VARCHAR(1),@_8 VARCHAR(13),@_9 DATETIME2(7))INSERT INTO WF_IRUTA
(EMP_CODI,CAS_CONT,IRU_CONT,FLU_CONT,RUT_CONT,SEG_CONT,SEG_COND,AUD_ESTA,AUD_USUA,AUD_UFAC)
VALUES ( @ , @_1 , @_2 , @_3 , @_4 , @_5 , @_6 , @_7 , @_8 , @_9 ) |
| 1365 | DWSGDAAPP3 | | ophelia | 5/27/2026 10:01:34 AM | 7 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(4),@_3 INT)SELECT PTL_REGI FROM WF_FPLAN
WHERE EMP_CODI= @
AND CAS_CONT= @_1
AND PTL_CODI= @_2
AND PTL_VERS= @_3 |
| 2090 | DWSGDAAPP3 | | ophelia | 5/27/2026 10:01:34 AM | 7 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(4),@_3 INT)SELECT PTL_REGI FROM WF_FPLAN
WHERE EMP_CODI= @
AND CAS_CONT= @_1
AND PTL_CODI= @_2
AND PTL_VERS= @_3 |
| 1530 | DWSGDAAPP1 | | ophelia | 5/27/2026 10:01:35 AM | 6 | Read/Write | (@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL,
PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH
FROM WF_PSWET
WHERE PAR_TYPE='HEADER'
AND EMP_CODI= @
AND FLU_CONT= @_1
AND ETA_CONT= @_2 |
| 2099 | DWSGDAAPP1 | | ophelia | 5/27/2026 10:01:35 AM | 6 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(16))SELECT PTL_REGI FROM WF_FPLAN
WHERE EMP_CODI= @
AND CAS_CONT= @_1
AND PTL_CODI= @_2 |
| 1348 | DWSGDAAPP1 | | ophelia | 5/27/2026 10:01:35 AM | 6 | Read/Write | (@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(33),@_3 INT)SELECT PTL_REGI FROM WF_FPLAN
WHERE EMP_CODI= @
AND CAS_CONT= @_1
AND PTL_CODI= @_2
AND PTL_VERS= @_3 |