S_STU_CROSSLEA_REQUESTS_C (ver 21.1.2)
This table is child table of the Students table. This table stores the section information at the source school for students enrolled at 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 another LEA. |
| COURSE_NUMBER | 21.1.2 | VARCHAR2(50 CHAR) | The number of the course the student is taking at another LEA. |
| 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 of 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 | Not currently used. |
| EXITDATE | 21.1.2 | Date | Not currently used. |
| 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) | Stores the email address for the person at the home school that can be contacted about this request. |
| RESERVED3 | 21.1.2 | VARCHAR2(50 CHAR) | |
| RESERVED4 | 21.1.2 | VARCHAR2(50 CHAR) | |
| RESERVED5 | 21.1.2 | VARCHAR2(50 CHAR) | |
| SECTION_ENTRY_DATE | 21.1.2 | DATE | The date the student requested enrollment in this section. |
| 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 record 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_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 the student is enrolled. |
| 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. |