Dict-Physical

View VMF_Rate

Card of view VMF_Rate

Name	VMF_Rate
Comment	See the documentation on MF_Rate. Cf. documentation on MF_Yield. The foreign key relationship between MF_Rate and MD_Date is largely useless and is not carried over to this view. This fact-view is based on prospective students, not on their applications. Hence apply, admit, deposit, etc. numbers recorded here are not ideal for strategic yield calculations. But they are great for eliciting headcounts of new students, etc., and for mining our applicant pool for information on who applies, is admitted, etc.
Dimensional Type	Fact

SQL query of the view VMF_Rate

SELECT
   MD_PROSP_SURROGATEKEY,
   CONVERT(int, [MF_RATE_RECRUITMENTPLUSPKID]) AS MF_RATE_RECRUITMENTPLUSPKID,
   MF_RATE_APPCOUNT,
   MF_RATE_ADMITCOUNT,
MF_RATE_DEPOSITCOUNT,
   MF_RATE_MATRICULANTCOUNT,
   MF_RATE_PROSPECTCOUNT
FROM
   MF_RATE

List of outgoing view references of the view VMF_Rate

ViewReference_5

VMD_Prospect

List of referenced objects of the view VMF_Rate

MF_Rate

List of diagrams containing the view VMF_Rate

ViewsProspectDiagram

List of permissions of the view VMF_Rate

SELECT,VIEW DEFINITION

ProspectViewReader

List of view columns of the view VMF_Rate

MD_Prosp_SurrogateKey

numeric

MF_RATE_RECRUITMENTPLUSPKID

MF_Rate_AppCount

int

1 if a given student applied, 0 if not.

Note that the grain of the table here is one row per student, so 1 is the maximum value for any given student.

This allows us to use this value in application-rate calculations.

MF_Rate_AdmitCount

int

1 if a given student was accepted, 0 if not.

Note that the grain of the table here is one row per student, so 1 is the maximum value for any given student.

This allows us to use this value in acceptance-rate calculations.

MF_Rate_DepositCount

int

1 if a student has paid his/her deposit or has been marked as a matriculant.

MF_Rate_MatriculantCount

int

1 if a given student was accepted and matriculated, 0 if not.

Note that the grain of the table here is one row per student, so 1 is the maximum value for any given student.

This allows us to use this value in matriculation-rate calculations.

MF_Rate_ProspectCount

int

Total count of prospects. This will always be 1.

It is used as the divisor in rate calculations. Be sure, though, to do the division post-aggregation. For example, if you are calculating application rates by geographical area, first group by geographical area, and take the sum of AppCount and ProspectCount. Then, after you've aggregated and summed, and only then, do the rate calculation: sum of AppCount / sum of ProspectCount.

If you don't understand how to do this, give the data warehouse team a hollar.

Home