20200. EPMO Open Source Coordination Office Redaction File Detail Report

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.

20200.1 Files compared

# 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

20200.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 4 70
Changed 3 12
Inserted 0 0
Removed 0 0

20200.3 Comparison options

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

20200.4 Active regular expressions

No regular expressions were active.

20200.5 Comparison detail

  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'