S_IN_STU_X (ver 14.11.0)
This table is an extension of the [Students] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.5.3 | Number(10,0) | Primary key that relates the extended table to the [Students] table. |
| Academic_Honors | 15.6.4 | VarChar2(30) | The descriptive title for the honors received. Some common ones are “Valedictorian”, “Salutatorian”, “With Honors”. |
| Active_Duty_Parent | 16.3.0 | VarChar2(1) | Indicates the student's parent Active Duty. |
| Address_Country_Code | 15.6.4 | VarChar2(2) | Code indicating Country. |
| Assigning_Agency | 15.6.4 | VarChar2(30) | A code that describes the type of agency that assigned the student’s identification number. |
| Braille | 15.8.2 | VarChar2(1) | Braille for the test. |
| Calculator | 15.8.2 | VarChar2(1) | Calculator. |
| Class_Rank | 15.8.2 | Number(11,0) | Override to enter students class rank. |
| Class_Rank_Method | 15.9.0 | VarChar2(50) | Exclude from transcript and Class Rank Method Override. |
| Class_Size | 15.8.2 | Number(11,0) | Override to enter the class size. |
| Cohort_Graduation_Year | 15.6.4 | VarChar2(4) | The school year in which the student entered the baseline group used for computing completion rates, e.g., high school year and program. |
| Diploma_Level | 15.6.4 | VarChar2(30) | The level of the degree, certificate, or award granted for the successful completion of requirements of an academic program. |
| Diploma_Type | 15.6.4 | VarChar2(400) | The descriptive title for the academic award. |
| ENG_Lang_Prof_Level | 15.8.2 | VarChar2(3) | Student WIDA score. |
| Exclude_From_WIDA | 14.11.0 | VarChar2(1) | Exclude student from Test. |
| Exclude_GPA | 15.9.0 | Number(1,0) | Exclude the Student GPA field from e-Transcript. |
| Extended_Time | 15.8.2 | VarChar2(1) | Extended Time for the test. |
| GPA_Overall | 15.8.2 | Number(25,10) | Override field to enter a GPA for a student and not use the GPA calculated. |
| GPA_Range_Maximum | 15.6.4 | VarChar2(18) | The maximum possible Grade Point Average. |
| Grade_4_ISTEP_Not_Pass_IREAD3 | 14.11.0 | VarChar2(1) | Student Tested 4th Grade ISTEP And Did Not Pass IREAD3. Obsolete in sr170922. Reused in sr180222 for renamed field IREAD3 Retest. |
| Grade_Level_Code | 15.6.4 | VarChar2(30) | The current grade level of the student or the highest grade level attained by the student at the time the record was created. |
| Graduation_Date | 15.6.4 | Date | The date of the student's graduation. |
| Large_Font | 15.8.2 | VarChar2(1) | Large Font for the test. |
| Large_Print | 15.8.2 | VarChar2(1) | Large Print for the test. |
| Read_Aloud | 15.8.2 | VarChar2(1) | Read aloud for the test. |
| Special_Education_Location | 15.11.0 | VarChar2(2) | Indicates student is Special Education. |
Unaccompanied_Youth | 14.5.3 | VarChar2(1) | Reported on DOE-AD. Is this student an unaccompanied youth? Values are 1=Yes, null or 0=No. |
| WIDA_First_Year_Test_Taker | 14.11.0 | VarChar2(1) | First year student is taking WIDA. |
| WIDA_Teacher_SPN | 14.11.0 | VarChar2(8) | SPN for teacher administering WIDA. |
| WIDA_Tier | 14.11.0 | VarChar2(4) | WIDA test level. |
| Exclude_From_AT | 16.8.0 | Number(1,0) | Exclude flag for rewritten AT report. |
| Grade_Level_Override | 16.8.0 | VarChar2(2) | Grade Level Overide for the RT. |
| Paper_Format | 16.8.0 | VarChar2(1) | Accommodation field for TL Report. |
| Text_To_Speech | 16.8.0 | VarChar2(1) | Accommodation field for TL Report. |
| Braille_UEB_Contracted | 16.8.2 | VarChar2(1) | Accommodation field for TL Report. |
| Braille_EBAE_Contracted | 16.8.2 | VarChar2(1) | Accommodation field for TL Report. |
| Braille_UEB_Uncontracted | 16.8.2 | VarChar2(1) | Accommodation field for TL Report. |
| Braille_EBAE_Uncontracted | 16.8.2 | VarChar2(1) | Accommodation field for TL Report. |
| ISTEP_Session_Name_Part_1 | 16.8.2 | VarChar2(30) | Used for TL Report for the ELA Session Name Part 1 value. |
| ISTEP_Session_Name_Part_2 | 16.8.2 | VarChar2(30) | Used for TL Report for the ELA Session Name Part 2 value. |
| ISTEP_Reporting_Group | 16.8.2 | VarChar2(2) | Used for TL Report for the ELA Reporting Group value. |
| IREAD_Session_Name | 16.8.2 | VarChar2(30) | Used for TL Report. |
| IREAD_Reporting_Group | 16.8.2 | VarChar2(2) | Used for TL Report. |
| CHIRP_Sign_Off | 16.8.2 | Number(1,0) | Located on students Emergency/Medical page, used for the e-Transcript. |
| GPA_Academic_Summary_Type | 16.12.3 | VarChar2(50) | Used by the e-Transcript to indicate GPA Type. |
| GPA_Type_User_Defined_Desc | 16.12.3 | VarChar2(80) | Used by the e-Transcript to type a description of the GPA. |
| Had_Disease_Date | 16.12.3 | Date | Used by the e-Transcript to indicate exemption date of when student previously had a disease. |
| Medical_Exemption_Date | 16.12.3 | Date | Used by the e-Transcript to indicate a medical exemption date. |
| Religious_Exemption_Date | 16.12.3 | Date | Used by the e-Transcript to indicate a religious medical exemption date. |
| ISTEP_Teacher_SPN_Math | 17.1.0 | VarChar2(8) | Used by the TL to indicate the SPN of the ISTEP Math Test Teacher. |
| ISTEP_Session_Name_Part_1_Math | 17.1.0 | VarChar2(30) | Used by the TL to indicate Part 1 Session Name for the ISTEP Math Test. |
| ISTEP_Session_Name_Part_2_Math | 17.1.0 | VarChar2(30) | Used by the TL to indicate Part 2 Session Name for the ISTEP Math Test. |
| ISTEP_Reporting_Group_Math | 17.1.0 | VarChar2(30) | Used by the TL to indicate the Reporting Group for the ISTEP Math Test. |
| ISTEP_Teacher_SPN_Sci | 17.1.0 | VarChar2(8) | Used by the TL to indicate the SPN of the ISTEP Science Test Teacher. |
| ISTEP_Session_Name_Part_1_Sci | 17.1.0 | VarChar2(30) | Used by the TL to indicate Part 1 Session Name for the ISTEP Science Test. |
| ISTEP_Session_Name_Part_2_Sci | 17.1.0 | VarChar2(30) | Used by the TL to indicate Part 2 Session Name for the ISTEP Science Test. |
| ISTEP_Reporting_Group_Sci | 17.1.0 | VarChar2(30) | Used by the TL to indicate the Reporting Group for the ISTEP Science Test. |
| ISTEP_Teacher_SPN_Soc | 17.1.0 | VarChar2(8) | Used by the TL to indicate the SPN of the ISTEP Social Studies Test Teacher. |
| ISTEP_Session_Name_Part_1_Soc | 17.1.0 | VarChar2(30) | Used by the TL to indicate Part 1 Session Name for the ISTEP Social Studies Test. |
| ISTEP_Session_Name_Part_2_Soc | 17.1.0 | VarChar2(30) | Used by the TL to indicate Part 2 Session Name for the ISTEP Social Studies Test. |
| ISTEP_Reporting_Group_Soc | 17.1.0 | VarChar2(30) | Used by the TL to indicate the Reporting Group for the ISTEP Social Studies Test. |
| Exclude_Class_Rank | 15.9.0 | Number(1,0) | Used by the e-Transcript to indicate a student's Class Rank should be excluded from the e-Transcript. |
| Exclude_GPA | 15.9.0 | Number(1,0) | Used by the e-Transcript to indicate a student's GPA should be excluded from the e-Transcript. |
| Class_Rank_Method | 15.9.0 | VarChar2(50) | Used by the e-Transcript to specify a Class Rank Method override. |
| WIDA_Tier | 14.11.1 | VarChar2(4) | Used by the TL report to indicate the students WIDA Tier. |
| ISTAR_Teacher_SPN | 17.1.0 | VarChar2(8) | Used by the TL report to indicate ISTAR Teacher SPN. |
| Twentyfirst_Century_Scholar_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_21stCentury_Scholar. |
| Dual_Credit_YN | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_Dual_Credit. |
| Facility | 17.6.0 | VarChar2(2) | Migrated from [Students]Facility. |
| Homebound | 17.6.0 | VarChar2(2) | Migrated from [Students]Homebound. |
| Class_Period_Number_AlgII | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Class_Period_Num_AlgII. |
| Class_Period_Number_BioI | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Class_Period_Num_BioI. |
| Class_Period_Num_Eng11 | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Class_Period_Num_Eng11. |
| IMAST_Taker | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_IMAST_Taker. |
| Accom_MathAlgI | 17.6.0 | VarChar2(1) | Migrated from: [Students]IN_MathAccom_AlgI. |
| Accom_MathBiol | 17.6.0 | VarChar2(1) | Migrated from: [Students]IN_MathAccom_BioI. |
| Accom_MathEng10 | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_MathAccom_Eng10. |
| Accom_MathLAS | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_MathAccom_LAS. |
| Short_Day_Reason | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_reason_for_short. |
| Retest_AlgII_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Retest_AlgII. |
| Retest_Biol_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Retest_BioI. |
| Retest_Eng11_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Retest_Eng11. |
| Retest_ISTEP_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Retest_ISTEP. |
| Retest_Status | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Retest_Status. |
| Accom_ScienceAlgI | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_ScienceAccom_AlgI. |
| Accom_ScienceBiol | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_ScienceAccom_BioI. |
| Accom_ScienceEng10 | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_ScienceAccom_Eng10. |
| Accom_ScienceLAS_TF | 17.6.0 | Number(1,0) | Migrated from: [Students]IN_ScienceAccom_LAS. |
| Service_Site | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Service_Site. |
| Short_Day_Amount | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_short_day. |
| Accom_SocialAlgI | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_SocialAccom_AlgI. |
| Accom_SocialBiol | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_SocialAccom_BioI. |
| Accom_SocialEng10 | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_SocialAccom_Eng10. |
| Accom_SocialLAS_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_SocialAccom_LAS. |
| Teacher_SPN_AlgII | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_AlgII. |
| Teacher_SPN_Biol | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_BioI. |
| Teacher_SPN_Eng11 | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_Eng11. |
| Teacher_SPN_ISTEPR | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_ISTEPR. |
| Teacher_SPN_LAS | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_LAS. |
| Teacher_SPN2_ISTEP | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN2_ISTEP. |
| Test_Code_AlgII | 17.6.0 | VarChar2(4) | Migrated from [Students]IN_Test_Code_AlgII.. |
| Test_Code_Biol | 17.6.0 | VarChar2(4) | Migrated from [Students]IN_Test_Code_BioI. |
| Test_Code_Eng11 | 17.6.0 | VarChar2(4) | Migrated from [Students]IN_Test_Code_Eng11. |
| LMS | 17.6.0 | VarChar2(1) | Migrated from [Students]LMS. |
| Regular_Transportation_TF | 17.6.0 | Number(1,0) | Migrated from [Students]RegularTransportation. |
| Retained_TF | 17.6.0 | Number(1,0) | Migrated from [Students]Retained. |
| Retention_Status_TF | 17.6.0 | Number(1,0) | Migrated from [Students]RetentionStatus. |
| School_Choice_2 | 17.6.0 | VarChar2(1) | Migrated from [Students]SchoolChoice2.. |
| AccomScience_TF | 17.6.0 | Number(1,0) | Migrated from [Students]ScienceAccom. |
| AccomSocial_TF | 17.6.0 | Number(1,0) | Migrated from [Students]SocialAccom. |
| Special_Code_R | 17.6.0 | VarChar2(1) | Migrated from: [Students]SpecialCodeR. |
| Special_Code_S | 17.6.0 | VarChar2(1) | Migrated from [Students]SpecialCodeS. |
| Special_Code_T | 17.6.0 | VarChar2(1) | Migrated from [Students]SpecialCodeT. |
| SpecialEd_Referral_TF | 17.6.0 | Number(1,0) | Migrated from [Students]SpecialEdReferral. |
| SpecialEd_Transportation_TF | 17.6.0 | Number(1,0) | Migrated from [Students]SpecialEdTransportation. |
| Supplemental_Services | 17.6.0 | VarChar2(1) | Migrated from [Students]Supplemental. |
| Vocational_Transportation_TF | 17.6.0 | Number(1,0) | Migrated from [Students]VocationalTransportation. |
| Accom_EngLangArts_TF | 17.6.0 | Number(1,0) | Migrated from [Students]EngLangArtsAccom. |
| Accom_EngLangArtsAlgI | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_EngLangArtsAccom_AlgI. |
| Accom_EngLanArtsBiol | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_EngLangArtsAccom_BioI. |
| Accom_EngLanArtsEng10 | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_EngLangArtsAccom_Eng10. |
| Accom_EngLanArtsLAS_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_EngLangArtsAccom_LAS. |
| Exclude_From_EV_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Exclude_From_EV. |
| Exclude_From_IREAD | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_Exclude_From_IREAD. |
| Exclude_From_LM_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Exclude_From_LM. |
| Exclude_From_ME_TF | 17.6.0 | Number(1,0) | Migrated from: [Students]IN_Exclude_From_ME. |
| Exclude_From_RT_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Exclude_From_RT.. |
| Exclude_From_SE_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Exclude_From_SE. |
| Exclude_From_STN_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Exclude_From_STN. |
| Exclude_From_TR_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Exclude_From_TR. |
| Exclude_From_LasLinks | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_Exclude_From_LasLinks. |
| Student_Name_Suffix | 17.6.0 | VarChar2(4) | Migrated from [Students]Suffix_Name. |
| ChoiceScholarStu_YN | 17.6.0 | VarChar2(1) | Migrated from [Students]ChoiceScholarStu. |
| Corp_Student_ID | 17.6.0 | VarChar2(15) | Migrated from [Students]CorpStudentID. |
| County_Residence | 17.6.0 | VarChar2(2) | Migrated from [Students]CountyResidence. |
| Enrolled_TF | 17.6.0 | Number(1,0) | Migrated from [Students]Enrolled. |
| Exceptionality_Primary | 17.6.0 | VarChar2(2) | Migrated from [Students]Exceptionality. |
| Gifted_Talented_TF | 17.6.0 | Number(1,0) | Migrated from [Students]GiftedAndTalented. |
| Access_School | 17.6.0 | VarChar2(4) | Migrated from [Students]IN_Access_School. |
| Accountable_School | 17.6.0 | VarChar2(4) | Migrated from [Students]IN_Accountable_School. |
| ADM_Type | 21.1.2.0 | VarChar2(2) | PSSR-254103- The field length increased to 2 characters |
| ASC_Graduate_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_asc_graduate. |
| Country_Of_Origin | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_country_of_origin. |
| Date_Of_Termination | 17.6.0 | Date | Migrated from [Students]IN_DateOfTermination. |
| Dropout_Mobility_Code | 17.6.0 | VarChar2(2) | Migrated from [Students]IN_dropout_mobility_code. |
| Dropout_Mobility_Date | 17.6.0 | Date | Migrated from [Students]IN_dropout_mobility_date. |
| Eighth_Grade_Tech | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_eighth_grade_tech. |
| English_Language_Proficiency | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_english_language_proficiency_level. |
| ESEA_Title_I_Program | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_esea_title_I_program. |
| First_Year_Test_Taker_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_First_Year_Test_Taker. |
| Foreign_Exchange_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_foreign_exchange. |
| Half_Time_KG | 17.6.0 | VarChar2(2) | Migrated from [Students]IN_HalfTimeKinder. |
| High_Ability | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_high_ability. |
| Homeless | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_Homeless. |
| Instructional_Days | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_instructional_days. |
| Instructional_Minutes | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_instructional_minutes. |
| IREAD_EL_Exempt | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_IREAD_EL_Exempt. |
| IREAD_IEP_Exempt | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_IREAD_IEP_Exempt. |
| IREAD_OutOfState_Exempt | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_IREAD_Out_Of_State_Exempt. |
| IREAD_Retained_Exempt | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_IREAD_Retained_Exempt. |
| ISTAR_Taker_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_ISTAR_Taker. |
| Migrant_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_migrant. |
| Native_Language_Code | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Native_Language. |
| Non_US_Origin_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_non_us_origin. |
| Other_Country | 17.6.0 | VarChar2(20) | Migrated from [Students]IN_other_country. |
| Post_Graduate_Info | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_post_graduate_info. |
| Reason_Termination | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_ReasonForTermination. |
| Services_Begin_Date | 17.6.0 | Date | Migrated from [Students]IN_Services_Begin_Date. |
| Student_Eligibility | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_Student_Eligibility. |
| Title_I_Extended_Time | 18.2.0 | VarChar2(400) | Migrated from [Students]IN_title_I_extended_time. |
| Title_I_Instruction | 17.6.0 | VarChar2(50) | Migrated from [Students]IN_title_I_instruction. Field length updated with 17.12.0. |
| Title_I_Support | 17.6.0 | VarChar2(50) | Migrated from [Students]IN_title_I_support. Field length updated with 17.12.0. |
| Type_of_Graduate | 17.6.0 | VarChar2(2) | Migrated from [Students]IN_type_of_graduate. |
| LEP_YN | 17.6.0 | VarChar2(1) | Migrated from [Students]LEP. |
| Exceptionality_Secondary | 17.6.0 | VarChar2(2) | Migrated from [Students]SecondaryExceptionality. |
| SpecialEd_Placement | 17.6.0 | VarChar2(2) | Migrated from [Students]SpecialEdPlacement. |
| Special_Education_TF | 17.6.0 | Number(1,0) | Migrated from [Students]SpecialEducation. |
| Title_I_Participant_TF | 17.6.0 | Number(1,0) | Migrated from: [Students]TitleI. |
| Case_Conference_Date | 17.6.0 | Date | Migrated from [Students]IN_Case_Conference_Date. |
| Class_Period_Number_AlgI | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Class_Period_Num_AlgI. |
| Class_Period_Num_Eng10 | 17.6.0 | VarChar2(3) | Migrated from [Students]IN_Class_Period_Num_Eng10. |
| Timeline_Compliance | 17.6.0 | VarChar2(2) | Migrated from [Students]IN_Deadline_Miss_Reason. |
| Initiation_Evaluation_Date | 17.6.0 | Date | Migrated from [Students]IN_Initial_Evaluation_Date. |
| Instructional_Program | 17.6.0 | VarChar2(2) | Migrated from [Students]IN_instructional_program. |
| Instrument_Used | 17.6.0 | VarChar2(2) | Migrated from [Students]IN_instrument_used. |
| Length_US_Enrollment | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_length_us_enrollment. |
| Referral_Date | 17.6.0 | Date | Migrated from [Students]IN_Referral_Date.. |
| Retest_AlgI_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Retest_AlgI. |
| Retest_Eng10_TF | 17.6.0 | Number(1,0) | Migrated from [Students]IN_Retest_Eng10. |
| Servicing_School | 17.6.0 | VarChar2(4) | Migrated from [Students]IN_Servicing_School. |
| Teacher_SPN_AlgI | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_AlgI. |
| Teacher_SPN_Eng10 | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_Eng10. |
| Teacher_SPN_IREAD | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_IREAD. |
| Teacher_SPN_ISTEP | 17.6.0 | VarChar2(8) | Migrated from [Students]IN_Teacher_SPN_ISTEP. |
| Timeline_Circumstances | 17.6.0 | VarChar2(1) | Migrated from [Students]IN_Timeline_Circumstances. |
| AccomMath_TF | 17.6.0 | Number(1,0) | Migrated from [Students]MathAccom. |
| School_Choice | 17.6.0 | VarChar2(1) | Migrated from [Students]SchoolChoice. |
| Section_504_Plan_TF | 17.6.0 | Number(1,0) | Migrated from [Students]Section504. |
| Foster_Care | 17.7.0 | VarChar2(1) | New field for the 2017-2018 school year. |
| Living_With_Parent | 17.8.0 | VarChar2(1) | New field to indicate if Student lives with Parent or Guardian |
| TANF_Food_Stamp | 17.8.0 | VarChar2(16) | New field to indicate the TANF or Food Stamp Case Number |
| SSN_Parent | 17.8.0 | VarChar2(4) | New field to indicate Last 4 digits of Social Security Number of Adult Household Member |
| Mothers_Maiden_Name | 17.8.0 | VarChar2(50) | Field to track students mothers maiden name, an optional field for CHIRP exchange. |
| CHIRP_Exchange_Exclude | 17.8.0 | Number(1,0) | Field to indicate if the student is to be excluded from the CHIRP exchange process. |
| ISTEP_Retest_Grade10_Eng | 17.8.3 | Number(1,0) | Field to indicate if the student is retesting for ISTEP English/ELA and is in 10th Grade. |
| ISTEP_Retest_Grade10_Math | 17.8.3 | Number(1,0) | Field to indicate if the student is retesting for ISTEP Math and is in 10th Grade. |
| TestTaker_NotEnr_SCI_9920 | 18.5.0 | Varchar2(1) | |
| TestTaker_NotEnr_SCI_9921 | 18.5.0 | Varchar2(1) | |
| TestTaker_NotEnr_SCI_9922 | 18.5.0 | Varchar2(1) | |
| Teacher_SPN_SCI_9920 | 18.5.0 | Varchar2(8) | Used by the TL to indicate the SPN of the ISTEP Grade 10 Science, for code 9920. |
| Teacher_SPN_SCI_9921 | 18.5.0 | Varchar2(8) | Used by the TL to indicate the SPN of the ISTEP Grade 10 Science, for code 9921. |
| Teacher_SPN_SCI_9922 | 18.5.0 | Varchar2(8) | Used by the TL to indicate the SPN of the ISTEP Grade 10 Science, for code 9922. |
| ISTEP_Sess_Name_Part1_9920 | 18.5.0 | Varchar2(30) | Used by the TL to indicate Part 1 Session Name for the ISTEP Grade 10 Science, for code 9920. |
| ISTEP_Sess_Name_Part1_9921 | 18.5.0 | Varchar2(30) | Used by the TL to indicate Part 1 Session Name for the ISTEP Grade 10 Science, for code 9921. |
| ISTEP_Sess_Name_Part1_9922 | 18.5.0 | Varchar2(30) | Used by the TL to indicate Part 1 Session Name for the ISTEP Grade 10 Science, for code 9922. |
| ISTEP_Sess_Name_Part2_9920 | 18.5.0 | Varchar2(30) | Used by the TL to indicate Part 2 Session Name for the ISTEP Grade 10 Science, for code 9920. |
| ISTEP_Sess_Name_Part2_9921 | 18.5.0 | Varchar2(30) | Used by the TL to indicate Part 2 Session Name for the ISTEP Grade 10 Science, for code 9921. |
| ISTEP_Sess_Name_Part2_9922 | 18.5.0 | Varchar2(30) | Used by the TL to indicate Part 2 Session Name for the ISTEP Grade 10 Science, for code 9922. |
| ISTEP_Report_Group_SCI_9920 | 18.5.0 | Varchar2(30) | Used by the TL to indicate the Reporting Group for the ISTEP Grade 10 Science, for code 9920. |
| ISTEP_Report_Group_SCI_9921 | 18.5.0 | Varchar2(30) | Used by the TL to indicate the Reporting Group for the ISTEP Grade 10 Science, for code 9921. |
| ISTEP_Report_Group_SCI_9922 | 18.5.0 | Varchar2(30) | Used by the TL to indicate the Reporting Group for the ISTEP Grade 10 Science, for code 9922. |
| Exclude_Att_From_Transcript | 18.8.0 | Number(1,0) | Flag to exclude all attendance for a student on the e-Transcript. |
| Spanish_Translation | 18.8.0 | Varchar2(1) | Spanish Translation for the test. |
| Online_Refreshable_Braille | 18.8.0 | Varchar2(1) | Accommodation field for TL/TA. |
| TestTaker_NotEnr_US_Govt | 18.8.0 | Varchar2(1) | Used for TL/TA ILEARN field. |
| Burmese_Glossary | 18.8.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Spanish_Glossary | 18.8.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Mandarin_Glossary | 18.8.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Arabic_Glossary | 18.8.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Vietnamese_Glossary | 18.8.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Days_In_US_School | 19.3.0 | Varchar2(3) | The number of days the student has been enrolled in a US School. |
| Exclude_Doe_Ta | 19.4.1.0 | Number(1,0) | Indicates student is excluded from the DOE-TA Report. |
| Iam_Test_Taker | 19.4.1.0 | Varchar2(1) | Indicates student is taking the IAM Test. |
| Assistive_Technology | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Hundreds_Chart_Grades | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Alt_Indication_Response | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| American_Sign_Lang | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Scribe | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Human_Reader_Script | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Biling_Dictionary | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Tested_Individually | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Hearing | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Print_Demand | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Multiplication | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Captioning | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Speech_To_Text | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| StreamlineFormat | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| PermissiveMode | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Print_Format | 19.8.2.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Human_Reader_Script_All | 20.2.1.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Calculator_for_All | 20.2.1.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Text_To_Speech_All | 20.2.1.0 | Varchar2(1) | Accommodation field for TL/TA. |
| Primary_School_of_Enrollment | 21.2.2.0 | Varchar2(1) | Indicates the primary school of enrollment for the student. |
| TeacherOfRecord | 21.9.2.0 | Number(11,0) | Stores the Users.DCID value of the teacher or counselor responsible for the student's credit recovery classes. |
| AlternativeStudent | 22.4.1.0 | Varchar2(1) | To indicate that a student have an active alternative education program or not |