PeopleSoft Wiki

This looks rather handy!

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