I have created a data table to store all of the possible commissions that can be paid to an agent based on multiple criteria, but it’s well over 600k rows (and that’s just for one product). I’m wondering if there’s a better way? I can’t upload the document (new user). But here is how it’s laid out.
Col 1 = Insurance Carrier
Col 2 = Issue Age (Age of the client at Issue Date)
Col 3 = Contract Level
Col 4 = Plan Option
Col 5 = State
Col 6 = Commission Percentage
With 8 insurance carriers, 13 issue age rules, 12 Contract Levels, 11 plan options, and 50 states (813121150) we’re well over 600k rows. Any help would be greatly appreciated.