The StudentContactRelationship SIF Object defines the relationship between a student and a contact person. Each record links one StudentContactPersonal record to one StudentPersonal record.
Events
SIF Events are reported for this object.
Element Mappings for StudentContactRelationship
|
Element Name or @Attribute |
Submission |
Definition |
Code Set, if applicable |
[Table]Field Mapping |
Business Rules |
|---|---|---|---|---|---|
|
RefId |
Required |
Unique identifier for the student-contact relationship. |
|
[CST_PUBPUBLISHED_TMP]SIFREFID |
One record per student-contact association. |
|
StudentPersonalRefId |
Required |
Reference to the student. |
|
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_3 |
Preprocessed StudentPersonal RefId. |
|
StudentContactPersonalRefId |
Required |
Reference to the contact person. |
|
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_2 |
Preprocessed StudentContactPersonal RefId. |
|
Relationship/Code/value |
Required |
CEDS relationship code. |
CEDS relationship code |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_4 |
Relationship label is mapped: Aunt 2652, Brother 2653, Father 1735, Foster 2667, Friend 2668, Grandparent 2659, Grandmother 2657, Mother 1736, Neighbor 2670, Other 2675, Sister 2662, Step-Parent 2671, Uncle 2663. Unmapped values publish null. |
|
ContactFlags/ParentLegalGuardian/value |
Optional |
Indicates whether the contact is the student's parent or legal guardian. |
Yes/No |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_5 |
|
|
ContactFlags/PickupRights/value |
Optional |
Indicates whether the contact has pickup rights. |
Yes/No |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_6 |
|
|
ContactFlags/LivesWith/value |
Optional |
Indicates whether the student lives with the contact. |
Yes/No |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_7 |
|
|
ContactFlags/AccessToRecords/value |
Optional |
Indicates whether the contact has access to student records. |
Yes/No |
[GuardianStudent]StudentsDCID, [GuardianPersonAssoc]GuardianID, [StudentContactAssoc]StudentContactAssocID |
Publishes Yes when the contact is associated through the Guardian tables; otherwise No. |
|
ContactFlags/EmergencyContact/value |
Optional |
Indicates whether the contact is an emergency contact. |
Yes/No |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_8 |
|
|
ContactFlags/HasCustody/value |
Optional |
Indicates whether the contact has custody. |
Yes/No |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_9 |
|
|
ContactFlags/DisciplinaryContact/value |
Optional |
Indicates whether the contact is a disciplinary contact. |
Yes/No |
[OriginalContactMap]StudentContactAssocID, [OriginalContactMap]OriginalContactType |
Publishes Yes when original contact type is disciplinary; otherwise No. |
|
ContactFlags/PrimaryCareProvider/value |
Optional |
Indicates whether the contact is the primary care provider. |
Yes/No |
Calculated constant Unknown |
No PowerSchool source field is consulted. |
|
ContactSequence |
Optional |
Sequence of the contact for the student. |
|
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_4 |
Extracted from the second pipe-delimited segment. |
Relationship Code Mapping
|
PowerSchool Code |
SIF Value |
|---|---|
|
Aunt |
Aunt |
|
Brother |
Brother |
|
Brother-In-Law |
BrotherInLaw |
|
Cousin |
Cousin |
|
Daugther |
Daugther |
|
Father |
Father |
|
Foster Parent |
FosterParent |
|
Friend |
Friend |
|
Godparent |
Godparent |
|
Grandfather |
Grandfather |
|
Grandmother |
Grandmother |
|
Grandparent |
Grandparent |
|
Mother |
Mother |
|
Neighbor |
Neighbor |
|
Other |
Other |
|
Sister |
Sister |
|
Sister-In-Law |
SisterInLaw |
|
Stepfather |
Stepfather |
|
Stepmother |
Stepmother |
|
Uncle |
Uncle |
Publish StudentContactPersonal before StudentContactRelationship so the referenced contact records already exist when relationship records are published.