S_NC_CROSSLEA_REENROLLMENTS (ver 15.2.3)
This table is a stand alone table used to store information about student re-enrollments at other LEAs in the state.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| DistrictOfResidence | 15.2.3 | Varchar2(20) | The district in which the student resides. |
| EnrollmentCode | 15.2.3 | Number(11,0) | This field is not used. |
| EnrollmentType | 15.2.3 | Varchar2(2) | This identifies the status of the enrollment record. |
| EntryCode | 15.2.3 | Varchar2(20) | The entry code for the cross LEA enrolled student. |
| EntryComment | 15.2.3 | Clob | Comment for entry. |
| EntryDate | 15.2.3 | Date | The date the student was cross LEA enrolled in the school. |
| ExitCode | 15.2.3 | Varchar2(20) | The exit code for the student's exit from the cross LEA enrollment. |
| ExitComment | 15.2.3 | Clob | Comment for exit. |
| ExitDate | 15.2.3 | Date | The date the student was exited from the cross LEA enrollment. |
| FTEID | 15.2.3 | Number(11,0) | The id of the FTE for the student's enrollment. This is not a required field. |
| Grade_Level | 15.2.3 | Number(11,0) | The grade level of the student at the time of the enrollment. |
| ID | 15.2.3 | Number(19,0) | Primary key |
| LunchStatus | 15.2.3 | Varchar2(11) | Identifies the student's lunch status. Not currently populated. |
| MembershipShare | 15.2.3 | Number(25,10) | Identifies the membership value for this student. Not currently populated. |
| SchoolID | 15.2.3 | Number(11,0) | The number of the school where the student is from. |
| StudentID | 15.2.3 | Number(11,0) | The student number of the student. |
| StudentSchlEnrol_Guid | 15.2.3 | Varchar2(32) | Not currently used. |
| Track | 15.2.3 | Varchar2(20) | The track that the student is on. |
| TuitionPayer | 15.2.3 | Number(11,0) | Indicates if the student pays tuition. Not currently used. |
| Type | 15.2.3 | Number(11,0) | Not currently used. |
| Withdrawal_Reason_Code | 15.2.3 | Varchar2(3) | The code for the student's reason for withdrawal. |