| [613] | 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 | 
|---|