Hi
I need some insight into the following user scenario and would like some thoughts and suggestions where possible to see if I am in the correct state of mind :) I hope this makes sense.
The scenario;
A user configures award settings (Award Date, Award Price, Tranche Settings etc) and then allocates a number of options to to one or more participants. The particular award of options only becomes available in tranches for example;
A users receives 100 options on 01/01/2000 and they vest (become available) in intervals 50 on 01/01/2001 and 50 on 01/01/2002.
OR Tranches can be determined through a range of settings for example. 10 % of Options vest on 01/01/2001 and thereafter 3% Monhtly or specific dates can be specifiied in advance like I mentioned above.
To translate the user scenario into objects I have the following objects in place
Award (Parent)
AwardTransactions(Child)
I am not sure if I should have a seperate object for recording the vestings of the award for a participant or have it as part of the AwardTransaction object, i.e. put all the calculation logic to determine the tranche detail within Private Sub Child_Insert of the AwardTransaction object as it the tranches are only determined once the award has taken place and is essentialy part of the "Award Transaction"
I currently have the following tables in place to store the data required;
Award Table
AwardID
....
Participant Table
ParticipantID
...
Transactions Table
TransactionID
AwardID
ParticipantID
Units
ParticipantAwardVestings Table
ParticipantID
AwardID
Units
VestingDate
I hope this paints the picture to trigger some thought.
Thanks
John
Copyright (c) Marimer LLC