MFP Audit Table
- Kavitha Thangaswamy (Unlicensed)
- Pamela Totas (Deactivated)
The PERFORMDBO.MFP_AUDIT table, described in the following table, defines the structure of the record including entity, date, and source.
Column | Description | Example |
|---|---|---|
AUDIT_ID | Unique ID assigned to a unique combination of [entity/effective date/source/frequency] | 123 |
ENTITY_ID | The unique ID of the mutual fund share class | FUND1 |
EFFECTIVE_DATE | The run date of the performance analysis report. This typically also is the end date of the performance period. | 12/31/2005 |
SRC_INTFC_INST | The source of the record (PACE MFP Audit Logging assigns a source of 4) | 4 |
FREQ_TYPE | The frequency of the logging data (currently only D for daily) | D |
UPDATE_DATE | Update date | 5/17/2006 |
UPDATE_SOURCE | Update source | MFP_AUDIT_PROC |
Interpretation
On 5/17/2006, a performance analysis report that included one or more Audit Daily fields, was run. The report was run as of the 12/31/2005 effective date and included FUND1. The associated records (stored on MFP_AUDIT_SUMMARY and MFP_AUDIT_DETAILS) are stored under audit ID 123.