WIXLIB

Data Dictionary SIS ViewsPowerSchool Premier 5.2Student Information System

Released July 2008Document Owner: Documentation ServicesThis edition applies to Release 5.2 of the PowerSchool Premier software and to all subsequent releases and modifications until otherwiseindicated in new editions or updates.This edition applies to Structure 5.2.0.4 of the PowerSchool Premier software and to all subsequent releases and modifications until otherwiseindicated in new editions or updates.The data and names used to illustrate the reports and screen images may include names of individuals, companies, brands, and products. Allof the data and names are fictitious; any similarities to actual names are entirely coincidental.PowerSchool is a trademark, in the U.S. and/or other countries, of Pearson Education, Inc. or its affiliate(s).Copyright 2008 Pearson Education, Inc. or its affiliates. All rights reserved. All trademarks are either owned or licensed by PearsonEducation, Inc. or its affiliates. Other brands and names are the property of their respective owners.

Data Dictionary SIS ViewsContentsIntroduction . 1SIS Views . 1Purpose . 1Audience. 1Conventions . 2SIS Repository Views . 3PSSIS AdaAdm Daily Ctod (ver5.0.0). 3PSSIS AdaAdm Daily Ttod (ver5.0.0) . 4PSSIS AdaAdm Interval Ttod (ver5.0.0) . 6PSSIS AdaAdm Meeting Ptod (ver5.0.0) . 7PSSIS AdaAdm Meeting Ttod (ver5.0.0) . 9PSSIS AdaAdm TimeInter Ttod (ver5.0.0) .10PSSIS AdaAdm Time Ttod (ver5.0.0) .12PSSIS Attendance Daily (ver5.0.0) .13PSSIS Attendance Interval (ver5.0.0) .15PSSIS Attendance Meeting (ver5.0.0) .18PSSIS Attendance Time (ver5.0.0) .21PSSIS Attendance TimeInter (ver5.0.0) .23PSSIS Bus Routes (ver5.0.0).25PSSIS Enrollment All (ver5.0.0) .25PSSIS Membership Defaults (ver5.0.0) .27PSSIS Membership Prog (ver5.0.0) .28PSSIS Membership Reg (ver5.0.0) .30PSSIS NCLB Fields (ver5.0.0) .32Contentsiii

Data Dictionary SIS ViewsPSSIS Special Pgm Enrollments (ver5.0.0) .33PSSIS Standards (ver5.0.0) .33PSSIS Student Addresses (ver5.0.0) .34PSSIS Student Alerts (ver5.0.0) .35PSSIS Student Sched Class Term (ver5.0.0) .36PSSIS Student Demographics (ver5.0.0).37PSSIS Student Discip Summary (ver5.0.0) .39PSSIS Student Enrollments (ver5.0.0) .41PSSIS Student Fees (ver5.0.0) .43PSSIS Student Relationships (ver5.0.0) .45PSSIS Student Scheduling (ver5.0.0) .46PSSIS Student Stored Standards (ver5.0.0).47PSSIS Student Test Scores (ver5.0.0).49PSSIS Student Transportation (ver5.0.0) .50PVSIS Custom CC (ver5.1.0) .52PVSIS Custom Courses (ver5.1.0).53PVSIS Custom Fee (ver5.1.0) .54PVSIS Custom Fee Transaction (ver5.1.0) .55PVSIS Custom Fee Type (ver5.1.0) .56PVSIS Custom Log (ver5.1.0) .57PVSIS Custom ReEnrollments (ver5.1.0) .58PVSIS Custom SchoolFee (ver5.1.0) .59PVSIS Custom Schools (ver5.1.0) .61PVSIS Custom Sections (ver5.1.0) .61PVSIS Custom SPEnrollments (ver5.1.0) .63PVSIS Custom Students (ver5.1.0) .64Contentsiv

Data Dictionary SIS ViewsPVSIS Custom Teachers (ver5.1.0) .65Notes . 67Contentsv

