reapershole
Technical User
i am building a database where the people in the database, listed by social security number, must get certain bennifits calculated per year in another table...
tblemployee tbldentlecoverage tblevisioncoverage
social # social security social security
year hire basic coverage glasses
major coverage contacts
the socials are all related (obviously), my trouble is determining how to build the equations for the basic and major dental coverage...
here is what i need to do...
for basic, the first year is 70% which increases yearly to 100% BUT if an employee goes a year without using thier coverage then it recycles down to 70% from where-ever it was. the percentages increase every year when the year changes, not when they have been employed for a year (or two, or three, or...). this coverage has a lifetime deductable of 50 dollars (meaning, they have to pay out 50 bucks one time in the very beginning to get anything but do not have to pay it ever again). this equation also has a yearly payout limit of 850 dollars.
for major, the company pays a straight 50% with a 25 dollar yearly deductable and an 850 maximum payout.
tblemployee tbldentlecoverage tblevisioncoverage
social # social security social security
year hire basic coverage glasses
major coverage contacts
the socials are all related (obviously), my trouble is determining how to build the equations for the basic and major dental coverage...
here is what i need to do...
for basic, the first year is 70% which increases yearly to 100% BUT if an employee goes a year without using thier coverage then it recycles down to 70% from where-ever it was. the percentages increase every year when the year changes, not when they have been employed for a year (or two, or three, or...). this coverage has a lifetime deductable of 50 dollars (meaning, they have to pay out 50 bucks one time in the very beginning to get anything but do not have to pay it ever again). this equation also has a yearly payout limit of 850 dollars.
for major, the company pays a straight 50% with a 25 dollar yearly deductable and an 850 maximum payout.