Skip to main content
Skip table of contents

Student Demographics

Contents

Introduction

The Student Demographics report generates a comma separated (.CSV) file containing one record for each student enrolled during the collection period. This report is processed at the district-level for state reporting submission. The option to process for selected students or for a single school is provided for troubleshooting purposes only.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Students Selection

The report selects records from the [Students] table based on the following criteria:

  • The student’s school exit date must occur after the report start date.

  • The student’s school entry date must occur on or before the report end date.

  • The student’s school exit date must occur after their school entry date.

  • The school must not be excluded from state reporting.

  • The student must not be excluded from enrollment reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools

Choose one of the following:

  • Current School Only – This option is for troubleshooting purposes and Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

  • All Schools – This option is only available when running the report from the District Office. Includes all student records on the PowerSchool server that meet selection criteria.

Select Students

Indicate which students to include in the report by selecting one of the following options:

  • The selected [number] students only – Run the report for students in the current selection.

  • All students – Run the report for all students in the current school or district that meet the selection criteria.

If running the report for a single student, or group of students, select the students prior to running report.

Start Date

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the first day of the report date range.

End Date

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the last day of the report date range.

Include Audit Fields

Choose Yes to include additional fields used for troubleshooting to identify data that may need to be modified prior to submitting the report to the state.

The default option is No.

Validate Data

Choose No to validate only whether the records meet the selection criteria listed above. The report returns a validation error if any of the selection criteria is not met.

Choose Yes (the default) to validate all data.

Check the box if this is EOY submission

Select to indicate the report is the EOY submission.

Report atRisk for*

Indicate which students to include in the report by selecting one of the following options:

  • Only Students in Alternative Schools – At Risk values of Y are only reported if applicable checkboxes are selected and the student is enrolled in an alternative building. All other student's atRisk values are blank or N.

  • All Students – At Risk values of Y or N are reported for all students in the appropriate grade range (6-12)

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

Field Name

Field Path

Field Type

Field Length

Reqd

1

IDStuId

The Idaho student number.

[Students]State_StudentNumber



Varchar

9

Yes

2

lastName

The student’s last name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

Legal Name (Last)

Name (Last)

Demographics

State/Province - ID > Student Information

Varchar

35

Yes

3

firstName

The student’s first name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

Legal Name (First)

Name (First)

Demographics

State/Province - ID > Student Information

Varchar

35

Yes

4

middleName

The student’s middle name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

Legal Name (Middle)

Name (Middle)

Demographics

State/Province - ID > Student Information


Varchar

30

No

5

suffix

The suffix for the student name.

Note: If populated, the student's legal suffix overrides the student's preferred suffix.

[StudentCoreFields]PSCore_Legal_Suffix

[S_ID_STU_X]Suffix

Legal Name (Suffix)

Suffix

Demographics

State/Province - ID > Student Information

Varchar

8

No

6

birthDate

The student’s date of birth.

[Students]DOB

DOB

Demographics

Date

10

Yes

7

gender

The student’s gender.

Note: If populated, the student's legal gender overrides the student's preferred gender.

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

Legal Gender

Gender

Demographics

Option Set

1

Yes

8

hispanic

Indicates whether the student is Hispanic or Latino.

Valid values:

  • 0 – No

  • 1 – Yes

[Students]Fedethnicity

Ethnicity

Demographics

Option Set

1

Yes

9

asian

Indicates whether the student is Asian.

[StudentRace]Racecd

Race/Asian

Demographics

Option Set

1

Yes

10

indian

Indicates whether the student is American Indian or Alaska Native.

[StudentRace]Racecd

Race/American Indian or Alaska Native

Demographics

Option Set

1

Yes

11

black

Indicates whether the student is Black or African American.

[StudentRace]Racecd

Race/Black or African American

Demographics

Option Set

1

Yes

12

islander

Indicates whether the student is Native Hawaiian or Pacific Islander.

[StudentRace]Racecd

Race/Native Hawaiian or Other Pacific Islander

Demographics

Option Set

1

Yes

13

white

Indicates whether the student is White.

[StudentRace]Racecd

Race/White

Demographics

Option Set

1

Yes

14

openEnrolled

 Indicates whether  the student is open enrolled.

Valid values:

  • Yes - open enrolled

  • No - not open enrolled or blank

[S_ID_STU_X]openEnrolled

[S_ID_REN_X]openEnrolled

Open Enrolled

Demographics


1


15

baseSchoolId

The base school ID.

[S_ID_STU_X]BaseSchoolId

[S_ID_REN_X]BaseSchoolId

[Schools]Alternate_School_Number

[Schools]School_Number

Base School ID

Transfer Info > Current Enrollment

Option Set

4

Yes

16

county

The County of residence for the student's home address.



[S_ID_STU_X]County_of_Residence

[S_ID_SCH_X]LocationCounty

[Prefs]Name = ID_countyName

County of Residence

Location County

Demographics

District Setup > Schools/School Info > Idaho State Specific School Information

Option Set

2

Yes

17

zip

The student’s zip code.

[Students]Zip

Zip

Demographics

Char

9

No

18

phSchool

Private or Home Schooled indicator.

