Produced by Araxis Merge on 6/20/2018 10:12:21 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\CCRS-BUSRULES-v1.5.3.zip\CCRS-BUSRULES-v1.5.3-436e6fff1115001d614ccd45b469ad60a9bdb27b\brengine\src\test\resources\sql\utils | demo.sql | Tue Apr 10 06:18:41 2018 UTC |
2 | CCRS.zip\CCRS\CCRS-BUSRULES-v1.5.3.zip\CCRS-BUSRULES-v1.5.3-436e6fff1115001d614ccd45b469ad60a9bdb27b\brengine\src\test\resources\sql\utils | demo.sql | Tue Jun 19 17:10:26 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 4 | 70 |
Changed | 3 | 12 |
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 | -- test cl aimlines a re all wit h batch id : 'AA_2017 1024_A' | |
2 | select dis tinct c.cl aim_key, c .etl_batch _id, f.cla im_detail_ key, f.etl _batch_id, f.pos_key , pr.npi a s provider , p.member _id as pat ient, f.se rvice_date _from, f.s ervice_dat e_to, f.ch arge_amoun t | |
3 | from dbo.d im_va_clai m c join d bo.F_PROFE SSIONAL_ME DICAL_CLAI M_DETAILS f on c.cla im_key = f .claim_key | |
4 | join dbo.DIM_PR OVIDER pr on pr.prov ider_key = c.billing _provider_ key | |
5 | j oin dbo.DI M_PATIENT p on p.pat ient_key = c.patient _key | |
6 | where c.et l_batch_id = 'AA_201 71024_A' | |
7 | order by p os_key, pr ovider, pa tient, ser vice_date_ from, serv ice_date_t o, charge_ amount | |
8 | ||
9 | -- matchin g claimlin es are pre viously AP PROVED: | |
10 | select dis tinct c.cl aim_key, c .etl_batch _id, f.cla im_detail_ key, f.etl _batch_id, f.pos_key , pr.npi a s provider , p.member _id as pat ient, f.se rvice_date _from, f.s ervice_dat e_to, f.ch arge_amoun t | |
11 | from dbo.d im_va_clai m c join d bo.F_PROFE SSIONAL_ME DICAL_CLAI M_DETAILS f on c.cla im_key = f .claim_key | |
12 | join dbo.DIM_PR OVIDER pr on pr.prov ider_key = c.billing _provider_ key | |
13 | j oin dbo.DI M_PATIENT p on p.pat ient_key = c.patient _key | |
14 | j oin dbo.de cision d o n d.claim_ detail_key = f.claim _detail_ke y | |
15 | where d.de cision = ' APPROVED' | |
16 | order by p os_key, pr ovider, pa tient, ser vice_date_ from, serv ice_date_t o, charge_ amount | |
17 | ||
18 | -- update dbo.F_PROF ESSIONAL_M EDICAL_CLA IM_DETAILS set charg e_amount = 101 where claim_det ail_key = 431 | |
19 | ||
20 | ||
21 | -- Check i f decision has previ ous result for testi ng claims: | |
22 | select d.* , v.* from dbo.decis ion d join dbo.valid ation_fail ure v on d .decision_ key = v.de cision_key | |
23 | where d.et l_batch_id = 'AA_201 71024_A' | |
24 | ||
25 | -- delete testing da ta if ther e are some : | |
26 | -- delete from dbo.d ecision wh ere etl_ba tch_id = ' AA_2017102 4_A' | |
27 | ||
28 | -- Now go to RESTful api and r un: | |
29 | -- 1: proc ess duplic ate rule a gaist test claims | |
30 | -- http:// IP | |
31 | -- http:// DNS URL.PO RT | |
32 | -- 2: chec k log to s ee if proc ess is wor king | |
33 | -- http:// IP.PORT | |
34 | -- http:// DNS URL. P ORT | |
35 | -- 3: chec k decision to see if duplicate claimline is record ed | |
36 | -- http:// IP | |
37 | -- http:// DNS URL.PO RT | |
38 | ||
39 | -- Check i f decision has new r esult for testing cl aims: | |
40 | select d.* , v.* from dbo.decis ion d join dbo.valid ation_fail ure v on d .decision_ key = v.de cision_key | |
41 | where d.et l_batch_id = 'AA_201 71024_A' |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.