Return to Navigation

Setting Up Adjustment Calendars

To set up adjustment calendars, use the Adjustment Calendars component (ADJ_TERM_PANEL).

This section provides an overview of adjustment calendars and discusses:

Adjustment calendars determine the refund schedules that you apply to the members of a tuition group. These calendars govern how the system adjusts term and class level fees when a student withdraws or drops a class. The system uses the number of days that a term or class has been in session or the class attendance percentage to determine the percentage of refund due. The system calculates these figures using date and time stamps located in the STDNT_ENRL table. State government, an agency, the federal government, or your institution can mandate refund schedules. The pro rata refund is applied to first-time students who withdraw. Federal regulations require you to use the refund table that is best for the student.

The logic for term fee calculations and adjustments for each student is:

  • The student enrollment record contains all the add and drop transactions. When a student adds or drops a class, the Tuition Calculation process records various fields from the enrolment records in a temporary table. The temporary table references the add and drop dates as the transaction date.

  • When a student drops a class, the Tuition Calculation process calculates the drop costs by comparing the amount before the drop to the amount after the drop. Tuition Calculation then applies the appropriate adjustment calendar percentage.

Page Name

Definition Name

Navigation

Usage

Adjustment Calendars

ADJ_TERM_TABLE

select Set Up SACR, then select Product Related, then select Student Financials, then select Tuition and Fees, then select Adjustment Calendars

Define adjustment calendars.

Administrative Fee Setup

ADMIN_FEE_SP

Click the Administrative Fee Setup link on the Adjustment Calendars page.

Define administrative fee for adjustment periods.

Access the Adjustment Calendars page (select Set Up SACR, then select Product Related, then select Student Financials, then select Tuition and Fees, then select Adjustment Calendars).

Image: Adjustment Calendars page

This example illustrates the fields and controls on the Adjustment Calendars page. You can find definitions for the fields and controls later on this page.

Adjustment Calendars page

Note: Most types of financial aid have specific fee adjustment requirements. Consult your financial aid staff to determine adjustment calendar requirements.

Field or Control

Definition

Description

Enter a description to identify this adjustment calendar.

Adjustment Option

Select the adjustment option for this adjustment calendar. Values are:

By Census Date:Select to adjust fees based on the census date. Use only for Higher Education Contribution Scheme (HECS) calculation. This adjustment option is not available for term fees.

By Class Length % (by class length percentage): Select to adjust fees based on the number of days that have passed out of the total number of class days scheduled. For example, if a class is scheduled to run for 13 weeks, and a student drops the class at the end of the second week, the student would have attended slightly over 15 percent of the class length.

By Class Meeting % (by class meeting percentage): Select to adjust fees based on the number of class meetings attended out of the total number of scheduled class meetings.

By Class Meetings Select to adjust fees based on the number of class meetings attended regardless of the total number of meetings scheduled.

By Class Start Date: Select to adjust fees based on the number of days that have passed from the class start date.

By Session Start Date: Select to adjust fees based on the number of days that have passed from the first day of the session.

By Term Start Date: Select to adjust fees based on the number of days that have passed from the first day of the term.

Adjust Reason (adjustment reason)

Select the adjustment reason code. You might adjust fees differently depending on the reason that the student drops or withdraws. For example, you might give a full refund to a student who has to drop for reasons beyond his control. The adjust reason is a short explanation of the difference.

Note: If you want to select an adjustment reason for a term withdrawal, you must first select the Term Withdrawal check box.

Term Withdrawal

Select if this adjustment code is to be used for term withdrawal. Do not select this check box if the adjust reason is for dropped classes.

Copy Adjustment Calendar

Click to copy an adjustment calendar from one term to another.

Set Default

Select to designate an adjust reason as the default reason for both term withdrawal and dropping a class. Both term withdrawal and class drop must have one adjustment calendar defined as the default.

Term and Session

Enter the appropriate term and session information for each adjust reason.

Day From and To

If you select the adjustment options By Class Start Date, By Term Start Date, or By Session Start Date, enter the beginning (Day From) and ending point (Day To) of the time period. For both of these fields, express the number of days before the start date defined in the Adjustment Option field as a negative number.

