Tables [dbo].[Act_Allergy]
Allergy Activity
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Act_Allergy_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Act_Allergy table
Indexes XAct_Allergy_ActHdrIDForeign Keys FK_Act_Allergy_ActivityHeaderID_Act_Hdr_Allergy_ID: [dbo].[Act_Hdr_Allergy].ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLAllergy Activity Header ID. Link to Act_Hdr_Allergy.ID.
Indexes TWstat_Act_Allergy_OrganizationIDForeign Keys FK_Act_Allergy_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationIDOrganizationIDnumeric(8,0)5NOT NULLOrganization ID. Link to Organization.ID.
Foreign Keys FK_Act_Allergy_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDEForeign Keys FK_Act_Allergy_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersionNoteTypeDE[dbo].[dict_id]5NOT NULLNote Type. Link to Note_Type_DE.ID.
Foreign Keys FK_Act_Allergy_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersionTemplateVersionsmallint2NOT NULLNot Used. Link to Note_Template_Version.ID.
EpisodeID[dbo].[uniqueid]9NOT NULLNot Used
CarePlanDE[dbo].[dict_id]5NOT NULLCare Plan. Link to Care_Plan_DE.ID.
Foreign Keys FK_Act_Allergy_OrderSourceDE_Order_Source_DE_ID: [dbo].[Order_Source_DE].OrderSourceDEOrderSourceDE[dbo].[dict_id]5NOT NULLOrder Source. Link to Order_Source_DE.ID.
OrderNumberEXTvarchar(20)20NOT NULLExternal Order Number
FUComment[dbo].[message]255NOT NULLNot used
Indexes XAct_Allergy_AccNumAccessionNumbervarchar(255)255NOT NULLAccession Number
Indexes TWstat_Act_Allergy_InterfaceSourceIDInterfaceSourceIDsmallint2NOT NULLInterface Source ID
Foreign Keys FK_Act_Allergy_TestingProviderID_Provider_ID: [dbo].[Provider].TestingProviderIDTestingProviderID[dbo].[uniqueid]9NOT NULLTesting Provider ID. Always 0
Foreign Keys FK_Act_Allergy_WhoForID_Provider_ID: [dbo].[Provider].WhoForIDWhoForID[dbo].[uniqueid]9NOT NULLProvider who requested to add the Allergy into the patient Chart. Link to Person.ID.
Foreign Keys FK_Act_Allergy_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLProvider who added the Allergy into the patient Chart. Link to IDX_User.ID.
PerformedDTTMdatetime8NOT NULLDatetime Allergy was added
RecordedDTTMdatetime8NOT NULLDatetime the details are  added in Act_Allergy table.
Check Constraints CK_Act_Allergy_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')HasClinicalWarningFLAG[dbo].[BOOL]1NOT NULLHas Clinical Warning ? Always 'N'
ClinicalDTTMdatetime8NOT NULLDatetime Allergy was added
Foreign Keys FK_Act_Allergy_ClinicalSourceDE_Source_DE_ID: [dbo].[Source_DE].ClinicalSourceDEClinicalSourceDE[dbo].[dict_id]5NOT NULLClinical Source. Always 0
Foreign Keys FK_Act_Allergy_OrderingProviderID_Provider_ID: [dbo].[Provider].OrderingProviderIDOrderingProviderID[dbo].[uniqueid]9NOT NULLProvider who requested to add the Allergy into the patient Chart. Link to Person.ID.
OrderingProviderName[dbo].[name]255NOT NULLOrdering Provider Name
Cluster Key XcAct_Allergy_Person: PatientIDIndexes TWstat_Act_Allergy_ActivityType_PatientIDForeign Keys FK_Act_Allergy_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientIDnumeric(16,0)9NOT NULLPatient. Link to Person.ID.
Indexes TWstat_Act_Allergy_ActivityType_PatientIDCheck Constraints CK_Act_Allergy_ActivityType : ([ActivityType]='Al')ActivityTypevarchar(10)10NULL allowedActivity Type.  'AL'