PSSPKIPI ;BIR/MHA-DEA/PKI Post-Inst DEA-CS FED SCH mismatch report ;08/08/02
;;1.0;PHARMACY DATA MANAGEMENT;**61**;9/30/97
;Reference to ^PSNDF(50.68 supported by DBIA 3735
START ;
S ZZ="PSSPKI"
K ^XTMP(ZZ,$J) N PSSX,PSSD,PSSJ,PSSK,PSSN,NDR
S PSSX="" F S PSSX=$O(^PSDRUG("B",PSSX)) Q:PSSX="" D
.S PSSN=0 F S PSSN=$O(^PSDRUG("B",PSSX,PSSN)) Q:'PSSN D
..Q:'$D(^PSDRUG(PSSN,0))
..I $P($G(^PSDRUG(PSSN,"I")),"^"),$P($G(^("I")),"^")<DT Q
..;Q:$P($G(^PSDRUG(PSSN,2)),"^",3)'["O"
..S PSSD=$P($G(^PSDRUG(PSSN,0)),"^",3) I PSSD="" D GCS Q
..I PSSD[1!(PSSD[2)!(PSSD[3)!(PSSD[4)!(PSSD[5)!($P($G(^PSDRUG(PSSN,2)),"^",3)["N") S PSSJ=0,NDR="" D D:PSSJ REP
...I PSSD["A"&(PSSD["C"),+PSSD=2!(+PSSD=3) S PSSJ=3 Q
...S PSSL="",PSSK=$P($G(^PSDRUG(PSSN,"ND")),"^",3) I 'PSSK S PSSJ=2 Q
...S PSSL=$$GET1^DIQ(50.68,PSSK,19,"I") Q:'PSSL
...S PSSL=$E(PSSL)_$S(PSSL["n":"C",+PSSL=2!(+PSSL=3):"A",1:"")
...I $L(PSSL)=1,PSSD[PSSL Q
...I PSSD[$E(PSSL),PSSD[$E(PSSL,2) Q
...S PSSJ=1,NDR=$$GET1^DIQ(50.68,PSSK,.01),PSSL=$$GET1^DIQ(50.68,PSSK,19,"I")
D REP4,SM Q
;
GCS S PSSL="",PSSK=$P($G(^PSDRUG(PSSN,"ND")),"^",3) Q:'PSSK
S PSSL=$$GET1^DIQ(50.68,PSSK,19,"I") Q:'PSSL
S PSSL=$E(PSSL)_$S(PSSL["n":"C",+PSSL=2!(+PSSL=3):"A",1:"")
S:+PSSL $P(^PSDRUG(PSSN,0),"^",3)=PSSL
Q
;
REP S ^XTMP(ZZ,$J,PSSJ,PSSX)=NDR_"^"_$P($G(^PSDRUG(PSSN,0)),"^",2)_"^"_PSSD_$S(PSSJ=1:"^"_PSSL,1:"")
Q
SM K ^TMP($J),XMY
F J=1,2,3,4 I $D(^XTMP(ZZ,$J,J)) D
.N S1,S2 S $E(S1,42)="",$E(S2,12)="",K="",$P(UL,"=",79)=""
.D:J=1
..S ^TMP($J,J,1)="The following active Controlled Substances were identified as having a"
..S ^TMP($J,J,2)="discrepancy between the CS FEDERAL SCHEDULE in the VA PRODUCT file (#50.68)"
..S ^TMP($J,J,3)="and the DEA,SPECIAL HDLG code in the DRUG file (#50). You may wish to update"
..S ^TMP($J,J,4)="the DEA,SPECIAL HDLG code for these drugs."
..S ^TMP($J,J,5)=""
..S ^TMP($J,J,6)="PLEASE NOTE: The CS FEDERAL SCHEDULE will only identify DEA, SPECIAL HDLG"
..S ^TMP($J,J,8)="codes of 1, 2A, 2C, 3A, 3C, 4, or 5. In addition to these codes, you may"
..S ^TMP($J,J,9)="also use other DEA, SPECIAL HDLG codes such as L, P,R, S, etc., as needed."
..S ^TMP($J,J,10)="",XX=11
.D:J=2
..S ^TMP($J,J,1)="The following active Controlled Substances have not been matched to NDF."
..S ^TMP($J,J,2)="You may wish to match these drugs."
..S ^TMP($J,J,5)=""
..S ^TMP($J,J,6)="GENERIC NAME",$E(^TMP($J,J,6),43)="VA CLASS",$E(^TMP($J,J,6),53)="CURR DEA, SPECIAL HDLG"
..S ^TMP($J,J,7)=UL,^TMP($J,J,8)="",XX=9
.D:J=3
..S ^TMP($J,J,1)="The following active drugs are defined as Controlled Substances, but"
..S ^TMP($J,J,2)="not classified correctly as Narcotics or Non-Narcotics."
..S ^TMP($J,J,3)="Please make sure they are defined correctly."
..S ^TMP($J,J,5)=""
..S ^TMP($J,J,6)="GENERIC NAME",$E(^TMP($J,J,6),43)="VA CLASS",$E(^TMP($J,J,6),53)="CURR DEA, SPECIAL HDLG"
..S ^TMP($J,J,7)=UL,^TMP($J,J,8)="",XX=9
.D:J=4
..S ^TMP($J,J,1)="The following pharmacy orderable items are associated with active dispense"
..S ^TMP($J,J,2)="drugs that have a discrepancy within their DEA Special Hdlg fields. Please"
..S ^TMP($J,J,3)="correct all entries to identify these orderable items with a specific"
..S ^TMP($J,J,5)="Controlled Substance schedule."
..S ^TMP($J,J,6)=""
..S ^TMP($J,J,7)="PHARMACY ORDERABLE ITEM"
..S ^TMP($J,J,8)=" IEN DISPENSE DRUG",$E(^TMP($J,J,8),52)="DEA SPEC. HDLG",$E(^TMP($J,J,8),67)="CS FED. SCHE."
..S ^TMP($J,J,9)=UL,^TMP($J,J,10)="",XX=11
.F S K=$O(^XTMP(ZZ,$J,J,K)) Q:K="" D
..S:J'=4 QQ=^XTMP(ZZ,$J,J,K)
..I J=1 D PDET Q
..I J=4 D REPN Q
..S ^TMP($J,J,XX)=$E(K_S1,1,42)_$E($P(QQ,"^",2)_S2,1,10)_$E($P(QQ,"^",3)_S2,1,10),XX=XX+1
.S XMY(DUZ)="",XMDUZ="Patch # - DEA/PKI Post-Install"
.I $D(^XUSEC("PSNMGR")) F I=0:0 S I=$O(^XUSEC("PSNMGR",I)) Q:'I S XMY(I)=""
.I J=1 S XMSUB="CS FEDERAL SCHEDULE AND DEA, SPECIAL HDLG DISCREPANCIES"
.I J=2 S XMSUB="CONTROLLED SUBSTANCES NOT MATCHED"
.I J=3 S XMSUB="CONTROLLED SUBSTANCES NOT SET CORRECTLY"
.I J=4 S XMSUB="DISCREPANCY IN DEA WITHIN DRUGS TIED TO AN OI"
.S XMTEXT="^TMP($J,J," N DIFROM ;D ^XMD K XMY,^TMP($J,J)
END K ^XTMP(ZZ,$J),^TMP($J),XMY,XMDUZ
Q
PDET ;
S ^TMP($J,J,XX)="GENERIC NAME: "_K,XX=XX+1
S ^TMP($J,J,XX)="VA PRODUCT NAME: "_$P(QQ,"^"),XX=XX+1
S ^TMP($J,J,XX)="VA CLASS: "_$P(QQ,"^",2),XX=XX+1
S ^TMP($J,J,XX)="CURRENT DEA, SPECIAL HDLG: "_$P(QQ,"^",3),XX=XX+1
S ^TMP($J,J,XX)="CS FEDERAL SCHEDULE: "_$P(QQ,"^",4),XX=XX+1
S ^TMP($J,J,XX)="",XX=XX+1
Q
REP4 ;
N OI S PSSL="" F S PSSL=$O(^PSDRUG("ASP",PSSL)) Q:'PSSL D
.Q:'$D(^PS(50.7,PSSL,0)) S OI=$P(^PS(50.7,PSSL,0),"^")
.S PSSN="" K AR S (I,J)=0 F S PSSN=$O(^PSDRUG("ASP",PSSL,PSSN)) Q:'PSSN D
..Q:'$D(^PSDRUG(PSSN,0))
..I $P($G(^PSDRUG(PSSN,"I")),"^"),$P($G(^("I")),"^")<DT Q
..S PSSD=$P($G(^PSDRUG(PSSN,0)),"^",3)
..Q:PSSD=""
..I PSSD["A"!(PSSD["C") I PSSD[1!(PSSD[2)!(PSSD[3)!(PSSD[4)!(PSSD[5)!($P($G(^PSDRUG(PSSN,2)),"^",3)["N") D
...S PSSK=$P($G(^PSDRUG(PSSN,"ND")),"^",3)
...S:PSSK PSSK=$$GET1^DIQ(50.68,PSSK,19,"I")
...S AR(PSSN)=OI_"^"_PSSL_"^"_PSSN_"^"_$P(^PSDRUG(PSSN,0),"^")_"^"_PSSD_"^"_PSSK
...I PSSD["A" S I=1 Q
...I PSSD["C" S J=1
.I I,J S I="" F S I=$O(AR(I)) Q:'I S AR=AR(I),^XTMP(ZZ,$J,4,$P(AR,"^",1,2),I)=$P(AR,"^",3,6)
Q
REPN ;
S DOS="" S DOS=$P(^PS(50.7,$P(K,"^",2),0),"^",2) I DOS S DOS=$P(^PS(50.606,DOS,0),"^")
S ^TMP($J,J,XX)=$P(K,"^")_" "_DOS,XX=XX+1
S I=0 F S I=$O(^XTMP(ZZ,$J,J,K,I)) Q:'I S QQ=$G(^XTMP(ZZ,$J,J,K,I)) D
.S ^TMP($J,J,XX)=" "_$E(I_" ",1,6)_$E($P(QQ,"^",2)_S1,1,43)_$E($P(QQ,"^",3)_" ",1,13)_$P(QQ,"^",4),XX=XX+1
S ^TMP($J,J,XX)="",XX=XX+1
Q
PSSPKIPI ;BIR/MHA-DEA/PKI Post-Inst DEA-CS FED SCH mismatch report ;08/08/02
+1 ;;1.0;PHARMACY DATA MANAGEMENT;**61**;9/30/97
+2 ;Reference to ^PSNDF(50.68 supported by DBIA 3735
START ;
+1 SET ZZ="PSSPKI"
+2 KILL ^XTMP(ZZ,$JOB)
NEW PSSX,PSSD,PSSJ,PSSK,PSSN,NDR
+3 SET PSSX=""
FOR
SET PSSX=$ORDER(^PSDRUG("B",PSSX))
IF PSSX=""
QUIT
Begin DoDot:1
+4 SET PSSN=0
FOR
SET PSSN=$ORDER(^PSDRUG("B",PSSX,PSSN))
IF 'PSSN
QUIT
Begin DoDot:2
+5 IF '$DATA(^PSDRUG(PSSN,0))
QUIT
+6 IF $PIECE($GET(^PSDRUG(PSSN,"I")),"^")
IF $PIECE($GET(^("I")),"^")<DT
QUIT
+7 ;Q:$P($G(^PSDRUG(PSSN,2)),"^",3)'["O"
+8 SET PSSD=$PIECE($GET(^PSDRUG(PSSN,0)),"^",3)
IF PSSD=""
DO GCS
QUIT
+9 IF PSSD[1!(PSSD[2)!(PSSD[3)!(PSSD[4)!(PSSD[5)!($PIECE($GET(^PSDRUG(PSSN,2)),"^",3)["N")
SET PSSJ=0
SET NDR=""
Begin DoDot:3
+10 IF PSSD["A"&(PSSD["C")
IF +PSSD=2!(+PSSD=3)
SET PSSJ=3
QUIT
+11 SET PSSL=""
SET PSSK=$PIECE($GET(^PSDRUG(PSSN,"ND")),"^",3)
IF 'PSSK
SET PSSJ=2
QUIT
+12 SET PSSL=$$GET1^DIQ(50.68,PSSK,19,"I")
IF 'PSSL
QUIT
+13 SET PSSL=$EXTRACT(PSSL)_$SELECT(PSSL["n":"C",+PSSL=2!(+PSSL=3):"A",1:"")
+14 IF $LENGTH(PSSL)=1
IF PSSD[PSSL
QUIT
+15 IF PSSD[$EXTRACT(PSSL)
IF PSSD[$EXTRACT(PSSL,2)
QUIT
+16 SET PSSJ=1
SET NDR=$$GET1^DIQ(50.68,PSSK,.01)
SET PSSL=$$GET1^DIQ(50.68,PSSK,19,"I")
End DoDot:3
IF PSSJ
DO REP
End DoDot:2
End DoDot:1
+17 DO REP4
DO SM
QUIT
+18 ;
GCS SET PSSL=""
SET PSSK=$PIECE($GET(^PSDRUG(PSSN,"ND")),"^",3)
IF 'PSSK
QUIT
+1 SET PSSL=$$GET1^DIQ(50.68,PSSK,19,"I")
IF 'PSSL
QUIT
+2 SET PSSL=$EXTRACT(PSSL)_$SELECT(PSSL["n":"C",+PSSL=2!(+PSSL=3):"A",1:"")
+3 IF +PSSL
SET $PIECE(^PSDRUG(PSSN,0),"^",3)=PSSL
+4 QUIT
+5 ;
REP SET ^XTMP(ZZ,$JOB,PSSJ,PSSX)=NDR_"^"_$PIECE($GET(^PSDRUG(PSSN,0)),"^",2)_"^"_PSSD_$SELECT(PSSJ=1:"^"_PSSL,1:"")
+1 QUIT
SM KILL ^TMP($JOB),XMY
+1 FOR J=1,2,3,4
IF $DATA(^XTMP(ZZ,$JOB,J))
Begin DoDot:1
+2 NEW S1,S2
SET $EXTRACT(S1,42)=""
SET $EXTRACT(S2,12)=""
SET K=""
SET $PIECE(UL,"=",79)=""
+3 IF J=1
Begin DoDot:2
+4 SET ^TMP($JOB,J,1)="The following active Controlled Substances were identified as having a"
+5 SET ^TMP($JOB,J,2)="discrepancy between the CS FEDERAL SCHEDULE in the VA PRODUCT file (#50.68)"
+6 SET ^TMP($JOB,J,3)="and the DEA,SPECIAL HDLG code in the DRUG file (#50). You may wish to update"
+7 SET ^TMP($JOB,J,4)="the DEA,SPECIAL HDLG code for these drugs."
+8 SET ^TMP($JOB,J,5)=""
+9 SET ^TMP($JOB,J,6)="PLEASE NOTE: The CS FEDERAL SCHEDULE will only identify DEA, SPECIAL HDLG"
+10 SET ^TMP($JOB,J,8)="codes of 1, 2A, 2C, 3A, 3C, 4, or 5. In addition to these codes, you may"
+11 SET ^TMP($JOB,J,9)="also use other DEA, SPECIAL HDLG codes such as L, P,R, S, etc., as needed."
+12 SET ^TMP($JOB,J,10)=""
SET XX=11
End DoDot:2
+13 IF J=2
Begin DoDot:2
+14 SET ^TMP($JOB,J,1)="The following active Controlled Substances have not been matched to NDF."
+15 SET ^TMP($JOB,J,2)="You may wish to match these drugs."
+16 SET ^TMP($JOB,J,5)=""
+17 SET ^TMP($JOB,J,6)="GENERIC NAME"
SET $EXTRACT(^TMP($JOB,J,6),43)="VA CLASS"
SET $EXTRACT(^TMP($JOB,J,6),53)="CURR DEA, SPECIAL HDLG"
+18 SET ^TMP($JOB,J,7)=UL
SET ^TMP($JOB,J,8)=""
SET XX=9
End DoDot:2
+19 IF J=3
Begin DoDot:2
+20 SET ^TMP($JOB,J,1)="The following active drugs are defined as Controlled Substances, but"
+21 SET ^TMP($JOB,J,2)="not classified correctly as Narcotics or Non-Narcotics."
+22 SET ^TMP($JOB,J,3)="Please make sure they are defined correctly."
+23 SET ^TMP($JOB,J,5)=""
+24 SET ^TMP($JOB,J,6)="GENERIC NAME"
SET $EXTRACT(^TMP($JOB,J,6),43)="VA CLASS"
SET $EXTRACT(^TMP($JOB,J,6),53)="CURR DEA, SPECIAL HDLG"
+25 SET ^TMP($JOB,J,7)=UL
SET ^TMP($JOB,J,8)=""
SET XX=9
End DoDot:2
+26 IF J=4
Begin DoDot:2
+27 SET ^TMP($JOB,J,1)="The following pharmacy orderable items are associated with active dispense"
+28 SET ^TMP($JOB,J,2)="drugs that have a discrepancy within their DEA Special Hdlg fields. Please"
+29 SET ^TMP($JOB,J,3)="correct all entries to identify these orderable items with a specific"
+30 SET ^TMP($JOB,J,5)="Controlled Substance schedule."
+31 SET ^TMP($JOB,J,6)=""
+32 SET ^TMP($JOB,J,7)="PHARMACY ORDERABLE ITEM"
+33 SET ^TMP($JOB,J,8)=" IEN DISPENSE DRUG"
SET $EXTRACT(^TMP($JOB,J,8),52)="DEA SPEC. HDLG"
SET $EXTRACT(^TMP($JOB,J,8),67)="CS FED. SCHE."
+34 SET ^TMP($JOB,J,9)=UL
SET ^TMP($JOB,J,10)=""
SET XX=11
End DoDot:2
+35 FOR
SET K=$ORDER(^XTMP(ZZ,$JOB,J,K))
IF K=""
QUIT
Begin DoDot:2
+36 IF J'=4
SET QQ=^XTMP(ZZ,$JOB,J,K)
+37 IF J=1
DO PDET
QUIT
+38 IF J=4
DO REPN
QUIT
+39 SET ^TMP($JOB,J,XX)=$EXTRACT(K_S1,1,42)_$EXTRACT($PIECE(QQ,"^",2)_S2,1,10)_$EXTRACT($PIECE(QQ,"^",3)_S2,1,10)
SET XX=XX+1
End DoDot:2
+40 SET XMY(DUZ)=""
SET XMDUZ="Patch # - DEA/PKI Post-Install"
+41 IF $DATA(^XUSEC("PSNMGR"))
FOR I=0:0
SET I=$ORDER(^XUSEC("PSNMGR",I))
IF 'I
QUIT
SET XMY(I)=""
+42 IF J=1
SET XMSUB="CS FEDERAL SCHEDULE AND DEA, SPECIAL HDLG DISCREPANCIES"
+43 IF J=2
SET XMSUB="CONTROLLED SUBSTANCES NOT MATCHED"
+44 IF J=3
SET XMSUB="CONTROLLED SUBSTANCES NOT SET CORRECTLY"
+45 IF J=4
SET XMSUB="DISCREPANCY IN DEA WITHIN DRUGS TIED TO AN OI"
+46 ;D ^XMD K XMY,^TMP($J,J)
SET XMTEXT="^TMP($J,J,"
NEW DIFROM
End DoDot:1
END KILL ^XTMP(ZZ,$JOB),^TMP($JOB),XMY,XMDUZ
+1 QUIT
PDET ;
+1 SET ^TMP($JOB,J,XX)="GENERIC NAME: "_K
SET XX=XX+1
+2 SET ^TMP($JOB,J,XX)="VA PRODUCT NAME: "_$PIECE(QQ,"^")
SET XX=XX+1
+3 SET ^TMP($JOB,J,XX)="VA CLASS: "_$PIECE(QQ,"^",2)
SET XX=XX+1
+4 SET ^TMP($JOB,J,XX)="CURRENT DEA, SPECIAL HDLG: "_$PIECE(QQ,"^",3)
SET XX=XX+1
+5 SET ^TMP($JOB,J,XX)="CS FEDERAL SCHEDULE: "_$PIECE(QQ,"^",4)
SET XX=XX+1
+6 SET ^TMP($JOB,J,XX)=""
SET XX=XX+1
+7 QUIT
REP4 ;
+1 NEW OI
SET PSSL=""
FOR
SET PSSL=$ORDER(^PSDRUG("ASP",PSSL))
IF 'PSSL
QUIT
Begin DoDot:1
+2 IF '$DATA(^PS(50.7,PSSL,0))
QUIT
SET OI=$PIECE(^PS(50.7,PSSL,0),"^")
+3 SET PSSN=""
KILL AR
SET (I,J)=0
FOR
SET PSSN=$ORDER(^PSDRUG("ASP",PSSL,PSSN))
IF 'PSSN
QUIT
Begin DoDot:2
+4 IF '$DATA(^PSDRUG(PSSN,0))
QUIT
+5 IF $PIECE($GET(^PSDRUG(PSSN,"I")),"^")
IF $PIECE($GET(^("I")),"^")<DT
QUIT
+6 SET PSSD=$PIECE($GET(^PSDRUG(PSSN,0)),"^",3)
+7 IF PSSD=""
QUIT
+8 IF PSSD["A"!(PSSD["C")
IF PSSD[1!(PSSD[2)!(PSSD[3)!(PSSD[4)!(PSSD[5)!($PIECE($GET(^PSDRUG(PSSN,2)),"^",3)["N")
Begin DoDot:3
+9 SET PSSK=$PIECE($GET(^PSDRUG(PSSN,"ND")),"^",3)
+10 IF PSSK
SET PSSK=$$GET1^DIQ(50.68,PSSK,19,"I")
+11 SET AR(PSSN)=OI_"^"_PSSL_"^"_PSSN_"^"_$PIECE(^PSDRUG(PSSN,0),"^")_"^"_PSSD_"^"_PSSK
+12 IF PSSD["A"
SET I=1
QUIT
+13 IF PSSD["C"
SET J=1
End DoDot:3
End DoDot:2
+14 IF I
IF J
SET I=""
FOR
SET I=$ORDER(AR(I))
IF 'I
QUIT
SET AR=AR(I)
SET ^XTMP(ZZ,$JOB,4,$PIECE(AR,"^",1,2),I)=$PIECE(AR,"^",3,6)
End DoDot:1
+15 QUIT
REPN ;
+1 SET DOS=""
SET DOS=$PIECE(^PS(50.7,$PIECE(K,"^",2),0),"^",2)
IF DOS
SET DOS=$PIECE(^PS(50.606,DOS,0),"^")
+2 SET ^TMP($JOB,J,XX)=$PIECE(K,"^")_" "_DOS
SET XX=XX+1
+3 SET I=0
FOR
SET I=$ORDER(^XTMP(ZZ,$JOB,J,K,I))
IF 'I
QUIT
SET QQ=$GET(^XTMP(ZZ,$JOB,J,K,I))
Begin DoDot:1
+4 SET ^TMP($JOB,J,XX)=" "_$EXTRACT(I_" ",1,6)_$EXTRACT($PIECE(QQ,"^",2)_S1,1,43)_$EXTRACT($PIECE(QQ,"^",3)_" ",1,13)_$PIECE(QQ,"^",4)
SET XX=XX+1
End DoDot:1
+5 SET ^TMP($JOB,J,XX)=""
SET XX=XX+1
+6 QUIT
