Skip to content
Partner Developer Portal byOptum

Schema

Column NameData TypesDescriptionExample
is_deletedbooleanDeletion status flagtrue/false
code_idbigintEMIS Web Code ID2986010
termvarcharCode ID termSolar retinopathy
snomed_concept_idbigintSNOMED Concept ID123456789
snomed_description_idbigintSNOMED Concept ID description0358791000
fully_specified_namevarcharSNOMED fully specified nameSolar retinopathy (disorder)
readv2_codevarcharOld readv2 codeF404400
other_code_systemvarcharOther system http addresswebsite link
other_codevarcharOther EMIS old codesDRGC6020BRIDL
other_displayvarcharOther EMIS code termsAluminium Chlorhydroxide Complex
organisationvarcharEMIS sourceEMIS
transform_datetimetimestamp(6) with time zoneTransformation timestamp2023-05-12 14:30:15.000000 UTC
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