Transcript:
0:00 hi everyone mike from north52 here in
0:02 today's video
0:03 we will show how a multi-sheet decision
0:05 table can be used to calculate the
0:08 complex heart disease risk score
0:10 for a patient our requirement for this
0:12 scenario
0:13 is as follows we wish to store
0:16 all the patient vital data within crm
0:20 we want to use this data to calculate
0:22 our risk score
0:24 we need the calculation to be easily
0:26 readable for future adaption
0:29 so in this example we will have eight
0:31 risk factors
0:32 and one mitigating factor that affect
0:35 the chance of heart disease
0:37 however for this video we will show only
0:39 the first requirement
0:40 to save time
0:44 risk factor one smoking the patient is
0:47 considered a risk
0:49 if they meet any of the following
0:50 criteria
0:52 are they currently a smoker have they
0:55 given up smoking in the last six months
0:58 or do they have environment and exposure
1:00 to cigarette smoke
1:01 in the work or home so let's see this
1:04 implemented
1:05 into a decision table you can see here
1:08 that this is the first risk factor
1:10 smoking
1:12 note the conditional or column here if
1:15 the patient meets any of these
1:16 conditions
1:17 the smoke risk variable will be set to
1:19 true the other risks are similar in
1:21 nature
1:22 so we will just flick through them
1:26 lifestyle
1:29 obesity
1:33 hypertension
1:38 dyslipidemia
1:40 pre-diabetes
1:43 age and gender
1:47 family history and high hdl
1:52 note that you can see all of these
1:54 variables now under the decision table
1:56 calculation
1:57 the decision table then uses all these
2:00 risk variables
2:01 to add up the risk score note that the
2:04 hdl
2:04 mitigating factor is subtracting from
2:07 the score
2:08 this is because it actually reduces
2:09 chances of heart disease
2:11 now here you can see that we now have a
2:14 fully calculated risk score
2:16 and then we update the risk score field
2:19 on the patient vital with this
2:20 calculated variable
2:22 so let's see this in action here's a
2:25 patient's vital records
2:27 and if we make a few changes here
2:31 we can see the score changing
2:41 thank you for watching and if you have
2:43 any questions about how North52 can
2:45 help your organization
2:47 please get in touch also please
2:49 subscribe to our youtube channel by
2:51 clicking the subscribe button