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.
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.