PowerSchool Resources, References, & Terminology
Listed below are several resources and references where additional PowerSchool information can be obtained.
Where to find Information on PowerSchool Fields
- PowerSchool Data Dictionary
- Direct Database Export (DDE)
- Fields List
- View Field List - Located on the PowerSchool Start Page
- Data Access Tags Supplement (KB 55742)
- PowerSource - PowerSchool Community - KB 55742
Knowledge Base Articles
PowerSchool Community is a place for PS administrators, educators, partners, parents, and students to get the most out of their PowerSchool products.
A login is required and can be obtained on the PowerSchool Community's main page
- Click Sign In tab, then New User? Register Here option located in the upper right hand corner of the sign in window
Listed below are several Knowledge Base Articles (KBA's) associated with many of the items contained within this Data Reference Plugin.
Article Number | Description/Title |
---|---|
KB 5826 | Anatomy of the GPA DAT - ^(gpa) |
KB 74786 | Grading User Guide for PowerSchool 9.x |
KB 5720 | How it Works: GPA Calculation Explained |
KB 6439 | Formulas for Calculation Methods |
KB 7182 | How it Works: GPA Calculation Query Options |
KB 11148 | Troubleshooting GPAs |
KB 55371 | Tutorial: Calculation the GPA using the "Simple" GPA Method |
KB 55379 | Calculating the GPA using the "Weighted" GPA Method |
KB 69896 | Function of Users and SchoolStaff tables when importing into the Teachers table |
KB 55742 | Data Access Tags Supplement |
KB 7891 | Matched Selection - How it Works |
KB 6018 | Logic DATs - If/Then Statements |
KB 71873 | Field Level Security - Common usage scenarios with details on how to use FLS in customizations by utilizing DAT's, tlist, and conditional statements |
Most Commonly Used Tables
Table Name | Table Number | Description |
---|---|---|
Students | 001 | Contains Student Demographic Information including many state reportable fields |
Teachers | 005 | Contains basic staff demographic information |
CC | 004 | Contains class enrollment information (ex: all enrollment screen data) |
StoredGrades | 031 | Contains historical grade information |
Courses | 002 | Contains detailed course information |
Sections | 003 | Contains detailed section information |
Schools | 039 | Contains school information created on District > Schools/School Info screen |
Log | 008 | Contains student log entries used for Discipline Reporting in some states |
ReEnrollments | 018 | Stores all school enrollments; except the current one |
Terms | 013 | Created by school on the Year and Terms screen |
TermBin | 033 | Created by school on the Final Grade Setup screen |
All PowerSchool Tables
Auditing Tables/Fields
AccessAdmin
AccessSchool
AccessStudent
AccessTeacher
Activities
Address (164)
AdminAlert
Agg_Att_Detail (171)
Agg_Attendance (167)
AggStats (46)
APEX_Appln_Bckp
Assignment
AssignmentCategoryAssoc
AssignmentDroppedByLowScore
AssignmentRetakeScore
AssignmentScore
AssignmentScoreComment
AssignmentScoreImportLine
AssignmentSection
AssignmentSectOnLineWork
AssignmentStandardAssoc
AssignmentStudentAssoc
ATN_ConsecutiveProcessing
ATN_ITVLBellSchedItms
ATN_MeetingConversion
ATN_NotifyRecToProcess
ATN_SchoolAttendanceCode
ATN_SchoolDays
ATN_TermOrder
Att_AdaAdm_Defaults_All
Att_AdaAdm_Defaults_HIS
Att_Code_Code_Entity (163)
Att_DayPart_CurYear
Att_DayPart_PrevYear
Att_Inc_Action_Codes_Mapping
Att_Nightly_Log
Att_Nightly_Process_Schools
Att_Nightly_Schools
Att_Process_Schools
Attendance_Code (156)
Attendance_Conversion_Items2
Attendance_Conversion (131)
Attendance_CurYear_School
Attendance_Taken (172)
Attendance_Time (158)
Attendance (157)
AttendanceQueue (48)
Au_TableName_
Aud_Calendar_Day
Audit_Log (170)
AutoCalendarSetting
AutoComm (47)
AutoSend (49)
Awsched_Constraint (152)
Awsched_Preference (155)
Batches (28)
Bell_Schedule_Items (134)
Bell_Schedule (133)
BLOBS (12)
Books (14)
BulletinItems (26)
C_ReenrollmentsOutOfDistrict
C_Schools_Registrar
C_StudentLookup
Cache_Message (178)
Calendar_Day (51)
Calendar (29)
CanonicalFieldList
CareerTechAuditHistory
CareerTechCluster
CareerTechClusterPrograms
CareerTechClusterType
CareerTechCredential
CareerTechCredentialType
CareerTechLocality
CareerTechProgram
CareerTechProgramCredentials
CareerTechProgramType
CareerTechSchool
CareerTechSite
CareerTechStudentCredentials
CareerTechStudentPrograms
CategorySchoolExcludeAssoc
CC_Exclusions
CC (4)
ChangeHistorySettings
ClassRank (15)
Code_Entity (162)
CodeSet
ColumnReMap
Component (161)
Config_Group (176)
ConsecutiveDaysAlert
CountryISOCodeLU
Course_Relationship (151)
CourseEquivalency
CourseFee (104)
CoursePreReqEvaluated
CoursePreReqOverride
CoursePreReqRecommend
CoursePreReqRule
Courses (2)
CoursesByYear
CoursesCoreFields
CReq (38)
CST_AssociatedResult
CST_AssocResultForeignKey
CST_ChildReport
CST_ConfigFile
CST_ExternalAdapter
CST_Param
CST_ParamDefault
CST_PrefConfig
CST_PropertyFiles
CST_Query
CST_QueryDependency
CST_QueryResult
CST_QueryResultColumn
CST_QueryResultTable
CST_RenderExpression
CST_RenderExpressionItem
CST_RenderExpressionOption
CST_ReportConfig
CST_ReportProcess
CST_ReportProcessTable
CST_ReportSubProcess
CST_Result
CST_SQLMapFiles
CST_Template
CST_UpdateCycleLock
CST_VLDConfigFile
CST_VLDGroup
CST_VLDGroupRule
CST_VLDParam
CST_VLDParamVal
CST_VLDQuery
CST_VLDRecord
CST_VLDRecordVal
CST_VLDResultByGroup
CST_VLDResultByRule
CST_VLDRule
CST_VLDSeverity
CustomDates (185)
CustomFieldMap
CustomIntegers (181)
CustomReals (182)
CustomText (183)
CustomTimes (186)
CustomVarchars (184)
Cycle_Day (135)
DailyAttendance (84)
Dalx_Semaphore
DataExportTemplate
DataExportTemplateField
DataExportTemplateFilter
DataExportTemplateOption
DataExportTemplateSchedule
DataFailedRecord
DataImport
DataImportTemplate
DataImportTemplateColumn
DayPart
DB_Credentials
DB_Object (169)
DB_Version (187)
DBLog (20)
DCFApplication
DCFColumnMap
DCFTable
Demographic (166)
Department (136)
Dialogs (10)
DictionaryColumn
DictionaryObject
DistrictBellSchedule
DistrictCalendar
DistrictCalendarDay
DistrictCategory
DistrictCycleDay
DistrictTeacherCategory
DM_CurrentGrade
DM_HistoricalGrade
DM_SchoolEnrollment
DM_StandardGrade
DnlDQueue (19)
DocDistrict
DocMetaData
DocMetaDataDistrictCategory
DQ$_TableName_
DS (23)
DV_TextMasks
DV_TextMaskSets
EmailAddress
Enrollment_Withdrawl_Tracking
EnterpriseReportPage
ERPFields
Ethnicity (168)
EvaluationFactors
EvaluationLevels
EvaluationMethods
EvaluationSchoolConfig
ExtSchemaCustomRemap
ExtSchemaDef
ExtSchemaDefAsset
ExtSchemaDefField
ExtSchemaDefForeignKey
ExtSchemaDefIndex
ExtSchemaDefTable
ExtSchemaMigrationIssue
Facility (137)
Fee_Balance (148)
Fee_Transaction (147)
Fee_Type (144)
Fee (146)
Fees (54)
FieldLevelSecurity
FieldsTable (7)
FieldTypeChangeRequest (196)
FinalGradeAttrib
FTE_Grade (160)
FTE (159)
Gen (6)
GLDetail (25)
GPExpectation
GPExpectationItem
GPNode
GPProgressSubject
GPProgressSubjectEarned
GPProgressSubjectEnrolled
GPProgressSubjectRequested
GPProgressSubjectWaived
GPProgressSubjWaivedApplied
GPProgressTest
GPScoreConfig
GPSelectedCrs
GPSelectedCrType
GPSelector
GPStudentPlan
GPStudentTestWaiver
GPStudentWaiver
GPTarget
GPTestConfig
GPTestScoreConfig
GPVersion
GPWaiverConfig
GradeCalcDropLowScore
GradeCalcFormulaWeight
GradeCalcSchoolAssoc
GradeCalculationType
GradeCourseConfig
GradeFormulaSet
GradePolicyStoreCodes
GradeReplacementPolicy
GradeScaleItem_Backup (90)
GradeScaleItem
GradeScaleRelated
GradeScaleSchoolAssoc
GradeScaleScoreCode
GradeScaleSectionStudent
GradeSchoolConfig
GradeSchoolFormulaAssoc
GradeSectionConfig
GradPlan
GradReq (37)
GradReqSets (57)
Guardian
GuardianNotificationEmail
GuardianPersonAssoc
GuardianRelationshipType
Guardians (55)
GuardianStudent
GuardianStudRestrictionMap
GUID_SetUpMetaData
HealthAccident
HealthConcerns
HealthContactLog
HealthGradeLevel
HealthImmExempt
HealthImmSource
HealthMainStudRec
HealthMedAdmin
HealthMedication
HealthMedInventory
HealthMisc
HealthOfficeVisit
HealthPEWaiver
HealthPhysical
HealthScreenChngDetail
HealthScreenLookup
HealthScreenWaiver
HealthStudChngDetail
HealthStudChngRsn
HealthStudDiabetesMonitor
HealthStudDoseRec
HealthStudGradeLevel
HealthStudHearing
HealthStudImmRec
HealthStudLead
HealthStudMonitor
HealthStudOral
HealthStudScolio
HealthStudTB
HealthStudTreatmentAssoc
HealthStudVision
HealthStudentHealth
HealthStudentPlan
HealthVaccine
HealthVaccineRule
HealthVitalSigns
Help (44)
HonorRoll (34)
IDPContext
IDPMetaData
IDPMetaDataMAP
IDPRelyingParty
IDPService
IDPServiceMap
IDPServiceParam
ImportLocalizationResults
ImportLocalizationStatus
Incident_Action_Attribute
Incident_Action
Incident_Change_Rsn_Desc
Incident_Detail
Incident_LU_Code
Incident_LU_Sub_Code
Incident_Object_Person
Incident_Object
Incident_Other_Person
Incident_Person_Action
Incident_Person_Detail
Incident_Person_Role
Incident_Personal_Detail
Incident_Personal
Incident_Security_Group
Incident
IncidentTemplate
Institution
InstitutionCodeList
KeyStore
LanguageISOCodeLU
LG_TableName
Locale
LocaleDateFormat
LocaleNumCurrFormatLU
LocaleSeparatorLU
LocaleTimeFormat
LockOverride
LockOverrideSection
LockOverrideTermBin
Log2 (50)
Log (8)
Logins (16)
MessageKeyMap
MessageRequestSummary
MessageStaging
Metaphone
MimeTypes (11)
OauthAccessToken
OIDServerAssociationStore
OriginalContactMap
Pages (30)
PCAS_Account
PCAS_AccountAccessHist
PCAS_AccountServicePref
PCAS_AccountServiceRel
PCAS_AccountSession
PCAS_Audit
PCAS_Configuration
PCAS_CredentialComplexity
PCAS_CredentialRecoveryToken
PCAS_CredentialReuse
PCAS_CredentialType
PCAS_DeviceToken
PCAS_EmailContact
PCAS_ExternalAccountMap
PCAS_Service
PCAS_ServiceTicket
Period (138)
PermissionGroupLabel
PermissionGroupValue
Person_Obsolete
Person (188)
PersonAddress
PersonAddressAssoc
PersonAddressCoreFields
PersonCoreFields
PersonEmailAddressAssoc
PersonLanguageAssoc
PersonPhoneNumberAssoc
PGAssignments (92)
PGAssignmentStandards (93)
PGCategories (94)
PGCommentBank (97)
PGFinalGrades (95)
PGFinalGradesSetup (191)
PGGradeScales (192)
PGGradeScalesMark (193)
PGIncomingQueue (40)
PGNotification (173)
PGPreferences (43)
PGScores (96)
PGSections (195)
PGStudents (194)
PhoneLog (27)
PhoneNumber
PhoneNumberCoreFields
PISA_Session
PluginBackupData
PluginConfigDefaults
PluginConfigOIDProvider
PluginConfigWSTrustBridge
PluginConfOAuthConsumer
PluginConfOAuthProvider
PluginConfWebCustomPage
PluginConfWSSoapClient
PluginConfWSSoapConsumer
PluginConfWSSoapProvider
PluginDef
PluginDefAccessRequest
PluginDefAsset
PluginDefEntityAttribMap
PluginDefInterfaceMap
PluginDefRole
PluginDefSchoolsMap
PluginDefStatesMap
PluginEntity
PluginEntityAttrib
PluginEventSubscriber
PluginEventType
PluginInterface
PluginKnownHost
PluginLink
PluginLinkContext
PlugInLinkRoleCapMap
PluginPublisher
PluginRegistration
PluginRegistrationParam
PluginResourceEntity
PluginSubscriberEventType
PostSecondary (165)
Pre_Mig_Fld_Lvl_Security_Bkup
Pre_Mig_Guardian_Details_Bkup
Pre_Mig_Student_Details_Bkup
Prefs (9)
Program (174)
PS_Common_Code_Config
PS_Common_Code
PS_Membership_Defaults
PS_WritebackAuditTrail
PSM_Asset
PSM_AssetContent
PSM_AssetContentArchive
PSM_AssetFolder
PSM_ChartLayout
PSM_ChartLayoutPreference
PSM_ChartObject
PSM_ChartSection
PSM_ChartTeacherSection
PSM_JobQueueCurrent
PSM_ReportAppCatAssoc
PSM_ReportApplication
PSM_ReportClass
PSM_ReportColumn
PSM_ReportEntity
PSM_ReportMapping
PSM_ReportModel
PSM_ReportNode
PSM_ReportOutput
PSM_ReportParameter
PSM_ReportParamOptions
PSM_ReportPath
PSM_ReportProject
PSM_ReportPub
PSM_ReportPubAppCat
PSM_ReportPubRole
PSM_ReportPubSchool
PSM_ReportRunTimeRequest
PSM_ReportTree
PSM_ReportTreeParamAssoc
PSM_TeacherFavoriteComment
Queries_Table
Queue (24)
ReadReceipt
ReEnrollments (18)
RegistReq (56)
Relationship (189)
RepoBatchSetups (101)
RepoLookupTables (65)
RepoLookupTablesContentsI (67)
RepoLookupTablesContRecords (6)
RepoLookupTablesDefItems (66)
Reports (22)
RepoSetups (59)
RepoSetupsItems (60)
RepoSetupsOrderBy (64)
RepoSetupsQueries (63)
RepoSetupsQueryItems (62)
RepoSetupsUserData (61)
RepoSetupsUserDataDefaults (91)
RepoSetupsVariables (83)
RObj (36)
RoleAccess
RoleAttributeGroup
RoleAvailableAccess
RoleAvailableCapability
RoleAvailableDataGroup
RoleAvailableIDPCapability
RoleAvailableProperty
RoleCapability
RoleCategoryAccess
RoleChangeHistoryAccess
RoleData
RoleDef
RoleDefTeachersMap
RoleEnterpriseRptAccess
RoleFieldAccess
RoleMassDataAccess
RoleModule
RoleProperty
Room (139)
SCED_Code_Mapping
Sched_Debug (115)
SchedCategoryBalancing
SchedSectProgSettings
ScheduleActivityStatus (73)
ScheduleBldSessions (114)
ScheduleBuildCourseRank (116)
ScheduleBuildDiagnostics (118)
ScheduleBuildings (71)
ScheduleBuilds (105)
ScheduleCatalogs (109)
ScheduleCC (111)
ScheduleConstraints (110)
ScheduleCourseCatalogs (107)
ScheduleCourseRelationships (7)>
ScheduleDays (75)
ScheduleDepartments (69)
ScheduleFacilities (76)
ScheduleHouses (72)
ScheduleItems (52)
ScheduleLoadDiagnostics (119)
ScheduleLoadTypes (77)
SchedulePeriods (80)
ScheduleQueue (113)
ScheduleRequests (82)
ScheduleRooms (81)
ScheduleRoomTypes (74)
ScheduleSectionMeeting (130)
ScheduleSections (112)
ScheduleSectionTypes (79)
ScheduleTeacherAssignments (10)>
ScheduleTerms (108)
ScheduleValidation (117)
ScheduleValidTerms (70)
ScheduledEvent
SchemaUpdateStatus
School_Course_Sched_Parm (154)
School_Course (153)
SchoolAlertConfig
SchoolFee (145)
SchoolMap
SchoolProfile
Schools (39)
SchoolsCoreFields
SchoolStaff
Section_Meeting (140)
SectionAttrib
SectionReadiness
Sections (3)
SectionScores (100) (Obsolete)
SectionScoresAssignments (198)
SectionScoresID (197)
SectionTeacher
SectProgSettings
Selections (85)
SeqNo (58)
Server_Config (175)
Server_Instance_Singleton
Server_Instance (177)
SGRCalculationSettings
SIF_Message (179)
SPEnrollments (41)
Standard
StandardCourseAssoc
StandardCourseLowerWeight
StandardGradeRollup
StandardGradeRollupComment
StandardGradeSection
StandardGradeSectionComment
StandardReportingTermWeight
StandardRetakeScore
Standards_Migration_Backup (53)
StandardScore
StandardsCurrent (98)
StandardsGrades_Backup (99)
StandardThirdParty
StandardThirdPartyAssoc
StateEventQueue (102)
StateExtract_CodeConversion8
StateExtract_LayoutElements7
StateExtract_Layouts (126)
States
StateSupportData (21)
StateTransactionQueue (103)
Stats (17)
StoredGrades (31)
StudentAttendanceSummary (200)
StudentContactAssoc
StudentContactAssocCoreFields
StudentContactDetail
StudentContactDetailCoreField>
StudentCoreFields
StudentRace (201)
Students (1)
StudentSchedulingResults (190)
StudentSectCategoryTotal
StudentTest (87)
StudentTestScore (89)
Sys_Sequence (180)
SystemHistory
TableNumberMap
TeacherCategory
TeacherCatSectExcludeAssoc
TeacherCommentBank
TeacherDailyLoad (199)
TeacherFavoriteComment
TeacherPreference
TeacherRace (202)
Teachers_ncf31 (5)
TeacherScoreCode
Template
TermBinAttrib
TermBins (33)
Terms (13)
Test (86)
TestScore (88)
TmpDalxTables
TransformTemp
Transportation (120)
Truancies (42)
UCols (35)
UnexcusedHistorical
UnexcusedNotify
UnexcusedNotifyDates
UnexcusedNotifyDatesHist
UnexcusedNotifyHistory
UnexcusedYTD
UnSchedStudSchedLink (143)
UnSchedTermDayPeriodSlot (142)
UnScheduledRoom (150)
UnScheduledStudent (141)
UnScheduledTeacher (149)
Users
UsersCoreFields
UTable (32)
VirtualFieldsDef (122)
VirtualTablesDef (121)
VirtualTablesLegacyData1
VirtualTablesLegacyData2
VirtualTablesLegacyData3
VS, 45
WebAsmt, 124
Terminology
Comparator | A tool used to search and retrieve records by combining two or more criteria |
Compound Query | A search command containing multiple queries that are separated by an and (;) comparator between the two queries |
Data Dictionary | A set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database |
Data Mining | The process of finding anomalies, patterns, and correlations within large data sets |
Dataset | A collection of data |
Field | A data structure for a single piece of data; organized into records that contains information relevant to a specific entity |
Foreign Key | A field (or collection of fields) in one table, that refers to the Primary Key in another table |
Primary Key | A unique value contained within a table's field that uniquely identifies each row/record in a database table |
Query | A request for information from a database |
Record | A grouping of fields within a table that reference one particular object (i.e., a row of data in a database) |
Report Codes | Commands used to customize report and labels, calculate GPAs, and export data |
Search Command | A statement of search instructions containing a field, comparator, and a search argument |
Search Argument | A comparison, placed within a query, to limit the rows of data returned |
Search Codes | A special type of command that searches by completing a calculation and comparing the results |
Table | A place where all the data in a database is stored; organized into a row-and-column format |