| 1 | SPNLGRRX ; ISC-SF/GMB - SCD GATHER OUTPATIENT PHARMACY DATA;11 MAY 94 [ 08/08/94  1:26 PM ] ;6/23/95  11:42
 | 
|---|
| 2 |  ;;2.0;Spinal Cord Dysfunction;;01/02/1997
 | 
|---|
| 3 | ROLLUP(DFN,FDATE,TDATE,HI) ;
 | 
|---|
| 4 |  ; DFN       Patient's internal entry number in the Patient file
 | 
|---|
| 5 |  ; FDATE     "From" date
 | 
|---|
| 6 |  ; TDATE     "Thru" date, default=today
 | 
|---|
| 7 |  ; HI        1=keep track of individual patient usage
 | 
|---|
| 8 |  ;           0=don't keep track
 | 
|---|
| 9 |  ; Data will be rolled up into the following global:
 | 
|---|
| 10 |  ; ^TMP("SPN",$J,"RX",
 | 
|---|
| 11 |  ; with the following nodes:
 | 
|---|
| 12 |  ; "PAT")                # patients with at least 1 fill
 | 
|---|
| 13 |  ; "FILLS")              # fills of all drugs
 | 
|---|
| 14 |  ; "FILLS",-fills)       # patients with this many fills of all drugs
 | 
|---|
| 15 |  ; "COST",-cost)         # patients whose total drug cost is in this
 | 
|---|
| 16 |  ;                       dollar range (cost thru cost+99)
 | 
|---|
| 17 |  ; "VAL",-value)         # patients whose total drug value is in this
 | 
|---|
| 18 |  ;                       dollar range (value thru value+99)
 | 
|---|
| 19 |  ; "DRUG",drugnr)        # fills for this drug
 | 
|---|
| 20 |  ; "DRUG",drugnr,"NAME") name of this drug
 | 
|---|
| 21 |  ; "DRUG",drugnr,"PAT")  # patients who had this drug
 | 
|---|
| 22 |  ; "DRUG",drugnr,"COST") actual cost of all fills for this drug
 | 
|---|
| 23 |  ; "DRUG",drugnr,"VAL")  current value of all fills for this drug
 | 
|---|
| 24 |  ; "DRUG",drugnr,"QTY")  total quantity of all fills for this drug
 | 
|---|
| 25 |  ; "DRUG",drugnr,"FILLS",-fills)  # patients who had this many fills of this drug
 | 
|---|
| 26 |  ; ...and track usage by individual patient ranked by:
 | 
|---|
| 27 |  ; "HI","H1",-fills,-diff drugs,-cost,DFN)
 | 
|---|
| 28 |  ; "HI","H2",-cost,-fills,-diff drugs,DFN)
 | 
|---|
| 29 |  ; "HI","H3",-fills,-diff drugs,-value,DFN)
 | 
|---|
| 30 |  ; "HI","H4",-value,-fills,-diff drugs,DFN)
 | 
|---|
| 31 |  N EXPDATE,RECNR,ZEROREC,TWOREC,ZDRUGNR,FILLS,COST,RANGE,UNITVAL
 | 
|---|
| 32 |  N FILLDATE,QTY,SUBRECNR,TOTFILLS,TOTCOST,TOTVAL,NDDRUGS
 | 
|---|
| 33 |  I '$D(TDATE) S TDATE=DT
 | 
|---|
| 34 |  ; We are interested in any drug whose prescription 'expiration' or
 | 
|---|
| 35 |  ; 'cancel' date falls on or after the 'from' date.
 | 
|---|
| 36 |  ; We are going to take only the fills or refills which occurred
 | 
|---|
| 37 |  ; during the 'from'-'thru' date range.
 | 
|---|
| 38 |  S (TOTFILLS,TOTCOST)=0
 | 
|---|
| 39 |  S EXPDATE=FDATE-.000001 ; for each expiration date
 | 
