PSSIS_Membership_Prog (ver5.0.0)
This view provides student membership information for each day that they have an active enrollment on valid in- session school days.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Name | 5.0.0 | String35 | [From PSSIS_Membership_Reg] The Student's last, first name. |
Student_Number | 5.0.0 | Real | [From PSSIS_Membership_Reg] The Student's number. |
Current_Grade_Level | 5.0.0 | Longint | [From PSSIS_Membership_Reg] The Student's current grade level. |
Current_School_Abbreviation | 5.0.0 | String20 | [From PSSIS_Membership_Reg] The School's abbreviation. |
Gender | 5.0.0 | String2 | [From PSSIS_NCLB_Fields] The Student's gender (M, F). |
Ethnicity_Name | 5.0.0 | String50 | [From PSSIS_NCLB_Fields] The Student's Ethnicity Name. |
Ethnicity_Code | 5.0.0 | String20 | [From PSSIS_NCLB_Fields] The Student's Ethnicity Code. |
Special_Ed_Student | 5.0.0 | String3 | [From PSSIS_NCLB_Fields] Flag to show whether or not this Student is a Special Ed Student. |
StudentID | 5.0.0 | Longint | [From Students] The internal number for the student this record is associated. Indexed. |
SchoolID | 5.0.0 | Longint | [From Attendance] ID Linked to the School_Number from the Schools table. Indexed. |
ProgramID | 5.0.0 | Longint | [From SPEnrollments] The Foreign key to the Program table from SPEnrollments; otherwise –1. |
CalendarDate | 5.0.0 | Date | [From Calendar_Day] The date value from Calendar_Day. Indexed. |
StudentMembership | 5.0.0 | Real | [From PSSIS_Membership_Reg] The student membership value from the PS_Enrollment_Reg view. |
CalendarMembership | 5.0.0 | Real | [From Calendar_Day] The student's Calendar membership value. |
Track | 5.0.0 | String20 | [From PSSIS_Membership_Reg] Represents the calendar days during the year when the Student goes to school. |
FTEID | 5.0.0 | Longint | [From Students & ReEnrollments] The FTE ID from the FTE table. Indexed. |
Attendance_Conversion_ID | 5.0.0 | Longint | [From Bell_Schedule] Foreign key to the Attendance Conversion table. Indexed. |
Dflt_Att_Mode_Code | 5.0.0 | String13 | [From PSSIS_Membership_Reg] Default Attendance Mode Code. Indexed. |
Dflt_Conversion_Mode_Code | 5.0.0 | String11 | [From PSSIS_Membership_Reg] Default Conversion Mode Code. Indexed. |
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). |