PSSIS_Enrollment_All (ver5.0.0)
This view provides Current Enrollment, Previous Enrollment and Special Program Enrollment information.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
StudentID | 5.0.0 | Longint | [From Students & ReEnrollments] The internal number for the student this record is associated. Indexed. |
SchoolID | 5.0.0 | Longint | [From Students & ReEnrollments] ID Linked to the School_Number from the Schools table. Indexed. |
EntryDate | 5.0.0 | Date | [From Students & ReEnrollments] Entry (enrollment) date into the school. Indexed. |
EntryCode | 5.0.0 | String20 | [From Students & ReEnrollments] Entry (enrollment) code into the school. Indexed. |
ExitDate | 5.0.0 | Date | [From Students & ReEnrollments] Exit date from the school. Indexed. |
ExitCode | 5.0.0 | String20 | [From Students & ReEnrollments] Exit code from the school. Indexed. |
Grade_Level | 5.0.0 | Longint | [From Students & ReEnrollments] The Student's current grade level. |
ProgramID | 5.0.0 | Longint | [From SPEnrollments] The Foreign key to the Program table from SPEnrollments; otherwise –1. |
FTEID | 5.0.0 | Longint | [From Students & ReEnrollments] The FTE ID from the FTE table. Indexed. |
MembershipShare | 5.0.0 | Real | [From Students & ReEnrollments] The amount of a Student's membership this school claims. |
Track | 5.0.0 | String20 | [From Students & ReEnrollments] Represents the calendar days during the year when the Student goes to school. |
Dflt_Att_Mode_Code | 5.0.0 | String13 | [From FTE] Default Attendance Mode Code. Indexed. |
Dflt_Conversion_Mode_Code | 5.0.0 | String11 | [From FTE] Default Conversion Mode Code. Indexed. |
YearId | 5.0.0 | Integer | [From Terms] Current school year for the student. |
ATT_CalcCntPresentAbsent | 5.0.0 | String7 | [From Prefs] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences). |
ATT_IntervalDuration | 5.0.0 | String30 | [From Prefs] The Interval Duration from the Prefs table (ATT_IntervalDuration). |