| 1 | RORX009A ;HCIOFO/SG - PRESCRIPTION UTILIZ. (QUERY & SORT) ; 10/12/05 11:49am | 
|---|
| 2 | ;;1.5;CLINICAL CASE REGISTRIES;;Feb 17, 2006 | 
|---|
| 3 | ; | 
|---|
| 4 | Q | 
|---|
| 5 | ; | 
|---|
| 6 | ;***** QUERIES THE REGISTRY | 
|---|
| 7 | ; | 
|---|
| 8 | ; FLAGS         Flags for the $$SKIP^RORXU005 | 
|---|
| 9 | ; | 
|---|
| 10 | ; Return Values: | 
|---|
| 11 | ;       <0  Error code | 
|---|
| 12 | ;        0  Ok | 
|---|
| 13 | ;       >0  Number of non-fatal errors | 
|---|
| 14 | ; | 
|---|
| 15 | QUERY(FLAGS) ; | 
|---|
| 16 | N ROREDT1       ; Day after the end date | 
|---|
| 17 | N RORPTN        ; Number of patients in the registry | 
|---|
| 18 | ; | 
|---|
| 19 | N CNT,ECNT,IEN,IENS,PATIEN,RC,RORXDST,RXFLAGS,TMP,XREFNODE | 
|---|
| 20 | S XREFNODE=$NA(^RORDATA(798,"AC",+RORREG)) | 
|---|
| 21 | S RORPTN=$$REGSIZE^RORUTL02(+RORREG)  S:RORPTN<0 RORPTN=0 | 
|---|
| 22 | S ROREDT1=$$FMADD^XLFDT(ROREDT,1) | 
|---|
| 23 | S (CNT,ECNT,RC)=0 | 
|---|
| 24 | ; | 
|---|
| 25 | ;--- Prepare parameters for the pharmacy search API | 
|---|
| 26 | S RORXDST=$NA(^TMP("RORX009",$J)) | 
|---|
| 27 | S RORXDST("RORCB")="$$RXSCB^RORX009A" | 
|---|
| 28 | S RORXDST("GENERIC")=$$PARAM^RORTSK01("DRUGS","AGGR_GENERIC") | 
|---|
| 29 | S RXFLAGS="E" | 
|---|
| 30 | S:$$PARAM^RORTSK01("PATIENTS","INPATIENT") RXFLAGS=RXFLAGS_"IV" | 
|---|
| 31 | S:$$PARAM^RORTSK01("PATIENTS","OUTPATIENT") RXFLAGS=RXFLAGS_"O" | 
|---|
| 32 | Q:RXFLAGS="E" 0 | 
|---|
| 33 | ; | 
|---|
| 34 | ;--- Browse through the registry records | 
|---|
| 35 | S IEN=0 | 
|---|
| 36 | F  S IEN=$O(@XREFNODE@(IEN))  Q:IEN'>0  D  Q:RC<0 | 
|---|
| 37 | . S TMP=$S(RORPTN>0:CNT/RORPTN,1:"") | 
|---|
| 38 | . S RC=$$LOOP^RORTSK01(TMP)  Q:RC<0 | 
|---|
| 39 | . S IENS=IEN_",",CNT=CNT+1 | 
|---|
| 40 | . ;--- Check if the patient should be skipped | 
|---|
| 41 | . Q:$$SKIP^RORXU005(IEN,FLAGS,RORSDT,ROREDT) | 
|---|
| 42 | . ; | 
|---|
| 43 | . ;--- Get the patient IEN (DFN) | 
|---|
| 44 | . S PATIEN=$$PTIEN^RORUTL01(IEN)  Q:PATIEN'>0 | 
|---|
| 45 | . ; | 
|---|
| 46 | . ;--- Search the pharmacy data | 
|---|
| 47 | . M RORXDST("RORXGRP")=RORXGRP("C") | 
|---|
| 48 | . S TMP=$$RXSEARCH^RORUTL14(PATIEN,RORXL,.RORXDST,RXFLAGS,RORSDT,ROREDT1) | 
|---|
| 49 | . I TMP<0  S ECNT=ECNT+1  Q | 
|---|
| 50 | . ;--- No medications from some groups | 
|---|
| 51 | . Q:$D(RORXDST("RORXGRP"))>1 | 
|---|
| 52 | . ;--- Skip the patient if no data has been found | 
|---|
| 53 | . I '$D(@RORXDST@("IP",PATIEN)),'$D(@RORXDST@("OP",PATIEN))  Q | 
|---|
| 54 | . ; | 
|---|
| 55 | . ;--- Calculate intermediate totals | 
|---|
| 56 | . S RC=$$TOTALS(PATIEN) | 
|---|
| 57 | . I RC  S ECNT=ECNT+1  Q:RC<0 | 
|---|
| 58 | ;--- | 
|---|
| 59 | Q $S(RC<0:RC,1:ECNT) | 
|---|
| 60 | ; | 
|---|
| 61 | ;***** CALLBACK FUNCTION FOR THE PHARMACY SEARCH API | 
|---|
| 62 | RXSCB(ROR8DST,ORDER,ORDFLG,DRUG,DATE) ; | 
|---|
| 63 | N DRUGIEN,DRUGNAME,IRP,RPS,RXCNT,SUBS,TMP | 
|---|
| 64 | I ROR8DST("GENERIC")  D | 
|---|
| 65 | . S DRUGIEN=+ROR8DST("RORXGEN"),DRUGNAME=$P(ROR8DST("RORXGEN"),U,2) | 
|---|
| 66 | E  S DRUGIEN=+DRUG,DRUGNAME=$P(DRUG,U,2) | 
|---|
| 67 | Q:(DRUGIEN'>0)!(DRUGNAME="") 1 | 
|---|
| 68 | ;=== Check the drug groups | 
|---|
| 69 | S TMP=$$RXGRPCHK^RORXU007(.ROR8DST,+DRUG,RORXL) | 
|---|
| 70 | Q:TMP TMP | 
|---|
| 71 | ;=== Process the order | 
|---|
| 72 | S SUBS=$S(ORDFLG["I":"IP",ORDFLG["O":"OP",1:"")  Q:SUBS="" 1 | 
|---|
| 73 | S RXCNT=0 | 
|---|
| 74 | ;--- Count the original order, refills and partials | 
|---|
| 75 | I ORDFLG["I"  S RXCNT=RXCNT+1  ; Inpatient | 
|---|
| 76 | E  D                           ; Outpatient | 
|---|
| 77 | . S TMP=+$P($G(^TMP("PS",$J,"RXN",0)),U,6)  ; Original Fill Date | 
|---|
| 78 | . S:(TMP'<ROR8DST("RORSDT"))&(TMP<ROR8DST("ROREDT")) RXCNT=RXCNT+1 | 
|---|
| 79 | F RPS="PAR","REF"  S IRP=0  D | 
|---|
| 80 | . F  S IRP=$O(^TMP("PS",$J,RPS,IRP))  Q:IRP'>0  S RXCNT=RXCNT+1 | 
|---|
| 81 | ;--- Update the counters | 
|---|
| 82 | D:RXCNT>0 | 
|---|
| 83 | . S TMP=$G(@ROR8DST@(SUBS,+ROR8DST("RORDFN"),"D",DRUGIEN)) | 
|---|
| 84 | . S @ROR8DST@(SUBS,+ROR8DST("RORDFN"),"D",DRUGIEN)=TMP+RXCNT | 
|---|
| 85 | . S TMP=SUBS_"D" | 
|---|
| 86 | . S:'$D(@ROR8DST@(TMP,DRUGIEN)) @ROR8DST@(TMP,DRUGIEN)=DRUGNAME | 
|---|
| 87 | Q 0 | 
|---|
| 88 | ; | 
|---|
| 89 | ;***** SORTS THE RESULTS AND COMPILES THE TOTALS | 
|---|
| 90 | ; | 
|---|
| 91 | ; Return Values: | 
|---|
| 92 | ;       <0  Error code | 
|---|
| 93 | ;        0  Ok | 
|---|
| 94 | ;       >0  Number of non-fatal errors | 
|---|
| 95 | ; | 
|---|
| 96 | SORT() ; | 
|---|
| 97 | N ECNT,NODE,RC | 
|---|
| 98 | S (ECNT,RC)=0 | 
|---|
| 99 | S NODE=$NA(^TMP("RORX009",$J)) | 
|---|
| 100 | Q:$D(@NODE)<10 0 | 
|---|
| 101 | ;--- | 
|---|
| 102 | S RC=$$LOOP^RORTSK01(0)    Q:RC<0 RC | 
|---|
| 103 | D SORTRX(NODE,"IPD") | 
|---|
| 104 | ;--- | 
|---|
| 105 | S RC=$$LOOP^RORTSK01(.33)  Q:RC<0 RC | 
|---|
| 106 | D SORTRX(NODE,"OPD") | 
|---|
| 107 | ;--- | 
|---|
| 108 | S RC=$$LOOP^RORTSK01(.66)  Q:RC<0 RC | 
|---|
| 109 | S RC=$$SUMRX(NODE) | 
|---|
| 110 | ;--- | 
|---|
| 111 | Q $S(RC<0:RC,1:ECNT) | 
|---|
| 112 | ; | 
|---|
| 113 | ;***** SORTS THE DRUG LIST | 
|---|
| 114 | ; | 
|---|
| 115 | ; NODE          Closed root of the category section | 
|---|
| 116 | ;               in the temporary global | 
|---|
| 117 | ; | 
|---|
| 118 | ; SUBS          Drug list subscript ("IPD" or "OPD") | 
|---|
| 119 | ; | 
|---|
| 120 | SORTRX(NODE,SUBS) ; | 
|---|
| 121 | N IEN,NAME,NDRUGS,SUM,TMP | 
|---|
| 122 | S IEN=0,NDRUGS=0 | 
|---|
| 123 | F  S IEN=$O(@NODE@(SUBS,IEN))  Q:IEN'>0  D | 
|---|
| 124 | . S NAME=@NODE@(SUBS,IEN),NDRUGS=NDRUGS+1 | 
|---|
| 125 | . S TMP=+$G(@NODE@(SUBS,IEN,"D")) | 
|---|
| 126 | . S @NODE@(SUBS,"B",TMP,NAME,IEN)="" | 
|---|
| 127 | ;--- Numbers of different drugs | 
|---|
| 128 | S @NODE@(SUBS)=NDRUGS | 
|---|
| 129 | Q | 
|---|
| 130 | ; | 
|---|
| 131 | ;***** COMBINES THE INPATIENT AND OUTPATIENT DATA | 
|---|
| 132 | ; | 
|---|
| 133 | ; NODE          Closed root of the category section | 
|---|
| 134 | ;               in the temporary global | 
|---|
| 135 | ; | 
|---|
| 136 | SUMRX(NODE) ; | 
|---|
| 137 | N COUNT,I,MAXUTNUM,NDRX,NRX,RC,RXIEN,SUMNRX,TMP | 
|---|
| 138 | Q:($D(@NODE@("IPRX"))<10)!($D(@NODE@("OPRX"))<10) 0 | 
|---|
| 139 | S MAXUTNUM=$$PARAM^RORTSK01("MAXUTNUM") | 
|---|
| 140 | Q:MAXUTNUM'>0 0 | 
|---|
| 141 | ; | 
|---|
| 142 | ;=== Outpatient data | 
|---|
| 143 | S NRX="",(COUNT,RC)=0 | 
|---|
| 144 | F  S NRX=$O(@NODE@("OPRX",NRX),-1)  Q:NRX=""  D  Q:RC | 
|---|
| 145 | . S RC=$$LOOP^RORTSK01()  Q:RC<0 | 
|---|
| 146 | . S @NODE@("SUMRX",NRX)=$G(@NODE@("OPRX",NRX)) | 
|---|
| 147 | . S NAME="" | 
|---|
| 148 | . F  S NAME=$O(@NODE@("OPRX",NRX,NAME))  Q:NAME=""  D  Q:RC | 
|---|
| 149 | . . S DFN="" | 
|---|
| 150 | . . F  S DFN=$O(@NODE@("OPRX",NRX,NAME,DFN))  Q:DFN=""  D  Q:RC | 
|---|
| 151 | . . . ;--- Include only the patients with highest utilization | 
|---|
| 152 | . . . S COUNT=COUNT+1  I COUNT>MAXUTNUM  S RC=1  Q | 
|---|
| 153 | . . . ;--- Calculate the totals | 
|---|
| 154 | . . . S (NDRX,SUMNRX)=0 | 
|---|
| 155 | . . . F I="IP","OP"  S TMP=$G(@NODE@(I,DFN))  D | 
|---|
| 156 | . . . . S NDRX=NDRX+$P(TMP,U,5),SUMNRX=SUMNRX+$P(TMP,U,4) | 
|---|
| 157 | . . . S @NODE@("SUMRX",SUMNRX,NAME,DFN,"OP")="" | 
|---|
| 158 | . . . S @NODE@("SUMRX",SUMNRX)=$G(@NODE@("SUMRX",SUMNRX))+1 | 
|---|
| 159 | . . . ;--- Adjust the total number of different drugs | 
|---|
| 160 | . . . ;--- (some drugs could be both inpatient and outpatient) | 
|---|
| 161 | . . . S RXIEN=0 | 
|---|
| 162 | . . . F  S RXIEN=$O(@NODE@("OP",DFN,"D",RXIEN))  Q:RXIEN'>0  D | 
|---|
| 163 | . . . . S:$D(@NODE@("IP",DFN,"D",RXIEN)) NDRX=NDRX-1 | 
|---|
| 164 | . . . ;--- Store the number of different drugs | 
|---|
| 165 | . . . S @NODE@("SUMRX",SUMNRX,NAME,DFN)=NDRX | 
|---|
| 166 | ; | 
|---|
| 167 | ;=== Inpatient data | 
|---|
| 168 | S NRX="",(COUNT,RC)=0 | 
|---|
| 169 | F  S NRX=$O(@NODE@("IPRX",NRX),-1)  Q:NRX=""  D  Q:RC | 
|---|
| 170 | . S RC=$$LOOP^RORTSK01()  Q:RC<0 | 
|---|
| 171 | . S NAME="" | 
|---|
| 172 | . F  S NAME=$O(@NODE@("IPRX",NRX,NAME))  Q:NAME=""  D  Q:RC | 
|---|
| 173 | . . S DFN="" | 
|---|
| 174 | . . F  S DFN=$O(@NODE@("IPRX",NRX,NAME,DFN))  Q:DFN=""  D  Q:RC | 
|---|
| 175 | . . . ;--- Include only the patients with highest utilization | 
|---|
| 176 | . . . S COUNT=COUNT+1  I COUNT>MAXUTNUM  S RC=1  Q | 
|---|
| 177 | . . . ;--- Calculate the totals | 
|---|
| 178 | . . . S (NDRX,SUMNRX)=0 | 
|---|
| 179 | . . . F I="IP","OP"  S TMP=$G(@NODE@(I,DFN))  D | 
|---|
| 180 | . . . . S NDRX=NDRX+$P(TMP,U,5),SUMNRX=SUMNRX+$P(TMP,U,4) | 
|---|
| 181 | . . . S @NODE@("SUMRX",SUMNRX,NAME,DFN,"IP")="" | 
|---|
| 182 | . . . ;--- Quit if the patient has been processed already | 
|---|
| 183 | . . . Q:$D(@NODE@("SUMRX",SUMNRX,NAME,DFN,"OP")) | 
|---|
| 184 | . . . S @NODE@("SUMRX",SUMNRX)=$G(@NODE@("SUMRX",SUMNRX))+1 | 
|---|
| 185 | . . . ;--- Adjust the total number of different drugs | 
|---|
| 186 | . . . ;--- (some drugs could be both inpatient and outpatient) | 
|---|
| 187 | . . . S RXIEN=0 | 
|---|
| 188 | . . . F  S RXIEN=$O(@NODE@("IP",DFN,"D",RXIEN))  Q:RXIEN'>0  D | 
|---|
| 189 | . . . . S:$D(@NODE@("OP",DFN,"D",RXIEN)) NDRX=NDRX-1 | 
|---|
| 190 | . . . ;--- Store the number of different drugs | 
|---|
| 191 | . . . S @NODE@("SUMRX",SUMNRX,NAME,DFN)=NDRX | 
|---|
| 192 | ;=== | 
|---|
| 193 | Q $S(RC<0:RC,1:0) | 
|---|
| 194 | ; | 
|---|
| 195 | ;***** CALCULATES THE INTERMEDIATE TOTALS | 
|---|
| 196 | ; | 
|---|
| 197 | ; PATIEN        Patient IEN (DFN) | 
|---|
| 198 | ; | 
|---|
| 199 | ; Return Values: | 
|---|
| 200 | ;       <0  Error code | 
|---|
| 201 | ;        0  Ok | 
|---|
| 202 | ;       >0  Number of non-fatal errors | 
|---|
| 203 | ; | 
|---|
| 204 | TOTALS(PATIEN) ; | 
|---|
| 205 | N DOD,IEN,LAST4,NDRUGS,NODE,NRX,PTNAME,PTNRX,RXS,SUBS,TMP,VA,VADM,VAERR | 
|---|
| 206 | S NODE=$NA(^TMP("RORX009",$J)) | 
|---|
| 207 | ;--- Get the patient's data | 
|---|
| 208 | D VADEM^RORUTL05(PATIEN,1) | 
|---|
| 209 | S PTNAME=VADM(1),LAST4=VA("BID"),DOD=$$DATE^RORXU002(VADM(6)\1) | 
|---|
| 210 | ;--- | 
|---|
| 211 | F SUBS="IP","OP"  D:$D(@NODE@(SUBS,PATIEN))>1 | 
|---|
| 212 | . S RXS=SUBS_"D" | 
|---|
| 213 | . S IEN=0,(NDRUGS,PTNRX)=0 | 
|---|
| 214 | . F  S IEN=$O(@NODE@(SUBS,PATIEN,"D",IEN))  Q:IEN'>0  D | 
|---|
| 215 | . . S NRX=@NODE@(SUBS,PATIEN,"D",IEN) | 
|---|
| 216 | . . S NDRUGS=NDRUGS+1,PTNRX=PTNRX+NRX | 
|---|
| 217 | . . ;--- | 
|---|
| 218 | . . S @NODE@(RXS,IEN,"D")=$G(@NODE@(RXS,IEN,"D"))+NRX | 
|---|
| 219 | . . S @NODE@(RXS,IEN,"P")=$G(@NODE@(RXS,IEN,"P"))+1 | 
|---|
| 220 | . . ;--- | 
|---|
| 221 | . . S TMP=$G(@NODE@(RXS,IEN,"M")) | 
|---|
| 222 | . . D:NRX'<TMP | 
|---|
| 223 | . . . I NRX>TMP  S @NODE@(RXS,IEN,"M")=NRX_U_1  Q | 
|---|
| 224 | . . . S $P(@NODE@(RXS,IEN,"M"),U,2)=$P(TMP,U,2)+1 | 
|---|
| 225 | . ;--- | 
|---|
| 226 | . S @NODE@(SUBS)=$G(@NODE@(SUBS))+1 | 
|---|
| 227 | . S @NODE@(SUBS,PATIEN)=LAST4_U_PTNAME_U_DOD_U_PTNRX_U_NDRUGS | 
|---|
| 228 | . ;--- | 
|---|
| 229 | . S RXS=SUBS_"RX" | 
|---|
| 230 | . S @NODE@(RXS)=$G(@NODE@(RXS))+PTNRX | 
|---|
| 231 | . S @NODE@(RXS,PTNRX)=$G(@NODE@(RXS,PTNRX))+1 | 
|---|
| 232 | . S @NODE@(RXS,PTNRX,PTNAME,PATIEN)="" | 
|---|
| 233 | ;--- | 
|---|
| 234 | Q 0 | 
|---|