Common PowerSchool SIS Student Table Names and Fields

Student_Number

State_StudentNumber

First_Name

Middle_Name

Last_Name

StudentCoreFields.PSCORE_LEGAL_FIRST_NAME

StudentCoreFields.PSCORE_LEGAL_MIDDLE_NAME

StudentCoreFields.PSCORE_LEGAL_LAST_NAME

Sched_YearOfGraduation StudentCoreFields.graduation_year

ClassOf

Student_Web_ID

DOB

Gender

StudentCoreFields.PSCORE_LEGAL_GENDER

Ethnicity

Street

Mailing_Street

City

Mailing_City

Zip

Mailing_Zip

Home_Phone

~(*gpa method="[Unweighted GPA Calculation Method name]")

~(*gpa method="[Weighted GPA Calculation Method name]")

~(*classrank method=”[GPA Calculation Method name]”)