L. D. Newlin-Blackwell Management Reporting Analyst University Reporting & Research

1. STU_ADMT_TERM_CD, STU_ADMT_TYP_CD, ACAD_DRVD_MATRIC_CD, ACAD_DRVD_COHORT_CD on IR_CEN_TRM_SNPSHT_GT L. D. Newlin-Blackwell Management Reporting Analyst University Reporting & Research

2. Records that were updated: STU_ADMT_TERM_CD & STU_ADMT_TYP_CD • Only records where ACAD_TRM_PRD_DESC =‘Official Census’ were updated • Records where ACAD_TRM_PRD_DESC = ‘First Week of Census’ were left as they were on the date of the 100% refund for a campus

3. Background Information • One addition (STDNT_CAR_NBR) to the logic that is used to determine admit term/type • UID, CAREER, INSTITUTION, STDNT_CAR_NBR from PS_STDNT_CAR_TERM • Joins to UID, CAREER, INSTITUTION, STDNT_CAR_NBR from PS_ACAD_PROG to pull off ADM_APPL_NBR which is the primary key to obtaining the admit term and type • Keys: UID, CAREER, INSTITUTION, ADM_APPL_NBR • ADMIT_TERM is located on PS_ADM_APPL_PROG • ADMIT_TYPE is located on PS_ADM_APPL_DATA • Problems with this logic: • Some records are missing ADM_APPL_NBR on ADM_APPL on PS_ACAD_PROG mostly on converted records and records get dropped • We remedy this by looking at those records where the term/type = null and check against the IR_LGCY_CENSUS_ST table to pull the entry date if there is one.

4. Why did we update these two columns? • This logic was not completely in place at the time of census • Business practices that may be different than we expected • Some students have admit terms of 4042 • But students did not have an enrollment record until 4048 • Students change programs but not careers • It appears that new records were inserted with new admit terms and types rather with the program action something other than PRGC – Does this practice on only apply to students who have applied and have not been admitted? • Issues with converted data, missing application numbers.

5. Will we need to continue this practice? • We hope not • We feel that as the SIS matures these issues will be resolved

6. ACAD_DRVD_COHORT_CD • Used the “updated” STU_ADMT_TERM_CD and STU_ADMT_TYP_CD as base • UGRD student enrolled in the 4048 and matriculated in 4044, 4045, 4046, or 4048 • And was either FYU, B, R, TRU, or T = part of the 4048 cohort • If the student had been identified in a previous cohort, the flag was set to null. • Can do this via a shadow system we maintain on our departmental server • We hope to be able to publish this data so that it is accessible to programmers

7. ACAD_DRVD_COHORT_CD values • F04UGB – Undergraduate Beginner (type = FYU) • F04UGB – Undergraduate Transfer (type = TRU) • F04GRB – Graduate Beginner (type = FYG) • F04GRT – Graduate Transfer (type = TRG • F04OPB – Optometry Beginner (type = FYO) • F04DTB – Dental Beginner (type = FYD) • F04LWB – Law Beginner (type = FYL) • F04MDB – Medical Beginner (type = FYM)

8. ACAD_DRVD_MATRIC_CD • Value in column = Y if a student has an “updated” STU_ADMT_TERM_CD = ‘4048’ • Value N if student was not identified as a matriculant • Applies to all student irregardless of career level