For example, if you want a student to receive a full refund from any time before the start of a term to the day before the start of a term, enter –9999 in the From Day field and –1 in the To Day field.

Percent From and To

If you select the adjustment options By Class Length % or By Class Meeting %, enter a beginning (Percent From) and ending point (Percent To) of the range. Percent values cannot be expressed as negative numbers.

For example, if you want students to receive a full refund if they drop any time before attending at least 10 percent of the class, enter 0% in the Percent From field and 9.999% in the Percent To field.

Meeting From and Meeting To

If you select the adjustment option By Class Meetings, enter a beginning (Meeting From) and ending (Meeting To) class session.

For example, if you want students to receive a full refund if they drop any time before attending the third class session, enter 0 in the Meeting From field and 2 in the Meeting To field.

Refund Percent

Enter the percent of fees charged that you want the student to receive as a refund.

Administrative Fee Setup

Click to define any administrative fees that are associated with the adjustment period.

Note: Administrative fees for withdrawal can be defined for each refund range row. You can set up an administrative fee for cancellation only on the first row and only if the refund percent is 100 percent.

Access the Administrative Fee Setup page (click the Administrative Fee Setup link on the Adjustment Calendars page).

Image: Administrative Fee Setup page

This example illustrates the fields and controls on the Administrative Fee Setup page. You can find definitions for the fields and controls later on this page.

Administrative Fee Setup page

Field or Control

Definition

Due Date Code

Select the due date code (billing and due calendar) that you want to use for the administrative fee.

Withdrawal Group Box

Field or Control

Definition

Flat Fee

If you want to charge a student a specific amount for withdrawing from school or for canceling enrollment in classes, enter the amount in the Flat Fee fields. This option can be used alone or in conjunction with a percentage fee.

Percentage

If you want to charge students a percentage of their tuition and fees when they withdraw from school, enter that percentage in this field. This option can be used alone or in conjunction with a flat fee. This option applies to withdrawal only.

Maximum Amount

If you want to put a limit on the total administrative fees that can be charged to students who withdraw from school, enter a maximum amount in this field. This option applies to withdrawal only.

Account Type

Select an account type for the administrative fee.

Item Type

Select the item type that you have set up for administrative fee charges.

Cancellation

Field or Control

Definition

Flat Fee

If you want to charge a student a specific amount for withdrawing from school or for canceling enrollment in classes, enter the amount in the Flat Fee fields. This option can be used alone or in conjunction with a percentage fee.

Account Type

Select an account type for the administrative fee.

Item Type

Select the item type that you have set up for administrative fee charges.

The following scenarios describe how the system calculates the term fees after a student initially enrolls in four classes and then:

  • Drops one class.

  • Adds an additional class.

  • Drops two classes on the same day, with the same reason.

  • Drops two classes on the same day, with two different reasons.

The term fee is assessed through an equation and is charged by term and adjusted by term. Refer to the section Using Equation Engine to Define Tuition Calculation Equations to see the sample equation, SFTDTFTRMTRM (Charge by Term, Adjust by Term).

Scenario 1: On January 1, 2007 the student enrolled in four classes at 100 per unit. Each class is three billing units; therefore, the total billing units equals 12 and the total amount equals 1200.00 USD, as shown in the following examples:

Class_nbr

Stdnt_enrl_status

Enrl_add_dt

Trans_date

Enrol_actn_rsn_last

1001

E

01/01/2007

N/A

N/A

1022

E

01/01/2007

N/A

N/A

1003

E

01/01/2007

N/A

N/A

1004

E

0/01/2007

N/A

N/A

The following table lists the transaction in the Tuition Calculation temporary table after initial enrollment:

Transaction Date

Amount

Difference

Drop Date

Reason

Refund %

Drop Cost

01/01/2007

1200.00

N/A

N/A

N/A

/AN

N/A

Student Balance is 1200.00

Scenario 2: On January 1, 2007 the student initially enrolled in four classes. Then on January 2, 2007 the student drops one class:

Class_nbr

Stdnt_enrl_status

Enrl_add_dt

Trans_date

Enrol_actn_reason_last

1001

D

01/01/2007

01/02/2007

SDRP

1002

E

01/01/2007

N/A

N/A

1003

E

01/01/2007

