I have a task to design a grouping rule engine that must be robust and flexible for future needs.
I have a customer file with relationship code and I need to group the customers according to group types. Each group type have different criteria.
1) Group Type ABC - extract based on (1) relationship codes (from FILE2) A1, A2, A3, (A4 and FILE2/X1 field > 10%). (2) For individual (from FILE2) excluding A2, include members B1, B2, B3 (3) Stop extracting members for B1, B2, B3 i.e. just extract members for A1, A2, A3, A4
2) Group Type DEF, extract based on (1) relationship codes B1, B2, B3 (2) based on members extracted in (1) extract the rest of the members by D1, D2, D3, (D4 and X1 field > 50% or X1 field >=20% and < 50)
Any idea how to parameterized the above so that I can build a grouping rule engine without any hardcoding in my programs? ALso, if in the future they want to include new file and fields in the extraction how to cater?
Thanks so much in advance for those who will reply to may question.