S_AZ_STU_X (ver 14.10.1)
This is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.10.1 | Number(10,0) | Primary Key. |
| ATT_ProcByMin | 15.8.0 | Number(11,0) | Legacy SAIS reporting field. Migrated from [Students.AZ_SAIS_ATT_ProcByMin]. |
| ConcurrentSchoolID | 15.8.0 | Varchar2(9) | The ID of the school the student attends concurrently with (at the same time as) the current school. Migrated from [Students.AZ_SAIS_ConcurrentSchoolID]. |
| ConcurrentStudentID | 15.8.0 | Varchar2(15) | The ID assigned to the student by the concurrent school. Migrated from [Students.AZ_SAIS_ConcurrentStudentID]. |
| CountryBirthCode | 15.8.0 | Varchar2(5) | The student’s country of birth. Migrated from [Students.AZ_SAIS_CountryBirthCode]. |
| EntityID_Ovr | 15.8.0 | Varchar2(10) | Override for Schools EntityId for tuitioned-out students. |
| FirstAcquiredLanguage | 19.2.0 | Varchar(2) | The language that the student first acquired |
| FirstAZSchooling | 17.9.0 | Date | Initial enrollment date in an Arizona school or preschool. |
| ForeignExchangeInd | 15.8.0 | Varchar2(1) | Legacy SAIS reporting field. Migrated from [Students.AZ_SAIS_ForeignExchangeInd]. |
| Gifted | 14.10.1 | Varchar2(1) | Indicates that the student is gifted. |
| HomeLanguageCode | 15.8.0 | Varchar2(5) | The student’s home language. Migrated from [Students.AZ_SAIS_HomeLanguageCode]. |
| JTED_Concurrent_CTDS | 15.8.0 | Varchar2(9) | The County Code-Type Code-District Code-Site Number (CTDS) of the student’s concurrent school. Migrated from [Students.JTED_Concurrent_CTDS]. |
| JTED_Indicator | 15.8.0 | Varchar2(1) | Indicates the student should be included in JTED reports. Migrated from [Students.JTED_Indicator]. |
| JTED_School_CTDS | 15.8.0 | Varchar2(9) | The County Code-Type Code-District Code-Site Number (CTDS) of the student’s JTED school. Migrated from [Students.JTED_School_CTDS]. |
| JTED_TuitionPayer | 21.6.1 | Number(10,0) | The student's JTED Satellite Tuition Payer |
| LastNameBirth | 15.8.0 | Varchar2(75) | The last name the student goes by. This may be the same as Last Name on Legal Document. Migrated from [Students.AZ_SAIS_LastNameBirth]. |
| LEP | 14.10.1 | Varchar2(1) | Indicates that the student is LEP. |
| LEPPrograms | 14.10.1 | Varchar2(1) | Indicates that the student is enrolled in an LEP program. |
| NormalGraduationYear | 15.8.0 | Varchar2(10) | The student’s expected year of graduation. Migrated from [Students.AZ_SAIS_NormalGraduationYear]. |
| OthTribalAffiliation | 19.3.0 | Varchar(250) | The student's tribal affiliation. |
| ParentMilitaryStatus | 16.2.2 | Varchar2(5) | The student's parent in military status. |
| PreviousLEA | 15.8.0 | Varchar2(80) | The name of the district or Charter School the student attended in the previous school year OR the ISEP / Non-ISEP data if applicable. Migrated from [Students.AZ_PreviousLEA]. |
| PreviousSchoolID | 15.8.0 | Varchar2(9) | The CTDS of the school the student previously attended. Migrated from [Students.AZ_SAIS_PreviousSchoolID]. |
| PreviousStateCode | 15.8.0 | Varchar2(5) | The state in which the student previously attended school, if applicable. Migrated from [Students.AZ_SAIS_PreviousStateCode]. |
| PreviousStudentID | 15.8.0 | Varchar2(15) | The student’s identifier, assigned by their previous school, if applicable. Migrated from [Students.AZ_SAIS_PreviousStudentID]. |
| PrvDistSchEntity | 20.4.4.0 | Varchar2(60) | The student's previous District School's Entity Id. |
SpecialEd | 14.10.1 | Varchar2(1) | Indicates that the student is SpecialEd. |
| SpecialEd504Only | 14.10.1 | Varchar2(1) | Is this student SpecialEd 504 only? |
| SpokenLanguage | 19.2.0 | Varchar(2) | Language most often spoken by the student |
| StateBirthCode | 15.8.0 | Varchar2(5) | The student’s state of birth. Migrated from [Students.AZ_SAIS_StateBirthCode]. |
| TribalAffiliation | 19.3.0 | Varchar(25) | The student's tribal affiliation. |
| TribalName | 15.8.0 | Varchar2(20) | The student’s tribal name. Migrated from [Students.AZ_SAIS_TribalName]. |
| UngradedElementary | 21.9.2 | Varchar2(1) | Designates a K aged student receiving Group B SPED services. |