This list outlines the tables and views currently available for each product supported in PowerBuddy for Data Analysis.
For PowerSchool SIS, refer to the PowerSchool SIS Data Dictionary for further information.
|
Release Version Number |
Product |
Tables and Views |
Notes |
|---|---|---|---|
|
25.7.0.0 |
PowerSchool SIS |
PS SIS views - STUDENTS_VIEW CONTACTS_VIEW COURSE_VIEW ENROLLMENTS_DEMOGRAPHICS_VIEW INCIDENT_VIEW TEST_SCORES_VIEW SCHEDULE_VIEW FEE_VIEW ASSIGNMENTS_VIEW CA State Views USA_CA_STUDENTS_VIEW USA_CA_SECTIONS_VIEW USA_CA_STUDENT_ELA_VIEW USA_CA_LEGACY_LANGUAGE_CODES Dynamic Tables ATTENDANCE_VIEW GRADES_VIEW User Defined Functions FN_INCIDENT_COUNT_TABLE FN_GRADE_RATE_TABLE |
Definitions of objects within the PSSIS_VIEWS schema will be available for users with CIDBADMIN role in CI. |
|
25.3.0.0 |
PowerSchool SIS |
PS SIS views - Enrollments PSSIS_ALL_ENROLLMENTS Attendance PSSIS_ATTENDANCE_DAILY_ENHANCED PSSIS_ATTENDANCE_INTERVAL_ENHANCED PSSIS_ATTENDANCE_MEETING_ENHANCED Incidents PSSIS_INCIDENT_ENHANCED PSSIS_INCIDENT_DETAIL_ENHANCED PSSIS_INCIDENT_PERSON_ACTION_ENHANCED PSSIS_INCIDENT_PERSON_BEHAVIOR_ENHANCED |
Views updated in 25.7.0.0 release |
|
Core Tables Assignment Assignmentcategoryassoc Assignmentdroppedbylowscore Assignmentretakescore Assignmentscore Assignmentscorecomment Assignmentsectonlinework Assignmentsection Assignmentstandardassoc Assignmentstudentassoc Attendance Attendance_Code Att_Adaadm_Defaults_All Bell_Schedule Bell_Schedule_Items Calendar_Day Cc Classrank Codeset Courses Cycle_Day Docdistrict Coursefee Emailaddress Fee Fee_Balance Fee_Pay_Item_Fee_Tran_Assoc Fee_Payment Fee_Payment_Item Fee_Transaction Fee_Type Fees Fte Gen Gradescaleitem Guardiannotificationemail Guardianpersonassoc Guardianstudent Honorroll Incident Incident_Action Incident_Detail Incident_Lu_Code Incident_Other_Person Incident_Person_Action Incident_Person_Detail Incident_Person_Role Incident_Lu_Sub_Code Incident_Object Incident_Object_Person Period Person Personaddress Personaddressassoc Personemailaddressassoc Personphonenumberassoc Pgfinalgrades Phonenumber Prefs Reenrollments Roledef School_Course Schools Schoolstaff Section_Meeting Sections Sectionteacher Studentcontactassoc Studentcontactdetail Studentcontactdetailcorefields Studentcorefields Studenttest Studenttestscore Schoolfee Spenrollments Standard Standardgradesection Standardgradesectioncomment Storedgrades Studentcounselor Studentrace Students Termbins Terms Transportation Teachercategory Test Testscore Users |
|
Note: Schoology (Usage Analytics) will be added back in the future release