Tool Search: Ed-Fi

The Sessions, Course Offerings, and Sections resources must be present for the Student Academic Records resource to process and send.

Object Triggering Logic

Action	Trigger
POST	Report a record for each unique Ed-Fi termDescriptor in the current configuration year in which the student has a transcript record OR When the student has a Diploma Type and Diploma Date in the current configuration year. Do not report a record if any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude Transcript's Score is NULL The transcript can be posted manually or through the Transcript Post tool. When the Ed-Fi termDescriptor cannot be determined on a Transcript record, provide an error with the following message: "Could not identify a valid term type for transcript record." If a student has an enrollment with a Local Start Status mapped to the State Start Status of 999: Past Year School Graduate AND that enrollment is marked as State Exclude, perform a POST regardless of if the Diploma Date is within the configured year.
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following transcript-related information is updated: Transcript ID (New Transcript Entry) Score Ed-Fi Term Override End Year GPA Value GPA Weight School Number Unweighted GPA Value Credits Attempted Credits Earned When the following enrollment-related information is updated: End Status Start Date End Date Grade No Show State Exclude When the following graduation-related information is updated: Diploma Date Diploma Period Diploma Type Employability Skills Local Pathway Postsecondary-Ready Competencies Graduating School
DELETE	When all transcript records related to the termDescriptor being reported are deleted. When the diploma date/diploma type is removed, and the student has no transcript records associated with the termDescriptor being reported. When all of the reportable enrollments for the student are deleted.

Action

Trigger

POST

Report a record for each unique Ed-Fi termDescriptor in the current configuration year in which the student has a transcript record OR When the student has a Diploma Type and Diploma Date in the current configuration year.

Do not report a record if any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
- Transcript's Score is NULL
The transcript can be posted manually or through the Transcript Post tool.
When the Ed-Fi termDescriptor cannot be determined on a Transcript record, provide an error with the following message: "Could not identify a valid term type for transcript record."
If a student has an enrollment with a Local Start Status mapped to the State Start Status of 999: Past Year School Graduate AND that enrollment is marked as State Exclude, perform a POST regardless of if the Diploma Date is within the configured year.

DELETE /
POST
PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following transcript-related information is updated:
- Transcript ID (New Transcript Entry)
- Score
- Ed-Fi Term Override
- End Year
- GPA Value
- GPA Weight
- School Number
- Unweighted GPA Value
- Credits Attempted
- Credits Earned
When the following enrollment-related information is updated:
- End Status
- Start Date
- End Date
- Grade
- No Show
- State Exclude
When the following graduation-related information is updated:
- Diploma Date
- Diploma Period
- Diploma Type
- Employability Skills
- Local Pathway
- Postsecondary-Ready Competencies
- Graduating School

DELETE

