Fully agree with Luis on this one, you need at least another table, but you do need to record history.

Think of questions like; does the allowance change annually, how is it calculated, is it connected to salary, how do you record any increase as a result of promotion so that you can calculate the full allowance paid in any one period or over successive periods.