S_IA_STU_X (ver 14.7.2)
This table is an extension of the Students table, and holds Iowa-specific state reporting fields.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.7.2 | Number(10,0) | System generated primary key. |
| Academic_Year_Status | 17.2.0 | Varchar2(1) | Full academic year status. Migrated from [Students]IA_FullAcademicYearStatus. |
| Accountable_District | 17.2.0 | Varchar2(8) | The accountable district for the student. Migrated from [Students]IA_AccountableDist. |
| Address_Type | 17.2.0 | Varchar2(4) | The student's address type; previously used by the e-Transcript. Migrated from [Students]IA_AddressType. |
| Alt_Lang | 22.1.1 | Varchar2(3) | The alternate language of the test questions and answer choices. |
| Answer_Mask | 22.1.1 | Varchar2(1) | Masks all answer choices until student clicks to reveal them. |
| At_Risk | 17.2.0 | Varchar2(1) | Indicates whether the student is considered to be at risk at any time during the year. Migrated from [Students]IA_AtRisk. |
| Attending_District | 17.2.0 | Varchar2(4) | State assigned ID of the district where the student is counted for attendance purposes. Migrated from [Students]IA_AttendingDistrict. |
| Biliteracy_Lang2 | 19.6.2 | Varchar2(3) | Stores the Biliteracy Seal 2nd Language. |
| Biliteracy_Lang2_Date | 19.6.2 | Date | Stores the Biliteracy Seal 2nd Language date. |
| Biliteracy_Lang3 | 19.6.2 | Varchar2(3) | Stores the Biliteracy Seal 3rd Language. |
| Biliteracy_Lang3_Date | 19.6.2 | Date | Stores the Biliteracy Seal 3rd Language date. |
| Birth_Country | 15.7.3 | Varchar2(2) | Country of birth as noted on the Home Language survey. |
| Cardio_Course_Completion | 17.2.0 | Varchar2(1) | Indicates whether the student completed a Cardiopulmonary Resuscitation Course; previously used by the e-Transcript. Migrated from [Students]IA_CardioCourseCompletion. |
| Class_Teacher_Name | 17.2.0 | Varchar2(50) | The name of the student's teacher or class. Migrated from [Students]IA_ClassTeacherName. |
| Color_Cont | 22.1.1 | Varchar2(20) | Changes the color scheme of the test. |
| CPI_Dual_Enrollment | 17.2.0 | Varchar2(2) | Indicates the student’s CPI dual enrollment status. Migrated from [Students]IA_CPIDualEnrollment. |
| Destination_Code | 17.2.0 | Varchar2(2) | The type of destination location. Migrated from [Students]IA_DestCode. |
| Destination_Location | 17.2.0 | Varchar2(8) | The state assigned code for the specific destination. Migrated from [Students]IA_DestLoc. |
| Diploma | 17.6.0 | Varchar2(2) | Indicates whether the student received a district diploma by meeting a set of board-approved graduation requirements/credits. |
| Diploma_Type | 17.2.0 | Varchar2(2) | The student's diploma type. Migrated from [Students]DiplomaCat. |
| Early_Services_Indicator | 17.2.0 | Varchar2(1) | Indicates whether the student receives Coordinated Early Intervening Services (CEIS) funded by IDEA Part B during the current year. Migrated from [Students]IA_EarlyIntervServIndicator. |
| ELL_Assessment | 17.2.0 | Varchar2(2) | The student's ELL assessment; no longer used for state reporting. Migrated from [Students]IA_ELLAssessment. |
| ELL_Exit_Date | 17.2.0 | Date | The LIEP exit date when the student was removed from the ELL program/service. The student's ELL exit date Migrated from [Students]IA_ELLExitDate. |
| ELL_Placement_Date | 17.2.0 | Date | The LIEP placement date when the student was placed in an ELL program/service in the district. Migrated from [Students]IA_ELLPlacementDate. |
| ELL_Proficiency_Level | 17.2.0 | Varchar2(2) | The English proficiency level determined by the LIEP placement instrument. Migrated from [Students]IA_ELLProficiencyLevel. |
| ELL_Program | 17.2.0 | Varchar2(2) | The LIEP Instructional Program. Migrated from [Students]IA_ELLProgram. |
| ELL_Status | 17.2.0 | Varchar2(2) | The studen'ts current ELL status. Migrated from [Students]IA_ELLStatus. |
| ELL_YR1_Teacher | 15.7.3 | Number(11,0) | Year 1 monitor teacher folder number. |
| ELL_YR1_End_Date | 15.7.3 | Date | Date the Year 1 monitoring will end. |
| ELL_YR1_Decision | 15.7.3 | Varchar2(2) | Decision for monitoring after Year 1. |
| ELL_YR2_Teacher | 15.7.3 | Number(11,0) | Year 2 monitor teacher folder number. |
| ELL_YR2_End_Date | 15.7.3 | Date | Date the Year 2 monitoring will end. |
| ELL_YR2_Decision | 15.7.3 | Varchar2(2) | Date the Year 2 monitoring will end. |
| Entry_Type | 17.2.0 | Varchar2(5) | The process by which a student enters a school. Migrated from [Students]IA_EntryType. |
| ESA_Funded | 23.7.1 | Number(1,0) | Indicates if the student is funded by an Educational Savings Account. |
| Facility_Type | 17.2.0 | Varchar2(2) | The student's service/facility type. Migrated from [Students]IA_ServFacType. |
| Foster_Care | 17.2.0 | Varchar2(1) | Indicates whether a student is in foster care. Migrated from [Students]IA_FosterCare. |
| FourPlusSenior | 24.1.2 | Number(1,0) | Indicates that the student will not graduate in the normal four year timeframe. |
| FTE | 17.2.0 | Double | The student’s full-time equivalency. Migrated from [Students]IA_Fte. |
| Gifted | 17.2.0 | Number(1,0) | Indicates whether the student is identified as gifted/talented. Migrated from [Students]IA_Gifted. |
| Graduation_Status | 17.2.0 | Number(1,0) | Indicates whether the student has graduated. Migrated from [Students]IA_Graduated. |
| Health_Issues | 17.2.0 | Number(1,0) | Indicates whether the student has health issues; no longer used for state reporting. Migrated from [Students]IA_HealthInfo. |
| Home_Lang_Date | 15.7.3 | Date | Date the Home Language Survey was completed. |
| Home_Lang_ID | 15.7.3 | Number(11,0) | Home Language Identifier, other than English, from the Home Language Survey. |
| Homeless_Student_Served | 17.2.0 | Varchar2(2) | Indicates whether the student is homeless and served through McKinney-Vento funds. Migrated from [Students]IA_HomelessStudentServed. |
| Homeless_Youth | 17.2.0 | Varchar2(2) | Indicates whether the student is an unaccompanied youth. Migrated from [Students]IA_Unaccomp_Uth. |
| HS_Graduation_Date | 17.2.0 | Date | The student's high school graduation date; previously used for the e-Transcript. Migrated from [Students]IA_HSGradDate. |
IEP_Level | 14.7.2 | Number(11,0) | The Special Education weighting for the student. |
| IEP_Placement_Date | 17.2.0 | Date | Date of the students most recent IEP placement. Migrated from [Students]IA_IEPPlacementDate. |
| IEP_Staffed_Out_Date | 17.2.0 | Date | Date of the most recent IEP staff out. Migrated from [Students]IA_IEPStaffedOutDate. |
| If_Lang | 22.1.1 | Varchar2(3) | Indicates the language of the menus and directions |
| Immigrant | 17.2.0 | Number(1,0) | Indicates whether the student is an immigrant. Migrated from [Students]IA_Immigrant. |
Junior_Senior | 14.7.2 | Number(1.0) | Indicates whether the student is continuing enrollment under the Junior Senior Rule. |
| LEP_ReEntry_Date | 15.7.3 | Date | Date of LEP re-entry. |
| LEP_Waived_Service | 16.8.2 | Date | Date Parent Waived LIEP Services. |
| Line_Rdr | 22.1.1 | Varchar2(1) | Indicates enabled feature that blocks all but a small section of the text on screen. |
| Migrant | 17.2.0 | Varchar2(1) | Indicates whether the student is a migrant. Migrated from [Students]IA_Migrant. |
| Mig_Arrive_Date | 21.7.2 | Date | Date the student's family arrived in the city or town in order to work. Captures the response to "If so, what is the date your family arrived in the city/town?" on the Migrant Questionnaire. |
| Mig_Employment | 21.7.2 | Varchar2(25) | The types of employment for the student's parents. Captures the response to "Has anyone in your family been involved in one of the following jobs, either full or part-time or temporarily during the last three (3) years?" on the Migrant Questionnaire. |
| Mig_Moved_to_Work | 21.7.2 | Varchar2(1) | Indicates if the student's family moved in order to work. Captures the response to "Has your family moved in order to work in another city, country, or state in the last three (3) years?" on the Migrant Questionnaire. |
| Mig_Submit_Date | 21.7.2 | Date | Date the Migrant Questionnaire was last submitted. |
| Military_Connected_Status | 17.2.0 | Varchar2(1) | Indicates whether the student is a child of military personnel. Migrated from [Students]IA_MilitaryConnectedStatus. |
No_ ELDAScore | 14.7.2 | Number(11,0) | The reason no ELDA Score will be reported for the student; no longer used for state reporting. |
| No_State_Math_Reason | 17.2.0 | Varchar2(2) | The reason no state math assessment score will be reported for this student. Migrated from [Students]IA_State_NoStMathReason. |
| No_State_Read_Reason | 17.2.0 | Varchar2(2) | The reason no state reading assessment score will be reported for this student. Migrated from [Students]IA_State_NoStReadingReason. |
| No_State_Sci_Reason | 17.2.0 | Varchar2(2) | The reason no state science assessment score will be reported for this student. Migrated from [Students]IA_State_NoStScienceReason. |
| Non_Public_School_Number | 17.2.0 | Varchar2(8) | Indicates State assigned code of the nonpublic school where the student has his / her primary enrollment. Migrated from [Students]IA_NonPubSchoolNumber. |
| Other_Employ | 21.7.2 | Varchar2(200) | Indicates other type(s) of employment the student's family engaged in. Captures the response to "Specify Other Employment" on the Migrant Questionnaire. |
| Other_Info_Field1 | 17.2.0 | Varchar2(3) | The value of the first Other Information field on the Iowa Testing Program answer sheet; reserved for CogAt scores. Migrated from [Students]IA_OtherInformationField1. |
| Other_Info_Field2 | 17.2.0 | Varchar2(3) | The value of the second Other Information field on IA Testing Program answer sheet. Migrated from [Students]IA_OtherInformationField2. |
| Other_Info_Field3 | 17.2.0 | Varchar2(3) | The value of the third Other Information field on IA Testing Program answer sheet. Migrated from [Students]IA_OtherInformationField3. |
| Parent_Name_Type1 | 17.2.0 | Varchar2(2) | Parent Name Type 1; no longer used for state reporting. The Migrated from [Students]IA_ParentNameType. |
| Parent_Name_Type2 | 17.2.0 | Varchar2(2) | Parent Name Type 2; no longer used for state reporting. Migrated from [Students]IA_ParentNameType2. |
| Paying_Job | 16.8.2 | Varchar2(2) | Indicates whether the student has a paying job. |
| Phone_Number_Type | 17.2.0 | Varchar2(4) | The student's phone number type; no longer used for state reporting. Migrated from [Students]IA_PhoneNumberType. |
| Post_Grad_Location | 17.2.0 | Varchar2(2) | The student's post-graduate location. Migrated from [Students]PostGradIntLoc. |
Post_Grad_Plan | 17.2.0 | Varchar2(2) | The student’s post-graduate intended educational or occupational plans. Migrated from [Students]PostGradPlan. |
| Program_1 | 17.2.0 | Varchar2(3) | The student's program code. Migrated from [Students]IA_Prg1. |
| Program_2 | 17.2.0 | Varchar2(3) | The student's additional program code. Migrated from [Students]IA_Prg2. |
| Program_3 | 17.2.0 | Varchar2(3) | The student's additional program code. Migrated from [Students]IA_Prg3. |
| Receiving_Ed_Services | 17.2.0 | Varchar2(2) | Indicates whether the student receives educational services. Migrated from [Students]IA_RcvEduServices. |
| Resident_County | 17.2.0 | Varchar2(2) | The student's resident county. Migrated from [Students]IA_ResidentCounty. |
| Resident_Facility | 17.2.0 | Varchar2(8) | The Department of Education code for the facility in which the student resides or the location |
| School_of_Origin | 17.6.0 | Varchar2(2) | Indicates whether a foster care student is continuing his or her enrollment in the school of origin. |
| School_Override | 17.2.0 | Varchar2(4) | Student-level override value for the student's school of enrollment. Migrated from [Students]IA_SchoolNumber. |
| Section_504 | 17.2.0 | Number(1,0) | Indicates whether the student has a 504 plan. Migrated from [Students]IA_504. |
| Stt | 23.10.2 | Varchar2(1) | Indicates the student requires the Speech-to-Text accommodation for the state assessments. |
| Student_Name_Type | 17.2.0 | Varchar2(2) | The student's name type; no longer used for state reporting. Migrated from [Students]IA_StudentNameType. |
| Student_Previous_First_Name | 17.2.0 | Varchar2(50) | The student's previous first name; no longer used for state reporting. Migrated from [Students]IA_StudentPreviousFirstName. |
| Student_Previous_Last_Name | 17.2.0 | Varchar2(50) | The student's previous last name; no longer used for state reporting. Migrated from [Students]IA_StudentPreviousLastName. |
| Student_Previous_Mid_Name | 17.2.0 | Varchar2(30) | The student's previous middle name; no longer used for state reporting. Migrated from [Students]IA_StudentPreviousMiddleName. |
| Student_Previous_Name_Type | 17.2.0 | Varchar2(2) | The student's previous name type; no longer used for state reporting. Migrated from [Students]IA_StudentPreviousNameType. |
| TI_Target_Assist_Math | 17.2.0 | Number(1,0) | Indicates whether the student receives Title I assistance for math. Migrated from [Students]IA_TitleI_TargetedAssistanceMath. |
| TI_Target_Assist_Reading | 17.2.0 | Number(1,0) | Indicates whether the student receives Title I assistance for reading. Migrated from [Students]IA_TitleI_TargetedAssistanceReading. |
| Therap_Prgm_Att | 21.7.2 | Varchar2(1) | Indicates whether the student was served in a Therapeutic Program/Classroom. |
| Therap_Prgm_Comment | 21.7.2 | Varchar2(250) | The comments provided about the Therapeutic Program/Classroom. |
| Therap_Prgm_Ref | 21.7.2 | Varchar2(1) | Indicates whether the student was referred to a Therapeutic Program/Classroom. Obsolete as of September 2021. Therapeutic Referrals are now held a separate child table: S_IA_STU_THER_REF_C. |
| Title_I_School | 17.2.0 | Varchar2(4) | The school offering Title I school choice. Migrated from [Students]IA_Title1SchoolOffering. |
| Title_I_Supplemental | 17.2.0 | Varchar2(2) | The student’s Title I Supplement Services status. Migrated from [Students]IA_TitleI_Supplemental. |
| Title_I_School_Status | 17.2.0 | Varchar2(2) | The student’s Title I school choice status. Migrated from [Students]IA_TitleISchoolChoiceStatus. |
| Transfer_Option | 17.2.0 | Varchar2(2) | The student’s option transfer status under the Unsafe School Individual Student Option. Migrated from [Students]IA_StudentOptTrans. |
| Tts | 22.1.1 | Varchar2(1) | Indicates student can have any on-screen text read aloud to them by the computer. |
| Tuition_Out_Acc_School | 19.6.2 | Varchar2(4) | Numeric field for Tuitioned-out accountable school. Rendered obsolete for the 2021-22 school year and beyond. |
| Xtra_Curricular | 16.8.2 | Varchar2(2) | Indicates whether the student is involved in extra curricular activities. |