Valid values:

  • Y – Yes

  • N – No

If the source field is blank, a value of X is reported.

[S_ID_STU_X]PH_Code

[S_ID_REN_X]PH_Code

Private or Home Schooled

Transfer Info > Current Enrollment

Option Set

1

Yes

19

gradeLevel

The student’s grade level.

PowerSchool grade levels below 0 report as PK. PowerSchool grade level 0 reports as KG


[Students]Grade_Level

[ReEnrollments]Grade_Level

[S_ID_STU_X]No_Grade

[S_ID_REN_X]No_Grade



Option Set

2

Yes

20

uGPA

The student’s unweighted GPA.

Derived on calculation method selected at the school the enrollment pertains to.



Numeric

4

Yes

21

econDisStatus

The student’s economic disadvantage status, derived from the student's lunch status and calculated as follows:

  • If LunchStatus = FDC, then econDisStatus = D, OR

  • If LunchStatus = F or T, then econDisStatus = F, OR

  • If LunchStatus = R, then econDisStatus = R, OR

  • If no LunchStatus and S_ID_STU_X.householdSurvey = S, econDisStatus = S

  • If none of the above are true, then econDisStatus = X

[Students]LunchStatus

[ReEnrollments]LunchStatus

[S_ID_STU_X]HouseholdSurvey



Option Set

1

Yes

22

specialEd

The student’s special ed program status. This program status is determined by enrollment in a special program where the name contains SPE.

[SpEnrollments]ProgramID

[Gen]Cat=specprog

[Gen]Name



Option Set

1

Yes

23

504

The student’s 504 program status.This program status is determined by enrollment in a special program where the name contains 504.

[SpEnrollments]ProgramID

[Gen]Cat=specprog

[Gen]Name



Option Set

1

Yes

24

atRisk

Indicates whether the student has been identified as having at risk attributes.

  • If three or more of the following fields are Yes, then the student is a Group A At-Risk student: atRiskA, atRiskB, atRiskC, atRiskD, atRiskE, atRiskF.

  • If one or more of the following fields is Yes, then the student is a Group B At-Risk student: atRiskG, atRiskH, atRiskI, atRiskJ, atRiskK, atRiskL, atRiskM

  • Students who qualify for Groups A and B are reported as C.

[S_ID_STU_X]atRiskA

[S_ID_STU_X]atRiskB

[S_ID_STU_X]atRiskC

[S_ID_STU_X]atRiskD

[S_ID_STU_X]atRiskE

[S_ID_STU_X]atRiskF

[S_ID_STU_X]atRiskG

[S_ID_STU_X]atRiskH

[S_ID_STU_X]atRiskI

[S_ID_STU_X]atRiskJ

[S_ID_STU_X]atRiskK

[S_ID_STU_X]atRiskL

[S_ID_STU_X]atRiskM

At -Risk Indicators

Demographics > Student At-Risk Fields


1


25

militaryConnected

Indicates whether the student has a military connection.

[S_ID_STU_X]militaryConnected

Military Connected Student

Demographics

Varchar

1


26

servedTitleI

The student’s Title I program status. This program status is determined by enrollment in a special program where the name contains TIA.

[SpEnrollments]ProgramID

[Gen]Cat=specprog

[Gen]Name



Option Set

1

Yes

27

idResident

Indicates whether the student is a permanent resident of Idaho.

If the Is this student an Idaho resident ([S_ID_STU_X]US_Citizen) field is any of the following, then idResident is Y:

  • Yes

  • Blank

If the Is this student an Idaho resident ([S_ID_STU_X]US_Citizen) field is any of the following, then idResident is N:

  • No - Not on an Educational Visa

  • No - On Educational Visa

[S_ID_STU_X]US_Citizen

Is this student an Idaho resident?

Demographics

Option Set

1

Yes

28

onVisa

Indicates whether the student is on an Educational Visa.

  • If the Is this student an Idaho resident ([S_ID_STU_X]US_Citizen) field is blank, then onVisa is X

  • If the Is this student an Idaho resident ([S_ID_STU_X]US_Citizen) field is No - On Educational Visa, then onVisa is y

  • If the Is this student an Idaho resident ([S_ID_STU_X]US_Citizen) field is No - Not on an Educational Visa, then onVisa is N

[S_ID_STU_X]US_Citizen

Is this student an Idaho resident?

Demographics

Option Set

1

Yes

29

gifted

The student’s gifted/talented program status. This program status is determined by enrollment in a special program where the name contains GAT.

[SpEnrollments]ProgramID

[Gen]Cat=specprog

[Gen]Name



Option Set

1

Yes

30

nOrD

The student’s neglected or delinquent program status.This program status is determined by enrollment in a special program where the name contains NOD.

[SpEnrollments]ProgramID

[Gen]Cat=specprog

[Gen]Name



Option Set

1

Yes

31

homeless

The student’s homeless program status. This program status is determined by enrollment in a special program where the name contains HML.

If a student was homeless at any point in the year then Y is reported.

[SpEnrollments]ProgramID

[Gen]Cat=specprog

[Gen]Name



Option Set

1

Yes

32

