PowerSchool Plugin - Tables and Fields | Incident IQ Help Center

Student Email Address Data

The following tables & fields are supported for pulling student email address data:

Table Name	Field(s) Supported
EmailAddress (Default)	EmailAddressID EmailAddress
U_DEF_ACCOUNT_MGMT	Studentsdcid STUDENT_EMAIL
U_DEF_EXT_STUDENTS	STUDENTSDCID STUDENTEMAIL

Parent/Guardian Data

This section supports pulling parent/guardian information. The base query uses standard contact tables and provides filtering options based on specific criteria.

Source: Standard PowerSchool contact tables.
Options: Administrators may choose to pull all associated parent/guardian data or only the primary contact (contactpriorityorder=1).

Table	Field(s)
psm_student	Id studentidentifier
PSM_StudentContact	Id Email Studentcontacttypeid studentid
PSM_StudentContactType	Id Description name
Person	ID DCID FIRSTNAME MIDDLENAME LASTNAME
StudentContactAssoc	STUDENTDCID PERSONID StudentContactAssocID contactpriorityorder
StudentContactDetail	STUDENTCONTACTASSOCID ENDDATE ISACTIVE ISCUSTODIAL ISEMERGENCY STARTDATE RELATIONSHIPTYPECODESETID
Codeset	CodesetID CODE DESCRIPTION DISPLAYVALUE
PersonEmailAddressAssoc	PERSONID EMAILADDRESSID Emailaddresspriorityorder ISPRIMARYEMAILADDRESS
EmailAddress	EmailAddressID EmailAddress
PersonPhoneNumberAssoc	PERSONID PHONENUMBERID ISPREFERRED

Awesome Student Contacts

Table	Field(s)
u_stu_contact	Studentsdcid C1_FIRST_NAME C1_LAST_NAME C2_FIRST_NAME C2_LAST_NAME C1_CELL_PHONE C2_CELL_PHONE C1_EMAIL, C2_EMAIL C1_Home_Phone C2_Home_Phone C1_Work_Phone C2_Work_Phone C1_Receive_Mail C2_Receive_Mail C1_Street C2_Street C1_City C2_City C1_State C2_State C1_Zip C2_Zip C4_Street C4_City C4_State C4_Zip

Staff Role Assignment Data

(Default) OneRoster Roles

Table	Field(s)
SectionTeacher	SectionID TeacherID ID End_Date Start_Date RoleID PriorityOrder Allocation
RoleDef	ID Name RoleKey

California-Specific Configuration

Table	Field(s)
S_CA_USR_STAFFASSIGNMENTS_C	UsersDCID Cert_Class_Desig Job_Code_1

Full List of Support Fields & Tables

For data mapping and query building, use the following comprehensive reference of PS Tables and their associated Fields.

Table	Associated Field(s)
Courses	Course_name Course_number Dcid Id Schoolid status, code Sched_year sched_department
Schools	school_number
Users	DCID TeacherNumber LoginID TeacherLoginID First_Name Middle_Name Last_Name Street City State Zip Email_Addr Home_Phone HomeSchoolID School_Phone Homeroom PSAccess
SchoolStaff	Id SchoolID StaffStatus Status Users_DCID Sched_BuildingCode Sched_Classroom Sched_Department Sched_Homeroom Sched_HouseCode DCID
Students	ID DCID Student_Number State_StudentNumber Student_Web_ID Street City State Zip Geocode, Mailing_Street Mailing_City Mailing_State Mailing_Zip Mailing_Geocode Last_Name First_Name Middle_Name Home_Room Enroll_Status Grade_Level SchoolID Enrollment_SchoolID EntryDate ExitDate GUARDIANEMAIL MOTHER FATHER summerSchoolId person_id
psm_student	Id studentidentifier
PSM_StudentContact	Id Email Studentcontacttypeid studentid
PSM_StudentContactType	Id Description name
Person	ID DCID FIRSTNAME MIDDLENAME LASTNAME
StudentContactAssoc	STUDENTDCID PERSONID StudentContactAssocID contactpriorityorder
StudentContactDetail	STUDENTCONTACTASSOCID ENDDATE ISACTIVE ISCUSTODIAL ISEMERGENCY STARTDATE RELATIONSHIPTYPECODESETID
Codeset	CodesetID CODE DESCRIPTION DISPLAYVALUE
PersonEmailAddressAssoc	PERSONID EMAILADDRESSID Emailaddresspriorityorder ISPRIMARYEMAILADDRESS
EmailAddress	EmailAddressID EmailAddress
PersonPhoneNumberAssoc	PERSONID PHONENUMBERID ISPREFERRED
PhoneNumber	PhoneNumberID PhoneNumber PhoneNumberEXT ISSMS
Sections	DCID SchoolID Course_Number TermID Section_Number Expression Teacher Grade_Level Room Id
Terms	DCID YearId FirstDay LastDay ID SchoolId
SectionTeacher	SectionID TeacherID ID End_Date Start_Date RoleID PriorityOrder Allocation
RoleDef	ID Name RoleKey
Teachers	DCID Status Users_DCID
S_CA_USR_STAFFASSIGNMENTS_C	UsersDCID Cert_Class_Desig Job_Code_1
U_DEF_ACCOUNT_MGMT	Studentsdcid STUDENT_EMAIL
U_DEF_EXT_STUDENTS	STUDENTSDCID STUDENTEMAIL
u_stu_contact	Studentsdcid C1_FIRST_NAME C1_LAST_NAME C2_FIRST_NAME C2_LAST_NAME C1_CELL_PHONE C2_CELL_PHONE C1_EMAIL C2_EMAIL C1_Home_Phone C2_Home_Phone C1_Work_Phone C2_Work_Phone C1_Receive_Mail C2_Receive_Mail C1_Street C2_Street C1_City C2_City C1_State C2_State C1_Zip C2_Zip C4_Street C4_City C4_State C4_Zip

Query Types + Options

List all Student Users

Base: >(Default)
Options for Student Email:
- Default PS tables (reading from emailaddress)
- Reading student email from U_DEF_ACCOUNT_MGMT
- Reading student email from U_DEF_EXT_STUDENTS

List all Staff Users

Base: >(Default)
Options for Staff Roles:
- Default OneRoster roles
- California-specific Staff Assignment Table (S_CA_USR_STAFFASSIGNMENTS_C)

List all Guardian Users

Base: >(Default)
Options for Guardian Selection:
- Include all Active Guardians
- One guardian per student (by contact priority)
- Awesome Contacts