vwPALLIATIVE_NCPC4


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
L_DATE_DISCHARGE smalldatetime 16 √ null
L_DISCH_METHOD int 4 √ null
L_DISCH_DEST int 4 √ null
PALLIATIVE_ID int 4 √ null
CON_ID int 4 null
L_CONTACT_DATE smalldatetime 16 √ null
L_LOCATION int 4 √ null
LOCATION_DESC varchar 50 √ null
L_CONTACT_TYPE int 4 √ null
CONTACTTYPE_DESC varchar 50 √ null
L_TIME int 4 √ null
L_CONTACT_PAT int 4 √ null
L_CONTACT_REL int 4 √ null
L_CONTACT_CARER int 4 √ null
L_CONTACT_PROF int 4 √ null
L_SEEN_BY int 4 √ null
SEEN_BY1 varchar 50 √ null
L_SEEN_NAME varchar 50 √ null
L_SEEN_BY_2 int 4 √ null
SEEN_BY2 varchar 50 √ null
L_SEEN_NAME_2 varchar 50 √ null
L_PAIN_CONTROL int 4 √ null
L_OTHER_SYMP_MAN int 4 √ null
L_TEL_SUPP int 4 √ null
L_PSYC_SUPP int 4 √ null
L_INFO_GIVE int 4 √ null
L_PAL_TREAT int 4 √ null
L_TERM_CARE int 4 √ null
L_STAFF_SUPP int 4 √ null
L_FAM_SUPP int 4 √ null
L_DISCH_LIASON int 4 √ null
L_PLN_RAPID_DISCH int 4 √ null
L_HOME_VISIT int 4 √ null
L_BEREAV_SUPP int 4 √ null
L_INT_INVEST int 4 √ null
L_PAT_REL_ADMIN int 4 √ null
L_REF_COMP_INT 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_CURRENT_MEDICATION varchar 255 √ null
L_CURRENT_THERAPIES varchar 255 √ null
L_CURRENT_DIET varchar 255 √ null
L_CURRENT_EXCERCISE varchar 255 √ null
L_COMMENTS text 2147483647 √ null

View Definition

Possibly Referenced Tables/Views