Skip to content

Appointment Slot Mode of Contact is truncated - datatype declared by EMIS is incorrect #26

@BillWoodNHS

Description

@BillWoodNHS

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.

Image Image

Metadata

Metadata

Assignees

Labels

Projects

Status

Ready For Internal Test

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions