url.EID = decrypt(#url.EID#, "54kczhzgHTj4a8n+SRZPyg==", "AES", "Hex");
SELECT Emp_ID, Emp_Last AS Last_Name, Emp_First AS First_Name
FROM #Request.prefix_db_lookup#.pEmployee
WHERE Emp_ID = '#session.cs.employeeid#'
AND Loc_ID = #session.AgencyID#
SELECT * FROM #Request.prefix_db_agency#.Employee_Files
WHERE idEmployee_Files =
AND AgencyId =
AND Emp_ID =
DELETE FROM #Request.prefix_db_agency#.Employee_Files
WHERE idEmployee_Files =
AND AgencyId =
AND Emp_ID =
INSERT IGNORE INTO #Request.prefix_db_agency#.Employee_Files (
AgencyId, Emp_ID, Title, FileName, FileType, Dup_file_name ,CreatedBy
,DOC_ID,Expiration_Date
) VALUES (
'#session.AgencyId#'
,'#url.EID#'
,'#form.ufTitle#'
,'#File.ServerFile#'
,'#File.ContentType#/#File.ContentSubType#'
,'#Duplicate_file_name#'
,'#session.AgencyId#'
,#form.document_name#,#CreateODBCDate(form.Expiration_Date)#
)
SELECT *
FROM #Request.prefix_db_agency#.DocumentDesc
WHERE DocumentType like '%Employee%'
ORDER BY DOC_ID