Tables [dbo].[Patient_Pharmacy_Def]
Defau;t pharmacies for a patient. This table gets populated when assigning pharmacies to a patient in the Patient Profile screen in TouchWorks. You can have up to 4 retail pharmacies and 4 mail_order. Once you exceed this limit the app will still add the new entry but it will remove the oldest one
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Patient_Pharmacy_Def_PatientID_PharmacyID: PatientID\PharmacyIDIndexes TWstat_Patient_Pharmacy_Def_PharmacyID_PatientID, TWstat_Patient_Pharmacy_Def_PrescribeActionID_PatientID_PharmacyID(2)Foreign Keys FK_patient_pharmacy_def_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
Cluster Primary Key PK_Patient_Pharmacy_Def_PatientID_PharmacyID: PatientID\PharmacyIDIndexes TWstat_Patient_Pharmacy_Def_PharmacyID_PatientID, TWstat_Patient_Pharmacy_Def_PrescribeActionID_PatientID_PharmacyID(2)Foreign Keys FK_Patient_Pharmacy_Def_PharmacyID_Pharmacy_DE_ID: [dbo].[Pharmacy_DE].PharmacyIDPharmacyIDnumeric(8,0)5NOT NULLPharmacy. Link to Pharmacy_DE.ID.
Indexes TWstat_Patient_Pharmacy_Def_PrescribeActionID_PatientID_PharmacyIDForeign Keys FK_Patient_Pharmacy_Def_PrescribeActionID_PrescribeAction_DE_ID: [dbo].[PrescribeAction_DE].PrescribeActionIDPrescribeActionID[dbo].[dict_id]5NOT NULL(0)Either Retail or Mail Order. Link to PrescribeAction_DE.ID.
CreateDTTMdatetime8NOT NULL(getdate())Date pharmacy was added to patient
Indexes TWstat_Patient_Pharmacy_Def_DefaultFLAGCheck Constraints CK_Patient_Pharmacy_Def_DefaultFLAG_Yes_Or_No : ([DefaultFLAG]='N' OR [DefaultFLAG]='Y')DefaultFLAG[dbo].[BOOL]1NOT NULL('Y')Y/N Is it the default pharmacy
Indexes TWstat_Patient_Pharmacy_Def_LastDefaultedDTTMLastDefaultedDTTMdatetime8NOT NULL(getdate())Date phamacy was made default