Produced by Araxis Merge on 6/20/2018 10:27:47 AM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | CCRS.zip\CCRS\Reports-Sprint_5.zip\Reports-Sprint_5-aa03f94869cda45ee08ca75641e61a7376f2c2a5 | Detail_Report.sql | Fri Mar 30 15:47:12 2018 UTC |
2 | CCRS.zip\CCRS\Reports-Sprint_5.zip\Reports-Sprint_5-aa03f94869cda45ee08ca75641e61a7376f2c2a5 | Detail_Report.sql | Fri Jun 15 13:04:49 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 5 | 334 |
Changed | 4 | 8 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | USE [ccrsd b] | |
2 | GO | |
3 | /****** Ob ject: Sto redProcedu re [dbo].[ IPPS_Invoi ce_DataFee d_Detail] Script Date: 3/3/ 2018 10:35 :26 AM *** ***/ | |
4 | SET ANSI_N ULLS ON | |
5 | GO | |
6 | SET QUOTED _IDENTIFIE R ON | |
7 | GO | |
8 | ALTER PROC EDURE [dbo ].[IPPS_In voice_Data Feed_Detai l] | |
9 | AS | |
10 | BEGIN | |
11 | DECLARE @Inv_Num A S varchar( 3) | |
12 | ||
13 | SET @Inv _Num = '01 ' | |
14 | ||
15 | DECLARE @Network_I D_Val AS i nteger | |
16 | ||
17 | SET @Net work_ID_Va l = @@ROWC OUNT | |
18 | ||
19 | DECLARE @Oblig_Num AS varcha r(6) | |
20 | ||
21 | SET @Obl ig_Num = ' C12345' | |
22 | ||
23 | DECLARE @Formatted _Date AS v archar(8) | |
24 | ||
25 | SET @For matted_Dat e = Concat ('0', DATE PART(MONTH , GETDATE( )), | |
26 | DATEPART (DAY, GETD ATE())) | |
27 | ||
28 | DECLARE @Two_Digit _Yr AS var char(2) | |
29 | ||
30 | SET @Two _Digit_Yr = RIGHT(DA TEPART(YEA R, GETDATE ()), 2) | |
31 | ||
32 | DECLARE @Full_Inv_ Num AS var char(20) | |
33 | ||
34 | SET @Ful l_Inv_Num = Concat(' -', @Two_D igit_Yr, @ Formatted_ Date, '-', | |
35 | @Inv_Num , '-', @Ob lig_Num) | |
36 | ||
37 | DECLARE @Net_ID AS integer | |
38 | ||
39 | SET @Net _ID = 001 | |
40 | ||
41 | DECLARE @Status_Ty pe AS varc har(20) | |
42 | ||
43 | SET @Sta tus_type = 'Approved ' | |
44 | ||
45 | DECLARE @Status_A AS varchar (20) | |
46 | ||
47 | SET @Sta tus_A = 'A PPROVED' | |
48 | ||
49 | SELECT | |
50 | Conca t('N', CAS E billing_ provider_k ey | |
51 | WHEN '5280469' THEN '1' | |
52 | WHEN '5280573' THEN '2' | |
53 | WHEN '5280572' THEN '3' | |
54 | ELSE '4' | |
55 | END, @ Full_Inv_N um) AS Ful l_Inv_Num, | |
56 | @O blig_Num A S Oblig_Nu m, | |
57 | T. tax_id, | |
58 | T. start_date as Date_R eceived, | |
59 | --T.Re ferral_Num ber, | |
60 | T. ReferralNu mber, | |
61 | T .charge_am ount [char ge_amount] , | |
62 | T .service_d ate, | |
63 | T .claim_key | |
64 | ||
65 | ||
66 | FROM (SE LECT | |
67 | CLAIM. billing_pr ovider_key , | |
68 | PROV.t ax_id, | |
69 | decisi on.decisio n_key, | |
70 | DENT.c harge_amou nt [charge _amount], | |
71 | DENT.s ervice_dat e, | |
72 | de nt.claim_k ey, | |
73 | CLAIM. start_date , | |
74 | CLAIM. referral_n umber, | |
75 | REF.Re ferralNumb er | |
76 | FROM F_D ENTAL_CLAI M_DETAILS DENT | |
77 | INNER JO IN dbo.dec ision | |
78 | ON DEN T.claim_de tail_key = decision. claim_deta il_key | |
79 | AND DE NT.claim_k ey = decis ion.claim_ key | |
80 | AND de cision.dec ision = 'A PPROVED' | |
81 | INNER JO IN dbo.DIM _VA_CLAIM CLAIM | |
82 | ON DEN T.claim_ke y = CLAIM. claim_key | |
83 | INNER JO IN ccra.Re ferral REF | |
84 | ON CLA IM.referra l_number = REF.Refer ralNumber | |
85 | INNER JO IN [dbo].[ DIM_PROVID ER] PROV | |
86 | ON CLA IM.billing _provider_ key = PROV .PROVIDER_ KEY | |
87 | AND PR OV.tax_id IS NOT NUL L | |
88 | AND PR OV.tax_id <> '' | |
89 | Wh ere billin g_provider _key = AI | |
90 | ||
91 | UNION | |
92 | ||
93 | SELECT | |
94 | CLAIM. billing_pr ovider_key , | |
95 | PROV.t ax_id, | |
96 | decisi on.decisio n_key, | |
97 | INST.c harge_amou nt [charge _amount], | |
98 | INST.s ervice_dat e, | |
99 | in st.claim_k ey, | |
100 | CLAIM. start_date , | |
101 | CLAIM. referral_n umber, | |
102 | REF.Re ferralNumb er | |
103 | FROM F_I NSTITUTION AL_MEDICAL _CLAIM_DET AILS INST | |
104 | INNER JO IN dbo.dec ision | |
105 | ON INS T.claim_de tail_key = decision. claim_deta il_key | |
106 | AND IN ST.claim_k ey = decis ion.claim_ key | |
107 | AND de cision.dec ision = 'A PPROVED' | |
108 | INNER JO IN dbo.DIM _VA_CLAIM CLAIM | |
109 | ON INS T.claim_ke y = CLAIM. claim_key | |
110 | INNER JO IN ccra.Re ferral REF | |
111 | ON CLA IM.referra l_number = REF.Refer ralNumber | |
112 | INNER JO IN [dbo].[ DIM_PROVID ER] PROV | |
113 | ON CLA IM.billing _provider_ key = PROV .PROVIDER_ KEY | |
114 | AND PR OV.tax_id IS NOT NUL L | |
115 | AND PR OV.tax_id <> '' | |
116 | Wh ere billin g_provider _key = AI | |
117 | UNION | |
118 | ||
119 | SELECT | |
120 | CLAIM. billing_pr ovider_key , | |
121 | PROV.t ax_id, | |
122 | decisi on.decisio n_key, | |
123 | PROF.c harge_amou nt [charge _amount], | |
124 | PROF.s ervice_dat e_to servi ce_date, | |
125 | pr of.claim_k ey, | |
126 | CLAIM. start_date , | |
127 | CLAIM. referral_n umber, | |
128 | REF.Re ferralNumb er | |
129 | FROM F_P ROFESSIONA L_MEDICAL_ CLAIM_DETA ILS PROF | |
130 | INNER JO IN dbo.dec ision | |
131 | ON PRO F.claim_de tail_key = decision. claim_deta il_key | |
132 | AND PR OF.claim_k ey = decis ion.claim_ key | |
133 | AND de cision.dec ision = 'A PPROVED' | |
134 | INNER JO IN dbo.DIM _VA_CLAIM CLAIM | |
135 | ON PRO F.claim_ke y = CLAIM. claim_key | |
136 | INNER JO IN ccra.Re ferral REF | |
137 | ON CLA IM.referra l_number = REF.Refer ralNumber | |
138 | INNER JO IN [dbo].[ DIM_PROVID ER] PROV | |
139 | ON CLA IM.billing _provider_ key = PROV .PROVIDER_ KEY | |
140 | AND PR OV.tax_id IS NOT NUL L | |
141 | AND PR OV.tax_id <> '' | |
142 | Wh ere billin g_provider _key = AI | |
143 | UNION | |
144 | ||
145 | SELECT | |
146 | CLAIM. billing_pr ovider_key , | |
147 | PROV.t ax_id, | |
148 | decisi on.decisio n_key, | |
149 | PHARM. net_amount _due [char ge_amount] , | |
150 | PHARM. start_date service_d ate, | |
151 | ph arm.claim_ key, | |
152 | CLAIM. start_date , | |
153 | CLAIM. referral_n umber, | |
154 | REF.Re ferralNumb er | |
155 | FROM F_P HARMACY_CL AIM_DETAIL S PHARM | |
156 | INNER JO IN dbo.dec ision | |
157 | ON PHA RM.claim_d etail_key = decision .claim_det ail_key | |
158 | AND PH ARM.claim_ key = deci sion.claim _key | |
159 | AND de cision.dec ision = 'A PPROVED' | |
160 | INNER JO IN dbo.DIM _VA_CLAIM CLAIM | |
161 | ON PHA RM.claim_k ey = CLAIM .claim_key | |
162 | INNER JO IN ccra.Re ferral REF | |
163 | ON CLA IM.referra l_number = REF.Refer ralNumber | |
164 | INNER JO IN [dbo].[ DIM_PROVID ER] PROV | |
165 | ON CLA IM.billing _provider_ key = PROV .PROVIDER_ KEY | |
166 | AND PR OV.tax_id IS NOT NUL L | |
167 | AND PR OV.tax_id <> '') T | |
168 | Wh ere billin g_provider _key = AI | |
169 | ||
170 | ||
171 | END |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.