The following
table, which is NOT all inclusive, outlines some of the tables which should
never be purged without serious analysis and testing. This table was
compiled as a result of a direct request regarding these specific tables, and
you should not take this to mean that these are the only tables that need to
remain intact.
ITEM_SF
ITEM_LINE_SF
ITEM_XREF
ITEM_DUE_SF
ACCOUNT_SF
TUIT_CALC_TBL
FEE_CLASS_PRICE
BI_BILLING_LINE
STDNT_CAR_TERM
STDNT_ENRL (except through the delivered process)
STDNT_SESSION
The following tables may be purged through delivered processes:
STDNT_ENRL - (Manage Student Records, Manage Academic Records, Process, Drop Purge) will purge all of the classes in a drop status from PS_STDNT_ENRL.
PS_SA_REPORT_RSLT
The following tables can be purged as indicated:
PS_STDNT_CARTRM_PD after Consolidated Statistics has been run
BI_EMPLID_TEMP - After any billing run
BI_ACCT_TEMP - After any billing run
BI_ACCT_ITM_TMP - After any billing run
CREDIT_HISTORY of all but the most current effective dated rows for each student
ITEM_SF_GL_HIST - if the following table is purged
SF_ACCTG_LN - after journals are processed and data no longer needed for historical purposes
COMM_SCTN _DATA in conjunction with the following table
COMM_SCTN_HDR.
ITEM_SF
ITEM_LINE_SF
ITEM_XREF
ITEM_DUE_SF
ACCOUNT_SF
TUIT_CALC_TBL
FEE_CLASS_PRICE
BI_BILLING_LINE
STDNT_CAR_TERM
STDNT_ENRL (except through the delivered process)
STDNT_SESSION
The following tables may be purged through delivered processes:
STDNT_ENRL - (Manage Student Records, Manage Academic Records, Process, Drop Purge) will purge all of the classes in a drop status from PS_STDNT_ENRL.
PS_SA_REPORT_RSLT
The following tables can be purged as indicated:
PS_STDNT_CARTRM_PD after Consolidated Statistics has been run
BI_EMPLID_TEMP - After any billing run
BI_ACCT_TEMP - After any billing run
BI_ACCT_ITM_TMP - After any billing run
CREDIT_HISTORY of all but the most current effective dated rows for each student
ITEM_SF_GL_HIST - if the following table is purged
SF_ACCTG_LN - after journals are processed and data no longer needed for historical purposes
COMM_SCTN _DATA in conjunction with the following table
COMM_SCTN_HDR.
PS_SF_ACCTG_LN_OLD after upgrade has been completed
