...
Feedback on how you are using this data and any particular new pain points:
Andrew Horton tweaks to SQL script
Marital Status values removed – couldn’t get uploads to work with them in.
We’ve put a case statement in to make Nationality a Nationality – may have missed some but had everything we needed last year.
Case statement for to match to the TIS Gender reference values as at April 2024 reference values.
We put the provided OrielID’s into an IN statement to capture the records we want. – How are these known?
Other pain points from Andy and team
Move address 3 into address 2 where it is blank
Check the telephone number looks correct as there is sometimes an issue with formatting (Convert the column to number, then remove the decimal places)
Questions:
Will the ‘tweaks’ above be useful for all and should they be applied?
Do the Address[RT1] and Phone Number pain points hold true for all? Should a fix be investigated for them?
...
Do we need to meet again regularly?
...
[RT1]In Oriel Address Line 2 is an optional field. There is no Address Line 3 but 'City/Town' which I believe becomes the TIS Address Line 3.
...