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 JANUARY 25, 2024

Applies to:

Goal

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):

DL_ORIG_##_EC
DL_ORGACK_##_EC
DL_PNTACK_##_EC
DL_CHG_##_EC
DL_CHGACK_##_EC
DL_DISB_##_EC
DL_DSBACK_##_EC

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?

Solution

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