ORELR1 ; slc/dcm - Cross check/update file 100 with file 69
;;3.0;ORDER ENTRY/RESULTS REPORTING;**20,42**;Dec 17, 1997
EN ;Fix inconsistencies from ^OR to ^LRO(69
W !,"This utility will look for inconsistencies between OE/RR 3.0 and Lab files."
W !,"It will compare records in the Orders file (100) with the Lab Order file (69)."
W !!,"Problems identified",?53,"Resolution"
W !,"-------------------",?53,"----------"
W !,"^OR(100,IFN,0) does not exist",?53,"^OR(100,IFN) killed"
W !,"Bad pointers on child orders",?53,"Pointers removed"
W !,"Child orders with no parent order",?53,"Pointer removed"
W !,"Child order missing parent pointer",?53,"Pointer restored"
W !,"Incorrect status on parent order",?53,"Status corrected"
W !,"Old veiled orders",?53,"Purged"
W !,"Unrecognized pointer to file 69",?53,"Order cancelled"
W !,"Unconverted orders from OE/RR 2.5",?53,"Order lapsed"
W !,"Invalid pointer to file 69",?53,"Order cancelled"
W !,"Incorrect status on uncollected specimens",?53,"Status updated"
W !,"Incorrect status on completed orders",?53,"Status updated"
W !,"Missing reference to file 69",?53,"Cancelled (optional)"
W !,"Old pending, active & unreleased orders",?53,"Status changed"
W !!,"Continue"
N %,I,ORLOR,ORPEND,ORPENDT,ORIFN,ORAFIX,ZTSAVE
S %=2 D YN^DICN Q:%'=1
LRO W !,"Check for CPRS orders that no longer exist in the Lab Order file"
S ORLRO=0,%=2 D YN^DICN Q:%=-1 S:%=1 ORLRO=1 I %=0 W !!,"You may want to cancel any active orders that no longer have a valid",!,"reference to file 69 (may have been purged from lab files).",! G LRO
CAN S ORPEND=0,ORPENDT=0
W !,"Do you want to remove old PENDING, ACTIVE and UNRELEASED orders" S %=2 D YN^DICN Q:%=-1 S:%=1 ORPEND=1
I %=0 W !!,"Unreleased orders are removed from the system.",!,"Old pending orders are changed to a Lapsed status, which will",!,"remove them from the current orders context."
I %=0 W !,"Active orders that no longer have corresponding entries in the lab files",!,"are changed to Lapsed" G CAN
I ORPEND S %DT="AEQ",%DT("A")="Remove old orders with Start dates before: ",%DT("B")="T-30" D ;_$S($P($G(^ORD(100.99,1,2)),"^",16):$P(^(2),"^",16),1:30) D
. N % D ^%DT
. I Y<0 S ORPEND=0 W !!,"Old orders will not be removed." Q
. S ORPEND=1,ORPENDT=Y
S ORIFN=0,%=2 ;,X=$P($G(^ORD(100.99,1,2)),"^",12) I X W !,"Do you want to start where the last clean-up left off (#"_X_")" S %=1 D YN^DICN Q:%=-1 S:%=1 ORIFN=X
I %=2 W !,"OK, which ORIFN do you want to start with: 0// " R X:DTIME Q:'$T S:X=""!(X=0) X=.1 Q:'X S ORIFN=X
FIX W !,"Do you want me to correct the inconsistencies now"
S ORAFIX=0,%=2 D YN^DICN Q:%=-1 S:%=1 ORAFIX=1 I %=0 W !!,"Answer 'YES' to correct them now, or 'NO' to just display them.",! G FIX
F I="ORLRO","ORPEND","ORPENDT","ORIFN","ORAFIX" S ZTSAVE(I)=""
D QUE^ORUTL1("DEQUE^ORELR1","Check from 100 to 69",.ZTSAVE)
Q
DEQUE ;Queued entry point
N SIBCNT,SIBPCNT,NOCNT,OCNT,UNCNT,TTCNT,PHCNT,ICNT,WICNT,BSCNT,DCNT,CNT,PCNT,APCNT,A,UCNT,END,ORDUZ,PTCNT,HCNT,NCNT,VCNT,UCCNT,IVCNT,ICNT,ACNT,ICCNT,STCNT,LCNT,PKG,ORSICK
S (SIBCNT,SIBPCNT,NOCNT,OCNT,UNCNT,TTCNT,PHCNT,ICNT,WICNT,BSCNT,DCNT,CNT,PCNT,APCNT,UCNT,END,ORDUZ,PTCNT,HCNT,NCNT,VCNT,UCCNT,IVCNT,ICNT,ACNT,ICCNT,STCNT,LCNT)=0,PKG=$O(^DIC(9.4,"B","LAB SERVICE",0)) Q:PKG=""
D NOW^%DTC
I '$D(DT) S DT=X
U IO
W !,"Inconsistency report between OE/RR (100) and LAB (69) files..."
W !,"Date/time Started: "_$$DATETIME^ORU(%)
W !,"Now looking for data..."
F S ORIFN=$O(^OR(100,ORIFN)) Q:ORIFN<1 S ORSICK=ORIFN D A^ORELR2 S ORIFN=ORSICK Q:END
W:IOSL-$Y<25 @IOF
W !!,"Total inconsistencies: "_TTCNT
W !,"Date/time Completed: "_$$DATETIME^ORU($$NOW^XLFDT())
W:DCNT !,"Wrong Patient Total: "_DCNT
W:PCNT !,"Old Pending orders total: "_PCNT
W:APCNT !,"Old Active orders total: "_APCNT
W:UCNT !,"Old Unreleased orders total: "_UCNT
W:UNCNT !,"Unconverted 2.5 orders total: "_UNCNT
W:PTCNT !,"Parent status update total: "_PTCNT
W:HCNT !,"Bad child pointer total: "_HCNT
W:NCNT !,"Orders with no status total: "_NCNT
W:VCNT !,"Old veiled orders: "_VCNT
W:UCCNT !,"Unrecognized package link: "_UCCNT
W:BSCNT !,"Bad package link ,null status: "_BSCNT
W:IVCNT !,"Invalid package link: "_IVCNT
W:WICNT !,"No enterer: "_WICNT
W:PHCNT !,"No physician: "_PHCNT
W:ICNT !,"Incorrect status: "_ICNT
W:ACNT !,"Active canceled orders: "_ACNT
W:ICCNT !,"Incomplete should be complete: "_ICCNT
W:STCNT !,"Status should be complete: "_STCNT
W:LCNT !,"Missing reference in 69: "_LCNT
W:NOCNT !,"No order # in 69: "_NOCNT
W:OCNT !,"Missing pointer to 100: "_OCNT
W:SIBCNT !,"Child with no parent: "_SIBCNT
W:SIBPCNT !,"Child orders with wrong parent pointer: "_SIBPCNT
K ORLRO,ORPEND,ORPENDT,ORIFN,ORAFIX
I $D(ZTQUEUED) S ZTREQ="@"
Q
ORELR1 ; slc/dcm - Cross check/update file 100 with file 69
+1 ;;3.0;ORDER ENTRY/RESULTS REPORTING;**20,42**;Dec 17, 1997
EN ;Fix inconsistencies from ^OR to ^LRO(69
+1 WRITE !,"This utility will look for inconsistencies between OE/RR 3.0 and Lab files."
+2 WRITE !,"It will compare records in the Orders file (100) with the Lab Order file (69)."
+3 WRITE !!,"Problems identified",?53,"Resolution"
+4 WRITE !,"-------------------",?53,"----------"
+5 WRITE !,"^OR(100,IFN,0) does not exist",?53,"^OR(100,IFN) killed"
+6 WRITE !,"Bad pointers on child orders",?53,"Pointers removed"
+7 WRITE !,"Child orders with no parent order",?53,"Pointer removed"
+8 WRITE !,"Child order missing parent pointer",?53,"Pointer restored"
+9 WRITE !,"Incorrect status on parent order",?53,"Status corrected"
+10 WRITE !,"Old veiled orders",?53,"Purged"
+11 WRITE !,"Unrecognized pointer to file 69",?53,"Order cancelled"
+12 WRITE !,"Unconverted orders from OE/RR 2.5",?53,"Order lapsed"
+13 WRITE !,"Invalid pointer to file 69",?53,"Order cancelled"
+14 WRITE !,"Incorrect status on uncollected specimens",?53,"Status updated"
+15 WRITE !,"Incorrect status on completed orders",?53,"Status updated"
+16 WRITE !,"Missing reference to file 69",?53,"Cancelled (optional)"
+17 WRITE !,"Old pending, active & unreleased orders",?53,"Status changed"
+18 WRITE !!,"Continue"
+19 NEW %,I,ORLOR,ORPEND,ORPENDT,ORIFN,ORAFIX,ZTSAVE
+20 SET %=2
DO YN^DICN
IF %'=1
QUIT
LRO WRITE !,"Check for CPRS orders that no longer exist in the Lab Order file"
+1 SET ORLRO=0
SET %=2
DO YN^DICN
IF %=-1
QUIT
IF %=1
SET ORLRO=1
IF %=0
WRITE !!,"You may want to cancel any active orders that no longer have a valid",!,"reference to file 69 (may have been purged from lab files).",!
GOTO LRO
CAN SET ORPEND=0
SET ORPENDT=0
+1 WRITE !,"Do you want to remove old PENDING, ACTIVE and UNRELEASED orders"
SET %=2
DO YN^DICN
IF %=-1
QUIT
IF %=1
SET ORPEND=1
+2 IF %=0
WRITE !!,"Unreleased orders are removed from the system.",!,"Old pending orders are changed to a Lapsed status, which will",!,"remove them from the current orders context."
+3 IF %=0
WRITE !,"Active orders that no longer have corresponding entries in the lab files",!,"are changed to Lapsed"
GOTO CAN
+4 ;_$S($P($G(^ORD(100.99,1,2)),"^",16):$P(^(2),"^",16),1:30) D
IF ORPEND
SET %DT="AEQ"
SET %DT("A")="Remove old orders with Start dates before: "
SET %DT("B")="T-30"
Begin DoDot:1
+5 NEW %
DO ^%DT
+6 IF Y<0
SET ORPEND=0
WRITE !!,"Old orders will not be removed."
QUIT
+7 SET ORPEND=1
SET ORPENDT=Y
End DoDot:1
+8 ;,X=$P($G(^ORD(100.99,1,2)),"^",12) I X W !,"Do you want to start where the last clean-up left off (#"_X_")" S %=1 D YN^DICN Q:%=-1 S:%=1 ORIFN=X
SET ORIFN=0
SET %=2
+9 IF %=2
WRITE !,"OK, which ORIFN do you want to start with: 0// "
READ X:DTIME
IF '$TEST
QUIT
IF X=""!(X=0)
SET X=.1
IF 'X
QUIT
SET ORIFN=X
FIX WRITE !,"Do you want me to correct the inconsistencies now"
+1 SET ORAFIX=0
SET %=2
DO YN^DICN
IF %=-1
QUIT
IF %=1
SET ORAFIX=1
IF %=0
WRITE !!,"Answer 'YES' to correct them now, or 'NO' to just display them.",!
GOTO FIX
+2 FOR I="ORLRO","ORPEND","ORPENDT","ORIFN","ORAFIX"
SET ZTSAVE(I)=""
+3 DO QUE^ORUTL1("DEQUE^ORELR1","Check from 100 to 69",.ZTSAVE)
+4 QUIT
DEQUE ;Queued entry point
+1 NEW SIBCNT,SIBPCNT,NOCNT,OCNT,UNCNT,TTCNT,PHCNT,ICNT,WICNT,BSCNT,DCNT,CNT,PCNT,APCNT,A,UCNT,END,ORDUZ,PTCNT,HCNT,NCNT,VCNT,UCCNT,IVCNT,ICNT,ACNT,ICCNT,STCNT,LCNT,PKG,ORSICK
+2 SET (SIBCNT,SIBPCNT,NOCNT,OCNT,UNCNT,TTCNT,PHCNT,ICNT,WICNT,BSCNT,DCNT,CNT,PCNT,APCNT,UCNT,END,ORDUZ,PTCNT,HCNT,NCNT,VCNT,UCCNT,IVCNT,ICNT,ACNT,ICCNT,STCNT,LCNT)=0
SET PKG=$ORDER(^DIC(9.4,"B","LAB SERVICE",0))
IF PKG=""
QUIT
+3 DO NOW^%DTC
+4 IF '$DATA(DT)
SET DT=X
+5 USE IO
+6 WRITE !,"Inconsistency report between OE/RR (100) and LAB (69) files..."
+7 WRITE !,"Date/time Started: "_$$DATETIME^ORU(%)
+8 WRITE !,"Now looking for data..."
+9 FOR
SET ORIFN=$ORDER(^OR(100,ORIFN))
IF ORIFN<1
QUIT
SET ORSICK=ORIFN
DO A^ORELR2
SET ORIFN=ORSICK
IF END
QUIT
+10 IF IOSL-$Y<25
WRITE @IOF
+11 WRITE !!,"Total inconsistencies: "_TTCNT
+12 WRITE !,"Date/time Completed: "_$$DATETIME^ORU($$NOW^XLFDT())
+13 IF DCNT
WRITE !,"Wrong Patient Total: "_DCNT
+14 IF PCNT
WRITE !,"Old Pending orders total: "_PCNT
+15 IF APCNT
WRITE !,"Old Active orders total: "_APCNT
+16 IF UCNT
WRITE !,"Old Unreleased orders total: "_UCNT
+17 IF UNCNT
WRITE !,"Unconverted 2.5 orders total: "_UNCNT
+18 IF PTCNT
WRITE !,"Parent status update total: "_PTCNT
+19 IF HCNT
WRITE !,"Bad child pointer total: "_HCNT
+20 IF NCNT
WRITE !,"Orders with no status total: "_NCNT
+21 IF VCNT
WRITE !,"Old veiled orders: "_VCNT
+22 IF UCCNT
WRITE !,"Unrecognized package link: "_UCCNT
+23 IF BSCNT
WRITE !,"Bad package link ,null status: "_BSCNT
+24 IF IVCNT
WRITE !,"Invalid package link: "_IVCNT
+25 IF WICNT
WRITE !,"No enterer: "_WICNT
+26 IF PHCNT
WRITE !,"No physician: "_PHCNT
+27 IF ICNT
WRITE !,"Incorrect status: "_ICNT
+28 IF ACNT
WRITE !,"Active canceled orders: "_ACNT
+29 IF ICCNT
WRITE !,"Incomplete should be complete: "_ICCNT
+30 IF STCNT
WRITE !,"Status should be complete: "_STCNT
+31 IF LCNT
WRITE !,"Missing reference in 69: "_LCNT
+32 IF NOCNT
WRITE !,"No order # in 69: "_NOCNT
+33 IF OCNT
WRITE !,"Missing pointer to 100: "_OCNT
+34 IF SIBCNT
WRITE !,"Child with no parent: "_SIBCNT
+35 IF SIBPCNT
WRITE !,"Child orders with wrong parent pointer: "_SIBPCNT
+36 KILL ORLRO,ORPEND,ORPENDT,ORIFN,ORAFIX
+37 IF $DATA(ZTQUEUED)
SET ZTREQ="@"
+38 QUIT
