The Pennsylvania State University - Administrative Information Services, a unit of Information Technology Services

Bursar DB--Billing View Changes

Posted: Monday, February 05, 2007

Changes have been made to the billing view in the Bursar database. In order to retrieve the same data that could be retrieved before the upgrade, use the following query:

select student_id,
billed_amount_due,
billed_date,
billed_payment_due_date
from billing
where bill_type_long_name = 'SEMESTER BILL' and
      bill_semester = '200607SP'

I have pasted below some helpful information about the new fields from Scott's previous announcement from 12/22/06:

"There can now be bills from the current and future semesters.

Also there will be a record for each bill type that a student may have.

The bill_type and bill_type_long_name values are as follows:

E2 = SEMESTER BILL
G1 = STUDENT ACCOUNT STATEMENT
G2 = STUDENT ACCOUNT STATEMENT
P1 = DEFERMENT BILL
P2 = DEFERMENT BILL

In most cases if the deferment indicator is set on the Semester Bill, then the student would have a Deferment Bill produced later in the semester. If the student would pay off the account balance before the Deferment Bill for the second or third installment is created, then the student would not have a Deferment Bill produced - but the Semester Bill record would still have the deferment indicator set to a "Y".

The Semester Bill includes all the current charges for the semester (Tuition, Room & Board, etc., plus it would include any outstanding balance on the student account at the point that the Semester Bill is produced).

The Student Account Statement is a current balance of the student account at the point the bill is produced."

Content Questions: Data Warehouse