Wisconsin Ed-Fi Data v3.3 - Student Academic Records

Tool Search: Ed-Fi

This educational entity represents the cumulative record of academic achievement for a student.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	Report a Student Academic Record for students in grade levels 9-12 who have a Student School Association record for the scope year without diploma array if Diploma Date is not populated (Public only). If a student has multiple studentSchoolAssociations, report a SAR for each if they are in different schools. For 12th grade students, report a SAR record with diploma array when Diploma Date and Diploma Type are populated for the scope year. When a student graduates and has diploma information entered, a new studentAcademicRecord posts with the diploma information in addition to the other studentAcademicRecords that are reported based on enrollments.
Post	Report only for an enrollment with WI State Enrollment Type = Primary. If the student has more than 1 enrollment look for the following to determine which enrollment the record should be associated: If the Diploma Date overlaps the enrollment start and end dates report from that enrollment. If the Enrollment end date is NULL, use the end of the school year as the default date (6/30). If the Diploma Dates does not overlap the enrollment(s) look for an enrollment in the same school year as the diploma date. Report based on that enrollment. If there is no enrollment in that year, do NOT send a record. If more than 1 enrollment qualifies, report from enrollment service type in the following order: Primary, Special Ed. Summer school graduates report diploma information if graduation date is after 6/30 but before the start of the next school year when Diploma Period = 'Summer'. If enrollment service types are the same, report: first from an Enrollment with the end status = HSC then from the most recent end date finally by highest enrollment ID If Ed-Fi Configuration Profile = Choice + Opt in report a record for all eligible students if Choice = Yes or No on the student's enrollment. - Only send a record when student is given a Diploma Date and Diploma Type in the config year. If Ed-Fi Configuration Profile = Choice AND Choice = No on Student enrollment, do not report a record. If Ed-Fi Configuration Profile = Choice AND Choice is changed from No to Yes on Student enrollment and saved, post a new record when student has a Diploma Date and Diploma Type in the config year . Do not send a record driven from any enrollment with WISE Exclude, State Exclude, or No Show checked marked. Do not send a record if enrollment is in a calendar marked as State Exclude, Summer School, or in a School marked Exclude.
Delete	When the State Exclude, WISE Exclude, or No Show check boxes are checked.

Action

Trigger

Post

Report a Student Academic Record for students in grade levels 9-12 who have a Student School Association record for the scope year without diploma array if Diploma Date is not populated (Public only).

If a student has multiple studentSchoolAssociations, report a SAR for each if they are in different schools.
For 12th grade students, report a SAR record with diploma array when Diploma Date and Diploma Type are populated for the scope year.
When a student graduates and has diploma information entered, a new studentAcademicRecord posts with the diploma information in addition to the other studentAcademicRecords that are reported based on enrollments.

Post

Report only for an enrollment with WI State Enrollment Type = Primary.

If the student has more than 1 enrollment look for the following to determine which enrollment the record should be associated:
1. If the Diploma Date overlaps the enrollment start and end dates report from that enrollment.
  1. If the Enrollment end date is NULL, use the end of the school year as the default date (6/30).
2. If the Diploma Dates does not overlap the enrollment(s) look for an enrollment in the same school year as the diploma date. Report based on that enrollment.
  1. If there is no enrollment in that year, do NOT send a record.
3. If more than 1 enrollment qualifies, report from enrollment service type in the following order: Primary, Special Ed.
4. Summer school graduates report diploma information if graduation date is after 6/30 but before the start of the next school year when Diploma Period = 'Summer'.
5. If enrollment service types are the same, report:
  1. first from an Enrollment with the end status = HSC
  2. then from the most recent end date
  3. finally by highest enrollment ID
