Tables [dbo].[Patient_List_Entry]
Patients on a Patient List
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Patient_List_Entry_ID: IDIndexes NIX_Patient_List_Entry_PatientListID, NIX_Patient_List_Entry_VisitID_INC_ID_PatientListID, TWstat_Patient_List_Entry_PersonID_PatientListID_ID, TWstat_Patient_List_Entry_VisitID_PatientListID_ID(4)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_list_Entry table
Indexes NIX_Patient_List_Entry_PatientListID, NIX_Patient_List_Entry_VisitID_INC_ID_PatientListID, TWstat_Patient_List_Entry_PersonID_PatientListID_ID, TWstat_Patient_List_Entry_VisitID_PatientListID_ID(4)Foreign Keys FK_Patient_List_Entry_PatientListID_Patient_List_ID: [dbo].[Patient_List].PatientListIDPatientListID[dbo].[uniqueid]9NOT NULLPatient List. Link to Patient_List.ID
Cluster Key CIX_Patient_List_Entry_PersonID: PersonIDIndexes TWstat_Patient_List_Entry_PersonID_PatientListID_IDForeign Keys FK_Patient_List_Entry_PersonID_Person_ID: [dbo].[Person].PersonIDPersonID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
StartDTdatetime8NOT NULLDate of entry onto the list. Used with inpatient lists.
EndDTdatetime8NULL allowedDate entry no longer meets the criteria of the list. Used with inpatient lists.
Indexes NIX_Patient_List_Entry_PatientListIDSequenceNumberint4NULL allowedSequence on the list
Indexes NIX_Patient_List_Entry_PatientListID, NIX_Patient_List_Entry_VisitID_INC_ID_PatientListID, TWstat_Patient_List_Entry_VisitID_PatientListID_ID(3)Foreign Keys FK_Patient_List_Entry_VisitID_Visit_ID: [dbo].[Visit].VisitIDVisitID[dbo].[uniqueid]9NOT NULL(0)Inpatient visit associated with the Inpatient list