Project

General

Profile

Actions
Copy link

Bug #1221

closed

Task 21121: Duplicidad de la Sociedad para la Asistencia Legal en la lista de entidades exentas

Added by Estefany Santiago Trinidad 18 days ago. Updated 5 days ago.

Status:
Closed
Priority:
Normal
Assignee:
John A Cruz Merced
Category:
-
Target version:
OAT - TA | Bugs | Enero 2026
Start date:
01/14/2026
Due date:
% Done:

0%

Estimated time:

Files

Download all files
clipboard-202601151020-l2ksf.png (143 KB) clipboard-202601151020-l2ksf.png John A Cruz Merced, 01/15/2026 02:20 PM
clipboard-202601211527-bvvvf.png (432 KB) clipboard-202601211527-bvvvf.png John A Cruz Merced, 01/21/2026 07:27 PM
Actions
Copy link
 #1

Updated by John A Cruz Merced 18 days ago

  • Status changed from Not Started to In Progress
  • Assignee set to John A Cruz Merced
Actions
Copy link
 #2

Updated by John A Cruz Merced 18 days ago

Existen dos catalogos de Sociedad para la Asistencia Legal de tipo 45 (courfeeExemptionReason).

`` delete new catalog
UPDATE catalogValues
SET isDeleted = 0,
	dateDeleted = GETDATE()
WHERE catalogValueCode = 546;

-- update courtfee participants
UPDATE courtFeeParticipants
SET exemptionReasonCode = 308,
	exemptionReasonDescription = dbo.getCatalogValueDescription(308)
WHERE exemptionReasonCode = 546;

Se borra el más reciente.

  • Solo requiere correr esos sql statements para resolver asunto *
Actions
Copy link
 #3

Updated by John A Cruz Merced 18 days ago

  • Status changed from In Progress to Test Internally
Actions
Copy link
 #4

Updated by Estefany Santiago Trinidad 12 days ago

  • Status changed from Test Internally to OAT: Not Passed

Sigue saliendo duplicado

Actions
Copy link
 #5

Updated by John A Cruz Merced 12 days ago 


-- delete catalog
UPDATE catalogValues
SET isDeleted = 1,
	dateDeleted = GETDATE()
WHERE catalogValueCode = 308;

-- update entries with wrong catalog
UPDATE courtFeeParticipants
SET exemptionReasonCode = 546,
	exemptionReasonDescription = dbo.getCatalogValueDescription(546)
WHERE exemptionReasonCode = 308;
Actions
Copy link
 #6

Updated by John A Cruz Merced 12 days ago

  • Status changed from OAT: Not Passed to Test Internally
Actions
Copy link
 #7

Updated by John A Cruz Merced 12 days ago

Se borró el que no dice SAL por petición de la OAT (ver devops).

Actions
Copy link
 #9

Updated by Estefany Santiago Trinidad 5 days ago

  • Status changed from Test Internally to Closed
Actions
Copy link

Also available in: Atom PDF