When all transcript records related to the termDescriptor being reported are deleted.
When the diploma date/diploma type is removed, and the student has no transcript records associated with the termDescriptor being reported.
When all of the reportable enrollments for the student are deleted.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Click here to expand...

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
termDescriptor	When reporting Transcript records posted using the Transcript Post tool (have an associated scoreID): Report the Ed-Fi Code mapped to the value selected for Ed-Fi Term Type on the transcript entry. If Transcript Ed-Fi Term Type is NULL, report the Ed-Fi Code mapped to the value selected for the Section Ed-Fi Term Descriptor Override (Sessions Resource Preferences override mapping). If Section Ed-Fi Term Descriptor Override is NULL, report the Ed-Fi Code mapped to the value selected for the Course Ed-Fi Term Descriptor Override (Sessions Resource Preferences override mapping). If the Course Ed-Fi Term Descriptor Override is NULL, report the Ed-Fi Code mapped to the Term the course is being offered in (Sessions Resource Preferences main mapping). If the Ed-Fi Code cannot be determined for the Term, report the Ed-Fi Code mapped to the Ed-Fi Transcript Term Override (Student Academic Records Resource Preferences). If no Ed-Fi Code can be determined, provide the error: "Could not identify a valid term type for transcript record." When reporting Transcript records that are manually added (no scoreID): Report the Ed-Fi Code mapped to the value selected for Ed-Fi Term Type on the transcript record. If the transcript Ed-Fi Term Type is NULL, report the Ed-Fi Code mapped to the Ed-Fi Transcript Term Override (Student Academic Records Resource Preferences). If no Ed-Fi Code can be determined, provide the error: "Could not identify a valid term type for transcript record." When reporting from a Graduation Record because there are no Course Transcript records for the student: Report the Ed-Fi Code mapped to the term in Sessions Resource Preferences that the Diploma Date overlaps. If the Diploma Date does not overlap a term, or the term does not have an Ed-Fi Code mapped, use the Ed-Fi Code mapped to the term with the latest end date. If there is more than one term schedule, reports from the Primary term schedule. If the Diploma Date overlaps more than one term, report the value from the term with the highest termID. When reporting for students whose enrollment has a Local Start Status that is mapped to a State Start Status of 999: Past School Year Graduate: Report the Ed-Fi Code mapped to the earliest term in the school/calendar the student's enrollment is associated with.	M	N/A
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
schoolYearType Reference	Reports the End Year of the associated School Year selected.	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
cumulativeAttempted Credits	Reports the total number of Credits Attempted for all time. Reports 0 if the student does not have any Credits Attempted. Does not report if the Student Academic Record is reporting only from Graduation information.	O	Student Information > General > Transcripts TranscriptCredit.creditsAttempted
cumulativeEarned Credits	Reports the total number of Credits Earned for all time. Reports 0 if the student does not have any Credits Earned. Does not report if the Student Academic Record is reporting only from Graduation information.	O	Student Information > General > Transcripts TranscriptCredit.creditsEarned
cumulativeGradePoint Average	Reports the Cumulative GPA. This will be the same value on all eligible Student Academic Record records that are eligible to report for the student regardless of the year it is reporting for. Does not report if the Student Academic Record is reporting only from Graduation information.	O	Student Information > General > Credit Summary v_CumGPA.cumGPA
diplomas	Reports the below data element in an array when the student has a Diploma Date and a Diploma Type on their Graduation record: diplomaTypeDescriptor Reports Certificate of completion if Diploma Type is set to 06: Certificate of Completion (IEP program Completed). Reports Certificate of attendance if Diploma Type is set to 07: Course Completion. Reports Alternate Diploma if Diploma Type is set to 23: Alternate Diploma. Reports Regular Diploma if Diploma Type is set to any other code than 06, 07, or 23. diplomaAwardDate Reports Diploma Date. diplomaLevelDescriptor Reports the Ed-Fi Code mapped to the value selected for Diploma Type. Additional Logic: If the Graduating School field is populated, this array will only POST under that school. This is for situations where the student has enrollments in different schools and the "graduating school" needs to be specified. When reporting for students whose enrollment has a Local Start Status that is mapped to a State Start Status of 999: Past School Year Graduate: Always report the diplomas array, regardless of the Scope Year under which their Diploma Date falls.	C	Graduation > Diploma Type Graduation > Diploma Date Graduation.diplomaType Graduation.diplomaDate
recognitions	Reports the below data elements in an array when the student is given an Employability Skills or Postsecondary-Ready Competencies value mapped to an Ed-Fi Code. Reports a separate record in the array for each reportable instance: recognitionTypeDescriptor Reports Employability Skills (Hard-Coded) if reporting from the Employability Skills field. Reports Post-Secondary Competencies (Hard-Coded) if reporting from the Postsecondary-Ready Competencies field. achievementCategoryDescriptor Reports the Ed-Fi Code mapped to the value selected for Employability Skills or Postsecondary-Ready Competencies. achievementCategorySystem Reports the Local Pathway. This is only reported when reporting from Postsecondary-Ready Competencies when it has a value of 09: Locally Created Pathway. 10000 = Not Applicable; Locally Created Pathway not utilized. 10001 through 99999 = Approved Locally Created Pathway. The approved Locally Created Pathways can be found on the IDOE site.	C	Graduation > Employability Skills + Postsecondary-Ready Competencies + Local Pathway Graduation.employabilitySkills Graduation.postsecondaryReadyCompetencies Graduation.localPathway
sessionAttemptedCredits	Reports the total number of Credits Attempted for the session (term) reporting. Reports 0 if the student does not have any Credits Attempted. Does not report if the Student Academic Record is reporting only from Graduation information.	O	Student Information> General > Transcripts TranscriptCredit.creditsAttempted
sessionEarnedCredits	The number of credits an individual earned in this session.	O	Student Information> General> Transcripts TranscriptCredit.creditsEarned

