vwGP_DETAILS

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

GP_ID

int

null

varchar

null

GPNAME

varchar

100

null

PRACTICE_ID

int

√

null

ADDR1

varchar

250

√

null

ADDR2

varchar

250

√

null

ADDR3

varchar

250

√

null

ADDR4

varchar

250

√

null

POSTCODE

varchar

√

null

PRACCODE

varchar

√

null

PCT

varchar

√

null

PCT_DESC

varchar

100

√

null

CCG

varchar

√

null

CCG_NAME

varchar

100

√

null

IS_DELETED

int

null

View Definition

CREATE VIEW [dbo].[vwGP_DETAILS]
AS

SELECT	dbo.GP.ID AS [GP_ID],
		dbo.GP.Code AS [GP],
		dbo.GP.Name AS [GPNAME],
		dbo.Practice.ID AS [PRACTICE_ID],
		dbo.Practice.AddressLine1 AS [ADDR1],
		dbo.Practice.AddressLine2 AS [ADDR2],
		dbo.Practice.AddressLine3 AS [ADDR3],
		dbo.Practice.AddressLine4 AS [ADDR4],
		dbo.Practice.Postcode AS [POSTCODE],
		dbo.Practice.Code AS [PRACCODE],
		dbo.ltblNATIONAL_GP.PCT,
		dbo.ltblNATIONAL_PCT.PCT_DESC,
		dbo.ltblNATIONAL_CCG_INFO.CCG,
		dbo.ltblNATIONAL_CCG_INFO.Name AS CCG_NAME,
		CASE
			WHEN dbo.GP.IsDeleted = 1 OR dbo.Practice.IsDeleted = 1
				THEN 1
			ELSE 0
		END AS [IS_DELETED]
FROM dbo.GP
JOIN dbo.PracticeGP
	ON dbo.PracticeGP.GP = dbo.GP.ID
LEFT JOIN dbo.Practice
	ON dbo.Practice.ID = dbo.PracticeGP.Practice
LEFT JOIN dbo.ltblNATIONAL_GP
	ON dbo.ltblNATIONAL_GP.PRACCODE = LEFT(dbo.Practice.Code, 6)
LEFT JOIN dbo.ltblNATIONAL_PCT
	ON dbo.ltblNATIONAL_PCT.PCT_CODE = dbo.ltblNATIONAL_GP.PCT
LEFT JOIN dbo.ltblNATIONAL_CCG_PracticeCode
	ON dbo.ltblNATIONAL_CCG_PracticeCode.PracticeCode = LEFT(dbo.Practice.Code, 6)
LEFT JOIN dbo.ltblNATIONAL_CCG_INFO
	ON dbo.ltblNATIONAL_CCG_INFO.CCG = dbo.ltblNATIONAL_CCG_PracticeCode.CCG

Columns

View Definition

Possibly Referenced Tables/Views