powerschool data dictionary sis views - island trees … · · 2015-03-04pssis_attendance_daily...

Data Dictionary SIS Views

PowerSchool Premier 5.2 Student Information System

Released July 2008

Document Owner: Documentation Services

This edition applies to Release 5.2 of the PowerSchool Premier software and to all subsequent releases and modifications until otherwise indicated 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 otherwise indicated 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. All of 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 Pearson Education, Inc. or its affiliates. Other brands and names are the property of their respective owners.


Contents Introduction............................................................................................................................................................. 1

SIS Views ................................................................................................................................................. 1 Purpose .................................................................................................................................................... 1 Audience................................................................................................................................................... 1 Conventions .............................................................................................................................................. 2

SIS Repository Views ............................................................................................................................................... 3 PSSIS_AdaAdm_Daily_Ctod (ver5.0.0).......................................................................................................... 3 PSSIS_AdaAdm_Daily_Ttod (ver5.0.0) .......................................................................................................... 4 PSSIS_AdaAdm_Interval_Ttod (ver5.0.0) ...................................................................................................... 6 PSSIS_AdaAdm_Meeting_Ptod (ver5.0.0) ...................................................................................................... 7 PSSIS_AdaAdm_Meeting_Ttod (ver5.0.0) ...................................................................................................... 9 PSSIS_AdaAdm_TimeInter_Ttod (ver5.0.0) ..................................................................................................10 PSSIS_AdaAdm_Time_Ttod (ver5.0.0) .........................................................................................................12 PSSIS_Attendance_Daily (ver5.0.0).............................................................................................................13 PSSIS_Attendance_Interval (ver5.0.0) .........................................................................................................15 PSSIS_Attendance_Meeting (ver5.0.0).........................................................................................................18 PSSIS_Attendance_Time (ver5.0.0) .............................................................................................................21 PSSIS_Attendance_TimeInter (ver5.0.0) ......................................................................................................23 PSSIS_Bus_Routes (ver5.0.0).....................................................................................................................25 PSSIS_Enrollment_All (ver5.0.0) .................................................................................................................25 PSSIS_Membership_Defaults (ver5.0.0) .......................................................................................................27 PSSIS_Membership_Prog (ver5.0.0) ............................................................................................................28 PSSIS_Membership_Reg (ver5.0.0) .............................................................................................................30 PSSIS_NCLB_Fields (ver5.0.0) ....................................................................................................................32

Contents iii


PSSIS_Special_Pgm_Enrollments (ver5.0.0) .................................................................................................33 PSSIS_Standards (ver5.0.0) .......................................................................................................................33 PSSIS_Student_Addresses (ver5.0.0) ..........................................................................................................34 PSSIS_Student_Alerts (ver5.0.0) ................................................................................................................35 PSSIS_Student_Sched_Class_Term (ver5.0.0) ..............................................................................................36 PSSIS_Student_Demographics (ver5.0.0).....................................................................................................37 PSSIS_Student_Discip_Summary (ver5.0.0) .................................................................................................39 PSSIS_Student_Enrollments (ver5.0.0) ........................................................................................................41 PSSIS_Student_Fees (ver5.0.0) ..................................................................................................................43 PSSIS_Student_Relationships (ver5.0.0) ......................................................................................................45 PSSIS_Student_Scheduling (ver5.0.0) .........................................................................................................46 PSSIS_Student_Stored_Standards (ver5.0.0)................................................................................................47 PSSIS_Student_Test_Scores (ver5.0.0)........................................................................................................49 PSSIS_Student_Transportation (ver5.0.0) ....................................................................................................50 PVSIS_Custom_CC (ver5.1.0) .....................................................................................................................52 PVSIS_Custom_Courses (ver5.1.0)..............................................................................................................53 PVSIS_Custom_Fee (ver5.1.0)....................................................................................................................54 PVSIS_Custom_Fee_Transaction (ver5.1.0) ..................................................................................................55 PVSIS_Custom_Fee_Type (ver5.1.0) ...........................................................................................................56 PVSIS_Custom_Log (ver5.1.0)....................................................................................................................57 PVSIS_Custom_ReEnrollments (ver5.1.0) .....................................................................................................58 PVSIS_Custom_SchoolFee (ver5.1.0)...........................................................................................................59 PVSIS_Custom_Schools (ver5.1.0) ..............................................................................................................61 PVSIS_Custom_Sections (ver5.1.0) .............................................................................................................61 PVSIS_Custom_SPEnrollments (ver5.1.0) .....................................................................................................63 PVSIS_Custom_Students (ver5.1.0) ............................................................................................................64

Contents iv


Contents v

PVSIS_Custom_Teachers (ver5.1.0) ............................................................................................................65 Notes ..................................................................................................................................................................... 67


Introduction In Database Management Systems (DBMS), the collection of information that defines the basic organization of a database – and the objects contained therein - is called the Data Dictionary. The Data Dictionary typically contains a list of all tables in the database, the column definitions in each table, the types of each field, and an associated description.

SIS Views

The 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 retrieve and where the information resides in the database. Complex business logic and calculations are designed into the data views so querying 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.

Purpose

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.

Audience

This document is intended for a district or school’s database administrators (DBA). A DBA directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system, and establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system.

Introduction 1


Conventions

Tables and (views) follow a standard convention. Table (or view) names appear as the table title along with the version string indicating 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.

Introduction 2


SIS Repository Views

PSSIS_AdaAdm_Daily_Ctod (ver5.0.0)

This View may be used for gathering Daily Attendance records (using Code to Day conversion).

Column Name Data Type Description

Name (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 a Special 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 this record 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.

SIS Repository Views 3




Indexed.

AttendanceValue (ver5.0.0) Real [From Attendance_Conversion_Items] The attendance value to use for a student for a day (a real number typically a fraction of 1).

MembershipValue (ver5.0.0) Real [Derived] Student membership derived from the PS_Membership_Reg view.

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 by the 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 by the 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 the year when the Student goes to school.

Potential_AttendanceValue Real [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).




















Attendance_Conversion_ID (ver5.0.0) Longint [From PSSIS_Membership_Reg] Key to the Attendance_Conversion table. Indexed.


MembershipValue (ver5.0.0) Real [Derived] Student membership derived from the PSSIS_Membership_Reg view.







PSSIS_AdaAdm_Interval_Ttod (ver5.0.0)

This View may be used for gathering Interval Attendance records (using Time to Day conversion).























MembershipValue (ver5.0.0) Real [Derived] Student membership derived from the PSSIS_Membership_Reg view.






PSSIS_AdaAdm_Meeting_Ptod (ver5.0.0)

This View may be used for gathering Meeting Attendance records (using Period to Day conversion).


Name (ver5.0.0) String 35 [From PSSIS_Membership_Defaults] The Student’s last, first name.

Student_Number (ver5.0.0) Real [From PSSIS_Membership_Defaults] The Student’s number.

Current_Grade_Level (ver5.0.0) Longint [From PSSIS_Membership_Defaults] The Student’s current grade level.


String 20 [From PSSIS_Membership_Defaults] The School’s abbreviation.




Special_Ed_Student (ver5.0.0) String 3 [From PSSIS_NCLB_Fields] Flag to show whether or not this Student is a




Special Ed Student.



StudentID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] The internal number for the student this record is associated. Indexed.

