PSO55FX3 ;ISC-BHAM/MHA - cleanup of bad p nodes and mismatched Rxs in file 55 ; 07/26/2001
;;7.0;OUTPATIENT PHARMACY;**69**;DEC 1997
;External reference to ^PS(55 is supported by DBIA 2228
MSG ;
W @IOF,"*** This patch will be queued to run in the background ***",!
W !,"It will scan through the PHARMACY PATIENT file (#55) and will look"
W !,"for possible bad 'P' or 'P','A' cross-references or prescriptions with"
W !,"mismatched patients. If it finds any bad cross-references then it will clean"
W !,"those bad cross-references and a count of them for each Outpatient Site"
W !,"entry will be sent in a mail message to the patch installer. If it finds any"
W !,"prescriptions that belong to other patients the mail message will also include"
W !,"a list of those patients with prescriptions that may have been discontinued"
W !,"because a DATE OF DEATH or an ADMISSION was entered for the patient with a"
W !,"corrupt cross-reference. Forward this mail message to the corresponding"
W !,"Pharmacy Application Coordinator, or to the appropriate Outpatient Pharmacy"
W !,"Personnel, for their review and correction. It will send summary information"
W !,"to G.PL2 PATCH TRACKING group on FORUM to keep a count of bad nodes by site."
W !,"This patch will also scan through the PRESCRIPTION file (#52) using the 'AD'"
W !,"cross-reference and will check if a corresponding entry exists in the"
W !,"PHARMACY PATIENT file (#55). The software will provide a count of missing"
W !,"entries in a separate mail message that will be sent to G.PL2 PATCH TRACKING"
W !,"on FORUM for their review.",!
S DIR(0)="E",DIR("A")="Press Return to Continue " D ^DIR K DIR W !
W !,"This task stores information in ^XTMP(""PSO"" global. Upon completion of the"
W !,"cleanup process, the information stored in this global will be used to"
W !,"generate several e-mail messages. If this task stops unexpectedly, it can be"
W !,"restarted by doing BEG^PSO55FX2. The routine will begin processing with the"
W !,"last record reviewed and will utilize the same global reference for storing"
W !,"data. No information will be lost.",!
W !,"We recommend re-indexing the ""B"" cross-reference of the PHARMACY PATIENT file"
W !,"(#55), during non-peak hours or when the number of pharmacy users on the system"
W !,"is at a minimum any time after completion of this job.",!!
Q
PH2 ;
S SD=2980101,PS=0,RX=0,TY="PSO",JN="692"
I '$D(^XTMP(TY,JN)) S X1=DT,X2=+90 D C^%DTC S ^XTMP(TY,JN,0)=$G(X)_"^"_DT G SPH2
I $D(^XTMP(TY,JN,1)) D
.S SD=$P($G(^XTMP(TY,JN,1)),"^") S:'SD SD=2980101
.S RX=$P($G(^XTMP(TY,JN,1)),"^",2) S:'RX RX=0
.S PS=$P($G(^XTMP(TY,JN,1)),"^",3) S:'PS PS=0
SPH2 F S SD=$O(^PSRX("AD",SD)) Q:'SD!(SD>3010801) D
.F S RX=$O(^PSRX("AD",SD,RX)) Q:'RX I $O(^PSRX("AD",SD,RX,""))=0,$D(^PSRX(RX,"STA")),+^PSRX(RX,"STA")'=13 D
..Q:$D(^PSRX(RX,"D"))
..S DFN=$P($G(^PSRX(RX,0)),"^",2),(PF,J)=0
..I DFN F S J=$O(^PS(55,DFN,"P",J)) Q:PF!('J) D
...I $P($G(^PS(55,DFN,"P",J,0)),"^")=RX S PF=1 Q
..I 'PF S PS=PS+1,^XTMP(TY,JN,2,PS)=$E(RX_" ",1,12)_$G(^PSRX(RX,0))
..S ^XTMP(TY,JN,1)=(SD-.1)_"^"_RX_"^"_PS
.S RX=0
S ZZ="PSO",^TMP(ZZ,$J,1)=""
S ^TMP(ZZ,$J,2)="Total Count of PRESCRIPTION Entries Missing from PHARMACY PATIENT file: "_PS
S ^TMP(ZZ,$J,3)=""
I PS D
.S ^TMP(ZZ,$J,4)="Prescription Information"
.S ^TMP(ZZ,$J,5)="IEN ZERO NODE"
.S ^TMP(ZZ,$J,6)="----------- -------------------------------------------------------------------"
.S XX=7,J=0
.F S J=$O(^XTMP(TY,JN,2,J)) Q:'J S ^TMP(ZZ,$J,XX)=^XTMP(TY,JN,2,J),XX=XX+1
S XMY("G.PL2 PATCH TRACKING@DOMAIN.NAME")=""
;S XMY(DUZ)=""
S XMSUB=$P($$SITE^VASITE(),"^",2)_" - PSO*7*69 - PART TWO"
S XMDUZ="Missing Rx entries from PHARMACY PATIENT file (#55)"
S XMTEXT="^TMP(ZZ,$J," D ^XMD
K ^XTMP(TY,JN),^TMP(ZZ,$J),^XTMP("PSO2",69),XMY,XMDUZ,SD,JN,TY,DFN,RX,XX,ZZ,J,PF,PS,X1,X2
K AL,CDT,CT,EDT,II,JJ,PDFN,QQ,S1,S2,SDT,YY,UL
S:$D(ZTQUEUED) ZTREQ="@"
Q
PSO55FX3 ;ISC-BHAM/MHA - cleanup of bad p nodes and mismatched Rxs in file 55 ; 07/26/2001
+1 ;;7.0;OUTPATIENT PHARMACY;**69**;DEC 1997
+2 ;External reference to ^PS(55 is supported by DBIA 2228
MSG ;
+1 WRITE @IOF,"*** This patch will be queued to run in the background ***",!
+2 WRITE !,"It will scan through the PHARMACY PATIENT file (#55) and will look"
+3 WRITE !,"for possible bad 'P' or 'P','A' cross-references or prescriptions with"
+4 WRITE !,"mismatched patients. If it finds any bad cross-references then it will clean"
+5 WRITE !,"those bad cross-references and a count of them for each Outpatient Site"
+6 WRITE !,"entry will be sent in a mail message to the patch installer. If it finds any"
+7 WRITE !,"prescriptions that belong to other patients the mail message will also include"
+8 WRITE !,"a list of those patients with prescriptions that may have been discontinued"
+9 WRITE !,"because a DATE OF DEATH or an ADMISSION was entered for the patient with a"
+10 WRITE !,"corrupt cross-reference. Forward this mail message to the corresponding"
+11 WRITE !,"Pharmacy Application Coordinator, or to the appropriate Outpatient Pharmacy"
+12 WRITE !,"Personnel, for their review and correction. It will send summary information"
+13 WRITE !,"to G.PL2 PATCH TRACKING group on FORUM to keep a count of bad nodes by site."
+14 WRITE !,"This patch will also scan through the PRESCRIPTION file (#52) using the 'AD'"
+15 WRITE !,"cross-reference and will check if a corresponding entry exists in the"
+16 WRITE !,"PHARMACY PATIENT file (#55). The software will provide a count of missing"
+17 WRITE !,"entries in a separate mail message that will be sent to G.PL2 PATCH TRACKING"
+18 WRITE !,"on FORUM for their review.",!
+19 SET DIR(0)="E"
SET DIR("A")="Press Return to Continue "
DO ^DIR
KILL DIR
WRITE !
+20 WRITE !,"This task stores information in ^XTMP(""PSO"" global. Upon completion of the"
+21 WRITE !,"cleanup process, the information stored in this global will be used to"
+22 WRITE !,"generate several e-mail messages. If this task stops unexpectedly, it can be"
+23 WRITE !,"restarted by doing BEG^PSO55FX2. The routine will begin processing with the"
+24 WRITE !,"last record reviewed and will utilize the same global reference for storing"
+25 WRITE !,"data. No information will be lost.",!
+26 WRITE !,"We recommend re-indexing the ""B"" cross-reference of the PHARMACY PATIENT file"
+27 WRITE !,"(#55), during non-peak hours or when the number of pharmacy users on the system"
+28 WRITE !,"is at a minimum any time after completion of this job.",!!
+29 QUIT
PH2 ;
+1 SET SD=2980101
SET PS=0
SET RX=0
SET TY="PSO"
SET JN="692"
+2 IF '$DATA(^XTMP(TY,JN))
SET X1=DT
SET X2=+90
DO C^%DTC
SET ^XTMP(TY,JN,0)=$GET(X)_"^"_DT
GOTO SPH2
+3 IF $DATA(^XTMP(TY,JN,1))
Begin DoDot:1
+4 SET SD=$PIECE($GET(^XTMP(TY,JN,1)),"^")
IF 'SD
SET SD=2980101
+5 SET RX=$PIECE($GET(^XTMP(TY,JN,1)),"^",2)
IF 'RX
SET RX=0
+6 SET PS=$PIECE($GET(^XTMP(TY,JN,1)),"^",3)
IF 'PS
SET PS=0
End DoDot:1
SPH2 FOR
SET SD=$ORDER(^PSRX("AD",SD))
IF 'SD!(SD>3010801)
QUIT
Begin DoDot:1
+1 FOR
SET RX=$ORDER(^PSRX("AD",SD,RX))
IF 'RX
QUIT
IF $ORDER(^PSRX("AD",SD,RX,""))=0
IF $DATA(^PSRX(RX,"STA"))
IF +^PSRX(RX,"STA")'=13
Begin DoDot:2
+2 IF $DATA(^PSRX(RX,"D"))
QUIT
+3 SET DFN=$PIECE($GET(^PSRX(RX,0)),"^",2)
SET (PF,J)=0
+4 IF DFN
FOR
SET J=$ORDER(^PS(55,DFN,"P",J))
IF PF!('J)
QUIT
Begin DoDot:3
+5 IF $PIECE($GET(^PS(55,DFN,"P",J,0)),"^")=RX
SET PF=1
QUIT
End DoDot:3
+6 IF 'PF
SET PS=PS+1
SET ^XTMP(TY,JN,2,PS)=$EXTRACT(RX_" ",1,12)_$GET(^PSRX(RX,0))
+7 SET ^XTMP(TY,JN,1)=(SD-.1)_"^"_RX_"^"_PS
End DoDot:2
+8 SET RX=0
End DoDot:1
+9 SET ZZ="PSO"
SET ^TMP(ZZ,$JOB,1)=""
+10 SET ^TMP(ZZ,$JOB,2)="Total Count of PRESCRIPTION Entries Missing from PHARMACY PATIENT file: "_PS
+11 SET ^TMP(ZZ,$JOB,3)=""
+12 IF PS
Begin DoDot:1
+13 SET ^TMP(ZZ,$JOB,4)="Prescription Information"
+14 SET ^TMP(ZZ,$JOB,5)="IEN ZERO NODE"
+15 SET ^TMP(ZZ,$JOB,6)="----------- -------------------------------------------------------------------"
+16 SET XX=7
SET J=0
+17 FOR
SET J=$ORDER(^XTMP(TY,JN,2,J))
IF 'J
QUIT
SET ^TMP(ZZ,$JOB,XX)=^XTMP(TY,JN,2,J)
SET XX=XX+1
End DoDot:1
+18 SET XMY("G.PL2 PATCH TRACKING@DOMAIN.NAME")=""
+19 ;S XMY(DUZ)=""
+20 SET XMSUB=$PIECE($$SITE^VASITE(),"^",2)_" - PSO*7*69 - PART TWO"
+21 SET XMDUZ="Missing Rx entries from PHARMACY PATIENT file (#55)"
+22 SET XMTEXT="^TMP(ZZ,$J,"
DO ^XMD
+23 KILL ^XTMP(TY,JN),^TMP(ZZ,$JOB),^XTMP("PSO2",69),XMY,XMDUZ,SD,JN,TY,DFN,RX,XX,ZZ,J,PF,PS,X1,X2
+24 KILL AL,CDT,CT,EDT,II,JJ,PDFN,QQ,S1,S2,SDT,YY,UL
+25 IF $DATA(ZTQUEUED)
SET ZTREQ="@"
+26 QUIT
