Created by Miki Yanagi, last modified on Feb 03, 2022
A number of tables and views have been created for calculating retention rates and graduation rates.
Here is the list of tables:
| Table Name | Brief Summary | Load process |
|---|---|---|
| UM_RETENTIONFSB | List of student with demographic information by term, institution, and career Includes undergraduate fall cohort students only. | AppEngine UM_STURETENT |
List of student with demographic information by term, institution, and career (more fields than UM_RETENTIONFSB). Includes undergraduate fall cohort students only. (same population as in UM_RETENTIONFSB) | it is done via a copy of PS_UM_RETENTIONFSB in the AppEngine UM_STURETENT. | |
| UM_RETENT_AET | This table is empty. |
Here is the list of views. The source table for these views is UM_STUD_CENS_VW.
| View Name | Brief Summary |
|---|---|
| um_retent_all | All terms attended (including summer) by career, terms not necessarily continuous |
| um_retent_fall | All fall terms attended (excluding summer and spring) by career, terms not necessarily continuous |
| um_retent_fallc | All continuous fall terms attended (excluding summer and spring) by career |
| All fall and spring terms attended (excluding summer) by institution and career, not necessarily continuous. Includes all students in UM_STUD_CENS_VW. | |
| um_retent_f_in | All fall terms attended by institution and career, terms not necessarily continuous |
| um_retent_inst | All terms attended (including summer) by institution and career, terms not necessarily continuous |
| Um_Retntc_Fl_In | All continuous fall terms attended (excluding summer and spring) by institution and career |
| Um_Retntc_Fs_In | All continuous fall terms attended (excluding summer and spring) by institution and career |
* The views with a C are based on continuous enrollment by term. Those without a C are based on enrollment by term not necessarily continuous.