Skip to main content
Skip table of contents

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_Minutes14.10.0Number(11,0)The number of minutes this section meets on a daily basis.
Course_Name14.10.0Varchar2(100)The name of the course the student is taking at another LEA.
Course_Number14.10.0Varchar2(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_ID14.10.0Number(11,0The 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_TermID14.10.0Number(11,0)The term id for the section at the destination school. 
DEST_TermName14.10.0Varchar2(100)The name of the term for the section at the destination school.
EntryDate14.10.0DateNot currently used.
ExitDate14.10.0DateNot currently used.
Expression14.10.0Varchar2(50)The expression on the section at the destination school. 
ID14.10.0Number(19,0)Primary Key
Reserved114.10.0Varchar2(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.
Reserved214.10.0Varchar2(50)Stores the email address for the person at the home school that can be contacted about this request.
Reserved314.10.0Varchar2(50)
Reserved414.10.0Varchar2(50)
Reserved514.10.0Varchar2(50)

Section_Entry_Date

13.6.0

Date

The date the student requested enrollment in this section.

Section_Number14.10.0Varchar2(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_ID14.10.0Number(11,0)This is the school id for the student's home school.
State_Course_Number14.10.0Varchar2(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_Name14.10.0Varchar2(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.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.