Project

General

Profile

Actions
Copy link

Feature #1725

closed

Work Order #1754: WO2026-19

Task 16890: Copias certificadas: replicar proceso adoptado para SUMAC de Tribunal de Primera Instancia

Added by Estefany Santiago Trinidad about 2 months ago. Updated 4 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Alejandro De Jesús Reyes
Category:
-
Target version:
OAT - TA | Bugs | Jul-2026
Start date:
06/08/2026
Due date:
% Done:

0%

Estimated time:
Actions
Copy link
 #1

Updated by Estefany Santiago Trinidad about 2 months ago

  • Description updated (diff)
  • Estimated time deleted (45:00 h)
Actions
Copy link
 #2

Updated by Estefany Santiago Trinidad about 2 months ago

  • Parent task set to #1754
Actions
Copy link
 #3

Updated by Repo Bot about 2 months ago

  • Status changed from Not Started to Pending Review
Actions
Copy link
 #4

Updated by Repo Bot about 2 months ago

Actions
Copy link
 #5

Updated by Alejandro De Jesús Reyes about 2 months ago

  • Assignee set to Alejandro De Jesús Reyes
Actions
Copy link
 #6

Updated by Repo Bot about 2 months ago

Changes requested by EBS-SEEDBURY on PR #376

Actions
Copy link
 #7

Updated by Repo Bot about 2 months ago

  • Status changed from Pending Review to Approved

Approved by EBS-SEEDBURY on PR #216 → status: Approved

Actions
Copy link
 #8

Updated by Estefany Santiago Trinidad about 2 months ago

  • Target version changed from SUMAC | Asuntos Prioridad 2 | Jun-2026 to TA | Ventana | Jun-22-2026
Actions
Copy link
 #9

Updated by Repo Bot about 1 month ago

  • Status changed from Approved to Test Internally

Merged into Development via PR #216 → status: Test Internally

Actions
Copy link
 #10

Updated by Repo Bot about 1 month ago

  • Status changed from Test Internally to Approved

Approved by EBS-SEEDBURY on PR #376 → status: Approved

Actions
Copy link
 #11

Updated by Repo Bot about 1 month ago

  • Status changed from Approved to Test Internally

Merged into Development via PR #376 → status: Test Internally

Actions
Copy link
 #12

Updated by Estefany Santiago Trinidad 13 days ago

  • Target version changed from TA | Ventana | Jun-22-2026 to TA | Asuntos | jul-2026
Actions
Copy link
 #13

Updated by Estefany Santiago Trinidad 13 days ago

  • Target version changed from TA | Asuntos | jul-2026 to TA | Bugs | Jul-2026
Actions
Copy link
 #14

Updated by Repo Bot 11 days ago

  • Status changed from Test Internally to Pending Review
Actions
Copy link
 #15

Updated by Repo Bot 11 days ago

Actions
Copy link
 #16

Updated by Edwin X Borrero 11 days ago 

