tblPALLIATIVE_CARE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PALLIATIVE_ID int identity 4 √ null
lnkPAL_REASON_REFERRAL_NEW.PALLIATIVE_ID FK_lnkPAL_REASON_REFERRAL_NEW_tblPALLIATIVE_CARER
lnkPAL_REF_INVESTIGATIONS.PALLIATIVE_ID FK_lnkPAL_REF_INVESTIGATIONS_tblPALLIATIVE_CARER
tblPALLIATIVE_CONTACT.PALLIATIVE_ID FK_tblPALLIATIVE_CONTACT_tblPALLIATIVE_CAREC
tblPALLIATIVE_CONTACT_BACK_UP.PALLIATIVE_ID FK_tblPALLIATIVE_CONTACT_BACK_UP_tblPALLIATIVE_CAREC
tblPALLIATIVE_EPISODE.PalliativeID FK_tblPALLIATIVE_EPISODE_tblPALLIATIVE_CARER
tblPALLIATIVE_INPATIENTS.PALLIATIVE_ID FK_tblPALLIATIVE_INPATIENTS_tblPALLIATIVE_CAREC
tblPALLIATIVE_MDT.PALLIATIVE_ID FK_tblPALLIATIVE_MDT_tblPALLIATIVE_CAREC
tblPalliativeMetastases.PalliativeID FK_tblPalliativeMetastases_tblPALLIATIVE_CARER

Palliative Care record ID
PATIENT_ID int 4 null
tblDEMOGRAPHICS.PATIENT_ID FK_tblPALLIATIVE_CARE_tblDEMOGRAPHICSC

Demographic Record ID
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
L_REG_DATE smalldatetime 16 √ null

Date of palliative referral
L_CONSULTANT varchar 8 √ null

Palliative care consultant
L_REFERRAL_SOURCE int 4 √ null

Palliative referral source
L_REFERRAL_SOURCE_OTHER varchar 255 √ null

Palliative referral source if other
L_REFERRER int 4 √ null

Type of palliative referrer
L_TYPE_OF_REFERRER_OTHER varchar 255 √ null

Type of palliative referrer if other
L_WARD int 4 √ null

Ward referred from
L_REFERRED int 4 √ null
L_REF_REASON int 4 √ null

Reason for Referral
L_REASON_FOR_REFERRAL_2 int 4 √ null

Palliative/Supportive Care Reason
L_REASON_FOR_REFERRAL_OTHER varchar 255 √ null

Palliative/Supportive Care Reason if other
L_PRIORITY int 4 √ null

Referral Priority
L_PREV_SPEC_SUPPORT int 4 √ null

Previous Specialist Support
L_REFERRAL_OUTCOME int 4 √ ((0))

Referral Outcome
L_DATE_OF_FIRST_CONTACT smalldatetime 16 √ null

Date of First Contact
L_KEY_WORKER varchar 50 √ null

Key Worker
L_DATE_DIAGNOSIS smalldatetime 16 √ null

Date of Diagnosis
L_CANCER_SITE1 varchar 50 √ null

Main Diagnosis Site
L_PRIMARY_DIAGNOSIS varchar 10 √ null

Main Diagnosis group
L_PRIMARY_DIAGNOSIS_DET varchar 10 √ null

Main Diagnosis detail
L_CANCER_SITE_OTHER varchar 50 √ null

Other Diagnosis site
L_OTHER_DIAGNOSIS varchar 10 √ null

Other Diagnosis group
L_OTHER_DIAGNOSIS_DET varchar 10 √ null

Other Diagnosis detail
DEPRECATED_20_02_L_BONE int 4 √ null

Bone Metastases
DEPRECATED_20_02_L_BRAIN int 4 √ null

Brain Metastases
DEPRECATED_20_02_L_LUNG int 4 √ null

Lung Metastases
DEPRECATED_20_02_L_LIVER int 4 √ null

Liver Metastases
DEPRECATED_20_02_L_LYMPH int 4 √ null

Distant Lymph Nodes Metastases
L_LOCAL int 4 √ null

Local Metastases
DEPRECATED_20_02_L_SKIN int 4 √ null

Skin Metastases
DEPRECATED_20_02_L_OTHER int 4 √ null

Other Metastases
L_DATE_DISCHARGE date 20 √ null

Date of Discharge
L_DISCH_DESIRED_PLACE int 4 √ null

Desired Destination
L_DISCH_DESIRED_PLACE_OTH varchar 255 √ null

Desired Destination if other
L_RAPID_DISCH bit 1 ((0))

Rapid Discharge Desirable
L_DISCH_METHOD int 4 √ null

Discharge Reason
L_DISCH_METHOD_IP_UNIT varchar 255 √ null

Discharge Reason (IP Unit)
L_RAPID_DISCH_ACHIEVED bit 1 ((0))

Rapid Discharge Acheived
L_DISCH_DEST int 4 √ null

Actual Destination
L_DISCH_DEST_OTH varchar 255 √ null

Actual Destination if other
DEPRECATED_20_02_L_ADRENAL int 4 √ null

Adrenal Metastases
DEPRECATED_20_02_L_BONE_MARROW int 4 √ null

Bone Marrow Metastases
DEPRECATED_20_02_L_BONE_EXCL_MARROW int 4 √ null

Bone (excluding bone marrow) Metastases
DEPRECATED_20_02_L_UNKNOWN int 4 √ null
DEPRECATED_20_02_L_OTHER_METS varchar 255 √ null
PALLIATIVE_REFERRAL_ID int 4 √ null
DIAGNOSIS_TYPE_CODE_PRIMARY int 4 √ null
DIAGNOSIS_TYPE_CODE_OTHER int 4 √ null
DISEASE_CLASSIFICATION_ID_PRIMARY int 4 √ null
DISEASE_CLASSIFICATION_ID_OTHER int 4 √ null
ACTION_ID int 4 √ null

Latest Audit entry ID
DIAGNOSIS_ACTION_ID int 4 √ null

Latest Audit entry ID for diagnosis
L_REASON_FOR_REFERRAL_OTHER_NEW varchar 255 √ null
INV_OTHER varchar 100 √ null
INV_COMMENTS varchar 2147483647 √ null
READY_TREATMENT_DATE datetime 16,3 √ null
TIME_FIRST_CONTACT time 32 √ null
TIME_AFTER_DIAGNOSIS varchar 50 √ null
PERSONALISED_CARE_PLAN int 4 √ null
CONSENT_SECONDARY_USERS int 4 √ null
PREFERRED_PLACE_DEATH int 4 √ null
COMMENTS varchar 2147483647 √ null
DIAGNOSIS_TYPE_CODE_SECONDARY int 4 √ null
L_CANCER_SITE_SECONDARY varchar 50 √ null
DISEASE_CLASSIFICATION_ID_SECONDARY int 4 √ null
L_SECONDARY_DIAGNOSIS varchar 10 √ null
L_SECONDARY_DIAGNOSIS_DET varchar 10 √ null
PREFERRED_PLACE_DEATH_OTHER varchar 255 √ null
DEPRECATED_20_02_RegionalLymphNodeMetastases int 4 √ null
DEPRECATED_20_02_RecurrenceorMetastaticType int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblPALLIATIVE_CARE Primary key Asc PALLIATIVE_ID

Relationships

Close relationships within degrees of separation