Skip to main content
Skip table of contents

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_Date23.6.0DateFor 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_Note23.6.0Varchar2(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.

Tax23.6.0FloatFor 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.

JavaScript errors detected

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

If this problem persists, please contact our support.