PSSIS_Student_Fees (ver5.0.0)
This view provides Fee information related to Students. Much of this information is aggregated from the Fee table.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Name | 5.0.0 | String35 | [From Students] The Student Last Name, First Name. Indexed. |
Student_Number | 5.0.0 | Real | [From Students] The unique Student identifier. Indexed. |
Current_School_Abbreviation | 5.0.0 | String20 | [From Schools] The Current School's abbreviation. |
Grade | 5.0.0 | Longint | [From Students] The Student's current grade level. Indexed. |
Mother_Name | 5.0.0 | String60 | [From Students] The Students Mother's name. |
Father_Name | 5.0.0 | String60 | [From Students] The Students Father's name. |
Physical_Address | 5.0.0 | String125 | [Derived] Concatenation of Street, City, State and Zip code. |
Home_Phone | 5.0.0 | String30 | [From Students] Home phone number for the student. Indexed. |
LastMeal | 5.0.0 | String20 | [From Students] Stores the date of last lunch purchase. |
Lunch_Portion_to_Pay | 5.0.0 | String3 | [From Students] Represents the portion of lunch a student must pay for: Blank=No status P=Full pay R=Reduced F=Free E=Exempt T=Temporary FDC=Free-DC. |
Lunch_ID | 5.0.0 | Real | [From Students] The students PowerLunch number. Indexed. |
TuitionPayer | 5.0.0 | String16 | [From Students] This is an integer code used to represent the tuition status of a student. For AZ: 1=State-funded 2=Privately paid or no tuition |
Fee_Type_Name | 5.0.0 | String79 | The Name field from the Fee_Type table. |
Fee_Category_Name | 5.0.0 | String21 | The name of the Fee Category associated with the fee. |
Description | 5.0.0 | String79 | User defined description for this Fee. |
Creation_Date | 5.0.0 | Date | The date the fee was created. |
Original_Fee_Amount | 5.0.0 | Real | The original Fee_Amount. Does not change if the fee is pro-rated. |
Prorated_Fee_Amount | 5.0.0 | Real | Taken from the School_Fee Pro Ratable record associated with this fee. |
Fee_Balance | 5.0.0 | Real | The balance due on the fee. |
Fee_Paid | 5.0.0 | Real | The current amount that has been paid toward the Fee_Amount. |
Fee_Term | 5.0.0 | String6 | The internal number for the Term with which this record is associated. |
Fee_Year | 5.0.0 | String6 | 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. |
Family_Original_Fee_Amount | 5.0.0 | Real | Sum of the Original Fee Amount owed by this Student's family. |
Family_Prorated_Fee_Amount | 5.0.0 | Longint | Sum of the Prorated Fee Amount owed by this Student's family. |
Family_Fee_Paid | 5.0.0 | Real | Sum of the Fee_Paid owed by this Student's family. |
Family_Fee_Balance | 5.0.0 | Real | Sum of the Fee_Balance owed by this Student's family. |