Skip to main content
Skip table of contents

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.

Primary PowerSchool Source Data

  • [Person]
  • [StudentContactAssociation]
  • [Codeset]
  • [PersonAddress]
  • [EmailAddress]
  • [PersonEmailAddressAssoc]
  • [PhoneNumber]
  • [PersonPhoneNumberAssoc]

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).

Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

Data Type

Stored in [Table]Field

Req'd

parentUniqueId

A unique alpha-numeric code assigned to a parent.

String

Derived from:
[Person].id

district Id + '-' + [Person].id

R

personalTitlePrefix

A prefix used to denote the title, degree, position, or seniority of the person.

String

[Person]prefixcodesetid (value =[Codeset]code)

O

firstName

A name given to an individual at birth, baptism, during another naming ceremony, or through legal change.

String

[Person]firstName

R

middleName

A secondary name given to an individual at birth, baptism, or during another naming ceremony.

String

[Person]middleName

O

lastSurname

The name borne in common by members of a family.

String

[Person]lastName

R

generationCodeSuffix

An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., III.

String

[Person]suffixcodesetid (value = [Codeset]code)

O

sexDescriptor

A person's gender: Female or Male.

Type

[Person]gendercodesetid

O

addresses


/addressTypeDescriptor

The type of address listed for an individual or organization.

Type

[personaddressassoc]addresstypecodesetid

R

/streetNumberName

The street number and street name or post office box number of an address.

String

[PersonAddress].street

R

/apartmentRoomSuiteNumber

The apartment, room, or suite number of an address.

String

[PersonAddress]linetwo

O

/buildingSiteNumber

The number of the building on the site, if more than one building shares the same address.

String

[PersonAddress]unit

O

/city

The name of the city in which an address is located.

String

[PersonAddress]city

R

/stateAbbreviationType

The abbreviation for the state (within the United States) or outlying area in which an address is located.

String

[Codeset]code from [PersonAddress]statecodesetid

R

/postalCode

The five or nine-digit zip code or overseas postal code portion of an address.

String

[PersonAddress]postalcode

R

/doNotPublisheIndicator

[personaddressassoc]addresstypecodesetid

electronicMails


/electronicMailAddress

The electronic mail (e-mail) address listed for an individual or organization.

String

[EmailAddress]emailadress

R

/electronicMailType

The type of email listed for an individual or organization.

Type

[PersonEmailAddressAssoc]emailtypecodesetid

R

/primaryEmailAddressIndicator

An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.

Boolean

when [PersonEmailAddressAssoc]isprimaryemailaddress = 1 then 'true'


telephones


/telephoneNumber

The telephone number including the area code, and extension, if applicable.

String

[PhoneNumber]phonenumber

R

/telephoneNumberTypeDescriptor

The type of communication number listed for an individual.

Type

[PersonPhoneNumberAssoc]phonetypecodesetid

R

/orderOfPriority

[PersonPhoneNumberAssoc]phonenumberpriorityorder

/textMessageCapabilityIndicator

An indication that the telephone number is technically capable of sending and receiving Short Message Service (SMS) text messages.

Boolean

[PhoneNumber]IsSMS = 1 then true

O

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

parentUniqueId

ParentUniqueId - The parent associated with the student.

String

Derived from:
[Person].id

district Id + '-' + [Person].id

R

studentUniqueId

The student associated with parent.

String

[Students]state_studentnumber

R

emergencyContactStatus

Indicator of whether the person is a designated emergency contact for the student.

Boolean

[StudentContactDetail]isemergency

O

primaryContactStatus

Indicator of whether the person is a primary parental contact for the student.

Boolean

[StudentContactDetail]iscustodial

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.

Type

[StudentContactAssociation]curreltypecodesetid

R

livesWith

Indicator of whether the student lives with the associated parent.

Boolean

[StudentContactDetail]liveswithflg

O

JavaScript errors detected

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

If this problem persists, please contact our support.