S_MO_STU_X (ver 14.9.3)
This table is an extension of the Students table and contains fields used for Missouri state reporting.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| StudentsDCID | 14.9.3 | Number(10,0) | Relates the extended table to the Students table. |
AbdominalStr | 16.2.0 | Varchar2(10) | Abdominal Strength. Migrated from [Students]MO_AbdominalStr. |
Adult | 16.2.0 | Number(1,0) | Adult. Migrated from [Students]MO_Adult. |
AerobicCap | 16.2.0 | Varchar2(10) | Aerobic Capacity. Migrated from [Students]MO_AerobicCap. |
ALGIEOC | 17.3.0 | Varchar2(2) | Indicates whether the student scored proficient or advanced on the Algebra I EOC exam or state-approved equivalent. Migrated from [Students] MO_ALGIEOC. |
APlus | 16.2.0 | Varchar2(1) | Enrolled in A+ Program. Migrated from [Students]MO_Aplus. |
| AplusAttAppeal | 17.3.0 | Number(25,10) | The number of attendance hours granted during an appeal. Migrated from [Students]MO_AplusAttAppeal. |
| AplusRegAbs09 | 17.3.0 | Number(25,10) | The total number of hours a student was absent in 9th grade. Migrated from [Students]MO_AplusRegAbs09. |
| AplusRegAbs10 | 17.3.0 | Number(25,10) | The total number of hours a student was absent in 10th grade. Migrated from [Students]MO_AplusRegAbs10. |
| AplusRegAbs11 | 17.3.0 | Number(25,10) | The total number of hours a student was absent in 11th grade. Migrated from [Students]MO_AplusRegAbs11. |
| AplusRegAbs12 | 17.3.0 | Number(25,10) | The total number of hours a student was absent in 12th grade. Migrated from [Students]MO_AplusRegAbs12. |
| AplusRegAtt09 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance in 9th grade. Migrated from [Students]MO_AplusRegAtt09. |
| AplusRegAtt10 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance in 10th grade. Migrated from [Students]MO_AplusRegAtt10. |
| AplusRegAtt11 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance in 11th grade. Migrated from [Students]MO_AplusRegAtt11. |
| AplusRegAtt12 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance in 12th grade. Migrated from [Students]MO_AplusRegAtt12. |
| AplusTrainingDate | 17.3.0 | Date | The date the student completed mandatory Mentor/Tutor training. Migrated from [Students]MO_Aplus_TrainingDate. |
| AplusXferAbs09 | 17.3.0 | Number(25,10) | The total number of hours a student was absent while enrolled in another school district in 9th grade. Migrated from [Students]MO_AplusXferAbs09. |
| AplusXferAbs10 | 17.3.0 | Number(25,10) | The total number of hours a student was absent while enrolled in another school district 10th grade. Migrated from [Students]MO_AplusXferAbs10. |
| AplusXferAbs11 | 17.3.0 | Number(25,10) | The total number of hours a student was absent while enrolled in another school district in 11th grade. Migrated from [Students]MO_AplusXferAbs11. |
| AplusXferAbs12 | 17.3.0 | Number(25,10) | The total number of hours a student was absent while enrolled in another school district in 12th grade. Migrated from [Students]MO_AplusXferAbs12. |
| AplusXferAtt09 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance while enrolled in another school district in 9th grade. Migrated from [Students]MO_AplusXferAtt09. |
| AplusXferAtt10 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance while enrolled in another school district 10th grade. Migrated from [Students]MO_AplusXferAtt10. |
| AplusXferAtt11 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance while enrolled in another school district in 11th grade. Migrated from [Students]MO_AplusXferAtt11. |
| AplusXferAtt12 | 17.3.0 | Number(25,10) | The total number of hours a student was in attendance while enrolled in another school district in 12th grade. Migrated from [Students]MO_AplusXferAtt12. |
| Aplus_AgreementDate | 17.3.0 | Date | Date of the student's A+ agreement with the school. Migrated from [Students]MO_Aplus_AgreementDate. |
| Aplus_AppealComment | 17.3.0 | Varchar2(600) | The A+ appeal comment. Migrated from [Students]MO_Aplus_AppealComment. |
| Aplus_AppealDate | 17.3.0 | Date | The date of the A+ appeal. Migrated from [Students]MO_Aplus_AppealDate. |
| Aplus_AttendCommen | 17.3.0 | Varchar2(600) | The comment regarding the student's A+ appeal. Migrated from [Students]MO_Aplus_AppealComment. |
| Aplus_Consecutive_Years | 17.3.0 | Varchar2(1) | 3 yrs at A+ School indicator; indicates whether the student attended a school designated for the A+ Program for three consecutive years prior to graduation. Migrated from [Students]MO_Aplus_Consecutive_Years. |
| Aplus_MentorComment | 17.3.0 | Varchar2(600) | The A+ Mentor/Tutor comment. Migrated from [Students]MO_Aplus_MentorComment. |
| Aplus_Mentor_10 | 17.3.0 | Number(25,10) | The number of hours the student performed district-supervised, unpaid mentoring or tutoring in the 10th grade. Migrated from [Students]MO_Aplus_Mentor_10. |
| Aplus_Mentor_11 | 17.3.0 | Number(25,10) | The number of hours the student performed district-supervised, unpaid mentoring or tutoring in the 11th grade. Migrated from [Students]MO_Aplus_Mentor_11. |
| Aplus_Mentor_12 | 17.3.0 | Number(25,10) | The number of hours the student performed district-supervised, unpaid mentoring or tutoring in the 12th grade. Migrated from [Students]MO_Aplus_Mentor_12. |
| Aplus_Mentor_9 | 17.3.0 | Number(25,10) | The number of hours the student performed district-supervised, unpaid mentoring or tutoring in the 9th grade. Migrated from [Students]MO_Aplus_Mentor_9. |
| Aplus_Prob_End_Dt | 17.3.0 | Date | The end date of the student's A+ probation. Migrated from [Students]MO_Aplus_Prob_End_Dt. |
| Aplus_Prob_Start_Dt | 17.3.0 | Date | The start date of the student's A+ probation. Migrated from [Students]MO_Aplus_Prob_Start_Dt. |
| Aplus_Status | 17.3.0 | Varchar2(1) | The student's A+ status. Migrated from [Students]MO_Aplus_Status. |
| Aplus_StatusComment | 17.3.0 | Varchar2(600) | The comment regarding the student's A+ status. Migrated from [Students]MO_Aplus_StatusComment. |
| Aplus_Status_Reason | 17.3.0 | Varchar2(1) | The reason a student is not participating in an A+ Program. Migrated from [Students]MO_Aplus_Status_Reason. |
| Associate_Degree | 21.5.3 | Varchar2(1) | Indicate if student has earned an Associate Degree |
| Associate_Degree_Inst | 21.5.3 | Varchar2(10) | Location where Associate Degree is earned |
AttendingDistrict | 16.2.0 | Varchar2(6) | Attending District. Migrated from [Students]MO_AttendingDistrict. |
AttendingSchool | 16.2.0 | Varchar2(4) | Attending School. Migrated from [Students]MO_AttendingSchool. |
CIP | 16.2.0 | Varchar2(7) | CIP Code. Migrated from [Students]MO_CIP. |
CountyOfResidence | 16.2.0 | Varchar2(3) | County of Residence. Migrated from [Students]MO_CountyOfResidence. |
CTEAttendingDistrict | 16.2.0 | Varchar2(6) | CTE Attending District. Migrated from [Students]MO_CTEAttendingDistrict. |
CTEAttendingSchool | 16.2.0 | Varchar2(4) | CTE Attending School. Migrated from [Students]MO_CTEAttendingSchool. |
CTECluster | 16.2.0 | Varchar2(2) | Career Cluster. Migrated from [Students]MO_CTECluster. |
CTEPlacementRelation | 16.2.0 | Varchar2(2) | CTE Placement Relation. Migrated from [Students]MO_CTEPlacementRelation. |
CTE_Attainment | 16.2.0 | Varchar2(2) | CTE Technical Skills Attainment. Migrated from [Students]MO_CTE_Attainment. |
| CTE_Certificate | 19.11.1.0 | Varchar2(1) | CTE Certificate |
CTE_EducatorSSN | 16.2.0 | Varchar2(9) | Educator's Social Security Number. Migrated from [Students]MO_CTE_EducatorSSN. |
CTE_Program_Code | 16.2.0 | Varchar2(4) | CTE Program Code. Migrated from [Students]MO_CTE_Program_Code. |
CTSO_DECA | 15.1.0 | Number(11,0) | Distributive Education Clubs of America. |
CTSO_FBLA | 15.1.0 | Number(11,0) | Future Business Leaders of America. |
CTSO_FCCLA | 15.1.0 | Number(11,0) | Family, Career and Community Leaders of America. |
CTSO_FEA | 15.1.0 | Number(11,0) | Future Educators Association. |
CTSO_FFA | 15.1.0 | Number(11,0) | Future Farmers of America. |
CTSO_HOSA | 15.1.0 | Number(11,0) | Health Occupations Students of America - Future Health Professionals. |
CTSO_Pathways | 15.1.0 | Number(11,0) | Pathways to Prosperity. |
CTSO_SkillsUSA | 15.1.0 | Number(11,0) | Technical, Skilled and Service Occupations and Health Sciences. |
CTSO_TSA | 15.1.0 | Number(11,0) | Technology Student Association. |
Disadvantage | 16.2.0 | Number(1,0) | Disadvantaged. Migrated from [Students]Disadvantage. |
DisplacedHomemaker | 16.2.0 | Number(1,0) | Displaced Homemaker. Migrated from [Students]MO_DisplacedHomemaker. |
| Dyslexia | 18.8.0 | Varchar2(3) | Dyslexia status. |
ECO_Entry_Date | 16.2.0 | Date | ECO Entry Date. Migrated from [Students]MO_ECO_Entry_Date. |
ECO_Entry_Indicator_1 | 16.2.0 | Varchar2(1) | ECO Entry Indicator 1. Migrated from [Students]MO_ECO_Entry_Indicator_1. |
ECO_Entry_Indicator_2 | 16.2.0 | Varchar2(1) | ECO Entry Indicator 2. Migrated from [Students]MO_ECO_Entry_Indicator_2. |
ECO_Entry_Indicator_3 | 16.2.0 | Varchar2(1) | ECO Entry Indicator 3. Migrated from [Students]MO_ECO_Entry_Indicator_3. |
ECO_Exit_Date | 16.2.0 | Date | ECO Exit Date. Migrated from [Students]MO_ECO_Exit_Date. |
ECO_Exit_Indicator_1 | 16.2.0 | Varchar2(1) | ECO Exit Indicator 1. Migrated from [Students]MO_ECO_Exit_Indicator_1. |
ECO_Exit_Indicator_2 | 16.2.0 | Varchar2(1) | ECO Exit Indicator 2. Migrated from [Students]MO_ECO_Exit_Indicator_2. |
ECO_Exit_Indicator_3 | 16.2.0 | Varchar2(1) | ECO Exit Indicator 3. Migrated from [Students]MO_ECO_Exit_Indicator_3. |
ELLExit | 16.2.0 | Varchar2(3) | ELL Exit. Migrated from [Students]MO_ELLExit. |
EllExitDate | 16.2.0 | Date | ELL Exit Date. Migrated from [Students]MO_EllExitDate. |
ELLExitTest | 16.2.0 | Varchar2(3) | ELL Exit Test Code. Migrated from [Students]MO_ELLExitTest. |
ESOLInstModel | 16.2.0 | Varchar2(3) | ESOL Instructional Model. Migrated from [Students]MO_ESOLInstModel. |
ExcludeFromCTSO | 15.1.0 | Number(1,0) | Exclude student from CTSO report. |
ExcludeFromGRD | 15.1.0 | Number(1,0) | Exclude student from Grad Followup report. |
ExitDestComment | 16.2.0 | Varchar2(150) | Exit Destination Comment. Migrated from [Students]MO_ExitDestComment. |
ExitDestDistrictCode | 16.2.0 | Varchar2(6) | Exit Destination District. Migrated from [Students]MO_ExitDestDistrictCode. |
ExitDestSchoolCode | 16.2.0 | Varchar2(4) | Exit Destination School. Migrated from [Students]MO_ExitDestSchoolCode. |
ExtSchlHours | 16.2.0 | Number(25,10) | Extended School Hours. Migrated from [Students]MO_ExtSchlHours. |
| FAFSA | 17.3.0 | Date | The date the student submitted the Federal Student Aid Application (FAFSA). Migrated from [Students]MO_FAFSA. |
FirstFreshmanYear | 16.2.0 | Number(11,0) | First Freshman Year. Migrated from [Students]MO_FirstFreshmanYear. |
Flexibility | 16.2.0 | Varchar2(10) | Flexibility. Migrated from [Students]MO_Flexibility. |
FollowUpStatus | 16.2.0 | Varchar2(3) | Grad Follow-Up Status. Migrated from [Students]MO_FollowUpStatus. |
FosterCare | 16.12.3 | Number(1,0) | Foster Care Indicator. |
FosterCareEntry_Date | 16.12.3 | Date | Foster Care Entry Date. |
FosterCareExit_Date | 16.12.3 | Date | Foster Care Exit Date. |
GiftedTalented | 16.2.0 | Varchar2(2) | Gifted/Talented. Migrated from [Students]MO_GiftedTalented. |
Handicapping_Conditions | 16.2.0 | Varchar2(2) | IEP Disability Code. Migrated from [Students]MO_handicapping_conditions. |
| HighNeedStudent | 18.10.0 | Varchar2(1) | Indicates an IEP student whose educational costs exceed three times the LEA's current expenditure per Average Daily Attendance (ADA) |
Homeless | 16.2.0 | Varchar2(2) | Homeless. Migrated from [Students]MO_Homeless. |
HrsAbsent | 16.2.0 | Number(25,10) | Regular Hrs Absent. Migrated from [Students]MO_HrsAbsent. |
HrsInSession | 16.2.0 | Number(25,10) | Hours in Session. Migrated from [Students]MO_HrsInSession. |
HrsPresent | 16.2.0 | Number(25,10) | Hours Present. Migrated from [Students]MO_HrsPresent. |
HSCareerEd | 16.2.0 | Varchar2(3) | H.S. Career Ed. Student. Migrated from [Students]MO_HSCareerEd. |
| ICAP | 21.5.3 | Varchar2(1) | Indicator for Individual Career and Academic Plans |
| ICAP_Review | 21.5.3 | Varchar2(1) | Indicator for Individual Career and Academic Plans Review |
Immigrant | 16.2.0 | Varchar2(1) | Immigrant Status. Migrated from [Students]MO_Immigrant. |
IRC | 16.2.0 | Varchar2(10) | Industry Recognized Credential (IRC). Migrated from [Students]MO_IRC. |
K8_GraduateCode | 16.2.0 | Varchar2(6) | K-8 Graduate District Code. Migrated from [Students]MO_K8_GraduateCode. |
Kindergarten | 16.2.0 | Varchar2(2) | Kindergarten Enrollment. Migrated from [Students]MO_Kindergarten. |
| KG_Cognition_GenKnowledge | 21.9.1 | Varchar2(1) | Kindergarten Cognition General Knowledge |
| KG_Language_Literacy | 21.9.1 | Varchar2(1) | Kindergarten Language Literacy |
| KG_Learning_Approach | 21.9.1 | Varchar2(1) | Kindergarten Learning Approach |
| KG_Physical_Wellness_Motor | 21.9.1 | Varchar2(1) | Kindergarten Physical Wellness Motor |
| KG_Social_Emotional | 21.9.1 | Varchar2(1) | Kindergarten Social Emotional |
| Kinder_Readiness | 17.7.0 | Varchar2(2) | Kindergarten Readiness. Indicates whether a kindergarten student is prepared in key dimensions of early learning and development. |
Kinder_Readiness_Determination | 18.2.0 | Varchar2(50) | The method used to determine the student's Kindergarten readiness. |
LEPELL | 16.2.0 | Varchar2(3) | ELL Status. Migrated from [Students]MO_LEPELL. |
MAPAlternate | 16.2.0 | Number(1,0) | MAP-Alternate. Migrated from [Students]MO_MAPAlternate. |
MembPercent | 16.2.0 | Number(25,10) | Membership Percentage (for FTE). Migrated from [Students]MO_MembPercent. |
MigrantStatus | 16.2.0 | Varchar2(2) | Migrant Status. Migrated from [Students]MO_MigrantStatus. |
MilitaryConnected | 15.6.4 | Varchar2(4) | Student or Family Military Status. |
Months_USA | 16.2.0 | Number(11,0) | Override Number of Months in USA. Migrated from [Students]MO_Months_USA. |
MOPreKProject | 15.6.4 | Number(1,0) | Missouri PreSchool Project (MPP). |
| Neglected or Delinquent | 18.8.0 | Varchar2(3) | Neglected or Delinquent status. |
NonTradStudent | 16.2.0 | Number(1,0) | Non-Traditional Student. Migrated from [Students]MO_NonTradStudent. |
NSCComment | 16.2.0 | Varchar2(256) | National Student Clearinghouse Comment. Migrated from [Students]MO_NSCComment. |
OptionProgram | 16.2.0 | Number(1,0) | Missouri Option Program. Migrated from [Students]MO_OptionProgram. |
OtherBarrier | 16.2.0 | Number(1,0) | Other Barriers. Migrated from [Students]MO_OtherBarrier. |
OverrideGPA | 16.2.0 | Number(25,10) | Override GPA . Migrated from [Students]MO_OverrideGPA. |
Perkins | 16.2.0 | Number(1,0) | Perkins Concentrator. Migrated from [Students]MO_Perkins. |
| PK_Eligible_State_Aid | 17.7.0 | Varchar2(2) | PK Eligible State Aid. Indicates whether an eligible district has selected a PK student who participates in the free and reduced lunch program to have attendance hours claimed for state aid. |
| PK_Replacement_ID | 20.9.2.0 | Varchar2(10) | MOSIS ID for the PK, PKA, PKP student already claimed for state aid that this PK, PKA, PKP student is replacing. |
PlacementCode | 16.2.0 | Varchar2(4) | SPED Placement Code. Migrated from [Students]MO_PlacementCode. |
PlacementZIP | 16.2.0 | Varchar2(5) | Placement ZIP Code (employer, military base, educ. Institution). Migrated from [Students]MO_PlacementZIP. |
| Pre_Kindergarten | 18.10.0 | Varchar2(1) | Indicates new grade level of Pre-Kindergarten type. |
PrimarySpokenLanguage | 16.2.0 | Varchar2(3) | Primary Spoken Language. Migrated from [Students]MO_PrimarySpokenLanguage. |
RemHrsAttended | 16.2.0 | Number(25,10) | Regular Hrs Attended. Migrated from [Students]MO_RemHrsAttended. |
ResidencyStatus | 16.2.0 | Varchar2(2) | Residency Status. Migrated from [Students]MO_ResidencyStatus. |
SchoolChoice | 16.2.0 | Varchar2(1) | School Choice. Migrated from [Students]MO_SchoolChoice. |
SchoolofResidence | 16.2.0 | Varchar2(4) | School of Residence ID. Migrated from [Students]MO_SchoolofResidence. |
SingleParent | 16.2.0 | Number(1,0) | Single Parent. Migrated from [Students]MO_SingleParent. |
SPEDExit_Code | 14.9.3 | Varchar2(2) | SPED Exit Code. |
SPEDExit_Date | 14.9.3 | Date | SPED Exit Date. |
SPEDMetDefinition | 16.2.0 | Varchar2(1) | SPED Follow-up Definition Met. Migrated from [Students]MO_SPEDMetDefinition. |
SuppEdService | 16.2.0 | Varchar2(1) | Supplemental Education Service. Migrated from [Students]MO_SuppEdService. |
TechLiteracy | 16.2.0 | Varchar2(1) | 8th Grade Tech Literacy. Migrated from [Students]MO_TechLiteracy. |
TitleI | 16.2.0 | Number(1,0) | Title I. Migrated from [Students]MO_TitleI. |
TitleIII | 16.2.0 | Number(1,0) | Title III. Migrated from [Students]MO_TitleIII. |
TitleIIIImmigrant | 16.2.0 | Varchar2(2) | Title III Immigrant. Migrated from [Students]MO_TitleIIIImmigrant. |
TitleIIILEP | 16.2.0 | Varchar2(2) | Title III LEP. Migrated from [Students]MO_TitleIIILEP. |
Truant | 16.2.0 | Number(1,0) | Truant. Migrated from [Students]MO_Truant. |
UpperBodyStr | 16.2.0 | Varchar2(10) | Upper Body Strength. Migrated from [Students]MO_UpperBodyStr. |
VolTransfer | 16.2.0 | Number(1,0) | Voluntary Transfer. Migrated from [Students]MO_VolTransfer. |
| StackableCred1 | 21.4.2 | Varchar2(10) | "Stackable Credential 1" dropdown field on student career ed page |
| StackableCred1 | 21.4.2 | Varchar2(10) | "Stackable Credential 2" dropdown field on student career ed page |
| BiliteracyLang1 | 21.5.3 | Varchar2(30) | Option for Seal of Biliteracy Language 1 |
| BiliteracyLang2 | 21.5.3 | Varchar2(30) | Option for Seal of Biliteracy Language 2 |
| BiliteracyLang3 | 21.5.3 | Varchar2(30) | Option for Seal of Biliteracy Language 3 |
| Credits_Earned | 22.9.2.0 | Number(25,10) | Calculates the Credit earned for the student |
| Quality_Pre_K | 23.9.1 | Varchar2(1) | Missouri Quality Pre-Kindergarten (MOQPK) |
| Reading_Success_Plan | 23.9.1 | Varchar2(1) | Reading Success Plan (RSP) |
| RSP_Primary_Intervention | 23.9.1 | Varchar2(10) | RSP Primary Intervention |
| RSP_Primary_Support | 23.9.1 | Varchar2(16) | RSP Primary Support |