source: WorldVistAEHR/trunk/r/DSS_EXTRACTS-ECX/ECXADM.m@ 1200

Last change on this file since 1200 was 623, checked in by George Lilly, 15 years ago

revised back to 6/30/08 version
File size: 6.8 KB
Line 
1ECXADM ;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
3BEG ;entry point from option
4 D SETUP I ECFILE="" Q
5 D ^ECXTRAC,^ECXKILL
6 Q
7 ;
8START ; 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 ;
17GET ;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 ;
60PAT(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 ;
115PTF ; 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 ;
125FILE ;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 ;
178SETUP ;Set required input for ECXTRAC.
179 S ECHEAD="ADM"
180 D ECXDEF^ECXUTL2(ECHEAD,.ECPACK,.ECGRP,.ECFILE,.ECRTN,.ECPIECE,.ECVER)
181 Q
182 ;
183LOCAL ; 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 ;
187QUE ; entry point for the background requeuing handled by ECXTAUTO
188 D SETUP,QUE^ECXTAUTO,^ECXKILL Q
189 ;
Note: See TracBrowser for help on using the repository browser.