vwPALCARE_IP_S1_ADMITDATA

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PALLIATIVE_ID

int

√

null

PATIENT_ID

int

√

null

L_ADMIT_DATE

smalldatetime

√

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

L_CANCER_SITE1

varchar

√

null

L_PRIMARY_DIAGNOSIS

varchar

√

null

LOS

int

√

null

View Definition

CREATE VIEW [dbo].[vwPALCARE_IP_S1_ADMITDATA]
AS
SELECT     dbo.tblPALLIATIVE_INPATIENTS.PALLIATIVE_ID, dbo.tblPALLIATIVE_CARE.PATIENT_ID, dbo.tblPALLIATIVE_INPATIENTS.L_ADMIT_DATE, 
                      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, dbo.tblPALLIATIVE_CARE.L_CANCER_SITE1, 
                      dbo.tblPALLIATIVE_CARE.L_PRIMARY_DIAGNOSIS, DATEDIFF(dd, dbo.tblPALLIATIVE_INPATIENTS.L_ADMIT_DATE, dbo.tblPALLIATIVE_INPATIENTS.L_DISCH_DATE) 
                      AS LOS
FROM         dbo.tblPALLIATIVE_INPATIENTS LEFT OUTER JOIN
                      dbo.tblPALLIATIVE_CARE ON dbo.tblPALLIATIVE_INPATIENTS.PALLIATIVE_ID = dbo.tblPALLIATIVE_CARE.PALLIATIVE_ID

Columns

View Definition

Possibly Referenced Tables/Views