Date: 16 Mar 2009 00:44
Number of posts: 10
RSS: New posts
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.
ps_adm_appl_dep - Records calculated deposit fees (e.g. student housing, tuition deposit) as distinct from full charges
Credit History -
Tuition Calc -
Group Post -
Third Party Contracts/Deferral Contracts/Payment Plans -
1098-T Reporting -
GL Interface -
Optional Fees -
Tuition Group Setup -
Criteria Setup -
Term Fee Setup -
Waiver Setup -
Item Type Setup -
Thanks for your contribution, I've updated the article with this info.
you can also add "Grade Book" information tables like
PS_STDNT_GRADE_DTL student's grades detail
PS_LAM_CLASS_ACTV Class assignments information
Syed Usman Ahmed
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.