Student Identification

students

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]

• STUDENTS (s)

• S_STU_X (xt)

• STUDENTCOREFIELDS (scf)

• S_TX_STU_X (txt), TX_STUDENT_SUBMISSION,

• S_TX_STU_CENSUS_BLOCK_C

• S_TX_STU_STATE_GEN_C (PEIMS General Info Table)

• S_TX_STU_AOS_C (AsOfStatus table)

Selection Criteria

Records are published if the following criteria are met:

• The studentUniqueId must be populated in PowerSchool.

• The student must not be excluded from state reporting.

• The student must have an active school enrollment.

• 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 student's crisis event must have a start date within the current school year.

• Includes any student with an enrollment entryDate in the current school year for a published school

  • One record for each student with at least one studentSchoolAssociation in the current school year at a published school

  • Student must have ADA value (S_TX_STU_STATE_GEN_C.E0787_ADA_Code) for current school year

  • excluded if S_STU_X.ExcludeFromEdFi = 1

  • unless otherwise excluded, include where state_excludefromreporting = 1, set studentDoNotReportTSDS = true

  Students who attended the previous year but not this year (Prior Year Leavers) are not published here

  • Published in PriorYearLeavers, which includes the identifying info normally included in Students

  Charter school waitlisted students are not published here

  • Published in StudentApplications, which includes the identifying info normally included in Students

  • Does not include a StudentUniqueId reference

  • See waitlisted students selection criteria in StudentApplications resource

  ChildFind students are all published here

  • Those who are not enrolled are not published in StudentSchoolAssociations

    • Non-enrolled must be published in studentEdcationOrganizationResponsibilityAssociations

    • Responsibility = 'Evaluation'

    • Not required for ChildFind students who are enrolled

  • All ChildFind students are published in studentSpecialEducationProgramEligibilityAssociations

    • Resource does not have name and DOB

    • It does have a StudentUniqueId reference

  • See ChildFind selection criteria in studentSpecialEducationProgramEligibilityAssociations resource

Resource Output

• A student record is published for each student 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 the Student Enrollment category has also 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

TX Element

TX Element Name

Description

Data Type

Stored in [Table]Field

Required?

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

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

Integer

[Students]State_StudentNumber

R

firstName

E0703

FIRST-NAME

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

String

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

R

middleName

E0704

MIDDLE-NAME

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

String

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

O

lastSurname

E0705

LAST-NAME

The name borne in common by members of a family.

String

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

R

generationCodeSuffix

E1303
E0706

GENERATION-CODE-SUFFIX
GENERATION-CODE

An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., III.

String

[StudentCoreFields]PSCore_Legal_Suffix

TX_STUDENT_SUBMISSION.TX_STUDENT_INFORMATION
upper(stux.E0706) generationCode

O

birthSexDescriptor

N/A

A person's gender: Female or Male.

String

Tables - scf.PSCore_Legal_Gender and stu.gender
coalesce(scf.PSCore_Legal_Gender, stu.gender) gender

R

birthDate

E0006

DATE-OF-BIRTH

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

Date

S_TX_STU_X.Birth_Country

R

birthStateAbbreviationDescriptor

N/A

N/A

The US state where student was born.

String

xt.birthstate

birthCountryDescriptor

N/A

N/A

The country where student was born.

String

S_TX_STU_X.Birth_Country

studentApplications

Lists information about applications submitted by students for various educational programs, services, or opportunities. This entity helps in tracking and managing student applications,

Primary PowerSchool Source Data

Tables: STUDENTS (s), S_TX_STU_X (stux), S_TX_STU_CHARTER_WAITLIST_C

Selection Criteria

• student does not have an enrollment in the current school year at a published school (not included above)

• district has a waitlist placeholder school (S_TX_SCH_SCHOOLS_X.CSW_Placeholder)

• student is enrolled in the waitlist placeholder school

• entry date on or before count date

• no exit date or exit date is after count date (last Friday in September)

• one record published for each record in student's waitlist array (S_TX_STU_CHARTER_WAITLIST_C) where:

  • Waitlist_Campus_ID is a reportable school

  • Waitlist_Effective_Date is on or before count date

Resource Output

Data Element

TX Element

TX Element Name

Description

Stored in [Table]Field

applicationIdentifier

A unique identifier for the application

educationOrganizationId

N/A

This is a unique identifier assigned to an educational organization

S_TX_STU_CHARTER_WAITLIST_C.Waitlist_Campus_ID

schoolYear

E1093

SCHOOL-YEAR

his term refers to the academic year for which data is being reported. It typically spans from one summer to the next, covering the full cycle of an academic year.

p_yearid + 1991

studentUid

E1523

TX-UNIQUE-STUDENT-ID

This is a unique identifier assigned to each student

Students.State_StudentNumber
State-assigned number for student

name

firstName

E0703

FIRST-NAME

The first name of the student.

STUDENTCOREFIELDS.PSCore_Legal_First_Name
If blank then STUDENTS.First_Name

Truncate to 60 chars

middleName

E0704

MIDDLE-NAME

The middle name of the student.

STUDENTCOREFIELDS.PSCore_Legal_Middle_Name
If blank then STUDENTS.Middle_Name

Truncate to 60 chars

lastSurname

E0705

LAST-NAME

The last name of the student.

STUDENTCOREFIELDS.PSCore_Legal_Last_Name
If blank then STUDENTS.Last_Name

Truncate to 60 chars

birthData

birthDate

E0006

DATE-OF-BIRTH

Student’s date of birth.

students.dob

sexDescriptor

E1325
E0004

SEX
SEX-CODE

This descriptor indicates the sex of the student.

coalesce(s.gender, studentcorefields.pscore_legal_gender)

entryGradeLevelDescriptor

E1517

ENTRY-GRADE-LEVEL-TYPE

This descriptor identifies the grade level at which a student enters a school or educational program.

TX Grade Levels:
-3 or below = EE  Early Education
-2 or -1 = PK Pre-Kindergarten
0 = KG Kindergarten
Other grades are standard

derived from STUDENTS.grade_level, REENROLLMENTS.grade_level

generationCodeDescriptor

E1303
E0706

GENERATION-CODE-SUFFIX
GENERATION-CODE

Identifies the generation suffix attached to a person’s name.

STUDENTCOREFIELDS.PSCore_Legal_Suffix
single-char code, don't left-zero-pad to 2 chars

studentId

E0001

STUDENT-ID

A reference to the student who submitted the application.

students.ssn

applicationTypeDescriptor

E3005

N/A

Categorizes the type of application a student submits. This descriptor helps in identifying and classifying different kinds of applications within the educational data system.

 '

applicationDate

E3004

N/A

The date when the application was submitted.

S_TX_STU_CHARTER_WAITLIST_C.Waitlist_Effective_Date