S_NC_CROSSLEAENROLLMENTS (ver 13.6.0)
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.
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 the destination school. |
| Course_Number | 14.10.0 | Varchar2(50) | The number of the course the student is taking at the destination school. |
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 for 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 | The date the student entered the section. |
| ExitDate | 14.10.0 | Date | The date that the student withdrew or completed the section at the destination school. |
| 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) | Not currently used. |
| Reserved3 | 14.10.0 | Varchar2(50) | |
| Reserved4 | 14.10.0 | Varchar2(50) | Not currently used. |
| Reserved5 | 14.10.0 | Varchar2(50) | Not currently used. |
Section_Entry_Date | 13.6.0 | Date | The date the cross LEA record was processed. |
| 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 request 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(50) | This is the PowerSchool URL for the student's home school (source). |
| 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. |
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). |
| StudentsDCID | 13.6.0 | Number(19,0) | Foreign key to link to the 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. |