After Running Consolidated Statistics, NSC Data Elements Page Shows Enrollment Status Date Prior to Term Instead of the First Day of Term, When the Enrollment Status Has Changed Compared to Previous Term (Doc ID 2979256.1)

Last updated on OCTOBER 09, 2023

Applies to:

Symptoms

On the NSC Data Elements page, the enrollment status date, populated by the Consolidated Statistics process, is incorrect for a small subset of students whose enrollment status has changed from the prior term to the current term; for example, the status was full time in the spring and now half time in the summer.

In these situations, the Program Enrollment Status Date on the NSC Data Elements page - which subsequently is transferred to the NSC report - displays the latest add/drop date for classes in the term, when all the enrollment activity occurred prior to the term start.

Regardless of when the class adds and drops occurred, the Program Enrollment Status Date should be the first day of the current term for the First of Term report if the enrollment status change begins with the start of the new term.

The issue can be reproduced at will with the following steps:

1. Navigate to Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Process Consolidate Statistics > Consolidated Statistics, and run the process - first the 'Take Term Statistics Snapshot' step (SRPCCONA), then the 'Consolidated Acad Statistics' step (SRPCCONP).
2. Navigate to Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Student Consolidated Stats > NSC Data Elements for a student with a new enrollment status for the term just processed - ie, enrollment status has changed from the student's prior term.
3. Go to the row for the Statistics Period and term that was processed. 
4. In the 'NSC Data Elements History By CIP Code' section, click on 'Statistics' tab and note the enrollment status date is befor the start of the term.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.