SchoolID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] The unique School identifier. Indexed.

CalendarDate (ver5.0.0) Date [From PSSIS_Membership_Defaults] The Calendar date.

FTEID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] Key to the FTE table. Indexed.

Attendance_Conversion_ID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] Key to the Attendance_Conversion table. Indexed.

PeriodCount (ver5.0.0) Longint [Derived] Count from the PS_Attendance_Meeting view (where the count_for_ada value = 1).


MembershipValue (ver5.0.0) Real [Derived] Student membership derived from the PS_Membership_Defaults view.

Grade_Level (ver5.0.0) Longint [From PSSIS_Membership_Defaults] Student Grade Level.

OnTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Membership_Defaults view and the Calendar_Day track values.

OffTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Membership_Defaults view and the Calendar_Day track values.

Student_Track (ver5.0.0) String 20 [From PSSIS_Membership_Defaults] Represents the calendar days during




the year when the Student goes to school.


PSSIS_AdaAdm_Meeting_Ttod (ver5.0.0)

This View may be used for gathering Meeting Attendance records (using Time to Day conversion).


Name (ver5.0.0) String 35 [From PSSIS_Membership_Defaults] The Student’s last, first name.

Student_Number (ver5.0.0) Real [From PSSIS_Membership_Defaults] The Student’s number.

Current_Grade_Level (ver5.0.0) Longint [From PSSIS_Membership_Defaults] The Student’s current grade level.


String 20 [From PSSIS_Membership_Defaults] The School’s abbreviation.







StudentID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] The internal number for the student this record is associated. Indexed.

SchoolID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] The unique School identifier. Indexed.

CalendarDate (ver5.0.0) Date [From PSSIS_Membership_Defaults] The Calendar date.




FTEID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] Key to the FTE table. Indexed.

Attendance_Conversion_ID (ver5.0.0) Longint [From PSSIS_Membership_Defaults] Key to the Attendance_Conversion table. Indexed.



Grade_Level (ver5.0.0) Longint [From PSSIS_Membership_Defaults] Student Grade Level.

OnTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Membership_Defaults view and the Calendar_Day track values.

OffTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Membership_Defaults view and the Calendar_Day track values.

Student_Track (ver5.0.0) String 20 [From PSSIS_Membership_Defaults] Represents the calendar days during the year when the Student goes to school.


PSSIS_AdaAdm_TimeInter_Ttod (ver5.0.0)

This View may be used for gathering Time and Interval Attendance records (using Time to Day conversion).





















Total_Minutes (ver5.0.0) Real [Derived] Sum of the total minutes from the PSSIS_Attendance_TimeInter view (where the att_mode_code is Time or Interval and status is present).











PSSIS_AdaAdm_Time_Ttod (ver5.0.0)

This View may be used for gathering Time Attendance records (using Time to Day conversion).




























PSSIS_Attendance_Daily (ver5.0.0)

This View will provide all Daily Attendance records that fall within a valid in-session school calendar day. This will include both present and absent attendance records.












ID (ver5.0.0) Longint [From Attendance] Unique ID from the Attendance table. Indexed.

StudentID (ver5.0.0) Longint [From Students] The internal number for the student this record is associated. Indexed.

SchoolID (ver5.0.0) Longint [From Attendance] ID Linked to the School_Number from the Schools table. Indexed.

Att_Date (ver5.0.0) Date [From Attendance] The Attendance Date from the Attendance Code table. Indexed.

Attendance_CodeID (ver5.0.0) Longint [From Attendance] The Attendance Code ID from the Attendance Code table. Indexed.

Att_Code (ver5.0.0) String 10 [From Attendance_Code] The Attendance Code value from the Attendance Code table. Indexed.

Att_Mode_Code (ver5.0.0) String 20 [From Attendance] The Attendance Mode Code from the Attendance Code table. Indexed.

Calendar_DayID (ver5.0.0) Longint [From Calendar_Day] The unique identifier from the Calendar_Day table.





ProgramID (ver5.0.0) Longint [From Attendance] The program ID located in the Attendance table.

Att_Comment (ver5.0.0) String 1024 [From Attendance] The Attendance comment.

Program_Name (ver5.0.0) String 50 [From Gen] The Program Name associated with the Program ID.

Track_A (ver5.0.0) Longint [From Calendar_Day] Track A from Calendar_Day.

Track_B (ver5.0.0) Longint [From Calendar_Day] Track B from Calendar_Day.

Track_C (ver5.0.0) Longint [From Calendar_Day] Track C from Calendar_Day.

Track_D (ver5.0.0) Longint [From Calendar_Day] Track D from Calendar_Day.

Track_E (ver5.0.0) Longint [From Calendar_Day] Track E from Calendar_Day.

Track_F (ver5.0.0) Longint [From Calendar_Day] Track F from Calendar_Day.

InSession (ver5.0.0) Longint [From Calendar_Day] In session flag from the calendar Day table.

Count_For_ADA (ver5.0.0) Longint [From Attendance_Code] Calculate ADA (y or n).

Presence_Status_CD (ver5.0.0) String 10 [From Attendance_Code] Presence status code from the Attendance_Code table.

Cycle_Day_ID (ver5.0.0) Longint [From Calendar_Day] Cycle day unique ID. Indexed.

Cycle_Day_Abbreviation (ver5.0.0) String 3 [From Cycle_Day] Cycle Day (3 character) Abbreviation.

Total_Minutes (ver5.0.0) Real [From Attendance] The total minutes from the Attendance table (Daily Mode).

PSSIS_Attendance_Interval (ver5.0.0)

This View will provide all Interval Attendance records that fall within a valid in-session school calendar day. This will include both present and absent attendance records.



















Att_Interval (ver5.0.0) Longint [From Attendance] The Attendance Interval from the Attendance table.





Indexed.


CCID (ver5.0.0) Longint [From Attendance] Foreign key to the CC table. Indexed.


CC_SchoolID (ver5.0.0) Longint [From CC] Foreign key to the Schools table from CC. Indexed.

Dropped (ver5.0.5) Longint [Derived] 1 if class has been dropped (negative sectionid in CC). 0 if class not dropped.

PeriodID (ver5.0.0) Longint [From Attendance] Foreign key to the Period table from Attendance. Indexed.

Period_Abbreviation (ver5.0.0) String 3 [From Period] The period abbreviation value from the Period table.

Period_Number (ver5.0.0) Longint [From Period] The period Number value from the Period table. Indexed.

SectionID (ver5.0.0) Longint [From Sections] Primary key from the Sections table. Indexed.

Section_Number (ver5.0.0) String 10 [From Sections] Actual section number value from the Sections table. Indexed.












InSession (ver5.0.0) Longint [From Calendar_Day] In session flag from the calenday Day table.





Total_Minutes (ver5.0.0) Longint [From Attendance] The total minutes from the Attendance table (Daily Mode).

PSSIS_Attendance_Meeting (ver5.0.0)

This View will provide all Meeting Attendance records that fall within a valid student class enrollment, valid student school enrollment, and valid calendar in-session school day. This will include both present and absent attendance records.





















Att_Interval (ver5.0.0) Longint [From Attendance] The Attendance Interval from the Attendance table. Indexed.





Dropped (ver5.0.5) Longint [Derived] 1 if class has been dropped (negative sectionid in CC). 0 if class not dropped.







SectionID (ver5.0.0) Longint [From Sections] Primary key from the Sections table. Indexed.

Section_Number (ver5.0.0) String 10 [From Sections] Actual section number value from the Sections table. Indexed.
















PSSIS_Attendance_Time (ver5.0.0)

This View will provide all Time Attendance records that fall within a valid in-session school calendar day. This will include both present and absent attendance records.



















PSSIS_Attendance_TimeInter (ver5.0.0)

This View will provide all Time and Interval Attendance records that fall within a valid student class enrollment, valid student school enrollment, and valid calendar in-session school day. This will include both present and absent attendance records.






















Att_Interval (ver5.0.0) Longint [From Attendance] The Attendance Interval from the Attendance table. Indexed.

























PSSIS_Bus_Routes (ver5.0.0)

This View will provide information related to Bus Routes associated with the School.


Route_Number (ver5.0.0) String 79 [From Transportation] The Route Number.

Bus_Number (ver5.0.0) String 79 [From Transportation] The Bus Number.

Driver_Name (ver5.0.0) String 79 [From Transportation] The Bus Driver’s Name.

Number_Of_Students (ver5.0.0) Longint [Derived] Count of the number of Students associated with this Route, Bus and Driver.

PSSIS_Enrollment_All (ver5.0.0)

This View will provide Current Enrollment, Previous Enrollment and Special Program Enrollment information.


StudentID (ver5.0.0) Longint [From Students & ReEnrollments] The internal number for the student this record is associated. Indexed.

SchoolID (ver5.0.0) Longint [From Students & ReEnrollments] ID Linked to the School_Number from




the Schools table. Indexed.

EntryDate (ver5.0.0) Date [From Students & ReEnrollments] Entry (enrollment) date into the school. Indexed.

EntryCode (ver5.0.0) String 20 [From Students & ReEnrollments] Entry (enrollment) code into the school. Indexed.

ExitDate (ver5.0.0) Date [From Students & ReEnrollments] Exit date from the school. Indexed.

ExitCode (ver5.0.0) String 20 [From Students & ReEnrollments] Exit code from the school. Indexed.

Grade_Level (ver5.0.0) Longint [From Students & ReEnrollments] The Student’s current grade level.

ProgramID (ver5.0.0) Longint [From SPEnrollments] The Foreign key to the Program table from SPEnrollments; otherwise –1.

FTEID (ver5.0.0) Longint [From Students & ReEnrollments] The FTE ID from the FTE table. Indexed.

MembershipShare (ver5.0.0) Real [From Students & ReEnrollments] The amount of a Student’s membership this school claims.

Track (ver5.0.0) String 20 [From Students & ReEnrollments] Represents the calendar days during the year when the Student goes to school.

Dflt_Att_Mode_Code (ver5.0.0) String 13 [From FTE] Default Attendance Mode Code. Indexed.

Dflt_Conversion_Mode_Code (ver5.0.0)

String 11 [From FTE] Default Conversion Mode Code. Indexed.

YearId (Ver5.0.0) Int [From Terms] Current school year for the student.

ATT_CalcCntPresentAbsent (ver5.0.0) String 7 [From Prefs] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences).

ATT_IntervalDuration (ver5.0.0) String 30 [From Prefs] The Interval Duration from the Prefs table (ATT_IntervalDuration).


PSSIS_Membership_Defaults (ver5.0.0)

This View will provide Current Enrollment and Previous Enrollment information.




CalendarDate (ver5.0.0) Date [From Calendar_Day] The date value from Calendar_Day. Indexed.

StudentMembership (ver5.0.0) Real [From PSSIS_Enrollment_All] The student membership value from the PS_Enrollment_Reg view.

CalendarMembership (ver5.0.0) Real [From Calendar_Day] The student’s Calendar membership value.

Student_Track (ver5.0.0) String 20 [From PSSIS_Enrollment_All] Represents the calendar days during the year when the Student goes to school.


Attendance_Conversion_ID (ver5.0.0) Longint [From Bell_Schedule] Foreign key to the Attendance Conversion table. Indexed.

Dflt_Att_Mode_Code (ver5.0.0) String 13 [From PSSIS_Enrollment_All] Default Attendance Mode Code. Indexed.


String 11 [From PSSIS_Enrollment_All] Default Conversion Mode Code. Indexed.













OnTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Enrollment_All view and the Calendar_Day track values.

OffTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Enrollment_All view and the Calendar_Day track values.


Bell_Schedule_ID (ver5.0.0) Longint [From Bell_Schedule] Foreign key to the Bell Schedule table. Indexed.

Cycle_Day_ID (ver5.0.0) Longint [From Cycle_Day] Foreign key to the Cycle_Day table. Indexed.

YearId (Ver5.0.0) Longint [From Terms] Current school year for the student.

Potential_Periods_Present Longint [Derived} Total periods possible for a student for a day.

Potential_Minutes_Present Longint [Derived} Total attendance minutes possible for a student for a day.

Period_Absent Longint [Derived} Total periods absent for a student for a day.

Minutes_Absent Longint [Derived} Total minutes absent for a student for a day.

PSSIS_Membership_Prog (ver5.0.0)

This View will provide student membership information for each day that they have an active enrollment on valid in-session school days.














ProgramID (ver5.0.0) Longint [From SPEnrollments] The Foreign key to the Program table from SPEnrollments; otherwise –1.


StudentMembership (ver5.0.0) Real [From PSSIS_Membership_Reg] The student membership value from the PS_Enrollment_Reg view.


Track (ver5.0.0) String 20 [From PSSIS_Membership_Reg] Represents the calendar days during the year when the Student goes to school.







Dflt_Att_Mode_Code (ver5.0.0) String 13 [From PSSIS_Membership_Reg] Default Attendance Mode Code. Indexed.


String 11 [From PSSIS_Membership_Reg] Default Conversion Mode Code. Indexed.



PSSIS_Membership_Reg (ver5.0.0)

This View will provide student membership information for each day that they have an active enrollment on valid in-session school days.


Name (ver5.0.0) String 35 [From PSSIS_Enrollement_All] The Student’s last, first name.

Student_Number (ver5.0.0) Real [From PSSIS_Enrollement_All] The Student’s number.

Current_Grade_Level (ver5.0.0) Longint [From PSSIS_Enrollement_All] The Student’s current grade level.


String 20 [From PSSIS_Enrollement_All] The School’s abbreviation.











StudentMembership (ver5.0.0) Real [From PSSIS_Enrollement_All] The student membership value from the PS_Enrollment_Reg view.


