Skip to main content
Skip table of contents

Student Core File Layout

Many fields report different values based on which submission you are processing. 

  • For all submissions other than the June submission, data is pulled if the collection data is between the program's start date and the program's end date
  • For the June submission, data is pulled if any of the dates from the program's start date through the program's end date fall in between the Collection from date to the Collection Date
Field #Field NameData TypeField LengtheSchoolPLUS table.columnValidationWhere in eSchoolPLUS?
5Collection VersionText50Calculated  
10Current School YearInteger4The ending year of the current school year. For example, use '2017' for the 2016-2017 school year.  This data is entered from the user page to create Submission.Required for all submisisons
Format=YYYY		 
15Attending District CodeText6reg_programs.program_value where state_code_equiv = 'ATTDIST'

if there is no value, use

REG_DISTRICT.DISTRICT		REG_DISTRICT.STATE_CODE_EQUIVALENT where program_value = REG_DISTRICT.DISTRICTRegistration > Entry & Reports > Student Demographic > Registration: Attending District field

Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Attending District field

Values selected based on Submission
20Attending School CodeText4reg_programs.program_value where program_id and field_number maps to reg_program_column.state_code_equiv='ALTBLDG'

If no value is found, then Reporting Building Code value.		REG_BUILDING.STATE_CODE_EQUIVALENT where program_value = REG_BUILDING.BUILDING

Registration > Entry & Reports > Student Demographic > Registration: Alt Accountability Building field

Value can also be updated from Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Attending Building

Values selected based on Submission

 

If Residency Status = R1, FL, NR, DI or PT Attending School and Reporting School must be the same code.
 
If Residency Status = R2, Reporting School and Resident School must be the same code.

25Reporting District CodeText6Left 6 digits of

reg_programs.program_value where state_code_equiv = 'MORPTBDG'



if there is no value, use



REG_ENTRY_WITH.DISTRICT		REG_DISTRICT.STATE_CODE_EQUIVALENT where program_value = REG_DISTRICT.DISTRICTAdministration > General Setup > District > District: State Equivalency Code Field
30Reporting School CodeText4

Right 4 digits of

reg_programs.program_value where state_code_equiv = 'MORPTBDG'



if there is no value, use



REG_ENTRY_WITH.BUILDING		REG_BUILDING.STATE_CODE_EQUIVALENT where program_value = REG_BUILDING.BUILDING

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel:  Building

If Residency Status = R1, FL, NR, DI or PT Attending School and Reporting School must be the same code.
 
If Residency Status = R2, Reporting School and Resident School must be the same code.

35Resident District CodeText6For R2,NR,DI Residency

REG.home_district

otherwise use the reporting school

For R1

use reporting district

For FL

use attending district 		REG_DISTRICT.STATE_CODE_EQUIVALENT where program_value = REG_DISTRICT.DISTRICTRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  Resident District/School first 6 characters
40Resident School CodeText4For R1,FL,DI Residency



Right 4 digits ofreg_programs.program_value where state_code_equiv = 'RESBDG'

convert buidling to REGTB_STATE_BLDG.STATE_CODE_EQUIV



otherwise use the reporting school



For R2, NR



use reporting building		REG_BUILDING.STATE_CODE_EQUIVALENT where program_value = REG_BUILDING.BUILDINGRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  Resident District/School last 4 characters

Values selected based on Submission
45Teacher Name (Pre-Code Sort)Text40  From the Download Prompt
50MOSIS Student IDText10REG_PERSONAL.state_report_id Registration > Entry & Reports > Student Demographic > Personal > General panel:  State Reporting ID
55Local Student IDText20REG_ENTRY_WITH.student_id Student ID
60Legal Last NameText60if REG_LEGAL_INFO.LEGAL_FIRSTNAME exists
use

REG_LEGAL_INFO.LEGAL_LAST_NAME

else

REG.LAST_NAME		 Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Last Name
65Legal First NameText60if REG_LEGAL_INFO.LEGAL_FIRSTNAME exists
use

REG_LEGAL_INFO.LEGAL_FIRST_NAME

else

