PowerSchool Field List Glossary

Have you ever wanted a comprehensive list of field names and descriptions to help you get what you want out of powerschool?  A list to help you make queries or quick exports of data?  Well here is a list that will be periodically updated to act as your starting point!

20140207 1602 Capture

PowerSchool Field List Glossary

  • ACT_composite
  • ACT_date
  • ACT_english
  • ACT_math
  • ACT_reading
  • ACT_science
  • Alert_Discipline
    • One of many various alerts in PowerSchool. This field stores the text tied to the alert.
  • Alert_DisciplineExpires
    • One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert.
  • Alert_Guardian
    • One of many various alerts in PowerSchool. This field stores the text tied to the alert.
  • Alert_GuardianExpires
    • One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert.
  • Alert_Medical
    • One of many various alerts in PowerSchool. This field stores the text tied to the alert.
  • Alert_MedicalExpires
    • One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert.
  • Alert_Other
    • One of many various alerts in PowerSchool. This field stores the text tied to the alert.
  • Alert_OtherExpires
    • One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert.
  • allergies
  • AllowWebAccess
    • Indicates whether to allow the parent user ID to log in to the parent/student page: 1=Yes 0=No
  • area
  • ATE_skill_cert
  • Autosend_howoften
  • Balance1
    • Lunch balance.
  • Balance2
    • Beginning lunch balance for the year copied from balance 1 in the end- of-year process.
  • Balance3
    • Fees balance.
  • Balance4
    • Beginning fee balance for the year copied from balance 3 in the end-of- year process.
  • Building
    • This field is necessary to capture the building value assigned in PowerScheduler to a student. This will need to be moved from Students:Sched_NextYearBuilding during the End-of-Year process. The field stores the text value of building (i.e. Building 1)
  • Bus_Route
    • The district name for the students’ bus route.
  • Bus_Stop
    • The stop number at which the student gets on and off the bus.
  • C_STUDENTLOCATOR.ISOK_TO_TRANSFER
  • C_STUDENTLOCATOR.NEXT_LOCATOR
  • C_STUDENTLOCATOR.PREV_LOCATOR
  • CA_AKAFirst
  • CA_AKAMiddle
  • CA_AKASurname
  • CA_BirthCountry
  • CA_BirthPlace_City
  • CA_BirthPlace_Country
  • CA_BirthPlace_Special
  • CA_BirthPlace_State
  • CA_BirthPlace_StateProvince
  • CA_CELDT_TestPurpose
  • CA_CMA_ELA
  • CA_CMA_Math
  • CA_CMA_Science
  • CA_CountyOfResidence
  • CA_DateELAStatus
  • CA_Dateenroll
  • CA_DateRFEP
  • CA_EL
  • CA_ELAStatus
  • CA_ELlt12mos
  • CA_ELProfELA
  • CA_ELSetting
  • CA_EnrollmentStatus
  • CA_ethnAA
  • CA_ethnAI
  • CA_ethnAsPIGu
  • CA_ethnLa
  • CA_ethnWh
  • CA_ExcludeFromADA
  • CA_FirstUSASchooling
  • CA_G1Relationship
  • CA_G2Relationship
  • CA_GroupCode
  • CA_GroupName
  • CA_guardian2_fn
  • CA_guardian2_ln
  • CA_HispanicEthnicity
  • CA_HomeLanguage
  • CA_ImmigrantFunding
  • CA_InterdistrictTransfer
  • CA_LangFluency
  • CA_MultChWave
  • CA_NameSuffix
  • CA_NonPublicIEP
  • CA_NPS_CDS_SchoolCode
  • CA_ParentCorrespLang
  • CA_ParentEd
  • CA_PrimaryGuardian
  • CA_PrimaryLanguage
  • CA_PrimaryResidence
  • CA_PrimDisability
  • CA_ReceiverSchool
  • CA_SchoolCompletionStatus
  • CA_SecondaryGuardian
  • CA_STS
  • CA_TitleI_Targeted
  • CA_UC_CSU
  • CA_Use_UC_CSU_Override
  • CA_WritWave
  • CampusID
    • No longer used by application. This field may still be referenced on reports and/or custom pages.
  • City
    • City element of the students address.
  • ClassOf
    • Stores the calculated graduation class year.
  • Cumulative_Pct
    • The cumulative percent GPA for the student as of the last time GPA calculations ran.
  • Custom
    • This field holds all the students’ custom fields and their values in key- pair format separated by semicolons.
  • CustomRank_GPA
    • The rank for the student as of the last time GPA calculations ran based on their custom calculations.
  • Dentist_Name
  • Dentist_Phone
  • DistrictEntryDate
    • A static field with no coding used simply to hold information entered by the district.
  • DistrictOfResidence
    • The school district in which the student physically lives.
  • DOB
    • Date of birth.
  • Doctor_Name
    • Name of the doctor for the student.
  • Doctor_Phone
    • Phone number for the doctor.
  • Emerg_1_Ptype
  • Emerg_1_Rel
  • Emerg_2_Ptype
  • Emerg_2_Rel
  • Emerg_3_Phone
  • Emerg_3_Ptype
  • Emerg_3_Rel
  • Emerg_Contact_1
    • Name to contact in case of an emergency.
  • Emerg_Contact_2
    • Name to contact in case of an emergency.
  • Emerg_Contact_3
  • Emerg_Phone_1
    • Phone number for the first emergency contact.
  • Emerg_Phone_2
    • Phone number for the second emergency contact.
  • Enroll_Status
    • The enrollment status of the student. -2=Inactive, -1=Pre-registered, 0=Currently enrolled, 1=Inactive, 2=Transferred out, 3=Graduated, 4=Imported as Historical, Any other value =Inactive.
  • Enrollment_SchoolID
    • This field holds the school ID value when creating reenrollment records.
  • Enrollment_Transfer_Date_Pend
    • Date of the pending transfer of the student from the school. If 00/00/00 then immediate transfer.
  • Enrollment_Transfer_Info
    • Blob containing one or more comments regarding this transfer.
  • EnrollmentCode
    • This can be used for any special code that needs to be attached to an enrollment. Currently, it is only used in AZ: 0=None 1=CECA 2=CECB 3=Open Enrollment
  • EnrollmentID
  • EnrollmentType
    • This is used to specify what type of enrollment the student has at this school. Currently, it is only used in AZ: M=Main A=Ancillary
  • EntryCode
    • The code representing how or why the student entered school. These codes are stored in Gen Table [6] cat=entrycodes. These are set in school setup.
  • EntryDate
    • The date the student enrolled in school for the current enrollment.
  • ESL_placement
  • Ethnicity
    • Heritage background of a student. The codes assigned here are stored in the Gen Table [6] Cat=Ethnicity. These are set in school setup.
  • Exclude_fr_rank
    • True/False. Exclude from class rank. Used to keep particular students from counting in the class rank. This is often used for special education students.
  • ExitCode
    • The code representing how or why the student exited the school. These codes are stored in Gen Table [6] cat=exitcodes. These are set in school setup.
  • ExitComment
    • Any comments for the student exiting this school.
  • ExitDate
    • The date the student exited for the current/last enrollment. This is the day after a student-attended class. For example, if the last day the student is in school is a Wednesday, Thursday is the exit day.
  • Father
    • Name of students father.
  • Father_Employer
  • Father_home_phone
  • Father_StudentCont_guid
    • Globally unique identifier for this table for SIF compliancy.
  • fatherdayphone
  • FedEthnicity
    • Numerical answer to the question “Is the student Hispanic or Latino?” Valid values : -1 = Default value, user has not yet made a selection, 0 = No, 1 = Yes, 2 = User-defined answer specified on the Federal Ethnicity and Race Settings page.
  • FedRaceDecline
    • Valid values: 0 = Value assigned by default or one or more values specified in the StudentRace table, 1 = Declined to specify race (no rows should appear in the StudentRace table).
  • Fee_Exemption_Status
    • Determines what fees this student is exempt from. Values are, 0 = Students Not Exempted1 = Students Exempted from Course Fees. 2 = Students Exempted from School Fees 3 = Students Exempted from All Fees.
  • First_Name
    • Students’ first name.
  • FTEID
    • The internal number for the FTE with which this record is associated.
  • Gender
    • M=Male F=Female.
  • Geocode
    • Latitude/longitude coordinates for the student’s primary address.
  • GPEntryYear
    • The year the current entry entered the Grad Planner.
  • Grade_Level
    • The grade the student is in. Since this is an integer: 0=Kindergarten 1, -2=Preschool.
  • GradReqSetID
    • The graduation requirements this student follows. Links to the ID on the GradReq Table [37].
  • Graduated_Rank
    • Class rank upon the time of graduation.
  • Graduated_SchoolID
    • Stores the school number the student graduated from so the user can search for him or her in the Graduated Students school.
  • Graduated_SchoolName
    • Stores the name of the school the student graduated from so the user can search for him or her in the Graduated Students school.
  • graduation_year
  • Guardian_FN
  • Guardian_LN
  • Guardian_MN
  • Guardian_StudentCont_guid
    • Globally unique identifier for this table for SIF compliancy.
  • guardiandayphone
  • GuardianEmail
    • Parent/guardian email address.
  • GuardianFax
    • Parent/guardian fax number.
  • guardianship
  • HLN
  • Home_Phone
    • Home phone number for the student.
  • House
    • This field is necessary to capture the house value assigned in PowerScheduler to a student. This will need to be moved from Students:Sched_NextYearHouse during the End-of-Year process. The field stores the text value of house (i.e. Hawthorne).
  • ID
    • Sequential number generated by the application, but uniqueness in the table is not guaranteed.
  • ILDP
  • immunizaton_dpt
  • immunizaton_mmr
  • immunizaton_polio
  • Last_Name
    • Students last name.
  • LastFirst
    • Last, First, Mi. Indexed.
  • LastMeal
    • Stores the date of last lunch purchase.
  • LDAPEnabled
    • Used for LDAP support.
  • LEP_exit_date
  • LEP_status
  • Log
    • Place to write notes about transferring students.
  • LPAC_date
  • Lunch_ID
    • The students PowerLunch number.
  • LunchStatus
    • Represents the portion of lunch a student must pay for: Blank=No status P=Full pay R=Reducednt F=Free E=Exempt T=Temporary FDC=Free-DC.
  • Mailing_City
    • City part of the mailing address.
  • Mailing_Geocode
    • Latitude/longitude coordinates for the student’s mailing address.
  • Mailing_State
    • State part of the mailing address.
  • Mailing_Street
    • Street address of the mailing address.
  • Mailing_Zip
    • The zip code in the students mailing address.
  • Medical_Considerations
  • MembershipShare
    •  The amount of a student’s membership this school claims. If a student attends more than one school each one will only be able to claim a certain portion of the membership. The largest number for this will usually be 1 and fractions expressed as decimals. Like .5 or .25.
  • Middle_Name
    • Student’s middle name.
  • monitor_date
  • Mother
    • Name of student’s mother.
  • Mother_Employer
  • Mother_home_phone
  • Mother_StudentCont_guid
    • Globally unique identifier for this table for SIF compliancy.
  • motherdayphone
  • Next_School
    • The school the student will be attending the next school year. It is likely this will be the same school. The information is stored as the internal ID on the schools table for that school.
  • Person_ID
    • The related person in the Relationship table.
  • Phone_ID
    • The number for the student on PowerLink.
  • PhotoFlag
    • Set to 1 if a photo exists for this student.
  • PL_Language
    • PowerLink language, which is either Spanish or English.
  • prevstudentid
  • SAT
  • Sched_LoadLock
    • This field will lock individual students’ schedules from Load.
  • Sched_LockStudentSchedule
    • True/False: True (selected)=Do not allow the schedule to be changed by PowerScheduler. False (deselected)=Schedule this student when the scheduling engine is run.
  • Sched_NextYearBuilding
    • The building this student will be in next year for schools with multi- building needs.
  • Sched_NextYearGrade
    • The grade the student is going to be in next year. If the student is being retained, this should be the same as the current grade level.
  • Sched_NextYearHouse
    • The house this student will belong to next year. This is used for scheduling purposes. A house is most often used for _school within a school_ type of scheduling.
  • Sched_NextYearTeam
    • The team this student will belong to next year.
  • Sched_Priority
    • Indicates when you want this student to be scheduled in relation to the other students. The lower the number, the sooner he or she is scheduled.
  • Sched_Scheduled
    • A flag indicating if this student has had a schedule built for them. True means they do have a schedule and another will not be made unless the engine is told to reschedule regardless of this flag. False, the engine will build a schedule for this student next time.
  • Sched_YearOfGraduation
    • Year of graduation. This changes if the student fails or skips a grade.
  • SchoolEntryDate
    • A static field with no coding used to hold information entered by the district.
  • SchoolEntryGradeLevel
    • Grade level of the student for entering into this school.
  • SchoolID
    • This ID is linked to the School_Number from the School table.
  • Simple_GPA
    • The simple GPA for the student as of the last time GPA calculations ran.
  • Simple_PCT
    • The simple percent GPA for the student as of the last time GPA calculations ran.
  • singleparenthshldflag
  • SSN
    • Students Social Security number.
  • State
    • State element of address.
  • State_EnrollFlag
    • True/False. Used for state reporting to indicate he or she is enrolled at the state level.
  • state_excludeenrollment
  • State_ExcludeFromReporting
    • True/False. Used for state reports to exclude certain students from reports. Most often, these will be special education students who are reported differently.
  • State_StudentNumber
    • The state-assigned student number for the student. In most cases, this number should stay the same from school to school.  In California, this is the state issued SSID.
  • Street
    • Student’s street address.
  • Student_AllowWebAccess
    • Allow student user webID to log in to parent/student page: 1=Yes 0=No
  • Student_Number
    • Student Number assigned by the school.
  • Student_Web_ID
    • The student user ID for logging in to PowerSchool Parent.
  • Student_Web_Password
    • The password for Student_Web_ID.
  • StudentPers_guid
    • Globally unique identifier for this table for SIF compliancy.
  • StudentPict_guid
    • Globally unique identifier for this table for SIF compliancy.
  • StudentSchlEnrl_guid
    • Globally unique identifier for this table for SIF compliancy.
  • SummerSchoolID
    • School Identifer for this Student’s Summer School, if applicable.
  • SummerSchoolNote
    • Notes specific to this Student’s Summer School.
  • Team
    • This field is necessary to capture the team value assigned in PowerScheduler to a student. This will need to be moved from Students:Sched_NextYearTeam during the End-of-Year process. Sched_NextYearTeam captures the record ID from the Gen table (Cat = TeacherGroups). Current_Team cannot capture the ID since this record is part of PowerScheduler and may be changed when scheduling for a future year. An acceptable compromise is to capture the value instead (i.e. Blue) and store this.
  • Track
    • A-H or blank. This represents the times of year a student goes to school. This is most common with year-round schools.
  • Tracker
  • TransferComment
    • A text field for the school administrator to write a note about the reason a student is being transferred.
  • TuitionPayer
    • This is an integer code used to represent the tuition status of a student. For AZ: 1=State-funded 2=Privately paid or no tuition
  • Web_ID
    • The parent user ID for logging in to PowerSchool Parent.
  • Web_Password
    • The parent password for logging in to PowerSchool Parent.
  • Withdrawal_Reason_Code
    • Reason code provided when a student withdraws from school.
  • Zip
    • Students zip code.