Data Dictionary SIS ViewsIntroductionIn Database Management Systems (DBMS), the collection of information that defines the basic organization of a database – andthe objects contained therein - is called the Data Dictionary. The Data Dictionary typically contains a list of all tables in thedatabase, the column definitions in each table, the types of each field, and an associated description.SIS ViewsThe SIS views provide instant access to key metrics not just raw data. These pre-defined Structured Query Language (SQL)quires, known as data views, can extract key data such as a student’s average daily attendance (ADA), course schedules,student assessment data, demographic profiles, and discipline information.SQL is the common language used by both the application and the database. It allows users to specify what data to retrieveand where the information resides in the database. Complex business logic and calculations are designed into the data views soquerying the data to generate reports is simple.For more information, please see the SIS Repository User Guide available on the PowerSchool Customer Support Web site.PurposeThis 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.AudienceThis document is intended for a district or school’s database administrators (DBA). A DBA directs or performs all activitiesrelated to maintaining a successful database environment. Responsibilities include designing, implementing, and maintainingthe database system, and establishing policies and procedures pertaining to the management, security, maintenance, and useof the database management system.Introduction1

Data Dictionary SIS ViewsConventionsTables and (views) follow a standard convention. Table (or view) names appear as the table title along with the version stringindicating when the object was created or modified. Column names that appear italicized are designated as “No Longer Used.”All Foreign Key fields are specified as such in the Description column of each table.Introduction2

Data Dictionary SIS ViewsSIS Repository ViewsPSSIS AdaAdm Daily Ctod (ver5.0.0)This View may be used for gathering Daily Attendance records (using Code to Day conversion).Column NameData TypeDescriptionName (ver5.0.0)String 35[From PSSIS Membership Reg] The Student’s last, first name.Student Number (ver5.0.0)Real[From PSSIS Membership Reg] The Student’s number.Current Grade Level (ver5.0.0)Longint[From PSSIS Membership Reg] The Student’s current grade level.Current School Abbreviation(ver5.0.0)String 20[From PSSIS Membership Reg] The School’s abbreviation.Gender (ver5.0.0)String 2[From PSSIS NCLB Fields] The Student’s gender (M, F).Ethnicity Name (ver5.0.0)String 50[From PSSIS NCLB Fields] The Student’s Ethnicity Name.Ethnicity Code (ver5.0.0)String 20[From PSSIS NCLB Fields] The Student’s Ethnicity Code.Special Ed Student (ver5.0.0)String 3[From PSSIS NCLB Fields] Flag to show whether or not this Student is aSpecial Ed Student.Attendance School Abbreviation(ver5.0.0)String 20[From Schools] The School’s abbreviation.StudentID (ver5.0.0)Longint[From PSSIS Membership Reg] The internal number for the student thisrecord is associated. Indexed.SchoolID (ver5.0.0)Longint[From PSSIS Membership Reg] The unique School identifier. Indexed.CalendarDate (ver5.0.0)Date[From PSSIS Membership Reg] The Calendar date.FTEID (ver5.0.0)Longint[From PSSIS Membership Reg] Key to the FTE table. Indexed.Attendance Conversion ID (ver5.0.0) LongintSIS Repository Views[From PSSIS Membership Reg] Key to the Attendance Conversion table.3

Data Dictionary SIS ViewsColumn NameData TypeDescriptionIndexed.AttendanceValue (ver5.0.0)Real[From Attendance Conversion Items] The attendance value to use for astudent for a day (a real number typically a fraction of 1).MembershipValue (ver5.0.0)Real[Derived] Student membership derived from the PS Membership Regview.Grade Level (ver5.0.0)Longint[From PSSIS Membership Reg] Student Grade Level.OnTrack (ver5.0.0)Longint[Derived] The value is determined from the track information returned bythe PSSIS Membership Reg view and the Calendar Day track values.OffTrack (ver5.0.0)Longint[Derived] The value is determined from the track information returned bythe PSSIS Membership Reg view and the Calendar Day track values.Student Track (ver5.0.0)String 20[From PSSIS Membership Reg] Represents the calendar days during theyear when the Student goes to school.Potential AttendanceValueReal[Derived] Total attendance possible for a student for a day.PSSIS AdaAdm Daily Ttod (ver5.0.0)This View may be used for gathering Daily Attendance records (using Time to Day conversion).Column NameData TypeDescriptionName (ver5.0.0)String 35[From PSSIS Membership Reg] The Student’s last, first name.Student Number (ver5.0.0)Real[From PSSIS Membership Reg] The Student’s number.Current Grade Level (ver5.0.0)Longint[From PSSIS Membership Reg] The Student’s current grade level.Current School Abbreviation(ver5.0.0)String 20[From PSSIS Membership Reg] The School’s abbreviation.Gender (ver5.0.0)String 2[From PSSIS NCLB Fields] The Student’s gender (M, F).Ethnicity Name (ver5.0.0)String 50[From PSSIS NCLB Fields] The Student’s Ethnicity Name.SIS Repository Views4

