SchoolFee, 145 (ver3.7.0)
Used to create new fees such as Course or School. For example, algebra 1 has a textbook fee of $10.00 and a Materials fee of $15.00. This would result in 2 rows in this table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| Charge_Tax | 23.6.0 | Number(1) | For future use by PowerSchool |
Course_Name | 3.7.0 | Varchar(100) | The name of the course, associated with this record. |
Course_Number | 3.7.0 | Varchar(20) | The course number associated with this record. Indexed. |
Creationdate | 3.7.0 | Date | The date this record was created. |
Custom | 3.7.0 | CLOB | Holds school fee-related custom fields. |
Date | 3.7.0 | Date | The date this record was created. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DepartmentID | 3.7.0 | Number(10,0) | The internal number for the department with which this record is associated. |
Department_Name | 3.7.0 | Varchar(79) | The user-entered table Department column Name |
Description | 3.7.0 | CLOB | A user-defined description of this School Fee. |
Fee_Amount | 3.7.0 | Float | The user-entered amount of this School Fee. |
Fee_Category_Name | 3.7.0 | Varchar(21) | Default values SCHOOL and COURSE. User-entered Name for this record. Indexed. |
Fee_Type_Description | 3.7.0 | CLOB | A user-defined description of this record. |
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) | Taken from the FEE_TYPE Name record associated with this FEE. Indexed. |
Fee_Type_Priority | 3.7.0 | Number(10,0) | Taken from the FEE_TYPE Priority record associated with this FEE. |
ID | 3.7.0 | Number(10,0) | Sequential number generated by the application. Indexed. |
ModificationDate | 3.7.0 | Date | The last date the record was modified. |
Pro_Ratable | 3.7.0 | Number(10,0) | Indicates whether or not this Fee can be prorated. |
SchoolID | 3.7.0 | Number(10,0) | The School_Number of the associated Schools record. |
School_Fee_Prorate_Period | 3.7.0 | Varchar(11) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Unused1 | 3.7.0 | Number(10,0) | Currently unused field. |
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. |