Transcription
Data Dictionary TablesPowerSchool Premier 5.2Student Information System
Released August 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.5 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 TablesContentsIntroduction . 1Purpose . 1Audience. 1Conventions . 1Tables . 2Address (ver4.0.0) . 2AggStats (ver3.6.1). 3Agg Attendance (ver4.0.0). 5Agg Att Detail (ver4.0.0) . 6Attendance (ver4.0.0). 7AttendanceQueue (ver3.6.1). 9Attendance Code (ver4.0.0) .10Attendance Conversion (ver3.6.1).11Attendance Conversion Items (ver3.6.1) .12Attendance Taken (ver4.0.0) .13Attendance Time (ver4.0.0) .14Att Code Code Entity (ver4.0.0) .15Audit Log (ver4.0.0) .15AutoComm (ver3.6.1) .16AutoSend (ver3.6.1).19Awsched Constraint (ver4.0.0) .19Awsched Preference (ver4.0.0).21Batches (ver3.6.1) .23Bell Schedule (ver3.6.1) .24Contentsiii
Data Dictionary TablesBell Schedule Items (ver3.6.1) .24Blobs (ver3.6.1).25Books (ver3.6.1) .26BulletinItems (ver3.6.1) .27Cache Message (ver4.2) .27Calendar (ver3.6.1) .28Calendar Day (ver3.6.1).29CC (ver3.6.1) .31ClassRank (ver3.6.1) .33Code Entity (ver4.0.0) .34Component (ver4.0.0) .35Config Group (ver4.2) .36CourseFee (ver3.6.1).36Courses (ver3.6.1) .37Course Relationship (ver4.0.0) .44CReq (ver3.6.1) .45CustomIntegers (ver5.0.0) .46CustomDates (ver5.0.0).46CustomTimes (ver5.0.0) .47CustomVarchars (ver5.0.0).47CustomReals (ver5.0.0) .47CustomText (ver5.0.0).48Cycle Day (ver3.6.1).48DailyAttendance (ver3.6.1).49DBLog (ver3.6.1) .50DB Object (ver4.0.0) .51Contentsiv
Data Dictionary TablesDB Version (ver5.0.0) .52Demograhpic (ver4.0.0) .52Department (ver3.6.1).54Dialogs (ver3.6.1) .54DnldQueue (ver3.6.1) .55DS (ver3.6.1) .55Ethnicity (ver4.0.0) .56Facility (ver3.6.1) .57Fee (ver3.7.0) .57Fees (ver3.6.1).59Fee Balance (ver3.7.0).60Fee Transaction (ver4.0.4).61Fee Type (ver3.7.0) .63FieldsTable (ver3.6.1) .63FieldTypeChangeRequest (ver4.3.0/5.0.7) .65FTE (ver4.0.0) .66FTE Grade (ver4.0.0) .67Gen (ver3.6.1).67GLDetail (ver3.6.1) .69GradeScaleItem (ver3.6.1) .70GradReq (ver3.6.1) .72GradReqSets (ver3.6.1) .75Guardians (ver4.0.4) .76Help (ver4.0.4) .77HonorRoll (ver3.6.1).78INCIDENT ACTION (ver5.2.0) .79Contentsv
Data Dictionary TablesINCIDENT LU CODE (ver5.2.0).81INCIDENT OBJECT (ver5.2.0) .82INCIDENT LU SUB CODE (ver5.2.0) .83INCIDENT OBJECT PERSON (ver5.2.0) .84INCIDENT (ver5.2.0).85INCIDENT PERSON ROLE (ver5.2.0).85INCIDENT DETAIL (ver5.2.0).86INCIDENT PERSON DETAIL (ver5.2.0).87INCIDENT OTHER PERSON (ver5.2.0).87INCIDENT SECURITY GROUP (ver5.2.0) .88INCIDENT CHANGE RSN DESC (ver5.2.0) .88Log (ver3.6.1) .89Log2 (ver3.6.1) .93Logins (ver3.6.1) .93Message Queue (ver4.0.4).95MimeTypes (ver3.6.1).95Pages (ver3.6.1) .96Period (ver3.6.1) .97Person (ver5.0.0).97PGAssignments (ver3.6.1) .98PGAssignmentStandards (ver3.6.1) .99PGCategories (ver3.6.1).99PGCommentBank (ver3.6.1) . 100PGFinalGrades (ver3.6.1) . 101PGFinalGradesSetup (ver4.3.0/5.0.7). 102PGGradeScales (ver4.3.0/5.0.7) . 104Contentsvi
Data Dictionary TablesPGGradeScalesMark (ver4.3.0/5.0.7) . 104PGIncomingQueue (ver3.6.1). 105PGNotification (ver4.0.0). 106PGPreferences (ver3.6.1) . 107PGScores (ver3.6.1) . 108PGSections (ver4.3.0/5.0.7) . 109PGStudents (ver4.3.0/5.0.7). 110PhoneLog (ver3.6.1). 110Pisa Session (ver5.2.0.5). 111PostSecondary (ver4.0.0) . 112Prefs (ver3.6.1) . 113Program (ver4.0.4) . 113PS Membership Defaults (ver5.0.14) . 114Queue (ver3.6.1) . 116ReEnrollments (ver3.6.1) . 117RegistReq (ver3.6.1) . 119Relationship (ver5.0.0) . 123RepoBatchSetups (ver3.6.1) . 123RepoLookupTables (ver3.6.1) . 126RepoLookupTablesContentsItems (ver3.6.1) . 126RepoLookupTablesContRecords (ver3.6.1) . 127RepoLookupTablesDefItems (ver3.6.1) . 127Reports (ver3.6.1) .
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 c
