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.
Add Comment