Tables [dbo].[Problem_Activity]
Linkage of problems to other clinical items.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Problem_Activity_ActHdrID_ProbActHdrID: ActivityHeaderID\ProblemHeaderID\ActivityTypeIndexes TWstat_Problem_Activity_ProblemHeaderID_ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. (eg. Order_Activity_Header.ID)
Cluster Primary Key PK_Problem_Activity_ActHdrID_ProbActHdrID: ActivityHeaderID\ProblemHeaderID\ActivityTypeIndexes XAK1Problem_Activity_ProblemHeaderID, TWstat_Problem_Activity_ProblemHeaderID_ActivityHeaderID(2)Foreign Keys FK_Problem_Activity_ProblemHeaderID_Problem_Header_ID: [dbo].[Problem_Header].ProblemHeaderIDProblemHeaderID[dbo].[uniqueid]9NOT NULLProblem Header. Link to Problem_Header.ID.
Cluster Primary Key PK_Problem_Activity_ActHdrID_ProbActHdrID: ActivityHeaderID\ProblemHeaderID\ActivityTypeActivityTypechar(10)10NOT NULL('UNKNOWN')Activity Type