Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  (5) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Patient_List table |
| Name | varchar(255) | 255 | NOT NULL | | | Patient List Name |
 (4) | IDXUserID | [dbo].[uniqueid] | 9 | NOT NULL | | | User. Link to IDX_User.ID |
 ![Foreign Keys FK_Patient_List_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID Foreign Keys FK_Patient_List_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID](../../../../Images/fk.png) | OrganizationID | [dbo].[dict_id] | 5 | NOT NULL | | | Organization. Link to Organization.ID |
 ![Check Constraints PatientListType_check : ([PatientListType]='S' OR [PatientListType]='I' OR [PatientListType]='G') Check Constraints PatientListType_check : ([PatientListType]='S' OR [PatientListType]='I' OR [PatientListType]='G')](../../../../Images/c-constraint.png) | PatientListType | char(1) | 1 | NOT NULL | | ('G') | List type. Default ('G') I = Service List else NonServiceList |
 ![Foreign Keys FK_Patient_List_ProviderID_Provider_ID: [dbo].[Provider].ProviderID Foreign Keys FK_Patient_List_ProviderID_Provider_ID: [dbo].[Provider].ProviderID](../../../../Images/fk.png) | ProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | ('0') | Provider Identifier. Link to Person.ID. |
 ![Foreign Keys FK_Patient_List_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE Foreign Keys FK_Patient_List_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE](../../../../Images/fk.png) | BillingAreaDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Billing Area. Link to Billining_Area_DE.ID |
 ![Foreign Keys FK_Patient_List_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE Foreign Keys FK_Patient_List_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE](../../../../Images/fk.png) | BillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Billing Location. Link to Billing_Location_DE.ID |
 ![Foreign Keys FK_Patient_List_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDE Foreign Keys FK_Patient_List_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDE](../../../../Images/fk.png) | DivisionDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Division. Link to Division_DE.ID |
| IsRefProvReqdFLAG | char(1) | 1 | NOT NULL | | ('') | Is reffering provider required (Y/N). |
| BillingProviderType | char(2) | 2 | NOT NULL | | ('') | CU - Current User CA - Current Attending AP - Admitting Provider Default ('') |
| CreateSubmitIPEncTask | char(2) | 2 | NOT NULL | | ('') | 'DN' -- create task daily - next day 'OA' -- create task once, on admit 'OD' -- On Discharge NO - Do not create Task Default ('') |
| AssignToType | char(2) | 2 | NOT NULL | | ('') | T - Team AP - Admitting Provider CA - Current Attending Default ('') |
 | AssignToDE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | ID as per AssignToType column |
| FilterText | varchar(4000) | 4000 | NULL allowed | | | Filter condition applied on patient list |
 ![Foreign Keys FK_Patient_List_SecurityCodeDE: [dbo].[Security_Code_DE].SecurityCodeDE Foreign Keys FK_Patient_List_SecurityCodeDE: [dbo].[Security_Code_DE].SecurityCodeDE](../../../../Images/fk.png) | SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Security Code. Link to Security_Code_DE.ID |
![Check Constraints CK_Patient_List_SpecialAccessFLAG_Yes_Or_No : ([SpecialAccessFLAG]='N' OR [SpecialAccessFLAG]='Y') Check Constraints CK_Patient_List_SpecialAccessFLAG_Yes_Or_No : ([SpecialAccessFLAG]='N' OR [SpecialAccessFLAG]='Y')](../../../../Images/c-constraint.png) | SpecialAccessFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | For VIP 'Y';Default ('N') |
![Foreign Keys FK_Patient_List_HospitalOrgID: [dbo].[Organization].HospitalOrgID Foreign Keys FK_Patient_List_HospitalOrgID: [dbo].[Organization].HospitalOrgID](../../../../Images/fk.png) | HospitalOrgID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Hospital. Link to Organization.ID |