REG.FIRST_NAME		 Registration > Entry & Reports > Student Demographic > Registration > Student panel:  First Name
70Legal Middle NameText60if REG_LEGAL_INFO.LEGAL_FIRSTNAME exists
use

REG_LEGAL_INFO.LEGAL_MIDDLE_NAME

else

REG.MIDDLE_NAME		 Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Middle Name
75Legal Name SuffixText10if REG_LEGAL_INFO.LEGAL_FIRSTNAME exists
use

REG_LEGAL_INFO.LEGAL_GENERATION

else

REG.GENERATION		 Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Generation
80Date of BirthText10REG.BIRTHDATE Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Birth Date
90CountyText3reg_programs.program_value where state_code_equiv = 'COUNTY', converted to regtb_county.state_code_equiv

if there is no value, use

Left 3 characters from Residence District

else

Left 3 characters from Report District		 Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Resident District/School first 3 characters or use the Reporting District

Values selected based on Submission
95Student Grade LevelText2REG_ENTRY_WITH.gradeREG_GRADE.STATE_CODE_EQUIV where grade=codeRegistration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel:  Grade
100GenderText1if REG_LEGAL_INFO.LEGAL_FIRSTNAME exists
use

REG_LEGAL_INFO.GENDER

else

REG.GENDER		 Registration > Entry & Reports > Student Demographic > Registration > Student panel:  Gender
105Race/EthnicityText1if REG_PRESONAL.HISPANIC = "Y" then report "H" else
REG_PERSONAL.ETHNIC_CODE		REGTB_ETHNICITY.STATE_CODE_EQUIV where ethnic_code=codeRegistration > Entry & Reports > Student Demographic > Personal > Federal panel:  Hispanic/Latino Ethnicity or Race field

If a student is marked Y in the Hispanic/Latino Ethnicity field, an H will be sent in this field.  If a student is not Hispanic and has one Race, then the state equiv code of the Primary Race will be sent.  If a student is not Hispanic and has multiple races, an M is sent.  
110Lunch StatusText1reg_programs.program_value where state_code_equiv = 'MEALSTATUS'REGTB_MEAL_STATUS.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student Demographic > Personal > Educational Factors panel:  Meal Status field

Data is pulled if any of the dates from the program's start date through the program's end date fall inbetween Oct 1 previous year to the Collection Date
115GiftedBoolean1reg_programs.program_value where state_code_equiv = 'GIFTED'MOTB_GIFTED_CODES.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  Gifted field

Values selected based on Submission
120HomelessText2reg_programs.program_value where state_code_equiv = 'HOMELESS'REGTB_HOMELESS.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student Demographic > Personal > Educational Factors panel:  Homeless Status field

Values selected based on Submission
125MigrantText2reg_programs.program_value where state_code_equiv = 'MOMIGTYPE'MOTB_MIGRANT.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student Demographic > Personal > Federal panel:  Migrant field

Values selected based on Submission
130In building less than a yearBoolean1REG_ENTRY_WITH.ENTRY_DATE
REG_ENTRY_WITH.WITHDRAWAL_DATE		 If "In district less than a year" is 'Y', then
'Y'
else
 
 ‘Y for any student who was not enrolled the last Wednesday in September OR any student who was enrolled the last Wednesday in September, transfers out of the Academic Session for one more than half of the in-school/membership days between the last Wednesday in September and the Report Parameter End Date, and is re-enrolled on or before Report Parameter End Date
  Else, ‘N’.
135In district less than a yearBoolean1REG_ENTRY_WITH.ENTRY_DATE
REG_ENTRY_WITH.WITHDRAWAL_DATE		   ‘Y for any student who was not enrolled the last Wednesday in September OR any student who was enrolled the last Wednesday in September, transfers out of the Academic Session for one more than half of the in-school/membership days between the last Wednesday in September and the Report Parameter End Date, and is re-enrolled on or before Report Parameter End Date
  Else, ‘N’.
140Voluntary Transfer StudentBoolean1reg_programs.program_value where state_code_equiv = 'TRANSFER' Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Voluntary Transfer Student field

