Report- How to plot PA/VE ratio

book

Article ID: 106639

calendar_today

Updated On:

Products

CA Payment Security ARCOT ECOMMERCE

Issue/Introduction

The article describes on how we can plot the PA/VE ratio.


Environment

Release: ARCWTF05900-9.0-Arcot-WebFort-for TransFort for Windows
Component:

Resolution

The below steps describe how we can plot the PA/VE ratio table in Excel:

1. Identify for which Silo we need to run the report for. 
2. Login to TM console.
3. Under 'Transaction Report', click on 'Verify Enrollment Log'
 

<Please see attached file for image>

Transaction Manager
4. Download the report for last 30 mins, or chose the timestamp based on the requirement.
5. Open the downloaded report and select all the transactions
6. Navigate to 'Insert' tab within Excel and click on 'PivotTable'

<Please see attached file for image>

Pivot
7. Drag and drop the PivotTable fields as follows:

<Please see attached file for image>

fields
8. The table obtained will provide you with the information/statistics to gauge the PA/VE ratio
Row LabelsNoYes(blank)Grand Total
Y1062129 1191
(blank)    
Grand Total1062129 1191
 89.17%10.83%  
Of the 1191 VERes sent, we didn't receive PAReq for 1062 (89.17%).
 

Attachments

1558696532994000106639_sktwi1f5rjvs16ilg.png get_app
1558696531270000106639_sktwi1f5rjvs16ilf.png get_app
1558696529369000106639_sktwi1f5rjvs16ile.png get_app