This version of the Ed-Fi Dashboards is no longer supported. See the Ed-Fi Technology Version Index for a link to the latest version.

 

Options for Populating Daily Attendance in Ed-Fi Dashboards

Owned by Ian Christopher
Last updated: Nov 06, 2016
2 min read

Previous Version

This is a previous version of the Ed-Fi Dashboards. Visit the Ed-Fi Tech Docs home page for a link to the current version, or the Ed-Fi Technology Version Index for links to all versions. 

To support a wide variety of source data systems, there are two ways in which to display the daily attendance metrics on the Ed-Fi Dashboards UI.

The first option is to use section attendance data and the second option is to use daily attendance data. This document discusses the data approaches taken for each option. No configuration is required, the assumption is that attendance data will be submitted using one of the options but not both.

Option 1: Using Section Attendance

This option uses Section attendance data loaded into the edfi.StudentSectionAttendanceEvent table to display daily attendance. This requires the "Homeroom Indicator" flag to be set.

In the Student Enrollment interchange XSD, for example, the StudentSectionAssociation complex type has a field that designates whether that class/section is the homeroom period where daily attendance is taken.

  • If the class is designated as homeroom and a student receives an attendance event for that class, and no daily attendance is submitted, this attendance event is used to calculate the daily attendance metrics.
  • If you have section attendance and want to calculate the daily attendance metrics for your data, then the "Homeroom Indicator" must be set for a section that a student is associated with and have attendance data for.
  • There should be one class per day that is designated as the homeroom period. The sample below is from the StudentAttendance Interchange for StudentSectionAttendanceEvent.
	<StudentSectionAttendanceEvent>
		<AttendanceEvent>
			<EventDate>2010-11-09</EventDate>
			<AttendanceEventCategory>
				<CodeValue>Excused Absence</CodeValue>
			</AttendanceEventCategory>
			<AttendanceEventReason>Absent excused</AttendanceEventReason>
			<EducationalEnvironment>Classroom</EducationalEnvironment>
		</AttendanceEvent>
		<StudentReference>
			<StudentIdentity>
				<StudentUniqueId>604822</StudentUniqueId>
			</StudentIdentity>
			. . .
		</StudentReference>
		<SectionReference>
			<SectionIdentity>
				<LocationReference>
					<LocationIdentity>
						<ClassroomIdentificationCode>120</ClassroomIdentificationCode>
						<SchoolReference>
							<SchoolIdentity>
								<SchoolId>255901001</SchoolId>
							</SchoolIdentity>
							. . .
						</SchoolReference>
					</LocationIdentity>
				</LocationReference>
				<ClassPeriodReference>
					<ClassPeriodIdentity>
						<ClassPeriodName>01 - Traditional</ClassPeriodName>
						<SchoolReference>
							<SchoolIdentity>
								<SchoolId>255901001</SchoolId>
							</SchoolIdentity>
							. . .
						</SchoolReference>
					</ClassPeriodIdentity>
				</ClassPeriodReference>
				<CourseOfferingReference>
					<CourseOfferingIdentity>
						<LocalCourseCode>ENG-1</LocalCourseCode>
						<SessionReference>
							<SessionIdentity>
								<SchoolReference>
									<SchoolIdentity>
										<SchoolId>255901001</SchoolId>
									</SchoolIdentity>
									. . .
								</SchoolReference>
								<SchoolYear>2010-2011</SchoolYear>
								<Term>
									<CodeValue>Fall Semester</CodeValue>
								</Term>
							</SessionIdentity>
						</SessionReference>
						<SchoolReference>
							<SchoolIdentity>
								<SchoolId>255901001</SchoolId>
							</SchoolIdentity>
							. . .
						</SchoolReference>
					</CourseOfferingIdentity>
				</CourseOfferingReference>
				<UniqueSectionCode>25590100101Trad120ENG112011</UniqueSectionCode>
				<SequenceOfCourse>1</SequenceOfCourse>
			</SectionIdentity>
			. . .
		</SectionReference>
	</StudentSectionAttendanceEvent>

For the indicated StudentUniqueId, the SectionReference data, lines 16 through 69 above, of the StudentSectionAttendanceEvent relate to the SectionReference data, lines 8 through 61 below, of the StudentSectionAssociation.

