Fees, 54 (ver3.6.1)
The actual fee transactions assessed to a student.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Cash | 3.6.1 | Float | The amount of actual currency coming into the account. |
Course_Number | 3.6.1 | Varchar(20) | The course number attached to a course fee. |
Credit | 3.6.1 | Float | The transaction is money going into the students account. |
Date_Value | 3.6.1 | Date | The date this record is stored. Indexed. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Debit | 3.6.1 | Float | The transaction is money going out of the students account. |
Description | 3.6.1 | CLOB | The description of the transaction. |
EnteredBy | 3.6.1 | Number(10,0) | The userID the record was entered by. |
FeesType | 3.6.1 | Varchar(20) | The category entered by the user with which they want this to be associated. Indexed. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
NetEffect | 3.6.1 | Float | The effect this transaction has on the balance. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Time | 3.6.1 | Number(10,0) | The time the record was stored. |
YearID | 3.7.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. |