Is There a Process to Purge Data from Tables Populated by Consolidated Statistics Processes? (Doc ID 2006554.1)

Last updated on DECEMBER 22, 2015

Applies to:

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

Goal

 Customers generate consolidated statistics data many times during a term for a variety of reporting needs, each of which requires a unique Academic Statistics Period value to be created. The consolidated statistics processes populate the following tables:

STDNT_CONS_STAT

STDNT_CARTRM_PD

SSR_STD_CON_ST2

The processes can insert data rows for every active student at the institution, so over several terms the tables that hold the data could exceed a million rows. The actual academic statistics period list of values can become so long that it becomes unwieldy in a prompt field. Is there a way to delete rows from these tables for date ranges or statistics periods, and to delete academic statistics values themselves?

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms