FIS Reporting

Home Forums Data issues FIS Reporting

Tagged: 

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

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

  • pcorker
    Participant

    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

     
    #179152

    Martin West
    Participant

    Hi,
    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.
    HTH
    PS I do this using the Access mdb but you could do the same using the server tables.

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

You must be logged in to reply to this topic.