Skip to main content
Skip table of contents

Student 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 (Wisconsin State Number/WISEid) in order for the student record to be published. In turn, the publishing of all other student-related Ed-Fi data is dependent on the successful publishing of the student record; as needed, use the "Publishing Errors" data view to identify and resolve any issues.

Student Demographics

This view captures the core student demographic record and contains identifying information as published in the Student resource. For each student enrolled in the district in the current year, the published view layout provides the School Name, Student Number, Student Name, Gender, Grade Level, Wisconsin Student Number, Last Publish Date, and the Publishing ID.

student

This resource represents an individual for whom instruction, services, and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency, or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

Primary PowerSchool Source Data

  • [Students]

  • [S_WI_STU_X]

Selection Criteria

Records are published if the following criteria are met:

  • The studentUniqueId (Wisconsin Student Number/WISEid) 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.

Resource Output

  • A student record is published for each student who meets the selection criteria, and who is enrolled in the district in the year for the Term selected in the PowerSchool UI.

  • The student resource is not dependent on the prior publishing of other Ed-Fi resources.

Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record in Student Enrollments category has been uploaded for the same student.

    • This establishes a relationship between the school, the associated LEA, and the student.

    • The LEA then has permission to modify the previously uploaded student record.

  • LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

String

[Students]State_StudentNumber

R

firstName

A name given to an individual at birth, baptism, during another naming ceremony, or through legal change.

String

[StudentCoreFields]PS_Core_Legal_First_Name if populated

Otherwise: [Students]First_Name

R

lastSurname

The name borne in common by members of a family.

String

[StudentCoreFields]PS_Core_Legal_Last_Name if populated

Otherwise: [Students]Last_Name

R

sexType

A person’s gender: Female or Male.

String

[StudentCoreFields]PS_Core_Legal_Gender if populated

Otherwise: [Students]Gender

  • M: 'Male'

  • F: 'Female' (Default)

R

birthDate

The month, day, and year on which an individual was born.

Date-time

[Students]DOB

R

dateEnteredUS

For students born outside of the US, the date the student entered the US. 

*If applicable to the student, this element is required.

Date-time

[Students]DateOfEntryIntoUSA

O*

hispanicLatinoEthnicity

An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."

Boolean

[Students]FedEthnicity

If blank, derived from:

[StudentRace]RaceCD

[Gen]Name where cat=’federalrace’

If Federal Ethnicity = 1 or Race Code = HI, ‘true’ is published; else, ‘false’

R

economicDisadvantaged

An indication of inadequate financial condition of an individual's family, as determined by family income, number of family members/dependents, participation in public assistance programs, and/or other characteristics considered relevant by federal, state, and local policy.

Boolean

[S_WI_STU_X]Economic_Status

If blank, derived from:

[Students]LunchStatus

  • F, R, A, or FDC: ‘true’

  • Else: ‘false’

R

schoolFoodServicesEligibilityDescriptor

An indication of a student's level of eligibility for school food programs.

*This element is required if  economicDisadvantage = ‘True’; otherwise, it is excluded from publishing.

String

[S_WI_STU_X] Economic_Status

If blank, derived from:

[Students]LunchStatus

  • F: '01'

  • FDC: '01'

  • A: ‘03’

  • N: '02'

  • R: '03'

  • E: ‘01’

  • Default: '04'

R*

limitedEnglishProficiencyDescriptor

An indication that the student has been identified as limited English proficient.

String

[S_WI_STU_X]EnglishProfCode

PowerSchool codes 1-7 are mapped to the corresponding descriptor short code numeric value.

R

characteristics – studentCharacteristics array (0-many)

O

/studentCharacteristicDescriptor

The source of data for the following elements is corrected:

  • BiLit

  • CivicEngage

  • FineArts

  • Skills

Reflects important characteristics of a student, such as Fine Arts, Civic Engagement, International Skills diploma, and so on.

The values are taken from the General Info tab on the Georgia State Information page under the High School Graduation Information section.

String

S_GA_STU_X.BiLiteracyDiplomaSeal

S_GA_STU_X.CivicEngagementDiplomaSeal

S_GA_STU_X.FineArtsDiplomaSeal

S_GA_STU_X.InternationalSkillsDiploma

O

studentIndicator array (0-many)

The source of data for the following elements is corrected:

  • CTAEEmploy

  • CTAEPathway

  • CTAELeadership

The logic is changed for the GA_Alt_Math_Seq element.

Reflects important indicators of a student, such as CTAE Employability Soft Skills, CTAE Pathway Skills, and CTAE Leadership Skills.

The values are taken from the General Info tab on the Georgia State Information page under the High School Graduation Information section.

On the Georgia State Information page, under the Special Education tab, if the Alternate Match Sequence field is checked, the value Y is published. However, with the change in logic, if the field is unchecked, the value N is published.

String

S_GA_STU_X.CTAEEmployabilitySoftSkills

S_GA_STU_X.CTAEPathwaySkillsSeal

S_GA_STU_X.CTAELeadershipSkillsSeal

S_GA_STU_X.GA_Alt_Math_Seq

disabilities – studentDisability array (0-many)

This type represents an impairment of body structure or function, a limitation in activities, or a restriction in participation, as ordered by severity of impairment.

Note: Disability is only published for Choice schools. Public schools include disabilities in SPED Program data.

*Disability is required if applicable to the student; otherwise, the array is excluded from publishing.

O*

/disabilityDescriptor

This descriptor defines a student’s impairment.

Descriptor

[Students]DisabilityCode

[S_WI_STU_X]SecondaryDisability

Primary Disability is published only if DisabilityCode is not ‘N’ or blank.

Secondary Disability is published if value is not ‘N’ or blank, as long as Primary Disability is not ‘N’, ‘SDD’, or blank.

SecondaryDisability may include multiple codes separated by comma or colon.

R

/orderOfDisability

An indication if the disability is Primary, Secondary, Tertiary, etc.

Integer

‘1’ (Primary)

‘2’ (Secondary)

‘3’ (Tertiary)

R

language (1-many)

Defines the language(s) that are spoken or written.

Note: Language is only reported for public schools.

O

/language

The language(s) the individual uses to communicate.

Descriptor

[Students]PrimaryLanguage

O

/languageUse (0-many)

How the language is used, for example, Home Language, Native Language, Spoken Language.

Enumerated List

Derived based on the language field used.

O

races array (1-many)

Defines the student's racial categories.

R

/studentRace

The racial categories which most clearly reflect the individual’s recognition of his or her community or with which the individual most identifies.

String

Derived from:

[StudentRace]RaceCD

 

R

visaType

An indicator of a non-US citizen's visa type.

String

[S_WI_STU_X]Visa_Type

[S_WI_REN_X]Visa_Type

O

wiDpiStudentResidentEducation
OrganizationReference

A reference to the releated educationOrganizationReference. This is the LEA ID. Required for non-district 2R charter schools. For other districts, if not provided, the resident district will be identified as the reporting district.

Reference

If [Students]DistrictOfResidence matches the value in [Cst_PubOrganization]EduOrgId or [Cst_PubOrganization]AlternateId AND [Cst_PubOrganization]InstitutionType = 'LEA'

Then [Cst_PubOrganization]EduOrgId

O

Back to top

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close