Student Demographics

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)

Item #

Data Element

Description

Field Name

[Table]FieldName

Field Type

Field Length

Reqd

1

IDStuId

The Idaho student number.

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

State Student ID

[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.

Navigation: Select student, Student Profile, Student Details, Demographics and scroll to Idaho State Information section

OR
search for Demographics

Legal Name (Last)

Name (Last)

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

Value retrieved from the Legal Last Name field if available. Otherwise, from the Last Name field.

Varchar

35

Yes

3

firstName

The student’s first name.

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

Navigation: Select student, Student Profile, Student Details, Demographics and scroll to Idaho State Information section

OR
search for Demographics

Legal Name (First)

Name (First)

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

Value retrieved from the Legal First Name field if available. Otherwise, from the First Name field.

Varchar

35

Yes

4

middleName

The student’s middle name.

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

Navigation: Select student, Student Profile, Student Details, Demographics and scroll to Idaho State Information section

OR
search for Demographics

Legal Name (Middle)

Name (Middle)

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

Value retrieved from the Legal Middle Name field if available. Otherwise, from the Middle Name field.

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.

Navigation: Select student, Student Profile, Student Details, Demographics and scroll to Idaho State Information section

OR
search for Demographics

Legal Name (Suffix)

Suffix

[StudentCoreFields]PSCore_Legal_Suffix

[S_ID_STU_X]Suffix

Value retrieved from the Legal Suffix field if available. Otherwise, from the suffix field.

Varchar

8

No

6

birthDate

The student’s date of birth.

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

DOB

[Students]DOB

Date

10

Yes

7

gender

The student’s gender.

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

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Legal Gender

Gender

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

Value retrieved from the Legal Gender field if available. Otherwise, from the Gender field.

Note: If the Gender field reflects a value other than M or F,

Legal Gender is populated.

Option Set

1

Yes

8

hispanic

Indicates whether the student is Hispanic or Latino.

Valid values:

• 0 – No

• 1 – Yes

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Ethnicity

[Students]Fedethnicity

Option Set

1

Yes

9

asian

Indicates whether the student is Asian.

Valid values:

• 0 – No

• 1 – Yes

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Race/Asian

[StudentRace]Racecd

Option Set

1

Yes

10

indian

Indicates whether the student is American Indian or Alaska Native.

Valid values:

• 0 – No

• 1 – Yes

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Race/American Indian or Alaska Native

[StudentRace]Racecd

Option Set

1

Yes

11

black

Indicates whether the student is Black or African American.

Valid values:

• 0 – No

• 1 – Yes

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Race/Black or African American

[StudentRace]Racecd

Option Set

1

Yes

12

islander

Indicates whether the student is Native Hawaiian or Pacific Islander.

Valid values:

• 0 – No

• 1 – Yes

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Race/Native Hawaiian or Other Pacific Islander

[StudentRace]Racecd

Option Set

1

Yes

13

white

Indicates whether the student is White.

Valid values:

• 0 – No

• 1 – Yes

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Race/White

[StudentRace]Racecd

Option Set

1

Yes

14

openEnrolled

 Indicates whether  the student is open enrolled.

Valid values:

• Yes - open enrolled

• No - not open enrolled or blank

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

Open Enrolled

[S_ID_STU_X]openEnrolled

[S_ID_REN_X]openEnrolled

1

15

baseSchoolId

The base school ID.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

Base School ID

[S_ID_STU_X]BaseSchoolId

[S_ID_REN_X]BaseSchoolId

[Schools]Alternate_School_Number

[Schools]School_Number

If the Base School ID field is populated, that value will pull. If the Base School ID field is blank, the report will pull the ID of the school the student is enrolled in.

If the student's school has an Alternate School Number value entered, that value will be returned.

Option Set

4

Yes

16

county

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

Navigation: Select student, Student Profile,

Student Details, Demographics

OR
search for Demographics

County of Residence

Location County

[S_ID_STU_X]County_of_Residence

[S_ID_SCH_X]LocationCounty

[Prefs]Name = ID_countyName

If the student level County of Residence field is blank, the report considers the school level field. If the school level field is blank, the report considers the value from the district level field.

Option Set

2

Yes

17

zip

The student’s zip code.

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Zip

[Students]Zip

Value is reported 9 digits. Hyphens that may be in the saved value are stripped out by the report.

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.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

Private or Home Schooled

[S_ID_STU_X]PH_Code

[S_ID_REN_X]PH_Code

If the source field is blank, the report will return X.

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

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

[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.

The report calculates the reported GPA value based on the selected GPA calculation method.

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

Navigation: Select student, Student Profile, More, Lunch Program

OR
search for Lunch Program

[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

Students are reported as Sped Y if they are enrolled in a qualifying special program during the reporting time period, and the following must be true:

• The Special Program name must start with “SPE".

• The Special Program start date must be less than or equal to the student's exit date.

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank.

• The Special Program entry date must be less than the student's exit date or the Special Program exit date must be blank.

• Tested Ineligible must not be selected.

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

• Students are reported as 504 - Y if they're enrolled in a qualifying special program during the reporting time period and the following must be true:

• The Special Program name must include "504".

• The Special Program start date must be less than or equal to the student's exit date.

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank
  

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.
  

Navigation: Select student, Student Profile, Student Details, Demographics, and then click Student At-Risk Fields

OR
search for Demographics, then click Student At-Risk Fields

At -Risk Indicators

[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

The report automatically return N for students in grades 5 or below.

In order for a student to report Y, the following must be true:

• Student must be in grades 6-12.

• They must have met 3 or more criteria from Group A or 1 or more from Group B

1

25

militaryConnected

Indicates whether the student has a military connection.

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Military Connected Student

[S_ID_STU_X]militaryConnected for current enrollment

[S_ID_REN_X]militaryConnected for previous enrollment

The report will return N if the source field is blank.

The report will return N if the source field is blank.

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

Students are reported as TitleIA - Y if they are enrolled in a qualifying special program during the reporting time period and the following must be true:

• The Special Program name must include "TIA"

• The Special Program start date must be less than or equal to the student's exit date

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank.

Students are reported as TitleIA - Y if they are enrolled in a qualifying special program during the reporting time period and the following must be true:

• The Special Program name must include "TIA"

• The Special Program start date must be less than or equal to the student's exit date

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank.

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

Is this student an Idaho resident?

[S_ID_STU_X]US_Citizen

The report will return a Y if the source field is blank.

If an N or V is saved to the source field, the report will return an N.

The report will return a Y if the source field is blank.

If an N or V is saved to the source field, the report will return an N.

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

Is this student an Idaho resident?

[S_ID_STU_X]US_Citizen

The report will return a Y if V is saved to the source field.
The report will return an N if N is saved to the source field.
If none of the above are true, the report will return X.

The report will return a Y if V is saved to the source field.
The report will return an N if N is saved to the source field.
If none of the above are true, the report will return X.

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

Students are reported as Gifted - Y if they're enrolled in a qualifying special program during the reporting time period and the following must be true:

• The Special Program name must begine with "GAT –"

• The Special Program start date must be less than or equal to the student's exit date

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank
  

Students are reported as Gifted - Y if they're enrolled in a qualifying special program during the reporting time period and the following must be true:

• The Special Program name must begine with "GAT –"

• The Special Program start date must be less than or equal to the student's exit date

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank
  

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

Students are reported as Homeless - Y if they're enrolled in a qualifying special program during the reporting time period and the following must be true:

• The Special Program name must begine with "HML –"

• The Special Program start date must be less than or equal to the student's exit date

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank
  

Students are reported as Homeless - Y if they're enrolled in a qualifying special program during the reporting time period and the following must be true:

• The Special Program name must begine with "HML –"

• The Special Program start date must be less than or equal to the student's exit date

• The Special Program exit date must be greater than the student's entry date or the Special Program exit date must be blank
  

Option Set

1

Yes

32

homelessUAY

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

If homeless, is an unaccompanied youth

[S_ID_SEN_X]HomelessUAY

The field must be set in the current homeless program record.

The field must be set in the current homeless program record.

Option Set

1

Cond

33

homelessResid

The homeless student’s residence status.

Homeless Residence

[S_ID_SEN_X]HomelessResidence

The field must be set in the current homeless program record.

The field must be set in the current homeless program record.

Option Set

1

Cond

34

busRider

Indicates whether the student rides the bus.

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Is Bus Rider

[S_ID_STU_X]BusRider

The report will return a Y if the source field is blank.

The report will return a Y if the source field is blank.

Option Set

1

Cond

35

borderStudent

The student’s crossing state lines status.

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Is Border Student

[S_ID_STU_X]BorderStudent

Option Set

1

Yes

36

borderId

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

Navigation: Select student, Student Profile, Student Details, Demographics

OR
search for Demographics

Other Border District ID?

[S_ID_STU_X]BorderID

The report will return an X if the source field is blank.

The report will return an X if the source field is blank.

Varchar

10

Cond

37

immigrant

The student’s immigrant status.

Navigation: Select student, Compliance, Immigrant and LEP information

OR
search for Immigrant and LEP information

Is Immigrant

[S_ID_STU_X]Immigrant

Option Set

1

Yes

38

immigrantEntry

The date the student entered into the US.

Immigrant US Entry Date

[S_ID_STU_X]ImmigrantEntry

The report will return N if the source field is blank.

The report will return N if the source field is blank.

Date

10

Cond

39

nativeLanguage

The student's native language.

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

Navigation: Select student, Compliance, Immigrant and LEP information

OR
search for Immigrant and LEP information

Native Language

[S_ID_STU_X]NativeLanguage

Varchar

3

Yes

40

country

The student’s home country.

Navigation: Select student, Compliance, Immigrant and LEP information

OR
search for Immigrant and LEP information

Home Country Code

[S_ID_STU_X]Country

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

I

I

Option Set

1

Cond

42

earnedIndustryCert

The student's earned industry certification.

Navigation: Select student, Compliance, Student Information

OR
search for Student Information

Earned Industry Certification

[S_ID_STU_X]EarnedIndCert

Varchar

5

Cond

43

apprenticeshipParticipant

Indicates whether the student participated in School to Registered Apprenticeship Program (STRAP) during the current school year based school enrollment.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

Apprenticeship Participant

[S_ID_STU_X]ApprenticeshipParticipant

[S_ID_REN_X]ApprenticeshipParticipant

1

Cond

44

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

45

onSchoolGrounds

Indicates whether the current year enrolled K-12 students received majority of their instruction at a physical facility owned or leased by the reporting LEA.

Valid values:

• Yes - Y

• No - N

• Not Applicable - X

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

On School Grounds

[S_ID_STU_X]ON_SCH_GROUNDS

[S_ID_REN_X]ON_SCH_GROUNDS

[S_ID_SCH_X]ON_SCH_GROUNDS

If either the school-level is N or the student/enrollment level value is N, then the field will be reported as N.

Option Set

1

Yes

46

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

47

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

48

schoolEntryDate

The student’s entry date for the school enrollment.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

[Students]EntryDate

Date

10

Yes

49

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.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

[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

50

schoolExitDate

The student’s exit date for the school enrollment.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

[Students]ExitDate

[ReEnrollments]ExitDate

Date

10

No

51

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.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

[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

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

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

Derived from school enrollment records

[Students]ExitDate

[ReEnrollments]ExitDate

Date

10

No

53

districtExitType

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

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

[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

54

CurrentSchoolID*

Audit mode only

The student’s current schoolid.

Navigation: Select student, School Enrollment, Enrollment History

OR
search for Enrollment History

[Students]SchoolID

N/A

N/A

N/A