The sample below is from the StudentEnrollment interchange that designates the “Homeroom Indicator” flag, line 64, for each section or class that identifies which period the daily attendance is taken. This flag allows the daily attendance metrics to be calculated from the section attendance.

<StudentSectionAssociation>
		<StudentReference>
			<StudentIdentity>
				<StudentUniqueId>604822</StudentUniqueId>
			</StudentIdentity>
			. . .
		</StudentReference>
		<SectionReference>
			<SectionIdentity>
				<LocationReference>
					<LocationIdentity>
						<ClassroomIdentificationCode>120</ClassroomIdentificationCode>
						<SchoolReference>
							<SchoolIdentity>
								<SchoolId>255901001</SchoolId>
							</SchoolIdentity>
							. . .
						</SchoolReference>
					</LocationIdentity>
				</LocationReference>
				<ClassPeriodReference>
					<ClassPeriodIdentity>
						<ClassPeriodName>01 - Traditional</ClassPeriodName>
						<SchoolReference>
							<SchoolIdentity>
								<SchoolId>255901001</SchoolId>
							</SchoolIdentity>
							. . .
						</SchoolReference>
					</ClassPeriodIdentity>
				</ClassPeriodReference>
				<CourseOfferingReference>
					<CourseOfferingIdentity>
						<LocalCourseCode>ENG-1</LocalCourseCode>
						<SessionReference>
							<SessionIdentity>
								<SchoolReference>
									<SchoolIdentity>
										<SchoolId>255901001</SchoolId>
									</SchoolIdentity>
									. . .
								</SchoolReference>
								<SchoolYear>2010-2011</SchoolYear>
								<Term>
									<CodeValue>Fall Semester</CodeValue>
								</Term>
							</SessionIdentity>
							. . .
						</SessionReference>
						<SchoolReference>
							<SchoolIdentity>
								<SchoolId>255901001</SchoolId>
							</SchoolIdentity>
						</SchoolReference>
					</CourseOfferingIdentity>
				</CourseOfferingReference>
				<UniqueSectionCode>25590100101Trad120ENG112011</UniqueSectionCode>
				<SequenceOfCourse>1</SequenceOfCourse>
			</SectionIdentity>
			. . .
		</SectionReference>
		<BeginDate>2010-08-23</BeginDate>
		<EndDate>2010-12-17</EndDate>
		<HomeroomIndicator>true</HomeroomIndicator>
	</StudentSectionAssociation>

Option 2: Using Daily Attendance Data

In Option 2, the daily attendance data loaded into the edfi.StudentSchoolAttendanceEvent table is used to display daily attendance.

The sample below is from the Student Attendance interchange, which allows the population of the edfi.StudentSchoolAttendanceEvent table for the calculation of daily attendance metrics when there is no Homeroom indicator designated in the Student Section Association of the Student Enrollment interchange.

This complex type does not have a Section Reference, but instead has the School Reference and the Session Reference which are key to loading daily attendance in this option.

	<StudentSchoolAttendanceEvent>
		<AttendanceEvent>
			<EventDate>2010-11-09</EventDate>
			<AttendanceEventCategory>
				<CodeValue>Excused Absence</CodeValue>
			</AttendanceEventCategory>
			<AttendanceEventReason>Absent excused</AttendanceEventReason>
			<EducationalEnvironment>Classroom</EducationalEnvironment>
		</AttendanceEvent>
		<StudentReference>
			<StudentIdentity>
				<StudentUniqueId>604822</StudentUniqueId>
			</StudentIdentity>
			. . .
		</StudentReference>
		<SchoolReference>
			<SchoolIdentity>
				<SchoolId>255901001</SchoolId>
			</SchoolIdentity>
			. . .
		</SchoolReference>
		<SessionReference>
			<SessionIdentity>
				<SchoolReference>
					<SchoolIdentity>
						<SchoolId>255901001</SchoolId>
					</SchoolIdentity>
					. . .
				</SchoolReference>
				<SchoolYear>2010-2011</SchoolYear>
				<Term>
					<CodeValue>Fall Semester</CodeValue>
				</Term>
			</SessionIdentity>
		</SessionReference>
	</StudentSchoolAttendanceEvent>