Allow me to share some of the minutes from a Software Suppliers Meeting with SFA in July.
The group were also asked about making changes to the FIS export mdb. There are some minor fixes needed, for instance to remove columns that will never be populated and rename some fields. Based on the information presented, the group’s view was that they would prefer these changes not to be made, saying that this would introduce risk and cost without any tangible benefit other than ‘tidying up’. The suggestion was not to implement these changes until the next round of business critical changes. If critical then at least one or two months notice would be needed and there would have to be a guaranteed go live date so that provider MI systems could be updated exactly in line with FIS. A test system for providers to check this before the release
Minutes for meeting on 8 July 2014 NOT PROTECTIVELY MARKED
Software writer group 5 of 6
would be very beneficial. The group suggested issuing a script to rename columns rather than amending the database.
I was working on importing data from FIS DB exports yesterday and noticed that all dates are in DD/MM/YYYY format except for DateOfBirth in ILR1415_Learner which is YYYY-MM-DD and is stored as a 10 character text field.