Arizona Ed-Fi Data v3.5 - Student Academic Records

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	When transcript records are posted for a student for course with a state code and in grades 9-12. OR When a grade is posted to a grading task that is marked as State Reported and the student is in grades K-8. Only report transcript records that have a district id = to the district where the student is enrolled. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!. Do not report if posted from a course in an excluded calendar. If transcript is manually entered, only report if student has an enrollment in a calendar not marked as excluded. Do not report if the Course is marked as inactive or State Excluded. Do not send records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in. Student Academic Records will only delete when a student has only 1 Student School Association record for a specific School and Year and all Student School Association records are deleted. Do not send a record if the transcript's score is null.
Delete	Student Academic Records will only delete when a student has only 1 Student School Association record for a specific School and Year and all Student School Association records are deleted.
Delete	When the State Exclude box is checked. (Note: If the box is unchecked, the data will not post, a resync must be completed to resend the data.)

Action

Trigger

Post

When transcript records are posted for a student for course with a state code and in grades 9-12.

When a grade is posted to a grading task that is marked as State Reported and the student is in grades K-8.

Only report transcript records that have a district id = to the district where the student is enrolled.
Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
Do not report if posted from a course in an excluded calendar. If transcript is manually entered, only report if student has an enrollment in a calendar not marked as excluded.
Do not report if the Course is marked as inactive or State Excluded.
Do not send records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
Student Academic Records will only delete when a student has only 1 Student School Association record for a specific School and Year and all Student School Association records are deleted.
Do not send a record if the transcript's score is null.

Delete

Student Academic Records will only delete when a student has only 1 Student School Association record for a specific School and Year and all Student School Association records are deleted.

Delete

When the State Exclude box is checked.

(Note: If the box is unchecked, the data will not post, a resync must be completed to resend the data.)

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

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.	Report the Ed-Fi code for the value selected in "Ed-Fi Transcript Term Override" field on the transcript. If NULL, Report the Term Descriptor based on the Course Term Type Override, else Section Term Type Override. When the Ed-Fi Transcript Term Override and both the Course Term and the Section Term Override fields are Null, report the Term Descriptor for the term aligned to the Grading Score for the posted Grade Else, report the Ed-Fi Code from the Ed-Fi Transcript Term Descriptor Override in the SAR preferences. If an Term cannot be determined, provide error. When the SAR is posted only from the Graduation Record because there are no Course Transcripts records for the student, report the Ed-Fi Term Descriptor from the Sessions Resource Preferences that the Diploma Date falls in. If the Diploma Date is outside of any of the Term Dates for that School Year, report the Ed-Fi Term Descriptor from the Term with the latest End Date. If the Diploma Date is aligned to more than 1 Term Descriptor, report the value from the highest TermId.	M	Student Information > General > Transcript	transcriptDetail.edfiTerm Override
education Organization Reference	The identifier assigned to an education organization.	Reports the Entity ID for the School Number on the transcript record being reported.	M	System Administration > Resources > School > Entity ID
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. Note: The Ed-Fi ID reports from the Student State ID field.	M
academicHonors	An unordered collection of student Academic Record Academic Honors. 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 Credit Conversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This is optional, does not report.	O
cumulative Attempted 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
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.	This is optional, does not report.	O
cumulativeEarned CreditType Descriptor	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.	This is optional, does not report.	O
gradeValue Qualifier	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 Credit Conversion	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.	This is optional, does not report.	O
sessionAttempted CreditType Descriptor	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.	This is optional, does not report.	O
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

Arrays

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.	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.	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 the student associated.	M	Student Information> General> Graduation	graduation.diplomaType
diplomaLevelDescriptor	The type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements. Minimum high school program Recommended high school program Distinguished Achievement Program.	This is optional, does not report.	O
achievementCategorySystem	The system that defines the categories by which an achievement is attributed to the learner.	This is optional, does not report.	O
achievementTitle	The title assigned to the achievement.	This is optional, does not report.	O
criteria	The criteria for competency-based completion of the achievement/award.	This is optional, does not report.	O
criteriaURL	The Uniform Resource Locator (URL) for the unique address of a web page describing the competency-based completion criteria for the achievement/award.	This is optional, does not report.	O
cteCompleter	Indicated a student who reached a state-defined threshold of vocational education and who attained a high school diploma or its recognized state equivalent or GED.	This is optional, does not report.	O
diplomaAwardExpiresDate	Date on which the award expires.	This is optional, does not report.	O
diplomaDescription	The description of diploma given to the student for accomplishments.	This is optional, does not report.	O
evidenceStatement	A statement or reference describing the evidence that the learner met the criteria for attainment of the achievement.	This is optional, does not report.	O
imageURL	The Uniform Resource Locator (URL) for the unique address of an image representing an award or badge associated with the achievement.	This is optional, does not report.	O
issuerName	The name of the agent issuing the award.	This is optional, does not report.	O
issuerOriginURL	The Uniform Resource Locator (URL) from which the award was issued.	This is optional, does not report.	O

