Common PowerSchool SIS Student Table Names and Fields
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 …
Common PowerSchool SIS Staff Table Names and Fields
Users.DCID Users.First_Name Users.Middle_Name Users.Last_Name Users.Title Users.Email_Addr Users.TeacherNumber RoleDef.Name SchoolStaff.Status User...
This document lists all PowerSchool’s database fields. Included are the names of the tables (or views) in which the fields exist, the types of data that can be entered into or retrieved from the fields, and an associated description of the fields.
Jul 31, 2019 · This supplemental guide provides information on Data Access Tags (DATs) including formatting, DAT usage, and examples. Refer to this guide when using DATs in Object Reports, Form Letters, Report Cards, Mailing Labels, and more. List Students Group Function - usually used with student information DATs.
Common PowerSchool SIS Course Related Table Names and Fields
Course Catalog SCHOOL_COURSE.YearID COURSES.Course_Number COURSES.Course_Name COURSES.Sched_Department COURSES.Sched_CourseSubjectAreaCode COURSES....
Aug 3, 2019 · This document lists all PowerSchool’s database fields. Included are the names of the tables (or views) in which the fields exist, the types of data that can be entered into or retrieved from the fields, and an associated description of the fields.
Data Dictionary - ps-compliance.powerschool-docs.com
Database table names appear as the table titles and the software release version indicating when the table was created. Database data elements appear as rows within each table along with the software release version indicating when the data element was created or modified.
Data Dictionary - ps-compliance.powerschool-docs.com
Each state-specific table is comprised of rows and columns that correspond to the values and data elements in the table, including field name, software release version, data type, and description. Database table names are comprised of the table titles and the software release version, which indicates when the table was created.
PowerSchool Data Access Tags (DATs) | Report and Export Codes
Jul 1, 2021 · Comprehensive guide on using Data Access Tags (DATs) in PowerSchool for reporting and exporting student data, including attendance, GPA, and more.
For more information on PowerSchool tables and fields, see the North Carolina State Reporting Data Dictionary guide, which identifies all tables in the database, and provides table column definitions, field data types, and field descriptions.
- Some results have been removed