Contacts
Student contact refers to the information related to the individuals who can be contacted regarding a student. This typically includes parents, guardians, or other responsible parties.
Contact Information: Details such as names, addresses, phone numbers, and email addresses of the contacts.
Relationship to Student: The nature of the relationship between the contact and the student (e.g., parent, guardian, emergency contact).
Contact Preferences: Information on how and when the contact prefers to be reached.
Emergency Contact Details: Specifics about who to contact in case of an emergency and their priority.
parents
Primary PowerSchool Source Data
Tables: core Student Contacts (Unlimited Contacts):
Person (p), StudentContactAssoc (sca), StudentContactDetail (scd), Codeset (cs), PersonAddress (pa), PersonAddressAssoc (paa), EmailAddress (ea), PersonEmailAddressAssoc (peaa), PhoneNumber (pn), PersonPhoneNumberAssoc (ppna)
Selection Criteria
Legacy TEA: Parents/guardian are collected only for the SPPI-14 collection, which reports students who were prior year SPED grads and specific types of leavers.
For Ed-fi, publish max 2 contacts for all enrolled students
Selection Criteria: Publish records from the Person table where:
At least one StudentContactAssociation exists for the student
Student is enrolled during the school year
scd.isactive = 1
Additional criteria from student contact record (in order)studentcontactdetail.iscustodial = 1
studentcontactdetail.liveswithflg = 1
Codeset.code from StudentContactAssoc.currreltypecodesetid
Legal Guardian
Mother
Father
Otherwise contacts with highest priority
Resource Output
A student record is published for each student enrolled in the district in the year for the Term selected in the PowerSchool UI.
The student resource is not dependent on the prior publishing of other Ed-Fi resources.
Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record in the Student Enrollment category has also been uploaded for the same student.This establishes a relationship between the school, the associated LEA, and the student.
The LEA then has permission to modify the previously uploaded Student record.
LEAs and Schools may upload (publish) data to the ODS in real-time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Resource | Data Element | Description | TX Element | TX Element Name | Stored in [Table]Field
| Required? |
parentUniqueId | E1324 | PARENT-ID | derived from person.id (same as studentcontactassoc.personid) | Y | ||
personalTitlePrefix | Person.PrefixCodeSetID (value = cs.code) | N | ||||
firstName | E0703 | FIRST-NAME | Person.FirstName | Y | ||
middleName | E0704 | MIDDLE-NAME | Person.MiddleName | N | ||
lastSurname | E0705 | LAST-NAME | Person.LastName | Y | ||
addresses | [Array] | TX | ||||
addressTypeDescriptor | E1113 | ADDRESS-TYPE | personaddress: code value from personaddressassoc.addresstypecodesetid | Y | ||
streetNumberName | E1114 | STREET-NUMBER-NAME | PersonAddress.Street | Y | ||
apartmentRoomSuiteNumber | E1115 | APARTMENT-ROOM-SUITE-NUMBER | PersonAddress.LineTwo | N | ||
buildingStieNumber | PersonAddress.unit | N | ||||
city | E1117 | CITY | PersonAddress.City | Y | ||
stateAbbreviationDescriptor | E1118 | STATE-ABBREVIATION | codeset.code from personaddress.statecodesetid | Y | ||
postalCode | E1119 | POSTAL-CODE | PersonAddress.PostalCode | Y | ||
electronicMails | [Array] | TX | ||||
electronicMailTypeDescriptor | E1242 | EMAIL-ADDRESS-TYPE | code value from peaa.emailtypecodesetid | Y | ||
electroncMailAddress | E1243 | EMAIL-ADDRESS | Students.guardianemail | Y | ||
primaryEmailAddressIndicator | when peaa.isprimaryemailaddress = 1 then 'true' | N | ||||
telephones | [Array] | TX | ||||
telephoneNumberTypeDescriptor | E1455 | TELEPHONE-NUMBER-TYPE | code value from ppna.phonetypecodesetid | Y | ||
telephoneNumber | E1269 | TELEPHONE-NUMBER | StudentCoreFields.guardiandayphone | Y | ||
orderOfPriority | ppna.phonenumberpriorityorder | N | ||||
textMessageCapabilityIndicator | when pn.IsSMS = 1 then 'true' | N | ||||
TX extensions |
|
| TX | |||
generationCodeDescriptor | E0706 | GENERATION-CODE | Person.SuffixCodeSetID (value = cs.code) | TX | ||
additional fields for display only |
|
|
| |||
sch.school_name | ||||||
p.lastname||', '||p.firstname | ||||||
studentParentAssociationsThe studentParentAssociations resource links students to their parents or guardians. Primary PowerSchool Source DataTables: Person (p), StudentContactAssoc (sca), StudentContactDetail (scd), Codeset (cs), Students (s) Selection CriteriaLegacy TEA: Parents/guardian are collected only for the SPPI-14 collection, which reports students who were prior year SPED grads and specific types of leavers.
Resource Output | ||||||
parentUniqueId | E1324 | PARENT-ID | derived from studentcontactassoc.personid | Y | ||
studentUniqueId | E1523 | TX-UNIQUE-STUDENT-ID | studentcontactassoc.studentdcid | Y | ||
emergencyContactStatus | studentcontactdetail.isemergency | N | ||||
primaryContactStatus | studentcontactdetail.iscustodial | N | ||||
relationDescriptor | E1423 | RELATION | Codeset.code from StudentContactAssoc.currreltypecodesetid | TX | ||
livesWith | studentcontactdetai.liveswithflg | N | ||||
contactPriority | E1427 | CONTACT-PRIORITY | StudentContactAssoc.ContactPriorityOrder | TX | ||
additional fields for display only |
|
|
| |||
sch.school_name | Y | |||||
s.student_number | Y | |||||
s.lastfirst | Y | |||||
p.lastname||', '||p.firstname | Y | |||||