Student Contacts
This category represents information about parents/guardians and their relationships to students as published in the Parent resource within the Contacts category. The Contacts category includes the following data views and resources:
Student Contacts
This view captures the demographic record for each student contact as published in the Parent resource within the Contacts category. It includes each contact associated with a student in PowerSchool who was included for publishing in the Student resource. The layout includes School Name, Contact ID, Student Contact Name, and Contact Unique ID.
Each contact must first have an assigned Unique Person Identifier (Unique ID) in order for the contact record to be published. At his time, a Unique ID is automatically assigned to each contact. In turn, the publishing of the related StudentParentAssociation resource is dependent on the successful publishing of the contact record; as needed, use the Publishing Errors data view to identify and resolve any issues.
Parents
This resource represents a parent or guardian of a student, such as mother, father, or caretaker. One record is published for each Person record where a StudentContactAssociation exists for a student who is enrolled during the school year.
IMPORTANT: The logic will check the field sets listed below in the order designated on the Guardian Name Logic Preference portion of the District Info page.The logic will checked the number 1 ranked field set first, then the 2nd ranked field set, and finally the 3rd. In order for the logic to pull all elements from a given field set, the contact first and last name must be present.
Student Contact Fields
[StudentContactDetail]iscustodial
[StudentContactDetail]LivesWith
[Person]
[StudentContactAssociation]
[Codeset]
[PersonAddress]
[EmailAddress]
[PersonEmailAddressAssoc]
[PhoneNumber]
[PersonPhoneNumberAssoc]
If Student Contacts is the source, the information is pulled from the highest ranking contact where the following fields are checked:
[StudentContactDetail]iscustodial
[StudentContactDetail]LivesWith
NM Specific Field
S_NM_STU_X.GuardianFirstName
S_NM_STU_X.GuardianLastName
S_NM_STU_X.GuardianEmail
S_NM_STU_X.GuardianPhone
Legacy Guardian Field
StudentCoreFields.GuardianFN
StudentCoreFields.GuardianLN
StudentCoreFields.GuardianDayPhone
Students.GuardianEmail
Selection Criteria
Records are published if the following criteria are met:
The contact is associated with a student who qualifies for publishing (based on having a valid school enrollment in the year for the Term selected in the PowerSchool UI).
Contact Unique ID must be populated.
The contact must not be excluded from state reporting.
Contact FirstName and LastName must be populated.
Resource Output
A separate record is published for each parent or guardian associated with a student who qualifies for publishing.
The Parent resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
parentUniqueId | A unique alpha-numeric code assigned to a parent. | String | Student Contacts Derived from: district Id + '-' + [Person].id NM Specific Fields & Legacy Guardian Fields ProfileID+Students.DCID+YearID | R |
firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | String | Student Contacts [Person]firstName NM Specific Fields [S_NM_STU_X]GuardianFirstName Legacy Guardian Fields [StudentCoreFields]GuardianFN | R |
lastSurname | The name borne in common by members of a family. | String | Student Contacts [Person]LastName NM Specific Fields [S_NM_STU_X]GuardianLastName Legacy Guardian Fields [StudentCoreFields]GuardianLN | R |
Student Associations
This view captures the associations of contacts to students as published in the StudentParentAssociation resource within the Parent category. The layout includes School Name, Contact ID, Student Contact Name, Contact Unique ID, Relationship, Student Number, Student Name, and UIC.
studentParentAssociations
This resource relates students to their parents, guardians, or caretakers.
Primary PowerSchool Source Data
[Person]
[StudentContactAssociation]
[StudentContactDetail]
[Students]
Selection Criteria
Records are published if the following criteria are met:
Both the Student and Parent were previously published in the Student and Parent resources.
Resource Output
A separate StudentParentAssociation record is published for each unique Student/Parent combination included in the Student and Parent resources.
The StudentParentAssociation resource is dependent on the prior publishing of the following resources: Student and Parent.
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.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
parentReference | ||||
parentUniqueId | The ID associated with the parent associated with the student. | String | Student Contacts Derived from: district Id + '-' + [Person].id NM Specific Fields & Legacy Guardian Fields ProfileID+Students.DCID+YearID | R |
studentReference | ||||
studentUniqueId | The student associated with parent. | String | [Students]state_studentnumber | R |
primaryContactStatus | Indicator of whether the person is a primary parental contact for the student. | Boolean | Always published as True | O |
relationDescriptor | The nature of an individual's relationship to a student, for example, Father, Mother, Step Father, Step Mother, Foster Father, Foster Mother, Guardian, etc. Relation Type Descriptor Set | String | Always published as Other | R |