S_CA_REN_X (ver. 15.4.0)
This table is an extension of the ReEnrollments table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ReenrollmentsDCID | 15.4.0 | Number(10,0) | Primary key that relates the extended table to the Reenrollments table. |
| DirCertMethod | 17.9.0 | Varchar2(1) | Direct Certification Method for free or reduced lunch. |
| EnrollmentStatus | 16.3.0 | Varchar2(2) | Student enrollment status. Migrated from [ReEnrollments.CA_EnrollmentStatus]. |
| ExcludeFromADA | 16.3.0 | Number(1,0) | Exclude enrollment from ADA reporting. Migrated from [ReEnrollments.CA_ExcludeFromADA]. |
| FirstCASchooling | 17.4.0 | Date | Student initial CA School Enrollment Date, used for immunization requirements. |
| GradeLevelOverride | 16.3.0 | Varchar2(3) | Grade level override. Migrated from [ReEnrollments.CA_GradeLevelOverride]. Updated from 2 characters to 3 characters in version 20.5.2.0. |
InterdistrictTransfer | 15.4.0 | Number(11,0) | CALPADS Student School Transfer Code (1.31), copied from Students table upon creation of Reenrollments record. Migrated from [ReEnrollments.InterdistrictTransfer]. |
| NameSuffix | 16.3.0 | Varchar2(5) | Student name suffix. |
| NPS_CDS_SchoolCode | 16.3.0 | Varchar2(7) | Related seven-digit school code for NPS/CDS school. Migrated from [ReEnrollments.CA_NPS_CDS_SchoolCode]. |
| ReceiverSchool | 16.3.0 | Varchar2(7) | Related seven-digit school code for receiving school when student exits. Migrated from [ReEnrollments.CA_ReceiverSchool]. |
| SchoolCompletionStatus | 16.3.0 | Varchar2(3) | School completion status. Migrated from [ReEnrollments.CA_SchoolCompletionStatus]. |
| SchoolEntryDate | 16.3.0 | Date | School entry date. Migrated from [ReEnrollments.CA_SchoolEntryDate]. |
| SpEdGradeLevel | 16.3.0 | Varchar2(2) | Special Education grade level. Migrated from [ReEnrollments.CA_SpEdGradeLevel]. |
| STASExemptionIndicator | 18.5.0 | Number(1,0) | Exempt enrollment from STAS and Student Absenteeism report. |
| State_ExcludeEnrollment | 16.3.0 | Number(1,0) | Exclude enrollment from state reporting. Migrated from [ReEnrollments.state_excludeenrollment]. |