Skip to main content
Skip table of contents

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

Required
personalTitlePrefixA prefix is used to denote the title, degree, position, or seniority of the person.String[S_Contacts_S]PrefixOptional
firstNameThe primary name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.String[S_Contacts_S]First_NameRequired
middleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony.String[S_Contacts_S]Middle_NameOptional
lastSurnameA common name shared by members of a family.String[S_Contacts_S]Last_NameRequired
generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family, like Jr., Sr., III.String[S_Contacts_S]SuffixOptional
sexTypeA 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_SIDRequired

studentReference

A reference to the related students' resources.

Required

/studentUniqueID

The student associated with the contact.String[Students]State_StudentNumberRequired
relationTypeThe 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]RelationshipOptional
primaryContactStatusIndicator of whether the person is a primary parental contact for the Student.Boolean

[S_Contact_Relationship_C]Primary_Contact, if populated

Otherwise: '0'

Optional
livesWithIndicator of whether the Student lives with the associated parent.Boolean

[S_Contact_Relationship_C]Lives_With, if populated

Otherwise: '0'

Optional
emergencyContactStatusIndicator of whether the person is a designated emergency contact for the Student.Boolean

[S_Contact_Relationship_C]Emergency_Contact, if populated

Otherwise: '0'

Optional
contactPriorityThe numeric order of the preferred sequence or priority of contact.Integer[S_Contact_Relationship_C]Contact_OrderOptional
contactRestrictionsRestrictions 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]NotesOptional
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.