| 1 | RORX015A ;HCIOFO/SG - OUTPATIENT PROCEDURES (QUERY & SORT) ; 6/21/06 4:36pm | 
|---|
| 2 | ;;1.5;CLINICAL CASE REGISTRIES;**1**;Feb 17, 2006;Build 24 | 
|---|
| 3 | ; | 
|---|
| 4 | ; This routine uses the following IAs: | 
|---|
| 5 | ; | 
|---|
| 6 | ; #1995         $$CODEN^ICPTCOD and $$CPT^ICPTCOD (supported) | 
|---|
| 7 | ; #2548         SDQ routine (supported) | 
|---|
| 8 | ; #3990         $$CODEN^ICDCODE and $$ICDOP^ICDCODE (supported) | 
|---|
| 9 | ; | 
|---|
| 10 | Q | 
|---|
| 11 | ; | 
|---|
| 12 | ;***** SEARCHES FOR INPATIENT PROCEDURES | 
|---|
| 13 | ; | 
|---|
| 14 | ; PTIEN         Patient IEN (DFN) | 
|---|
| 15 | ; | 
|---|
| 16 | ; Return Values: | 
|---|
| 17 | ;       <0  Error code | 
|---|
| 18 | ;        0  Ok | 
|---|
| 19 | ;       >0  Number of non-fatal errors | 
|---|
| 20 | ; | 
|---|
| 21 | INPAT(PTIEN) ; | 
|---|
| 22 | N DATE,ERRCNT,FLDLST,IEN,IEN45,IENS,NODE,RC,RORBUF,RORMSG,XREF | 
|---|
| 23 | S (ERRCNT,RC)=0 | 
|---|
| 24 | S XREF=$$ROOT^DILFD(45,,1),XREF=$NA(@XREF@("B",PTIEN)) | 
|---|
| 25 | S IEN45=0 | 
|---|
| 26 | F  S IEN45=$O(@XREF@(IEN45))  Q:IEN45'>0  D | 
|---|
| 27 | . ;Q:$$GET1^DIQ(45,IEN45_",",6,"I",,"RORMSG")<1  ; Skip open records | 
|---|
| 28 | . ;S IENS=IEN45_"," | 
|---|
| 29 | . ;S FLDLST="45.01;45.02;45.03;45.04;45.05" | 
|---|
| 30 | . ;D GETS^DIQ(45,IENS,FLDLST,"I","RORBUF","RORMSG") | 
|---|
| 31 | . ;I $G(DIERR)  D  S ERRCNT=ERRCNT+1 | 
|---|
| 32 | . ;. D DBS^RORERR("RORMSG",-99,,PTIEN,45,IENS) | 
|---|
| 33 | . ;D INP(PTIEN,$NA(RORBUF(IENS)),FLDLST,???) | 
|---|
| 34 | . ;--- Surgical procedures | 
|---|
| 35 | . S NODE=$$ROOT^DILFD(45.01,","_IEN45_",",1) | 
|---|
| 36 | . S IEN=0 | 
|---|
| 37 | . F  S IEN=$O(@NODE@(IEN))  Q:IEN'>0  D | 
|---|
| 38 | . . S IENS=IEN_","_IEN45_","  K RORBUF | 
|---|
| 39 | . . S FLDLST="8;9;10;11;12" | 
|---|
| 40 | . . ;--- Load the data | 
|---|
| 41 | . . D GETS^DIQ(45.01,IENS,".01;"_FLDLST,"I","RORBUF","RORMSG") | 
|---|
| 42 | . . I $G(DIERR)  D  S ERRCNT=ERRCNT+1 | 
|---|
| 43 | . . . D DBS^RORERR("RORMSG",-99,,PTIEN,45.01,IENS) | 
|---|
| 44 | . . S DATE=$G(RORBUF(45.01,IENS,.01,"I")) | 
|---|
| 45 | . . Q:(DATE<RORSDT)!(DATE'<ROREDT1) | 
|---|
| 46 | . . ;--- Generate the output | 
|---|
| 47 | . . D INP(PTIEN,$NA(RORBUF(45.01,IENS)),FLDLST,DATE) | 
|---|
| 48 | . ;--- Other procedures | 
|---|
| 49 | . S NODE=$$ROOT^DILFD(45.05,","_IEN45_",",1) | 
|---|
| 50 | . S IEN=0 | 
|---|
| 51 | . F  S IEN=$O(@NODE@(IEN))  Q:IEN'>0  D | 
|---|
| 52 | . . S IENS=IEN_","_IEN45_","  K RORBUF | 
|---|
| 53 | . . S FLDLST="4;5;6;7;8" | 
|---|
| 54 | . . ;--- Load the data | 
|---|
| 55 | . . D GETS^DIQ(45.05,IENS,".01;"_FLDLST,"I","RORBUF","RORMSG") | 
|---|
| 56 | . . I $G(DIERR)  D  S ERRCNT=ERRCNT+1 | 
|---|
| 57 | . . . D DBS^RORERR("RORMSG",-99,,PTIEN,45.05,IENS) | 
|---|
| 58 | . . S DATE=$G(RORBUF(45.05,IENS,.01,"I")) | 
|---|
| 59 | . . Q:(DATE<RORSDT)!(DATE'<ROREDT1) | 
|---|
| 60 | . . ;--- Generate the output | 
|---|
| 61 | . . D INP(PTIEN,$NA(RORBUF(45.05,IENS)),FLDLST,DATE) | 
|---|
| 62 | ;--- | 
|---|
| 63 | Q $S(RC<0:RC,1:ERRCNT) | 
|---|
| 64 | ; | 
|---|
| 65 | ;**** | 
|---|
| 66 | INP(PTIEN,ROR8BUF,FLDLST,DATE) ; | 
|---|
| 67 | N I,ICD9IEN,FLD | 
|---|
| 68 | F I=1:1  S FLD=$P(FLDLST,";",I)  Q:FLD=""  D | 
|---|
| 69 | . S ICD9IEN=+$G(@ROR8BUF@(FLD,"I")) | 
|---|
| 70 | . D:ICD9IEN>0 PROCSET(PTIEN,"I",ICD9IEN,DATE) | 
|---|
| 71 | Q | 
|---|
| 72 | ; | 
|---|
| 73 | ;***** CALL-BACK PROCEDURE FOR THE OUTPATIENT SEARCH | 
|---|
| 74 | ; | 
|---|
| 75 | ; PTIEN         Patient IEN (DFN) | 
|---|
| 76 | ; | 
|---|
| 77 | OPSCAN(PTIEN) ; | 
|---|
| 78 | N CPTIEN,DATE,IEN,RORCPT,VDATE | 
|---|
| 79 | D GETCPT^SDOE(Y,"RORCPT") | 
|---|
| 80 | Q:$G(RORCPT)'>0 | 
|---|
| 81 | S VDATE=+$P(Y0,U) | 
|---|
| 82 | ;--- | 
|---|
| 83 | S IEN=0 | 
|---|
| 84 | F  S IEN=$O(RORCPT(IEN))  Q:IEN'>0  D | 
|---|
| 85 | . S CPTIEN=+$P(RORCPT(IEN),U),DATE=+$P($G(RORCPT(IEN,12)),U) | 
|---|
| 86 | . D:CPTIEN>0 PROCSET(PTIEN,"O",CPTIEN,$S(DATE>0:DATE,1:VDATE)) | 
|---|
| 87 | Q | 
|---|
| 88 | ; | 
|---|
| 89 | ;***** SEARCHES FOR OUTPATIENT PROCEDURES | 
|---|
| 90 | ; | 
|---|
| 91 | ; PTIEN         Patient IEN (DFN) | 
|---|
| 92 | ; | 
|---|
| 93 | ; Return Values: | 
|---|
| 94 | ;       <0  Error code | 
|---|
| 95 | ;        0  Ok | 
|---|
| 96 | ;       >0  Number of non-fatal errors | 
|---|
| 97 | ; | 
|---|
| 98 | OUTPAT(PTIEN) ; | 
|---|
| 99 | N QUERY | 
|---|
| 100 | D OPEN^SDQ(.QUERY) | 
|---|
| 101 | D INDEX^SDQ(.QUERY,"PATIENT/DATE","SET") | 
|---|
| 102 | D PAT^SDQ(.QUERY,PTIEN,"SET") | 
|---|
| 103 | D DATE^SDQ(.QUERY,RORSDT,ROREDT1,"SET") | 
|---|
| 104 | D SCANCB^SDQ(.QUERY,"D OPSCAN^RORX015A("_PTIEN_")","SET") | 
|---|
| 105 | D ACTIVE^SDQ(.QUERY,"TRUE","SET") | 
|---|
| 106 | D SCAN^SDQ(.QUERY,"FORWARD") | 
|---|
| 107 | D CLOSE^SDQ(.QUERY) | 
|---|
| 108 | Q 0 | 
|---|
| 109 | ; | 
|---|
| 110 | ;**** STORES THE PROCEDURE CODE | 
|---|
| 111 | ; | 
|---|
| 112 | ; PTIEN         Patient IEN (DFN) | 
|---|
| 113 | ; SOURCE        CPT source code ("O" or "I") | 
|---|
| 114 | ; [IEN]         IEN of the procedure descriptor (file #81 or #80.1) | 
|---|
| 115 | ; DATE          Date when the code was entered | 
|---|
| 116 | ; [CODE]        Procedure code (CPT or ICD-9) | 
|---|
| 117 | ; | 
|---|
| 118 | ; Either the IEN or the CODE parameter must be provided. | 
|---|
| 119 | ; | 
|---|
| 120 | PROCSET(PTIEN,SOURCE,IEN,DATE,CODE) ; | 
|---|
| 121 | Q:DATE'>0 | 
|---|
| 122 | N TMP | 
|---|
| 123 | S IEN=+$G(IEN) | 
|---|
| 124 | ;--- | 
|---|
| 125 | I IEN'>0  Q:$G(CODE)=""  D  Q:IEN'>0 | 
|---|
| 126 | . I SOURCE="O"  S IEN=+$$CODEN^ICPTCOD(CODE)       Q | 
|---|
| 127 | . I SOURCE="I"  S IEN=+$$CODEN^ICDCODE(CODE,80.1)  Q | 
|---|
| 128 | ;--- | 
|---|
| 129 | I SOURCE="O",'$$PARAM^RORTSK01("CPTLST","ALL")  D  Q:'TMP | 
|---|
| 130 | . S TMP=$D(RORTSK("PARAMS","CPTLST","C",IEN)) | 
|---|
| 131 | I SOURCE="I"  Q:$$ICDGRCHK^RORXU008(.RORPTGRP,IEN,RORICDL) | 
|---|
| 132 | ;--- | 
|---|
| 133 | S TMP=+$G(@RORTMP@("PAT",PTIEN,SOURCE,IEN)) | 
|---|
| 134 | S:'TMP!(DATE<TMP) @RORTMP@("PAT",PTIEN,SOURCE,IEN)=DATE | 
|---|
| 135 | S ^("C")=$G(@RORTMP@("PAT",PTIEN,SOURCE,IEN,"C"))+1 | 
|---|
| 136 | Q | 
|---|
| 137 | ; | 
|---|
| 138 | ;***** QUERIES THE REGISTRY | 
|---|
| 139 | ; | 
|---|
| 140 | ; FLAGS         Flags for the $$SKIP^RORXU005 | 
|---|
| 141 | ; | 
|---|
| 142 | ; Return Values: | 
|---|
| 143 | ;       <0  Error code | 
|---|
| 144 | ;        0  Ok | 
|---|
| 145 | ;       >0  Number of non-fatal errors | 
|---|
| 146 | ; | 
|---|
| 147 | QUERY(FLAGS) ; | 
|---|
| 148 | N ROREDT1       ; Day after the end date | 
|---|
| 149 | N RORPTGRP      ; Temporary list of ICD-9 groups | 
|---|
| 150 | N RORPTN        ; Number of patients in the registry | 
|---|
| 151 | ; | 
|---|
| 152 | N CNT,ECNT,IEN,IENS,MODE,PTIEN,RC,SKIP,SKIPEDT,SKIPSDT,TMP,UTEDT,UTSDT,XREFNODE | 
|---|
| 153 | S XREFNODE=$NA(^RORDATA(798,"AC",+RORREG)) | 
|---|
| 154 | S ROREDT1=$$FMADD^XLFDT(ROREDT\1,1) | 
|---|
| 155 | S (CNT,ECNT,RC)=0,SKIPEDT=ROREDT,SKIPSDT=RORSDT | 
|---|
| 156 | S:$$PARAM^RORTSK01("PATIENTS","INPATIENT") MODE("I")=1 | 
|---|
| 157 | S:$$PARAM^RORTSK01("PATIENTS","OUTPATIENT") MODE("O")=1 | 
|---|
| 158 | ;--- Utilization date range | 
|---|
| 159 | D:$$PARAM^RORTSK01("PATIENTS","CAREONLY") | 
|---|
| 160 | . S UTSDT=$$PARAM^RORTSK01("DATE_RANGE_3","START")\1 | 
|---|
| 161 | . S UTEDT=$$PARAM^RORTSK01("DATE_RANGE_3","END")\1 | 
|---|
| 162 | . ;--- Combined date range | 
|---|
| 163 | . S SKIPSDT=$$DTMIN^RORUTL18(SKIPSDT,UTSDT) | 
|---|
| 164 | . S SKIPEDT=$$DTMAX^RORUTL18(SKIPEDT,UTEDT) | 
|---|
| 165 | ;--- Number of patients in the registry | 
|---|
| 166 | S RORPTN=$$REGSIZE^RORUTL02(+RORREG)  S:RORPTN<0 RORPTN=0 | 
|---|
| 167 | ; | 
|---|
| 168 | ;=== Browse through the registry records | 
|---|
| 169 | S IEN=0 | 
|---|
| 170 | F  S IEN=$O(@XREFNODE@(IEN))  Q:IEN'>0  D  Q:RC<0 | 
|---|
| 171 | . S TMP=$S(RORPTN>0:CNT/RORPTN,1:"") | 
|---|
| 172 | . S RC=$$LOOP^RORTSK01(TMP)  Q:RC<0 | 
|---|
| 173 | . S IENS=IEN_",",CNT=CNT+1 | 
|---|
| 174 | . ;--- Check if the patient should be skipped | 
|---|
| 175 | . Q:$$SKIP^RORXU005(IEN,FLAGS,SKIPSDT,SKIPEDT) | 
|---|
| 176 | . ; | 
|---|
| 177 | . ;--- Get the patient IEN (DFN) | 
|---|
| 178 | . S PTIEN=$$PTIEN^RORUTL01(IEN)  Q:PTIEN'>0 | 
|---|
| 179 | . M RORPTGRP=RORIGRP("C") | 
|---|
| 180 | . ; | 
|---|
| 181 | . ;--- Inpatient codes (ICD-9) | 
|---|
| 182 | . I $G(MODE("I"))   D  I RC  Q:RC<0  S ECNT=ECNT+RC | 
|---|
| 183 | . . S RC=$$INPAT(PTIEN) | 
|---|
| 184 | . ;--- Outpatient codes (CPT) | 
|---|
| 185 | . I $G(MODE("O"))  D  I RC  Q:RC<0  S ECNT=ECNT+RC | 
|---|
| 186 | . . S RC=$$OUTPAT(PTIEN) | 
|---|
| 187 | . ; | 
|---|
| 188 | . ;--- If ICD-9 codes from some groups have not been found, | 
|---|
| 189 | . ;--- then do not consider inpatient procedures at all | 
|---|
| 190 | . K:$D(RORPTGRP)>1 @RORTMP@("PAT",PTIEN,"I") | 
|---|
| 191 | . ;--- | 
|---|
| 192 | . S SKIP=($D(@RORTMP@("PAT",PTIEN))<10) | 
|---|
| 193 | . S:RORPROC<0 SKIP='SKIP | 
|---|
| 194 | . ; | 
|---|
| 195 | . ;--- Check for any utilization in the corresponding date range | 
|---|
| 196 | . I 'SKIP  D:$$PARAM^RORTSK01("PATIENTS","CAREONLY") | 
|---|
| 197 | . . K TMP  S TMP("ALL")=1 | 
|---|
| 198 | . . S UTIL=+$$UTIL^RORXU003(UTSDT,UTEDT,PTIEN,.TMP) | 
|---|
| 199 | . . S:'UTIL SKIP=1 | 
|---|
| 200 | . ; | 
|---|
| 201 | . ;--- Skip the patient if not all search criteria have been met | 
|---|
| 202 | . I SKIP  K @RORTMP@("PAT",PTIEN)  Q | 
|---|
| 203 | . ; | 
|---|
| 204 | . ;--- Calculate the patient's totals | 
|---|
| 205 | . S RC=$$TOTALS(PTIEN) | 
|---|
| 206 | . I RC  Q:RC<0  S ECNT=ECNT+RC | 
|---|
| 207 | ;--- | 
|---|
| 208 | Q $S(RC<0:RC,1:ECNT) | 
|---|
| 209 | ; | 
|---|
| 210 | ;***** SORTS THE RESULTS AND COMPILES THE TOTALS | 
|---|
| 211 | ; | 
|---|
| 212 | ; Return Values: | 
|---|
| 213 | ;       <0  Error code | 
|---|
| 214 | ;        0  Ok | 
|---|
| 215 | ;       >0  Number of non-fatal errors | 
|---|
| 216 | ; | 
|---|
| 217 | SORT() ; | 
|---|
| 218 | N IEN,SRC,TMP,TNC,TNDC | 
|---|
| 219 | ;--- | 
|---|
| 220 | S (TNC,TNDC)=0 | 
|---|
| 221 | F SRC="I","O"  D | 
|---|
| 222 | . S IEN=0 | 
|---|
| 223 | . F  S IEN=$O(@RORTMP@("PROC",SRC,IEN))  Q:IEN'>0  D | 
|---|
| 224 | . . S TMP=$P($G(@RORTMP@("PROC",SRC,IEN)),U,2) | 
|---|
| 225 | . . S:TMP'="" @RORTMP@("PROC","B",TMP,SRC,IEN)="" | 
|---|
| 226 | . . S TNC=TNC+$G(@RORTMP@("PROC",SRC,IEN,"C")) | 
|---|
| 227 | . . S TNDC=TNDC+1 | 
|---|
| 228 | S @RORTMP@("PROC")=TNC_U_TNDC | 
|---|
| 229 | ;--- | 
|---|
| 230 | Q 0 | 
|---|
| 231 | ; | 
|---|
| 232 | ;***** CALCULATES INTERMEDIATE TOTALS | 
|---|
| 233 | ; | 
|---|
| 234 | ; PTIEN         Patient IEN (DFN) | 
|---|
| 235 | ; | 
|---|
| 236 | ; Return Values: | 
|---|
| 237 | ;       <0  Error code | 
|---|
| 238 | ;        0  Ok | 
|---|
| 239 | ;       >0  Number of non-fatal errors | 
|---|
| 240 | ; | 
|---|
| 241 | TOTALS(PTIEN) ; | 
|---|
| 242 | N CNT,CODE,IEN,NAME,PNODE,RC,SRC,TMP,VA,VADM | 
|---|
| 243 | S PNODE=$NA(@RORTMP@("PAT",PTIEN)) | 
|---|
| 244 | ;--- Get and store the patient's data | 
|---|
| 245 | D VADEM^RORUTL05(PTIEN,1) | 
|---|
| 246 | S @PNODE=VA("BID")_U_VADM(1)_U_$$DATE^RORXU002(VADM(6)\1) | 
|---|
| 247 | S ^("PAT")=$G(@RORTMP@("PAT"))+1 | 
|---|
| 248 | ; | 
|---|
| 249 | F SRC="I","O"  D | 
|---|
| 250 | . S IEN=0 | 
|---|
| 251 | . F  S IEN=$O(@PNODE@(SRC,IEN))  Q:IEN'>0  D | 
|---|
| 252 | . . S CODE=$P($G(@RORTMP@("PROC",SRC,IEN)),U),NAME="" | 
|---|
| 253 | . . D:CODE="" | 
|---|
| 254 | . . . I SRC="O"  D | 
|---|
| 255 | . . . . S TMP=$$CPT^ICPTCOD(IEN) | 
|---|
| 256 | . . . . S:TMP'<0 CODE=$P(TMP,U,2),NAME=$P(TMP,U,3) | 
|---|
| 257 | . . . E  D | 
|---|
| 258 | . . . . S TMP=$$ICDOP^ICDCODE(IEN) | 
|---|
| 259 | . . . . S:TMP'<0 CODE=$P(TMP,U,2),NAME=$P(TMP,U,5) | 
|---|
| 260 | . . . S:CODE="" CODE="UNKN" | 
|---|
| 261 | . . . S:NAME="" NAME="Unknown ("_IEN_")" | 
|---|
| 262 | . . . S @RORTMP@("PROC",SRC,IEN)=CODE_U_NAME | 
|---|
| 263 | . . ;--- | 
|---|
| 264 | . . S CNT=+$G(@PNODE@(SRC,IEN,"C")) | 
|---|
| 265 | . . S ^("C")=$G(@RORTMP@("PROC",SRC,IEN,"C"))+CNT | 
|---|
| 266 | . . S ^("P")=$G(@RORTMP@("PROC",SRC,IEN,"P"))+1 | 
|---|
| 267 | Q 0 | 
|---|