Infrastructure method and system for managing deductibles for insurance policies

A non-transitory computer-readable medium comprising a plurality of instructions, which, when executed by a processor, cause the processor to determine a renewal deductible for an insurance policy, the plurality of instructions comprising:

• instructions that cause the data processor to extract a first key reference from a first table of a plurality of interrelated tables, the first key reference identifying a first specific group of policy variables;
• instructions that cause the data processor to retrieve a current deductible associated with the insurance policy;
• instructions that cause the data processor to match the first key reference to a second table including a default deductible, a new deductible indicator having either a positive state or a negative state, an available deductible key reference, and a next higher deductible indicator having either a positive or a negative state;
• instructions that cause the data processor to retrieve the default deductible, the new deductible indicator, and the next higher deductible indicator from the second table;
• instructions that cause the data processor to determine that the default deductible is less than the current deductible;
• instructions that cause the data processor to determine that the new deductible indicator is in the negative state;
• instructions that cause the data processor to retrieve, using the available deductible key reference, a plurality of available deductibles from a third table;
• instructions that cause the data processor to determine that the plurality of available deductibles does not include the current deductible;
• instructions that cause the data processor to set the renewal deductible equal to the available deductible of the plurality of available deductibles higher than and closest to the current deductible if the next higher deductible indicator is in a positive state;
• and
• instructions that cause the data processor to set the renewal deductible equal to the available deductible of the plurality of available deductibles less than and closest to the current deductible if the next higher deductible indicator is in a negative state.

An information handling system for determining a renewal deductible for an insurance policy, the information handling system comprising:

• a storage device storing a program;
• a processor coupled to the storage device and operative with the program for processing data in a plurality of interrelated tables, wherein the processor is operable to execute instructions of the program, the instructions comprising:
• extracting, using the processor, a first key reference from a first table;
• retrieving a current deductible associated with the insurance policy;
• matching, using the processor, the first key reference to a second table including a default deductible, a new deductible indicator having either a positive state or a negative state, an available deductible key reference, and a next higher deductible indicator having either a positive or a negative state;
• retrieving, using the processor, the default deductible, the new deductible indicator, and the next higher deductible indicator from the second table;
• determining, using the processor, that the default deductible is less than the current deductible;
• determining, using the processor, that the new deductible indicator is in the negative state;
• retrieving, using the processor and the available deductible key reference, a plurality of available deductibles from a third table;
• determining, using the processor, that the plurality of available deductibles does not include the current deductible;
• setting the renewal deductible equal to the available deductible of the plurality of available deductibles higher than and closest to the current deductible if the next higher deductible indicator is in a positive state;
• and
• setting the renewal deductible equal to the available deductible of the plurality of available deductibles less than and closest to the current deductible if the next higher deductible indicator is in a negative state.