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