| [623] | 1 | ECXADM ;ALB/JAP,BIR/DMA,CML,PTD-Admissions Extract ; 04/12/2007
|
|---|
| 2 | ;;3.0;DSS EXTRACTS;**1,4,11,8,13,24,33,39,46,71,84,92,107**;Dec 22, 1997;Build 9
|
|---|
| 3 | BEG ;entry point from option
|
|---|
| 4 | D SETUP I ECFILE="" Q
|
|---|
| 5 | D ^ECXTRAC,^ECXKILL
|
|---|
| 6 | Q
|
|---|
| 7 | ;
|
|---|
| 8 | START ; start package specific extract
|
|---|
| 9 | S QFLG=0
|
|---|
| 10 | S ECED=ECED+.3,ECD=ECSD1
|
|---|
| 11 | F S ECD=$O(^DGPM("ATT1",ECD)),ECDA=0 Q:('ECD)!(ECD>ECED) D
|
|---|
| 12 | .F S ECDA=$O(^DGPM("ATT1",ECD,ECDA)) Q:ECDA="" D
|
|---|
| 13 | ..I $D(^DGPM(ECDA,0)) D
|
|---|
| 14 | ...S EC=^DGPM(ECDA,0),ECXDFN=$P(EC,U,3) D GET
|
|---|
| 15 | Q
|
|---|
| 16 | ;
|
|---|
| 17 | GET ;gather extract data
|
|---|
| 18 | N ADM,W,X,ECXNPRFI,ECXATTPC,ECXPRVPC,ECXEST
|
|---|
| 19 | ;patient demographics
|
|---|
| 20 | S ECXERR=0 D PAT(ECXDFN,ECD,.ECXERR)
|
|---|
| 21 | Q:ECXERR
|
|---|
| 22 | I $$ENROLLM^ECXUTL2(ECXDFN)
|
|---|
| 23 | S ECXFAC=$P($G(^DIC(42,+$P(EC,U,6),0)),U,11)
|
|---|
| 24 | S ECXPDIV=$$GETDIV^ECXDEPT(ECXFAC) ;Get production division
|
|---|
| 25 | ;admission data
|
|---|
| 26 | S ELGA=$P($G(^DIC(8,+$P(EC,U,20),0)),U,9)
|
|---|
| 27 | I ELGA S ELGA=$$ELIG^ECXUTL3(ELGA,ECXSVC)
|
|---|
| 28 | S (ECDRG,ECDIA,ECXSADM)="",ECPTF=+$P(EC,U,16) I ECPTF,$D(^DGPT(ECPTF,"M")) D PTF
|
|---|
| 29 | ;get encounter classification
|
|---|
| 30 | S (ECXAO,ECXECE,ECXIR,ECXMIL,ECXHNC)="",ECXVISIT=$P(EC,U,27)
|
|---|
| 31 | I ECXVISIT'="" D
|
|---|
| 32 | .D VISIT^ECXSCX1(ECXDFN,ECXVISIT,.ECXVIST,.ECXERR) I ECXERR K ECXERR Q
|
|---|
| 33 | .S ECXAO=$G(ECXVIST("AO")),ECXIR=$G(ECXVIST("IR"))
|
|---|
| 34 | .S ECXMIL=$G(ECXVIST("MST")),ECXHNC=$G(ECXVIST("HNC"))
|
|---|
| 35 | .S ECXECE=$G(ECXVIST("PGE"))
|
|---|
| 36 | ;use movement record date & time
|
|---|
| 37 | S ADM=$$INP^ECXUTL2(ECXDFN,ECD)
|
|---|
| 38 | S ECXA=$P(ADM,U),ECXMN=$P(ADM,U,2),ECXSPC=$P(ADM,U,3)
|
|---|
| 39 | S (ECXADMDT,ECXDATE)=$P(ADM,U,4)
|
|---|
| 40 | ;if movement# doesn't match cross-ref ien, then quit
|
|---|
| 41 | Q:ECXMN'=ECDA
|
|---|
| 42 | S ECTM=$$ECXTIME^ECXUTL(ECXDATE)
|
|---|
| 43 | S ECXDATE=$$ECXDATE^ECXUTL(ECXDATE,ECXYM)
|
|---|
| 44 | S W=$P(ADM,U,9)
|
|---|
| 45 | S ECXWRD=$P(W,";",1),ECXFAC=$P(W,";",2),ECXDSSD=$P(W,";",3)
|
|---|
| 46 | S ECXPRV=$P(ADM,U,7),ECXPRNPI="",ECXATT=$P(ADM,U,8),ECXATNPI=""
|
|---|
| 47 | S ECXDOM=$P(ADM,U,10),ECXATTPC=$P(ADM,U,12),ECXPRVPC=$P(ADM,U,11)
|
|---|
| 48 | ;
|
|---|
| 49 | ;- Observation patient indicator (YES/NO)
|
|---|
| 50 | S ECXOBS=$$OBSPAT^ECXUTL4(ECXA,ECXSPC)
|
|---|
| 51 | ;
|
|---|
| 52 | ;- Patient Type
|
|---|
| 53 | S ECXPTYPE=$$TYPE^ECXUTL5(ECXDFN)
|
|---|
| 54 | ;
|
|---|
| 55 | ;- If null encounter number, don't file record
|
|---|
| 56 | S ECXENC=$$ENCNUM^ECXUTL4(ECXA,ECXSSN,ECXADMDT,,ECXSPC,ECXOBS,ECHEAD,,)
|
|---|
| 57 | D:ECXENC'="" FILE
|
|---|
| 58 | Q
|
|---|
| 59 | ;
|
|---|
| 60 | PAT(ECXDFN,ECXDATE,ECXERR) ;get patient demographic data
|
|---|
| 61 | N OK,X
|
|---|
| 62 | K ECXPAT
|
|---|
| 63 | S ECXDATE=$P(ECXDATE,".")
|
|---|
| 64 | S OK=$$PAT^ECXUTL3(ECXDFN,ECXDATE,"1;2;3;4;5",.ECXPAT)
|
|---|
| 65 | I 'OK S ECXERR=1 K ECXPAT Q
|
|---|
| 66 | S ECXSSN=ECXPAT("SSN")
|
|---|
| 67 | S ECXPNM=ECXPAT("NAME")
|
|---|
| 68 | S ECXMPI=ECXPAT("MPI")
|
|---|
| 69 | S ECXSEX=ECXPAT("SEX")
|
|---|
| 70 | S ECXDOB=ECXPAT("DOB")
|
|---|
| 71 | S ECXELIG=ECXPAT("ELIG")
|
|---|
| 72 | S ECXVET=ECXPAT("VET")
|
|---|
| 73 | S ECXVNS=ECXPAT("VIETNAM")
|
|---|
| 74 | S ECXPOS=ECXPAT("POS")
|
|---|
| 75 | S ECXMNS=ECXPAT("MEANS")
|
|---|
| 76 | S ECXRACE=ECXPAT("RACE")
|
|---|
| 77 | S ECXRELG=ECXPAT("RELIGION")
|
|---|
| 78 | S ECXEMP=ECXPAT("EMPLOY")
|
|---|
| 79 | S ECXMAR=ECXPAT("MARITAL")
|
|---|
| 80 | S ECXPST=ECXPAT("POW STAT")
|
|---|
| 81 | S ECXPLOC=ECXPAT("POW LOC")
|
|---|
| 82 | S ECXRST=ECXPAT("IR STAT")
|
|---|
| 83 | S ECXAST=ECXPAT("AO STAT")
|
|---|
| 84 | S ECXMST=ECXPAT("MST STAT")
|
|---|
| 85 | S ECXSTATE=ECXPAT("STATE")
|
|---|
| 86 | S ECXCNTY=ECXPAT("COUNTY")
|
|---|
| 87 | S ECXZIP=ECXPAT("ZIP")
|
|---|
| 88 | S ECXENRL=ECXPAT("ENROLL LOC")
|
|---|
| 89 | S ECXSVC=ECXPAT("SC%")
|
|---|
| 90 | S ECXPHI=ECXPAT("PHI")
|
|---|
| 91 | S ECXHI=+$$INSUR^IBBAPI(ECXDFN,ECXDATE)
|
|---|
| 92 | S ECXEST=ECXPAT("EC STAT")
|
|---|
| 93 | ;
|
|---|
| 94 | ;- Agent Orange location
|
|---|
| 95 | S ECXAOL=ECXPAT("AOL")
|
|---|
| 96 | ;
|
|---|
| 97 | ; - Head and Neck Cancer Indicator
|
|---|
| 98 | S ECXHNCI=$$HNCI^ECXUTL4(ECXDFN)
|
|---|
| 99 | ; - Race and Ethnicity
|
|---|
| 100 | S ECXETH=ECXPAT("ETHNIC")
|
|---|
| 101 | S ECXRC1=ECXPAT("RACE1")
|
|---|
| 102 | ;
|
|---|
| 103 | ;get primary care data
|
|---|
| 104 | S X=$$PRIMARY^ECXUTL2(ECXDFN,ECXDATE)
|
|---|
| 105 | S ECPTTM=$P(X,U),ECPTPR=$P(X,U,2),ECCLAS=$P(X,U,3),ECPTNPI=$P(X,U,4)
|
|---|
| 106 | S ECASPR=$P(X,U,5),ECCLAS2=$P(X,U,6),ECASNPI=$P(X,U,7)
|
|---|
| 107 | ;get combat veteran data
|
|---|
| 108 | I $$CVEDT^ECXUTL5(ECXDFN,ECD)
|
|---|
| 109 | ;get national patient record flag if exist
|
|---|
| 110 | D NPRF^ECXUTL5
|
|---|
| 111 | ;get emergency response indicator (FEMA)
|
|---|
| 112 | S ECXERI=ECXPAT("ERI")
|
|---|
| 113 | Q
|
|---|
| 114 | ;
|
|---|
| 115 | PTF ; get admitting DRG, diagnosis, source of admission from PTF
|
|---|
| 116 | ;use number for DRG and .01 for diagnosis
|
|---|
| 117 | N EC,EC1,ECX
|
|---|
| 118 | S EC=1 I $D(^DGPT(ECPTF,"M",2,0)) S EC=2
|
|---|
| 119 | S EC1=+$P(^DGPT(ECPTF,"M",EC,0),U,5)
|
|---|
| 120 | S ECDRG=$P($G(^DGPT(ECPTF,"M",EC,"P")),U)
|
|---|
| 121 | S ECDIA=$P($G(^ICD9(EC1,0)),U)
|
|---|
| 122 | S ECX=+$P($G(^DGPT(ECPTF,101)),U),ECXSADM=$P($G(^DIC(45.1,ECX,0)),U,11)
|
|---|
| 123 | Q
|
|---|
| 124 | ;
|
|---|
| 125 | FILE ;file the extract record
|
|---|
| 126 | ;node0
|
|---|
| 127 | ;facility^dfn^ssn^name^in/out^day^primary care team^sex^dob^
|
|---|
| 128 | ;religion^employment status^health ins^state^county^zip^
|
|---|
| 129 | ;eligibility^vet^vietnam^agent orange^radiation^pow^
|
|---|
| 130 | ;period of service^means test^marital status^
|
|---|
| 131 | ;ward^treating specialty^attending physician^mov #^DRG^diagnosis^
|
|---|
| 132 | ;time^primary care provider^race^primary ward provider
|
|---|
| 133 | ;node1
|
|---|
| 134 | ;mpi^dss dept^attending npi^pc provider npi^ward provider npi^
|
|---|
| 135 | ;admission elig^mst status^^sharing payor^
|
|---|
| 136 | ;sharing insurance^enrollment location^
|
|---|
| 137 | ;pc prov person class^assoc pc provider^assoc pc prov person class^
|
|---|
| 138 | ;assoc pc prov npi^dom^enrollment cat^enrollment stat^enrollment
|
|---|
| 139 | ;priority^purple heart ind.^obs pat ind^encounter num^agent orange
|
|---|
| 140 | ;loc^production div^pow loc^source of admission^head & neck canc. ind
|
|---|
| 141 | ;^ethnicity^race1^enrollment priority_sub group^user enrollee^patient
|
|---|
| 142 | ;type^combat vet elig^combat vet elig end date^enc cv eligible^
|
|---|
| 143 | ;national patient record flag ECXNPRFI^att phy person class ECXATTPC
|
|---|
| 144 | ;^primary ward provider person class ECXPRVPC^environ contamin ECXEST
|
|---|
| 145 | ;^emergency response indicator(FEMA) ECXERI^agent orange indic ECXAO
|
|---|
| 146 | ;^environ contam ECXECE^encoun head/neck ECXHNC^encoun MST ECXMIL^rad
|
|---|
| 147 | ;encoun ECXIR
|
|---|
| 148 | ;
|
|---|
| 149 | ;Convert specialty to PTF Code
|
|---|
| 150 | ;
|
|---|
| 151 | N ECXDATA
|
|---|
| 152 | S ECXDATA=$$TSDATA^DGACT(42.4,+ECXSPC,.ECXDATA)
|
|---|
| 153 | S ECXSPC=$G(ECXDATA(7))
|
|---|
| 154 | ;
|
|---|
| 155 | N DA,DIK
|
|---|
| 156 | S EC7=$O(^ECX(ECFILE,999999999),-1),EC7=EC7+1
|
|---|
| 157 | S ECODE=EC7_U_EC23_U_ECXFAC_U_ECXDFN_U_ECXSSN_U_ECXPNM_U_ECXA_U_ECXDATE_U
|
|---|
| 158 | S ECODE=ECODE_ECPTTM_U_ECXSEX_U_ECXDOB_U_ECXRELG_U
|
|---|
| 159 | S ECODE=ECODE_ECXEMP_U_ECXHI_U_ECXSTATE_U_ECXCNTY_U_ECXZIP_U
|
|---|
| 160 | S ECODE=ECODE_ECXELIG_U_ECXVET_U_ECXVNS_U_ECXAST_U_ECXRST_U_ECXPST_U
|
|---|
| 161 | S ECODE=ECODE_ECXPOS_U_ECXMNS_U_ECXMAR_U
|
|---|
| 162 | S ECODE=ECODE_ECXWRD_U_ECXSPC_U_ECXATT_U_ECDA_U_ECDRG_U_ECDIA_U
|
|---|
| 163 | S ECODE=ECODE_ECTM_U_ECPTPR_U_ECXRACE_U_ECXPRV_U
|
|---|
| 164 | S ECODE1=ECXMPI_U_ECXDSSD_U_ECXATNPI_U_ECPTNPI_U_ECXPRNPI_U_ELGA_U
|
|---|
| 165 | S ECODE1=ECODE1_ECXMST_U_U_U_U_ECXENRL_U_ECCLAS_U
|
|---|
| 166 | S ECODE1=ECODE1_ECASPR_U_ECCLAS2_U_ECASNPI_U_ECXDOM_U_ECXCAT_U
|
|---|
| 167 | S ECODE1=ECODE1_ECXSTAT_U_$S(ECXLOGIC<2005:ECXPRIOR,1:"")_U_ECXPHI_U_ECXOBS_U_ECXENC_U_ECXAOL_U
|
|---|
| 168 | S ECODE1=ECODE1_ECXPDIV_U_ECXPLOC_U_ECXSADM_U_ECXHNCI_U_ECXETH_U
|
|---|
| 169 | S ECODE1=ECODE1_ECXRC1
|
|---|
| 170 | I ECXLOGIC>2004 S ECODE1=ECODE1_U_ECXPRIOR_ECXSBGRP_U_ECXUESTA_U_ECXPTYPE_U_ECXCVE_U_ECXCVEDT_U_ECXCVENC_U_ECXNPRFI
|
|---|
| 171 | I ECXLOGIC>2005 S ECODE1=ECODE1_U_ECXATTPC_U_ECXPRVPC_U_ECXEST
|
|---|
| 172 | I ECXLOGIC>2006 S ECODE1=ECODE1_U_ECXERI_U_ECXAO_U_ECXECE_U_ECXHNC_U_ECXMIL_U_ECXIR
|
|---|
| 173 | S ^ECX(ECFILE,EC7,0)=ECODE,^ECX(ECFILE,EC7,1)=ECODE1
|
|---|
| 174 | S ECRN=ECRN+1
|
|---|
| 175 | S DA=EC7,DIK="^ECX("_ECFILE_"," D IX1^DIK K DIK,DA
|
|---|
| 176 | Q
|
|---|
| 177 | ;
|
|---|
| 178 | SETUP ;Set required input for ECXTRAC.
|
|---|
| 179 | S ECHEAD="ADM"
|
|---|
| 180 | D ECXDEF^ECXUTL2(ECHEAD,.ECPACK,.ECGRP,.ECFILE,.ECRTN,.ECPIECE,.ECVER)
|
|---|
| 181 | Q
|
|---|
| 182 | ;
|
|---|
| 183 | LOCAL ; to extract nightly for local use not to be transmitted to TSI
|
|---|
| 184 | ; should be queued with a 1D frequency
|
|---|
| 185 | D SETUP,^ECXTLOCL,^ECXKILL Q
|
|---|
| 186 | ;
|
|---|
| 187 | QUE ; entry point for the background requeuing handled by ECXTAUTO
|
|---|
| 188 | D SETUP,QUE^ECXTAUTO,^ECXKILL Q
|
|---|
| 189 | ;
|
|---|
