SELECT Assmt_ID, pAssessments.Admit_ID, F25, F26,F27, F34, F81, F37, F38, F47,F49,F240, F82, F138, F83, F139,
F73, F72, F140, F143,F177 AS Certification_Start, F178 AS Certification_End,pAdmit.M0030_START_CARE_DT,
F223,F296,F297,F298,F299,F300,pAssessments.Record_Created_By,F40, pAdmit.M1100_PTNT_LVG_STUTN, pAdmit.problem_Intake,
pAdmit.Caregiver_commitment, pAdmit.Caregiver_competency
FROM #Request.prefix_db_agency#.pAssessments
JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status = 0
WHERE pAssessments.Patient_ID = '#session.cs.patientid#'
AND pAssessments.Assmt_ID IS NOT NULL
AND pAssessments.Admit_ID NOT IN (SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit
WHERE pAdmit.Patient_ID =
ANd pAdmit.status = 1 )
AND pAssessments.status = 0
AND Assmt_ID =
GROUP BY pAssessments.F27, Assmt_ID
ORDER BY pAssessments.F177 DESC
SELECT * FROM getallassesments
WHERE (F26 like '1%' or F26 like '4%')
ORDER BY M0030_START_CARE_DT DESC, Certification_Start DESC
SELECT pPayer.M0150
FROM #Request.prefix_db_agency#.pPtPayer pPtPayer
JOIN #Request.prefix_db_agency#.pPayer pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID
WHERE pPtPayer.Patient_ID =
AND pPtPayer.status = 0
AND pPayer.status = 0
AND (pPayer.M0150 LIKE '1%' OR pPayer.M0150 LIKE '2%')
LIMIT 1
SELECT pPayer.Output
FROM #Request.prefix_db_agency#.pPtPayer pPtPayer
JOIN #Request.prefix_db_agency#.pPayer pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID
WHERE pPtPayer.Patient_ID =
AND pPtPayer.status = 0
AND pPayer.status = 0
AND pPayer.Output = 'Medicare'
LIMIT 1
SELECT *
FROM #Request.prefix_db_lookup#.casmix_lookup
WHERE HIPPS_Code =
LIMIT 1
SELECT *
FROM #Request.prefix_db_lookup#.casmix_lookup
WHERE HIPPS_Code =
LIMIT 1