1 | IBJDF51 ;ALB/RB - CHAMPVA/TRICARE FOLLOW-UP REPORT (COMPILE);15-APR-00
|
---|
2 | ;;2.0;INTEGRATED BILLING;**123,185,240,356**;21-MAR-94
|
---|
3 | ;;Per VHA Directive 2004-038, this routine should not be modified.
|
---|
4 | ;
|
---|
5 | ST ; - Tasked entry point.
|
---|
6 | K IB,^TMP("IBJDF5",$J) S IBQ=0
|
---|
7 | ;
|
---|
8 | ; - Set selected categories for report.
|
---|
9 | I IBSEL[1 S IBCAT(31)=1
|
---|
10 | I IBSEL[2 S IBCAT(19)=2
|
---|
11 | I IBSEL[3 S IBCAT(30)=3
|
---|
12 | I IBSEL[4 S IBCAT(32)=4
|
---|
13 | I IBSEL[5 S IBCAT(29)=5
|
---|
14 | I IBSEL[6 S IBCAT(28)=6
|
---|
15 | ;
|
---|
16 | ; Initialize the Summary Information
|
---|
17 | S IBCAT="" F S IBCAT=$O(IBCAT(IBCAT)) Q:IBCAT="" D
|
---|
18 | . S IBDIV=0
|
---|
19 | . I IBSD,IBCAT'=31 D Q
|
---|
20 | . . F S IBDIV=$O(VAUTD(IBDIV)) Q:IBDIV="" D INIT^IBJDF53
|
---|
21 | . D INIT^IBJDF53
|
---|
22 | ;
|
---|
23 | ; - Print the header line for the Excel spreadsheet
|
---|
24 | I $G(IBEXCEL) D PHDL
|
---|
25 | ;
|
---|
26 | ; - Find data required for the report.
|
---|
27 | S IBA=0 F S IBA=$O(^PRCA(430,"AC",16,IBA)) Q:'IBA D Q:IBQ
|
---|
28 | . I IBA#100=0 D Q:IBQ
|
---|
29 | . . S IBQ=$$STOP^IBOUTL("CHAMPVA/Tricare Follow-Up Report")
|
---|
30 | . S IBAR=$G(^PRCA(430,IBA,0)) Q:'IBAR
|
---|
31 | . I $P($G(^DGCR(399,IBA,0)),U,13)=7 Q ; Cancelled claim.
|
---|
32 | . S IBCAT=+$P(IBAR,U,2) Q:'$D(IBCAT(IBCAT)) ; Invalid AR category.
|
---|
33 | . S IBCAT1=IBCAT(IBCAT)
|
---|
34 | . ;
|
---|
35 | . ; - Get division, if necessary.
|
---|
36 | . I IBCAT1=1 S IBDIV=0 ; CHAMPVA/Tricare Patient
|
---|
37 | . ;
|
---|
38 | . I IBCAT1'=1 D ; Others
|
---|
39 | . . I 'IBSD S IBDIV=0 Q
|
---|
40 | . . S IBDIV=$$DIV(IBA)
|
---|
41 | . ;
|
---|
42 | . I IBSD,IBDIV,'VAUTD Q:'$D(VAUTD(IBDIV)) ; Not a selected division.
|
---|
43 | . ;
|
---|
44 | . ; - Determine whether AR has corresponding IB action or claim and
|
---|
45 | . ; whether action/claim is inpatient, outpatient, or RX refill.
|
---|
46 | . S IBAC=$$CLMACT^IBJD(IBA,IBCAT) Q:IBAC=""!(+IBAC=3)
|
---|
47 | . I +IBAC=1 D
|
---|
48 | . . S X=$P($G(^IB($P(IBAC,U,2),0)),U,3)
|
---|
49 | . . S X=$P($G(^IBE(350.1,X,0)),U)
|
---|
50 | . . S IBTYP=$S(X["RX":3,X["OPT":2,1:1)
|
---|
51 | . I +IBAC'=1 D
|
---|
52 | . . S IBTYP=$S($P($G(^DGCR(399,IBA,0)),U,5)>2:2,1:1)
|
---|
53 | . . I $D(^IBA(362.4,"C",IBA)) S IBTYP=3
|
---|
54 | . ;
|
---|
55 | . I IBSEL1'[IBTYP,IBSEL1'[4 Q
|
---|
56 | . ;
|
---|
57 | . I IBRPT="D" S IBPT=$$PAT(IBA) Q:IBPT="" ; Get patient info.
|
---|
58 | . ;
|
---|
59 | . I '$G(IBEXCEL) D EN^IBJDF53 Q:IBRPT="S" ; Get stats for summary.
|
---|
60 | . ;
|
---|
61 | . ; - Get insurance info.
|
---|
62 | . S (IBI,IBIN)=0
|
---|
63 | . I $G(^DGCR(399,IBA,"MP")) D I 'IBI Q
|
---|
64 | . . S IBI=+$G(^DGCR(399,IBA,"MP")) I 'IBI S IBIN="*** UNKNOWN ***" Q
|
---|
65 | . . S IBIN=$P($G(^DIC(36,IBI,0)),U)_"@@"_IBI
|
---|
66 | . ;
|
---|
67 | . ; - Check the receivable age, if necessary.
|
---|
68 | . I IBSMN D Q:IBARD<IBSMN!(IBARD>IBSMX)
|
---|
69 | . . S IBARD=+$$ACT^IBJDF2(IBA) S:IBARD IBARD=$$FMDIFF^XLFDT(DT,IBARD)
|
---|
70 | . ;
|
---|
71 | . ; - Check the minimum balance amount, if necessary.
|
---|
72 | . S IBBA=0 F X=1:1:5 S IBBA=IBBA+$P($G(^PRCA(430,IBA,7)),U,X)
|
---|
73 | . I IBSAM,IBBA<IBSAM Q
|
---|
74 | . ;
|
---|
75 | . ; - Get remaining AR/claim information.
|
---|
76 | . S IBDP=$P(IBAR,U,10),X=$$CLMACT^IBJD(IBA,IBCAT) Q:X=""
|
---|
77 | . S IBBU=$S(+IBAC=1:$G(^IB($P(IBAC,U,2),0)),1:$G(^DGCR(399,IBA,"U")))
|
---|
78 | . S IBFR=$P(IBBU,U,$S(+IBAC=1:14,1:1))
|
---|
79 | . S IBTO=$P(IBBU,U,$S(+IBAC=1:15,1:2))
|
---|
80 | . S DFN=$P(IBPT,U,5),IBSID=$$SID(DFN,IBI)
|
---|
81 | . S IBOI=$$OTH(DFN,IBI,IBFR),IBVA=$$VA^IBJD1(DFN)
|
---|
82 | . S IBBN=$P(IBAR,U),IBOR=$P(IBAR,U,3)
|
---|
83 | . ;
|
---|
84 | . ; - Set up indexes for detail report.
|
---|
85 | . I $G(IBEXCEL) D Q
|
---|
86 | . . S IBDIV=$P($G(^DG(40.8,$S('IBDIV:+$$PRIM^VASITE(),1:IBDIV),0)),U)
|
---|
87 | . . ;
|
---|
88 | . . S IBEXCEL1=$P(IBPT,U,2)_U_IBVA_U_$P(IBPT,U,3)_U_$TR($P(IBPT,U,4),"-")
|
---|
89 | . . S IBEXCEL1=IBEXCEL1_U_$S(IBIN=0:"",1:$E($P(IBIN,"@@"),1,12))_U_$E(IBOI,1,12)
|
---|
90 | . . S IBEXCEL1=IBEXCEL1_U_$$DT^IBJD(IBDP,1)_U_$$DT^IBJD(IBFR,1)
|
---|
91 | . . S IBEXCEL1=IBEXCEL1_U_$$DT^IBJD(IBTO,1)_U_IBSID_U_IBBN_U_IBOR
|
---|
92 | . . S IBEXCEL1=IBEXCEL1_U_IBBA_U_$P($G(^PRCA(430.2,IBCAT,0)),U,2)
|
---|
93 | . . S IBEXCEL1=IBEXCEL1_U_$E("IOR",IBTYP)_U
|
---|
94 | . . I IBSH D COM ; This will capture the Last Comment Date
|
---|
95 | . . S IBD=$$FMDIFF^XLFDT(DT,$S('$P(IBEXCEL1,U,16):IBDP,1:$G(DAT)))
|
---|
96 | . . S IBEXCEL1=IBEXCEL1_U_IBD_U_$E(IBDIV,1,12) W !,IBEXCEL1 K IBD,IBEXCEL1
|
---|
97 | . ;
|
---|
98 | . S IBKEY=$P(IBPT,U)_"@@"_$S($G(IBPT):IBDP,1:IBFR_"/"_IBTO)
|
---|
99 | . F X=IBTYP,4 I IBSEL1[X D
|
---|
100 | . . I '($D(^TMP("IBJDF5",$J,IBDIV,IBCAT,X,IBIN,IBKEY))#10) D
|
---|
101 | . . . S ^TMP("IBJDF5",$J,IBDIV,IBCAT,X,IBIN,IBKEY)=$P(IBPT,U,2)_" "_IBVA_U_$P(IBPT,U,3,4)_U_IBOI
|
---|
102 | . . S ^TMP("IBJDF5",$J,IBDIV,IBCAT,X,IBIN,IBKEY,IBBN)=IBDP_U_IBFR_U_IBTO_U_IBOR_U_IBBA_U_IBSID
|
---|
103 | . . I IBSH D COM
|
---|
104 | ;
|
---|
105 | I 'IBQ,'$G(IBEXCEL) D EN^IBJDF52 ; Print the report.
|
---|
106 | ;
|
---|
107 | ENQ K ^TMP("IBJDF5",$J)
|
---|
108 | I $D(ZTQUEUED) S ZTREQ="@" G ENQ1
|
---|
109 | ;
|
---|
110 | D ^%ZISC
|
---|
111 | ENQ1 K IB,IBA,IBA1,IBAR,IBARD,IBBU,IBC,IBCAT,IBCAT1,IBDIV,IBD,IBI,IBQ,IBPT
|
---|
112 | K IBDP,IBKEY,IBVA,IBAC,IBBA,IBBN,IBFR,IBIN,IBOI,IBOR,IBSID,IBTO,IBTYP
|
---|
113 | K COM,COM1,DAT,DFN,J,X,X1,X2,Y,Z D KVA^VADPT
|
---|
114 | Q
|
---|
115 | ;
|
---|
116 | PAT(IBDA) ; - Find the claim patient and decide to include the claim.
|
---|
117 | ; Input: IBDA=Pointer to the claim/AR in file #399/#430 plus all
|
---|
118 | ; variable input in IBS*
|
---|
119 | ; Output: Y=Sort key (name or last 4)_@@_patient IEN to file #2
|
---|
120 | ; ^ Patient name ^ Age ^ SSN ^ Patient IEN to file #2
|
---|
121 | N AGE,ALL,ARZ,DA,DBTR,DFN,DIC,DIQ,DOB,DR,END,IBZ,INI,KEY,NAME,RCZ,SSN
|
---|
122 | N VADM,Y,Z
|
---|
123 | ;
|
---|
124 | S Y="" G:'$G(IBDA) PATQ
|
---|
125 | S DFN=0,(NAME,AGE,SSN)="",ARZ=$G(^PRCA(430,IBDA,0))
|
---|
126 | ;
|
---|
127 | ; - Look for Patient (Corresponding Claim in IB)
|
---|
128 | I $D(^DGCR(399,IBDA,0)) D I 'DFN S Y="" G PATQ
|
---|
129 | . S IBZ=^DGCR(399,IBDA,0),DFN=+$P(IBZ,"^",2)
|
---|
130 | . D DEM^VADPT S NAME=VADM(1),SSN=$P(VADM(2),"^",2),AGE=VADM(4)
|
---|
131 | ;
|
---|
132 | ; - Look for Debtor (No corresponding Claim in IB)
|
---|
133 | I '$D(^DGCR(399,IBDA,0)) D I 'DFN S Y="" G PATQ
|
---|
134 | . S DBTR=+$P(ARZ,"^",9) I 'DBTR Q
|
---|
135 | . S RCZ=$G(^RCD(340,DBTR,0)),DFN=+RCZ
|
---|
136 | . I $P(RCZ,"^")["DPT" D
|
---|
137 | . . D DEM^VADPT S NAME=VADM(1),SSN=$P(VADM(2),"^",2),AGE=VADM(4)
|
---|
138 | . I $P(RCZ,"^")'["DPT" D
|
---|
139 | . . S DIC="^PRCA(430,",DA=IBDA,DR=9,DIQ="DEB" D EN^DIQ1
|
---|
140 | . . S NAME=$G(DEB(430,DA,9)),KEY=NAME
|
---|
141 | . . S DIC="^RCD(340,",DA=DBTR,DR=110,DIQ="DEB" D EN^DIQ1
|
---|
142 | . . S SSN=$G(DEB(340,DA,110))
|
---|
143 | . . I SSN S SSN=$E(SSN,1,3)_"-"_$E(SSN,4,5)_"-"_$E(SSN,6,9)
|
---|
144 | ;
|
---|
145 | S KEY=$S(IBSN="N":NAME,1:+$P(SSN,"-",3))
|
---|
146 | S INI=IBSNF,END=IBSNL,ALL=IBSNA
|
---|
147 | I (INI'="@"&('DFN)) S Y="" G PATQ
|
---|
148 | I ALL="ALL"&('DFN)!(ALL="NULL"&(DFN)) S Y="" G PATQ
|
---|
149 | I INI="@",END="zzzzz" G PATC
|
---|
150 | I INI]KEY!(KEY]END) S Y="" G PATQ
|
---|
151 | ;
|
---|
152 | PATC ; - Find all patient data.
|
---|
153 | S Y=KEY_"@@"_DFN_U_$E(NAME,1,25)_U_AGE_U_SSN_"^"_DFN
|
---|
154 | PATQ Q Y
|
---|
155 | ;
|
---|
156 | DIV(CLM) ;Find the default division of the bill.
|
---|
157 | S DIV=$P($G(^DGCR(399,CLM,0)),"^",22)
|
---|
158 | QDIV S:'DIV DIV=$$PRIM^VASITE() S:DIV'>0 DIV=0
|
---|
159 | Q DIV
|
---|
160 | SID(DFN,INS) ; - Find the subscriber ID for a bill (if any).
|
---|
161 | ; Input: DFN=Pointer to the patient in file #2
|
---|
162 | ; INS=Pointer to the patient's primary carrier in file #36
|
---|
163 | ; Output: Subscriber ID no. or null
|
---|
164 | N X,Y,Z S Y="" G:'$G(DFN)!('$G(INS)) SIDQ
|
---|
165 | S Z=0 F S Z=$O(^DPT(DFN,.312,Z)) Q:'Z S X=$G(^(Z,0)) D Q:Y]""
|
---|
166 | .I +X=INS S Y=$E($P(X,U,2),1,16)
|
---|
167 | ;
|
---|
168 | SIDQ Q Y
|
---|
169 | ;
|
---|
170 | PHDL ; - Print the header line for the Excel spreadsheet
|
---|
171 | N X
|
---|
172 | S X="Patient^VA Empl.?^Age^SSN^Prim.Ins.Carrier^Other Ins.Carrier^"
|
---|
173 | S X=X_"Dt Bill prep.^Bill From Dt^Bill To Dt^Subsc.ID^Bill #^"
|
---|
174 | S X=X_"Orig.Amt^Curr.Bal.^Cat.^Bill Type^Lst Comm.Dt^Days Lst Comm.^"
|
---|
175 | S X=X_"Division"
|
---|
176 | W !,X
|
---|
177 | Q
|
---|
178 | ;
|
---|
179 | OTH(DFN,INS,DS) ; - Find a patient's other valid insurance carrier (if any).
|
---|
180 | ; Input: DFN=Pointer to the patient in file #2
|
---|
181 | ; INS=Pointer to the patient's primary carrier in file #36
|
---|
182 | ; DS=Date of service for validity check
|
---|
183 | ; Output: Valid insurance carrier (first 15 chars.) or null
|
---|
184 | N X,X1,Y,Z S Y="" G:'$G(DFN)!('$G(INS))!('$G(DS)) OTHQ
|
---|
185 | S Z=0 F S Z=$O(^DPT(DFN,.312,Z)) Q:'Z S X=$G(^(Z,0)) D:X Q:Y]""
|
---|
186 | .I +X=INS Q
|
---|
187 | .S X1=$G(^DIC(36,+X,0)) Q:X1=""
|
---|
188 | .I $P(X1,U,2)'="N",$$CHK^IBCNS1(X,DS) S Y=$E($P(X1,U),1,15)
|
---|
189 | ;
|
---|
190 | OTHQ Q Y
|
---|
191 | ;
|
---|
192 | COM ; - Get bill comments.
|
---|
193 | S DAT=0,IBA1=$S(IBSH1="M":999999999,1:0)
|
---|
194 | F S IBA1=$S(IBSH1="M":$O(^PRCA(433,"C",IBA,IBA1),-1),1:$O(^PRCA(433,"C",IBA,IBA1))) Q:'IBA1 D I IBSH1="M",DAT Q
|
---|
195 | .S IBC=$G(^PRCA(433,IBA1,1)) Q:'IBC
|
---|
196 | .I $G(IBSH2),$$FMDIFF^XLFDT(DT,+IBC)<IBSH2 Q ; Comment age not minimum.
|
---|
197 | .I $P(IBC,U,2)'=35,$P(IBC,U,2)'=45 Q ; Not decrease/comment transact.
|
---|
198 | .S DAT=$S(IBC:+IBC\1,1:+$P(IBC,U,9)\1)
|
---|
199 | .I $G(IBEXCEL),IBSH1="M" S IBEXCEL1=IBEXCEL1_$$DT^IBJD(DAT,1) Q
|
---|
200 | .;
|
---|
201 | .; - Append brief and transaction comments.
|
---|
202 | .K COM,COM1 S COM(0)=DAT,X1=0
|
---|
203 | .S COM1(1)=$P($G(^PRCA(433,IBA1,5)),U,2)
|
---|
204 | .S COM1(2)=$E($P($G(^PRCA(433,IBA1,8)),U,6),1,70)
|
---|
205 | .S COM(1)=COM1(1)_$S(COM1(1)]""&(COM1(2)]""):"|",1:"")_COM1(2)
|
---|
206 | .I COM(1)]"" S COM(1)="**"_COM(1)_"**",X1=1
|
---|
207 | .;
|
---|
208 | .; - Get main comments.
|
---|
209 | .S X2=0 F S X2=$O(^PRCA(433,IBA1,7,X2)) Q:'X2 S COM($S(X1:X2+1,1:X2))=^(X2,0)
|
---|
210 | .;
|
---|
211 | .S X1="" F S X1=$O(COM(X1)) Q:X1="" D
|
---|
212 | ..S ^TMP("IBJDF5",$J,IBDIV,IBCAT,X,IBIN,IBKEY,IBBN,IBA1,X1)=COM(X1)
|
---|
213 | ;
|
---|
214 | Q
|
---|