charEncoding="windows-1252"
chardecode=CharsetDecode(arguments.Notes, charEncoding);
charencode=CharsetEncode(chardecode, charEncoding);
UPDATE #Request.prefix_db_agency#.Eligibility
SET
Verification_Date = ,
Start_Date = ,
Expiration_Date = ,
Notes = ,
Date_Change = ,
Change_by = ,
status =
WHERE
Elig_ID =
INSERT INTO #Request.prefix_db_agency#.Eligibility (Patient_ID, PtPayer_ID,
Verification_Date, Start_Date, Expiration_Date, Notes,Date_Create,Created_by,
Date_Change,Change_by,status)
VALUES
(,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.Eligibility SET
Status = ,
Date_Change = ,
Change_by =
WHERE Elig_ID =
SELECT * FROM #Request.prefix_db_agency#.Eligibility WHERE Elig_ID =
SELECT pPtPayer.*,pPayer.* FROM #Request.prefix_db_agency#.pPtPayer
JOIN #Request.prefix_db_agency#.pPayer on pPtPayer.Payer_ID = pPayer.Pay_ID
WHERE pPtPayer.Status = 0
AND pPtPayer.PtPayer_ID = '#ptPayer_ID#'
SELECT * FROM #Request.prefix_db_agency#.Eligibility
WHERE Patient_ID = #session.cs.patientid#
AND PtPayer_ID = '#ptPayer_ID#'
AND Start_Date >= '#Dateformat(arguments.Date_Start,"yyyy-mm-dd")#'
AND Start_Date <= '#Dateformat(arguments.Date_End,"yyyy-mm-dd")#'
AND Start_Date IS NOT NULL
AND Status = 0
SELECT Detail_ID, Status, approved
FROM #Request.prefix_db_agency#.Eligibility_Detail
WHERE Detail_ID =
UPDATE #Request.prefix_db_agency#.Eligibility_Detail
SET approved =
WHERE Detail_ID =
AND Status = 0
- #cfcatch.detail#' />