Transcript:
0:01 hi everyone mike from north52 here
0:04 in today's video we will show how a
0:06 decision table
0:07 can be used as a business rules engine
0:10 to calculate the supplemental nutrition
0:12 assistance program for idaho
0:14 this example for microsoft dynamics 365
0:17 shows some of our decision engine
0:18 features easily readable
0:21 with complex calculations that can be
0:23 comparamentalized
0:25 the requirements are as follows you must
0:28 be a citizen or a legal immigrant
0:31 to the usa you must be a resident of the
0:33 state of idaho
0:35 and with some exceptions you must work
0:37 or participate
0:38 in an employment or training your
0:40 household income must be less than the
0:42 program income limits
0:44 for your household size now let's have a
0:47 look at the decision table that has
0:49 incorporated
0:50 these requirements as you can see
0:53 each requirement has been met here
0:57 however only two of these columns are
0:59 field comparisons
1:02 immigration status
1:06 and employment status
1:10 the other three are referencing global
1:12 calculations
1:13 which we will look at shortly the end
1:16 result of this sheet
1:17 is if all conditions are met the food
1:20 assistance field
1:21 is updated to either yes or no
1:26 let's look at the global calculation
1:28 sheet next
1:29 our first calculation is resident in
1:32 idaho
1:32 this is a string comparison of the
1:35 primary residences
1:36 state or province it will return either
1:40 true
1:40 or false next
1:44 we have household monthly savings
1:48 this sums up the monthly income of any
1:50 contact
1:51 whose primary resident is equal to that
1:54 of the record we are executing this
1:56 formula on
1:58 the household income current savings is
2:00 similar
2:01 it sums up the current savings of anyone
2:04 whose primary residence is the same as
2:06 the record we're on
2:08 and the household income total is the
2:11 sum of these two results
2:14 a household resident is a count of all
2:17 the contacts
2:18 that have had their primary residency
2:19 set to this household account
2:23 to see this in action let's open up a
2:25 household resident
2:28 we can see that the resident is
2:29 currently ineligible for the food
2:31 assistance
2:33 however if we change the monthly income
2:36 to be a new number
2:37 and save
2:40 the value has now changed going back to
2:43 the decision table we can see
2:46 that this row here was the one to be
2:48 found
2:49 true thank you for watching and if you
2:51 have any questions about how North52
2:53 can help your organization
2:55 please get in touch also please
2:58 subscribe to our youtube channel by
2:59 clicking the subscribe button