Skip to content

Student Enrollment Known Issues Log

Issue Date Historical/Incremental Years Impacted Issue Description
07/18/2018

Historical

Incremental

All Years

Even though there is a UC Ethnicity 13 Category in both the Student Enrollment data mart (ENR_UC_ETHN_13_CAT) and in the star schema (UC_ETN_CD_LVL_1_13CAT_NAM), the variables are different across both environments. The UC Ethnicity 13 Category within the star schema does not include the International category. The same variable in the data mart does. Do not expect the distinct values for UC Ethnicity 13 Category from the data mart to match the distinct values from the star schema.

03/13/2018

Historical

2009

In 2009 academic year, counts for UCI off by one student per file

05/11/2017

Historical

Incremental

All Years

In CDW, data was stored as one record per student. In case of students with multiple majors each of them having conflicting MASTER_ACAD_PROF_STATUS or DOCTOR_ACAD_PROF_STATUS data for related data in the CCM cross-reference table, then the value 'B' (BOTH) is stored in Academic/Professional field.

In UCDW, data will stored as a record for each major for every reporting year, term and period for a student and so ‘BOTH’ value will not be applicable for Academic/Professional field in UCDW.

09/15/2016 Historical

2009

2011

There is a known issue around the Units_Credited_From_CCC from UCD for for academic years 2009 and 2011. In 2009, the 3WK field is correct, but it was incorrectly multiplied by 10 for the EOT submission. In 2011, the EOT field seems correct, but the 3WK was multiplied by 10. See attachment.
02/05/2010 Historical 2009 Sixty UCI Law students were erroneously counted at student level 6 (doc1) instead of level 5 (master’s) in the Fall 2009 3WK file.
03/13/2008 Historical 2008 Merced will not be able to provide the new undergraduate unit fields (CREDUAP, CREDUIB, CREDUUC, CREDUCC, CREDUOT, ATTCN & PASTPU3) until Fall 2008.
03/13/2008

Historical

Incremental

All Years

There is currently no source for department data for the campus-college-major data (STUD_BI.CAMPUS_COLLEGE_MAJOR_CODE_D). This column is blank.

03/03/2008

 

Historical

Incremental

All Years

UCSF does not send enrollment EOT files. There is no expectation for this to change in the future.

Back to Student Enrollment Main Page