select *
from #Request.prefix_db_agency#.Assessment_New
where Assessment_ID = #url.AID#
select *
from #Request.prefix_db_agency#.patient
where Patient_ID = #url.ID#
select *
from #Request.prefix_db_agency#.Coding_Results
where Assessment_ID = #url.AID#
and M0_Item_Medication = '(M1021)'
select *
from #Request.prefix_db_agency#.Coding_Results
where Assessment_ID = #url.AID#
and M0_Item_Medication = '(M1023)'
Order by Dx_Order
select *
from #Request.prefix_db_agency#.Coding_Results
where Assessment_ID = #url.AID#
and (M0_Item_Medication = 'OASIS')
Order by Results_ID
-------------
' &
'PRIMARY DIAGNOSIS admission notes: ' & '
' &
'F2F: ' & '#Get_CR_1.Diagnosis#' & '
' & '#Get_CR_1.OASIS#' & '
comments:'>
-------------
' &
'PRIMARY DIAGNOSIS admission notes: ' & '
' &
'F2F: ' & '#Get_CR_1.Diagnosis#' & '
comments:'>
-------------
' &
'#Get_CR_2.Dx_Order#' & ' Diagnosis admission notes: ' & '
' &
'H&P: ' & '#Get_CR_2.Diagnosis#' & '
' & '#Get_CR_2.OASIS#' & '
comments:'>
-------------
' &
'#Get_CR_2.Dx_Order#' & ' Diagnosis admission notes: ' & '
' &
'H&P: ' & '#Get_CR_2.Diagnosis#' & '
comments:'>
-------------
' &
'OASIS ORPHAN: ' & '#Get_CR_3.Diagnosis#' & '
' & '#Get_CR_3.OASIS#' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M0110 Episode timing is reported as an 1-Early. As a 4-Recertification it should be reported as 2-Later' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M0110 Episode timing is reported as an 1-Early. If this resumption is after the first recertification it should be reported as 2-Later' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1033 contains 5 - Decline in mental/emotional/behavioral but M1700 Cognition reports Alert and Oriented' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1033 contains 5 - Decline in mental/emotional/behavioral but M1710 Confusion reports Never Confused' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1033 contains 5 - Decline in mental/emotional/behavioral but M01740 reports No Problems Demonstrated' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1033 contains 6 - Difficulty complying with medical instructions... but M1700 Cognition reports Alert and Oriented' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1033 contains 6 - Difficulty complying with medical instructions... but M1710 Confusion reports Never Confused' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1033 contains 6 - Difficulty complying with medical instructions... but M01740 reports No Problems Demonstrated' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1200 reports severe vision deficit but patient is independent in one or more ADLs: M1800-M1870, M2020, M2030' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1242 reports severe pain but patient is independent in one or more ADLs: M1800-M1870' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1400 reports severe shortness of breath but patient is independent in one or more ADLs: M1800-M1870' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1700 reports severe cognitive deficit but patient is independent in one or more ADLs: M1800-M1870, M2020, M2030' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1710 reports severe confusion but patient is independent in one or more ADLs: M1800-M1870, M2020, M2030' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1740 reports cognitive, behavioral and/or psych issues but patient is independent in one or more ADLs: M1800-M1870, M2020, M2030' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1740 reports weekly cognitive, behavioral and/or psych issues but M1745 Frequency of Behavior Problems is less than weekly' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M1910 - no Fall Risk Assessment performed' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M2102f reports no supervision or assistance needed but patient has M1200 severe vision deficit OR M1242 severe pain OR M1400 severe SOB OR M17XX significant cognitive/behavioral deficits ' & '
comments:'>
-------------
' &
'OASIS INCONSISTENCY: ' & 'M2102f reports no supervision or assistance available but M1100 reports assistance available' & '
comments:'>
-------------
'>
' & 'M1800 GROOMING: INDEPENDENT (' & '#Get_OASIS.Grooming_M0640#' & ')' & '
comments:'>
!!GG0130B1: CHANGE TO 06'>
' & 'M1800 GROOMING: MODIFIED INDEPENDENT (' & '#Get_OASIS.Grooming_M0640#' & ')' & '
comments:'>
!!GG0130B1: CHANGE TO 05'>
' & 'M1800 GROOMING: SUPERVISION OR standby assist OR contact guard OR minimum OR mod OR max assist (' & '#Get_OASIS.Grooming_M0640#' & ')' & '
comments:'>
!!GG0130B1: CHANGE TO 02, 03 OR 04'>
' & 'M1800 GROOMING: DEPENDENT (' & '#Get_OASIS.Grooming_M0640#' & ')' & '
comments:'>
!!GG0130B1: CHANGE TO 01'>
OT Evaluation Upper Body Dressing: ' & '
' & 'M1810 UPPER BODY DRESSING: INDEPENDENT (' & '#Get_OASIS.Dress_Upper_M0650#' & ')' & '
comments:'>
!!GG0130F1: CHANGE TO 06'>
OT Evaluation Upper Body Dressing: ' & '
' & 'M1810 UPPER BODY DRESSING: MODIFIED INDEPENDENT OR supervision OR standby assist OR contact guard (' & '#Get_OASIS.Dress_Upper_M0650#' & ')' & '
comments:'>
!!GG0130F1: CHANGE TO 05'>
OT Evaluation Upper Body Dressing: ' & '
' & 'M1810 UPPER BODY DRESSING: MINIMUM OR mod OR max assist (' & '#Get_OASIS.Dress_Upper_M0650#' & ')' & '
comments:'>
!!GG0130F1: CHANGE TO 02, 03 OR 04'>
OT Evaluation Upper Body Dressing: ' & '
' & 'M1810 UPPER BODY DRESSING: DEPENDENT (' & '#Get_OASIS.Dress_Upper_M0650#' & ')' & '
comments:'>
!!GG0130F1: CHANGE TO 01'>
OT Evaluation Lower Body Dressing: ' & '
' & 'M1820 LOWER BODY DRESSING: INDEPENDENT (' & '#Get_OASIS.Dress_Lower_M0660#' & ')' & '
comments:'>
!!GG0130G1: CHANGE TO 06'>
!!GG0130H1: CHANGE TO 06'>
OT Evaluation Lower Body Dressing: ' & '
' & 'M1820 LOWER BODY DRESSING: MODIFIED INDEPENDENT OR supervision OR standby assist OR contact guard (' & '#Get_OASIS.Dress_Lower_M0660#' & ')' & '
comments:'>
!!GG0130G1: CHANGE TO 05'>
!!GG0130H1: CHANGE TO 05'>
OT Evaluation Lower Body Dressing: ' & '
' & 'M1820 LOWER BODY DRESSING: MINIMUM OR mod OR max assist (' & '#Get_OASIS.Dress_Lower_M0660#' & ')' & '
comments:'>
!!GG0130G1: CHANGE TO 02, 03 OR 04'>
!!GG0130H1: CHANGE TO 02, 03 OR 04'>
OT Evaluation Lower Body Dressing: ' & '
' & 'M1820 LOWER BODY DRESSING: DEPENDENT (' & '#Get_OASIS.Dress_Lower_M0660#' & ')' & '
comments:'>
!!GG0130G1: CHANGE TO 01'>
!!GG0130H1: CHANGE TO 01'>
OT Evaluation Bathing: ' & '
' & 'M1830 BATHING: INDEPENDENT (' & '#Get_OASIS.Bathing_M0670#' & ')' & '
comments:'>
!!GG0130E1: CHANGE TO 06'>
OT Evaluation Bathing: ' & '
' & 'M1830 BATHING NOT CHAIR/BEDBOUND: MODIFIED INDEPENDENT (' & '#Get_OASIS.Bathing_M0670#' & ')' & '
comments:'>
!!GG0130E1: CHANGE TO 05'>
OT Evaluation Bathing: ' & '
' & 'M1830 BATHING NOT CHAIR/BEDBOUND: SUPERVISION OR standby assist OR contact guard or min assist OR mod assist OR max assist (' & '#Get_OASIS.Bathing_M0670#' & ')' & '
comments:'>
!!GG0130E1: CHANGE TO 02, 03 OR 04'>
OT Evaluation Bathing: ' & '
' & 'M1830 BATHING NOT CHAIR/BEDBOUND: SUPERVISION OR standby assist OR contact guard or min assist OR mod assist OR max assist (' & '#Get_OASIS.Bathing_M0670#' & ')' & '
comments:'>
!!GG0130E1: CHANGE TO 02, 03 OR 04'>
OT Evaluation Bathing: ' & '
' & 'M1830 BATHING NOT CHAIR/BEDBOUND: MODIFIED INDEPENDENT (' & '#Get_OASIS.Bathing_M0670#' & ')' & '
comments:'>
!!GG0130E1: CHANGE TO 02, 03 OR 04'>
OT Evaluation Bathing: ' & '
' & 'M1830 BATHING CHAIR/BEDBOUND: SUPERVISION OR standby assist OR contact guard or min assist OR mod assist OR max assist (' & '#Get_OASIS.Bathing_M0670#' & ')' & '
comments:'>
!!GG0130E1: CHANGE TO 02, 03 OR 04'>
OT Evaluation Bathing: ' & '
' & 'M1830 BATHING: DEPENDENT (' & '#Get_OASIS.Bathing_M0670#' & ')' & '
comments:'>
!!GG0130E1: CHANGE TO 01'>
OT Evaluation Toileting: ' & '
' & 'M1845 TOILETING HYGIENE: INDEPENDENT (' & '#Get_OASIS.M1845_Toilet#' & ')' & '
comments:'>
!!GG0130C1: CHANGE TO 06'>
OT Evaluation Toileting: ' & '
' & 'M1845 TOILETING HYGIENE: MODIFIED INDEPENDENT OR supervision OR standby assist OR contact guard (' & '#Get_OASIS.M1845_Toilet#' & ')' & '
comments:'>
!!GG0130C1: CHANGE TO 05'>
OT Evaluation Toileting: ' & '
' & 'M1845 TOILETING HYGIENE: MINIMUM OR mod OR max assist (' & '#Get_OASIS.M1845_Toilet#' & ')' & '
comments:'>
!!GG0130C1: CHANGE TO 02, 03 OR 04'>
OT Evaluation Toileting: ' & '
' & 'M1845 TOILETING HYGIENE: DEPENDENT (' & '#Get_OASIS.M1845_Toilet#' & ')' & '
comments:'>
!!GG0130C1: CHANGE TO 01'>
OT Evaluation Feeding/Eating: ' & '
' & 'M1870 FEEDING/EATING: INDEPENDENT (' & '#Get_OASIS.Eating_M0710#' & ')' & '
comments:'>
!!GG0130A1: CHANGE TO 06'>
OT Evaluation Feeding/Eating: ' & '
' & 'M1870 FEEDING/EATING: MODIFIED INDEPENDENT OR supervision OR standby assist OR contact guard OR min assist OR mod assist (' & '#Get_OASIS.Eating_M0710#' & ')' & '
comments:'>
!!GG0130A1: CHANGE TO 03, 04 OR 05'>
OT Evaluation Feeding/Eating: ' & '
' & 'M1870 FEEDING/EATING: MAX ASSIST OR dependent (' & '#Get_OASIS.Eating_M0710#' & ')' & '
comments:'>
!!GG0130A1: CHANGE TO 01 or 02'>
OT Evaluation Feeding/Eating: ' & '
' & 'M1870 FEEDING/EATING: NG OR GASTROSTOMY (' & '#Get_OASIS.Eating_M0710#' & ')' & '
comments:'>
!!GG0130A1: CHANGE TO 09 or 88'>
OT Evaluation Oral Med Mgmt: ' & '
' & 'M2020 ORAL MED MGMT: INDEPENDENT (' & '#Get_OASIS.Oral_Meds_M0780#' & ')' & '
comments:'>
OT Evaluation Oral Med Mgmt: ' & '
' & 'M2020 ORAL MED MGMT: MODIFIED INDEPENDENT (' & '#Get_OASIS.Oral_Meds_M0780#' & ')' & '
comments:'>
OT Evaluation Oral Med Mgmt: ' & '
' & 'M2020 ORAL MED MGMT: SUPERVISION OR standby assist OR contact guard or min assist OR mod assist (' & '#Get_OASIS.Oral_Meds_M0780#' & ')' & '
comments:'>
OT Evaluation Oral Med Mgmt: ' & '
' & 'M2020 ORAL MED MGMT: MAX ASSIST OR dependent (' & '#Get_OASIS.Oral_Meds_M0780#' & ')' & '
comments:'>
OT Evaluation Oral Med Mgmt: ' & '
' & 'M2020 ORAL MED MGMT: NO MEDS (' & '#Get_OASIS.Oral_Meds_M0780#' & ')' & '
comments:'>
-------------'>
PT Evaluation Toilet Transferring: ' & '
' & 'M1840 TOILET TRANSFERRING: INDEPENDENT (' & '#Get_OASIS.M1840_Toilet#' & ')' & '
comments:'>
!!GG0170F1: CHANGE TO 06'>
PT Evaluation Toilet Transferring: ' & '
' & 'M1840 TOILET TRANSFERRING: MODIFIED INDEPENDENT OR supervision OR standby assist OR contact guard or min or mod assist (' & '#Get_OASIS.M1840_Toilet#' & ')' & '
comments:'>
!!GG0170F1: CHANGE TO 04 OR 05'>
PT Evaluation Toilet Transferring: ' & '
' & 'M1840 TOILET TRANSFERRING: MODIFIED INDEPENDENT OR supervision OR standby assist OR contact guard or min or mod assist (' & '#Get_OASIS.M1840_Toilet#' & ')' & '
comments:'>
!!GG0170F1: CHANGE TO 02 or 03'>
PT Evaluation Toilet Transferring: ' & '
' & 'M1840 TOILET TRANSFERRING: MAX ASSIST OR dependent (' & '#Get_OASIS.M1840_Toilet#' & ')' & '
comments:'>
!!GG0170F1: CHANGE TO 01'>
PT Evaluation Transferring: ' & '
' & 'M1850 TRANSFERRING: INDEPENDENT (' & '#Get_OASIS.Transferring_M0690#' & ')' & '
comments:'>
!!GG0170A1: CHANGE TO 06'>
!!GG0170B1: CHANGE TO 06'>
!!GG0170C1: CHANGE TO 06'>
!!GG0170D1: CHANGE TO 06'>
!!GG0170E1: CHANGE TO 06'>
!!GG0170G1: CHANGE TO 06'>
PT Evaluation Transferring: ' & '
' & 'M1850 TRANSFERRING: MODIFIED INDEPENDENT or supervision OR standby assist OR contact guard or min assist (' & '#Get_OASIS.Transferring_M0690#' & ')' & '
comments:'>
PT Evaluation Transferring: ' & '
' & 'M1850 TRANSFERRING: MOD ASSIST OR max assist (' & '#Get_OASIS.Transferring_M0690#' & ')' & '
comments:'>
PT Evaluation Transferring: ' & '
' & 'M1850 TRANSFERRING: DEPENDENT (' & '#Get_OASIS.Transferring_M0690#' & ')' & '
comments:'>
PT Evaluation Transferring: ' & '
' & 'M1850 BED MOBILITY TRANSFERRING: INDEPENDENT (' & '#Get_OASIS.Transferring_M0690#' & ')' & '
comments:'>
PT Evaluation Transferring: ' & '
' & 'M1850 BED MOBILITY TRANSFERRING: DEPENDENT (' & '#Get_OASIS.Transferring_M0690#' & ')' & '
comments:'>
PT Evaluation Ambulation/Locomotion: ' & '
' & 'M1860 AMBULATION/LOCOMOTION: INDEPENDENT (' & '#Get_OASIS.Ambulation_M0700#' & ')' & '
comments:'>
PT Evaluation Ambulation/Locomotion: ' & '
' & 'M1860 AMBULATION/LOCOMOTION: MODIFIED INDEPENDENT (' & '#Get_OASIS.Ambulation_M0700#' & ')' & '
comments:'>
PT Evaluation Ambulation/Locomotion: ' & '
' & 'M1860 AMBULATION/LOCOMOTION: MODIFIED INDEPENDENT OR supervision OR standby assist OR contact guard or min assist (' & '#Get_OASIS.Ambulation_M0700#' & ')' & '
comments:'>
PT Evaluation Ambulation/Locomotion: ' & '
' & 'M1860 AMBULATION/LOCOMOTION: MAX ASSIST OR dependent (' & '#Get_OASIS.Ambulation_M0700#' & ')' & '
comments:'>
PT Evaluation Ambulation/Locomotion: ' & '
' & 'M1860 WHEELECHAIR LOCOMOTION: INDEPENDENT (' & '#Get_OASIS.Ambulation_M0700#' & ')' & '
comments:'>
PT Evaluation Ambulation/Locomotion: ' & '
' & 'M1860 WHEELECHAIR LOCOMOTION: INDEPENDENT (' & '#Get_OASIS.Ambulation_M0700#' & ')' & '
comments:'>
PT Evaluation Ambulation/Locomotion: ' & '
' & 'M1860 WHEELECHAIR LOCOMOTION: DEPENDENT (' & '#Get_OASIS.Ambulation_M0700#' & ')' & '
comments:'>
'
' &
'#Get_CR_1.OASIS#'
Update #Request.prefix_db_agency#.Coding_Results
set Textfield_13 = '#REVIEW#'
where Assessment_ID = #url.AID#
and Patient_ID = #url.ID#
and Message_ID = 78