INSERT INTO catalogTypes (catalogTypeCode, catalogTypeDescription)
 VALUES (72, 'certifiedCopyStatus')
 
 INSERT INTO catalogValues (catalogValueCode, catalogValueDescription, catalogTypeCode, catalogTypeDescription, isLocked)
 VALUES 
 		(891, 'Pendiente de Pago', 72, 'certifiedCopyStatus', 1),
 		(892, 'Pendiente de Exención', 72, 'certifiedCopyStatus', 1),
 		(893, 'Exención Denegada', 72, 'certifiedCopyStatus', 1),
 		(894, 'Completado', 72, 'certifiedCopyStatus', 1)
 		
 CREATE TABLE certifiedCopyDetails (
 	certifiedCopyDetailId int IDENTITY(1,1) NOT NULL,
 	certifiedCopyId int NOT NULL,
 	certifiedCopyStatusCode int NOT NULL,
 	certifiedCopyStatusDescription varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
 	certifiedCopyDeniedReason varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
 	dateCreated datetime DEFAULT getdate() NOT NULL,
	creatorId int NOT NULL,
	isDeleted bit DEFAULT 0 NOT NULL,
	deleterId int NULL,
	dateDeleted datetime NULL,
	CONSTRAINT PK__certifiedCopyDetail PRIMARY KEY (certifiedCopyDetailId),
	CONSTRAINT FK__certifiedCopyId FOREIGN KEY (certifiedCopyId) REFERENCES dbo.certifiedCopies(certifiedCopyId),
	CONSTRAINT FK__certifiedCopyStatusCode FOREIGN KEY (certifiedCopyStatusCode) REFERENCES dbo.catalogValues(catalogValueCode),
	CONSTRAINT FK__certifiedCopy_creator FOREIGN KEY (creatorId) REFERENCES dbo.persons(personId),
	CONSTRAINT FK__certifiedCopy_deleter FOREIGN KEY (deleterId) REFERENCES dbo.persons(personId)
 )
 
 CREATE TABLE documents (
 	documentId int IDENTITY(1,1) NOT NULL,
 	dateCreated datetime DEFAULT getdate() NOT NULL,
	creatorId int NOT NULL,
	isDeleted bit DEFAULT 0 NOT NULL,
	deleterId int NULL,
	dateDeleted datetime NULL,
	encoding1 uniqueidentifier DEFAULT newid() NOT NULL,
	encoding2 uniqueidentifier DEFAULT newid() NOT NULL,
	CONSTRAINT PK__documentId PRIMARY KEY (documentId),
	CONSTRAINT FK__documents_creator FOREIGN KEY (creatorId) REFERENCES dbo.persons(personId),
	CONSTRAINT FK__documents_deleter FOREIGN KEY (deleterId) REFERENCES dbo.persons(personId),
	CONSTRAINT documents_unique UNIQUE (encoding1),
	CONSTRAINT documents_unique_1 UNIQUE (encoding2)
 )
 
 CREATE TABLE documentDetails (
 	documentDetailId int IDENTITY(1,1) NOT NULL,
 	documentId int NOT NULL,
 	documentRoleCode int NOT NULL,
	documentRoleDescription varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
	documentTypeCode int NOT NULL,
	documentTypeDescription varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
	description varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
	url varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
	fileExtension varchar(5) COLLATE Modern_Spanish_CI_AS NULL,
	fileName varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
	hash varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
	isConfidential bit DEFAULT 0 NOT NULL,
	orderPosition int NULL,
	fileSize int NULL,
	filePageCount int NULL,
 	dateCreated datetime DEFAULT getdate() NOT NULL,
	creatorId int NOT NULL,
	isDeleted bit DEFAULT 0 NOT NULL,
	deleterId int NULL,
	dateDeleted datetime NULL,
	CONSTRAINT PK__documentDetailId PRIMARY KEY (documentDetailId),
	CONSTRAINT FK__document_details_documentId FOREIGN KEY (documentId) REFERENCES dbo.documents(documentId),
	CONSTRAINT FK__document_details_role FOREIGN KEY (documentRoleCode) REFERENCES dbo.catalogValues(catalogValueCode),
	CONSTRAINT FK__document_details_type FOREIGN KEY (documentTypeCode) REFERENCES dbo.catalogValues(catalogValueCode),
	CONSTRAINT FK__document_details_creator FOREIGN KEY (creatorId) REFERENCES dbo.persons(personId),
	CONSTRAINT FK__document_details_deleter FOREIGN KEY (deleterId) REFERENCES dbo.persons(personId),
 )
 
 CREATE TABLE certifiedCopyExemptionDocument (
 	certifiedCopyExemptionDocumentId int IDENTITY(1,1) NOT NULL,
 	certifiedCopyId int NOT NULL,
 	documentId int NOT NULL,
 	dateCreated dateTime DEFAULT getdate() NOT NULL,
 	creatorId int NOT NULL,
 	isDeleted bit DEFAULT 0 NOT NULL,
 	CONSTRAINT PK__certifiedCopyExemptionDocumentId PRIMARY KEY (certifiedCopyExemptionDocumentId)
 	CONSTRAINT FK__certifiedCopyExemptionDocument_certifiedCopyId FOREIGN KEY (certifiedCopyId) REFERENCES dbo.certifiedCopies(certifiedCopyId),
 	CONSTRAINT FK__certifiedCopyExemptionDocument_documentId FOREIGN KEY (documentId) REFERENCES dbo.documents(documentId),
 	CONSTRAINT FK__certifiedCopyExemptionDocument_creatorId FOREIGN KEY (creatorId) REFERENCES dbo.persons(personId)
 )