Values selected based on Submission
145A+ StudentText1reg_programs.program_value where state_code_equiv = 'APLUS''MOTB_APLUS.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  A+ Student

Values selected based on Submission
150Number of Months in USAInteger3reg_programs.program_value where state_code_equiv = 'MONTHS' 

Values selected based on Submission

Calculated using Registration - US Enrollment Date.  Or dates from the program where the state code equiv = ‘MONTHS’.

If the student is an immigrant value (Y) or LEP(MY1,MY2,RVC,NRC), add the total values from reg_v_program

If value > 36, report 36

155ImmigrantText3reg_programs.program_value where state_code_equiv = 'IMMIGRANT' 

Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Immigrant (program where the state code equiv = ‘IMMIGRANT’)

Values selected based on Submission

Program value will be Y or N

If immigrant has been in USA for over 36 months, report as N

160ELL Primary LanguageText4REG.LANGUAGEREGTB_LANGUAGE.STATE_CODE_EQUIV where language=codeRegistration > Entry & Reports > Student Demographic > Registration > Student panel:  Home Language
165LEP / ELLText3reg_programs.program_value where state_code_equiv = 'LEP/ELL'MOTB_LEP_CODE.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > MOSIS LEP/ELL: LEP/ELL (program where the state code equiv = ‘LEPELL’)
170ELL ExitText3reg_programs.program_value where state_code_equiv = 'ELLEXIT'MOTB_LEP_EXIT.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > MOSIS LEP/ELL: ELL Exit (program where the state code equiv = ‘ELLEXIT’)

Values selected based on Submission
175ELL Exit TestText3reg_programs.program_value where state_code_equiv = 'EXITTEST'MOTB_LEP_EXIT_TEST.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > MOSIS LEP/ELL: ELL Exit Test (program where the state code equiv = ‘EXITTEST’)

Values selected based on Submission
180ESOL Instructional ModelText3reg_programs.program_value where state_code_equiv = 'ESOL'MOTB_ESOL_MODEL.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > MOSIS LEP/ELL:  ESOL Instructional Model (program where the state code equiv = ‘ESOL’)

Values selected based on Submission
185Missouri Option ProgramBoolean1reg_programs.program_value where state_code_equiv = 'MOOPTION' 

Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Missouri Option Program (program where the state code equiv = ‘OPTION’)

Values selected based on Submission

 Reports Y if selected, otherwise N

Required for grades 09, 10, 11, 12.

190H.S. Career Ed studentText1reg_programs.program_value where state_code_equiv = 'CAREER'MOTB_CAREER_ED.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup:  High School Career Ed (program where the state code equiv = ‘CAREER’)

Values selected based on Submission

 If no value, use a calculation for credits earned, and for grades 11 and 12:
 
3+ credits, report CNP
1+ credits, report PHS
<1 credits, report LTO
0 credits, report NHS

195Title IBoolean1reg_programs.program_value where state_code_equiv = 'TITLEI' Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Title I (program where the state code equiv = ‘TITLEI’)

Values selected based on Submission
200Title IIIBoolean1reports blank Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Title III (program where the state code equiv = ‘TITLEIII’)
205Residency StatusText2reg_programs.program_value where state_code_equiv = 'RESIDENCY'REGTB_RESIDENCY.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student Demographic > Personal > General panel:  Residency (program where the state code equiv = ‘RESIDENCY’)
210Membership FTENumber4(2)reg_programs.program_value where state_code_equiv = 'FTE' 

Values selected based on Submission

Defaults to 1.00 unless student has value in FTE field on MOSIS Demographics screen.

If program_value doesn't have a numeric value:
 
calculate from students scheduled time divided by students total time
 
If no value or calculated value, report 1

215One Prior 10 Day AttendanceBoolean1Calculated Value based on attendance  
220Enrolled On Count DateBoolean1REG_ENTRY_WITH.ENTRY_DATE
REG_ENTRY_WITH.WITHDRAWAL_DATE		  
225Enrolled All YearBoolean1reg_programs.program_value where state_code_equiv = 'RESIDENCY'If the student was ever R2, set ot N, otherwise set to Y 
230First Year FreshmanBoolean1REG_ENTRY_WITH.GRADE convert to
REG_GRADE.STATE_CODE_EQUIV where grade=code		if the student is grade 09
and REG_ENTRY_WITH.ENTRY_WD_TYPE = 'C' (for current year)
count how many entries there are
count > 1, report N
count = 1, report Y

