Contacts
This category captures any contacts linked to the student including their defined relationship and includes the following data views and resources.
Student Contacts
This view captures the demographic record for each student contact as published in the parents resource within the Contacts category. It includes each contact associated with a student in PowerSchool who was included for publishing in the student's resource. The layout includes School Name, Contact ID, Student Contact Name, Contact Unique ID, Last Publish Date, Publishing ID, and Resource ID.
Each contact must first have an assigned Unique Person Identifier (Unique ID) in order for the contact record to be published. At this 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. Use the Publishing Errors data view, as needed, to identify and resolve any issues.
Districts can publish Student Resources on the basis of the current selection by selecting PUBLISH SELECTION - Publish records for current student selection. This option does not work if it is scheduled to run at a later time.
parents
Primary PowerSchool Source Data
[S_Contacts_S]
Selection Criteria
Records are published if the following criteria are met:
The contact must not be excluded from state reporting.
The contact's Unique ID must be populated.
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).
The contact's firstName and lastName must be populated.
The contact should be Active and should not have an End Date.
Resource Output
A separate record is published for each Student Contact associated with a student in PowerSchool who was included for publishing in the Student Demographic data.
The parent resource is not dependent on the prior publishing of any resources.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (Run Now button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required/Optional |
|---|---|---|---|---|
parentUniqueID | A unique alphanumeric code is assigned to a parent. | String | [S_Contacts_S]ID [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number Format - DistrictNumber-[S_Contacts_S]ID | Required |
personalTitlePrefix | A prefix is used to denote the title, degree, position, or seniority of the person. | String | [S_Contacts_S]Prefix | Optional |
firstName | The primary name given to an individual at birth, baptism, or during another naming ceremony, or through legal change. | String | [S_Contacts_S]First_Name | Required |
middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | String | [S_Contacts_S]Middle_Name | Optional |
lastSurname | A common name shared by members of a family. | String | [S_Contacts_S]Last_Name | Required |
generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family, like Jr., Sr., III. | String | [S_Contacts_S]Suffix | Optional |
sexType | A person's gender. | String | [S_Contacts_S]Gender, if populated Otherwise: 'Not Selected' | Optional |
parentAddress An unordered collection of parentAddresses. Parent's address, if different from the student's address. | Optional | |||
/addressType | The type of address listed for an individual or organization. | String | 'Home' 'Mailing' | Required |
/streetNumberName | The street number and street name or post office box number of an address. | String | [S_Contacts_S]Home_Address_1 [S_Contacts_S]Mailing_Address_1 | Required |
/apartmentRoomSuiteNumber | The apartment, room, or suite number of an address. | String | [S_Contacts_S]Home_Address_2 [S_Contacts_S]Mailing_Address_2 | Optional |
/buildingSiteNumber | The building number on the site, if more than one building shares the same address. | String | [S_Contacts_S]Home_Address_3 [S_Contacts_S]Mailing_Address_3 | Optional |
/city | The name of the city in which an address is located. | String | [S_Contacts_S]Home_City [S_Contacts_S]Mailing_City | Required |
/stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located. | String | [S_Contacts_S]Home_State [S_Contacts_S]Mailing_State | Required |
/postalCode | The five- or nine-digit zip code or overseas postal code portion of an address. | String | [S_Contacts_S]Home_Postal_Code [S_Contacts_S]Mailing_Postal_Code | Required |
/nameOfCounty | The name of the county, parish, borough, or comparable unit (within a state) in which an address is located. | String | [S_Contacts_S]Home_County [S_Contacts_S]Mailing_County | Optional |
parentElectronicMail An unordered collection of parentElectronicMails. The numbers, letters and symbols used to identify an e-mail user within the network to which the individual or organization belongs. | Optional | |||
/electronicMailType | The type of email listed for an individual or organization. | String | 'Home/Personal' 'Work' | Required |
/electronicMailAddress | The e-mail address listed for an individual or organization. | String | [S_Contacts_S]Personal_Email [S_Contacts_S]Work_Email | Required |
parentTelephone An unordered collection of parentTelephones. | Optional | |||
/telephoneNumberType | The type of phone number listed for an individual. | String | 'Home' 'Mobile' 'Work' | Required |
/telephoneNumber | The 10-digit telephone number, including the area code, for the parent or guardian. | Integer | [S_Contacts_S]Home_Phone [S_Contacts_S]Cell_Phone [S_Contacts_S]Work_Phone | Optional |
Student Associations
This data view represents a detailed list of student contacts and their relationship to the student. The published view layout provides the School Name, Student Number, Student Name, STN Number, Contact ID, Student Contact Name, Contact Unique ID, Relationship, Last Publish Date, Publishing ID, and Resource ID.
Customers can publish Contact data for Parent and StudentParentAssociation records in Ed-Fi.
studentParentAssociations
Primary PowerSchool Source Data
[S_Contact_Relationship_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student's school of enrollment must not be excluded from state reporting.
The contact's Unique ID must be populated.
The studentUniqueID (Indiana Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The contact should be Active and should not have an End Date.
Resource Output
A separate Student Contact record is published for each unique Student/Contact combination.
The studentParentAssociation resource is dependent on the prior publishing of the following resources: students, parents, studentSchoolAssociation.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (Run Now button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required/Optional |
|---|---|---|---|---|
parentReference A reference to the related parents resource. | Required | |||
/parentUniqueID | A unique alpha-numeric code assigned to a parent. | String | [S_Contact_Relationship_C]S_Contacts_SID | Required |
studentReference A reference to the related students' resources. | Required | |||
/studentUniqueID | The student associated with the contact. | String | [Students]State_StudentNumber | Required |
relationType | The nature of an individual's relationship to a student; like, Father, Mother, Step-Father, Step-Mother, Foster Father, Foster Mother, or Guardian. | String | [S_Contact_Relationship_C]Relationship | Optional |
primaryContactStatus | Indicator of whether the person is a primary parental contact for the Student. | Boolean | [S_Contact_Relationship_C]Primary_Contact, if populated Otherwise: '0' | Optional |
livesWith | Indicator of whether the Student lives with the associated parent. | Boolean | [S_Contact_Relationship_C]Lives_With, if populated Otherwise: '0' | Optional |
emergencyContactStatus | Indicator of whether the person is a designated emergency contact for the Student. | Boolean | [S_Contact_Relationship_C]Emergency_Contact, if populated Otherwise: '0' | Optional |
contactPriority | The numeric order of the preferred sequence or priority of contact. | Integer | [S_Contact_Relationship_C]Contact_Order | Optional |
contactRestrictions | Restrictions for student or teacher contact with the individual (e.g., the student may not be picked up by the individual). | String | [S_Contact_Relationship_C]Notes | Optional |