Student_Track (ver5.0.0) String 20 [From PSSIS_Enrollement_All] Represents the calendar days during the year when the Student goes to school.



Dflt_Att_Mode_Code (ver5.0.0) String 13 [From PSSIS_Enrollement_All] Default Attendance Mode Code. Indexed.


String 11 [From PSSIS_Enrollement_All] Default Conversion Mode Code. Indexed.












OnTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Enrollement_All view and the Calendar_Day track values.

OffTrack (ver5.0.0) Longint [Derived] The value is determined from the track information returned by the PSSIS_Enrollement_All view and the Calendar_Day track values.


Bell_Schedule_ID (ver5.0.0) Longint [From Bell_Schedule] Foreign key to the Bell Schedule table. Indexed.

Cycle_Day_ID Longint [From Cycle_Day] Foreign key to the Cycle_Day table. Indexed.

YearId (Ver5.0.0) Longint [From Terms] Current school year for the student.

PSSIS_NCLB_Fields (ver5.0.0)

This View (typically to be used by other Views) will provide basic demographic information related to Students.


StudentID (ver5.0.0) Longint [From Students] The unique Student identifier. Indexed.

Gender (ver5.0.0) String 2 [From Students] The Student’s gender (M, F).

Ethnicity_Name (ver5.0.0) String 50 [From Gen] The Student’s Ethnicity Name.

Ethnicity_Code (ver5.0.0) String 20 [From Students] The Student’s Ethnicity Code.

Special_Ed_Student (ver5.0.0) String 3 [From Gen, SpEnrollments] Flag to show whether or not this Student is a Special Ed Student.


PSSIS_Special_Pgm_Enrollments (ver5.0.0)

This View will provide Special Enrollments information. Note that the Text Value from the Gen table has been converted [and thus perhaps truncated] to a character string in this view.


Name (ver5.0.0) String 35 [From Students] The Student Last Name, First Name. Indexed.

Student_Number (ver5.0.0) Real [From Students] The unique Student identifier. Indexed.


String 20 [From Schools] The Current School’s abbreviation.

Grade (ver5.0.0) Longint [From Students] The Student’s current grade level.

SEOP_Code (ver5.0.0) String 15 [From SpEnrollments] SEOP self-containing code.

SEOP_Setting_Code (ver5.0.0) String 15 [From SpEnrollments] SEOP setting code.

Comment_Value (ver5.0.0) Text [From SpEnrollments] The SpEnrollments comment.

Exit_Reason (ver5.0.0) String 2048 [From GEN] The text value from GEN where the category = ‘exitcodes’.

Enter_Date (ver5.0.0) Date [From SpEnrollments] The enrollment entry date. Indexed.

Exit_Date (ver5.0.0) Date [From SpEnrollments] The enrollment exit date. Indexed.

Grade_Level (ver5.0.0) Longint [From SpEnrollments] The Student’s current enrollments grade level.

Program_Name (ver5.0.0) String 50 [From GEN] The text value from GEN where the category = ‘spenrollments.ProgramID’.

PSSIS_Standards (ver5.0.0)

This View will provide information from the Standards & Gen tables.


ID (ver5.0.0) Longint [From Standards] The Standards Identifier. Indexed.





AllowAssignments (ver5.0.0) Longint [From Standards] The Allowed Assignments for this Standard.

CalculationParent (ver5.0.0) String 20 [From Standards] Standards Parent Calculation.

ConversionScaleName (ver5.0.0) String 50 [From Gen] The Conversion Scale Name where the gen.category = ‘stdconvscale’.

ConversionScaleText (ver5.0.0) Text [From Gen] The Conversion Scale Text value where the gen.category = ‘stdconvscale’.

ConversionScaleReal (ver5.0.0) Real [From Gen] The Conversion Scale Real value where the gen.category = ‘stdconvscale’.

Courses (ver5.0.0) Text [From Standards] Course information from the Standards table.

StandardDescription (ver5.0.0) Text [From Standards] The standards description.

Identifier (ver5.0.0) String 20 [From Standards] Unique identifier for this Standard.

IncludeComment (ver5.0.0) Longint [From Standards] Standards comment text.

LevelValue (ver5.0.0) Longint [From Standards] Standards Level Value.

ListParent (ver5.0.0) String 20 [From Standards] Parent standard value.

Name (ver5.0.0) String 80 [From Standards] Standard name value.

SubjectArea (ver5.0.0) String 40 [From Standards] Specific subject area for this Standard.

Type (ver5.0.0) String 8 [Derived] Depending upon the Standards type value (e.g., ‘National’, ‘District’, ‘State’, ‘School’).

PSSIS_Student_Addresses (ver5.0.0)

This View will provide information related to the various forms of Student Addresses for currently enrolled students. Specifically, the union of the ‘Physical’ & ‘Mailing’ addresses.





Current_Grade (ver5.0.0) Longint [From Students] The Student’s current grade level.



Current_Enroll_Status (ver5.0.0) String 15 [From Students] Enrollment status as a sting value (e.g., 'Inactive', 'Pre-registered', 'Active', etc.). Indexed.

Address_Type (ver5.0.0) String 8 [Derived] the ‘Physical’ & ‘Mailing’ addresses.

Street (ver5.0.0) String 60 [From Students] The Student’s Street name.

City (ver5.0.0) String 50 [From Students] The Student’s City name.

State (ver5.0.0) String 2 [From Students] The Student’s State name.

Zip (ver5.0.0) String 10 [From Students] The Student’s Zip Code value.

PSSIS_Student_Alerts (ver5.0.0)

This View will provide information related to the various forms of Student Alerts.






Grade (ver5.0.0) Longint [From Students] The Student’s current grade level.





Alert_Discipline (ver5.0.0) Text [From Students] Stores the text associated with the Alert.

Alert_DisciplineExpires (ver5.0.0) Date [From Students] Stored the expiration date associated with the Alter.

Alert_Guardian (ver5.0.0) Text [From Students] Stores the text associated with the Alert.

Alert_GuardianExpires (ver5.0.0) Date [From Students] Stored the expiration date associated with the Alter.

Alert_Medical (ver5.0.0) Text [From Students] Stores the text associated with the Alert.

Alert_MedicalExpires (ver5.0.0) Date [From Students] Stored the expiration date associated with the Alter.

Alert_Other (ver5.0.0) Text [From Students] Stores the text associated with the Alert.

Alert_OtherExpires (ver5.0.0) Date [From Students] Stored the expiration date associated with the Alter.

PSSIS_Student_Sched_Class_Term (ver5.0.0)

This View will provide scheduling information as well as Class and Term details.






Grade (ver5.0.0) Longint [From Students] The Student’s current grade level. Indexed.

Gender (ver5.0.0) String 2 [From Students] Gender indicator. Indexed.

Ethnicity_Name (ver5.0.0) String 50 [From GEN] Ethnicity from the Gen table where category = ‘Ethnicity’.

Ethnicity_Code (ver5.0.0) String 20 [From Students custom field] The student’s Primary Language as decoded in the CustomVarchars table.