otherwise report N		Calculated.  If student is in grade 09 for the first time based on Entry/Withdrawal, the value is Y. 
235GPANumber6(3)MR_STU_GPA.CUR_GPAIf grade is 09 or 10 and submission is DEC or JUN
use value

If there is no value, report 0

Otherwise report blank		Mark Reporting > Entry & Reports > Student > GPA Summary:  Current GPA

Uses GPA for school year and GPA Type from prompts
240GPA ScaleInteger2MR_STU_GPA.CUR_GPAif MAX(CUR_GPA) is greater than 6, report 11
otherwise report 4		 
2458th Grade Tech LiteracyBoolean1REG_USER.FIELD_VALUE where SCREEN_NUMBER = 553 and FIELD_NUMBER=1

LTDB_STU_SUBTEST.SCORE where STATE_CODE_EQUIV='LITERACY'		For Students in grade 08, and Collection = JUN

If no value in MO_V_STU_TEST

score converted to MOTB_TESTED.STATE_CODE_EQUIV where score=code		Registration > Entry & Reports > Student District Defined > MOSIS Tests:  8th Grade Tech Literacy

or

Test Scores > All > Student > Test History by Student > click Test Date link for test defined with Subtest Score where the State Code Equiv = 'LITERACY' > In the Subtests and Scores panel, find the Subtest panel with the Score associated with the LITERACY State Code Equiv

To see a Subtest Score's State Code Equiv, select Administration > Test Scores Setup > Test Definition > click a Test's Description link > In the Subtests and Scores panel, open the panel for the subtest containing the score > In the Score Information panel, click the Edit icon for the appropriate Score Code > Score Definition panel:  State Code Equiv
250Aerobic CapacityText10REG_USER.FIELD_VALUE where SCREEN_NUMBER=553

5th grade result pulled from Fand FIELD_NUMBER=2

7th grade result pulled from Fand FIELD_NUMBER=10

9th grade result pulled from Fand FIELD_NUMBER=6

LTDB_STU_SUBTEST.SCORE where STATE_CODE_EQUIV='AEROBIC'		For Students in grade 05, 07, 09, and Collection = JUN

If no value in MO_V_STU_TEST

score converted to MOTB_PHYSICAL_FIT.STATE_CODE_EQUIV where score=code		Registration > Entry & Reports > Student District Defined > MOSIS Tests: 

5th Grade Aerobic Capacity, 7th Grade Aerobic Capacity, or 9th Grade Aerobic Capacity

or

Test Scores > All > Student > Test History by Student > click Test Date link for test defined with Subtest Score where the State Code Equiv = 'AEROBIC' > In the Subtests and Scores panel, find the Subtest panel with the Score associated with the AEROBIC State Code Equiv

To see a Subtest Score's State Code Equiv, select Administration > Test Scores Setup > Test Definition > click a Test's Description link > In the Subtests and Scores panel, open the panel for the subtest containing the score > In the Score Information panel, click the Edit icon for the appropriate Score Code > Score Definition panel:  State Code Equiv
255Abdominal StrengthText10REG_USER.FIELD_VALUE where SCREEN_NUMBER=553

5th grade result pulled from FIELD_NUMBER=3

7th grade result pulled from FIELD_NUMBER=11

9th grade result pulled from FIELD_NUMBER=7
 
LTDB_STU_SUBTEST.SCORE where STATE_CODE_EQUIV='ABDOMINAL'		For Students in grade 05, 07, 09, and Collection = JUN

If no value in MO_V_STU_TEST

score converted to MOTB_PHYSICAL_FIT.STATE_CODE_EQUIV where score=code		Registration > Entry & Reports > Student District Defined > MOSIS Tests: 

