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 |
|
|
|
|
|
|
|
|
|
studentParentAssociations
The studentParentAssociations resource links students to their parents or guardians. Primary PowerSchool Source Data
Tables: Person (p), StudentContactAssoc (sca), StudentContactDetail (scd), Codeset (cs), Students (s) 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.
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 |