Special_Ed_Student (ver5.0.0) String 3 [From Students custom field] The student’s Secondary Language as decoded in the CustomVarchars table.

Current_Building (ver5.0.0) String 10 [From Students] Student’s current building.

Current_Homeroom (ver5.0.0) String 60 [From Students] Student’s current Homeroom assignment.

Current_House (ver5.0.0) String 10 [From Students] Student’s current house, if applicable.

Current_Next_School (ver5.0.0) Longint [From Students] Student’s next school, if applicable.

Locker_Number (ver5.0.0) String 15 [From Students] The Locker number.

Locker_Combination (ver5.0.0) String 20 [From Students] Encrypted version of the Locker Combination.

Course_Number (ver5.0.0) String 11 [From Courses] Student’s course information.

Course_Name (ver5.0.0) String 40 [From Courses] Name of the Course associated with the Course Number.

Section_Number (ver5.0.0) String 10 [From CC] Section number.

Section_Expression (ver5.0.0) String 80 [From Sections] Encoded expression for this Section.

Teacher_Name (ver5.0.0) String 40 [From Teachers] Teacher name – last, first.

Room_Number (ver5.0.0) String 10 [From Sections] Room Number for this Section / Course.

Term (ver5.0.0) String 6 [From Terms] Actual Term value.

Term_First_Day (ver5.0.0) Date [From Terms] First day of term.

Term_Last_Day (ver5.0.0) Date [From Terms] Last day of Term.

Section_School (ver5.0.0) String 20 [From Schools] School associated with this Section.

PSSIS_Student_Demographics (ver5.0.0)

This View will provide demographics information related to Students.





Current_Grade_Level (ver5.0.0) Longint [From Students] The Student’s current grade level. Indexed.








Number_years_In_District (ver5.0.0) Longint [From Demographic] Single Parent Household flag from Demographics.

Middle_Name (ver5.0.0) String 20 [From Students] The students’ middle name.

Last_Name (ver5.0.0) String 20 [From Students] The students’ last name.

First_Name (ver5.0.0) String 15 [From Students] The students’ first name.

Date_Of_Birth (ver5.0.0) Date [From Students] The students’ date of birth.

ClassOf (ver5.0.0) Longint [From Students] The students’ graduation class year.

DistrictEntryDate (ver5.0.0) Date [From Students] The date of entry into the district.

DistrictEntryGradeLevel (ver5.0.0) Longint [From Students] The students’ grade level of entry into the district.

DistrictofResidence (ver5.0.0) String 20 [From Students] The district in which the student resides.





Exclude_From_Rank (ver5.0.0) String 3 [From Students] Exclude from ranking.

Family_Ident (ver5.0.0) String 30 [From Students] Family identifier.

Fee_Exemption_Status (ver5.0.0) String 33 [From Students] Fee exempt status indicator.

Graduation_Req_Set (ver5.0.0) String 40 [From GradReqSets] The name of the graduation requirement set.

Home_Phone (ver5.0.0) String 30 [From Students] The students’ home phone number. Indexed.

Locker_Combination (ver5.0.0) String 20 [From Students] The students’ encrypted locker combination.

Locker_Number (ver5.0.0) String 15 [From Students] The students’ locker number.

PhotoFlag (ver5.0.0) Longint [From Students] The students’ photo flag.

SSN (ver5.0.0) String 12 [From Students] The students’ social security number.

Exclude_From_Reporting (ver5.0.0) String 3 [From Students] Exclude from state reporting flag.

State_Enrolled (ver5.0.0) String 3 [From Students] The state enrolled flag.

State_Student_Number (ver5.0.0) String 20 [From Students] The students’ state-provided number.

Allow_Web_Access (ver5.0.0) String 3 [From Students] Whether or not to allow web access.

Web_ID (ver5.0.0) String 20 [From Students] The students’ web ID. Indexed.

Web_Password (ver5.0.0) Text [From Students] The students’ web password. Indexed.

MembershipShare (ver5.0.0) Real [From Students] The students’ membership share as a fractional value.

PSSIS_Student_Discip_Summary (ver5.0.0)

This View will provide summarized Discipline information related to Students.












Log_Type (ver5.0.0) String 50 [From Gen] Log type indicator.

Incident_Sub_Type (ver5.0.0) String 20 [From Log] not yet populated.

Incident_Date (ver5.0.0) Date [From Log] not yet populated.

