The column "ModeOfContact" within the source EMIS data (table "Appointment_Slot") is being silently truncated to 20 characters.
EMIS declared this column as a varchar of length 20. However we are seeing values up to length 26.
Impact
This column is transformed and indexed into the OLIDS column LDSConceptId_ContactMode. The list of witnessed concepts built up from this process is therefore being truncated to 20 characters. This is also then impacting mapping from the source concepts to target concepts.
