Skip to main content
Skip table of contents

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 NameInitial VersionData TypeDescription
Charge_Tax23.6.0Number(1)For future use by PowerSchool

Course_Name

3.7.0

Varchar(79)

The name of the course, associated with this record.

Course_Number

3.7.0

Varchar(11)

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.





JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.