What are All the Staging Table Records That Store Flat Format Direct Loan Data, Including Any Detail Staging Tables Used After the Change to COD Processing in XML format Beginning 2004-2005 ?
(Doc ID 2963414.1)
Last updated on AUGUST 14, 2023
Applies to:PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.
Is there an existing reference - or any other method - that can help identify a full list of staging tables that store incoming Direct Loan (DL) flat file data?
There may be various uses for this type of table identification. For example, in one reported case a school was working on a project archive and then delete date from staging tables that contain Personal Information (PII).
For Aid Years 2003-2004 and earlier, DL Data processed in the flat file format for all of the various message classes can be found in the Header (DL_HDR_XX_EC) and Trailer Records along with the following detail records (which may not be a fully inclusive list):
Beginning in 2004-2005, the preceding list of 7 detail tables stopped being delivered with the transition to COD processing in the XML format. The Header and Trailer records have continued to be delivered each year, since these are still used for some of the reconciliation message classes like DSDF and DSLF. However, the header and trailer records are seen to have still been populated with the other COD message classes also, through at least 2008-2009.
This observed data population pattern is confusing because it is not clear if (a) there are other, different staging table records that contain the detail information corresponding to the header information loaded into DL_HDR_XX_EC for the COD message classes; and/or (b) if all of the COD information - including header, trailer, and detail records - is intended to be in the SFA_COD tables, then why and how was the header data for the COD message classes also loaded into DL_HDR_XX_EC?
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