| 1 | ECXQSR ;ALB/JAP,BIR/PTD-DSS QUASAR Extract ; 04/16/07 8:58am
 | 
|---|
| 2 |  ;;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
 | 
|---|
| 3 | BEG ;entry point from option
 | 
|---|
| 4 |  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
 | 
|---|
| 5 |  I '$D(^ACK(509850.8,1,"DSS")) W !,"Linkage has not been established between QUASAR and the DSS UNIT file (#724).",!! Q
 | 
|---|
| 6 |  I '$O(^ACK(509850.6,0)) W !,"There is no data in the A&SP CLINIC VISIT file (#509850.6).",!! Q
 | 
|---|
| 7 |  D SETUP I ECFILE="" Q
 | 
|---|
| 8 |  D ^ECXTRAC,^ECXKILL
 | 
|---|
| 9 |  Q
 | 
|---|
| 10 | START ;entry point from tasked job
 | 
|---|
| 11 |  N ERR,ECXQDT,ECXNPRFI
 | 
|---|
| 12 |  S QFLG=0,ECED=ECED+.9,ECD=ECSD1,ECXQV=""
 | 
|---|
| 13 |  D QINST I $D(ERR) Q
 | 
|---|
| 14 |  S ECL=+^ACK(509850.8,1,0),ECLINK=^ACK(509850.8,1,"DSS")
 | 
