On this page:
Students Table
PowerSchool includes data validation for the following Students table fields:
ALERT_DISCIPLINEEXPIRES ALERT_GUARDIANEXPIRES ALERT_MEDICALEXPIRES ALERT_OTHEREXPIRES ALLOWWEBACCESS APPLIC_RESPONSE_RECVD_DATE APPLIC_SUBMITTED_DATE BUILDING BUS_ROUTE BUS_STOP CAMPUSID CITY CLASSOF DISTRICTENTRYDATE DISTRICTENTRYGRADELEVEL DISTRICTOFRESIDENCE DOB DOCTOR_NAME DOCTOR_PHONE EMERG_CONTACT_1 EMERG_CONTACT_2 EMERG_PHONE_1 EMERG_PHONE_2 ENROLLMENTCODE ENROLLMENTID ENROLLMENTTYPE ENROLLMENT_SCHOOLID ENROLLMENT_TRANSFER_DATE_PEND ENROLL_STATUS ENTRYCODE ENTRYDATE EXITCODE EXITDATE FAMILY_IDENT FATHER FEDRACEDECLINE FEE_EXEMPTION_STATUS FIRST_NAME FTEID GENDER GEOCODE GPENTRYYEAR GRADE_LEVEL GRADREQSET GRADUATED_RANK GRADUATED_SCHOOLID GRADUATED_SCHOOLNAME GUARDIANFAX | GUARDIAN_STUDENTCONT_GUID HOME_PHONE HOME_ROOM HOUSE LASTFIRST LAST_NAME LOCKER_COMBINATION LOCKER_NUMBER LUNCH_ID MAILING_CITY MAILING_GEOCODE MAILING_STATE MAILING_STREET MAILING_ZIP MIDDLE_NAME MOTHER PHONE_ID SCHED_NEXTYEARBUILDING SCHED_NEXTYEARGRADE SCHED_NEXTYEARHOMEROOM SCHED_NEXTYEARHOUSE SCHED_NEXTYEARTEAM SCHED_PRIORITY SCHED_YEAROFGRADUATION SCHOOLENTRYDATE SCHOOLENTRYGRADELEVEL SCHOOLID SSN STATE STATE_STUDENTNUMBER STREET STUDENT_ALLOWWEBACCESS STUDENT_NUMBER STUDENT_WEB_ID SUMMERSCHOOLNOTE TEAM TRACK TUITIONPAYER WEB_ID WITHDRAWAL_REASON_CODE WM_ADDRESS WM_CREATEDATE WM_STATUS WM_STATUSDATE WM_TA_DATE WM_TA_FLAG WM_TIER ZIP |
Teachers Table
PowerSchool includes data validation for the following Teachers table fields:
ADMINLDAPENABLED BALANCE1 BALANCE2 BALANCE3 BALANCE4 CITY DOB EMAIL_ADDR ETHNICITY FEDETHNICITY FEDRACEDECLINE FIRST_NAME GRADEBOOKTYPE GROUP HOMEROOM HOME_PHONE LASTFIRST LASTMEAL LAST_NAME LOGINID LUNCH_ID MAXIMUM_LOAD MIDDLE_NAME NAMEASIMPORTED NOOFCURCLASSES NUMLOGINS PASSWORD PERIODSAVAIL PHOTO POWERGRADEPW PREFERREDNAME PSACCESS SCHED_ACTIVITYSTATUSCODE SCHED_BUILDINGCODE SCHED_CLASSROOM SCHED_DEPARTMENT SCHED_GENDER | SCHED_HOMEROOM SCHED_HOUSECODE SCHED_MAXIMUMCONSECUTIVE SCHED_MAXIMUMCOURSES SCHED_MAXIMUMDUTY SCHED_MAXIMUMFREE SCHED_MAXPERS SCHED_MAXPREPS SCHED_PRIMARYSCHOOLCODE SCHED_TEAM SCHED_TOTALCOURSES SCHOOLID SCHOOL_PHONE SIF_STATEPRID SSN STAFFPERS_GUID STAFFSTATUS STATE STATUS STREET SUPPORTCONTACT TEACHERLDAPENABLED TEACHERLOGINID TEACHERLOGINPW TEACHERNUMBER TITLE WM_ADDRESS WM_ALIAS WM_CREATEDATE WM_EXCLUDE WM_PASSWORD WM_STATUS WM_STATUSDATE WM_TA_DATE WM_TA_FLAG WM_TIER ZIP |
Database Extensions (Legacy Custom Fields)
PowerSchool includes data validation for the following Students database extensions (legacy custom fields):
DATEOFENTRYINTOUSA IPT_ORAL_CURDATE IPT_ORAL_ORIGDATE IPT_READING_CURDATE IPT_READING_ORIGDATE IPT_WRITING_CURDATE IPT_WRITING_ORIGDATE |