Sources:

  • PowerSchool 7.x Data Dictionary Tables document released December 2013
Updated on July 27, 2018

Was this article helpful?

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT

Comments

  1. Hey, do you know of a simple way to identify students in Power School with the same names?

    1. You can try doing a quick export of lastfirst and Student_number. That way, you can see who has the same name but different student numbers so that you can identify those that actually have the same name but also those that might be the same student but have duplicate records!

  2. Just type Last name contains smith in the search box, and it will pull all students with that name. You can do the same for first or middle names.

    1. Thats a great tip! Just make sure that you don’t forget the underscore between the word “Last” and “name” as the technical field name is “Last_name”.

  3. How can i know who logged last into a student profile or my school’s powerschool database as there seems to be no accountability as to who can do what in this program.

    1. I would contact PowerSchool Support and ask them if they have any logs that track the specific behavior that you are looking for. We are not aware of a front-end setting that would allow you to do that.

  4. What is the field name if you are trying to locate where students went to school previously?

    1. For that, you won’t want to download from the Students table. The most direct way I know of is to download that data from the ReEnrollments table in the DDE. The Students table only contains the information for the most recent enrollment.

  5. Can you export students by period? I need to export students by third period.

    1. I would recommend that you first select students for the third period, then export the field(s) you want. Probably the easiest way to make that selection would be through the DDE by matching the Students table with the CC table.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Knowledge For Schools by Measure Education