|---|
| 15 |  F  S ECD=$O(^ACK(509850.6,"B",ECD)),ECDA=0 Q:(ECD>ECED)!('ECD)!(QFLG)  D
 | 
|---|
| 16 |  .I +ECXQV=3,ECD<ECXQDT S ECXQV=2.0
 | 
|---|
| 17 |  .F  S ECDA=$O(^ACK(509850.6,"B",ECD,ECDA)) Q:'ECDA  D UPDATE Q:QFLG
 | 
|---|
| 18 |  Q
 | 
|---|
| 19 | QINST ;Get installed information for QUASAR
 | 
|---|
| 20 |  N ARR,IENS,QVIEN,INTIEN
 | 
|---|
| 21 |  S ECXQDT=""
 | 
|---|
| 22 |  D FILE^DID(509850.6,,"VERSION","ARR","ERR")
 | 
|---|
| 23 |  S ECXQV=$G(ARR("VERSION")) I +ECXQV=0 S ERR=1 Q
 | 
|---|
| 24 |  S QVIEN=$$FIND1^DIC(9.4,"","X","QUASAR") I +QVIEN<1 S ERR=1 Q
 | 
|---|
| 25 |  S IENS=","_QVIEN_","
 | 
|---|
| 26 |  S INTIEN=$$FIND1^DIC(9.49,IENS,"X",ECXQV) I +INTIEN<1 S ERR=1 Q
 | 
|---|
| 27 |  S IENS=INTIEN_","_QVIEN,ECXQDT=$$GET1^DIQ(9.49,IENS,2,"I")
 | 
|---|
| 28 |  Q
 | 
|---|
| 29 | UPDATE ;create record for each unique CPT code for clinic visit 
 | 
|---|
| 30 |  N ARY,ECZNODE,CPT,LOC,MOD,STR,VOL,XX,ECTP,ECV
 | 
|---|
| 31 |  Q:'$D(^ACK(509850.6,ECDA,0))
 | 
|---|
| 32 |  S ECZNODE=^ACK(509850.6,ECDA,0),EC2NODE=$G(^ACK(509850.6,ECDA,2))
 | 
|---|
| 33 |  S ECDT=$P(ECZNODE,U),ECDAY=$$ECXDATE^ECXUTL(ECDT,ECXYM)
 | 
|---|
| 34 |  S ECTIME=$$ECXTIME^ECXUTL(ECDT) S:$P(ECDT,".",2)="" ECTIME="000000"
 | 
|---|
| 35 |  S ECXDFN=$P(ECZNODE,U,2)
 | 
|---|
| 36 |  Q:'$$PATDEM^ECXUTL2(ECXDFN,ECD,"1;3;5")
 | 
|---|
| 37 |  S ECHL="",ECXDIV=$P($G(^ACK(509850.6,ECDA,5)),U),ECSTOP=$P(EC2NODE,U)
 | 
|---|
| 38 |  S ECXPDIV=$$GETDIV^ECXDEPT(ECXDIV)  ; Get Production Division
 | 
|---|
| 39 |  Q:ECSTOP=""
 | 
|---|
| 40 |  S (ECHLS,ECHL2S)="000",ECAC=$P($G(ECZNODE),U,6)
 | 
|---|
| 41 |  I ECAC D
 | 
|---|
| 42 |  .S ECHL=+$P($G(^SC(ECAC,0)),U,7),ECHL2=+$P($G(^(0)),U,18) I ECHL D
 | 
|---|
| 43 |  ..S ECHLS=$P($G(^DIC(40.7,+ECHL,0)),U,2),ECHL2S=$P($G(^DIC(40.7,+ECHL2,0)),U,2)
 | 
|---|
| 44 |  ..S ECHLS=$$RJ^XLFSTR(ECHLS,3,0),ECHL2S=$$RJ^XLFSTR(ECHL2S,3,0)
 | 
|---|
| 45 |  S ECDSS=ECHLS_ECHL2S
 | 
|---|
| 46 |  I ECXLOGIC>2003 D
 | 
|---|
| 47 |  .I "^18^23^24^36^41^65^94^"[("^"_ECXTS_"^") S ECDSS=$$TSMAP^ECXUTL4(ECXTS)
 | 
|---|
| 48 |  S ECDU=$S(ECSTOP["A":$P(ECLINK,U),ECSTOP["S":$P(ECLINK,U,2),1:"")
 | 
|---|
| 49 |  Q:'ECDU
 | 
|---|
| 50 |  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)
 | 
|---|
| 51 |  Q:'$O(^ACK(509850.6,ECDA,3,0))
 | 
|---|
| 52 |  ;Create local array of procedure codes and # of times each procedure
 | 
|---|
| 53 |  ; was performed.
 | 
|---|
| 54 |  F I=1:1:4 S @("ECXICD9"_I)=""
 | 
|---|
| 55 |  S (ECDIA,ECXPPC,ECXPRV1,ECXPRV2,ECXPRV3,ECUN1NPI)=""
 | 
|---|
| 56 |  ;if QUASAR v2
 | 
|---|
| 57 |  I +ECXQV=2 D
 | 
|---|
| 58 |  .S ECXPRV1=$P(EC2NODE,U,7),ECXPRV2=$P(EC2NODE,U,3),ECXPRV3=$P(EC2NODE,U,5),ECPN=0
 | 
|---|
| 59 |  .F  S ECPN=$O(^ACK(509850.6,ECDA,3,ECPN)) Q:'ECPN  D
 | 
|---|
| 60 |  ..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)
 | 
|---|
| 61 |  ..I ECXCPT]"" D
 | 
|---|
| 62 |  ...I '$D(LOC(ECXCPT)) S LOC(ECXCPT)=0_U_ECXPRV1
 | 
|---|
| 63 |  ...S $P(LOC(ECXCPT),U)=$P(LOC(ECXCPT),U)+1
 | 
|---|
| 64 |  .S ECIEN=$O(^ACK(509850.6,ECDA,1,0)),ECDIA=$P($G(^ICD9(+$G(^ACK(509850.6,ECDA,1,ECIEN,0)),0)),U)
 | 
|---|
| 65 |  .F I=1:1:4 S ECIEN=$O(^ACK(509850.6,ECDA,1,ECIEN)) Q:'+ECIEN  D
 | 
|---|
| 66 |  ..S @("ECXICD9"_I)=$P($G(^ICD9(+$P(^ACK(509850.6,ECDA,1,ECIEN,0),U),0)),U)
 | 
|---|
| 67 |  ;if QUASAR v3
 | 
|---|
| 68 |  I +ECXQV=3 D
 | 
|---|
| 69 |  .N CPT,DIA,I,J,MOD,MOD1,P,STR,VOL,ECTP,ARY,ECP,ECPN
 | 
|---|
| 70 |  .S ECXPRV2=$G(^ACK(509850.6,ECDA,2.7,1,0)),ECXPRV3=$G(^ACK(509850.6,ECDA,2.7,2,0))
 | 
|---|
| 71 |  .S ECPN=0 F  S ECPN=$O(^ACK(509850.6,ECDA,3,ECPN)) Q:'ECPN  D
 | 
|---|
| 72 |  ..S CPT=^ACK(509850.6,ECDA,3,ECPN,0),ECXCPT=$P(CPT,U),ECTP=+$P(CPT,U,5),ECV=1,ECP=""
 | 
|---|
| 73 |  ..Q:ECXCPT=""
 | 
|---|
| 74 |  ..I ECTP D
 | 
|---|
| 75 |  ...S CPT=$G(^ACK(509850.6,ECDA,7,ECTP,0)),ECP=$P(CPT,U)
 | 
|---|
| 76 |  ...S ECP=$S(ECP<90000:$P($G(^EC(725,+ECP,0)),U,2)_"N",1:$P($G(^EC(725,+ECP,0)),U,2)_"L")
 | 
|---|
| 77 |  ...S VOL=+$P(CPT,U,2),ECXPRV1=$P(CPT,U,3)
 | 
|---|
| 78 |  ..I 'ECTP S VOL=+$P(CPT,U,3),ECXPRV1=$P(CPT,U,4)
 | 
|---|
| 79 |  ..S ECXCPT=$E($$CPT^ECXUTL3(ECXCPT),1,5),ECXMOD="",MOD=0
 | 
|---|
| 80 |  ..F  S MOD=$O(^ACK(509850.6,ECDA,3,ECPN,1,MOD)) Q:'MOD  D
 | 
|---|
| 81 |  ...S MOD1=+^ACK(509850.6,ECDA,3,ECPN,1,MOD,0) D:MOD1
 | 
|---|
| 82 |  ....S ECXMOD=ECXMOD_MOD1_";"
 | 
|---|
| 83 |  ..F I=1:1:$L(ECXMOD,";") I $G(ARY(ECXCPT))'[$P(ECXMOD,";",I) D
 | 
|---|
| 84 |  ...S ARY(ECXCPT)=$G(ARY(ECXCPT))_$P(ECXMOD,";",I)_";"
 | 
|---|
| 85 |  ..S:VOL ECV=VOL
 | 
|---|
| 86 |  ..S ECV=ECV+$G(LOC(ECXCPT)),LOC(ECXCPT)=ECV_U_ECXPRV1_U_ECP
 | 
|---|
| 87 |  .S ECIEN=0 F  S ECIEN=$O(^ACK(509850.6,ECDA,1,ECIEN)) Q:'ECIEN  D
 | 
|---|
| 88 |  ..S DIA=^ACK(509850.6,ECDA,1,ECIEN,0),P=$P(DIA,U,2),P=$S(P=1:"P",1:"S")
 | 
|---|
| 89 |  ..S CNT=$G(STR(P))+1,STR(P,CNT)=$P($G(^ICD9(+DIA,0)),U),STR(P)=CNT
 | 
|---|
| 90 |  .S ECDIA=$G(STR("P",1))
 | 
|---|
| 91 |  .F I=1:1:4 Q:'$D(STR("P",I+1))  S @("ECXICD9"_I)=STR("P",I)
 | 
|---|
| 92 |  .S:ECDIA="" ECDIA=$G(STR("S",1)),I=2
 | 
|---|
| 93 |  .F J=I:1:4 Q:'$D(STR("S",J))  S @("ECXICD9"_J)=STR("S",J)
 | 
|---|
| 94 |  Q:('$D(LOC))!('$O(^ACK(509850.6,ECDA,1,0)))
 | 
|---|
| 95 |  ;- Ord Div, Contract St/End Dates, Contract Type placeholders for FY2002
 | 
|---|
| 96 |  S (ECXODIV,ECXCSDT,ECXCEDT,ECXCTYP)=""
 | 
|---|
| 97 |  ;set up Provider Person class
 | 
|---|
| 98 |  S (ECXCPT,ECXPPC1,ECXPPC2,ECXPPC3)=""
 | 
|---|
| 99 |  S:ECXPRV2'="" ECXPPC2=$$PRVCLASS^ECXUTL(ECXPRV2,ECD)
 | 
|---|
| 100 |  S:ECXPRV3'="" ECXPPC3=$$PRVCLASS^ECXUTL(ECXPRV3,ECD)
 | 
|---|
| 101 |  N DA,DIC,DIK,DR,FILEN,DIQ,XVAR,II,DI
 | 
|---|
| 102 |  F II=2,3 S XVAR="ECXPRV"_II I @XVAR'="" D
 | 
|---|
| 103 |  .S DA=@XVAR,(DIC,FILEN)=509850.3,DR=".01",DIQ="ECXQSR",DIQ(0)="I" D EN^DIQ1
 | 
|---|
| 104 |  .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
 | 
|---|
| 105 |  ; -Observation Patient Indicator (yes/no)
 | 
|---|
| 106 |  S ECXOBS=$$OBSPAT^ECXUTL4(ECXA,ECXTS,ECDSS)
 | 
|---|
| 107 |  ; -CNH status (YES/NO)
 | 
|---|
| 108 |  S ECXCNH=$$CNHSTAT^ECXUTL4(ECXDFN)
 | 
|---|
| 109 |  ;get encounter classification
 | 
|---|
| 110 |  S (ECXAO,ECXECE,ECXIR,ECXMIL,ECXHNC)="",ECXVISIT=$P($G(^ACK(509850.6,ECDA,6)),U,3)
 | 
|---|
| 111 |  I ECXVISIT'="" D
 | 
|---|
| 112 |  .D VISIT^ECXSCX1(ECXDFN,ECXVISIT,.ECXVIST,.ECXERR) I ECXERR K ECXERR Q
 | 
|---|
| 113 |  .S ECXAO=$G(ECXVIST("AO")),ECXECE=$G(ECXVIST("PGE"))
 | 
|---|
| 114 |  .S ECXIR=$G(ECXVIST("IR")),ECXMIL=$G(ECXVIST("MST")),ECXHNC=$G(ECXVIST("HNC"))
 | 
|---|
| 115 |  ; -Head and Neck Cancer Indicator
 | 
|---|
| 116 |  S ECXHNCI=$$HNCI^ECXUTL4(ECXDFN)
 | 
|---|
| 117 |  ;get enrollment data (category, status and priority)
 | 
|---|
| 118 |  I $$ENROLLM^ECXUTL2(ECXDFN)
 | 
|---|
| 119 |  ; -Get national patient record flag Indicator if exist
 | 
|---|
| 120 |  D NPRF^ECXUTL5
 | 
|---|
| 121 |  ; -If no encounter number don't file record
 | 
|---|
| 122 |  S ECXENC=$$ENCNUM^ECXUTL4(ECXA,ECXSSN,ECXADMDT,ECDT,ECXTS,ECXOBS,ECHEAD,ECDSS,)
 | 
|---|
| 123 |  Q:ECXENC=""
 | 
|---|
| 124 |  ;Loop through array of unique procedures. Create record in ECODE.
 | 
|---|
| 125 |  S CPT="" F  S CPT=$O(LOC(CPT)) Q:CPT=""  D
 | 
|---|
| 126 |  .S ECV=+$P(LOC(CPT),U),ECXCPT=$$CPT^ECXUTL3(CPT,$G(ARY(CPT)),ECV)
 | 
|---|
| 127 |  .S ECXPRV1=$P(LOC(CPT),U,2)
 | 
|---|
| 128 |  .S:ECXPRV1'="" ECXPPC1=$$PRVCLASS^ECXUTL(ECXPRV1,ECD),ECXPRV1=2_ECXPRV1
 | 
|---|
| 129 |  .S ECP=$P(LOC(CPT),U,3) I ECP="" S ECP=$$CPT^ECXUTL3(CPT,"",ECV)
 | 
|---|
| 130 |  .D FILE
 | 
|---|
| 131 |  K CPT,LOC
 | 
|---|
| 132 |  Q
 | 
|---|
| 133 | FILE ;file record in #727.825
 | 
|---|
| 134 |  ;node0
 | 
|---|
| 135 |  ;inst^dfn ECXDFN^ssn ECXSSN^name ECXPNM^i/o status ECXA^day ECDAY^
 | 
|---|
| 136 |  ;DSS unit ECDU^^category ECPTTM^procedure ECP^volume ECV^cost center^
 | 
|---|
| 137 |  ;ordering sec ^section^provider ECXPRV1^ECXPPC1^ECXPRV2^ECXPPC2^ECXPRV3^
 | 
|---|
| 138 |  ;ECXPPC3^mov # ECXMN^treat spec ECXTS^time ECTIME^primary care team 
 | 
|---|
| 139 |  ;ECPTTM^primary care provider ECPTPR^pce cpt code & modifers ECXCPT^
 | 
|---|
| 140 |  ;primary icd-9 code ECDIA^secondary icd-9 #1 ECXICD91^secondary icd-9 
 | 
|---|
| 141 |  ;#2 ECXICD92^secondary icd-9 #3 ECXICD93^secondary icd-9 #4 ECXICD94^
 | 
|---|
| 142 |  ;agent orange ECXAST^radiation exposure ECRST^environmental
 | 
|---|
| 143 |  ;contaminants ECEST^service connected ECSC^sent to pce^^dss identifier
 | 
|---|
| 144 |  ;ECDSS^placeholder
 | 
|---|
| 145 |  ;node1
 | 
|---|
| 146 |  ;mpi ECXNPI^dss dept ECXDSSD^provider npi ECUN1NPI^^^pc prov person 
 | 
|---|
| 147 |  ;class ECPTNPI^assoc pc provider ECASPR^assoc pc prov person class 
 | 
|---|
| 148 |  ;ECCLAS2^assoc pc provider npi ECASNPI^divison ECXDIV^dom ECXDOM^
 | 
|---|
| 149 |  ;enrollment category ECXCAT^enrollment status ECXSTAT^enrollment prior 
 | 
|---|
| 150 |  ;ECXPRIOR^period of service ECXPOS^purple heart ECXPHI^observ pat ind 
 | 
|---|
| 151 |  ;ECXOBS^encounter num ECXENC^ao loc ECXAOL^ord div ECXODIV^contr st dt 
 | 
|---|
| 152 |  ;ECXCSDT^contr end dt ECXCEDT^contr typ ECXCTYP^CNH stat ECXCNH^
 | 
|---|
| 153 |  ;production division ECXPDIV^eligibility ECXELIG^ethnicity ECXETH^
 | 
|---|
| 154 |  ;race1 ECXRC1^enrollment location ECXENRL^^enrollment priority 
 | 
|---|
| 155 |  ;ECXPRIOR_enrollment subgroup ECXSBGRP^user enrollee ECXUESTA^patient 
 | 
|---|
| 156 |  ;type ECXPTYPE^combat vet elig ECXCVE^combat vet elig end date ECXCVEDT^
 | 
|---|
| 157 |  ;enc cv eligible ECXCVENC^national patient record flag ECXNPRFI^
 | 
|---|
| 158 |  ;emergency response indicator(FEMA) ECXERI^agent orange indicator 
 | 
|---|
| 159 |  ;ECXAO^environ contam ECXECE^head/neck ECXHNC^military sexual trauma 
 | 
|---|
| 160 |  ;ECXMIL^radiation encoun ECXIR^nutrition dx
 | 
|---|
| 161 |  N DA,DIK
 | 
|---|
| 162 |  S EC7=$O(^ECX(ECFILE,999999999),-1),EC7=EC7+1
 | 
|---|
| 163 |  S ECODE=EC7_U_EC23_U
 | 
|---|
| 164 |  S ECODE=ECODE_ECL_U_ECXDFN_U_ECXSSN_U_ECXPNM_U_ECXA_U_ECDAY_U_ECDU_U_U
 | 
|---|
| 165 |  S ECODE=ECODE_ECP_U_ECV_U_ECCS_U_ECO_U_ECM_U_ECXPRV1_U_ECXPPC1_U
 | 
|---|
| 166 |  S ECODE=ECODE_ECXPRV2_U_ECXPPC2_U_ECXPRV3_U_ECXPPC3_U_U
 | 
|---|
| 167 |  S ECODE=ECODE_ECXMN_U_ECXTS_U_ECTIME_U_ECPTTM_U
 | 
|---|
| 168 |  S ECODE=ECODE_ECPTPR_U_ECXCPT_U_ECDIA_U_ECXICD91_U_ECXICD92_U
 | 
|---|
| 169 |  S ECODE=ECODE_ECXICD93_U_ECXICD94_U_ECXAST_U_ECXRST_U_ECXEST_U
 | 
|---|
| 170 |  S ECODE=ECODE_ECSC_U_"N"_U_U_ECDSS_U_U
 | 
|---|
| 171 |  S ECODE1=ECXMPI_U_ECXDSSD_U_ECUN1NPI_U_U_U_ECCLAS_U_ECPTNPI_U_ECASPR_U
 | 
|---|
| 172 |  S ECODE1=ECODE1_ECCLAS2_U_ECASNPI_U_ECXDIV_U_ECXMST_U_ECXDOM_U
 | 
|---|
| 173 |  S ECODE1=ECODE1_ECXDOB_U_ECXCAT_U_ECXSTAT_U_$S(ECXLOGIC<2005:ECXPRIOR,1:"")_U_ECXPOS_U_ECXPHI_U
 | 
|---|
| 174 |  S ECODE1=ECODE1_ECXOBS_U_ECXENC_U_ECXAOL_U_ECXODIV_U_ECXCSDT_U_ECXCEDT_U
 | 
|---|
| 175 |  S ECODE1=ECODE1_ECXCTYP_U_ECXCNH_U_ECXPDIV_U_ECXELIG_U_ECXHNCI_U_ECXETH_U
 | 
|---|
| 176 |  S ECODE1=ECODE1_ECXRC1
 | 
|---|
| 177 |  I ECXLOGIC>2003 S ECODE1=ECODE1_U_ECXENRL
 | 
|---|
| 178 |  I ECXLOGIC>2004 S ECODE1=ECODE1_U_U_ECXPRIOR_ECXSBGRP_U_ECXUESTA_U_ECXPTYPE_U_ECXCVE_U
 | 
|---|
| 179 |  I ECXLOGIC>2004 S ECODE2=ECXCVEDT_U_ECXCVENC_U_ECXNPRFI
 | 
|---|
| 180 |  I ECXLOGIC>2006 S ECODE2=ECODE2_U_ECXERI_U_ECXAO_U_ECXECE_U_ECXHNC_U_ECXMIL_U_ECXIR_U
 | 
|---|
| 181 |  S ^ECX(ECFILE,EC7,0)=ECODE,^ECX(ECFILE,EC7,1)=ECODE1,^ECX(ECFILE,EC7,2)=$G(ECODE2),ECRN=ECRN+1
 | 
|---|
| 182 |  S DA=EC7,DIK="^ECX("_ECFILE_"," D IX1^DIK K DIK,DA
 | 
|---|
| 183 |  I $D(ZTQUEUED),$$S^%ZTLOAD
 | 
|---|
| 184 |  Q
 | 
|---|
| 185 | SETUP ;Set required input for ECXTRAC
 | 
|---|
| 186 |  S ECHEAD="ECQ"
 | 
|---|
| 187 |  D ECXDEF^ECXUTL2(ECHEAD,.ECPACK,.ECGRP,.ECFILE,.ECRTN,.ECPIECE,.ECVER)
 | 
|---|
| 188 |  Q
 | 
|---|
| 189 | QUE ;Entry point for the background requeuing handled by ECXTAUTO.
 | 
|---|
| 190 |  D SETUP,QUE^ECXTAUTO,^ECXKILL Q
 | 
|---|