S_AZ_STU_CONENR_C (ver 15.8.0)
This table is a child of the [Students] table. These fields enable concurrent enrollments for Arizona students.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.8.0 | Number(10,0) | ID field of the extension table. |
STUDENTSDCID | 15.8.0 | Number(10,0) | Primary key that relates the extended table back to the Students table. |
SCHOOLID | 15.8.0 | Number(10,0) | School of this concurrent enrollment. |
ENTRYDATE | 15.8.0 | Date | Entry date of this concurrent enrollment. |
ENTRYCODE | 15.8.0 | Varchar2(10) | Entry code of this concurrent enrollment. |
ENTRYCOMMENT | 15.8.0 | Varchar2(1000) | Entry comment of this concurrent enrollment. |
EXITDATE | 15.8.0 | Date | Exit date of this concurrent enrollment. |
EXITCODE | 15.8.0 | Varchar2(10) | Exit code of this concurrent enrollment. |
EXITCOMMENT | 15.8.0 | Varchar2(1000) | Exit comment of this concurrent enrollment. |
FTEID | 15.8.0 | Number(11,0) | FTE of this concurrent enrollment. |
GRADE_LEVEL | 15.8.0 | Number(11,0) | Grade level of this concurrent enrollment. |
TRACK | 15.8.0 | Varchar2(20) | Track of this concurrent enrollment. |
DISTRICTOFRESIDENCE | 15.8.0 | Varchar2(20) | District of residence of this concurrent enrollment. |
TUITIONPAYER | 15.8.0 | Number(11,0) | Tuition payer of this concurrent enrollment. |
ENROLLMENTCODE | 15.8.0 | Number(11,0) | Enrollment code of this concurrent enrollment. |
ENROLLMENTTYPE | 15.8.0 | Varchar2(2) | Enrollment type of this concurrent enrollment. |
WITHDRAWALREASON | 15.8.0 | Varchar2(3) | Withdrawal reason of this concurrent enrollment. |
PREVIOUSLEA | 15.8.0 | Varchar2(80) | Previous LEA of this concurrent enrollment. |
MEMBERSHIPSHARE | 15.8.0 | Number(25,10) | Membership share of this concurrent enrollment. |
| ENTITYID_OVR | 16.2.0 | Varchar2(10) | EntityID Override for Tuitioned-Out students. |
| JTED_Concurrent_CTDS | 17.12.0 | Varchar2(9) | The County Code-Type Code-District Code-Site Number (CTDS) of the student’s concurrent school. |
| JTED_Indicator | 17.12.0 | Varchar2(1) | Indicates the student should be included in JTED reports. |
| JTED_School_CTDS | 17.12.0 | Varchar2(9) | The County Code-Type Code-District Code-Site Number (CTDS) of the student’s JTED school. |
| JTED_TuitionPayer | 21.6.1 | Number(10,0) | The student's JTED Satellite Tuition Payer |
| UngradedElementary | 21.9.2 | Varchar2(1) | Designates a K aged student receiving Group B SPED services. |