5th Grade Abdominal Strength, 7th Grade Abdominal Strength, 9th Grade Abdominal Strength

or

Test Scores > All > Student > Test History by Student > click Test Date link for test defined with Subtest Score where the State Code Equiv = 'ABDOMINAL' > In the Subtests and Scores panel, find the Subtest panel with the Score associated with the ABDOMINAL State Code Equiv

To see a Subtest Score's State Code Equiv, select Administration > Test Scores Setup > Test Definition > click a Test's Description link > In the Subtests and Scores panel, open the panel for the subtest containing the score > In the Score Information panel, click the Edit icon for the appropriate Score Code > Score Definition panel:  State Code Equiv
260Upper Body StrengthText10REG_USER.FIELD_VALUE where SCREEN_NUMBER=553

5th grade result pulled from FIELD_NUMBER=4

7th grade result pulled from FIELD_NUMBER=12

9th grade result pulled from FIELD_NUMBER=8

LTDB_STU_SUBTEST.SCORE where STATE_CODE_EQUIV='UPPERBODY'		For Students in grade 05, 07, 09, and Collection = JUN

If no value in MO_V_STU_TEST

score converted to MOTB_PHYSICAL_FIT.STATE_CODE_EQUIV where score=code		Registration > Entry & Reports > Student District Defined > MOSIS Tests:

5th Grade Upper Body Strength, 7th Grade Upper Body Strength, 9th Grade Upper Body Strength

or

Test Scores > All > Student > Test History by Student > click Test Date link for test defined with Subtest Score where the State Code Equiv = 'UPPERBODY' > In the Subtests and Scores panel, find the Subtest panel with the Score associated with the UPPERBODY State Code Equiv

To see a Subtest Score's State Code Equiv, select Administration > Test Scores Setup > Test Definition > click a Test's Description link > In the Subtests and Scores panel, open the panel for the subtest containing the score > In the Score Information panel, click the Edit icon for the appropriate Score Code > Score Definition panel:  State Code Equiv
265FlexibilityText10REG_USER.FIELD_VALUE where SCREEN_NUMBER=553

5th grade result pulled from FIELD_NUMBER=5

7th grade result pulled from FIELD_NUMBER=13

9th grade result pulled from FIELD_NUMBER=9

LTDB_STU_SUBTEST.SCORE where STATE_CODE_EQUIV='FLEXIBLE'		For Students in grade 05, 07, 09, and Collection = JUN

If no value in MO_V_STU_TEST

score converted to MOTB_PHYSICAL_FIT.STATE_CODE_EQUIV where score=code		Registration > Entry & Reports > Student District Defined > MOSIS Tests:

5th Grade Flexibility, 7th Grade Flexibility, 9th Grade Flexibility

or

Test Scores > All > Student > Test History by Student > click Test Date link for test defined with Subtest Score where the State Code Equiv = 'FLEXIBLE' > In the Subtests and Scores panel, find the Subtest panel with the Score associated with the FLEXIBLE State Code Equiv

To see a Subtest Score's State Code Equiv, select Administration > Test Scores Setup > Test Definition > click a Test's Description link > In the Subtests and Scores panel, open the panel for the subtest containing the score > In the Score Information panel, click the Edit icon for the appropriate Score Code > Score Definition panel:  State Code Equiv
270IEP DisabilityText2reg_programs.program_value where state_code_equiv = 'IEPDISAB'MOTB_DISABILITY.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  IEP Disability (program where the state code equiv = ‘IEPDISAB’)

Data is pulled if any of the dates from the program's start date through the program's end date fall in between the First Day of School to the Collection Date

If there is a SPED exit date, take the most recent record from the start of the school year to the collection date
 
otherwise, take the most recent record (can be from a previous year)

275MAP-AlternateBoolean1reg_programs.program_value where state_code_equiv = 'IEPMAPA'default value NRegistration > Entry & Reports > Student District Defined > MOSIS Special Ed:  MAP Alternate (program where the state code equiv = ‘IEPMAPA’)

