vwPALLIATIVE_CONTACT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PATIENT_ID 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
L_OTHER_LOCATION varchar 255 √ null
L_SOCIAL_SUPP int 4 √ null
L_SPIRITUAL_SUPP int 4 √ null
L_ADVANCE_CARE int 4 √ null
L_FINANCIAL_PLANNING int 4 √ null
L_NEW_TREATMENT int 4 √ null
L_PERSONAL_CARE int 4 √ null
L_PERMANENT_RECORD int 4 √ null
L_WRITTEN_INFO int 4 √ null
L_EPACGs int 4 √ null

View Definition

Possibly Referenced Tables/Views