Skip to main content
Skip table of contents

K12 Student Academic Record

This resource publishes Student Academic Records that include course grades, graduation-related data, and academic awards received.

Additional setup is required to publish the K12 Student Academic Record resources. Refer to the Additional District Setup section.

Note: If this is NOT set then we will NOT publish any grades and related items like Potential Credit Hours, Earned Credit, and Grade Level.

  • The students published must NOT be excluded from state reporting.

  • The school must not be excluded from reporting. No students will be published from a school that is excluded from reporting.

  • The course section must have a final grade stored for the corresponding term.

Element Name

Submission

Definition

Code Set, if applicable

Technical Name

[Table]Field Mapping

Business Rules or Comments

Category - Academic Record, Academic Record Course Info

Career Education Plan Date

Yes

The date on which an individual's professional development career plan was last updated.

None

CareerEducationPlanDate

NA

For Individual Student/Service Plan (ISP).

Needs more discussion with MDE.

Career Education Plan Type

Yes

An indication of whether an individual completed an individualized guidance and counseling plan

Education - Education plan
Career - Career plan
Both - Both education and career plan
Other - Other

CareerEducationPlanType

NA

For Individual Student/Service Plan (ISP).

Needs more discussion with MDE.

Course Code System

Yes

A system that is used to identify the organization of subject matter and related learning experiences provided for the instruction of students.

MDE Option Set

LEA - LEA course code
State - State course code

CourseCodeSystem

Default to "State"

Course Identifier

Yes

The actual code that identifies the organization of subject matter and related learning experiences for the instruction of students.

None

CourseIdentifier

[Courses]Alt_Course_Number
or
[Courses]Course_Number

Extract the alternate course number, if populated. Otherwise, extract the course number.

Course Title

Yes

The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).

None

CourseTitle

[Courses]Course_Name

Credit Unit Type

Yes

The type of credits or units of value awarded for the completion of a course.

MDE Option Set

00585 - Carnegie unit

CreditUnitType

Default to "00585"

End of Term Status

Yes

The nature of the student's progress at the end of a given school term.

Promotion - Promotion
Retention - Retention

EndOfTermStatus

[S_MS_STU_X]PromotionInd

Yes = Promoted

No = Retained

Grade Point Average Cumulative

Yes

A measure of average performance in all courses taken by a person 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 person was previously enrolled.

None

GPACumulative

NA

For end-of-year reporting.

Needs more discussion with MDE.

Grade Point Average Weighted Indicator

Yes

An indication of whether the reported Grade Point Average is weighted or unweighted.

Weighted - Weighted
Unweighted - Unweighted

GPAWeightedIndicator

NA

For end-of-year reporting.

Needs more discussion with MDE.

Grade Level When Course Taken

Yes

Student's grade level at time of course.

IT - Infant/toddler
PR - Preschool
PK - Prekindergarten
TK - Transitional Kindergarten
KG - Kindergarten
01 - First grade
02 - Second grade
03 - Third grade
04 - Fourth grade
05 - Fifth grade
06 - Sixth grade
07 - Seventh grade
08 - Eighth grade
09 - Ninth grade
10 - Tenth grade
11 - Eleventh grade
12 - Twelfth grade
13 - Grade 13
PS - Postsecondary
UG - Ungraded
Other - Other

GradeLevelWhenCourseTaken

[StoredGrades]Grade_Level

Grade Value Qualifier

Yes

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.)

None

GradeValueQualifier

Derived

If [StoredGrades]Grade or [StoredGrades]Percent field has a value > 0 then extract "A=90-100%, B=80-89%, C=70-79%, D=60-69%, F=0-59%" else blank.

Check the Grade field first, if the field is empty then check the Percent field.

Note: This is not required for pass/fail-type courses. So, If the value is not a number, then extract blank.

Number of Credits Attempted

Yes

The number of credits that a student can earn for enrolling in and completing a given course.

None

NumberOfCreditsAttempted

[StoredGrades]PotentialCrHrs

Number of Credits Earned

Yes

The number of credits an individual earns by the successful completion of a course.

None

NumberOfCreditsEarned

[StoredGrades]EarnedCrHrs

Projected Graduation Date

Yes

The year and month the student is projected to graduate.

None

ProjectedGraduationDate

NA

To be added later.

Student Course Section Grade Earned

Yes

A final indicator of student performance in a course section as submitted by the instructor.

None

StudentCourseSectionGradeEarned

[StoredGrades]Grade

Extract the "final" grade based on the store code setup in the CRDC Final Grade Store Codes table.

Refer to the Additional District Setup section.

Category - Academic Record, Academic Award

Academic Award Date

Yes

The year, month, and day or year and month on which the academic award was conferred.

None

AcademicAwardDate

NA

To be added later.

Academic Award Title

Yes

The descriptive title for the academic award.

None

AcademicAwardTitle

NA

To be added later.

Diploma or Credential Award Date

Yes

The month and year on which the diploma/credential is awarded to a student in recognition of his/her completion of the curricular requirements.

None

DiplomaOrCredentialAwardDate

NA

To be added later.

High School Diploma Distinction Type

Yes

The distinction of the diploma or credential that is awarded to a student in recognition of their completion of the curricular requirements.

MDE Option Set

Career and Technical Education
Academic
Distinguished - Distinguished

HighSchoolDiplomaDistinctionType

[S_MS_STU_X]DiplomaEndorsement1

[S_MS_STU_X]DiplomaEndorsement2

Codeset Mapping

  • CE = CareerAndTechnicalEducation

  • AE = Academic

  • DE = Distinguished

If both the fields are null then publish blank.

High School Diploma Type

Yes

The type of diploma/credential that is awarded to a person in recognition of his/her completion of the curricular requirements.

MDE Option Set

00806 - Regular diploma
00807 - Endorsed/advanced diploma
00812 - Alternative credential
00813 - Certificate of attendance
00814 - Certificate of completion
00816 - General Educational Development (GED) credential
00818 - Postgraduate certificate (grade 13)
75000 -Alternate Diploma

HighSchoolDiplomaType

[S_MS_STU_X]GraduationType

Codeset Mapping

  • T = 00806

  • O = 00814

  • G = 00816

  • AD = 75000

  • OD = 00812 ***

Projected High School Diploma Type

Yes

The type of diploma/credential a person would be awarded in recognition of his/her completion of the curricular requirements.

Refer to Projected High School Diploma Typefor both Option set and MDE option set.

ProjectedHighSchoolDiplomaType

NA

To be added later.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.