Values selected based on Submission
280Special Education PlacementText4reg_programs.program_value where state_code_equiv = 'SPEDPLACE'MOTB_SPED_PLACEMNT.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  SPED Placement (program where the state code equiv = ‘SPEDPLACE’)

Data is pulled if any of the dates from the program's start date through the program's end date fall inbetween the First Day of School to the Collection Date

If there is a SPED exit date, take the most recent record from the start of the school year to the collection date
 
otherwise, take the most recent record (can be from a previous year)

285SPED Program Exit CodeText2reg_programs.program_value where state_code_equiv = 'SPEDEXIT'MOTB_SPED_EXIT.STATE_CODE_EQUIV where program_value=code

if not code 01,17, report blank		Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  SPED Exit Code (program where the state code equiv = ‘SPEDEXIT’)

Data is pulled if any of the dates from the program's start date through the program's end date fall inbetween the First Day of School to the Collection Date

If the End Date for this program falls on or prior to the MOSIS Download Collection Date in the year you are processing, the download leaves SPED Program Exit Code blank.
286TruantBoolean1sum(att_value) from att_stu_day_totalsif Submission= JUN, and Grade <> PK

if program_value >= 10 report T, otherwise report N		For June Collection only.  Calculated from the Truancy Attendance View using the Truant Absent Code from the MOSIS Download prompts.
288Supplemental Education ServiceText1reg_programs.program_value where state_code_equiv = 'SUPPLEED'MOTB_SUPPLE_ED.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  Supplemental Ed Services (program where the state code equiv = ‘SUPPLEED’)

Values selected based on Submission
290Career ClusterText2REG_USER.FIELD_VALUE where SCREEN_NUMBER=552 and FIELD_NUMBER=5values choosen from MOTB_CTE_CLUSTERRegistration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup:  Career Education Cluster
292Nontraditional Student (Secondary)Boolean1reg_programs.program_value where state_code_equiv = 'NONTRAD'reported as Y or N
defaults to N for CAREERED(CHS,CTP,PHS,PTP)
reports blank for all others		Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup:  Nontraditional Student (program where the state code equiv = ‘NONTRAD’)

Values selected based on Submission
294Single Parent (Secondary)Boolean1reported as blank Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup:  Single Parent (program where the state code equiv = ‘PARENT’)
296Displaced Homemaker (Secondary)Boolean1reported as blank Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup:  Displaced Homemaker (program where the state code equiv = ‘DISPLACED’)
298CTE Technical Skills AttainmentsText2REG_USER.FIELD_VALUE where SCREEN_NUMBER=552 and FIELD_NUMBER=6MOTB_CTE_SKILLSRegistration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: CTE Technical Skill Attainment field
300K-8 Graduate District CodeText6REG_USER.FIELD_VALUE where SCREEN_NUMBER=551 and FIELD_NUMBER=15if value is >6 characters, report the left 6 characters, otherwise report blankRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  K-8 Graduate District Code field
302ECO Entry DateText10reg_programs.STARTE_DATE where state_code_equiv = 'MOECSE' 

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program ECSE Program Start Date field

Values selected based on Submission

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

304ECO Entry Indicator 1Text1reg_programs.program_value where state_code_equiv = 'MOECSE1'MOTB_ECSE_CODES.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program – ECSE Code Social Behavior Value field)

Values selected based on Submission

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

306ECO Entry Indicator 2Text1reg_programs.program_value where state_code_equiv = 'MOECSE2'MOTB_ECSE_CODES.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program – ECSE Code Knowledge and Skills Value field)

Values selected based on Submission

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

308ECO Entry Indicator 3Text1reg_programs.program_value where state_code_equiv = 'MOECSE3'MOTB_ECSE_CODES.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program – ECSE Code Appropriate Behaviors Value field)

Values selected based on Submission

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

310ECO Exit DateText10reg_programs.END_DATE where state_code_equiv = 'MOECSE' 

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program – ECSE Program End Date field)

Values selected based on Submission

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

312ECO Exit Indicator 1Text1reg_programs.program_value where state_code_equiv = 'MOECSE1'MOTB_ECSE_CODES.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program – ECSE Code Social Behavior End Reason field)

Values selected based on Submission

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

314ECO Exit Indicator 2Text1reg_programs.program_value where state_code_equiv = 'MOECSE2'MOTB_ECSE_CODES.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program – ECSE Code Knowledge and Skills End Reason field)

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

316ECO Exit Indicator 3Text1reg_programs.program_value where state_code_equiv = 'MOECSE3'MOTB_ECSE_CODES.STATE_CODE_EQUIV where program_value=code

Registration > Entry & Reports > Student District Defined > MOSIS Special Ed:  ESCE Program (MODEM Program – ECSE Code Appropriate Behaviors End Reason field)

Values selected based on Submission

If submission= JUN, then Entry Date must be greater that June 30 of current year, and must be before the exit date, and must be less than July 1 of current year, otherwise report blank

318CTE Program CodeText4REG_USER.FIELD_VALUE where SCREEN_NUMBER=552 and FIELD_NUMBER=2MOTB_CTE_PROGRAMRegistration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup:  Primary CTE Program
320Title III LEPText2reg_programs.program_value where state_code_equiv = 'T3LEP'MOTB_TITLE3_FUNDRegistration > Entry & Reports > Student District Defined > MOSIS LEP/ELL: Title III LEP

Values selected based on Submission
321Title III ImmigrantText2reg_programs.program_value where state_code_equiv = 'T3IMM'MOTB_TITLE3_FUNDRegistration > Entry & Reports > Student District Defined > MOSIS Demographics: Title III Immigrant 
322First Freshman YearInteger4REG_ACADEMIC.FEDERAL_GRAD_YEAR Registration > Entry & Reports > Student Demographic > Academic > Graduation panel:  First Freshman School Year (Federal Graduation)

This is an optional field.

Report for students beginning in the 2013 school year for Grade 9 and higher.
323Zip CodeInteger9REG_CONTACT.ZIP inner join REG_CONTACT on reg_stu_contact.contact_id = reg_contact.contact_id where CONTACT_TYPE = 'P' If the student's physical address matches the mailing address, Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Mailing Address panel:  Zip Code

If the student's physical address differs from the mailing address, Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Additional Options icon in Addresses panel bar > Different Physical Address > Physical Address panel:  Zip Code
324Industry Recognized CredentialText10REG_USER.FIELD_VALUE where SCREEN_NUMBER = 556 and FIELD_NUMBER = 1 Registration > Entry & Reports > Student District Defined > MOSIS Industry Recognized Credential:  Industry Recognized Credential
325MilitaryText3reg_programs.program_value where state_code_equiv = 'MILITARY'STATETB_MILITARY.STATE_CODE_EQUIV where program_value=codeRegistration > Entry & Reports > Student District Defined > Military Connected Status: Military Connected Status field

Values selected based on Submission
326MPPText3REG_USER.FIELD_VALUE where SCREEN_NUMBER=551 and FIELD_NUMBER=24 Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  MPP field
327FosterCareBoolean1reg_programs.program_value where state_code_equiv = 'FOSTER' Values selected based on Submission
328PK Eligible State AidBoolean1REG_USER.FIELD_VALUE where SCREEN_NUMBER=551 and FIELD_NUMBER=27 Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  PK Eligible State Aid field
329Kindergarten ReadinessBoolean1REG_USER.FIELD_VALUE where SCREEN_NUMBER=551 and FIELD_NUMBER=28 Registration > Entry & Reports > Student District Defined > MOSIS Demographics:  Kindergarten Readiness field
330High Need StudentBoolean1reg_programs.program_value where state_code_equiv = "MOHIGHNEED"motb_high_needRegistration > Entry & Reports > Student District Defined > MOSIS Special Ed:  (IEP) High Need Student
331DyslexiaText3reg_programs.program_value where state_code_equiv = "MODYSLEXIA"motb_dyslexiaRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  Dyslexia field
332Neglected or DelinquentText3reg_programs.program_value where state_code_equiv = "MONEGLECT"motb_neglected_delinquentRegistration > Entry & Reports > Student District Defined > MOSIS Demographics:  Neglected or Delinquent field



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close