Tables [dbo].[Person_Multi_Dictionary]
Patient attributes , which have multiple entries. View vPersonMultiDictionary  will return a unique row per Person
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Person_Multi_Dictionary_PatientID_DictionaryName_DictionaryID: PersonID\DictionaryName\DictionaryIDForeign Keys FK_Person_Multi_Dictionary_PatientID: [dbo].[Person_Other].PersonIDPersonID[dbo].[uniqueid]9NOT NULLPerson. Link to Person.ID
Cluster Primary Key PK_Person_Multi_Dictionary_PatientID_DictionaryName_DictionaryID: PersonID\DictionaryName\DictionaryIDDictionaryID[dbo].[dict_id]5NOT NULLDictionary. Link to Dictionary.ID
Cluster Primary Key PK_Person_Multi_Dictionary_PatientID_DictionaryName_DictionaryID: PersonID\DictionaryName\DictionaryIDCheck Constraints CK_Person_Multi_Dictionary_DictionaryName : ([DictionaryName]='Ethnicity')DictionaryNamevarchar(30)30NOT NULLDictionary Name
DisplayOrdertinyint1NOT NULLDictionary Entry Display Order
IsDeletedbit1NOT NULL((0))Flag deleted ethnicity entries
LastUpdatedDTTMdatetime8NULL allowedModified date/time of Entry