Student contact refers to the information related to the individuals who can be contacted regarding a student. This typically includes parents, guardians, or other responsible parties.
-
Contact Information: Details such as names, addresses, phone numbers, and email addresses of the contacts.
-
Relationship to Student: The nature of the relationship between the contact and the student (e.g., parent, guardian, emergency contact).
-
Contact Preferences: Information on how and when the contact prefers to be reached.
-
Emergency Contact Details: Specifics about who to contact in case of an emergency and their priority.
parents
eSP Source Data
Tables: REG_CONTACT (RC), REG_STU_CONTACT (rsc), REG_CONTACT_PHONE (ph), REGTB_PHONE (rtb),
REG_ENTRY_WITH (rew), REG_BUILDING (rb)
Selection Criteria
One record published for each contact in REG_CONTACT where:
-
Contact is linked to currently enrolled student (rew, rb) in REG_STU_CONTACT
-
rsc.contact_type in ('G','C','O') - Guardian, Contact, Other
Resource Output
-
The localEducationAgencies 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
|
Resource |
Data Element |
Description |
TX Element |
TX Element Name |
eSP Source |
Required? |
Comments |
|
parents |
|
|
|
|
|
|
|
|
|
parentUniqueId |
E1324 |
PARENT-ID |
reg_contact.district + '-' + reg_contact.contact_id |
Y |
district id left-zero-padded to 6 chars |
|
|
|
personalTitlePrefix |
|
|
reg_contact.title |
N |
|
|
|
|
firstName |
E0703 |
FIRST-NAME |
reg_contact.first_name |
Y |
|
|
|
|
middleName |
E0704 |
MIDDLE-NAME |
reg_contact.middle_name |
N |
|
|
|
|
lastSurname |
E0705 |
LAST-NAME |
reg_contact.last_name |
Y |
|
|
|
|
addresses |
|
|
[Array] |
TX |
Publish where personaddress.statecodestid not null and pa.postalcode not null |
|
|
|
|
addressTypeDescriptor |
E1113 |
ADDRESS-TYPE |
'04' - Mailing |
Y |
only one contact address field, districts use for mailing address |
|
|
|
streetNumberName |
E1114 |
STREET-NUMBER-NAME |
reg_contact street_number + street_prefix + street_name + street_suffix + street_type |
Y |
|
|
|
|
apartmentRoomSuiteNumber |
E1115 |
APARTMENT-ROOM-SUITE-NUMBER |
reg_contact apartment |
N |
|
|
|
|
buildingStieNumber |
|
|
reg_contact.complex |
N |
|
|
|
|
city |
E1117 |
CITY |
reg_contact.city |
Y |
|
|
|
|
stateAbbreviationDescriptor |
E1118 |
STATE-ABBREVIATION |
reg_contact.state |
Y |
|
|
|
|
postalCode |
E1119 |
POSTAL-CODE |
reg_contact.zip |
Y |
|
|
|
electronicMails |
|
|
[Array] |
TX |
emailaddress linked by personemailaddressassoc |
|
|
|
|
electronicMailTypeDescriptor |
E1242 |
EMAIL-ADDRESS-TYPE |
'01' - Home/Personal |
Y |
|
|
|
|
electroncMailAddress |
E1243 |
EMAIL-ADDRESS |
reg_contact.email |
Y |
|
|
|
|
primaryEmailAddressIndicator |
|
|
'true' |
N |
|
|
|
telephones |
|
|
[Array] |
TX |
phonenumber linked by personphonenumberassoc |
|
|
|
|
telephoneNumberTypeDescriptor |
E1455 |
TELEPHONE-NUMBER-TYPE |
reg_contact_phone.phone_type, regtb_phone.description |
Y |
map regtb_phone.code to TX descripotrs or publish descriptor codeValue where shortDescription = regtb_phone.description;
|
|
|
|
telephoneNumber |
E1269 |
TELEPHONE-NUMBER |
reg_contact_phone.phone + reg_contact_phone.phone_extension |
Y |
|
|
|
|
orderOfPriority |
|
|
not published |
N |
no source |
|
|
|
textMessageCapabilityIndicator |
|
|
not published |
N |
no source |
|
|
TX extensions |
|
|
|
TX |
|
|
|
|
|
generationCodeDescriptor |
E0706
|
GENERATION-CODE
|
reg_contact.generation
|
N |
only if value is defined; changed element to TX descriptor Oct 1 spec
|
|
|
additional fields for display only |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
district view only - context school where associated student enrolled |
studentParentAssociations
eSP Source Data
Tables: REG_STU_CONTACT (rsc), REGTB_RELATION (rtr), REG_ENTRY_WITH (rew), REG_BUILDING (rb)
Selection Criteria
One record published for each REG_STU_CONTACT where:
-
contact_type in ('G','O') or 'C' if no other rsc record for this contact/student
-
student is currently enrolled (rew, reb)
Resource Output
-
The localEducationAgencies 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
|
Resource |
Data Element |
Description |
TX Element |
TX Element Name |
eSP Source |
Required? |
Comments |
|
studentParentAssociations |
|
|
|
|
|
||
|
|
parentUniqueId |
E1324 |
PARENT-ID |
reg_contact.district + '-' + reg_contact.contact_id |
Y |
|
|
|
|
studentUniqueId |
E1523 |
TX-UNIQUE-STUDENT-ID |
ru.field_value where ru.screen_number = 10165, ru.field_number = 1 |
Y |
from sca.studentdcid |
|
|
|
emergencyContactStatus |
|
|
true if reg_stu_contact.contact_type = 'C' or other record exists for contact/student where contact_type = 'C' |
N |
|
|
|
|
primaryContactStatus |
|
|
true if reg_stu_contact.contact_priority = 1 or other record exists for contact/student where contact_priority = 1 |
N |
|
|
|
|
relationDescriptor |
E1423 |
RELATION |
reg_stu_contact.relation_code, regtb_relation.description |
TX |
map regtb_relation.code to TX descriptors or publish descriptor codeValue where shortDescription = regtb_relation.description;
|
|
|
|
livesWith |
|
|
reg_stu_contact.living_with |
N |
|
|
|
|
contactPriority |
E1427 |
CONTACT-PRIORITY |
reg_stu_contact.contact_priority |
TX |
|
|
|
|
additional fields for display only |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
district view only - context school where associated student enrolled |