If Ed-Fi Configuration Profile = Choice + Opt in report a record for all eligible students if Choice = Yes or No on the student's enrollment. - Only send a record when student is given a Diploma Date and Diploma Type in the config year.
If Ed-Fi Configuration Profile = Choice AND Choice = No on Student enrollment, do not report a record.
If Ed-Fi Configuration Profile = Choice AND Choice is changed from No to Yes on Student enrollment and saved, post a new record when student has a Diploma Date and Diploma Type in the config year .
Do not send a record driven from any enrollment with WISE Exclude, State Exclude, or No Show checked marked.
Do not send a record if enrollment is in a calendar marked as State Exclude, Summer School, or in a School marked Exclude.

Delete

When the State Exclude, WISE Exclude, or No Show check boxes are checked.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Delete	If a resource is toggled to 'OFF" after data has sent and an action is performed that would trigger a delete, that data will remain in the ODS until a resync is done.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync	If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Trigger
Delete/Post	If any part of the Natural Key Changes If the District Number changes all data will remain under the old number. The delete tool would need to be used to remove all old data.
Delete/Post	If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
Delete/Post	If the End Year the transcript record or diploma record is aligned to changes.
Delete/Post	If the Term Descriptor is changed.
Delete/Post	If the natural key changes all dependent resources will delete/post.
Dependent Resources	Course Transcripts

Scope Year Logic

This table describes scope year logic of this object.

Logic
Records will send to each scope year in which the Course Transcript record is posted.
Records will only post to the SAR records for the year the diploma date occurs in but SAR records will post to all scoped years. The Diploma Date must be on or after the school year's start date and on or before the school year's end date defined in the School Years editor. If blank, the default start date of 7/1/xxxx and end date of 6/30/xxxx are used.
Data will only send for years that have a valid configuration.

Logic

Records will send to each scope year in which the Course Transcript record is posted.

Records will only post to the SAR records for the year the diploma date occurs in but SAR records will post to all scoped years.

The Diploma Date must be on or after the school year's start date and on or before the school year's end date defined in the School Years editor. If blank, the default start date of 7/1/xxxx and end date of 6/30/xxxx are used.

Data will only send for years that have a valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Ed-Fi Transcript Term Override	Term Descriptor for Course Transcripts
Graduation Diploma Type	Diploma Type Descriptors
Graduation Diploma Type	Achievement Category Descriptors

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
transcriptcourse	Post/Put/Delete	The primary table used for sending data for this resource.
graduation	Post/Put/Delete	The primary table used for sending data for this resource.
transcriptcredit	Put	cumulativeAttemptedCredits, cumulativeEarnedCredits, sessionAttemptedCredits, sessionEarnedCredits

Object Data Elements

