To report on PMR/TNP values, you can utilize the Power BI dashboards located in the Funding dashboard under the 'PMR/TNP report' tab. The data can be exported from there.
Additionally, there's another tab called Learning Funding Data, which provides ACT values.
Alternatively, you can use OData to report on these fields. To achieve this, the Apprenticeship financial records table needs to be joined with the ILRAims table using Aim ID and ID columns from the respective tables. The ILRAims table contains the LearnerID. If you're specifically interested in total TNP figures, these can be fetched directly from the ILRAims table.
To accurately report on the correct TNP figures, kindly reference the 'TotalTrainingPrice' and 'TotalAssessmentPrice' columns within the ILRAims table (displayed below). Alternatively, you can extract the most recent TNP figures from the ApprenticeshipFinancialRecords table by filtering based on 'Date' and/or 'Order' columns in your reporting
The Apprenticeship financial records table contains recorded TNP figures for each episode on the programme.
However, when generating reports, only the most recent TNP figures should be taken into consideration.
You can find the OData dictionary here.