ReEnrollments, 18 (ver3.6.1)
This table stores all enrollments, except the current one, for a student such as the ones for end-of-year (EOY) processing or in-term transfers.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Custom | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DistrictOfResidence | 3.6.1 | Varchar(20) | The district of residence the student was in during this enrollment from student table. This is used for state reports like AZ SAIS. |
EnrollmentCode | 3.6.1 | Number(10,0) | The special enrollment code for state reporting associated with this enrollment record from student table. |
EnrollmentType | 3.6.1 | Varchar(2) | The special enrollment type code for state reporting associated with this enrollment record from student table. |
EntryCode | 3.6.1 | Varchar(20) | The Enrollment code from the student table. |
EntryComment | 3.6.1 | CLOB | The comment for the enrollment from the Student table. |
EntryDate | 3.6.1 | Date | The school enrollment entry date from the student table for EOY it the next schools beginning date. Indexed. |
ExitCode | 3.6.1 | Varchar(20) | The school specified exit code from the student table for EOY or for re-enrollment purposes, such as S=Transfer. |
ExitComment | 3.6.1 | CLOB | The exit comment from the student table as specified for this record. |
ExitDate | 3.6.1 | Date | The school enrollment exit date from the student table. If EOY it's the schools next end-of-year date or effective date for other re-enrollment purposes. Indexed. |
FTEID | 4.0.0 | Number(10,0) | The internal number for the FTE with which this record is associated. Indexed. |
FullTimeEquiv_Obsolete | 4.0.0 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Grade_Level | 3.6.1 | Number(10,0) | The grade level the student was in for this enrollment or if EOY, the next grade level unless the student is being demoted. |
ID | 3.6.1 | Number(10,0) | Except for summer school enrollments, this is the value from Students.EnrollmentID when an enrollment becomes inactive and is transferred to this table. Indexed. |
LunchStatus | 3.6.1 | Varchar(11) | This is the Lunch status copied from the student table. 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 | 3.6.1 | Float | 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. The largest number for this will usually be 1 and fractions expressed as decimals. Like .5 or .25. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
StudentSchlEnrl_GUID | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
Track | 3.6.1 | Varchar(20) | The track the student was in during this enrollment from student table. |
TuitionPayer | 3.6.1 | Number(10,0) | Person who is the tuition payer for the student for this enrollment from the Student table. |
Type | 3.6.1 | Number(10,0) | Type of reenrollment record, 0=re-enrollment record made by system or 1=hand created re-enrollment record. Required. |
Withdrawal_Reason_Code | 4.0.0 | Varchar(3) | Reason code provided when a student withdraws from school. |