Fee, 146 (ver3.7.0)
Contains information about the Fees charged by school.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Adjustment | Float | Any adjustment necessary to the associated Fee. | |
Course_Name | 3.7.0 | Varchar(100) | The name of the course, such as Algebra. |
Course_Number | 3.7.0 | Varchar(20) | The course number associated with this fee. Indexed. |
CreationDate | 3.7.0 | Date | The date the fee was created. |
Custom | 3.7.0 | CLOB | Holds fee-related custom fields. |
Date_Value | 3.7.0 | Date | The date the FEE record was created. |
Datetime | 3.7.0 | Varchar(15) | The Date and time this record was modified. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Department_Name | 3.7.0 | Varchar(79) | Name or description for this department, such as English, Math. |
Description | 3.7.0 | Varchar(79) | User-defined description for this Fee. |
| Due_Date | 23.6.0 | Date | For future use by PowerSchool. |
Fee_Amount | 3.7.0 | Float | The amount of the fee. If the fee were pro-rated, this would be the pro-rated amount. |
Fee_Balance | 3.7.0 | Float | The balance due on the fee. |
Fee_Category_Name | 3.7.0 | Varchar(21) | The name of the Fee Category associated with the fee. |
FeeCharged | 5.0.7 | Float | The actual Fee charged (including Adjustments), |
Fee_Paid | 3.7.0 | Float | The current amount that has been paid toward the Fee_Amount. |
Fee_Type_ID | 3.7.0 | Number(10,0) | The internal number for the Fee Type with which this record is associated. Indexed. |
Fee_Type_Name | 3.7.0 | Varchar(79) | The Name field from the Fee_Type table. |
Group_Transaction_ID | 3.7.0 | Number(10,0) | An ID given to all transaction records resulting from a group function. All students selected in a Fee group function shall have the same Group Transaction_ID. Indexed. |
ID | 3.7.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Internal_Info_For_Trigger | 3.7.0 | Number(10,0) | This is for internal use or for specific functions: by setting its value to 1, you disable the trigger code that updates the totals for the kid. That is useful when importing data: you can import without changing the totals. |
| Internal_Note | 23.6.0 | Varchar2(4000 char) | For future use by PowerSchool. |
ModificationDate | 3.7.0 | Date | The last date the record was modified. |
OriginalFee | 3.7.0 | Float | The original Fee_Amount. Does not change if the fee is pro-rated. |
Priority | 3.7.0 | Number(10,0) | Taken from the [Fee_Type] Priority record associated with this fee. |
Pro_Rated | 3.7.0 | Number(10,0) | Taken from the School_Fee Pro Ratable record associated with this fee. |
SchoolFee_ID | 3.7.0 | Number(10,0) | The internal number for the SchoolFee with which this record is associated. Indexed. |
SchoolID | 3.7.0 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 3.7.0 | Number(10,0) | The internal number and ID of the associated Students record. |
System_User_ID | 3.7.0 | Number(10,0) | The internal number for the system user with which this record is associated. [DBLOG] UserID. |
| Tax | 23.6.0 | Float | For future use by PowerSchool. |
TeacherID | 3.7.0 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |
TermID | 3.7.0 | Number(10,0) | The internal number for the Term with which this record is associated. |
Time | 3.7.0 | Date | The time the FEE record was created. |
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. Indexed. |