FIS data version numbers and what date they apply to

Home Forums Data issues FIS data version numbers and what date they apply to

This topic contains 2 replies, has 3 voices, and was last updated by  Martin West 6 years, 10 months ago.

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

  • Caspar Verney
    Participant

    Many of you will know that within FIS there are different version numbers for each data set that it uses (eg LARS, Postcodes, etc.). However identifying what age any of them are or which one is which within SQL is not always as easy. The date stamp in SQL is only the date of installation and that is not the same as the date the reference data was issued (especially when you download an older version).

    I asked the Data Service for help with this at the beginning of November and have just received the following replies which I hope will be of assistance to others:

    Please accept our apologies for the delayed response to your query.

    We referred your query to the FIS technial team and they have advised as below:
    “The reference data available is Version referenced by using numbers. A date being a preference is not an issue.

    However we acknowledge your suggestion and we have added to our Service Improvement Log to add a date stamp of date published for all reference data (LARS, Postcodes, etc). This means that this change will be considered for a future release.”

    “If you look at the SQL databases that FIS uses, there is one called FundingInformationSystem, in here there is a table called Dataset, this table shows which version numbers relate to which databases, so the user should be able to tell which is which.”

     
    #4798

    chrishick
    Participant

    Thanks for posting Caspar

    I’m guessing their Service Improvement Log must be pretty extensive

     
    #4811

    Martin West
    Participant

    I use a simple pass through query from Access to return the versions
    SELECT DatabaseName, DataSetVersion
    FROM FundingInformationSystem.dbo.DataSet;

     
    #4813
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.