My Oracle Support Banner

SRPCCONP: ENRL_STAT_CHG_DT Is Blank For Dicontinued Students (Doc ID 2698722.1)

Last updated on AUGUST 07, 2020

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.


In  PeopleSoft Enterprise Campus Solutions  a customer generated and submitted the first enrollment file for term  to the Clearinghouse and received errors. The errors are for for those students reported as Withdrawn because they have a DC (discontinued) program status. Customer includes DC status in the Academic Statistics Type setup.

 Error (External) from NSC  Error Number 207 and these errors require correction in order for our file to be processed.

One would expect the  students with a program status equal to DC will be included in the file with an enrollment status change date populated.   This is based on Peoplebooks ascertion  that the ENRL_STAT_CHG_DT value in PS_STDNT_CONS_STAT table would have the effdt of the acad_prog record reported

“If any other program status is reported, the EFFDT of the ACAD_PROG record is reported.”

The issue can be reproduced at will with the following steps:
1. Run term snapshot and consolidation process using an academic statistics period with a type of NSC where Program Status of DC (discontinued) is included in the type definition. 
2. Generate the NSC report for the stats period 
3. Review the row of data for a student with a discontinued program and note that the enrollment status date field is blank.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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