ECXQSR ;ALB/JAP,BIR/PTD-DSS QUASAR Extract ; 04/16/07 8:58am ;;3.0;DSS EXTRACTS;**11,8,13,26,24,34,33,35,39,43,46,49,64,71,84,92,106**;Dec 22, 1997;Build 1 BEG ;entry point from option I '$O(^ACK(509850.8,0)) W !,"You must be using the Quality Audiology & Speech Pathology",!,"Audit & Review (QUASAR) software to run this extract.",!! Q I '$D(^ACK(509850.8,1,"DSS")) W !,"Linkage has not been established between QUASAR and the DSS UNIT file (#724).",!! Q I '$O(^ACK(509850.6,0)) W !,"There is no data in the A&SP CLINIC VISIT file (#509850.6).",!! Q D SETUP I ECFILE="" Q D ^ECXTRAC,^ECXKILL Q START ;entry point from tasked job N ERR,ECXQDT,ECXNPRFI S QFLG=0,ECED=ECED+.9,ECD=ECSD1,ECXQV="" D QINST I $D(ERR) Q S ECL=+^ACK(509850.8,1,0),ECLINK=^ACK(509850.8,1,"DSS") F S ECD=$O(^ACK(509850.6,"B",ECD)),ECDA=0 Q:(ECD>ECED)!('ECD)!(QFLG) D .I +ECXQV=3,ECD2003 D .I "^18^23^24^36^41^65^94^"[("^"_ECXTS_"^") S ECDSS=$$TSMAP^ECXUTL4(ECXTS) S ECDU=$S(ECSTOP["A":$P(ECLINK,U),ECSTOP["S":$P(ECLINK,U,2),1:"") Q:'ECDU S ECDSSU=$G(^ECD(ECDU,0)),ECCS=+$P(ECDSSU,U,4),(ECO,ECM)=+$P(ECDSSU,U,3),ECXDSSD=$E($P(ECDSSU,U,5),1,10) Q:'$O(^ACK(509850.6,ECDA,3,0)) ;Create local array of procedure codes and # of times each procedure ; was performed. F I=1:1:4 S @("ECXICD9"_I)="" S (ECDIA,ECXPPC,ECXPRV1,ECXPRV2,ECXPRV3,ECUN1NPI)="" ;if QUASAR v2 I +ECXQV=2 D .S ECXPRV1=$P(EC2NODE,U,7),ECXPRV2=$P(EC2NODE,U,3),ECXPRV3=$P(EC2NODE,U,5),ECPN=0 .F S ECPN=$O(^ACK(509850.6,ECDA,3,ECPN)) Q:'ECPN D ..S XX=^ACK(509850.6,ECDA,3,ECPN,0),XX=$P(XX,U),XX=$P($G(^ACK(509850.4,XX,0)),U),ECXCPT=$E($$CPT^ECXUTL3(XX),1,5) ..I ECXCPT]"" D ...I '$D(LOC(ECXCPT)) S LOC(ECXCPT)=0_U_ECXPRV1 ...S $P(LOC(ECXCPT),U)=$P(LOC(ECXCPT),U)+1 .S ECIEN=$O(^ACK(509850.6,ECDA,1,0)),ECDIA=$P($G(^ICD9(+$G(^ACK(509850.6,ECDA,1,ECIEN,0)),0)),U) .F I=1:1:4 S ECIEN=$O(^ACK(509850.6,ECDA,1,ECIEN)) Q:'+ECIEN D ..S @("ECXICD9"_I)=$P($G(^ICD9(+$P(^ACK(509850.6,ECDA,1,ECIEN,0),U),0)),U) ;if QUASAR v3 I +ECXQV=3 D .N CPT,DIA,I,J,MOD,MOD1,P,STR,VOL,ECTP,ARY,ECP,ECPN .S ECXPRV2=$G(^ACK(509850.6,ECDA,2.7,1,0)),ECXPRV3=$G(^ACK(509850.6,ECDA,2.7,2,0)) .S ECPN=0 F S ECPN=$O(^ACK(509850.6,ECDA,3,ECPN)) Q:'ECPN D ..S CPT=^ACK(509850.6,ECDA,3,ECPN,0),ECXCPT=$P(CPT,U),ECTP=+$P(CPT,U,5),ECV=1,ECP="" ..Q:ECXCPT="" ..I ECTP D ...S CPT=$G(^ACK(509850.6,ECDA,7,ECTP,0)),ECP=$P(CPT,U) ...S ECP=$S(ECP<90000:$P($G(^EC(725,+ECP,0)),U,2)_"N",1:$P($G(^EC(725,+ECP,0)),U,2)_"L") ...S VOL=+$P(CPT,U,2),ECXPRV1=$P(CPT,U,3) ..I 'ECTP S VOL=+$P(CPT,U,3),ECXPRV1=$P(CPT,U,4) ..S ECXCPT=$E($$CPT^ECXUTL3(ECXCPT),1,5),ECXMOD="",MOD=0 ..F S MOD=$O(^ACK(509850.6,ECDA,3,ECPN,1,MOD)) Q:'MOD D ...S MOD1=+^ACK(509850.6,ECDA,3,ECPN,1,MOD,0) D:MOD1 ....S ECXMOD=ECXMOD_MOD1_";" ..F I=1:1:$L(ECXMOD,";") I $G(ARY(ECXCPT))'[$P(ECXMOD,";",I) D ...S ARY(ECXCPT)=$G(ARY(ECXCPT))_$P(ECXMOD,";",I)_";" ..S:VOL ECV=VOL ..S ECV=ECV+$G(LOC(ECXCPT)),LOC(ECXCPT)=ECV_U_ECXPRV1_U_ECP .S ECIEN=0 F S ECIEN=$O(^ACK(509850.6,ECDA,1,ECIEN)) Q:'ECIEN D ..S DIA=^ACK(509850.6,ECDA,1,ECIEN,0),P=$P(DIA,U,2),P=$S(P=1:"P",1:"S") ..S CNT=$G(STR(P))+1,STR(P,CNT)=$P($G(^ICD9(+DIA,0)),U),STR(P)=CNT .S ECDIA=$G(STR("P",1)) .F I=1:1:4 Q:'$D(STR("P",I+1)) S @("ECXICD9"_I)=STR("P",I) .S:ECDIA="" ECDIA=$G(STR("S",1)),I=2 .F J=I:1:4 Q:'$D(STR("S",J)) S @("ECXICD9"_J)=STR("S",J) Q:('$D(LOC))!('$O(^ACK(509850.6,ECDA,1,0))) ;- Ord Div, Contract St/End Dates, Contract Type placeholders for FY2002 S (ECXODIV,ECXCSDT,ECXCEDT,ECXCTYP)="" ;set up Provider Person class S (ECXCPT,ECXPPC1,ECXPPC2,ECXPPC3)="" S:ECXPRV2'="" ECXPPC2=$$PRVCLASS^ECXUTL(ECXPRV2,ECD) S:ECXPRV3'="" ECXPPC3=$$PRVCLASS^ECXUTL(ECXPRV3,ECD) N DA,DIC,DIK,DR,FILEN,DIQ,XVAR,II,DI F II=2,3 S XVAR="ECXPRV"_II I @XVAR'="" D .S DA=@XVAR,(DIC,FILEN)=509850.3,DR=".01",DIQ="ECXQSR",DIQ(0)="I" D EN^DIQ1 .S DA=ECXQSR(FILEN,DA,DR,"I"),(DIC,FILEN)=8930.3 D EN^DIQ1 S @XVAR=2_ECXQSR(FILEN,DA,DR,"I") K DA,DIC,DR,DIQ,ECXQSR ; -Observation Patient Indicator (yes/no) S ECXOBS=$$OBSPAT^ECXUTL4(ECXA,ECXTS,ECDSS) ; -CNH status (YES/NO) S ECXCNH=$$CNHSTAT^ECXUTL4(ECXDFN) ;get encounter classification S (ECXAO,ECXECE,ECXIR,ECXMIL,ECXHNC)="",ECXVISIT=$P($G(^ACK(509850.6,ECDA,6)),U,3) I ECXVISIT'="" D .D VISIT^ECXSCX1(ECXDFN,ECXVISIT,.ECXVIST,.ECXERR) I ECXERR K ECXERR Q .S ECXAO=$G(ECXVIST("AO")),ECXECE=$G(ECXVIST("PGE")) .S ECXIR=$G(ECXVIST("IR")),ECXMIL=$G(ECXVIST("MST")),ECXHNC=$G(ECXVIST("HNC")) ; -Head and Neck Cancer Indicator S ECXHNCI=$$HNCI^ECXUTL4(ECXDFN) ;get enrollment data (category, status and priority) I $$ENROLLM^ECXUTL2(ECXDFN) ; -Get national patient record flag Indicator if exist D NPRF^ECXUTL5 ; -If no encounter number don't file record S ECXENC=$$ENCNUM^ECXUTL4(ECXA,ECXSSN,ECXADMDT,ECDT,ECXTS,ECXOBS,ECHEAD,ECDSS,) Q:ECXENC="" ;Loop through array of unique procedures. Create record in ECODE. S CPT="" F S CPT=$O(LOC(CPT)) Q:CPT="" D .S ECV=+$P(LOC(CPT),U),ECXCPT=$$CPT^ECXUTL3(CPT,$G(ARY(CPT)),ECV) .S ECXPRV1=$P(LOC(CPT),U,2) .S:ECXPRV1'="" ECXPPC1=$$PRVCLASS^ECXUTL(ECXPRV1,ECD),ECXPRV1=2_ECXPRV1 .S ECP=$P(LOC(CPT),U,3) I ECP="" S ECP=$$CPT^ECXUTL3(CPT,"",ECV) .D FILE K CPT,LOC Q FILE ;file record in #727.825 ;node0 ;inst^dfn ECXDFN^ssn ECXSSN^name ECXPNM^i/o status ECXA^day ECDAY^ ;DSS unit ECDU^^category ECPTTM^procedure ECP^volume ECV^cost center^ ;ordering sec ^section^provider ECXPRV1^ECXPPC1^ECXPRV2^ECXPPC2^ECXPRV3^ ;ECXPPC3^mov # ECXMN^treat spec ECXTS^time ECTIME^primary care team ;ECPTTM^primary care provider ECPTPR^pce cpt code & modifers ECXCPT^ ;primary icd-9 code ECDIA^secondary icd-9 #1 ECXICD91^secondary icd-9 ;#2 ECXICD92^secondary icd-9 #3 ECXICD93^secondary icd-9 #4 ECXICD94^ ;agent orange ECXAST^radiation exposure ECRST^environmental ;contaminants ECEST^service connected ECSC^sent to pce^^dss identifier ;ECDSS^placeholder ;node1 ;mpi ECXNPI^dss dept ECXDSSD^provider npi ECUN1NPI^^^pc prov person ;class ECPTNPI^assoc pc provider ECASPR^assoc pc prov person class ;ECCLAS2^assoc pc provider npi ECASNPI^divison ECXDIV^dom ECXDOM^ ;enrollment category ECXCAT^enrollment status ECXSTAT^enrollment prior ;ECXPRIOR^period of service ECXPOS^purple heart ECXPHI^observ pat ind ;ECXOBS^encounter num ECXENC^ao loc ECXAOL^ord div ECXODIV^contr st dt ;ECXCSDT^contr end dt ECXCEDT^contr typ ECXCTYP^CNH stat ECXCNH^ ;production division ECXPDIV^eligibility ECXELIG^ethnicity ECXETH^ ;race1 ECXRC1^enrollment location ECXENRL^^enrollment priority ;ECXPRIOR_enrollment subgroup ECXSBGRP^user enrollee ECXUESTA^patient ;type ECXPTYPE^combat vet elig ECXCVE^combat vet elig end date ECXCVEDT^ ;enc cv eligible ECXCVENC^national patient record flag ECXNPRFI^ ;emergency response indicator(FEMA) ECXERI^agent orange indicator ;ECXAO^environ contam ECXECE^head/neck ECXHNC^military sexual trauma ;ECXMIL^radiation encoun ECXIR^nutrition dx N DA,DIK S EC7=$O(^ECX(ECFILE,999999999),-1),EC7=EC7+1 S ECODE=EC7_U_EC23_U S ECODE=ECODE_ECL_U_ECXDFN_U_ECXSSN_U_ECXPNM_U_ECXA_U_ECDAY_U_ECDU_U_U S ECODE=ECODE_ECP_U_ECV_U_ECCS_U_ECO_U_ECM_U_ECXPRV1_U_ECXPPC1_U S ECODE=ECODE_ECXPRV2_U_ECXPPC2_U_ECXPRV3_U_ECXPPC3_U_U S ECODE=ECODE_ECXMN_U_ECXTS_U_ECTIME_U_ECPTTM_U S ECODE=ECODE_ECPTPR_U_ECXCPT_U_ECDIA_U_ECXICD91_U_ECXICD92_U S ECODE=ECODE_ECXICD93_U_ECXICD94_U_ECXAST_U_ECXRST_U_ECXEST_U S ECODE=ECODE_ECSC_U_"N"_U_U_ECDSS_U_U S ECODE1=ECXMPI_U_ECXDSSD_U_ECUN1NPI_U_U_U_ECCLAS_U_ECPTNPI_U_ECASPR_U S ECODE1=ECODE1_ECCLAS2_U_ECASNPI_U_ECXDIV_U_ECXMST_U_ECXDOM_U S ECODE1=ECODE1_ECXDOB_U_ECXCAT_U_ECXSTAT_U_$S(ECXLOGIC<2005:ECXPRIOR,1:"")_U_ECXPOS_U_ECXPHI_U S ECODE1=ECODE1_ECXOBS_U_ECXENC_U_ECXAOL_U_ECXODIV_U_ECXCSDT_U_ECXCEDT_U S ECODE1=ECODE1_ECXCTYP_U_ECXCNH_U_ECXPDIV_U_ECXELIG_U_ECXHNCI_U_ECXETH_U S ECODE1=ECODE1_ECXRC1 I ECXLOGIC>2003 S ECODE1=ECODE1_U_ECXENRL I ECXLOGIC>2004 S ECODE1=ECODE1_U_U_ECXPRIOR_ECXSBGRP_U_ECXUESTA_U_ECXPTYPE_U_ECXCVE_U I ECXLOGIC>2004 S ECODE2=ECXCVEDT_U_ECXCVENC_U_ECXNPRFI I ECXLOGIC>2006 S ECODE2=ECODE2_U_ECXERI_U_ECXAO_U_ECXECE_U_ECXHNC_U_ECXMIL_U_ECXIR_U S ^ECX(ECFILE,EC7,0)=ECODE,^ECX(ECFILE,EC7,1)=ECODE1,^ECX(ECFILE,EC7,2)=$G(ECODE2),ECRN=ECRN+1 S DA=EC7,DIK="^ECX("_ECFILE_"," D IX1^DIK K DIK,DA I $D(ZTQUEUED),$$S^%ZTLOAD Q SETUP ;Set required input for ECXTRAC S ECHEAD="ECQ" D ECXDEF^ECXUTL2(ECHEAD,.ECPACK,.ECGRP,.ECFILE,.ECRTN,.ECPIECE,.ECVER) Q QUE ;Entry point for the background requeuing handled by ECXTAUTO. D SETUP,QUE^ECXTAUTO,^ECXKILL Q