Course Transcripts (Georgia v3.6.1)

This entity is the final record of a student's performance in their courses at the end of a semester or school year.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Object Triggering

Action	Trigger
Post	When transcript records are posted for a student (both through the Transcript Post tool and manual transcript entries) and they have a valid Student School Association for the configured year. Do not send a record if the associated course is marked as inactive. Do not send a record if the transcript's score is null. Do not send a record if the School Exclude check box is checked. Do not send a record if the Calendar Exclude check box is checked. Do not send a record if the student's Enrollment is marked as State Exclude. For a manual transcript entry to post a record without error, all of the below fields must be populated on the transcript: Score Attempted Credits Earned Credits School Year Course Name State Code Ed-Fi Term Type (or have a mapped override)
Delete/Post/Put	A Delete/Post will be performed when the natural key is changed. A Put will be performed otherwise. When the following information is changed on a transcript entry: Transcript ID (New Transcript Entry) Score Attempted Credits Earned Credits School Year Course Name State Code Ed-Fi Term Type
Delete	When a transcript record is deleted for a student
Delete	All Transcript records will only delete when a student has only 1 Student School Association record for a specific Year and that record is deleted. (Note: If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data).

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data remains in the ODS but no new data sends.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is 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 is deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

Action	Trigger
Post/Delete	Natural Key changes: If the Natural Key changes from the Course Reference or Student Academic Reference, the cascading delete/post logic from those resources will trigger updates to the Course Transcripts. Records will delete/post if the Credits Earned or Credits Attempted are changed on a student's transcript record.

Action

Trigger

Post/Delete

Natural Key changes:

If the Natural Key changes from the Course Reference or Student Academic Reference, the cascading delete/post logic from those resources will trigger updates to the Course Transcripts.
Records will delete/post if the Credits Earned or Credits Attempted are changed on a student's transcript record.

Scope Year Logic

Logic
Transcript records send to each scope year where the student has a Student School Association, regardless of the Transcript School Year. Data only sends for years that have valid configuration. A resync must be completed at the beginning of each year so that all years transcript records are loaded in the ODS.

Logic

Transcript records send to each scope year where the student has a Student School Association, regardless of the Transcript School Year.

Data only sends for years that have valid configuration.
A resync must be completed at the beginning of each year so that all years transcript records are loaded in the ODS.

Identity Mapping Object Key

campusObjectType	Object Key Data Source
TranscriptCourse	transcriptID

Event Queue Detail

Campus Table	Ed-Fi Action	Fields
transcriptcourse	Post/Put/Delete	The primary table used for sending data for this resource.
transcriptcredit	Post/Put/Delete	The primary table used for sending data for this resource.

Object Data Elements

This table describes data elements sent within the Course Transcripts 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 and Business Rules	M, C, or O	Data Source GUI Path	Database Field
courseAttemptResultDescriptor	Report the Ed-Fi Code associated with the State Score that is mapped to the Score selected. If there is no State Score mapped to the Score selected, or the State Score does not have an Ed-Fi Code mapped to it, report the Ed-Fi Code mapped to the calculation between Attempted Credits and Earned Credits. When the sum of credits Earned is >= the sum of credits Attempted When the sum of credits Earned is blank or = 0 When the sum of credits Earned is not blank or = 0 and < than the sum of credits Attempted	M	State Score: Grading & Standards > Score Groups & Rubrics > State Score Calculation: Student Information> General> Transcripts> Earned AND Student Information> General> Transcripts> Attempted	State Score: ScoreListItem.stateScore Calculation: transcriptcredit.creditsAttempted transcriptcredit.creditsEarned
courseReference	A reference to the related Course resource. Reports the Natural Key fields for the Course resource	M
externalEducationOrganziationReference	The identifier assigned to an education organization. This is optional, do not report.	O
studentAcademicRecordReference	A reference to the related Student Academic Record resource. Reports the Natural Key fields for the Student Academic Record resource.	M
alternativeCourseCode	The local code assigned by the school that identifies the course offering, the code from an external educational organization, or other alternate course code. This is optional, do not report.	O
alternativeCourseTitle	The descriptive name given to a course of study offered in the school, if different from the CourseTitle. This is optional, do not report.	O
attemptedCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional, do not report.
attemptedCredits	The number of credits attempted for a course. This is optional, do not report.	O
attemptedCreditTypeDescriptor	The type of credits or units of value attempted for the completion of a course. This is optional, do not report.	O
courseRepeatCodeDescriptor	Indicates that an academic course has been repeated by a student and how that repeat is to be computed in the student''s academic grade average. This is optional, do not report.
CourseTitle	Reports the name of the course completed. Report the Course Name from the transcript record	O	Student Information > General > Transcripts > Course Name	transcriptcourse.courseName
earnedadditionalCredits	An unordered collection of courseTranscriptAdditionalCredits. This entity is the final record of a student's performance in their courses at the end of a semester or school year. This is optional, do not report.	O
earnedCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional, do not report.	O
earnedCredits	The number of credits awarded or earned for the course. Report the sum of credits from the Earned field on the Transcript record being reported	M	Student Information > General > Transcripts > Earned	transcriptcredit.creditsAttempted
earnedCreditTypeDescriptor	The type of credits or units of value awarded for the completion of a course. This is optional, do not report.	O
finalLetterGradeEarned	The final letter grade earned for the course. Determine if the posted score is an integer or not: If the posted value is an Integer, then report the posted score here If the posted value is not an Integer, then report in Final Letter Grade Earned field above.	O	Student Information > General > Transcripts > Current Score	transcriptcourse.score
finalNumericGradeEarned	The final numeric grade earned for the course. Determine if the posted score is an integer or not: If the posted value is an Integer, then report the posted score here If the posted value is not an Integer, then report in Final Letter Grade Earned field above.	O	Student Information > General > Transcripts > Current Score	transcriptcourse.score
methodCreditEarnedType	The method the credits were earned, for example: Classroom, Examination, Transfer. This is optional, do not report.	O
whenTakengradeLevelDescriptor	Student's grade level at time of course. This is optional, do not report.	O

Types/Descriptors

Click here to expand...

courseAttemptResultDescriptor

Ed-Fi Code Value	Description	Namespace
Fail	Fail	uri://gadoe.org/CourseAttemptResultDescriptor
Incomplete	Incomplete	uri://gadoe.org/CourseAttemptResultDescriptor
Pass	Pass	uri://gadoe.org/CourseAttemptResultDescriptor
Withdrawn	Withdrawn	uri://gadoe.org/CourseAttemptResultDescriptor

termDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
Y1	Year Course	uri://gadoe.org/TermDescriptor	Year Course
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 Trimester	uri://gadoe.org/TermDescriptor	1st Trimester
T2	2nd Trimester	uri://gadoe.org/TermDescriptor	2nd Trimester
T3	3rd Trimester	uri://gadoe.org/TermDescriptor	3rd Trimester
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