Skip to content
Partner Developer Portal byOptum

Schema

Column NameData TypeDescriptionExample
is_deletedBOOLEANFlag indicating if the code is deleted (or deprecated)false
code_idBIGINTUnique identifier for the ethnicity code (Primary Key)12345
snomed_concept_idBIGINTSNOMED CT concept identifier (nullable)186034007
snomed_descriptionVARCHARHuman-readable description of the SNOMED concept’White British’
snomed_description_idBIGINTID of the preferred SNOMED description234567
organisationVARCHARIdentifier for the data source, always ‘EMIS''EMIS’
transform_datetimeTIMESTAMP(6) WITH TIME ZONETimestamp when the record was last transformed’2023-05-12 14:30:15+00’
model_last_updatetimestamp(6) with time zoneTimestamp indicating when the model last updated this record (data type to be confirmed).2024-01-15 10:30:45