Fee Type Form
Field reference for fee type definitions.
Fee Type Fields
| Field | Type | Required | Max Length | Validation | Notes |
|---|---|---|---|---|---|
| Fee Type ID | Integer | Auto | - | - | System-generated identifier |
| Fee Code | Text | Yes | 30 | Unique | Fee type code |
| Name | Text | Yes | 200 | - | Display name |
| Description | Text Area | No | 500 | - | Fee description |
| Is Tuition | Boolean | No | - | - | Counted as tuition (for reporting) |
| Is Refundable | Boolean | No | - | - | Subject to refund schedule |
| GL Account Code | Text | No | 50 | - | General ledger account |
| Is Active | Boolean | No | - | - | Fee type is available |
Common Fee Types
| Code | Name | Is Tuition | Is Refundable |
|---|---|---|---|
| TUITION | Tuition | Yes | Yes |
| REG_FEE | Registration Fee | No | Partial |
| TECH_FEE | Technology Fee | No | Yes |
| ACTIVITY | Student Activity Fee | No | No |
| LAB_FEE | Lab Fee | No | Yes |
| PARKING | Parking Fee | No | No |
| HEALTH | Health Services Fee | No | No |
Term Fee (Applied to Term)
| Field | Type | Required | Validation | Notes |
|---|---|---|---|---|
| Term Fee ID | Integer | Auto | - | System-generated |
| Term | Select (FK) | Yes | Must exist | Which term |
| Fee Type | Select (FK) | Yes | Must exist | Fee category |
| Fee Name | Text | Yes | 200 | Display name for this instance |
| Description | Text Area | No | 500 | Description |
| Calculation Type | Select | Yes | See below | How fee is calculated |
| Is Universal | Boolean | No | - | Same for all students |
| Flat Amount | Decimal | Conditional | 10,2 | If flat calculation |
| Currency | Select (FK) | Yes | Must exist | Currency |
| Sort Order | Integer | No | - | Display order |
| Is Active | Boolean | No | - | Fee is applied |
| Effective Date | Date | Yes | Valid date | When fee starts |
| End Date | Date | No | >= Effective | When fee ends |
Calculation Type Values
| Code | Description | Requires |
|---|---|---|
| FLAT | Flat Amount | Flat Amount field |
| BANDED | Credit-Based Bands | Band definitions |
Term Fee Band (for BANDED calculation)
| Field | Type | Required | Notes |
|---|---|---|---|
| Band ID | Integer | Auto | System-generated |
| Term Fee | Select (FK) | Yes | Parent fee |
| Band Name | Text | Yes | Band description |
| Min Credits | Decimal | Yes | Band minimum |
| Min Inclusive | Boolean | No | Include min in range |
| Max Credits | Decimal | No | Band maximum |
| Max Inclusive | Boolean | No | Include max in range |
| Amount | Decimal | Yes | Fee amount |
| Sort Order | Integer | No | Display order |
Term Fee Category (for non-universal fees)
When Is Universal = false, fees vary by student population:
| Field | Type | Required | Notes |
|---|---|---|---|
| Category ID | Integer | Auto | System-generated |
| Term Fee | Select (FK) | Yes | Parent fee |
| Degree Level | Select (FK) | No | Undergraduate, Graduate |
| Student Type | Select (Lookup) | No | New, Continuing, Transfer |
| Campus | Select (FK) | No | Specific campus |
| Student List | Select (FK) | No | Specific student population |
| Amount | Decimal | Yes | Fee amount |
| Priority | Integer | Yes | Lower = higher priority |
| Effective Date | Date | Yes | When starts |
| End Date | Date | No | When ends |
Validation Rules
- Fee Code must be unique
- Flat Amount required when Calculation Type = FLAT
- Bands required when Calculation Type = BANDED
- Categories required when Is Universal = false
- Band ranges should not overlap
Related Screens
- Billing Methods - Tuition calculation
- Payment Plans - Payment options