N/A

N/A

1004

E

01/01/2007

N/A

N/A

The following table lists the transactions in the Tuition Calculation temporary table after initial enrollment and dropping one class:

Transaction Date

Amount

Difference

Drop Date

Reason

Refund %

Drop Cost

01/0/2007

1200.00

N/A

N/A

N/A

N/A

N/A

01/02/2007

900.00

300.00

01/02/2007

SDRP

80%

300* (100% — 80%) = 60

Student balance: 900.00 + 60.00 = 960.00

Scenario 3: On January 3, 2007 the student initially enrolled in four classes. On January 2, 2007 the student dropped a class and then on January 3, 2007 the student adds an additional class:

Class_nbr

Stdnt_enrl_status

Enrl_add_dt

Trans_date

Enrol_actn_ran_last

1011

D

01/01/2007

01/02/2007

SDRP

1002

E

01/01/2007

N/A

N/A

1003

E

01/01/2007

N/A

N/A

1004

E

01/01/2007

N/A

N/A

1005

E

01/03/2007

N/A

N/A

The following table lists the transactions in the Tuition Calculation temporary table after initial enrollment and dropping one class and adding one class:

Transaction Date

Amount

Difference

Drop Date

Reason

Refund %

Drop Cost

01/0/2007

1200.00

N/A

N/A

N/A

N/A

N/A

01/02/2007

900.00

300.00

01/02/2007

SDRP

80%

300* (100% — 80%) = 60

01/03/2007

1200.00

N/A

N/A

N/A

N/A

N/A

Note: In this example, the drop cost of 1200.00 on January 3, 2007 is not calculated on an added class.

Student balance: 1200.00 + 60.00 = 1260

Scenario 4; On January 1, 2007 the student initially enrolled in four classes. Then on January 2, 2007 the student drops two classes with the same reason, on the same day.

Class_nbr

Stdnt_enrl_status

Enrl_add_dt

Trans_date

Enrol_actn_ran_last

1011

D

01/01/2007

01/02/2007

SDRP

1002

D

01/01/2007

01/02/2007

SDRP

1003

E

01/01/2007

N/A

N/A

1004

E

01/01/2007

N/A

N/A

The following table lists the transactions in the Tuition Calculation temporary table after the initial enrollment and dropping of two classes with the same reason, on the same day.

Transaction Date

Amount

Difference

Drop Date

Reason

Refund %

Drop Cost

01/0/2007

1200.00

N/A

N/A

N/A

N/A

N/A

01/02/2007

900.00

600.00

01/02/2007

SDRP

80%

600 (100% — 80%) = 120.00

Student balance: 600.00 + 120.00 = 720.00

Scenario 5: On January 1, 2007 the student initially enrolled in four classes. Then on January 2, 2007 the student drops two classes with two different reasons:

Class_nbr

Stdnt_enrl_status

Enrl_add_dt

Trans_date

Enrol_actn_ran_last

1011

D

01/01/2007

01/02/2007

SDRP

1002

D

01/01/2007

01/02/2007

CANC

1003

E

01/01/2007

N/A

N/A

1004

E

01/01/2007

N/A

N/A

The following table lists the transactions in the Tuition Calculation temporary table after the initial enrollment and dropping of two classes with two different reasons, on the same day.

Transaction Date

Amount

Difference

Drop Date

Reason

Refund %

Drop Cost

01/0/2007

1200.00

N/A

N/A

N/A

N/A

N/A

01/02/2007

900.00*

300.00

01/02/2007

CANC

90%

300* (100% — 90%) = 30.00

01/02/2007

600.00

300.00

01/02/2007

SDRP

80%

$600 (100% — 80%) = 60.00

Student Balance: 600.00 + 30.00 + 60.00 = 690.00

When a student drops two classes with two different reasons on the same day, the temporary table is inserted alphabetically by reason and each class is calculated separately. The first amount is calculated by only noting that one class has been canceled. The second amount is calculated by using the second class that has been dropped by the student.

If the adjustment calendar is by session start date, the session code is taken into account similarly to the reason.

During withdrawal processing, the student's enrollment record, for enrolled classes, will have the drop date equal the last attendance date. Therefore, the transaction date will be the last attendance date.