S_CROSSLEA_REENROLLMENTS_S (ver 21.1.2)
This table is a stand alone table used to store information about student re-enrollments at other LEAs in the state. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 21.1.2 | Number(19,0) | Primary Key |
| DISTRICTOFRESIDENCE | 21.1.2 | VARCHAR2(20 CHAR) | The district in which the student resides. |
| ENROLLMENTCODE | 21.1.2 | NUMBER(11,0) | This field is not used. |
| ENROLLMENTTYPE | 21.1.2 | VARCHAR2(2 CHAR) | This identifies the status of the enrollment record. |
| ENTRYCODE | 21.1.2 | VARCHAR2(20 CHAR) | The entry code for the cross LEA enrolled student. |
| ENTRYCOMMENT | 21.1.2 | CLOB | Comment for entry. |
| ENTRYDATE | 21.1.2 | DATE | The date the student was cross LEA enrolled in the school. |
| EXITCODE | 21.1.2 | VARCHAR2(20 CHAR) | The exit code for the student's exit from the cross LEA enrollment. |
| EXITCOMMENT | 21.1.2 | CLOB | Comment for exit. |
| EXITDATE | 21.1.2 | DATE | The date the student was exited from the cross LEA enrollment. |
| FTEID | 21.1.2 | NUMBER(11,0) | The id of the FTE for the student's enrollment. This is not a required field. |
| GRADE_LEVEL | 21.1.2 | NUMBER(11,0) | The grade level of the student at the time of the enrollment. |
| LUNCHSTATUS | 21.1.2 | VARCHAR2(11 CHAR) | Identifies the student's lunch status. Not currently populated. |
| MEMBERSHIPSHARE | 21.1.2 | NUMBER(25,10) | Identifies the membership value for this student. Not currently populated. |
| SCHOOLID | 21.1.2 | NUMBER(11,0) | The number of the school where the student is from. |
| STUDENTID | 21.1.2 | NUMBER(11,0) | The student number of the student. |
| STUDENTSCHLENRL_GUID | 21.1.2 | VARCHAR2(32 CHAR) | Not currently used. |
| TRACK | 21.1.2 | VARCHAR2(20 CHAR) | The track that the student is on. |
| TUITIONPAYER | 21.1.2 | NUMBER(11,0) | Indicates if the student pays tuition. Not currently used. |
| TYPE | 21.1.2 | NUMBER(11,0) | Not currently used. |
| WITHDRAWAL_REASON_CODE | 21.1.2 | VARCHAR2(3 CHAR) | The code for the student's reason for withdrawal. |