VMF_Yield

See documentation on MD_Yield. Cf. MD_Rate.

Please note that this fact view is for calculating yield rates, and not so much for getting a headcount of students entering in the fall. The difference here is that the headcount (due to deferred admission cases) differs from the actual admit : matriculate or admit : deposit ratios, which are based on applications (so, e.g., if someone applies for admission in the winter of 2009 for admission that fall, and is accepted, but defers admission until the next year, we count this towards the 2009 yields; if we counted the matriculation towards 2010 yields, our numbers would be wrong, because we'd be counting the application and admit for one year, 2009, but the matriculation for another year, 2010, which would lead to inaccurate matriculation/admit ratios, i.e., to bad yield figures).

Bottom line: Yields ? fall headcounts.

As a workaround, if headcounts are desired, one can use MD_Prosp_ProjectedEntryTermYear from the prospect dimension instead of leveraging the foreign key relationship between this fact view and the Carleton term dimension. But one must be careful when doing this not to use the term dimension at all. And if a student has more than one complete application in our systems, then it is possible that he/she will be double counted. This situation is rare, but it does happen.

This fact view links to the most recent row for any given prospect.

Fact