Actions
Copy link
 #17

Updated by Alejandro De Jesús Reyes 10 days ago

Fix syntax errors

INSERT INTO catalogTypes
	(catalogTypeCode, catalogTypeDescription)
VALUES
	(72, 'certifiedCopyStatus')

INSERT INTO catalogValues
	(catalogValueCode, catalogValueDescription, catalogTypeCode, catalogTypeDescription, isLocked)
VALUES
	(891, 'Pendiente de Pago', 72, 'certifiedCopyStatus', 1),
	(892, 'Pendiente de Exención', 72, 'certifiedCopyStatus', 1),
	(893, 'Exención Denegada', 72, 'certifiedCopyStatus', 1),
	(894, 'Completado', 72, 'certifiedCopyStatus', 1)

CREATE TABLE certifiedCopyDetails
(
	certifiedCopyDetailId int IDENTITY(1,1) NOT NULL,
	certifiedCopyId int NOT NULL,
	certifiedCopyStatusCode int NOT NULL,
	certifiedCopyStatusDescription varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
	certifiedCopyDeniedReason varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
	dateCreated datetime DEFAULT getdate() NOT NULL,
	creatorId int NOT NULL,
	isDeleted bit DEFAULT 0 NOT NULL,
	deleterId int NULL,
	dateDeleted datetime NULL,
	CONSTRAINT PK__certifiedCopyDetail PRIMARY KEY (certifiedCopyDetailId),
	CONSTRAINT FK__certifiedCopyId FOREIGN KEY (certifiedCopyId) REFERENCES dbo.certifiedCopies(certifiedCopyId),
	CONSTRAINT FK__certifiedCopyStatusCode FOREIGN KEY (certifiedCopyStatusCode) REFERENCES dbo.catalogValues(catalogValueCode),
	CONSTRAINT FK__certifiedCopy_creator FOREIGN KEY (creatorId) REFERENCES dbo.persons(personId),
	CONSTRAINT FK__certifiedCopy_deleter FOREIGN KEY (deleterId) REFERENCES dbo.persons(personId)
)

CREATE TABLE documents
(
	documentId int IDENTITY(1,1) NOT NULL,
	dateCreated datetime DEFAULT getdate() NOT NULL,
	creatorId int NOT NULL,
	isDeleted bit DEFAULT 0 NOT NULL,
	deleterId int NULL,
	dateDeleted datetime NULL,
	encoding1 uniqueidentifier DEFAULT newid() NOT NULL,
	encoding2 uniqueidentifier DEFAULT newid() NOT NULL,
	CONSTRAINT PK__documentId PRIMARY KEY (documentId),
	CONSTRAINT FK__documents_creator FOREIGN KEY (creatorId) REFERENCES dbo.persons(personId),
	CONSTRAINT FK__documents_deleter FOREIGN KEY (deleterId) REFERENCES dbo.persons(personId),
	CONSTRAINT documents_unique UNIQUE (encoding1),
	CONSTRAINT documents_unique_1 UNIQUE (encoding2)
)

