Tables [dbo].[Patient_List]
Patient List definitions.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Patient_List_ID: IDCluster Key XAK1Patient_List: IDXUserID\IDIndexes XAK2Patient_List, TWstat_Patient_List_BillingAreaDE_IDXUserID_ID, TWstat_Patient_List_BillingLocationDE_IDXUserID_ID, TWstat_Patient_List_DivisionDE_IDXUserID_ID, TWstat_Patient_List_SecurityCodeDE_IDXUserID_ID(5)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_List table
Namevarchar(255)255NOT NULLPatient List Name
Cluster Key XAK1Patient_List: IDXUserID\IDIndexes TWstat_Patient_List_BillingAreaDE_IDXUserID_ID, TWstat_Patient_List_BillingLocationDE_IDXUserID_ID, TWstat_Patient_List_DivisionDE_IDXUserID_ID, TWstat_Patient_List_SecurityCodeDE_IDXUserID_ID(4)IDXUserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
Indexes XAK2Patient_ListForeign Keys FK_Patient_List_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationIDOrganizationID[dbo].[dict_id]5NOT NULLOrganization. Link to Organization.ID
Indexes nix_Patient_List_PatientListTypeCheck Constraints PatientListType_check : ([PatientListType]='S' OR [PatientListType]='I' OR [PatientListType]='G')PatientListTypechar(1)1NOT NULL('G')List type. Default ('G')
I = Service List else NonServiceList
Indexes TWstat_Patient_List_ProviderIDForeign Keys FK_Patient_List_ProviderID_Provider_ID: [dbo].[Provider].ProviderIDProviderID[dbo].[uniqueid]9NOT NULL('0')Provider Identifier. Link to Person.ID.
Indexes TWstat_Patient_List_BillingAreaDE_IDXUserID_IDForeign Keys FK_Patient_List_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDEBillingAreaDE[dbo].[dict_id]5NOT NULL('0')Billing Area. Link to Billining_Area_DE.ID
Indexes TWstat_Patient_List_BillingLocationDE_IDXUserID_IDForeign Keys FK_Patient_List_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDEBillingLocationDE[dbo].[dict_id]5NOT NULL('0')Billing Location. Link to Billing_Location_DE.ID
Indexes TWstat_Patient_List_DivisionDE_IDXUserID_IDForeign Keys FK_Patient_List_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDEDivisionDE[dbo].[dict_id]5NOT NULL('0')Division. Link to Division_DE.ID
IsRefProvReqdFLAGchar(1)1NOT NULL('') Is reffering provider required (Y/N).
BillingProviderTypechar(2)2NOT NULL('')CU - Current User
CA - Current Attending
AP - Admitting Provider
Default ('')
CreateSubmitIPEncTaskchar(2)2NOT NULL('')'DN'  -- create task daily - next day
'OA'  -- create task once, on admit
'OD'  -- On Discharge
NO - Do not create Task
Default ('')
AssignToTypechar(2)2NOT NULL('')T - Team
AP - Admitting Provider
CA - Current Attending
Default ('')
Indexes TWstat_Patient_List_AssignToDEAssignToDE[dbo].[uniqueid]9NOT NULL(0)ID as per AssignToType column
FilterTextvarchar(4000)4000NULL allowedFilter condition applied on patient list
Indexes TWstat_Patient_List_SecurityCodeDE_IDXUserID_IDForeign Keys FK_Patient_List_SecurityCodeDE: [dbo].[Security_Code_DE].SecurityCodeDESecurityCodeDE[dbo].[dict_id]5NOT NULL(0)Security Code. Link to Security_Code_DE.ID
Check Constraints CK_Patient_List_SpecialAccessFLAG_Yes_Or_No : ([SpecialAccessFLAG]='N' OR [SpecialAccessFLAG]='Y')SpecialAccessFLAG[dbo].[BOOL]1NOT NULL('N')For VIP 'Y';Default ('N')
Foreign Keys FK_Patient_List_HospitalOrgID: [dbo].[Organization].HospitalOrgIDHospitalOrgID[dbo].[dict_id]5NOT NULL(0)Hospital. Link to Organization.ID