HRM-10/db/Script/TaxParameterEssDeadline_DB_Changes.sql
Mohaimen Hasan 838b8d4480 first commit
2026-11-03 13:06:00 +06:00

21 lines
843 B
Transact-SQL

-- =============================================================
-- TaxParameter: ESS permission deadlines
-- Adds a nullable deadline for the Investment, AIT and Tax Return
-- ESS permissions on the Tax Rule Parameterization page.
-- Re-runnable (guarded).
-- Run this BEFORE deploying the matching code: the app reads these
-- columns on every TaxParameter load.
-- =============================================================
IF COL_LENGTH('TaxParameter', 'InvestmentSubmitDeadline') IS NULL
ALTER TABLE TaxParameter ADD InvestmentSubmitDeadline DATETIME NULL;
GO
IF COL_LENGTH('TaxParameter', 'AITSubmitDeadline') IS NULL
ALTER TABLE TaxParameter ADD AITSubmitDeadline DATETIME NULL;
GO
IF COL_LENGTH('TaxParameter', 'TaxReturnSubmitDeadline') IS NULL
ALTER TABLE TaxParameter ADD TaxReturnSubmitDeadline DATETIME NULL;
GO