tblPALLIATIVE_CONTACT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CON_ID int identity 4 √ null
tblPALLIATIVE_HOLISTIC_ASSESSMENT.contactID FK_tblPALLIATIVE_HOLISTIC_ASSESSMENT_tblPALLIATIVE_CONTACTC
PALLIATIVE_ID int 4 null
tblPALLIATIVE_CARE.PALLIATIVE_ID FK_tblPALLIATIVE_CONTACT_tblPALLIATIVE_CAREC
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
L_CONTACT_DATE smalldatetime 16 √ null

Date of Contact
L_RESIDENCE int 4 √ null

Current Residence
L_LOCATION int 4 √ null

Contact Location
L_OTHER_LOCATION varchar 255 √ null

Other Location
L_HOSPITAL varchar 5 √ null

Hospital
L_CLINIC varchar 255 √ null

Clinic
L_CONTACT_TYPE int 4 √ null

Contact Type
L_TIME int 4 √ null

Time Spent (mins)
L_CONTACT_PAT bit 1 ((0))

Contact With Patient
L_CONTACT_REL bit 1 ((0))

Contact With Relative
L_CONTACT_CARER bit 1 ((0))

Contact With Carer
L_CONTACT_PROF bit 1 ((0))

Contact With HCP
L_PROF_WHO varchar 255 √ null

HCP Details
L_SEEN_BY int 4 √ null

Seen By 1
L_SEEN_NAME varchar 50 √ null

Seen By 1 - Name
L_SEEN_BY_2 int 4 √ null

Seen By 2
L_SEEN_NAME_2 varchar 50 √ null

Seen By 2 - Name
L_PAIN_CONTROL bit 1 ((0))

Activity Level of Care - Pain Control
L_OTHER_SYMP_MAN bit 1 ((0))

Activity Level of Care -Other Symptom Management
L_TEL_SUPP bit 1 ((0))

Activity Level of Care - Telephone support
L_PSYC_SUPP bit 1 ((0))

Activity Level of Care - Psychological Support
L_INFO_GIVE bit 1 ((0))

Activity Level of Care - Information Giving
L_PAL_TREAT bit 1 ((0))

Activity Level of Care - Palliative Treatments
L_TERM_CARE bit 1 ((0))

Activity Level of Care - Terminal Care
L_STAFF_SUPP bit 1 ((0))

Activity Level of Care - Staff Support/Comms
L_FAM_SUPP bit 1 ((0))

Activity Level of Care - Family Support
L_DISCH_LIASON bit 1 ((0))

Activity Level of Care - Discharge Liaison
L_PLN_RAPID_DISCH bit 1 ((0))

Activity Level of Care - Rapid Discharge Planning
L_HOME_VISIT bit 1 ((0))

Activity Level of Care - Home Visit
L_BEREAV_SUPP bit 1 ((0))

Activity Level of Care - Bereavement Support
L_INT_INVEST bit 1 ((0))

Activity Level of Care - Initiate Investigation
L_PAT_REL_ADMIN bit 1 ((0))

Activity Level of Care - Patient Related Admin
L_REF_COMP_INT bit 1 ((0))

Activity Level of Care - Complex Intervention
L_INT_BLOOD bit 1 ((0))

Day Care Interventions - Blood Transfusion
L_INT_PARA bit 1 ((0))

Day Care Interventions - Paracentesis
L_INT_NEURAL bit 1 ((0))

Day Care Interventions - Neural Blockade Intervention
L_INT_INFUSE bit 1 ((0))

Day Care Interventions - Infusion Therapy
L_CURRENT_MEDICATION varchar 255 √ null

Medication
L_CURRENT_THERAPIES varchar 255 √ null

Therapies
L_CURRENT_DIET varchar 255 √ null

Diet
L_CURRENT_EXCERCISE varchar 255 √ null

Exercise
L_COMMENTS text 2147483647 √ null

Comments
CONTACT_NAME_ID_1 int 4 √ null

Seen By 1 Other ID
CONTACT_NAME_ID_2 int 4 √ null

Seen By 2 Other ID
L_SOCIAL_SUPP bit 1 ((0))

Activity Level of Care - Social Support
L_SPIRITUAL_SUPP bit 1 ((0))

Activity Level of Care - Spiritual Support
L_ADVANCE_CARE bit 1 ((0))

Activity Level of Care - Advance Care Planning
L_FINANCIAL_PLANNING bit 1 ((0))

Activity Level of Care - Financial Planning
L_NEW_TREATMENT bit 1 ((0))

Activity Level of Care - New Treatment
L_PERSONAL_CARE bit 1 ((0))

Activity Level of Care - Personal Care
L_PERMANENT_RECORD bit 1 ((0))

Activity Level of Care - Permaanent Record Offered
L_WRITTEN_INFO bit 1 ((0))

Activity Level of Care - Written Information Given
L_EPACGs bit 1 ((0))

Activity Level of Care - EPaCGs
PREVENTS_FACE_TO_FACE bit 1 ((0))

Prevents face to face contact
CONTACT_COMMENTS text 2147483647 √ null

Comments
ACTION_ID int 4 √ null
L_RESIDENCE_OTHER varchar 200 √ null
CNS_INTERVENTION_LEVEL int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblPALLIATIVE_CONTACT Primary key Asc CON_ID

Relationships

Close relationships within degrees of separation