Data Dictionary SIS ViewsColumn NameData TypeDescriptionEthnicity Code (ver5.0.0)String 20[From PSSIS NCLB Fields] The Student’s Ethnicity Code.Special Ed Student (ver5.0.0)String 3[From PSSIS NCLB Fields] Flag to show whether or not this Student is aSpecial Ed Student.Attendance School Abbreviation(ver5.0.0)String 20[From Schools] The School’s abbreviation.StudentID (ver5.0.0)Longint[From PSSIS Membership Reg] The internal number for the student thisrecord is associated. Indexed.SchoolID (ver5.0.0)Longint[From PSSIS Membership Reg] The unique School identifier. Indexed.CalendarDate (ver5.0.0)Date[From PSSIS Membership Reg] The Calendar date.FTEID (ver5.0.0)Longint[From PSSIS Membership Reg] Key to the FTE table. Indexed.Attendance Conversion ID (ver5.0.0) Longint[From PSSIS Membership Reg] Key to the Attendance Conversion table.Indexed.AttendanceValue (ver5.0.0)Real[From Attendance Conversion Items] The attendance value to use for astudent for a day (a real number typically a fraction of 1).MembershipValue (ver5.0.0)Real[Derived] Student membership derived from the PSSIS Membership Regview.Grade Level (ver5.0.0)Longint[From PSSIS Membership Reg] Student Grade Level.OnTrack (ver5.0.0)Longint[Derived] The value is determined from the track information returned bythe PSSIS Membership Reg view and the Calendar Day track values.OffTrack (ver5.0.0)Longint[Derived] The value is determined from the track information returned bythe PSSIS Membership Reg view and the Calendar Day track values.Student Track (ver5.0.0)String 20[From PSSIS Membership Reg] Represents the calendar days during theyear when the Student goes to school.Potential AttendanceValueReal[Derived] Total attendance possible for a student for a day.SIS Repository Views5

Data Dictionary SIS ViewsPSSIS AdaAdm Interval Ttod (ver5.0.0)This View may be used for gathering Interval Attendance records (using Time to Day conversion).Column NameData TypeDescriptionName (ver5.0.0)String 35[From PSSIS Membership Reg] The Student’s last, first name.Student Number (ver5.0.0)Real[From PSSIS Membership Reg] The Student’s number.Current Grade Level (ver5.0.0)Longint[From PSSIS Membership Reg] The Student’s current grade level.Current School Abbreviation(ver5.0.0)String 20[From PSSIS Membership Reg] The School’s abbreviation.Gender (ver5.0.0)String 2[From PSSIS NCLB Fields] The Student’s gender (M, F).Ethnicity Name (ver5.0.0)String 50[From PSSIS NCLB Fields] The Student’s Ethnicity Name.Ethnicity Code (ver5.0.0)String 20[From PSSIS NCLB Fields] The Student’s Ethnicity Code.Special Ed Student (ver5.0.0)String 3[From PSSIS NCLB Fields] Flag to show whether or not this Student is aSpecial Ed Student.Attendance School Abbreviation(ver5.0.0)String 20[From Schools] The School’s abbreviation.StudentID (ver5.0.0)Longint[From PSSIS Membership Reg] The internal number for the student thisrecord is associated. Indexed.SchoolID (ver5.0.0)Longint[From PSSIS Membership Reg] The unique School identifier. Indexed.CalendarDate (ver5.0.0)Date[From PSSIS Membership Reg] The Calendar date.FTEID (ver5.0.0)Longint[From PSSIS Membership Reg] Key to the FTE table. Indexed.Attendance Conversion ID (ver5.0.0) Longint[From PSSIS Membership Reg] Key to the Attendance Conversion table.Indexed.AttendanceValue (ver5.0.0)[From Attendance Conversion Items] The attendance value to use for astudent for a day (a real number typically a fraction of 1).SIS Repository ViewsReal6