FIS Reporting

Home Forums Data issues FIS Reporting


This topic contains 1 reply, has 2 voices, and was last updated by  Martin West 11 months, 1 week ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author

  • pcorker

    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.

    Thanks in anticipation


    Martin West

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.