S_STU_CROSSLEA_ENROLLMENTS_C (ver 21.1.2)
This table is a child table of the Students table. This table stores the section information at the destination school for students enrolled from another LEA. 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 |
| STUDENTSDCID | 21.1.2 | Number(19,0) | Foreign Key |
| AVG_MINUTES | 21.1.2 | NUMBER(11,0) | The number of minutes this section meets on a daily basis. |
| COURSE_NAME | 21.1.2 | VARCHAR2(100 CHAR) | The name of the course the student is taking at the destination school. |
| COURSE_NUMBER | 21.1.2 | VARCHAR2(50 CHAR) | The number of the course the student is taking at the destination school. |
| DEST_LEA_CODE | 21.1.2 | VARCHAR2(5 CHAR) | The LEA code where the student is taking the course. |
| DEST_SCHOOL_ID | 21.1.2 | NUMBER(11,0) | The School code where the student is taking the course. |
| DEST_SECTION_ID | 21.1.2 | NUMBER(11,0) | The internal section id for the section at the destination school. |
| DEST_TERMID | 21.1.2 | NUMBER(11,0) | The term id for the section at the destination school. |
| DEST_TERMNAME | 21.1.2 | VARCHAR2(100 CHAR) | The name of the term for the section at the destination school. |
| ENTRYDATE | 21.1.2 | Date | The date the student entered the section. |
| EXITDATE | 21.1.2 | Date | The date that the student withdrew or completed the section at the destination school. |
| EXPRESSION | 21.1.2 | VARCHAR2(50 CHAR) | The expression on the section at the destination school. |
| FACILITATOR | 21.4.2 | VARCHAR2(50 CHAR) | Data for Cross LEA for Development use |
| RESERVED1 | 21.1.2 | VARCHAR2(50 CHAR) | Stores the GUID that links to the S_STU_CROSSLEA_REQUESTS_C and S_CROSSLEA_REENROLLMENTS_S table and S_STU_CROSSLEA_ATT_C table for the section information. |
| RESERVED2 | 21.1.2 | VARCHAR2(50 CHAR) | Not currently used. |
| RESERVED3 | 21.1.2 | VARCHAR2(50 CHAR) | Not currently used. |
| RESERVED4 | 21.1.2 | VARCHAR2(50 CHAR) | Not currently used. |
| RESERVED5 | 21.1.2 | VARCHAR2(50 CHAR) | Not currently used. |
| SECTION_ENTRY_DATE | 21.1.2 | DATE | The date the cross LEA record was processed. |
| SECTION_NUMBER | 21.1.2 | VARCHAR2(50 CHAR) | The section number of the section at the destination school. |
| SELECT_PROCESSED | 21.1.2 | VARCHAR2(1 CHAR) | This is a P if the request has been processed and the student is enrolled in the section at the other LEA. This is a D if the request was denied. This is R if the request has not been processed. |
| SOURCE_LEA_CODE | 21.1.2 | VARCHAR2(5 CHAR) | This is the LEA code of the student's home school. |
| SOURCE_LEA_HOST | 21.1.2 | VARCHAR2(50 CHAR) | This is the PowerSchool URL for the student's home school (source). |
| SOURCE_SCHOOL_ID | 21.1.2 | NUMBER(11,0) | This is the school id for the student's home school. |
| STATE_COURSE_NUMBER | 21.1.2 | VARCHAR2(10 CHAR) | This is the state_course_number for the section. |
| STOP_DATE | 21.1.2 | DATE | This is the date that the system should stop trying to enroll the student in another section at another LEA (in case they are on a wait list). |
| Teacher_Name | 21.1.2 | Varchar2(50) | This is the teacher name for the section the student is enrolled at the destination school. |
TimeDateStamp | 21.1.2 | Date | Date and time stamp for the enrollment transaction. |