CREATE TABLE documentDetails
(
	documentDetailId int IDENTITY(1,1) NOT NULL,
	documentId int NOT NULL,
	documentRoleCode int NOT NULL,
	documentRoleDescription varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
	documentTypeCode int NOT NULL,
	documentTypeDescription varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
	description varchar(250) COLLATE Modern_Spanish_CI_AS NOT NULL,
	url varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
	fileExtension varchar(5) COLLATE Modern_Spanish_CI_AS NULL,
	fileName varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
	hash varchar(250) COLLATE Modern_Spanish_CI_AS NULL,
	isConfidential bit DEFAULT 0 NOT NULL,
	orderPosition int NULL,
	fileSize int NULL,
	filePageCount int NULL,
	dateCreated datetime DEFAULT getdate() NOT NULL,
	creatorId int NOT NULL,
	isDeleted bit DEFAULT 0 NOT NULL,
	deleterId int NULL,
	dateDeleted datetime NULL,
	CONSTRAINT PK__documentDetailId PRIMARY KEY (documentDetailId),
	CONSTRAINT FK__document_details_documentId FOREIGN KEY (documentId) REFERENCES dbo.documents(documentId),
	CONSTRAINT FK__document_details_role FOREIGN KEY (documentRoleCode) REFERENCES dbo.catalogValues(catalogValueCode),
	CONSTRAINT FK__document_details_type FOREIGN KEY (documentTypeCode) REFERENCES dbo.catalogValues(catalogValueCode),
	CONSTRAINT FK__document_details_creator FOREIGN KEY (creatorId) REFERENCES dbo.persons(personId),
	CONSTRAINT FK__document_details_deleter FOREIGN KEY (deleterId) REFERENCES dbo.persons(personId)
)

CREATE TABLE certifiedCopyExemptionDocument
(
	certifiedCopyExemptionDocumentId int IDENTITY(1,1) NOT NULL,
	certifiedCopyId int NOT NULL,
	documentId int NOT NULL,
	dateCreated dateTime DEFAULT getdate() NOT NULL,
	creatorId int NOT NULL,
	isDeleted bit DEFAULT 0 NOT NULL,
	CONSTRAINT PK__certifiedCopyExemptionDocumentId PRIMARY KEY (certifiedCopyExemptionDocumentId),
	CONSTRAINT FK__certifiedCopyExemptionDocument_certifiedCopyId FOREIGN KEY
	(certifiedCopyId) REFERENCES dbo.certifiedCopies
	(certifiedCopyId),
 	CONSTRAINT FK__certifiedCopyExemptionDocument_documentId FOREIGN KEY
	(documentId) REFERENCES dbo.documents
	(documentId),
 	CONSTRAINT FK__certifiedCopyExemptionDocument_creatorId FOREIGN KEY
	(creatorId) REFERENCES dbo.persons
	(personId)
 )
Actions
Copy link
 #18

Updated by Repo Bot 10 days ago

  • Status changed from Pending Review to Approved

Approved by EVP-Seedbury on PR #381 → status: Approved

Actions
Copy link
 #19

Updated by Alejandro De Jesús Reyes 10 days ago

Alejandro De Jesús Reyes wrote in #note-17:

Fix syntax errors

Fixed*

Actions
Copy link
 #20

Updated by Repo Bot 10 days ago

  • Status changed from Approved to Test Internally

Merged into Development via PR #381 → status: Test Internally

Actions
Copy link
 #21

Updated by Repo Bot 10 days ago

  • Status changed from Test Internally to Approved

Approved by adr-seedbury on PR #224 → status: Approved

Actions
Copy link
 #22

Updated by Repo Bot 10 days ago

  • Status changed from Approved to Test Internally

Merged into Development via PR #224 → status: Test Internally

Actions
Copy link
 #23

Updated by Estefany Santiago Trinidad 4 days ago

  • Status changed from Test Internally to Closed
Actions
Copy link

Also available in: Atom PDF