This table describes data elements sent within the Student Academic Records resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path
id	The unique identifier of the resource.		M
termDescriptor	The term for the session during the school year.	termDescriptor of SAR with graduation/diploma information will report as 'A' for Annual. termDescriptor for non-graduate SARs will send a value of 'S1'.	M
educationOrganization Reference	A reference to the related EducationOrganization resource.	If the School Override is set on the associated enrollment, report the school ID from the Override. Report the School ID for the school the student is enrolled in for the config year. If the student has more than 1 enrollment in more than 1 school, report the school from the primary enrollment. If enrollment types are the same, report from most recent end date. When Diploma Date and Diploma Type fields are populated: Report the School ID that the student graduated from. First determine the associated enrollment. If the Diploma Date falls within a student's enrollment report from that enrollment. If the Diploma Date falls outside of a student's enrollment, report the school from the most recent enrollment. If the student has more than 1 enrollment in more than 1 school report the school from the primary enrollment. If enrollment types are the same, report from most recent end date. Otherwise, report the school ID for the enrollment school.	M	System Administration > Resources > School > School Editor > School Detail > Ed-Fi School Number
schoolYearType Reference	A reference to the related SchoolYearType resource.	Reports the end year for the transcript record being reported Reports the end year the Diploma Date is aligned to	M
studentReference	A reference to the related Student resource.	Reports the fields that are part of the Natural Key for the Student resource.	M
academicHonors	An unordered collection of studentAcademicRecordAcademicHonors. This educational entity represents the cumulative record of academic achievement for a student.	This is optional, does not report.	O
classRanking	This educational entity represents the cumulative record of academic achievement for a student.	This is optional, does not report.	O
cumulativeEarned CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This is optional, does not report.	O
cumulativeAttempted Credits	The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled.	This is optional, does not report.	O
cumulativeAttemptedCredit TypeDescriptor	The type of credits or units of value awarded for the completion of a course.	This is optional, does not report.	O
cumulativeAttempted CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This is optional, does not report.	O
cumulativeEarnedCredits	The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled.	This is optional, does not report.	O
cumulativeEarnedCredit TypeDescriptor	The type of credits or units of value awarded for the completion of a course.	This is optional, does not report.	O
cumulativeGradePoint Average	A measure of average performance in all courses taken by an individual during his or her school career as determined for record-keeping purposes. This is obtained by dividing the total grade points received by the total number of credits attempted. This usually includes grade points received and credits attempted in his or her current school as well as those transferred from schools in which the individual was previously enrolled.	This is optional, does not report.	O
cumulativeGradePoints Earned	The cumulative number of grade points an individual earns by successfully completing courses or examinations during his or her enrollment in the current school as well as those transferred from schools in which the individual had been previously enrolled.	This is optional, does not report.	O
diplomas	An unordered collection of studentAcademicRecordDiplomas. This educational entity represents the cumulative record of academic achievement for a student.	See Array data below for requirements.	O
gradeValueQualifier	The scale of equivalents, if applicable, for grades awarded as indicators of performance in schoolwork. For example, numerical equivalents for letter grades used in determining a student's Grade Point Average (A=4, B=3, C=2, D=1 in a four-point system) or letter equivalents for percentage grades (90-100%=A, 80-90%=B, etc.).	This is optional, does not report.	O
projectedGraduation Date	The month and year the student is projected to graduate.	This is optional, does not report.	O
recognitions	An unordered collection of studentAcademicRecordRecognitions. This educational entity represents the cumulative record of academic achievement for a student.	This is optional, does not report.	O
reportCards	An unordered collection of studentAcademicRecordReportCards. This educational entity represents the cumulative record of academic achievement for a student.	This is optional, does not report.	O
sessionAttemptedCredit Conversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This is optional, does not report.	O
sessionAttemptedCredits	The number of an credits an individual attempted to earn in this session.	This is optional, does not report.	O
sessionAttemptedCredit TypeDescriptor	Key for Credit.	This is optional, does not report.	O
sessionEarnedCredit Conversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This is optional, does not report.	O
sessionEarnedCredits	The number of an credits an individual earned in this session.	This is optional, does not report.	O
sessionEarnedCredit TypeDescriptor	Key for Credit.	This is optional, does not report.	O
sessionGradePointsEarned	The number of grade points an individual earned for this session.	This is optional, does not report.	O
sessionGradePointAverage	The grade point average for an individual computed as the grade points earned during the session divided by the number of credits attempted.	This is optional, does not report.	O
etag	A unique system-generated value that identifies the version of the resource.	This is optional, does not report.	O

Arrays

Click here to expand...

Diplomas

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
DiplomaTypeDescriptor	The type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements.	Report the Ed-Fi Code for the Diploma Type selected. If null, do not report.	M	Student Information> General> Graduation	graduation.diplomaType
diplomaAwardDate	The month, day, and year on which the student met graduation requirements and was awarded a diploma.	Report the Diploma Date. If null, do not report.	M	Student Information> General> Graduation	graduation.diplomaDate
achievementCategoryDescriptor	This descriptor defines the category of achievement attributed to the learner.	Report the Ed-Fi Code from the mapping for this field based on the Diploma Type in which the student is associated. If null, do not report.	M	Student Information> General> Graduation> Diploma Type	graduation.diplomaType