PSSIS_Student_Enrollments (ver5.0.0)
This view provides enrollment information related to Students. This will essentially be a union of the information from the Students and ReEnrollments tables.
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. |
Current_Enroll_Stat us | 5.0.0 | String15 | [From Students] Enrollment status as a sting value (e.g., 'Inactive', 'Pre- registered', 'Active', etc.). Indexed. |
EnrollmentCode | 5.0.0 | Longint | [From Students custom field] The student's Primary Language as decoded in the CustomVarchars table. |
EnrollmentType | 5.0.0 | String2 | [From Students] This is used to specify what type of enrollment the student has at this school. Currently, it is only used in AZ: M=Main A=Ancillary |
Full_Time_Equivalency | 5.0.0 | String80 | [From Students] The internal number for the FTE with which this record is associated. Indexed. |
Enrollment_Transfer_Date_Pend | 5.0.0 | Date | [From Students] Date of the Pending transfer of the student from the school. If 00/00/00 then immediate transfer. |
Enrollment_Transfer_Info | 5.0.0 | Varbinary2048 | [From Students] Blob containing one or more comments regarding this transfer. |
Entry_Code | 5.0.0 | String20 | [From Students] The code representing how or why the student entered school. These codes are stored in Gen Table [6] cat=entrycodes. These are set in school setup. |
Entry_Reason | 5.0.0 | String2048 | [From Gen] The textual value associated with this student's 'entrycode'. |
Entry_Date | 5.0.0 | Date | [From Students] The date the student enrolled in school for the current enrollment. Indexed. |
Exit_Code | 5.0.0 | String20 | [From Students] The code representing how or why the student exited the school. These codes are stored in Gen Table [6] cat=exitcodes. These are set in school setup. |
Exit_Reason | 5.0.0 | String2048 | [From Gen] The textual value associated with this student's 'exitcode'. |
Exit_Comment | 5.0.0 | String2048 | [From Students] Any comments for the student exiting this school. |
Exit_Date | 5.0.0 | Date | [From Students] The date the student exited for the current/last enrollment. This is the day after a student-attended class. For example, if the last day the student is in school is a Wednesday, Thursday is the exit day. Indexed. |
Graduated_Rank | 5.0.0 | Longint | [From Students] Class rank upon the time of graduation. |
Graduated_SchoolName | 5.0.0 | String60 | [From Students] Stores the name of the school the student graduated from so the user can search for him or her in the Graduated Students school. |
Log_Notes | 5.0.0 | String2048 | [From Students] Place to write notes about transferring students. |
Transfer_Comments | 5.0.0 | String2048 | [From Students] A text field for the school administrator to write a note about the reason a student is being transferred. |
Withdrawal_Reason | 5.0.0 | String2048 | [From Students] Reason code provided when a student withdraws from school. |
Lunch_Portion_to_Pay | 5.0.0 | String11 | [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. |
MembershipShare | 5.0.0 | Real | [From Students] The amount of a student's membership this school claims. If a student attends more than one school each one will only be able to claim a certain portion of the membership. |
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. |
Track | 5.0.0 | String20 | [From Students] A-H or blank. This represents the times of year a student goes to school. This is most common with year-round schools. |