homelessUAY

Indicates whether a student who is homeless is also an unaccompanied youth, as defined by law.

[S_ID_SEN_X]HomelessUAY

If homeless, is an unaccompanied youth

Special Programs

Option Set

1

Cond

33

homelessResid

The homeless student’s residence status.

[S_ID_SEN_X]HomelessResidence

Homeless Residence

Special Programs

Option Set

1

Cond

34

busRider

Indicates whether the student rides the bus.

[S_ID_STU_X]BusRider

Is Bus Rider

Demographics

Option Set

1

Cond

35

borderStudent

The student’s crossing state lines status.

[S_ID_STU_X]BorderStudent

Is Border Student

Demographics

Option Set

1

Yes

36


borderId

The SDE assigned ID for the other district for this border student.

[S_ID_STU_X]BorderID

Other Border District ID?

Demographics

Varchar

10

Cond

37

immigrant

The student’s immigrant status.

[S_ID_STU_X]Immigrant

Is Immigrant

State/Province - ID > Immigrant and LEP Information

Option Set

1

Yes

38

immigrantEntry

The date the student entered into the US.

[S_ID_STU_X]ImmigrantEntry

Immigrant US Entry Date

State/Province - ID > Immigrant and LEP Information

Date

10

Cond

39

nativeLanguage

The student's native language.

If this field is not populated, the default value reported is eng - English.

[S_ID_STU_X]NativeLanguage

Native Language

Demographics

Varchar

3

Yes

40

country

The student’s home country.

[S_ID_STU_X]Country

Home Country Code

State/Province - ID > Immigrant and LEP Information

Option Set

2

Cond

41

tdPeer

The student’s Typically Developing Peer program status.

This status is calculated according to the following logic:

  • If student’s grade level > -1, then always X.

  • If student’s grade level = -1 and SPED = N, then Y.

  • If student’s grade level = -1 and SPED = Y, then N.

Calculated



Option Set

1

Cond

42

earnedIndustryCert

The student's earned industry certification.

[S_ID_STU_X]EarnedIndCert

Earned Industry Certification

State/Province - ID > Student Information

Varchar

5

Cond

43

chronicallyAbsent

Indicates whether the student qualifies as a chronic absentee. A student is considered chronically absent, if the student was enrolled for at least ten school days and was absent at least 10% of the total school days or more.

If a student's school enrollment is excluded from enrollment reporting or if a student has been enrolled for less than 10 days, chronically absent is reported as N.

Valid values:

  • Y – Yes

  • N – No

Calculated from Potential_Minutes_Present and Minutes_Absent

This element is not based on the school's attendance conversion.




String

1

Cond

44

districtEntryDate

The month, day, and year on which the student entered or re-entered and began to receive instructional services in the district during the current school year.

Derived from school enrollment records

[Students]EntryDate

[ReEnrollments]EntryDate



Date

10

Yes

45

districtEntryType

The process by which a student entered the school district.

[Students]EntryCode

[ReEnrollments]EntryCode

If the LEA is mapping local codes to iSEE values:

[Gen]value2 (Idaho entry code)

[Gen]Cat=entrycodes




Option Set

2

Yes

46

schoolEntryDate

The student’s entry date for the school enrollment.

[Students]EntryDate



Date

10

Yes

47

schoolEntryType

The student’s entry code for the school enrollment.

The report extracts the Idaho-specific entry code mapped to the student’s entry code at the district level. If no Idaho specific entry code is mapped, then the report extracts the student’s entry code.

[Students]EntryCode

[ReEnrollments]EntryCode

If the LEA is mapping local codes to iSEE values:

[Gen]value2 (Idaho entry code)

[Gen]Cat=entrycodes




Option Set

2

Yes

48

schoolExitDate

The student’s exit date for the school enrollment.

[Students]ExitDate

[ReEnrollments]ExitDate



Date

10

No

49

schoolExitType

The student’s exit code for the school enrollment.

The report extracts the Idaho-specific exit code mapped to the student’s exit code at the district level. If no Idaho specific exit code is mapped, then the report extracts the student’s exit code. This field is required if the Exit Date is reported.

[Students]ExitCode

[ReEnrollments]ExitCode

If the LEA is mapping local codes to iSEE values:

[Gen]value2 (Idaho entry code)

[Gen]Cat=entrycodes




Option Set

2

Cond

50

districtExitDate

The month, day, and year of one of the following:

  • the student's last day of attendance within the district, or

  • the day on which the student graduated, or

  • the date on which it became known officially that a student left the District for this particular school year

Derived from school enrollment records

[Students]ExitDate

[ReEnrollments]ExitDate



Date

10

No

51

districtExitType

Indicates the circumstances under which the student exited from membership in the district.

[Students]ExitCode

[ReEnrollments]ExitCode

If the LEA is mapping local codes to iSEE values:

[Gen]value2 (Idaho entry code)

[Gen]Cat=entrycodes



Option Set

2

Cond

52

CurrentSchoolID*

Audit mode only

The student’s current schoolid.

[Students]SchoolID



N/A

N/A

N/A


JavaScript errors detected

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

If this problem persists, please contact our support.