Incident_Type (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Type_Category (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Context (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Location (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Offender (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Reporter (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Victim_Type (ver5.0.0) String 79 [From Log] not yet populated.





Incident_Felony (ver5.0.0) Longint [From Log] not yet populated.

Incident_Gang_Related (ver5.0.0) Longint [From Log] not yet populated.

Incident_Hate_Crime (ver5.0.0) Longint [From Log] not yet populated.

Incident_Alcohol (ver5.0.0) Longint [From Log] not yet populated.

Incident_Drug (ver5.0.0) Longint [From Log] not yet populated.

Incident_Weapon (ver5.0.0) Longint [From Log] not yet populated.

Incident_Weapon_Type (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Action_Taken (ver5.0.0) String 79 [From Log] not yet populated.

Incident_Money_Loss (ver5.0.0) Real [From Log] not yet populated.

PSSIS_Student_Enrollments (ver5.0.0)

This View will provide enrollment information related to Students. This will essentially be a union of the information from the Students and ReEnrollments tables.








EnrollmentCode (ver5.0.0) Longint [From Students custom field] The student’s Primary Language as decoded




in the CustomVarchars table.

EnrollmentType (ver5.0.0) String 2 [From Students] 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

Full_Time_Equivalency (ver5.0.0) String 80 [From Students] The internal number for the FTE with which this record is associated. Indexed.

Enrollment_Transfer_Date_Pend (ver5.0.0)

Date [From Students] Date of the Pending transfer of the student from the school. If 00/00/00 then immediate transfer.

Enrollment_Transfer_Info (ver5.0.0) Varbinary 2048

[From Students] Blob containing one or more comments regarding this transfer.

Entry_Code (ver5.0.0) String 20 [From Students] 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.

Entry_Reason (ver5.0.0) String 2048 [From Gen] The textual value associated with this student’s ‘entrycode’.

Entry_Date (ver5.0.0) Date [From Students] The date the student enrolled in school for the current enrollment. Indexed.

Exit_Code (ver5.0.0) String 20 [From Students] 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.

Exit_Reason (ver5.0.0) String 2048 [From Gen] The textual value associated with this student’s ‘exitcode’.

Exit_Comment (ver5.0.0) String 2048 [From Students] Any comments for the student exiting this school.

Exit_Date (ver5.0.0) Date [From Students] 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. Indexed.

Graduated_Rank (ver5.0.0) Longint [From Students] Class rank upon the time of graduation.




Graduated_SchoolName (ver5.0.0) String 60 [From Students] Stores the name of the school the student graduated from so the user can search for him or her in the Graduated Students school.

Log_Notes (ver5.0.0) String 2048 [From Students] Place to write notes about transferring students.

Transfer_Comments (ver5.0.0) String 2048 [From Students] A text field for the school administrator to write a note about the reason a student is being transferred.

Withdrawal_Reason (ver5.0.0) String 2048 [From Students] Reason code provided when a student withdraws from school.

Lunch_Portion_to_Pay (ver5.0.0) String 11 [From Students] Represents the portion of lunch a student must pay for: Blank=No status P=Full pay R=Reduced F=Free E=Exempt T=Temporary FDC=Free-DC.

MembershipShare (ver5.0.0) Real [From Students] 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.

TuitionPayer (ver5.0.0) String 16 [From Students] 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.

Track (ver5.0.0) String 20 [From Students] A-H or blank. This represents the times of year a student goes to school. This is most common with year-round schools.

PSSIS_Student_Fees (ver5.0.0)

This View will provide Fee information related to Students. Much of this information is aggregated from the Fee table.










Mother_name (ver5.0.0) String 60 [From Students] The Students Mother’s name.

Father_name (ver5.0.0) String 60 [From Students] The Students Father’s name.

Physical_Address (ver5.0.0) String 125 [Derived] Concatenation of Street, City, State and Zip code.

Home_Phone (ver5.0.0) String 30 [From Students] Home phone number for the student. Indexed.

LastMeal (ver5.0.0) String 20 [From Students] Stores the date of last lunch purchase.

Lunch_Portion_to_Pay (ver5.0.0) String 3 [From Students] Represents the portion of lunch a student must pay for: Blank=No status P=Full pay R=Reduced F=Free E=Exempt T=Temporary FDC=Free-DC.

Lunch_ID (ver5.0.0) Real [From Students] The students PowerLunch number. Indexed.

TuitionPayer (ver5.0.0) String 16 [From Students] 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

Fee_Type_Name (ver5.0.0) String 79 The Name field from the Fee_Type table.

Fee_Category_Name (ver5.0.0) String 21 The name of the Fee Category associated with the fee.

Description (ver5.0.0) String 79 User defined description for this Fee.

Creation_Date (ver5.0.0) Date The date the fee was created.

Original_Fee_Amount (ver5.0.0) Real The original Fee_Amount. Does not change if the fee is pro-rated.

Prorated_Fee_Amount (ver5.0.0) Real Taken from the School_Fee Pro Ratable record associated with this fee.

Fee_Balance (ver5.0.0) Real The balance due on the fee.




Fee_Paid (ver5.0.0) Real The current amount that has been paid toward the Fee_Amount.

Fee_Term (ver5.0.0) String 6 The internal number for the Term with which this record is associated.

Fee_Year (ver5.0.0) String 6 A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Indexed.

Family_Original_Fee_Amount (ver5.0.0)

Real Sum of the Original Fee Amount owed by this Student’s family.

Family_Prorated_Fee_Amount (ver5.0.0)

Longint Sum of the Prorated Fee Amount owed by this Student’s family.

Family_Fee_Paid (ver5.0.0) Real Sum of the Fee_Paid owed by this Student’s family.

Family_Fee_Balance (ver5.0.0) Real Sum of the Fee_Balance owed by this Student’s family.

PSSIS_Student_Relationships (ver5.0.0)

This View will provide Relationship information related to Students. This will include emergency contact details.


Student_Name (ver5.0.0) String 35 [From Students] The Student Last Name, First Name. Indexed.





Type (ver5.0.0) String 9 [Derived] Values include; ‘Doctor’, ‘Father’, ‘Mother’, Emergency’.

Full_Name (ver5.0.0) String 60 [From Students] Name of the contact.

Phone (ver5.0.0) String 30 [From Students] Phone number for the contact specified.




Emergency_Contact_Order (ver5.0.0) String 1 [From Students] Name to contact in case of an emergency.

Web_ID (ver5.0.0) String 20 [From Students] Student’s web id.

Web_Password (ver5.0.0) String 64 [From Students] Student’s encrypted web password.

PSSIS_Student_Scheduling (ver5.0.0)

This View will provide scheduling information related to Students.







Current_Building (ver5.0.0) String 10 [From Students] Student’s current building.

Current_Homeroom (ver5.0.0) String 60 [From Students] Student’s current Homeroom assignment.

Current_House (ver5.0.0) String 10 [From Students] Student’s current house, if applicable.

Current_Next_School (ver5.0.0) Longint [From Students] Student’s next school, if applicable.

Sched_LockStudentSchedule (ver5.0.0)

Longint [From Students] 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 (ver5.0.0) String 10 [From Students] The building this student will be in next year for schools with multi-building needs.

Sched_NextYearGrade (ver5.0.0) Longint [From Students] 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 (ver5.0.0) String 10 [From Students] 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 (ver5.0.0) String 10 [From Students] The team this student will belong to next year.

Sched_Priority (ver5.0.0) Longint [From Students] 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 (ver5.0.0) Longint [From Students] 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 (ver5.0.0) Longint [From Students] Year of graduation. This changes if the student fails or skips a grade.

Current_Team (ver5.0.0) String 10 [From Students] This field is the team value assigned in PowerScheduler to a student.

Track (ver5.0.0) String 20 [From Students] A-H or blank. This represents the times of year a student goes to school. This is most common with year-round schools.

PSSIS_Student_Stored_Standards (ver5.0.0)

This View will provide Standards information related to Students. This will essentially be a join of the information from the Students, Standards and the StandardsGrades tables.














Standard_Identifier (ver5.0.0) String 20 [From Standards] Code used by administrators for reporting and by teachers for designating to assignments. Must be unique. Indexed.

Standard_Name (ver5.0.0) String 80 [From Standards] The name of the standard.

Subject_Area (ver5.0.0) String 40 [From Standards] For reference as to which the subject with which this standard is associated.

Standard_Type (ver5.0.0) Longint [From Standards] The subcategory this standard falls into. 1=National, 2=State, 3=District, 4=School. Indexed.

Conversion_Scale_Name (ver5.0.0) String 50 [From Standards] The conversion scale this standard uses to convert percentages into the standard score they want displayed.

Year (ver5.0.0) Longint [From Standards] A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Indexed.

Store_Code (ver5.0.0) String 10 [From StandardsGrades] The code used to represent this grade level to TermID and SchoolID.

Number_Of_Scores (ver5.0.0) Longint [From StandardsGrades] Number of scores which make-up the averages specified in the associated fields.




High_Score (ver5.0.0) Real [From StandardsGrades] High score for this student for this term.

Average_Score (ver5.0.0) Real [From StandardsGrades] Average score provided for this student fro this standard. School can either set up AverageScore, HighScore, TransAverageScore or TransHighScore to be entered.

Translated_Average_Score (ver5.0.0) String 50 [From StandardsGrades] Translated average score provided for this student fro this standard. School can either set up AverageScore, HighScore, TransAverageScore or TransHighScore to be entered. Indexed.

Translated_High_Score (ver5.0.0) String 40 [From StandardsGrades] Student High Score with the conversion scale applied.

Comment_Value (ver5.0.0 renamed in ver5.2.0)

Text [From StandardsGrades] Comment associated with this specific standard.

PSSIS_Student_Test_Scores (ver5.0.0)

This View will provide Test Score information related to Students.











Test_Name (ver5.0.0) String 35 [From Test] Name provided for this test, such as ACT I, SAT2, etc. Indexed.

Test_Date (ver5.0.0) Date [From StudentTest] The date this test was given. Indexed.

Test_Subtest (ver5.0.0) String 35 [From TestScore] Name provided for this test score. Ex; Verbal, Math.

Num_score (ver5.0.0) Real [From StudentTestScore] The numeric score student received for this test.

Alpha_Score (ver5.0.0) String 20 [From StudentTestScore] The letter grade student received for this test.

Percent_Score (ver5.0.0) Real [From StudentTestScore] The percentage score student received for this test.

PSSIS_Student_Transportation (ver5.0.0)

This View will provide Transportation information related to Students.




Start_Date (ver5.0.0) Date [From Transportation] The date that the student will begin using this form of transportation.

End_Date (ver5.0.0) Date [From Transportation] The date that the student will stop using this form of transportation.

FromTo (ver5.0.0) String 79 [From Transportation] Indicates the direction of the transportation: From = From School, To= To school.

Monday (ver5.0.0) LongInt [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes.

Tuesday (ver5.0.0) LongInt [From Transportation] Flag indicating whether the student uses this form




of transportation on this day. 1= yes.

Wednesday (ver5.0.0) LongInt [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes.

Thursday (ver5.0.0) LongInt [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes.

Friday (ver5.0.0) LongInt [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes.

Saturday (ver5.0.0) LongInt [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes.

Sunday (ver5.0.0) LongInt [From Transportation] Flag indicating whether the student uses this form of transportation on this day. 1= yes.

Transportation_Type (ver5.0.0) String 79 [From Transportation] The indicated mean of transportation

Route_Number (ver5.0.0) String 79 [From Transportation] The route number if the student uses transportation provided by the school.

Bus_Number (ver5.0.0) String 79 [From Transportation]Bus number provided for this record by the school, which the student uses.

Departure_Time (ver5.0.0) Longint [From Transportation] Student’s departure time.

Arrival_Time (ver5.0.0) Longint [From Transportation] Student’s arrival time.

Driver_Name (ver5.0.0) String 79 [From Transportation] (Bus) Driver full name.

Student_Emergency_Phone (ver5.0.0) String 30 [From Students] Emergency contact phone number.

Alert_Medical (ver5.0.0) Text [From Students] Medical emergency contact phone number.

Alert_Guardian (ver5.0.0) Text [From Students] Emergency contact full name.

Trans_Special_Instructions (ver5.0.0) Text [From Transportation] Any special transportation information.


PVSIS_Custom_CC (ver5.1.0)

This View will provide the custom fields from the CC table.


Field_Name (ver5.1.0) String 50 [From FieldsTable] Name of the custom field.

Course_Number (ver5.1.0) String 11 [From CC] Course_Number associated to this CC record.

CC_ID (ver5.1.0) LongInt [From CC] Unique ID for the CC record.

Section_Number (ver5.1.0) String 10 [From CC] Section_Number associated to this CC record.

SectionID (ver5.1.0) LongInt [From CC] Unique ID of associated section record.

SchoolID (ver5.1.0) LongInt [From CC] Unique school number associated to this CC record.

StudentID (ver5.1.0) LongInt [From CC] Unique ID of student record associated to this CC record.

TermID (ver5.1.0) LongInt [From CC] Unique Id of term record associated to this CC record.

TeacherID (ver5.1.0) LongInt [From CC] Unique Id of teacher record associated to this CC record.

Char_Value (ver5.1.0) String 1024 [From CustomVarchars] Populated when the custom field type is character.

Real_Value (ver5.1.0) Real [From CustomReals] Populated when the custom field type is real.

Text_Value (ver5.1.0) String 2048 [From CustomText] Populated when the custom field type is text.

Date_Value (ver5.1.0) Date [From CustomDates] Populated when the custom field type is date.

Int_Value (ver5.1.0) LongInt [From CustomIntegers] Populated when the custom field type is integer.

Time_Value (ver5.1.0) LongInt [From CustomTimes] Populated when the custom field type is time.

String_Value (ver5.1.0) String 2048 [Derived] Contains the character value equivalent of the custom field. It is populated for all custom fields and is not dependent on type.

The_Type (ver5.1.0) String 1 [Derived from FieldsTable type] Represents the type of the custom field. Possible values: V – varchar, R – real, X – text, D – date, I – integer, T –





time.

PVSIS_Custom_Courses (ver5.1.0)

This View will provide the custom fields from the Courses table.



CourseID (ver5.1.0) LongInt [From Courses] Unique ID for the course record.

Course_Name (ver5.1.0) String 40 [From Courses] Course name.

Course_Number (ver5.1.0) String 11 [From Courses] Course_Number.

ProgramID (ver5.1.0) LongInt [From Courses] ID from Gen table (cat=specprog) associated to the course.








The_Type (ver5.1.0) String 1 [Derived from FieldsTable type] Represents the type of the custom field. Possible values: V – varchar, R – real, X – text, D – date, I – integer, T – time.


PVSIS_Custom_Fee (ver5.1.0)

This View will provide the custom fields from the Fee table.



Fee_Description (ver5.1.0) String 79 [From Fee] Description of the fee.

Fee_ID (ver5.1.0) LongInt [From Fee] Unique ID for the Fee record.

Fee_Categegory_Name (ver5.1.0) String 21 [From Fee] Name of the fee category associated to this Fee record.

Fee_Type_ID (ver5.1.0) LongInt [From Fee] Unique ID of the fee_type record associated to this Fee.

CreationDate (ver5.1.0) Date [From Fee] The date the fee was created.

Fee_Date (ver5.1.0) Date [From Fee] The date the fee record was created.

YearID (ver5.1.0) LongInt [From Fee] Internal number representing the year in which the associated term belongs.

SchoolID (ver5.1.0) LongInt [From Fee] Unique school number associated to this Fee record.

StudentID (ver5.1.0) LongInt [From Fee] Unique ID of student record associated to this Fee record.

SchoolFee_ID (ver5.1.0) LongInt [From Fee] Unique Id of term record associated to this Fee record

TeacherID (ver5.1.0) LongInt [From Fee] Unique Id of teacher record associated to this Fee record.

TermID (ver5.1.0) LongInt [From Fee] Unique Id of term record associated to this Fee record













PVSIS_Custom_Fee_Transaction (ver5.1.0)

This View will provide the custom fields from the Fee_Transaction table.



Fee_Transaction_ID (ver5.1.0) LongInt [From Fee_Transaction] Unique ID for the Fee_Transaction record.

FeeID (ver5.1.0) LongInt [From Fee_Transaction] Unique ID for the associated Fee record.

Transaction_Description (ver5.1.0) String 79 [From Fee_Transaction] Description of the transaction.

FT_Date_Value (ver5.1.0) Date [From Fee_Transaction] Actual date of the transaction.

YearID (ver5.1.0) LongInt [From Fee_Transaction] Internal number representing the year in which the associated term belongs.

SchoolID (ver5.1.0) LongInt [From Fee_Transaction] Unique school number associated to this Fee_Transaction record.

StudentID (ver5.1.0) LongInt [From Fee_Transaction] Unique ID of student record associated to this Fee_Transaction record.

TeacherID (ver5.1.0) LongInt [From Fee_Transaction] Unique Id of teacher record associated to this Fee_Transaction record.












PVSIS_Custom_Fee_Type (ver5.1.0)

This View will provide the custom fields from the Fee_Type table.



Fee_Name (ver5.1.0) String 50 [From Fee_Type] Name of the Fee_Type.

Fee_Type_ID (ver5.1.0) LongInt [From Fee_Type] Unique ID of the Fee_Type record.

Fee_Categegory_Name (ver5.1.0) String 50 [From Fee_Type] Name of the fee category associated to this Fee_Type record.

SchoolID (ver5.1.0) LongInt [From Fee_Type] Unique school number associated to this Fee_Type record.












PVSIS_Custom_Log (ver5.1.0)

This View will provide the custom fields from the Log table.



Log_Entry (ver5.1.0) Text [From Log] Log entry description.

Log_ID (ver5.1.0) LongInt [From Log] Unique ID for the Log record.

LogTypeID (ver5.1.0) LongInt [From Log] Unique ID for Gen record associated to the Log.

Consequence (ver5.1.0) String 20 [From Log] Value from Gen table (cat=consequence).

Entry_Date(ver5.1.0) Date [From Log] Date of the log entry.




Subtype (ver5.1.0) String 20 [From Log] Sub category for the Log.

SchoolID (ver5.1.0) LongInt [From Log] Unique school number associated to this Log record.

StudentID (ver5.1.0) LongInt [From Log] Unique ID of student record associated to this Log record.

TeacherID (ver5.1.0) LongInt [From Log] Unique Id of teacher record associated to this Log record.









PVSIS_Custom_ReEnrollments (ver5.1.0)

This View will provide the custom fields from the ReEnrollments table.



EnrollmentCode (ver5.1.0) LongInt [From ReEnrollments] State reporting enrollment code.




ReEnrollments_ID (ver5.1.0) LongInt [From ReEnrollments] Unique ID for the ReEnrollments record.

EntryDate (ver5.1.0) Date [From ReEnrollments] Student entry date for this ReEnrollments record.

ExitDate (ver5.1.0) Date [From ReEnrollments] Student exit date for this ReEnrollments record.

FTEID (ver5.1.0) LongInt [From ReEnrollments] Unique ID for the FTE record associated with this ReEnrollments record.

SchoolID (ver5.1.0) LongInt [From ReEnrollments] Unique school number associated to this ReEnrollments record.

StudentID (ver5.1.0) LongInt [From ReEnrollments] Unique ID of student record associated to this ReEnrollments record.









PVSIS_Custom_SchoolFee (ver5.1.0)

This View will provide the custom fields from the SchoolFee table.




SchoolFee_Description (ver5.1.0) Text [From SchoolFee] Description of the school fee.

SchoolFee_ID (ver5.1.0) LongInt [From SchoolFee] Unique ID for the SchoolFee record.

Fee_Category_Name (ver5.1.0) String 21 [From SchoolFee] Name for the SchoolFee.

Fee_Type_ID (ver5.1.0) LongInt [From SchoolFee Unique ID of the fee type record associated to this SchoolFee record.

SchoolID (ver5.1.0) LongInt [From SchoolFee] Unique school number associated to this SchoolFee record.

DepartmentID (ver5.1.0) LongInt [From SchoolFee] Unique ID of department record associated to this SchoolFee record.











PVSIS_Custom_Schools (ver5.1.0)

This View will provide the custom fields from the Schools table.



School_Number (ver5.1.0) LongInt [From Schools] Unique number for the school.

School_Name (ver5.1.0) String 60 [From Schools] Name of the school.

Alternate_School_Number (ver5.1.0) LongInt [From Schools] State reporting alternate school number.









PVSIS_Custom_Sections (ver5.1.0)

This View will provide the custom fields from the Sections table.





SectionID (ver5.1.0) LongInt [From Sections] Unique ID of this section record.

Section_Number (ver5.1.0) String 10 [From Sections] Section_Number of this Sections record.

Course_Number (ver5.1.0) String 11 [From Sections] Course_Number associated to this Sections record.

TeacherID (ver5.1.0) LongInt [From Sections] Unique Id of teacher record associated to this Sections record.

TermID (ver5.1.0) LongInt [From Sections] Unique Id of term record associated to this Sections record.

GradeScaleID (ver5.1.0) LongInt [From Sections] Unique Id of grade scale record associated to this Sections record.

SchoolID (ver5.1.0) LongInt [From Sections] Unique school number associated to this Sections record.











PVSIS_Custom_SPEnrollments (ver5.1.0)

This View will provide the custom fields from the SPEnrollments table.



SPEnrollments_ID (ver5.1.0) LongInt [From SPEnrollments] Unique ID for the SPEnrollments record.

Enter_Date (ver5.1.0) Date [From SPEnrollments] Student entry date for this special enrollments record.

Exit_Date (ver5.1.0) Date [From SPEnrollments] Student exit date for this special enrollments record.

ProgramID(ver5.1.0) LongInt [From SPEnrollments] ID from Gen table (cat=specprog) associated to the special enrollments record.

SchoolID (ver5.1.0) LongInt [From SPEnrollments] Unique school number associated to this special enrollments record.

StudentID (ver5.1.0) LongInt [From SPEnrollments] Unique ID of student record associated to this special enrollments record.













PVSIS_Custom_Students (ver5.1.0)

This View will provide the custom fields from the Students table.



Student_Last_First (ver5.1.0) String 35 [From Students] Student name.

StudentID (ver5.1.0) LongInt [From Students] Unique ID for the Students record.

Student_Number (ver5.1.0) Real [From Students] School assigned student number.

EntryDate (ver5.1.0) Date [From Students] Student entry date for this Students record.

ExitDate (ver5.1.0) Date [From Students] Student exit date for this Students record.

FTEID (ver5.1.0) LongInt [From Students] Unique ID for the FTE record associated with this Students record.

SchoolID (ver5.1.0) LongInt [From Students] Unique school number associated to this Students record.












PVSIS_Custom_Teachers (ver5.1.0)

This View will provide the custom fields from the Teachers table.



Teacher_Last_First (ver5.1.0) String 40 [From Teachers] Teacher name.

TeacherID (ver5.1.0) LongInt [From Teachers] Unique ID for the Teachers record.

Teacher_Number (ver5.1.0) String 20 [From Teachers] District assigned teacher number.

SchoolID (ver5.1.0) LongInt [From Teachers] Unique school number associated to this Teachers record.








Notes 67

Notes

www.PearsonSchoolSystems.com

powerschool data dictionary sis views - island trees … · · 2015-03-04pssis_attendance_daily...

Documents