Skip to main content
Skip table of contents

Data Validation Appendix

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.