SD53P754 ;MS/GN - TMP POST INSTALL;July 05, 2018
;;5.3;Scheduling;**754**;May 29, 2018;Build 5
;
;Post install routine for SD*5.3*754 to cleanup file 409.85 and add a CID date that was null.
;This routine will be left installed for possible UNDO tag execution during a backout patch scenario.
; ** Note: UNDO will not work if XTMP has been purged after its 90 day expiration date. **
; Site can delete this routine anytime they prefer at a later date.
;
EN ;Begin Post Install
S BEGDT=$P(^XPD(9.7,$O(^XPD(9.7,"B","SD*5.3*704","")),0),U,3)\1
S ENDDT=$P(^XPD(9.7,$O(^XPD(9.7,"B","SD*5.3*714","")),0),U,3)\1
D FIXCID(BEGDT,ENDDT) ;strt date of search for bad data AFTER *704, end date of search after *714
Q
FIXCID(BEGIN,END) ;Fix CID/PREFERRED DATE OF APPT field (#22) in SDEC APPOINTMENT REQUEST file (#409.85)
N AP,APSTS,CDT,CNT,CNTD,ERRCNT,ERRDIS S (CNT,CNTD,ERRCNT,ERRDIS)=0
S NAME="SD53P754"
S ^XTMP(NAME,0)=$$FMADD^XLFDT(DT,90)_U_DT_U_"POST INSTALL SD53P754 TMP APPT CID DT FIX"
D MES^XPDUTL("")
D MES^XPDUTL("Beginning update of data in the SDEC APPT REQUEST file...")
D MES^XPDUTL("")
;
;Save original 0 & "DIS" nodes prior to updating date fields to XTMP for 60 days, after 60 it will be auto deleted.
;
;Update recs with null CID/Preferred Date of Appt field #22 in the SDEC APPT REQUEST file (#409.85)
S (CNT,CNTO)=0
F ST="C","O" D
. F DTE=BEGIN:0 S DTE=$O(^SDEC(409.85,"E",ST,DTE)) Q:('DTE)!(DTE>END) D
.. F AP=0:0 S AP=$O(^SDEC(409.85,"E",ST,DTE,AP)) Q:'AP D:'$P(^SDEC(409.85,AP,0),U,16)
... S:ST="C" CNT=CNT+1 S:ST="O" CNTO=CNTO+1
... S APNODE0=^SDEC(409.85,AP,0),^XTMP(NAME,AP,"BEFOR")=APNODE0
... S APSTS=$P(APNODE0,U,17) ;get appt sts
... S CDT=+$P(APNODE0,U,2) S:'CDT CDT=DT ;get CREATE DATE FIELD (#1) for updating CID date, else DT
... D UPDCID(AP,CDT) ;update CID field
... I '$P($G(^SDEC(409.85,AP,"DIS")),U) D
.... S ^XTMP(NAME,AP,"DIS BEFOR")=$G(^SDEC(409.85,AP,"DIS"))
.... D UPDDIS(AP,CDT,APSTS) ;Update DIS nodes
D MES^XPDUTL(""),MES^XPDUTL("==== Appt Records Fixed ====")
D MES^XPDUTL(""),MES^XPDUTL(" Open sts Count: "_CNTO)
D MES^XPDUTL(""),MES^XPDUTL("Closed sts Count: "_CNT)
D MES^XPDUTL(""),MES^XPDUTL(" Total Count: "_(CNT+CNTO))
S ^XTMP(NAME,0,"TOTAL EMPTY CID RECORDS UPDATED")=CNT
S ^XTMP(NAME,0,"TOTAL EMPTY CID UPDATE ERRORS")=ERRCNT
S ^XTMP(NAME,0,"TOTAL EMPTY DIS RECORDS UPDATED")=CNTD
S ^XTMP(NAME,0,"TOTAL EMPTY DIS UPDATE ERRORS")=ERRDIS
S ^XTMP(NAME,0,"TOTAL FILE ERRORS")=(ERRCNT+ERRDIS)
D MES^XPDUTL("")
D MES^XPDUTL("===== Update Completed =====")
D MES^XPDUTL("")
Q
UPDCID(AP,CDT) ;Update 409.85 file field #22
; AP - Rec ien for 409.85 file
; CDT - CID date (FM format no time) in Appt Req file
N ERR,FDA
S FDA(409.85,AP_",",22)=CDT
D UPDATE^DIE(,"FDA","ERR")
S ^XTMP(NAME,AP,"AFTER")=^SDEC(409.85,AP,0)
I $D(ERR) D
. D MES^XPDUTL("FileMan error when updating APPT recnum: "_AP) S ERRCNT=ERRCNT+1 M ^XTMP(NAME,AP,"ERR")=ERR
E D
. S CNT=CNT+1
Q
UPDDIS(AP,DDT,APSTS) ;Update the "DIS" node in 409.85 file field all fields especially date (#19)
; AP - Rec ien for 409.85 file
; CDT - Dispositioned date (FM format no time) in Appt Req file
;
;If DIS date is null then prodeed, else do nothing, update this node as follows:
;
; DIS;1 19 DATE DISPOSITIONED = same date used in CID update
; DIS;2 20 DISPOSITIONED BY = DUZ
; DIS;3 21 DISPOSITION = "SA"
; DIS;4 21.1 DISPOSITION CLOSED BY CLEANUP = <-- ???? LEAVE NULL FOR NOW ????
; DESCRIPTION: Enter Yes if Disposition is related to Open Request
; becoming Closed due to the running of Cleanup Utility.
; Otherwise enter No.
N ERR,FDA
D:'$P($G(^SDEC(409.85,AP,"DIS")),U) ;If no 1st piece (date), then update this DIS node with all data
. S FDA(409.85,AP_",",19)=$P(DDT,".")
. S FDA(409.85,AP_",",20)=DUZ
. S FDA(409.85,AP_",",21)="SA"
. D UPDATE^DIE(,"FDA","ERR")
. M ^XTMP(NAME,AP,"DIS AFTER")=^SDEC(409.85,AP,"DIS")
I $D(ERR) D
. D MES^XPDUTL("FileMan error when updating DIS recnum: "_AP) S ERRDIS=ERRDIS+1 M ^XTMP(NAME,AP,"ERR DIS")=ERR
E D
. S CNTD=CNTD+1
Q
DISP ;QUICK DISPLAY OF SDEC RECS TOUCHED IF CURIOUS?
; assumes Refletion display settings set to max of 999 memory to see all or,
; user will turn on logging to record to a flat file or,
; user will use %G to access XTMP directly
N PG,LN S (PG,LN)=0 W # W #
W !!!,"APPROXIMATE NUMBER OF SCREEN PAGES TO DISPLAY... ",^XTMP("SD53P754",0,"TOTAL EMPTY CID RECORDS UPDATED")\7 H 3 W #
F AP=0:0 S AP=$O(^XTMP("SD53P754",AP)) Q:'AP D
. D:LN#7=0 HDR S LN=LN+1
. W !,"0: ",AP,?14,$P(^SDEC(409.85,AP,0),U,1,17)
. W !,"DIS:",?15,$G(^SDEC(409.85,AP,"DIS")),!
W #!,?20,"Ctrl + PgUp for previous page.",!,?17,"(hold down both for continuous scrolling)",!
W !?3,"Assumes Reflection Display Settings = 999 Memory blocks to retain all pages"
Q
HDR ;Write screen header
U 0
S PG=PG+1
W #
W "Node 0: IEN ^ Create dte",?36,"<pg ",PG,">",?53,"^16 CID dte ^17 Open/Close",!
W "DIS node: date ^ duz ^ sts"
W !,"================================================================================"
Q
CNT ;pre-post install null CID datre count entire 409.85 file
S CNT=0,CNTERR=0
F AP=0:0 S AP=$O(^SDEC(409.85,AP)) Q:'AP S CNT=CNT+1 I '$P(^SDEC(409.85,AP,0),U,2),'$P(^SDEC(409.85,AP,0),U,17) S CNTERR=CNTERR+1
W !,"cid null count: ",?40,$J(CNT,10),!,"date entered is also null count: ",?40,$J(CNTERR,10),!,"difference: ",?40,$J((CNT-CNTERR),10)
Q
ALL ;ALL RECD COUNTED INEGRITY OF "E" XREF VS $O OF 0 NODES
N ST,DTE,AP,CNT,ECNT,NCNT,DCNT,XCNT,XEC
S (CNT,ECNT,NCNT,DCNT,XCNT,XEC)=0
W !,"Analyzing."
F AP=0:0 S AP=$O(^SDEC(409.85,AP)) Q:'AP D
. S APNODE0=^SDEC(409.85,AP,0)
. S CNT=CNT+1 W:CNT#6000=0 "."
. S:'$P(APNODE0,U,16) ECNT=ECNT+1
. S:$P(APNODE0,U,17)="" NCNT=NCNT+1
. I '$P(APNODE0,U,2) W !,AP,?20,APNODE0 S DCNT=DCNT+1
F ST="C","O" F DTE=0:0 S DTE=$O(^SDEC(409.85,"E",ST,DTE)) Q:'DTE D
. F AP=0:0 S AP=$O(^SDEC(409.85,"E",ST,DTE,AP)) Q:'AP S XCNT=XCNT+1 S:'$P(^SDEC(409.85,AP,0),U,16) XEC=XEC+1
W !!,"TOTL ",CNT,!,"NCID ",ECNT,!,"NOST ",NCNT,!,"NODT ",DCNT,!!,"XREF ",XCNT,!,"XFIX ",XEC,!!
Q
UNDO ;UNDO MY CURRENT UPDATE FOR CID & DIS
N AP,ERR,FDA
F AP=0:0 S AP=$O(^XTMP("SD53P754",AP)) Q:'AP D
. W !,AP
. ;update the CID/PREFERRED DATE OF APPT date field (#22) in the SDEC APPT REQUEST file (#409.85)
. Q:'$D(^XTMP("SD53P754",AP,"AFTER"))
. W !,AP,"<<<<<<"
. S FDA(409.85,AP_",",22)="@"
. D UPDATE^DIE(,"FDA","ERR")
. K ^SDEC(409.85,AP,"DIS")
Q
--- Routine Detail --- with STRUCTURED ROUTINE LISTING ---[H[J[2J[HSD53P754 6913 printed Apr 09, 2024@21:43:02 Page 2
SD53P754 ;MS/GN - TMP POST INSTALL;July 05, 2018
+1 ;;5.3;Scheduling;**754**;May 29, 2018;Build 5
+2 ;
+3 ;Post install routine for SD*5.3*754 to cleanup file 409.85 and add a CID date that was null.
+4 ;This routine will be left installed for possible UNDO tag execution during a backout patch scenario.
+5 ; ** Note: UNDO will not work if XTMP has been purged after its 90 day expiration date. **
+6 ; Site can delete this routine anytime they prefer at a later date.
+7 ;
EN ;Begin Post Install
+1 SET BEGDT=$PIECE(^XPD(9.7,$ORDER(^XPD(9.7,"B","SD*5.3*704","")),0),U,3)\1
+2 SET ENDDT=$PIECE(^XPD(9.7,$ORDER(^XPD(9.7,"B","SD*5.3*714","")),0),U,3)\1
+3 ;strt date of search for bad data AFTER *704, end date of search after *714
DO FIXCID(BEGDT,ENDDT)
+4 QUIT
FIXCID(BEGIN,END) ;Fix CID/PREFERRED DATE OF APPT field (#22) in SDEC APPOINTMENT REQUEST file (#409.85)
+1 NEW AP,APSTS,CDT,CNT,CNTD,ERRCNT,ERRDIS
SET (CNT,CNTD,ERRCNT,ERRDIS)=0
+2 SET NAME="SD53P754"
+3 SET ^XTMP(NAME,0)=$$FMADD^XLFDT(DT,90)_U_DT_U_"POST INSTALL SD53P754 TMP APPT CID DT FIX"
+4 DO MES^XPDUTL("")
+5 DO MES^XPDUTL("Beginning update of data in the SDEC APPT REQUEST file...")
+6 DO MES^XPDUTL("")
+7 ;
+8 ;Save original 0 & "DIS" nodes prior to updating date fields to XTMP for 60 days, after 60 it will be auto deleted.
+9 ;
+10 ;Update recs with null CID/Preferred Date of Appt field #22 in the SDEC APPT REQUEST file (#409.85)
+11 SET (CNT,CNTO)=0
+12 FOR ST="C","O"
Begin DoDot:1
+13 FOR DTE=BEGIN:0
SET DTE=$ORDER(^SDEC(409.85,"E",ST,DTE))
if ('DTE)!(DTE>END)
QUIT
Begin DoDot:2
+14 FOR AP=0:0
SET AP=$ORDER(^SDEC(409.85,"E",ST,DTE,AP))
if 'AP
QUIT
if '$PIECE(^SDEC(409.85,AP,0),U,16)
Begin DoDot:3
+15 if ST="C"
SET CNT=CNT+1
if ST="O"
SET CNTO=CNTO+1
+16 SET APNODE0=^SDEC(409.85,AP,0)
SET ^XTMP(NAME,AP,"BEFOR")=APNODE0
+17 ;get appt sts
SET APSTS=$PIECE(APNODE0,U,17)
+18 ;get CREATE DATE FIELD (#1) for updating CID date, else DT
SET CDT=+$PIECE(APNODE0,U,2)
if 'CDT
SET CDT=DT
+19 ;update CID field
DO UPDCID(AP,CDT)
+20 IF '$PIECE($GET(^SDEC(409.85,AP,"DIS")),U)
Begin DoDot:4
+21 SET ^XTMP(NAME,AP,"DIS BEFOR")=$GET(^SDEC(409.85,AP,"DIS"))
+22 ;Update DIS nodes
DO UPDDIS(AP,CDT,APSTS)
End DoDot:4
End DoDot:3
End DoDot:2
End DoDot:1
+23 DO MES^XPDUTL("")
DO MES^XPDUTL("==== Appt Records Fixed ====")
+24 DO MES^XPDUTL("")
DO MES^XPDUTL(" Open sts Count: "_CNTO)
+25 DO MES^XPDUTL("")
DO MES^XPDUTL("Closed sts Count: "_CNT)
+26 DO MES^XPDUTL("")
DO MES^XPDUTL(" Total Count: "_(CNT+CNTO))
+27 SET ^XTMP(NAME,0,"TOTAL EMPTY CID RECORDS UPDATED")=CNT
+28 SET ^XTMP(NAME,0,"TOTAL EMPTY CID UPDATE ERRORS")=ERRCNT
+29 SET ^XTMP(NAME,0,"TOTAL EMPTY DIS RECORDS UPDATED")=CNTD
+30 SET ^XTMP(NAME,0,"TOTAL EMPTY DIS UPDATE ERRORS")=ERRDIS
+31 SET ^XTMP(NAME,0,"TOTAL FILE ERRORS")=(ERRCNT+ERRDIS)
+32 DO MES^XPDUTL("")
+33 DO MES^XPDUTL("===== Update Completed =====")
+34 DO MES^XPDUTL("")
+35 QUIT
UPDCID(AP,CDT) ;Update 409.85 file field #22
+1 ; AP - Rec ien for 409.85 file
+2 ; CDT - CID date (FM format no time) in Appt Req file
+3 NEW ERR,FDA
+4 SET FDA(409.85,AP_",",22)=CDT
+5 DO UPDATE^DIE(,"FDA","ERR")
+6 SET ^XTMP(NAME,AP,"AFTER")=^SDEC(409.85,AP,0)
+7 IF $DATA(ERR)
Begin DoDot:1
+8 DO MES^XPDUTL("FileMan error when updating APPT recnum: "_AP)
SET ERRCNT=ERRCNT+1
MERGE ^XTMP(NAME,AP,"ERR")=ERR
End DoDot:1
+9 IF '$TEST
Begin DoDot:1
+10 SET CNT=CNT+1
End DoDot:1
+11 QUIT
UPDDIS(AP,DDT,APSTS) ;Update the "DIS" node in 409.85 file field all fields especially date (#19)
+1 ; AP - Rec ien for 409.85 file
+2 ; CDT - Dispositioned date (FM format no time) in Appt Req file
+3 ;
+4 ;If DIS date is null then prodeed, else do nothing, update this node as follows:
+5 ;
+6 ; DIS;1 19 DATE DISPOSITIONED = same date used in CID update
+7 ; DIS;2 20 DISPOSITIONED BY = DUZ
+8 ; DIS;3 21 DISPOSITION = "SA"
+9 ; DIS;4 21.1 DISPOSITION CLOSED BY CLEANUP = <-- ???? LEAVE NULL FOR NOW ????
+10 ; DESCRIPTION: Enter Yes if Disposition is related to Open Request
+11 ; becoming Closed due to the running of Cleanup Utility.
+12 ; Otherwise enter No.
+13 NEW ERR,FDA
+14 ;If no 1st piece (date), then update this DIS node with all data
if '$PIECE($GET(^SDEC(409.85,AP,"DIS")),U)
Begin DoDot:1
+15 SET FDA(409.85,AP_",",19)=$PIECE(DDT,".")
+16 SET FDA(409.85,AP_",",20)=DUZ
+17 SET FDA(409.85,AP_",",21)="SA"
+18 DO UPDATE^DIE(,"FDA","ERR")
+19 MERGE ^XTMP(NAME,AP,"DIS AFTER")=^SDEC(409.85,AP,"DIS")
End DoDot:1
+20 IF $DATA(ERR)
Begin DoDot:1
+21 DO MES^XPDUTL("FileMan error when updating DIS recnum: "_AP)
SET ERRDIS=ERRDIS+1
MERGE ^XTMP(NAME,AP,"ERR DIS")=ERR
End DoDot:1
+22 IF '$TEST
Begin DoDot:1
+23 SET CNTD=CNTD+1
End DoDot:1
+24 QUIT
DISP ;QUICK DISPLAY OF SDEC RECS TOUCHED IF CURIOUS?
+1 ; assumes Refletion display settings set to max of 999 memory to see all or,
+2 ; user will turn on logging to record to a flat file or,
+3 ; user will use %G to access XTMP directly
+4 NEW PG,LN
SET (PG,LN)=0
WRITE #
WRITE #
+5 WRITE !!!,"APPROXIMATE NUMBER OF SCREEN PAGES TO DISPLAY... ",^XTMP("SD53P754",0,"TOTAL EMPTY CID RECORDS UPDATED")\7
HANG 3
WRITE #
+6 FOR AP=0:0
SET AP=$ORDER(^XTMP("SD53P754",AP))
if 'AP
QUIT
Begin DoDot:1
+7 if LN#7=0
DO HDR
SET LN=LN+1
+8 WRITE !,"0: ",AP,?14,$PIECE(^SDEC(409.85,AP,0),U,1,17)
+9 WRITE !,"DIS:",?15,$GET(^SDEC(409.85,AP,"DIS")),!
End DoDot:1
+10 WRITE #!,?20,"Ctrl + PgUp for previous page.",!,?17,"(hold down both for continuous scrolling)",!
+11 WRITE !?3,"Assumes Reflection Display Settings = 999 Memory blocks to retain all pages"
+12 QUIT
HDR ;Write screen header
+1 USE 0
+2 SET PG=PG+1
+3 WRITE #
+4 WRITE "Node 0: IEN ^ Create dte",?36,"<pg ",PG,">",?53,"^16 CID dte ^17 Open/Close",!
+5 WRITE "DIS node: date ^ duz ^ sts"
+6 WRITE !,"================================================================================"
+7 QUIT
CNT ;pre-post install null CID datre count entire 409.85 file
+1 SET CNT=0
SET CNTERR=0
+2 FOR AP=0:0
SET AP=$ORDER(^SDEC(409.85,AP))
if 'AP
QUIT
SET CNT=CNT+1
IF '$PIECE(^SDEC(409.85,AP,0),U,2)
IF '$PIECE(^SDEC(409.85,AP,0),U,17)
SET CNTERR=CNTERR+1
+3 WRITE !,"cid null count: ",?40,$JUSTIFY(CNT,10),!,"date entered is also null count: ",?40,$JUSTIFY(CNTERR,10),!,"difference: ",?40,$JUSTIFY((CNT-CNTERR),10)
+4 QUIT
ALL ;ALL RECD COUNTED INEGRITY OF "E" XREF VS $O OF 0 NODES
+1 NEW ST,DTE,AP,CNT,ECNT,NCNT,DCNT,XCNT,XEC
+2 SET (CNT,ECNT,NCNT,DCNT,XCNT,XEC)=0
+3 WRITE !,"Analyzing."
+4 FOR AP=0:0
SET AP=$ORDER(^SDEC(409.85,AP))
if 'AP
QUIT
Begin DoDot:1
+5 SET APNODE0=^SDEC(409.85,AP,0)
+6 SET CNT=CNT+1
if CNT#6000=0
WRITE "."
+7 if '$PIECE(APNODE0,U,16)
SET ECNT=ECNT+1
+8 if $PIECE(APNODE0,U,17)=""
SET NCNT=NCNT+1
+9 IF '$PIECE(APNODE0,U,2)
WRITE !,AP,?20,APNODE0
SET DCNT=DCNT+1
End DoDot:1
+10 FOR ST="C","O"
FOR DTE=0:0
SET DTE=$ORDER(^SDEC(409.85,"E",ST,DTE))
if 'DTE
QUIT
Begin DoDot:1
+11 FOR AP=0:0
SET AP=$ORDER(^SDEC(409.85,"E",ST,DTE,AP))
if 'AP
QUIT
SET XCNT=XCNT+1
if '$PIECE(^SDEC(409.85,AP,0),U,16)
SET XEC=XEC+1
End DoDot:1
+12 WRITE !!,"TOTL ",CNT,!,"NCID ",ECNT,!,"NOST ",NCNT,!,"NODT ",DCNT,!!,"XREF ",XCNT,!,"XFIX ",XEC,!!
+13 QUIT
UNDO ;UNDO MY CURRENT UPDATE FOR CID & DIS
+1 NEW AP,ERR,FDA
+2 FOR AP=0:0
SET AP=$ORDER(^XTMP("SD53P754",AP))
if 'AP
QUIT
Begin DoDot:1
+3 WRITE !,AP
+4 ;update the CID/PREFERRED DATE OF APPT date field (#22) in the SDEC APPT REQUEST file (#409.85)
+5 if '$DATA(^XTMP("SD53P754",AP,"AFTER"))
QUIT
+6 WRITE !,AP,"<<<<<<"
+7 SET FDA(409.85,AP_",",22)="@"
+8 DO UPDATE^DIE(,"FDA","ERR")
+9 KILL ^SDEC(409.85,AP,"DIS")
End DoDot:1
+10 QUIT
