• The Kimball Group usually describes the application process as an event pipeline with predictible milestones. As such, if you were to design a data warehouse like structure for this process then the accumulating snapshot is a nice choice. Here is the section of the website describing accumulating snapshots:

    http://www.kimballgroup.com/2002/06/13/design-tip-37-modeling-a-pipeline-with-an-accumulating-snapshot/

    What's more? He even uses something very close to your business requirement in this article!