SB3 PowerSchool SIS Texas
SB3 PowerSchool SIS Texas
Breadcrumbs

Student Identification

This category captures the core student demographic records and contains identifying student information. The Students category includes the following data views and resources:

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


TX Extensions

Data Element

 TX Element

TX Element Name

Description

Stored in [Table]Field

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

localStudentId

E0923

LOCAL-STUDENT-ID

The student’s local identification number assigned by the district.

students.student_number

studentId

E0001

STUDENT-ID

A unique identifier for a student.

students.ssn

asOfStatusLastFridayOctoberDescriptor

E3007

N/A

This descriptor indicates the student’s enrollment status as of the last Friday in October.

S_TX_STU_AOS_C.As_Of_Status_Fall

asOfStatusLastDayEnrollmentDescriptor

E3006

N/A

This descriptor captures the student’s enrollment status as of the last day of enrollment for the school year

S_TX_STU_AOS_C.As_Of_Status_EOY

studentDoNotReportTSDS

E3009

N/A

It is used to exclude certain students from state reporting.

s.state_excludefromreporting

censusBlockGroupSets



.

[Array]

     studentCensusBlockGroup

E1648

STUDENT-CENSUS-BLOCK-GROUP

This indicates the census block group in which the student resides.

S_TX_STU_CENSUS_BLOCK_C.Census_Block

     beginDate

E3010


The start date for the student’s residence in the specified census block group,

S_TX_STU_CENSUS_BLOCK_C.Effective_Date

     endDate

E3020


The end date for the student’s residence in the specified census block group,

Day after last day of school year or effective_date of subsequent record where applicable

crisisEvents




[Array]

     crisisEventDescriptor

E1054

CRISIS-CODE

This descriptor indicates a state health or weather-related event that impacts a group of students and may require additional funding, educational, or social services


     beginDate

E3010


The start date of the crisis event


     endDate

E3020


The end date of the crisis event


additional fields for display only

 

 







sch.school_name





s.student_number





s.lastfirst





s/r.grade_level

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