vwPALLIATIVE_INPATIENTS

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PATIENT_ID

int

null

PALLIATIVE_ID

int

√

null

INPAT_ID

int

null

L_ADMIT_DATE

smalldatetime

√

null

CON_DESC

varchar

√

null

WARD

varchar

√

null

PAL_WARD

int

√

null

L_DC_ADMIT

int

√

null

L_LOC_PRE_ADMIT

int

√

null

L_INT_BLOOD

int

√

null

L_INT_PARA

int

√

null

L_INT_NEURAL

int

√

null

L_INT_INFUSE

int

√

null

L_DISCH_DATE

smalldatetime

√

null

L_DISCH_DEST

int

√

null

View Definition

CREATE VIEW [dbo].[vwPALLIATIVE_INPATIENTS]
AS
SELECT     dbo.tblPALLIATIVE_CARE.PATIENT_ID, dbo.tblPALLIATIVE_INPATIENTS.PALLIATIVE_ID, dbo.tblPALLIATIVE_INPATIENTS.INPAT_ID, 
                      dbo.tblPALLIATIVE_INPATIENTS.L_ADMIT_DATE, dbo.ltblCONSULTANTS.CON_DESC, dbo.ltblPAL_WARDS.WARD, dbo.ltblPAL_WARDS.PAL_WARD, 
                      dbo.tblPALLIATIVE_INPATIENTS.L_DC_ADMIT, dbo.tblPALLIATIVE_INPATIENTS.L_LOC_PRE_ADMIT, dbo.tblPALLIATIVE_INPATIENTS.L_INT_BLOOD, 
                      dbo.tblPALLIATIVE_INPATIENTS.L_INT_PARA, dbo.tblPALLIATIVE_INPATIENTS.L_INT_NEURAL, dbo.tblPALLIATIVE_INPATIENTS.L_INT_INFUSE, 
                      dbo.tblPALLIATIVE_INPATIENTS.L_DISCH_DATE, dbo.tblPALLIATIVE_INPATIENTS.L_DISCH_DEST
FROM         dbo.tblPALLIATIVE_INPATIENTS INNER JOIN
                      dbo.tblPALLIATIVE_CARE ON dbo.tblPALLIATIVE_INPATIENTS.PALLIATIVE_ID = dbo.tblPALLIATIVE_CARE.PALLIATIVE_ID LEFT OUTER JOIN
                      dbo.ltblPAL_WARDS ON dbo.tblPALLIATIVE_INPATIENTS.L_WARD = dbo.ltblPAL_WARDS.WARD_ID LEFT OUTER JOIN
                      dbo.ltblCONSULTANTS 
						ON dbo.tblPALLIATIVE_INPATIENTS.L_CONSULTANT = dbo.ltblCONSULTANTS.NATIONAL_CODE AND ltblCONSULTANTS.IS_DELETED = 0

Columns

View Definition

Possibly Referenced Tables/Views