|---|
| 40 |  F  S EXPDATE=$O(^PS(55,DFN,"P","A",EXPDATE)) Q:EXPDATE'>0  D
 | 
|---|
| 41 |  . S RECNR=0 ; for each prescription on that date
 | 
|---|
| 42 |  . F  S RECNR=$O(^PS(55,DFN,"P","A",EXPDATE,RECNR)) Q:RECNR'>0  D
 | 
|---|
| 43 |  . . S TWOREC=$G(^PSRX(RECNR,2)) ; follow ptr to get prescripton info
 | 
|---|
| 44 |  . . Q:TWOREC=""
 | 
|---|
| 45 |  . . S FILLDATE=$P(TWOREC,U,2)
 | 
|---|
| 46 |  . . Q:FILLDATE>TDATE
 | 
|---|
| 47 |  . . S ZEROREC=$G(^PSRX(RECNR,0))
 | 
|---|
| 48 |  . . Q:ZEROREC=""
 | 
|---|
| 49 |  . . S ZDRUGNR=+$P(ZEROREC,U,6)
 | 
|---|
| 50 |  . . S (FILLS,COST,QTY)=0
 | 
|---|
| 51 |  . . I FILLDATE'<FDATE,FILLDATE'>TDATE D TRACKIT(.FILLS,.COST,.QTY,$P(ZEROREC,U,7),$P(ZEROREC,U,17))
 | 
|---|
| 52 |  . . S SUBRECNR=0 ; for each refill of the drug
 | 
|---|
| 53 |  . . F  S SUBRECNR=$O(^PSRX(RECNR,1,SUBRECNR)) Q:SUBRECNR'>0  D
 | 
|---|
| 54 |  . . . S ZEROREC=$G(^PSRX(RECNR,1,SUBRECNR,0))
 | 
|---|
| 55 |  . . . S FILLDATE=$P(ZEROREC,U,1)
 | 
|---|
| 56 |  . . . Q:FILLDATE<FDATE!(FILLDATE>TDATE)
 | 
|---|
| 57 |  . . . D TRACKIT(.FILLS,.COST,.QTY,$P(ZEROREC,U,4),$P(ZEROREC,U,11))
 | 
|---|
| 58 |  . . Q:'FILLS
 | 
|---|
| 59 |  . . S TOTFILLS=TOTFILLS+FILLS
 | 
|---|
| 60 |  . . S TOTCOST=TOTCOST+COST
 | 
|---|
| 61 |  . . S FILLS(ZDRUGNR)=$G(FILLS(ZDRUGNR))+FILLS
 | 
|---|
| 62 |  . . S QTY(ZDRUGNR)=$G(QTY(ZDRUGNR))+QTY
 | 
|---|
| 63 |  . . S ^("COST")=$G(^TMP("SPN",$J,"RX","DRUG",ZDRUGNR,"COST"))+COST
 | 
|---|
| 64 |  Q:TOTFILLS=0
 | 
|---|
| 65 |  S ^("PAT")=$G(^TMP("SPN",$J,"RX","PAT"))+1
 | 
|---|
| 66 |  S ^("FILLS")=$G(^TMP("SPN",$J,"RX","FILLS"))+TOTFILLS
 | 
|---|
| 67 |  S ^(-TOTFILLS)=$G(^TMP("SPN",$J,"RX","FILLS",-TOTFILLS))+1
 | 
|---|
| 68 |  S RANGE=TOTCOST\100*100
 | 
|---|
| 69 |  S ^(-RANGE)=$G(^TMP("SPN",$J,"RX","COST",-RANGE))+1
 | 
|---|
| 70 |  S (TOTVAL,NDDRUGS)=0,ZDRUGNR="" ; for each drug
 | 
|---|
| 71 |  F  S ZDRUGNR=$O(FILLS(ZDRUGNR)) Q:ZDRUGNR=""  D
 | 
