Student Demographics

Data Element

Additional Information

[Table] Field Name

Student Name

Last Name and First Name are required. Middle Name is required if applicable.

Use the PEIMS Name Override fields if the first name, middle name or last name exceeds the number of characters allowed by PowerSchool or if the name to be reported for PEIMS differs from what is on the Students Demographics page.

Note: Only A-Z, 0-9, spaces, apostrophes ( ' ), and hyphens ( - ) can be entered into these fields.

[Students]First_Name

[Students]Middle_Name

[Students]Last_Name

Last Name Override

Enter if the last name exceeds the character limit on the Demographics page or if the last name needs to be reported differently from the core Last Name.

Optional.

Notes:

• As of the 2019-20 school year, the maximum length allowed for TSDS/PEIMS for staff names is 60 characters. Names that exceed this character length will be truncated in the extracts.

• The TEA max length is 60 for each of the name fields; TREx max length is 30 for Middle Name. Values that exceed the max length will be shortened in state reports as needed.

• Only A-Z, 0-9, spaces, apostrophes ( ' ), and hyphens ( - ) can be entered into this field.

StudentCoreFields.PSCore_Legal_Last_Name

First Name Override

Enter if the first name exceeds the character limit on the Demographics page or if the first name needs to be reported differently from the core First Name.

Optional.

Notes:

• As of the 2019-20 school year, the maximum length allowed for TSDS/PEIMS for staff names is 60 characters. Names that exceed this character length will be truncated in the extracts.

• The TEA max length is 60 for each of the name fields; TREx max length is 30 for Middle Name. Values that exceed the max length will be shortened in state reports as needed.

• Only A-Z, 0-9, spaces, apostrophes ( ' ), and hyphens ( - ) can be entered into this field.

PSCore_Legal_First_Name

Middle Name Override

Enter if the middle name exceeds the character limit on the Demographics page or if the middle name needs to be reported differently from the core Middle Name.

Optional.

Notes:

• As of the 2019-20 school year, the maximum length allowed for TSDS/PEIMS for staff names is 60 characters. Names that exceed this character length will be truncated in the extracts.

• The TEA max length is 60 for each of the name fields; TREx max length is 30 for Middle Name. Values that exceed the max length will be shortened in state reports as needed.

• Only A-Z, 0-9, spaces, apostrophes ( ' ), and hyphens ( - ) can be entered into this field.

StudentCoreFields.PSCore_Legal_Middle_Name

Generation Code (Optional)

Choose a generation code form the pop-up menu.

Note: When reporting the generation code for TREx, the short codes are reported such as 1, 2, 3

1          Jr
2          Sr
3          II
4          III
5          IV
6          V
7          VI
8          VII
9          VIII
A          I
B          IX
C          X

StudentCoreFields.PSCore_Legal_Suffix

Address

Enter the student’s home address.

Required.

[Students]Street

[Students]City

[Students]State

[Students]Zip

Mailing Address

Enter the student’s mailing address.

Required.

[Students]Mailing_City

[Students]Mailing_State

[Students]Mailing_Zip

Phone Number

Enter the student’s home phone number.

Required.

[Students]Home_Phone

Date of Birth

September 1 impacts enrollment eligibility.

Format mm/dd/yyyy

Required.

[Students]DOB

Federal Ethnicity and Race

Ethnicity

Select Yes or No for the students Ethnicity.

Required.

[Students]FedEthnicity

Yes=1

No=0

Federal Ethnicity and Race

Race

Select the student's race. One or more may be selected.

Required.

[StudentRace]

StudentRace is linked to the Students table by the internal Student id ([Students]ID links to the [StudentRace]StudentID)

StudentRace has the following fields

ID (Internal number of record)

StudentID ([Students]ID)

RaceCd (this is the RaceCd from the Gen Table.

A record is created for each race a student has.

Father

Enter the father’s name. Format = Last, First

[Students]Father

Guardian Email

Enter any emails for guardians that wish to receive emails. Multiple emails may be added by separating with a semi-colon.

Optional.

[Students]GuardianEmail

Mother

Enter the father’s name. Format = Last, First

[Students]Mother

Gender

Select the student's gender.

Required.

[Students]Gender

Legal Gender

Select the student's legal gender.

[Students]LegalGender

Grade Level

Enter the student's grade level

[Students]GradeLevel

Graduation Year

Enter the student's graduation year.

[Students]GraduationYear

Guardianship

 Enter the student's guardianship

[Students]Guardianship

Guardian Email

Enter the guardian's email address

[Students]GuardianEmail

Mother (last, first)

Enter the mother's name.

[Students]MotherFirstName

[Students]MotheLastName

Mother's Cell Phone

Enter the mother's mobile phone number.

[Students]MotherCell Phone

Mother's Employer

Enter the mother's employer.

[Students]MotherEmployer

Mother's Home Phone

Enter the mother's home phone number.

[Students]MotherHomePhone

Previous Student ID

Enter if applicable (for local use).

[Students]PrevStudentID

Student ID

(E0001)

This may be a state-assigned number beginning with S or social security number.

Required.

Note: The Student ID must conform to one of the following formats: NNN-NN-NNNN, NNNNNNNNN, SNNNNNNNN., or SNN-NN-NNNN

• Must have 9 digits

• The first 3 digits and should not be 000, 666, or between 900 and 999.

• The 4th & 5th digits should be between 01 to 99.

• The 5th through 9th digits should be from 0001 to 9999.

[Students]SSN

Local Student ID

Enter the local student number or use the number PowerSchool automatically assigns at the time of enrollment. This field is optional for PEIMS.

[Students]Student_Number

Unique Student Identifier

Enter the unique student identifier assigned to the student by the state of Texas.

[Students]State_StudentNumber

Exclude from PEIMS/TSDS

Choose Yes to exclude this student from PEIMS reporting.

Optional. Default is No.

[Students]State_ExcludeFromReporting 

Exclude from Ed-Fi

Choose Yes to exclude this student from Ed-Fi reporting.

Optional. Default is No.

[S_STU_EDFI_X]ExcludeFromEdFi

Home Language Survey Date

Enter the date the original Home Language Survey was administered to a student upon initial enrollment in a Texas public school.

[S_TX_STU_X]Home_Language_Survey_Date

Home Language Code

Choose a Home Language code.

Home Language the language spoken in the student’s home most of the time, as determined by the student’s home language survey.

Required. The default is (98) English.

This may also be entered on the Other Information page.

[StudentCoreFields]PrimaryLanguage 

Student Language Code

Choose a Student Language code.

Student Language is the language spoken by the student most of the time, as determined by the student’s home language survey.

Required. The default is (98) English.

This may also be entered on the Other Information page.

[StudentCoreFields]SecondaryLanguage 

Previous Home Settings Language Code 

 Select the Previous Home Settings Language Code.

[S_TX_STU_X]Previous_Language

Data Element

Additional Information

[Table] Field Name

Birth Country

Choose a code for the student’s birth country.

This is used to automatically create Immigrant records in special programs.

[S_TX_STU_X]Birth_Country

Date First Enrolled in US Schools

Enter the date the student first enrolled in a U.S. school.

This field displays only when Birth Country is not (US) United States or (PR) Puerto Rico.

This is used to automatically create Immigrant records in special programs.

[S_TX_STU_X]First_US_Enrolled_Date

Months Not in US Schools

Enter the number of months the student spent outside of U.S. schools. Used to account for periods of non-enrollment for Immigrant coding.

This field displays only when Birth Country is not (US) United States or (PR) Puerto Rico.

This is used to automatically create Immigrant records in special programs.

[S_TX_STU_X]Months_Not_In_US

Data Element

Additional Information

[Table] Field Name

Email Address

Enter the student’s email address.

Optional.

[PSM_StudentContact]Email