| 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
|
---|