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 |