url.id=decrypt(#url.id#,#application.enckey#,"AES","Hex"); UPDATE #Request.prefix_db_agency#.CommunicationSubjects SET active = 'N' WHERE CommSub_Id = '#url.id#' AND Agency_Id = '#session.AgencyId#'

The Communication Subject has been De-Activated

UPDATE #Request.prefix_db_agency#.CommunicationSubjects SET active = 'Y' WHERE CommSub_Id = '#url.id#' AND Agency_Id = '#session.AgencyId#'

The Communication Subject has been Re-Activated

SELECT CommSub_Id, Subject FROM #Request.prefix_db_agency#.CommunicationSubjects WHERE Agency_Id = '#session.AgencyId#' AND active = 'Y' ORDER BY Subject

Communication Subjects

New Communication Subject Back

Active Communication Subjects

Subject	Action
Encrypted_CommSub_ID=encrypt(#getCommSub.CommSub_ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); #Subject# #Subject#

SELECT CommSub_Id, Subject FROM #Request.prefix_db_agency#.CommunicationSubjects WHERE Agency_Id = '#session.AgencyId#' AND active = 'N' ORDER BY Subject

De-activated Communication Subjects

Subject	Action
#Subject#	Encrypted_Gcs_CommSub_ID=encrypt(#gcs.CommSub_ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex");