Enrollment and Demographics
This category captures the core student demographic record and contains identifying information as published in the student resource. The Student Demographics category includes the following data views and resources:
Each student must first have an assigned Unique Person Identifier (MARSS Number) in order for the enrollments and demographics record to be published.
School Enrollment (studentSchoolAssociations)
This resource represents the enrollments of a student into schools within PowerSchool. Records can be standard enrollments in a school or Dual Enrollments pages
Primary PowerSchool Source Data
- [Students / ReEnrollments]
- [S_MN_STU_X / S_MN_REN_X]
Selection Criteria
Records are published if the following criteria are met:
- The studentUniqueId (MARSS Number) must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student's school of enrollment must not be excluded from state reporting.
- The student must have at least one school enrollment with an Entry Date that falls within the date range defined by [Terms]FirstDay and [Terms]LastDay for the year of the Term selected in the PowerSchool UI.
- The enrollment exit date is greater than the entry date.
Dual/Concurrent Enrollment Records
Dual/Concurrent records are published for students who have the Concurrent/Dual Enrolled checkbox marked and the School Number is a valid school within the PowerSchool database.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
schoolReference / schoolId | A reference to the related school. | String | Determined by the school that the data is being generated for. | R |
schoolYearTypeReference / schoolYear | The school year associated with the calendar recorded as the later calendar year of the school year. For example, the 2019-2020 school year is recorded as 2020. | String | Determined by the term selected on the PowerSchool screen. | R |
studentReference / studentUniqueId | A unique number or alphanumeric code assigned to a student by a state education agency. | String | [Students]State_StudentNumber | R |
| entryDate | The student's entry date into school. | Date-time | The source can be one of 4 places based on the record: | R |
| entryGradeLevelDescriptor | The student's grade level. | String | [Students]Grade_Level [ReEnrollments]Grade_Level | R |
| entryTypeDescriptor | The students entry type into school. | String | The source can be one of 4 places based on the record: [Students]EntryCode [ReEnrollments]EntryCode If the Dual Enrollment checkbox is marked, then: [S_MN_STU_X]Dual_Enroll_Entry_Code [S_MN_REN_X]Dual_Enroll_Entry_Code | R |
| exitWithdrawDate | The student's exit date from school. | Date-time | The source can be one of 4 places based on the record: [Students]ExitDate - 1 [ReEnrollments]ExitDate - 1 If the Dual Enrollment checkbox is marked, then: [S_MN_STU_X]Dual_Enroll_Exit_Date - 1 [S_MN_REN_X]Dual_Enroll_Exit_Date - 1 | O |
| exitWithdrawTypeDescriptor | The student's exit type from school. | String | The source can be one of 4 places based on the record: [Students]ExitCode [ReEnrollments]ExitCode If the Dual Enrollment checkbox is marked, then: [S_MN_STU_X]Dual_Enroll_Exit_Code [S_MN_REN_X]Dual_Enroll_Exit_Code | O |
Minnesota Extensions ( _ext / MN ) The following are extensions added to the Ed-Fi Specification specific to Minnesota. | R | |||
| specialEducationEvaluationStatusDescriptor | The Special Education Evaluation Status of a student. If the value is 8 or 9, then this is not published. | String | The source can be one of 4 places based on the record: [S_MN_STU_X]Sped_Eval_Status [S_MN_REN_X]Sped_Eval_Status If the Dual Enrollment checkbox is marked, then: [S_MN_STU_X]Dual_Enroll_SPED_Status [S_MN_REN_X]Dual_Enroll_SPED_Status | O |
| stateAidCategoryDescriptor | The State Aid Category of a student. | String | The source can be one of 4 places based on the record: [S_MN_STU_X]State_Aid_Cat [S_MN_REN_X]State_Aid_Cat If the Dual Enrollment checkbox is marked, then: [S_MN_STU_X]Dual_Enroll_ST_Aid_Cat [S_MN_REN_X]Dual_Enroll_ST_Aid_Cat | R |
| homeboundServiceIndicator | The Home Bound Service Indicator. | Boolean | [S_MN_STU_X]Homebound_Service [S_MN_REN_X]Homebound_Service | R |
| specialPupilIndicator | The Special Pupil for Care and Treatment indicator. | Boolean | [S_MN_STU_X]Ward_of_State [S_MN_REN_X]Ward_of_State | R |
| residentLocalEducationAgencyReference / localEducationAgencyId | The District Of Residence for a student. | Integer | [Students]DistrictOfResidence [ReEnrollments]DistrictOfResidence | R |
| membership / membershipAttendanceUnitDescriptor | An indicator of the membership units being used. Valid values are Days and Hours. If Percent Enrolled is 999 or 998 or Homebound is Yes and Membership Hours is populated, then Hours will be published. Otherwise, Days will be published. This applies to all fields for standard and dual enrollments. | String | The following fields are used based on the logic given: [S_MN_STU_X]Percent_Enrolled [S_MN_STU_X]Homebound_Service [S_MN_STU_X]Membership_Hours [S_MN_STU_X]Dual_Enroll_Pct_Enrolled [S_MN_STU_X]Dual_Enroll_Mem_Hours [S_MN_REN_X]Percent_Enrolled [S_MN_REN_X]Membership_Hours [S_MN_REN_X]Dual_Enroll_Pct_Enrolled [S_MN_REN_X]Dual_Enroll_Mem_Hours | R |
| membership / attendance | The totals days in attendance for the student from the entry date to the exit date. | Integer | If the membershipAttendanceUntiDescriptor is Hours, then the following fields will be published as entered: [S_MN_STU_X]Attendance_Hours [S_MN_STU_X]Dual_Enroll_Att_Hours [S_MN_REN_X]Attendance_Hours [S_MN_REN_X]Dual_Enroll_Att_Hours When membershipAttendanceUntiDescriptor is Days, then the sum of the attendance values from the ADA/ADM setup will be used. | R |
| membership / membership | The total days in membership for the student from the entry date to the exit date. | Integer | If the membershipAttendanceUntiDescriptor is Hours, then the following fields will be published as entered: [S_MN_STU_X]Membership_Hours [S_MN_STU_X]Dual_Enroll_Mem_Hours [S_MN_REN_X]Membership_Hours [S_MN_REN_X]Dual_Enroll_Mem_Hours When membershipAttendanceUntiDescriptor is Days, then the sum of the membership values from the ADA/ADM setup will be used. | R |
| membership / percentEnrolled | The Percent Enrolled for a student. | Integer | [S_MN_STU_X]Percent_Enrolled [S_MN_STU_X]Dual_Enroll_Pct_Enrolled [S_MN_REN_X]Percent_Enrolled [S_MN_REN_X]Dual_Enroll_Pct_Enrolled | R |
| transportation / transportationCategoryDescriptor | The Transportation Category given for the student. | String | [S_MN_STU_X]Transportation_Category [S_MN_REN_X]Transportation_Category | R |
| transportation / transportingLocalEducationAgencyReference / localEducationAgencyId | The Transporting District given for the student. | Integer | [S_MN_STU_X]Transporting_Dist_Number [S_MN_REN_X]Transporting_Dist_Number | O |
School Demographics (studentEducationOrganizationAssociations)
This resource represents the demographics of a student into schools within PowerSchool. One record will be published for each school the student is associated with either with a standard enrollment or a dual enrollment.
Primary PowerSchool Source Data
- [Students / ReEnrollments]
- [S_MN_STU_X / S_MN_REN_X]
- [S_STU_X / S_REN_X]
Selection Criteria
Records are published if the following criteria are met:
- The studentUniqueId (MARSS Number) must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student's school of enrollment must not be excluded from state reporting.
- The student must have at least one school enrollment with an Entry Date that falls within the date range defined by [Terms]FirstDay and [Terms]LastDay for the year of the Term selected in the PowerSchool UI.
- The enrollment exit date is greater than the entry date.
Dual/Concurrent Enrollment Records
Dual/Concurrent records are published for students who have the Concurrent/Dual Enrolled checkbox marked and the School Number is a valid school within the PowerSchool database.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
educationOrganizationReference / educationOrganizationId | A reference to the related school. | String | Determined by the school that the data is being generated for. | R |
studentReference / studentUniqueId | A unique number or alphanumeric code assigned to a student by a state education agency. | String | [Students]State_StudentNumber | R |
| hispanicLatinoEthnicity | Hispanic Yes/No flag for a student. | Boolean | [Students]Fedethnicity | O |
| languages / languageDescriptor | The Home Primary Language of a student. | String | [StudentCoreFields]PrimaryLanguage | O |
| languages / languageDescriptor / uses / languageUseDescriptor | Hardcoded to 'Home language'. | String | Hardcoded to 'Home Language'. | O |
| races / raceDescriptor | An array of races for a student. | String | A value is published for each race category that a student has a race selected. | O |
| sexDescriptor | A person’s birth gender: Female or Male. | String | [StudentCoreFields]PSCore_Legal_Gender if populated. Otherwise: [Students]Gender | O |
studentCharacteristics array (0-6) A list of student characteristics. | ||||
| studentCharacteristicDescriptor | An array of characteristics for a student. | String | If an American Indian race is checked other than Unknown or South/Central America, then send 'American Indian - Alaskan Native (Minnesota)'. If [S_MN_STU_X / S_MN_REN_X]Migrant_Indicator = 'Y', then 'Migrant'. If [S_STU_X / S_REN_X]ActiveDutyParent = 'Y', then 'Active Duty Parent (ADP)'. If [S_STU_X / S_REN_X]Immigrant = 'Y', then 'Immigrant'. If [S_STU_X / S_REN_X]RAEL = 'Y', then 'Recently Arrived English Learner (RAEL)'. If [S_MN_STU_X / S_MN_REN_X]SLIFE = 'Y', then 'SLIFE'. | O |
| studentIdentificationCodes / studentIdentificationSystemDescriptor | Two values will be published. Hardcoded to 'State' or 'Local'. | String | Hardcoded to 'State' or 'Local'. | R |
| studentIdentificationCodes / assigningOrganizationIdentificationCode | Two values will be published. Value of 'MARSS' for the state ID and the value of the District ID for the Local ID. | String | R | |
| studentIdentificationCodes / identificationCode | Two values will be published. | String | [Students]State_StudentNumber [Students]Student_Number | R |
Minnesota Extensions ( _ext / MN ) The following are extensions added to the Ed-Fi Specification specific to Minnesota. | ||||
| birthDate | The month, day, and year on which an individual was born. | Date-time | [Students]DOB | R |
| firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | String | [S_MN_STU_X]State_First_Name if populated. Otherwise: [Students]First_Name. | R |
| middleName | A middle name given to a student at birth, baptism, during another naming ceremony, or through legal change. | String | [S_MN_STU_X]State_Middle_Name is populated. Otherwise: [Students]Middle_Name. | O |
| lastSurname | The name borne in common by members of a family. | String | [S_MN_STU_X]State_Last_Name if populated. Otherwise: [Students]Last_Name. | R |
| generationCodeSuffix | The generation suffix given to a student at birth, baptism, during another naming ceremony, or through legal change. | String | [S_MN_STU_X]State_Suffix | O |
| ancestryEthnicOrigins | An array of Ancestry Ethnic Origin values. | String | [StudentRaces]RaceCd This element is a list of all of the Ancestry Ethnic Origins that have been checked for a student. | O |
| optOutIndicators / optOutIndicatorsDescriptor | The Minnesota Care Opt Out for a student. | String | [S_MN_STU_X]Opt_Out_MN_Care | O |