Type/Descriptor

Diploma Type Descriptor

Code Value	Description	Namespace	Short Description
Endorsed/advanced diploma	Endorsed/advanced diploma	uri://ed-fi.org/DiplomaTypeDescriptor	Endorsed/advanced diploma
Industry-recognized Certification	Industry-recognized Certification	uri://ed-fi.org/DiplomaTypeDescriptor	Industry-recognized Certification
High school equivalency credential, other than GED	High school equivalency credential, other than GED	uri://ed-fi.org/DiplomaTypeDescriptor	High school equivalency credential, other than GED
Career and Technical Education certificate	Career and Technical Education certificate	uri://ed-fi.org/DiplomaTypeDescriptor	Career and Technical Education certificate
Certificate of attendance	Certificate of attendance	uri://ed-fi.org/DiplomaTypeDescriptor	Certificate of attendance
Regular diploma	Regular diploma	uri://ed-fi.org/DiplomaTypeDescriptor	Regular diploma
International Baccalaureate	International Baccalaureate	uri://ed-fi.org/DiplomaTypeDescriptor	International Baccalaureate
Post graduate certificate (grade 13)	Post graduate certificate (grade 13)	uri://ed-fi.org/DiplomaTypeDescriptor	Post graduate certificate (grade 13)
General Educational Development (GED) credential	General Educational Development (GED) credential	uri://ed-fi.org/DiplomaTypeDescriptor	General Educational Development (GED) credential
Certificate of completion	Certificate of completion	uri://ed-fi.org/DiplomaTypeDescriptor	Certificate of completion
Other diploma	Other diploma	uri://ed-fi.org/DiplomaTypeDescriptor	Other diploma
Regents diploma	Regents diploma	uri://ed-fi.org/DiplomaTypeDescriptor	Regents diploma
Modified diploma	Modified diploma	uri://ed-fi.org/DiplomaTypeDescriptor	Modified diploma
Apprenticeship Certificate	Apprenticeship Certificate	uri://ed-fi.org/DiplomaTypeDescriptor	Apprenticeship Certificate
Other	Other	uri://ed-fi.org/DiplomaTypeDescriptor	Other
Alternative credential	Alternative credential	uri://ed-fi.org/DiplomaTypeDescriptor	Alternative credential
Occupational License	Occupational License	uri://ed-fi.org/DiplomaTypeDescriptor	Occupational License

Achievement Category Descriptors

Code Value	Description	Namespace	Short Description
Academic Honor	Academic Honor	uri://ed-fi.org/AchievementCategoryDescriptor	Academic Honor
Certificate Earned	Certificate Earned	uri://ed-fi.org/AchievementCategoryDescriptor	Certificate Earned
Competency Mastered	Competency Mastered	uri://ed-fi.org/AchievementCategoryDescriptor	Competency Mastered
Competency Retained	Competency Retained	uri://ed-fi.org/AchievementCategoryDescriptor	Competency Retained
Course Completed	Course Completed	uri://ed-fi.org/AchievementCategoryDescriptor	Course Completed
Diploma Earned	Diploma Earned	uri://ed-fi.org/AchievementCategoryDescriptor	Diploma Earned
Level Completed	Level Completed	uri://ed-fi.org/AchievementCategoryDescriptor	Level Completed
License Earned	License Earned	uri://ed-fi.org/AchievementCategoryDescriptor	License Earned
Non-Academic Honor	Non-Academic Honor	uri://ed-fi.org/AchievementCategoryDescriptor	Non-Academic Honor
License Endorsement Earned	License Endorsement Earned	uri://ed-fi.org/AchievementCategoryDescriptor	License Endorsement Earned
Participation	Participation	uri://ed-fi.org/AchievementCategoryDescriptor	Participation
Recognition	Recognition	uri://ed-fi.org/AchievementCategoryDescriptor	Recognition