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.Credit_Hours

COURSES.Sched_FullCatalogDescription

COURSES.IsCareerTech

COURSES.Vocational

COURSES.CreditType

COURSESCOREFIELDS.alt_course_number

COURSEPREREQRULE.NOTE

COURSEPREREQRULE.RULEEXPRESSION

SCHEDULECOURSECATALOGS.Sched_RepeatsAllowed

COURSEEQUIVALENCY.COURSE_NUMBER_EQUIVALENT

SCHEDULECOURSECATALOGS.Course_Number

SCHEDULECOURSECATALOGS.SchoolID

STUDENTS.Student_Number

STUDENTS.Grade_Level

CC.Course_Number

CC.SectionID

CC.TermID

TERMS.Abbreviation

TEACHERS.LastFirst

COURSES.Course_Name

COURSES.Credit_Hours

COURSES.CreditType

STUDENTS.Student_Number

STOREDGRADES.Course_Number

STOREDGRADES.Grade_Level

STOREDGRADES.StoreCode

STOREDGRADES.Course_Name

STOREDGRADES.Teacher_Name

STOREDGRADES.PotentialCrHrs

STOREDGRADES.EarnedCrHrs

STOREDGRADES.Grade

STOREDGRADES.Percent

STOREDGRADES.SectionID

STOREDGRADES.TermID

STOREDGRADES.Credit_Type