Contacts

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; if no match then publish '04' Other.
		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 E1303	GENERATION-CODE GENERATION-CODE-SUFFIX	reg_contact.generation single-char code, don't left-zero-pad to 2 chars	N	only if value is defined; changed element to TX descriptor Oct 1 spec C012 vlaidation table REGTB_GENERATION, use state_code_equiv
	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; if no match then publish '52' Other
	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