vwCNS_RECORDS_WITH_HNA - CanRegPrevious_v22

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

CNSContactID

int

null

View Definition

CREATE VIEW [dbo].[vwCNS_RECORDS_WITH_HNA]
AS

SELECT CNSContactID FROM
tblHolisticAssessment hna
WHERE
hna.DistressScorePractical IS NOT NULL OR
hna.DistressScoreFamily IS NOT NULL OR
hna.DistressScoreEmotional IS NOT NULL OR
hna.DistressScoreSpiritual IS NOT NULL OR
hna.DistressScorePhysical IS NOT NULL OR
hna.DistressScoreLifestyle IS NOT NULL OR
hna.childCare = 1 OR
hna.housing = 1 OR
hna.insurance = 1 OR
hna.transportation = 1 OR
hna.workSchool = 1 OR
hna.dealingWithChildren = 1 OR
hna.dealingWithPartner = 1 OR
hna.depression = 1 OR
hna.fears = 1 OR
hna.nervousness = 1 OR
hna.sadness = 1 OR
hna.worry = 1 OR
hna.lossOfFaith = 1 OR
hna.relatingToGod = 1 OR
hna.appearance = 1 OR
hna.bathingDressing = 1 OR
hna.breathing = 1 OR
hna.changesInUrination = 1 OR
hna.constipation = 1 OR
hna.diarrhea = 1 OR
hna.eating = 1 OR
hna.fatigue = 1 OR
hna.feelingSwollen = 1 OR
hna.fevers = 1 OR
hna.gettingAround = 1 OR
hna.indigestion = 1 OR
hna.mouthSores = 1 OR
hna.nausea = 1 OR
hna.noseDryCongested = 1 OR
hna.pain = 1 OR
hna.sexual = 1 OR
hna.skinDryItchy = 1 OR
hna.sleep = 1 OR
hna.tinglingInHandsFeet = 1 OR
hna.communication = 1 OR
hna.householdtasks = 1 OR
hna.[money] = 1 OR
hna.mealsDrinks = 1 OR
hna.relativeFriend = 1 OR
hna.anger = 1 OR
hna.diffMakingPlans = 1 OR
hna.guilt = 1 OR
hna.loneliness = 1 OR
hna.notAtPeace = 1 OR
hna.lossOfMeaningPurpose = 1 OR
hna.flushes = 1 OR
hna.memoryProblems = 1 OR
hna.speechProblems = 1 OR
hna.tasteDisturbance = 1 OR
hna.woundProblems = 1 OR
(REPLACE(hna.otherProblems, ' ', '') <> '' OR hna.otherProblems IS NOT NULL) OR
hna.CaringResponsibilities = 1 OR
hna.LossOfInterest = 1 OR
hna.QuestionsToDiscuss = 1 OR
hna.cbSupport = 1 OR
hna.cbTherapies = 1 OR
hna.cbDiet = 1 OR
hna.cbExercise = 1 OR
hna.cbSmoking = 1 OR
hna.cbAlcohol = 1 OR
hna.cbSun = 1 OR
hna.cbHobbies = 1 OR
hna.cbOther = 1 OR
hna.cbhopelessness = 1 OR
hna.cbexpressfeelings = 1 OR
hna.sadnessOrDepression = 1

Possibly Referenced Tables/Views

tblHolisticAssessment