BUD9RP7T ; IHS/CMI/LAB - UDS REPORT DRIVER TABLE 6B ;
;;10.0;IHS/RPMS UNIFORM DATA SYSTEM;;FEB 04, 2016;Build 50
;
;
PAUSE ;
K DIR S DIR(0)="E",DIR("A")="PRESS ENTER" KILL DA D ^DIR KILL DIR
Q
GENI ;general introductions
W !,"NOTE: Patient lists may be hundreds of pages long, depending on the size of your"
W !,"patient population. It is recommended that you run these reports at night and"
W !,"print to an electronic file, not directly to a printer.",!
K DIR S DIR(0)="E",DIR("A")="Press Enter to Continue" D ^DIR K DIR
W !!,"This Patient List option documents the individual patients and visits"
W !,"that are counted and summarized on each Table report (main menu"
W !,"option REP). The summary Table report is included at the beginning of each"
W !,"List report."
W !,"UDS searches your database to find all visits and related patients"
W !,"during the time period selected. Based on the UDS definition, to be counted"
W !,"as a patient, the patient must have had at least one visit meeting the "
W !,"following criteria:"
W !?4,"- must be to a location specified in your visit location setup"
W !?4,"- must be to Service Category Ambulatory (A), Hospitalization (H), Day"
W !?6,"Surgery (S), Observation (O), Telemedicine (M), Nursing home visit (R), "
W !?6,"or In-Hospital (I) visit"
W !?4,"- must NOT have an excluded clinic code (see User Manual for a list)"
W !?4,"- must have a primary provider and a coded purpose of visit"
W !
Q
;
CTR(X,Y) ;EP - Center X in a field Y wide.
Q $J("",$S($D(Y):Y,1:IOM)-$L(X)\2)_X
;----------
USR() ;EP - Return name of current user from ^VA(200.
Q $S($G(DUZ):$S($D(^VA(200,DUZ,0)):$P(^(0),U),1:"UNKNOWN"),1:"DUZ UNDEFINED OR 0")
;----------
LOC() ;EP - Return location name from file 4 based on DUZ(2).
Q $S($G(DUZ(2)):$S($D(^DIC(4,DUZ(2),0)):$P(^(0),U),1:"UNKNOWN"),1:"DUZ(2) UNDEFINED OR 0")
;----------
;
;
DMR3 ;EP
W:$D(IOF) @IOF
W !,$$CTR($$LOC,80)
W !,$$CTR("UDS 2009",80)
W !!,"All Patients w/DM and A1c >9 by Race and Hispanic or Latino Identity (Table 7)",!
D GENI
D PAUSE
W !!,"This report provides a list by race and Hispanic or Latino Identity of "
W !,"patients age 18 to 75 years old who have had two"
W !,"medical visits during the report period, with a diagnosis"
W !,"of Type I or Type II diabetes anytime through the end of the report"
W !,"period, and without a diagnosis of polycystic ovaries, gestational diabetes,"
W !,"or steroid-induced diabetes and with a most recent hemoglobin A1c greater"
W !,"than 9%, or with an A1c with no result, or with no A1c test during the"
W !,"report period."
W !
Q
DMR3L ;EP
S BUDP=0,BUDQUIT=0,BUDTOT=0
D DMR3H Q:BUDQUIT
I '$D(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3")) W !!,"No patients to report." Q
D DMR3L1
I $Y>(IOSL-3) D DMR3H G:BUDQUIT DMR3LX
W !!,"TOTAL DM PATIENTS 18+ W/A1C >9%: ",BUDTOT,!
DMR3LX ;
Q
DMR3L1 ;
I $Y>(IOSL-7) D DMR3H Q:BUDQUIT
S BUDTOT=0
S BUDRACE="" F S BUDRACE=$O(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE)) Q:BUDRACE=""!(BUDQUIT) D
.S BUDETH="" F S BUDETH=$O(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH)) Q:BUDETH=""!(BUDQUIT) D DMR3L2
Q
DMR3L2 ;
S BUDSTOT=0
S BUDRACEL=$$RACEL^BUD9RP7I(BUDRACE,BUDETH)
W !,BUDRACEL
S BUDCOM="" F S BUDCOM=$O(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM)) Q:BUDCOM=""!(BUDQUIT) D
.S BUDA="" F S BUDA=$O(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA)) Q:BUDA=""!(BUDQUIT) D
..S BUDNAME="" F S BUDNAME=$O(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA,BUDNAME)) Q:BUDNAME=""!(BUDQUIT) D
...S DFN=0 F S DFN=$O(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA,BUDNAME,DFN)) Q:DFN'=+DFN!(BUDQUIT) D
....I $Y>(IOSL-3) D DMR3H Q:BUDQUIT W !,BUDRACEL,!
....W !?2,$E($P(^DPT(DFN,0),U,1),1,20),?24,$S($$HRN^AUPNPAT(DFN,BUDSITE)]"":$$HRN^AUPNPAT(DFN,BUDSITE,2),1:$$HRN^AUPNPAT(DFN,DUZ(2),2)),?36,$E(BUDCOM,1,10),?47,BUDA,! ;,?51,$P($$RACE^BUD9RPTC(DFN),U,3)_"-"_$P($$RACE^BUD9RPTC(DFN),U,4),!
....S BUDTOT=BUDTOT+1,BUDSTOT=BUDSTOT+1
....S BUDRACV=$$RACE^BUD9RPTC(DFN)
....W ?2,$E($P(BUDRACV,U,4),1,16)_" ("_$P(BUDRACV,U,3),")" ;,?60,$E($P($$RACE^BUD9RPTC(DFN),U,3)_"-"_$P($$RACE^BUD9RPTC(DFN),U,4),1,19)
....S BUDHISV=$$HISP^BUD9RPTC(DFN)
....W ?24,$P(BUDHISV,U,3)," (",$P(BUDHISV,U,2),")",!
....S BUDALL=^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA,BUDNAME,DFN)
....S BUDPPV=$P(BUDALL,"^",1)
....W ?5,$P(BUDALL,"^",2),!
....F BUDX=1:1 S BUDV=$P(BUDPPV,U,BUDX) Q:BUDV=""!(BUDQUIT) D
.....I $Y>(IOSL-3) D DMR3H Q:BUDQUIT W !,BUDRACEL,!
.....I $E(BUDV)="P" W ?5,BUDV,! Q
.....S V=$P(BUDV,"|"),C=$P(BUDV,"|",2)
.....W ?5,$$FMTE^XLFDT($P($P(^AUPNVSIT(V,0),U),".")),?19,C,?35,$$PRIMPROV^APCLV(V,"D"),?45,$P(^AUPNVSIT(V,0),U,7),?53,$$CLINIC^APCLV(V,"C"),?65,$E($$VAL^XBDIQ1(9000010,V,.06),1,15),!
I $Y>(IOSL-4) D DMR3H Q:BUDQUIT W !,BUDRACEL,!
W !,"Sub-Total ",BUDRACEL,": ",BUDSTOT,!
Q
DMR3H ;
G:'BUDGPG DMR3H1
K DIR I $E(IOST)="C",IO=IO(0),'$D(ZTQUEUED) W ! S DIR(0)="EO" D ^DIR K DIR I Y=0!(Y="^")!($D(DTOUT)) S BUDQUIT=1 Q
DMR3H1 ;
W:$D(IOF) @IOF S BUDGPG=BUDGPG+1
W !,"***** CONFIDENTIAL PATIENT INFORMATION, COVERED BY THE PRIVACY ACT *****"
W !?3,$P(^VA(200,DUZ,0),U,2),?35,$$FMTE^XLFDT(DT),?70,"Page ",BUDGPG,!
W !,$$CTR("*** RPMS Uniform Data System (UDS) ***",80)
W !,$$CTR("Patient List for Table 7, Section C, DM w/A1c >9 by Race",80),!
W $$CTR($P(^DIC(4,BUDSITE,0),U),80),!
S X="Reporting Period: "_$$FMTE^XLFDT(BUDBD)_" to "_$$FMTE^XLFDT(BUDED) W $$CTR(X,80),!
W $TR($J("",80)," ","-")
I BUDP=0 D
.W !,"List by race of patients age 18 and older who have had two medical visits"
.W !,"during the report period and were diagnosed with Type I or Type II diabetes"
.W !,"anytime through the end of the report period and whose most recent"
.W !,"hemoglobin A1c is >9%, or did not have a result, or the patient did not"
.W !,"have an A1c test during the report period."
.W !,"Age is calculated as of December 31."
.W !,"* E - denotes the value was obtained from the Ethnicity field."
.W !," R - denotes the value was obtained from the Race field"
.W !," C - denotes the value was obtained from the Classification/Beneficiary field"
.W !
W !?2,"PATIENT NAME",?24,"HRN",?36,"COMMUNITY",?47,"SEX",?51,"AGE"
W !?2,"RACE*",?24,"HISPANIC OR LATINO IDENTITY*"
W !?5,"LAST A1C VALUE OR CD & DATE"
W !?5,"LAST DM DATE",?19,"DX OR SVC CD",?35,"PROV TYPE",?45,"SVC CAT",?53,"CLINIC",?65,"LOCATION"
W !,$TR($J("",80)," ","-"),!
S BUDP=1
Q
;
BUD9RP7T ; IHS/CMI/LAB - UDS REPORT DRIVER TABLE 6B ;
+1 ;;10.0;IHS/RPMS UNIFORM DATA SYSTEM;;FEB 04, 2016;Build 50
+2 ;
+3 ;
PAUSE ;
+1 KILL DIR
SET DIR(0)="E"
SET DIR("A")="PRESS ENTER"
KILL DA
DO ^DIR
KILL DIR
+2 QUIT
GENI ;general introductions
+1 WRITE !,"NOTE: Patient lists may be hundreds of pages long, depending on the size of your"
+2 WRITE !,"patient population. It is recommended that you run these reports at night and"
+3 WRITE !,"print to an electronic file, not directly to a printer.",!
+4 KILL DIR
SET DIR(0)="E"
SET DIR("A")="Press Enter to Continue"
DO ^DIR
KILL DIR
+5 WRITE !!,"This Patient List option documents the individual patients and visits"
+6 WRITE !,"that are counted and summarized on each Table report (main menu"
+7 WRITE !,"option REP). The summary Table report is included at the beginning of each"
+8 WRITE !,"List report."
+9 WRITE !,"UDS searches your database to find all visits and related patients"
+10 WRITE !,"during the time period selected. Based on the UDS definition, to be counted"
+11 WRITE !,"as a patient, the patient must have had at least one visit meeting the "
+12 WRITE !,"following criteria:"
+13 WRITE !?4,"- must be to a location specified in your visit location setup"
+14 WRITE !?4,"- must be to Service Category Ambulatory (A), Hospitalization (H), Day"
+15 WRITE !?6,"Surgery (S), Observation (O), Telemedicine (M), Nursing home visit (R), "
+16 WRITE !?6,"or In-Hospital (I) visit"
+17 WRITE !?4,"- must NOT have an excluded clinic code (see User Manual for a list)"
+18 WRITE !?4,"- must have a primary provider and a coded purpose of visit"
+19 WRITE !
+20 QUIT
+21 ;
CTR(X,Y) ;EP - Center X in a field Y wide.
+1 QUIT $JUSTIFY("",$SELECT($DATA(Y):Y,1:IOM)-$LENGTH(X)\2)_X
+2 ;----------
USR() ;EP - Return name of current user from ^VA(200.
+1 QUIT $SELECT($GET(DUZ):$SELECT($DATA(^VA(200,DUZ,0)):$PIECE(^(0),U),1:"UNKNOWN"),1:"DUZ UNDEFINED OR 0")
+2 ;----------
LOC() ;EP - Return location name from file 4 based on DUZ(2).
+1 QUIT $SELECT($GET(DUZ(2)):$SELECT($DATA(^DIC(4,DUZ(2),0)):$PIECE(^(0),U),1:"UNKNOWN"),1:"DUZ(2) UNDEFINED OR 0")
+2 ;----------
+3 ;
+4 ;
DMR3 ;EP
+1 IF $DATA(IOF)
WRITE @IOF
+2 WRITE !,$$CTR($$LOC,80)
+3 WRITE !,$$CTR("UDS 2009",80)
+4 WRITE !!,"All Patients w/DM and A1c >9 by Race and Hispanic or Latino Identity (Table 7)",!
+5 DO GENI
+6 DO PAUSE
+7 WRITE !!,"This report provides a list by race and Hispanic or Latino Identity of "
+8 WRITE !,"patients age 18 to 75 years old who have had two"
+9 WRITE !,"medical visits during the report period, with a diagnosis"
+10 WRITE !,"of Type I or Type II diabetes anytime through the end of the report"
+11 WRITE !,"period, and without a diagnosis of polycystic ovaries, gestational diabetes,"
+12 WRITE !,"or steroid-induced diabetes and with a most recent hemoglobin A1c greater"
+13 WRITE !,"than 9%, or with an A1c with no result, or with no A1c test during the"
+14 WRITE !,"report period."
+15 WRITE !
+16 QUIT
DMR3L ;EP
+1 SET BUDP=0
SET BUDQUIT=0
SET BUDTOT=0
+2 DO DMR3H
IF BUDQUIT
QUIT
+3 IF '$DATA(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3"))
WRITE !!,"No patients to report."
QUIT
+4 DO DMR3L1
+5 IF $Y>(IOSL-3)
DO DMR3H
IF BUDQUIT
GOTO DMR3LX
+6 WRITE !!,"TOTAL DM PATIENTS 18+ W/A1C >9%: ",BUDTOT,!
DMR3LX ;
+1 QUIT
DMR3L1 ;
+1 IF $Y>(IOSL-7)
DO DMR3H
IF BUDQUIT
QUIT
+2 SET BUDTOT=0
+3 SET BUDRACE=""
FOR
SET BUDRACE=$ORDER(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE))
IF BUDRACE=""!(BUDQUIT)
QUIT
Begin DoDot:1
+4 SET BUDETH=""
FOR
SET BUDETH=$ORDER(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH))
IF BUDETH=""!(BUDQUIT)
QUIT
DO DMR3L2
End DoDot:1
+5 QUIT
DMR3L2 ;
+1 SET BUDSTOT=0
+2 SET BUDRACEL=$$RACEL^BUD9RP7I(BUDRACE,BUDETH)
+3 WRITE !,BUDRACEL
+4 SET BUDCOM=""
FOR
SET BUDCOM=$ORDER(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM))
IF BUDCOM=""!(BUDQUIT)
QUIT
Begin DoDot:1
+5 SET BUDA=""
FOR
SET BUDA=$ORDER(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA))
IF BUDA=""!(BUDQUIT)
QUIT
Begin DoDot:2
+6 SET BUDNAME=""
FOR
SET BUDNAME=$ORDER(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA,BUDNAME))
IF BUDNAME=""!(BUDQUIT)
QUIT
Begin DoDot:3
+7 SET DFN=0
FOR
SET DFN=$ORDER(^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA,BUDNAME,DFN))
IF DFN'=+DFN!(BUDQUIT)
QUIT
Begin DoDot:4
+8 IF $Y>(IOSL-3)
DO DMR3H
IF BUDQUIT
QUIT
WRITE !,BUDRACEL,!
+9 ;,?51,$P($$RACE^BUD9RPTC(DFN),U,3)_"-"_$P($$RACE^BUD9RPTC(DFN),U,4),!
WRITE !?2,$EXTRACT($PIECE(^DPT(DFN,0),U,1),1,20),?24,$SELECT($$HRN^AUPNPAT(DFN,BUDSITE)]"":$$HRN^AUPNPAT(DFN,BUDSITE,2),1:$$HRN^AUPNPAT(DFN,DUZ(2),2)),?36,$EXTRACT(BUDCOM,1,10),?47,BUDA,!
+10 SET BUDTOT=BUDTOT+1
SET BUDSTOT=BUDSTOT+1
+11 SET BUDRACV=$$RACE^BUD9RPTC(DFN)
+12 ;,?60,$E($P($$RACE^BUD9RPTC(DFN),U,3)_"-"_$P($$RACE^BUD9RPTC(DFN),U,4),1,19)
WRITE ?2,$EXTRACT($PIECE(BUDRACV,U,4),1,16)_" ("_$PIECE(BUDRACV,U,3),")"
+13 SET BUDHISV=$$HISP^BUD9RPTC(DFN)
+14 WRITE ?24,$PIECE(BUDHISV,U,3)," (",$PIECE(BUDHISV,U,2),")",!
+15 SET BUDALL=^XTMP("BUD9RP7",BUDJ,BUDH,"DMR3",BUDRACE,BUDETH,BUDCOM,BUDA,BUDNAME,DFN)
+16 SET BUDPPV=$PIECE(BUDALL,"^",1)
+17 WRITE ?5,$PIECE(BUDALL,"^",2),!
+18 FOR BUDX=1:1
SET BUDV=$PIECE(BUDPPV,U,BUDX)
IF BUDV=""!(BUDQUIT)
QUIT
Begin DoDot:5
+19 IF $Y>(IOSL-3)
DO DMR3H
IF BUDQUIT
QUIT
WRITE !,BUDRACEL,!
+20 IF $EXTRACT(BUDV)="P"
WRITE ?5,BUDV,!
QUIT
+21 SET V=$PIECE(BUDV,"|")
SET C=$PIECE(BUDV,"|",2)
+22 WRITE ?5,$$FMTE^XLFDT($PIECE($PIECE(^AUPNVSIT(V,0),U),".")),?19,C,?35,$$PRIMPROV^APCLV(V,"D"),?45,$PIECE(^AUPNVSIT(V,0),U,7),?53,$$CLINIC^APCLV(V,"C"),?65,$EXTRACT($$VAL^XBDIQ1(9000010,V,.06),1,15),!
End DoDot:5
End DoDot:4
End DoDot:3
End DoDot:2
End DoDot:1
+23 IF $Y>(IOSL-4)
DO DMR3H
IF BUDQUIT
QUIT
WRITE !,BUDRACEL,!
+24 WRITE !,"Sub-Total ",BUDRACEL,": ",BUDSTOT,!
+25 QUIT
DMR3H ;
+1 IF 'BUDGPG
GOTO DMR3H1
+2 KILL DIR
IF $EXTRACT(IOST)="C"
IF IO=IO(0)
IF '$DATA(ZTQUEUED)
WRITE !
SET DIR(0)="EO"
DO ^DIR
KILL DIR
IF Y=0!(Y="^")!($DATA(DTOUT))
SET BUDQUIT=1
QUIT
DMR3H1 ;
+1 IF $DATA(IOF)
WRITE @IOF
SET BUDGPG=BUDGPG+1
+2 WRITE !,"***** CONFIDENTIAL PATIENT INFORMATION, COVERED BY THE PRIVACY ACT *****"
+3 WRITE !?3,$PIECE(^VA(200,DUZ,0),U,2),?35,$$FMTE^XLFDT(DT),?70,"Page ",BUDGPG,!
+4 WRITE !,$$CTR("*** RPMS Uniform Data System (UDS) ***",80)
+5 WRITE !,$$CTR("Patient List for Table 7, Section C, DM w/A1c >9 by Race",80),!
+6 WRITE $$CTR($PIECE(^DIC(4,BUDSITE,0),U),80),!
+7 SET X="Reporting Period: "_$$FMTE^XLFDT(BUDBD)_" to "_$$FMTE^XLFDT(BUDED)
WRITE $$CTR(X,80),!
+8 WRITE $TRANSLATE($JUSTIFY("",80)," ","-")
+9 IF BUDP=0
Begin DoDot:1
+10 WRITE !,"List by race of patients age 18 and older who have had two medical visits"
+11 WRITE !,"during the report period and were diagnosed with Type I or Type II diabetes"
+12 WRITE !,"anytime through the end of the report period and whose most recent"
+13 WRITE !,"hemoglobin A1c is >9%, or did not have a result, or the patient did not"
+14 WRITE !,"have an A1c test during the report period."
+15 WRITE !,"Age is calculated as of December 31."
+16 WRITE !,"* E - denotes the value was obtained from the Ethnicity field."
+17 WRITE !," R - denotes the value was obtained from the Race field"
+18 WRITE !," C - denotes the value was obtained from the Classification/Beneficiary field"
+19 WRITE !
End DoDot:1
+20 WRITE !?2,"PATIENT NAME",?24,"HRN",?36,"COMMUNITY",?47,"SEX",?51,"AGE"
+21 WRITE !?2,"RACE*",?24,"HISPANIC OR LATINO IDENTITY*"
+22 WRITE !?5,"LAST A1C VALUE OR CD & DATE"
+23 WRITE !?5,"LAST DM DATE",?19,"DX OR SVC CD",?35,"PROV TYPE",?45,"SVC CAT",?53,"CLINIC",?65,"LOCATION"
+24 WRITE !,$TRANSLATE($JUSTIFY("",80)," ","-"),!
+25 SET BUDP=1
+26 QUIT
+27 ;
