S_NC_CROSSLEAREQUESTS (ver 13.6.0)
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.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| Avg_Minutes | 14.10.0 | Number(11,0) | The number of minutes this section meets on a daily basis. |
| Course_Name | 14.10.0 | Varchar2(100) | The name of the course the student is taking at another LEA. |
| Course_Number | 14.10.0 | Varchar2(50) | The number of the course the student is taking at another LEA. |
DEST_LEA_Code | 13.6.0 | Varchar2(5) | The LEA code where the student is taking the course. |
| DEST_School_ID | 14.10.0 | Number(11,0 | The school code where the student is taking the course. |
DEST_Section_ID | 13.6.0 | Number(11,0) | The internal section id of the section at the destination school. |
| DEST_TermID | 14.10.0 | Number(11,0) | The term id for the section at the destination school. |
| DEST_TermName | 14.10.0 | Varchar2(100) | The name of the term for the section at the destination school. |
| EntryDate | 14.10.0 | Date | Not currently used. |
| ExitDate | 14.10.0 | Date | Not currently used. |
| Expression | 14.10.0 | Varchar2(50) | The expression on the section at the destination school. |
| ID | 14.10.0 | Number(19,0) | Primary Key |
| Reserved1 | 14.10.0 | Varchar2(50) | Stores the GUID that links to the S_NC_CREOSSLEAREQUESTS and S_NC_CROSSLEAENROLLMENTS table and S_NC_STU_CROSSLEAATT_C table for the section information. |
| Reserved2 | 14.10.0 | Varchar2(50) | Stores the email address for the person at the home school that can be contacted about this request. |
| Reserved3 | 14.10.0 | Varchar2(50) | |
| Reserved4 | 14.10.0 | Varchar2(50) | |
| Reserved5 | 14.10.0 | Varchar2(50) | |
Section_Entry_Date | 13.6.0 | Date | The date the student requested enrollment in this section. |
| Section_Number | 14.10.0 | Varchar2(50) | The section number of the section at the destination school. |
Select_Processed | 13.6.0 | Varchar2(1) | 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 | 13.6.0 | Varchar2(5) | This is the LEA code of the student's home school. |
Source_LEA_Host | 13.6.0 | Varchar2(5)0 | This is the PowerSchool URL for the student's home school. |
| Source_School_ID | 14.10.0 | Number(11,0) | This is the school id for the student's home school. |
| State_Course_Number | 14.10.0 | Varchar2(10) | This is the state course number for the section the student is enrolled. |
Stop_Date | 13.6.0 | 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). |
| StudentDCID | Number(19,0) | Foreign key to students table | |
| Teacher_Name | 14.10.0 | Varchar2(50) | This is the teacher name for the section the student is enrolled at the destination school. |
TimeDateStamp | 13.6.0 | Date | Date and time stamp for the enrollment transaction. |