vwCNS_PRINT_dotnet


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NURSE_ID int 4 null
CARE_ID int 4 null
L_CANCER_SITE varchar 50 √ null
N4_1_DIAGNOSIS_DATE varchar 30 √ null
ISODIAGNOSISDATE varchar 30 √ null
DIAG_DESC varchar 150 √ null
CONSULTANT varchar 56 √ null
FIRST_CONTACT int 4 √ null
L_DEC_REF_DATE varchar 30 √ null
L_REF_DATE varchar 30 √ null
L_SEEN_DATE varchar 30 √ null
L_DISCH_DATE varchar 30 √ null
TOTAL_TIME varchar 11 √ null
PLACE_DESC varchar 50 √ null
L_CONTACT_TYPE varchar 50 √ null
STATUS_DESC varchar 50 √ null
CNS_NAME varchar 50 √ null
L_KEY_WORKER varchar 255 √ null
CONTACT_WITH varchar 2147483647 √ null
REF1 varchar 50 null
REF2 varchar 50 √ null
REF3 varchar 50 √ null
L_NURSE varchar 50 √ null
ACTa1 varchar 100 null
ACTa2 varchar 100 null
ACTb1 varchar 100 null
ACTa3 varchar 100 null
ACTb2 varchar 100 null
ACTb3 varchar 100 null
OTHER_ACTIVITY_1 varchar 500 √ null
OTHER_ACTIVITY_2 varchar 500 √ null
OTHER_ACTIVITY_3 varchar 500 √ null
OTHER_ACTIVITY_4 varchar 500 √ null
OTHER_ACTIVITY_5 varchar 500 √ null
OTHER_ACTIVITY_6 varchar 500 √ null
L_NOTES text 2147483647 √ null
L_REFERRAL_OTHER varchar 500 √ null
L_REFERRAL_OTHER_SECONDARY varchar 500 √ null
HOLISTIC_ASSESSMENT_DECLINED int 4 √ null
HOLISTIC_ASSESSMENT_END int 4 √ null
PERFORMANCE_STATUS int 4 √ null
N1_5_SURNAME varchar 60 √ null
N1_6_FORENAME varchar 50 √ null
N1_10_DATE_BIRTH varchar 30 √ null
N1_2_HOSPITAL_NUMBER varchar 10 √ null
N1_1_NHS_NUMBER varchar 10 null
holisticID int 4 √ null
distressValue int 4 √ null
CaringResponsibilities bit 1 √ null
communication bit 1 √ null
householdtasks bit 1 √ null
housing bit 1 √ null
insurance bit 1 √ null
money bit 1 √ null
mealsDrinks bit 1 √ null
transportation bit 1 √ null
workSchool bit 1 √ null
childCare bit 1 √ null
dealingWithChildren bit 1 √ null
dealingWithPartner bit 1 √ null
relativeFriend bit 1 √ null
anger bit 1 √ null
diffMakingPlans bit 1 √ null
guilt bit 1 √ null
loneliness bit 1 √ null
worry bit 1 √ null
LossOfInterest bit 1 √ null
depression bit 1 √ null
fears bit 1 √ null
nervousness bit 1 √ null
sadness bit 1 √ null
cbhopelessness bit 1 √ null
cbexpressfeelings bit 1 √ null
sadnessOrDepression bit 1 √ null
lossOfFaith bit 1 √ null
notAtPeace bit 1 √ null
relatingToGod bit 1 √ null
lossOfMeaningPurpose bit 1 √ null
appearance bit 1 √ null
breathing bit 1 √ null
changesInUrination bit 1 √ null
constipation bit 1 √ null
diarrhea bit 1 √ null
eating bit 1 √ null
fatigue bit 1 √ null
feelingSwollen bit 1 √ null
fevers bit 1 √ null
flushes bit 1 √ null
gettingAround bit 1 √ null
indigestion bit 1 √ null
memoryProblems bit 1 √ null
mouthSores bit 1 √ null
nausea bit 1 √ null
pain bit 1 √ null
sexual bit 1 √ null
skinDryItchy bit 1 √ null
sleep bit 1 √ null
speechProblems bit 1 √ null
tasteDisturbance bit 1 √ null
tinglingInHandsFeet bit 1 √ null
woundProblems bit 1 √ null
bathingDressing bit 1 √ null
noseDryCongested bit 1 √ null
cbSupport bit 1 √ null
cbTherapies bit 1 √ null
cbDiet bit 1 √ null
cbExercise bit 1 √ null
cbSmoking bit 1 √ null
cbAlcohol bit 1 √ null
cbSun bit 1 √ null
cbHobbies bit 1 √ null
cbOther bit 1 √ null
otherProblems varchar 8000 √ null
ISODATESEEN varchar 30 √ null
L_KEY_WORKER_NEW int 4 √ null
L_KEY_WORKER_OTHER varchar 255 √ null

View Definition

Possibly Referenced Tables/Views