Descriptors

Click here to expand...

Diploma Type Descriptor

Ed-Fi Code Value	Short Description	Description	Namespace
Certificate of attendance	Certificate of attendance	Certificate of attendance	uri://ed-fi.org/DiplomaTypeDescriptor
Certificate of completion	Certificate of completion	Certificate of completion	uri://ed-fi.org/DiplomaTypeDescriptor
Regular diploma	Regular diploma	Regular diploma	uri://ed-fi.org/DiplomaTypeDescriptor
Alternate Diploma	Alternate Diploma	Alternate Diploma	uri://doe.in.gov/DiplomaTypeDescriptor

Diploma Level Descriptor

Recognition Type Descriptors

Ed-Fi Code Value	Short Description	Description	Namespace
Employability Skills	Employability Skills	Employability Skills	uri://doe.in.gov/RecognitionTypeDescriptor
Post-Secondary Competencies	Post-Secondary Competencies	Post-Secondary Competencies	uri://doe.in.gov/RecognitionTypeDescriptor

Achievement Category Descriptors

recognitionTypeDescriptor	Ed-Fi Code Value	Short Description	Description	Namespace
Post-Secondary Competencies	ACT - College Ready benchmarks	ACT - College Ready benchmarks	ACT - College Ready benchmarks	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	AP/IB/DC/Cambridge Intl courses or CLEP Exam	AP/IB/Dual Credit/Cambridge International courses or CLEP Exam	AP/IB/Dual Credit/Cambridge International courses or CLEP Exam	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	ASVAB	ASVAB	ASVAB	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	Career-Technical Education Concentrator	Career-Technical Education Concentrator	Career-Technical Education Concentrator	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	Honors Diploma	Honors Diploma	Honors Diploma	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	Locally Created Pathway	Locally Created Pathway	Locally Created Pathway	uri://doe.in.gov/AchievementCategoryDescriptor
Both	NA or Did Not Demonstrate	NA or Did Not Demonstrate	NA or Did Not Demonstrate	uri://doe.in.gov/AchievementCategoryDescriptor
Employability Skills	Project-Based Learning Experience	Project-Based Learning Experience	Project-Based Learning Experience	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	SAT - College Ready benchmarks	SAT - College Ready benchmarks	SAT - College Ready benchmarks	uri://doe.in.gov/AchievementCategoryDescriptor
Employability Skills	Service-Based Learning Experience	Service-Based Learning Experience	Service-Based Learning Experience	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	State/Federal/Industry recognized Apprenticeship	State, Federal, or Industry recognized Apprenticeship	State, Federal, or Industry recognized Apprenticeship	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	State/Industry recognized Cred or Certification	State and Industry recognized Credential or Certification	State and Industry recognized Credential or Certification	uri://doe.in.gov/AchievementCategoryDescriptor
Post-Secondary Competencies	Waiver Postsecondary Readiness Competency Reqs	Waiver from Postsecondary Readiness Competency Requirements	Waiver from Postsecondary Readiness Competency Requirements	uri://doe.in.gov/AchievementCategoryDescriptor
Employability Skills	Work-Based Learning Experience	Work-Based Learning Experience	Work-Based Learning Experience	uri://doe.in.gov/AchievementCategoryDescriptor

Term Descriptors

