Has anyone created any SQL views within FIS to report on the new apprenticeship funding methodology. I have found a number of tables prefixed “AEC”, but some of the fields within are not labelled clear enough, for me anyway. Does anyone have a guide to match the table/field names to anything meaningful in English.
If anyone has already written reports then the SQL would be useful also.
You will need to create a query using Rulebase_AEC_LearningDelivery and Rulebase_AEC_LearningDelivery_Period (Inner join) to get the funding values for each month.
PS I do this using the Access mdb but you could do the same using the server tables.