Tables [dbo].[Act_Hdr_Allergy]
Allergy Activity Header
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Act_Hdr_Allergy_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Act_Hdr_Allergy table
Cluster Key XcAct_Hdr_Allergy_Person: PatientIDIndexes TWstat_Act_Hdr_Allergy_ActivityType_PatientIDForeign Keys FK_Act_Hdr_Allergy_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
Indexes XAct_Hdr_Allergy_VisIDVisitID[dbo].[uniqueid]9NOT NULLVisit. Link to Visit.ID.
Indexes XAct_Hdr_Allergy_CurIDCurrentIDnumeric(16,0)9NOT NULLLatest Allergy instance ID. Link to Act_Allergy.ID.
DocFolderIDnumeric(16,0)9NOT NULLAlways 0
CreateDTTMdatetime8NOT NULLDate and time the row added into Act_Hdr_Allergy table.
LastUpdateDTTMdatetime8NOT NULLDate and time the row updated in Act_Hdr_Allergy table.
Check Constraints CK_Act_Hdr_Allergy_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLAlways 'N'
Check Constraints CK_Act_Hdr_Allergy_IsCorrectedFLAG_Yes_Or_No : ([IsCorrectedFLAG]='N' OR [IsCorrectedFLAG]='Y')IsCorrectedFLAG[dbo].[BOOL]1NOT NULLAlways 'N'
Check Constraints CK_Act_Hdr_Allergy_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotation Exists FLAG. Always 'N'
Check Constraints CK_Act_Hdr_Allergy_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y')SignatureRequiredFLAG[dbo].[BOOL]1NOT NULLSignature Required ? Always 'N'
Check Constraints CK_Act_Hdr_Allergy_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y')AcknowledgementReqFLAG[dbo].[BOOL]1NOT NULLAcknowledgement Required ? Always 'N'
SignedByProviderID[dbo].[uniqueid]9NOT NULLSigned By Provider ID. Provider who requested to add the Allergy into the patient Chart. Link to Person.ID.
Indexes TWstat_Act_Hdr_Allergy_AckByProviderIDAckByProviderID[dbo].[uniqueid]9NOT NULLAlways 0
NakByProviderID[dbo].[uniqueid]9NOT NULLAlways 0
Indexes TWstat_Act_Hdr_Allergy_ActivityType_PatientIDCheck Constraints CK_Act_Hdr_Allergy_ActivityType : ([ActivityType]='Al')ActivityTypechar(10)10NOT NULLActivity Type. 'AL'
Indexes XAct_Hdr_Allergy_EncIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
Indexes TWstat_Act_Hdr_Allergy_ResultStageCheck Constraints CK_Act_Hdr_Allergy_ResultStage_Result_Stage : ([ResultStage]='' OR [ResultStage]='C' OR [ResultStage]='A' OR [ResultStage]='F' OR [ResultStage]='I' OR [ResultStage]='P')ResultStagechar(2)2NOT NULLResult Stage. 'F'
ParentID[dbo].[uniqueid]9NOT NULLParent.
Indexes TWstat_Act_Hdr_Allergy_QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLOrderable item. Link to QO_Classification_DE.ID.
Check Constraints CK_Act_Hdr_Allergy_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y')HasProblemFLAG[dbo].[BOOL]1NOT NULLHas Problem ? 'N'
ActivityTypeDE[dbo].[dict_id]5NOT NULLActivity Type. Link to Activity_Type_DE.ID.
FormDE[dbo].[dict_id]5NOT NULLForm. Link to Form_DE.ID. Always 0.
Check Constraints CK_Act_Hdr_Allergy_CompletionStatus_Note_Completion_Status : ([CompletionStatus]='CompAmend' OR [CompletionStatus]='Ammended' OR [CompletionStatus]='Complete' OR [CompletionStatus]='Incomplete')CompletionStatuschar(10)10NOT NULLCompletion Status. Always 'Complete'
CMSVersionsmallint2NOT NULLCMS Version. 4