Ed-Fi Code Value	Short Description	Description	Namespace
Fall Semester	Fall Semester	Fall Semester	uri://ed-fi.org/TermDescriptor
First Quarter	First Quarter	First Quarter	uri://ed-fi.org/TermDescriptor
First Trimester	First Trimester	First Trimester	uri://ed-fi.org/TermDescriptor
Fourth Quarter	Fourth Quarter	Fourth Quarter	uri://ed-fi.org/TermDescriptor
MiniTerm	MiniTerm	MiniTerm	uri://ed-fi.org/TermDescriptor
Other	Other	Other	uri://ed-fi.org/TermDescriptor
Second Quarter	Second Quarter	Second Quarter	uri://ed-fi.org/TermDescriptor
Second Trimester	Second Trimester	Second Trimester	uri://ed-fi.org/TermDescriptor
Spring Semester	Spring Semester	Spring Semester	uri://ed-fi.org/TermDescriptor
Summer Semester	Summer Semester	Summer Semester	uri://ed-fi.org/TermDescriptor
Third Quarter	Third Quarter	Third Quarter	uri://ed-fi.org/TermDescriptor
Third Trimester	Third Trimester	Third Trimester	uri://ed-fi.org/TermDescriptor
Year Round	Year Round	Year Round	uri://ed-fi.org/TermDescriptor
MiniTerm One	MiniTerm One	MiniTerm One	uri://doe.in.gov/TermDescriptor
MiniTerm Two	MiniTerm Two	MiniTerm Two	uri://doe.in.gov/TermDescriptor
MiniTerm Three	MiniTerm Three	MiniTerm Three	uri://doe.in.gov/TermDescriptor
MiniTerm Four	MiniTerm Four	MiniTerm Four	uri://doe.in.gov/TermDescriptor
MiniTerm Five	MiniTerm Five	MiniTerm Five	uri://doe.in.gov/TermDescriptor
MiniTerm Six	MiniTerm Six	MiniTerm Six	uri://doe.in.gov/TermDescriptor

Ed-Fi Code Value	Short Description	Description	Namespace
01	General (Passed GQE or met Graduation Pathway)	General (Passed GQE or met Graduation Pathway)	uri://doe.in.gov/DiplomaLevelDescriptor
02	Core 40 with Academic Honors (Passed GQE or met Graduation Pathway)	Core 40 with Academic Honors (Passed GQE or met Graduation Pathway)	uri://doe.in.gov/DiplomaLevelDescriptor
03	Core 40 only (Passed GQE or met Graduation Pathway)	Core 40 only (Passed GQE or met Graduation Pathway)	uri://doe.in.gov/DiplomaLevelDescriptor
04	General (Evidence-based waiver)	General (Evidence-based waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
06	Certificate of Completion (IEP program Completed)	Certificate of Completion (IEP program Completed)	uri://doe.in.gov/DiplomaLevelDescriptor
07	Course Completion	Course Completion	uri://doe.in.gov/DiplomaLevelDescriptor
09	Core 40 with Technical Honors (Passed GQE or met Graduation Pathway)	Core 40 with Technical Honors (Passed GQE or met Graduation Pathway)	uri://doe.in.gov/DiplomaLevelDescriptor
11	General (Work Readiness Waiver)	General (Work Readiness Waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
12	International Baccalaureate Diploma	International Baccalaureate Diploma	uri://doe.in.gov/DiplomaLevelDescriptor
13	Core 40 Only (Evidence-based waiver or Waiver from Postsecondary Readiness Competency Requirements for Graduation Pathways)	Core 40 Only (Evidence-based waiver or Waiver from Postsecondary Readiness Competency Requirements for Graduation Pathways)	uri://doe.in.gov/DiplomaLevelDescriptor
14	Core 40 with Academic Honors (Evidence-based waiver)	Core 40 with Academic Honors (Evidence-based waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
15	Core 40 with Technical Honors (Evidence-based waiver)	Core 40 with Technical Honors (Evidence-based waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
16	Core 40 with Academic and Technical Honors (Passed GQE or met Graduation Pathway)	Core 40 with Academic and Technical Honors (Passed GQE or met Graduation Pathway)	uri://doe.in.gov/DiplomaLevelDescriptor
18	Core 40 with Academic and Technical Honors (Evidence-based waiver)	Core 40 with Academic and Technical Honors (Evidence-based waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
19	Core 40 Only (Work-Readiness Waiver)	Core 40 Only (Work-Readiness Waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
20	Core 40 with Academic Honors (Work-Readiness Waiver)	Core 40 with Academic Honors (Work-Readiness Waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
21	Core 40 with Technical Honors (Work-Readiness Waiver)	Core 40 with Technical Honors (Work-Readiness Waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
22	Core 40 with Academic & Technical Honors (Work-Readiness Waiver)	Core 40 with Academic & Technical Honors (Work-Readiness Waiver)	uri://doe.in.gov/DiplomaLevelDescriptor
23	Alternate Diploma	Alternate Diploma	uri://doe.in.gov/DiplomaLevelDescriptor
24	Core 40 with Academic Honors (No Grant Funding)	Core 40 with Academic Honors (No Grant Funding)	uri://doe.in.gov/DiplomaLevelDescriptor

Student Academic Records (Indiana v3.6)