I need to create a database to track various performance metrics of different people. My issues are these:
1) Each person has different metrics (some overlap, but there can be as many as 12 different metrics, with each person having 2-3 metrics being tracked)
2) Each person has a different acceptable level for each metric that they are being tracked on.
3) Each person is tracked at different frequencies (some quarterly, others semi-annually - and they don't all have it on the same months i.e. not everyone is reviewed Dec 31, Mar 30, Jun 30, Sep 30)
Any ideas?