20. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 4/23/2019 12:14:29 PM 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.

20.1 Files compared

# Location File Last Modified
1 C:\AraxisMergeCompare\Pri_un\CCRS\CaseManagement-B6S3\CaseManagement-B6S3\Specifications\performance performanceMetrics.xlsx Thu Mar 28 18:39:56 2019 UTC
2 C:\AraxisMergeCompare\Pri_re\CCRS\CaseManagement-B6S3\CaseManagement-B6S3\Specifications\performance performanceMetrics.xlsx Wed Apr 17 03:03:46 2019 UTC

20.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 1 322
Changed 0 0
Inserted 0 0
Removed 0 0

20.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

20.4 Active regular expressions

No regular expressions were active.

20.5 Comparison detail

  1   SHEET: Met rics
  2   Tier,Monit or Target, Metric,Val ue,Tool,
  3   UI,REST AP I /console /login,Tot al page lo ad respons e time ,IE  Browser d evelopler  tools,
  4   Time to fi rst byte ,
  5   Receive ti me,
  6   Worklist p age frame  rendering  time (DOM  load event ),
  7   Number of  page eleme nts/page,
  8   Max page e lement dow nload time ,
  9   REST API   /folio_man agement/fo lio/search ,Total pag e load res ponse time  ,
  10   Time to fi rst byte ,
  11   Receive ti me,
  12   Worklist p age frame  rendering  time (DOM  load event ),
  13   Number of  page eleme nts/page,
  14   Max page e lement dow nload time ,
  15   REST API   /logical_o bject/meta data?folio id=xxx,Tot al page lo ad respons e time ,
  16   Time to fi rst byte ,
  17   Receive ti me,
  18   Worklist p age frame  rendering  time (DOM  load event ),
  19   Number of  page eleme nts/page,
  20   Max page e lement dow nload time ,
  21   Applicatio n,
  22   REST Calls  as define d in UI ti er,Time to  first byt e ? Or ser ver side l og ?,IE Br owser deve lopler too ls,
  23   Worker Nod e OS, Numb er of vCPU s,TOP, IOS TAT, or VM STAT,
  24   Total RAM,
  25   Peak CPU u tilization ,
  26   Peak Memor y utilizat ion,
  27   Peak Netwo rk utiliza tion,
  28  
  29  
  30   Container  Solution S erver , CP U % ,docke r stats,
  31   MEM USAGE  / LIMIT,
  32   MEM % ,
  33   NET I/O ,
  34   BLOCK I/O, NFS ?,
  35   PIDS,
  36   Container  Analytics  Server, CP U % ,docke r stats,
  37   MEM USAGE  / LIMIT,
  38   MEM % ,
  39   NET I/O ,
  40   BLOCK I/O, NFS ?,
  41   PIDS,
  42   Container  DB2 Server , CPU % ,d ocker stat s,
  43   MEM USAGE  / LIMIT,
  44   MEM % ,
  45   NET I/O ,
  46   BLOCK I/O, NFS ?,
  47   PIDS,
  48  
  49   Database,D B2 Claim q uery,
  50   DB2 Claim  Line query ,
  51  
  52   MS SQL Ser ver ETL Qu eries,
  53  
  54   Network Fi le IO,TBD,
  55   Block IO,N FS Master   Node IO,D evice: ,
  56   tps ,
  57   kB_read/s,
  58   kB_wrtn/s  ,
  59   total kB_w rtn,
  60   total kB_r ead,
  61   Worker Nod e IO,Devic e: ,
  62   tps ,
  63   kB_read/s,
  64   kB_wrtn/s  ,
  65   total kB_w rtn,
  66   total kB_r ead,
  67  
  68  
  69   SHEET: ETL
  70   Job Name,E xecution T ime (no da ta in Targ et),Execut ion Time 5 00000 clai ms in Targ et,Executi on Time 1, 000,000 cl aims in Ta rget,Execu tion Time  6,000,000  claims in  Target,
  71   sq_Load_KA FKA_WorkFl ow_Tables_ All ( kick s off the  KAFKA chec k process) ,
  72   sq_Load_FC I_WorkFlow _Tables_Al l   (KAFKA  then subm its this s equencer w hich when  runs does  the sourci ng and loa ding of th e focal ta bles ),
  73   ----- sour cing table s -------- ---------- ---------- -,
  74   jb_load_ba tch_claims ,
  75   jb_stg_dim _patient,
  76   jb_stg_dim _Taxonomy,
  77   jb_stg_dim _Va_Statio n,
  78   jb_stg_dim _va_claim,
  79   jb_stg_ccr a_referral ,
  80   jb_stg_dim _instituti onal_claim ,
  81   jb_stg_f_i nstitution al_med_clm _detail,
  82   jb_stg_f_p rofessiona l_med_clm_ detail,
  83   jb_stg_f_d ental_clai m_details,
  84   jb_stg_cla im_occurre nce,
  85   jb_stg_dia gnosis_cod e,
  86   jb_stg_cla im_occurre nce_span,
  87   jb_stg_ccr a_PreAutho rization,
  88   jb_stg_dim _admission _source,
  89   jb_stg_cla im_value_c ode,
  90   jb_stg_dim _claim_pat ient,
  91   jb_stg_dim _claim_pro vider,
  92   ---------- ---------- ---------- ---------- ---------- -,
  93   ---------- ---- loadi ng focal t ables begi ns ------- -,
  94   sq_Load_FC I_Focal_Fa ct_Tables_ All (in th is sequenc er multipl e jobs),
  95      .jb_Loa dFocal_Str eet_Addres s,
  96      .jb_Loa dFocal_Par ty,
  97      .jb_Loa dFocal_Par ty_Name,
  98      .jb_Loa dFocal_Ind ividual,
  99      .jb_Loa dFocal_Con tact_Point ,
  100      .jb_Loa dFocal_Par ty_Address _Ref,
  101      .jb_Loa dFocal_Par ty_Propert y,
  102      ,
  103    --------- ---------- ---------- ---------- -------,
  104    ,
  105     sq_Load_ FCI_Focal_ Provider_T ables (in  this seque ncer multi ple jobs),
  106      .jb_Loa dFocal_Pro vider_Part y_Name,
  107      .jb_Loa dFocal_Pro vider_Part y_Property _Taxonomy,
  108      .jb_Loa dFocal_Dim _VaStation _To_Party,
  109      .jb_Loa dFocal_Dim _VaStation _To_Party_ Name,
  110      .jb_Loa dFocal_Dim _VaStation _To_Identi fication,
  111      ,
  112   ---------- ---------- The other  loading jo bs in the  following  load order  --------- --------,
  113   jb_Transac tion_Recor ds,
  114   jb_Transac tion_Role_ Patient,
  115   jb_Patient _Addr_For_ St_Addr2,
  116   jb_Patient _Txn_Role_ Links3,
  117   b_Transact ion_Role_P rovider,
  118   jb_Provide r_Addr_For _St_Addr2,
  119   jb_Provide r_Txn_Role _Links3,
  120   jb_Provide r_Txn_Role _Links_B,
  121   jb_LoadFoc al_Tranx_R ole_To_Sta tion,
  122   jb_LoadFoc al_Tranx_R ole_To_Sta tion_ULink s,
  123   jb_Load_Cl aim_Value_ Code_Trans x_Property ,
  124   jb_Load_Cl aim_Occrnc Span_To_Tr ansx_Prope rty,
  125   jb_Load_Cl aim_Occrnc _To_Transx _Property,
  126   jb_Load_In stitutiona l_Claim_De tail,
  127   jb_Load_In stitu_Clai ms_Transx_ Property,
  128   jb_Load_In stitu_Clai m_Line_Tra nsx_Record ,
  129   jb_Load_F_ Institutio nal_Med_Cl aim_Detail _Transx_Di sposition,
  130   jb_Load_F_ Institu_Me dClaims_Tr ansx_Prope rty,
  131   jb_Load_In stitu_Clai m_Line_Tra nsx_Relati onship,
  132   jb_Load_F_ Prof_MedCl aim_Detail _Transx_Re cord,
  133   jb_Load_F_ Prof_MedCl aim_Detail _Transx_Di sposition,
  134   jb_Load_F_ Prof_MedCl aims_Trans x_Property ,
  135   jb_Load_F_ Prof_Claim _Line_Tran sx_Relatio nship,
  136   jb_Load_F_ Prof_MedCl aim_Trans_ Role_Provi der,
  137   jb_Load_f_ dental_Cla im_Transx_ Record,
  138   jb_Load_f_ dental_Cla im_Line_Tr ansx_Relat ionship,
  139   jb_Load_f_ dental_Cla ims_Transx _Property,
  140   ---------- ---------- ---------- ---------- ---------- --,
  141   sq_Referra ls (in thi s sequence r multiple  jobs),
  142    .jb_Load_ Referrals_ To_Event,
  143    .jb_Load_ Referrals_ To_Event_P roperty,
  144    .jb_Load_ Referrals_ To_TransEv ent_Relati onship,
  145    .jb_Load_ Referrals_ To_Event_R ole,
  146    .jb_Load_ Referrals_ To_EventRo leRenderrr ing,
  147    ,
  148    --------- ---------- ---------- ---------- ---------- --,
  149    ,
  150   sq_CoPayme ntStatus ( in this se quencer mu ltiple job s),
  151     .jb_Load _CoPayment Status_To_ Event,
  152     .jb_Load _CoPayment Status_To_ Event_Prop erty,
  153     .jb_Load _CoPayment Status_To_ EventRelat ionShip,
  154     ,
  155    --------- ---------- ---------- ---------- ---------- ----- ,
  156    ,
  157   sq_PreAuth orization  (in this s equencer m ultiple jo bs),
  158     .jb_Load _PreAuthor ization_To _Event,
  159     .jb_Load _PreAuthor ization_To _Event_Pro perty,
  160     .jb_Load _PreAuthor ization_To _EventRela tionShip,
  161     .jb_Load _PreAuthor ization_To _TransEven tRelationS hip,