Extracting M&V Event Statistics
M&V event statistics can be extracted for import into an external system via a batch process which creates a file containing M&V event statistics information from both Service Point Event Outcome records and M&V transactions.
See About Service Point Event Outcome Snapshots and About M&V Transactions for more information.
Batch Control
M&V event statistics are extracted using the Event M&V Statistics Extract (X1-EVMVE) batch process. This batch process downloads data into a file, the details of which are specified by the batch control parameters.
This batch processes use the following parameters:
- File Integration Type: The file integration type (see below) used to extract M&V event statistics (see below).
- File Name: The name of the downloaded file. File names can use wildcards (Required).
- File Path: The file location to which the file will be downloaded. This can be a file location on a local server or a location in Object Storage. See Referencing URIs in the Framework Administrative User Guide the for more information (Required).
- File Format: The extract file format. Valid values are CSV (delimited) FIXD (fixed position output), XML (XML document), JSON (JSON document) or JSNL (JSON Lines).
- File Delimiter: The delimiter to use for the CSV file format.
Use the Batch Control portal to view additional details about these and other parameters.
File Integration Type
The M&V event statistics extract process uses the Event M&V Statistics Extract (X1-EVMVExtract) file integration type, defined as a parameter on the Event M&V Statistics ExtractX1-EVMVE) batch process.
Implementations that require a different extract format can create a custom file integration type that defines their own extract format and process. This includes creating a custom extract algorithm and a custom extract data area.
Refer to Extract Using File Integration for more information about the role of file integration types.
File Format
The file format of the extract file is defined by the Event M&V Statistics Extract Record (X1-EVMVExtractRecord) data area, specified on the Event M&V Statistics Extract (X1-EVMVExtract) file integration record on the Event M&V Statistics Extract (X1-EVMVExtract) file integration type.
M&V event statistics extract files use the following format:
| Field Name | Notes | ||
|---|---|---|---|
| Event ID | This is the External Event ID in the Program Event. | ||
| Stage ID | This is the External ID in the Program Event | ||
| Treatment Group | Entity Group from the Service Point Event Outcome | ||
| Control Group | Control Group linked to the Treatment Group | ||
| Coefficient of Determination | From M&V Transaction | ||
| Multiple R | From M&V Transaction | ||
| Standard Error | From M&V Transaction | ||
| Number of Observations | From M&V Transaction | ||
| B0 | From M&V Transaction Service Quantities | ||
| B0 Intercept Standard Error | From M&V Transaction | ||
| B0 Confidence Interval Low | From M&V Transaction | ||
| B0 Confidence Interval High | From M&V Transaction | ||
| Coefficient for Time (B1) | From M&V Transaction Service Quantities | ||
| B1 | From M&V Transaction | ||
| B1 Confidence Interval Low | From M&V Transaction | ||
| B1 Confidence Interval High | From M&V Transaction | ||
| B2 | From M&V Transaction Service Quantities | ||
| B2 Standard Error | From M&V Transaction | ||
| B2 Confidence Interval Low | From M&V Transaction | ||
| B2 Confidence Interval High | From M&V Transaction | ||
| B3 | From M&V Transaction Service Quantities | ||
| B3 Standard Error | From M&V Transaction | ||
| B3 Confidence Interval Low | From M&V Transaction | ||
| B3 Confidence Interval High | From M&V Transaction | ||