I hunted for HOURS to find where deposit fees are stored. Things like Tuition Deposit Fees are not recorded under ps_item_sf like regular charges; rather, these are considered "debit memos." Putting a $500 tuition deposit fee along with the full tuition would make a double charge. Deposit payments are recorded under ps_item_sf and go to offset tuition charges.
In short:
ps_adm_appl_dep - Records calculated deposit fees (e.g. student housing, tuition deposit) as distinct from full charges
Credit History -
CREDIT_HISTORY
Tuition Calc -
TUIT_CALC_TBL
CALC_MESSAGES
OPT_FEE_STDNT
Group Post -
GROUP_CONT_INFO
GROUP_LINE
Cashiering -
CSH_BD_CSH_OPEN
CSH_OFF_RECEIPT
CSH_OFF_RCPT_L
CSH_OFF_RCPT_T
Third Party Contracts/Deferral Contracts/Payment Plans -
TP_CONTRACT
TP_STUDENT
Refunds -
REFUND_HDR
REFUND_DTL
REFUND_CHECK
Collections -
COLLECTION_SF
1098-T Reporting -
SF_1098_DTL_SF
SF_1098_ITEM
GL Interface -
SF_ACCTG_LN
Optional Fees -
OPT_FEE_STDNT
Tuition Group Setup -
SEL_GROUP_TBL
SEL_GROUP_CRITR
GROUP_FEE_TBL
Criteria Setup -
SEL_CRITER_TBL
SEL_CRITR_TBL
SEL_VALUE_TBL
Term Fee Setup -
TERM_FEE_TBL
TERM_FE_CD_TBL
TERM_SF_CD_TBL
TERM_SUBFEE_TBL
Waiver Setup -
WAIVER_CODE_TBL
WAIVER_TBL
Item Type Setup -
ITEM_TYPE_TBL
ITEM_ACCT_TYPE
GL_INTERFACE
Billing -
BI_BILL_HEADER
BI_BILLING_LINE
BI_BILL_MESSAGE
BI_STD_REQ_TBL
Thanks for your contribution, I've updated the article with this info.
Maybe include Academic Advisement tables?
Cheers
I'm interested in what SF tables people are archiving / deleting and how it's being done. Eg PS_FEE_CLASS_PRICE and PS_CALC_MESSAGES
I know sites that have looked into using Data Archive Manager for SF tables (for example Collections). I'm curious as to how many rows you have in those two tables?
As a comparison where I work the numbers are:
- PS_FEE_CLASS_PRICE 2,945,423 rows
- PS_CALC_MESSAGES 2,386,750 rows
These might be good candidate tables for data archiving.