Classic View: System Administration > Ed-Fi
Search Terms: 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 StudentAcademicRecord instance for each school year in which the student has a transcript record and they have a Student School Association record for the scoped year.
|
| 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 1 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
|
| 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.
|
| 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 |
| Grade Levels to Send | Grade Levels |
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 | Database Field |
|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | |||
| termDescriptor | The term for the session during the school year. |
| M | ||
| education Organization Reference | A reference to the related EducationOrganization resource. | Reports the District Number. | M | ||
| schoolYearType Reference | A reference to the related SchoolYearType resource. |
| 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. |
| 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 his or her 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 |
| cumulativeEarned CreditTypeDescriptor | The type of credits or units of value awarded for the completion of a course. | This is optional, does not report. | O | ||
| cumulativeGrade PointAverage | 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 | ||
| cumulativeGrade PointsEarned | 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. | Reports when a student is given a Diploma Date and Diploma Type on their Graduation Record.
| 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 transcriptcredit table |
| sessionAttempted CreditTypeDescriptor | Key for Credit. | This is optional, does not report. | O | ||
| sessionEarned CreditConversion | Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. | This is optional, does not report. | O | ||
| sessionEarned Credits | 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 |
| sessionEarned CreditType Descriptor | Key for Credit. | This is optional, does not report. | O | ||
| sessionGrade PointsEarned | The number of grade points an individual earned for this session. | This is optional, does not report. | O | ||
| sessionGrade PointAverage | 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 |