|---|
| 72 |  . S NDDRUGS=NDDRUGS+1 ; number of different drugs
 | 
|---|
| 73 |  . S ^("PAT")=$G(^TMP("SPN",$J,"RX","DRUG",ZDRUGNR,"PAT"))+1
 | 
|---|
| 74 |  . S FILLS=FILLS(ZDRUGNR)
 | 
|---|
| 75 |  . S ^(ZDRUGNR)=$G(^TMP("SPN",$J,"RX","DRUG",ZDRUGNR))+FILLS
 | 
|---|
| 76 |  . S ^(-FILLS)=$G(^TMP("SPN",$J,"RX","DRUG",ZDRUGNR,"FILLS",-FILLS))+1
 | 
|---|
| 77 |  . S ^("QTY")=$G(^TMP("SPN",$J,"RX","DRUG",ZDRUGNR,"QTY"))+QTY(ZDRUGNR)
 | 
|---|
| 78 |  . S UNITVAL=+$P($G(^PSDRUG(ZDRUGNR,660)),U,6) ; current price
 | 
|---|
| 79 |  . S TOTVAL=QTY(ZDRUGNR)*UNITVAL+TOTVAL
 | 
|---|
| 80 |  S RANGE=TOTVAL\100*100
 | 
|---|
| 81 |  S ^(-RANGE)=$G(^TMP("SPN",$J,"RX","VAL",-RANGE))+1
 | 
|---|
| 82 |  Q:'HI
 | 
|---|
| 83 |  S ^TMP("SPN",$J,"RX","HI","H1",-TOTFILLS,-NDDRUGS,-TOTCOST,DFN)=""
 | 
|---|
| 84 |  S ^TMP("SPN",$J,"RX","HI","H2",-TOTCOST,-TOTFILLS,-NDDRUGS,DFN)=""
 | 
|---|
| 85 |  S ^TMP("SPN",$J,"RX","HI","H3",-TOTFILLS,-NDDRUGS,-TOTVAL,DFN)=""
 | 
|---|
| 86 |  S ^TMP("SPN",$J,"RX","HI","H4",-TOTVAL,-TOTFILLS,-NDDRUGS,DFN)=""
 | 
|---|
| 87 |  Q
 | 
|---|
| 88 | TRACKIT(FILLS,COST,QTY,FILLQTY,UNITCOST) ;
 | 
|---|
| 89 |  S FILLS=FILLS+1
 | 
|---|
| 90 |  S COST=UNITCOST*FILLQTY+COST
 | 
|---|
| 91 |  S QTY=QTY+FILLQTY
 | 
|---|
| 92 |  Q
 | 
|---|
| 93 | NAMEIT ; names the drugs and gives current value of dispensed quantities
 | 
|---|
| 94 |  N ZDRUGNR,UNITVAL,ZDRUGNAM
 | 
|---|
| 95 |  S ZDRUGNR="" ; We might have a drug number which is zero...
 | 
|---|
| 96 |  F  S ZDRUGNR=$O(^TMP("SPN",$J,"RX","DRUG",ZDRUGNR)) Q:ZDRUGNR=""  D
 | 
|---|
| 97 |  . S ZDRUGNAM=$P($G(^PSDRUG(ZDRUGNR,0)),U,1)
 | 
|---|
| 98 |  . I ZDRUGNAM="" S ZDRUGNAM="Not Identified"
 | 
|---|
| 99 |  . S ^TMP("SPN",$J,"RX","DRUG",ZDRUGNR,"NAME")=ZDRUGNAM
 | 
|---|
| 100 |  . S UNITVAL=+$P($G(^PSDRUG(ZDRUGNR,660)),U,6) ; current price
 | 
|---|
| 101 |  . S ^("VAL")=$G(^TMP("SPN",$J,"RX","DRUG",ZDRUGNR,"QTY"))*UNITVAL
 | 
|---|
| 102 |  Q
 | 
|---|