andreabringhurst
commented
3 months ago - headcount_census changes - changed the description (removed "from Edify"); changed a.sis_system_id to a.student_id for consistency.
- headcount_current changes - changed the description (removed "from Edify"); changed a.sis_system_id to a.student_id for consistency.
- headcount_end_of_term changes - changed the description (removed "from Edify"); changed a.sis_system_id to a.student_id for consistency; removed line 14 that included only Fall and Spring and excluded summer for consistency.
- headcount_ipeds_12_month changes - changed a.sis_system_id to a.student_id for consistency; removed the hard coding of academic year and changed to current academic year minus 1 making it for the previous year as IPEDS requires; added additional documentation.
- headcount_point_in_time - removed the hard coding of the term and changed to current term assuming that is what most people would want.
- headcount_census_groups - added a header with additional description; renamed level_id code and desc; renamed credit_load to course_load to match groups vignette; added is_subsidized_loan_awarded; renamed is_athlete_term to match groups vignette; recoded minority and renamed underrepresented_minority; added, fixed and renamed residency codes; renamed gpa_band to overall_cumulative_gpa_band for clarity; renamed all the program codes and pieces to match the groups vignette; renamed class_level id and code; changed = TRUE to IS TRUE to be consitent with other headcount sql; changed time frame to current year plus 5 years of data to be consistent with other headcount sql; removed the unneeded group by statement.