4.9 Finance

Finance controls the actual flow of money through the University. This includes the payment of deposits and tuition payments.

It is very important to run the Quality Checks on this data. There can very strange results (e.g. extremely late payments). Thus run the checks and work with Finance to verify their accuracy.

4.9.1 Deposits

These data represent the date that a student pays their deposit. Care should be taken to consider those students who have their deposit waived as in the case of some scholarships. Additionally, some students pay their tuition outright and thus will not have a separate deposit line item. These students are the rare cases, but this information should be considered.

First Deposits ETL
param	response
Description	Received Deposits
Contact	Mike Maedjaja
Contact Office	Finance
Input File Type	Excel File
Method of Retrieval	File sent on request
Frequency of Update	Term
Record Type	student
ETL File Name	Building FR cohort file_4_deposits.sas
Output Data Set Name	Xdeposits
QA Program (if Applicable)	qa/qa_deposit_payment.Rmd

4.9.2 First Payments

These data represent the first time that a student begins paying their tuition. Initial research has shown that students who wait until the last moment to pay their tuition are more likely to leave.

Tuition Payments ETL
param	response
Description	First Payments
Contact	Mike Maedjaja
Contact Office	Finance
Input File Type	Excel File
Method of Retrieval	File sent on request
Frequency of Update	Term
Record Type	term
ETL File Name	Building FR cohort file_4_first_payment.sas
Output Data Set Name	Xfirst_payments
QA Program (if Applicable)	qa/qa_deposit_payment.Rmd