ContactPersonDim View

Purpose

Contains names and contact information for a student's parents and/or guardians. Part of the Core View Collection.

SQL Object

analytics.ContactPersonDim

Usage Notes

When using the ContactPersonDimension, it may be important to pay attention to the ContactRestrictions value. This field may indicate that a parent should not be contacted, for example, due to a restraining order.

This view flattens the edfi.StudentParentAssociation into a single structure, so a surrogate key is introduced as UniqueKey. This facilitates loading the data into modeling tools that require a single unique primary key on each table. This value is not used anywhere else in the Analytics Middle Tier semantic model.

Sources

Data Standard 2.2

Data Standard 3+

Structure

Same for both 2.2 and 3+ data standards.

Column

Data Type

Source

Description

UniqueKeyString"{Parent.ParentUniqueId}-{Student.StudentUniqueId}"Surrogate key so that modeling tools will have a unique primary key
ContactPersonKeyStringParent.ParentUniqueId
StudentKeyStringStudent.StudentUniqueId
ContactFirstNameStringParent.FirstName
ContactLastNameStringParent.LastName
RelationshipToStudentStringRelationType.CodeValue
ContactHomeAddressString

"{ParentAddress.StreetNumberName}, {ParentAddress.ApartmentRoomSuiteNumber}, {ParentAddress.City}, {StateAbbreviationType.CodeValue} {ParentAddress.PostalCodeValue}"

Where Descriptor Constant= "Home"
ContactPhysicalAddressString

see above

Where Descriptor Constant= "Home"
ContactMailingAddressStringsee aboveWhere Descriptor Constant= "Mailing"
ContactWorkAddressStringsee aboveWhere Descriptor Constant= "Work"
ContactTemporaryAddressStringsee aboveWhere Descriptor Constant= "Temporary"
HomePhoneNumberStringParentTelephone.TelephoneNumberWhere Descriptor Constant = "Home"
MobilePhoneNumberStringParentTelephone.TelephoneNumberWhere Descriptor Constant = "Mobile"
WorkPhoneNumberStringParentTelephone.TelephoneNumberWhere Descriptor Constant = "Work"
PrimaryEmailAddressStringParentElectronicMail.PrimaryEmailAddressIndicator

"Work" if the work email address is primary, or "Personal" if the personal address is the primary, or "Not Specified"

PersonalEmailAddressStringParentElectronicMail.ElectronicMailAddressWhere Descriptor Constant = "Home/Personal"
WorkEmailAddressStringParentElectronicMail.ElectronicMailAddressWhere Descriptor Constant = "Work"
IsPrimaryContactBooleanStudentParentAssociation.PrimaryContactStatus(warning) The Ed-Fi data model does not preclude having multiple primary contacts.
StudentLivesWithBooleanStudentParentAssociation.LivesWith
IsEmergenyContactBooleanStudentParentAssociation.EmergencyContactStatus
ContactPriorityIntStudentParentAssociation.ContactPriority
ContactRestrictionsStringStudentParentAssociation.ContactRestrictions
LastModifiedDateDateMost recent of (StudentParentAssociation.LastModifiedDate, Parent.LastModifiedDate, ParentElectronicMail.LastModifiedDate, ParentTelephone.LastModifiedDate, ParentAddress.LastModifiedDate)



Contents