This educational entity represents the cumulative record of academic achievement for a student.
The Sessions, Course Offerings, and Sections resources all need to be present for the Student Academic Records resource to process and send.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | Report a Student Academic Record instance for each school year in which the student has a transcript record and they have a Student School Association record for the configured year. OR When a grade is posted to a grading task that is marked as State Reported and the student is in grades K-8. OR When a student's enrollment has a Local Start Status mapped to the State Start Status of '999: Past School Year Graduate' AND Exclude from State Reporting is checked on their enrollment. When Term Type cannot be determined on a Transcript record, provide an error with the following message, "Could not identify valid term type for transcript record". Do not send a record if the transcript's score is blank. |
| Post/Put | When a student is given a Diploma Date and Diploma Type.
|
| Delete | If records are posted from course transcript records and no Diploma information exits, all Student Academic Records will only delete when a student has only one Student School Association record for a specific year and all Student School Association records are deleted. |
| Delete | If a Graduation record is deleted and the student does not have any transcript records that would create a Student Academic Record. |
| Delete | If the Diploma Date is changed to no longer occur in the configured year and the student does not have any transcript records that would create a Student Academic Record. |
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
|
| 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.
|
| Data will only send for years that have a valid configuration. |
Identity Mapping Object Key
| campusObjectType | Object Key Data Source |
|---|---|
| TranscriptCourse | transcriptID |
| Graduation | graduationID |
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. |
Object Data Elements
This table describes data elements sent within the Student Academic Records resource. Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.
| Data Element Label | Business Requirement | Business Rules | M, C or O | Location |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| termDescriptor | The term for the session during the school year. |
When reporting for students that graduated prior to the start of the current school year, but after the end of the previous school year:
When reporting for students in Grades K-8 from a State Reported Grading Task or Standard:
| M | |
| educationOrganization Reference | A reference to the related Education Organization resource. | Reports the District Number based on the Local Education Agency resource logic:
| M | |
| schoolYearType Reference | A reference to the related SchoolYearType resource. | Reports the end year in format YYYY
| 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 their enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled. |
| O | Student Information> General > Transcripts Calculated value from the attempted credit field in the transcriptcredit table |
| cumulativeAttempted CreditTypeDescriptor | 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 | |
| cumulativeEarned Credits | The cumulative number of credits an individual earns by completing courses or examinations during their enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled. |
| O | Student Information> General> Transcripts Calculated value from the earned credit field in the transcriptcredit table |
| 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 their 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 their current school as well as those transferred from schools in which the individual was previously enrolled. |
| O | Student Information > General > Credit Summary CumGPA. cumGPA |
| cumulativeGradePoints Earned | The cumulative number of grade points an individual earns by successfully completing courses or examinations during their 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. | Reports when a student is given a Diploma Date and Diploma Type on their Graduation Record
When reporting for students that graduated prior to the start of the current school year, but after the end of the previous school year:
| 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 | |
| sessionAttempted CreditConversion | Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. | This is optional, does not report. | O | |
| sessionAttempted Credits | The number of an credits an individual attempted to earn in this session. |
| O | Student Information> General > Transcripts Calculated value from the attempted credit field in the transcript credit table |
| 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. |
| O | Student Information> General> Transcripts Calculated value from the earned credit field in the transcriptcredit table |
| sessionEarnedCredit TypeDescriptor | Key for Credit. | This is optional, does not report. | O | |
| sessionGradePoints Earned | The number of grade points an individual earned for this session. | This is optional, does not report. | O | |
| sessionGradePoint Average | 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 | |
| diplomaType | Reports the type of diploma. |
| C | |
| diplomaLevelType | Reports the diploma level. | Report value from Graduation > Diploma Type
| C | |
| diplomaAwardDate | The date the diploma was awarded. | Report value from Graduation > Diploma Date | C | |
| recognitionType | Reports skill from the diploma. |
| C | |
| achievementCategoryDescriptor | Reports the achievement. | 1. If recognitionType = Employability Skills, report the value selected in the drop list for Employability Skills. 2. If recognitionType = Post-Secondary Competencies, report the value selected in the drop list for Post-Secondary Competencies 3. Type / Descriptor list below has an added column for achievementCategoryDescriptor to reflect which recognitionType the descriptor will report in. | C | |
| achievementCategorySystem | Reports only if achievementCategoryDescriptor is populated with 'Locally Defined Pathway' | If achievementCategoryDescriptor = 09: Locally Created Pathway (recognitionType = Post-Secondary Competencies - achievementCategoryDescriptor = Locally Created Pathway)
| C | |
| etag | A unique system-generated value that identifies the version of the resource. | This is optional, does not report. | O |
Arrays
Type/Descriptor
