vwMDT_PRACTICE

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

MEETING_ID

int

√

null

MDT_DATE

smalldatetime

√

null

PRACCODE

varchar

null

ADDR1

varchar

√

null

ADDR2

varchar

√

null

IS_DELETED

bit

null

View Definition

CREATE VIEW [dbo].[vwMDT_PRACTICE]
AS

--This isn't efficient as it joins the demographic table to the GP table by practice code
--and the amount of times the practice code is returned is based on the amount of times
--the practice code appears in the GP table, but the default of GP9999998 appears multiple times
--SELECT     dbo.tblMDT_LIST.MEETING_ID, dbo.tblMDT_LIST.MDT_DATE, dbo.ltblGP_INFO.PRACCODE, dbo.ltblGP_INFO.ADDR1, dbo.ltblGP_INFO.ADDR2
--FROM       dbo.tblMDT_LIST INNER JOIN
--           dbo.tblDEMOGRAPHICS ON dbo.tblMDT_LIST.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID INNER JOIN
--           dbo.ltblGP_INFO ON dbo.tblDEMOGRAPHICS.N1_12_GP_PRACTICE_CODE = dbo.ltblGP_INFO.PRACCODE

SELECT     DISTINCT dbo.tblMDT_LIST.MEETING_ID, dbo.tblMDT_LIST.MDT_DATE, 
		   dbo.ltblGP_INFO.PRACCODE, dbo.ltblGP_INFO.ADDR1, dbo.ltblGP_INFO.ADDR2, dbo.ltblGP_INFO.IS_DELETED
FROM       dbo.tblMDT_LIST 
		   INNER JOIN dbo.tblDEMOGRAPHICS 
           ON dbo.tblMDT_LIST.PATIENT_ID = dbo.tblDEMOGRAPHICS.PATIENT_ID 
           INNER JOIN dbo.ltblGP_INFO 
           ON dbo.tblDEMOGRAPHICS.N1_11_GP_CODE = dbo.ltblGP_INFO.GP
WHERE	   dbo.ltblGP_INFO.IS_DELETED <> 1

Columns

View Definition

Possibly Referenced Tables/Views