PowerSchool SIS Illinois

S_IL_STU_ConEnr_C (ver 17.7.0)

This table is a child of the [Students] table. These fields enable concurrent enrollments for Illinois students.

Column Name

Version

Data Type

Description

ID

17.7.0

Number(10,0)

ID field of the extension table.

StudentsDCID

17.7.0

Number(10,0)

Primary key that relates the extended table back to the Students table. 

Enrollment_Entry_Type_Code

17.7.0

Varchar2(2)

Enrollment code of this concurrent enrollment.

EnrollmentType

17.7.0

Varchar2(2)

Enrollment type of this concurrent enrollment.

EntryCode

17.7.0

Varchar2(10)

Entry code of this concurrent enrollment.

EntryComment

17.7.0

Varchar2(1000)

Entry comment of this concurrent enrollment.

EntryDate

17.7.0

Date

Entry date of this concurrent enrollment.

ExitCode

17.7.0

Varchar2(10)

Exit code of this concurrent enrollment.

ExitComment

17.7.0

Varchar2(1000)

Exit comment of this concurrent enrollment.

ExitDate

17.7.0

Date

Exit date of this concurrent enrollment.

FTE

17.7.0

Number(25,10)

FTE of this concurrent enrollment.

FTEID

17.7.0

Number(11,0)

FTE ID (type) of this concurrent enrollment.

Grade_Level

17.7.0

Number(11,0)

Grade level of this concurrent enrollment.

MembershipShare

17.7.0

Number(25,10)

Membership share of this concurrent enrollment.

RCDTS_Home_School

17.7.0

Varchar2(15)

The RCDTS of the home school for this concurrent enrollment.

RCDTS_Service_Provider

17.7.0

Varchar2(15)

The RCDTS of the service for this concurrent enrollment.

RCDTS_Serving_School

17.7.0

Varchar2(15)

The RCDTS of the serving school for this concurrent enrollment.

SchoolID

17.7.0

Number(10,0)

School of this concurrent enrollment.

State_ExcludeEnrollment

17.7.0

Number(1,0)

Exclude this enrollment from state reporting.

Enrollment_Exit_Status

17.9.0

Varchar2(2)

The exit status of the concurrent enrollment.

Enrollment_Exit_Type_Code

17.9.0

Varchar2(2)

The enrollment exit type code of the concurrent enrollment.

EnrollmentID

19.7.1.0

Number(11,0)

The enrollment to which the entry corresponds.

Exclude_Attendance

19.7.1.0

Number(1,0)

Exclude attendance from IL attendance reporting at the Concurrent Enrollment level