vwPALLIATIVE_NCPC1


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PATIENT_ID int 4 null
N1_9_SEX int 4 √ null
N1_10_DATE_BIRTH datetime 16,3 √ null
N1_15_ETHNICITY varchar 50 √ null
L_REG_DATE smalldatetime 16 √ null
L_CANCER_SITE1 varchar 50 √ null
L_PRIMARY_DIAGNOSIS varchar 10 √ null
LOS int 4 √ null
PALLIATIVE_ID int 4 √ null
INPAT_ID int 4 null
L_ADMIT_DATE smalldatetime 16 √ null
CON_DESC varchar 50 √ null
WARD varchar 50 √ null
PAL_WARD int 4 √ null
L_DC_ADMIT int 4 √ null
L_LOC_PRE_ADMIT int 4 √ null
L_INT_BLOOD int 4 √ null
L_INT_PARA int 4 √ null
L_INT_NEURAL int 4 √ null
L_INT_INFUSE int 4 √ null
L_DISCH_DATE smalldatetime 16 √ null
L_DISCH_DEST int 4 √ null

View Definition

Possibly Referenced Tables/Views