Student Academic Records (Georgia v3.6.1)

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 record for each unique Ed-Fi termDescriptor in the current configuration year in which the student has a transcript record. Do not report a record if the 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 through the Transcript Post tool or manually. 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."
Delete/Post/Put	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise. When the following information on a transcript record is changed: Transcript ID (New Transcript Entry) Ed-Fi Term Type
Delete	When all transcript records related to the termDescriptor being reported are deleted. 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.

Do not report a record if the 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 through the Transcript Post tool or manually.
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."

Delete/Post/Put

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

When the following information on a transcript record is changed:
- Transcript ID (New Transcript Entry)
- Ed-Fi Term Type

Delete

When all transcript records related to the termDescriptor being reported are deleted.
When all of the reportable enrollments for the student are deleted.

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
Diploma Type Descriptors	Graduation Diploma Type

Identity Mapping Object Key

This table describes the Resource Preferences of this object.

Campus Object Type	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.
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 and Business Rules	M, C or O	Data Source GUI Path	Database Field
termDescriptor	The term for the session during the school year. 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."	M	N/A	N/A
educationOrganization Reference	A reference to the related Education Organization resource. Reports the fields that are part of the Natural Key for the Local Education Agencies resource. educationOrganizationId = Ed-Fi School Number If the Ed-Fi School Number cannot be determined (manual transcript / no scoreID), reports the Transcript District Number + Transcript School Number.	M	School > Ed-Fi School Number Transcript > District Number, School Number	School.entityID TranscriptCourse.districtNumber TranscriptCourse.schoolNumber
schoolYearType Reference	A reference to the related SchoolYearType resource. Reports the End Year of the associated School Year selected.	M	N/A	N/A
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource.	M	N/A	N/A

Descriptors

Click here to expand...

termDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
N1	1st Nine Week	uri://gadoe.org/TermDescriptor	1st Nine Week
N2	2nd Nine Week	uri://gadoe.org/TermDescriptor	2nd Nine Week
N3	3rd Nine Week	uri://gadoe.org/TermDescriptor	3rd Nine Week
N4	4th Nine Week	uri://gadoe.org/TermDescriptor	4th Nine Week
S1	1st Semester	uri://gadoe.org/TermDescriptor	1st Semester
S2	2nd Semester	uri://gadoe.org/TermDescriptor	2nd Semester
T1	1st Trimster	uri://gadoe.org/TermDescriptor	1st Trimster
T2	2nd Trimster	uri://gadoe.org/TermDescriptor	2nd Trimster
T3	3rd Trimster	uri://gadoe.org/TermDescriptor	3rd Trimster
X1	1st Six-Week	uri://gadoe.org/TermDescriptor	1st Six-Week
X2	2nd Six-Week	uri://gadoe.org/TermDescriptor	2nd Six-Week
X3	3rd Six-Week	uri://gadoe.org/TermDescriptor	3rd Six-Week
X4	4th Six-Week	uri://gadoe.org/TermDescriptor	4th Six-Week
X5	5th Six-Week	uri://gadoe.org/TermDescriptor	5th Six-Week
X6	6th Six-Week	uri://gadoe.org/TermDescriptor	6th Six-Week
F1	1st four and half week	uri://gadoe.org/TermDescriptor	1st four and half week
F2	2nd four and half week	uri://gadoe.org/TermDescriptor	2nd four and half week
F3	3rd four and half week	uri://gadoe.org/TermDescriptor	3rd four and half week
F4	4th four and half week	uri://gadoe.org/TermDescriptor	4th four and half week
F5	5th four and half week	uri://gadoe.org/TermDescriptor	5th four and half week
F6	6th four and half week	uri://gadoe.org/TermDescriptor	6th four and half week
F7	7th four and half week	uri://gadoe.org/TermDescriptor	7th four and half week
F8	8th four and half week	uri://gadoe.org/TermDescriptor	8th four and half week