Core SIF - StudentAcademicRecord

Tool Search: SIF 

The current version of SIF is v2.7.

This object conveys a student's academic record data for student record exchange and transcript purposes.

This object is designed to be a dual-purpose object. It can be linked to a StudentRecordExchange object for record exchange purposes. There may also be Zones where systems can provide this information for record exchange systems or general informational purposes, in which case the object can be linked directly to Student Personal

SIF_Events are NOT reported for this object.

Batch Condition

Existing SIF_Condition elements to support:

  1. @SIF_RefID
  2. @StudentSchoolEnrollmentData/SchoolAttendedRefId
  3. @StudentSchoolEnrollmentData/GradeLevel/Code

Object Triggering

SIF Events are NOT reported for this object

Object Population and Business Rules

Requirements
The district belongs to the same calendar and year assigned to the SIF Zone.
Any Student with an enrollment in the zone scope.
Report 1 unique RefId for each district and only send one value on each StudentSectionMarks and SectionMarkInfo.
Transcript record must exists for the Student.
Exclude State Exclude (zone options).
Exclude No Show (regardless of zone options).
Calendar "SIF Exclude".
Grade Level > Exclude From SIF Reporting.

(Note: These are MA Object Population and Business Rules)

Report only the marks from a Grading Task or Standard that has the term mask checked for the term, and only for those terms in which the section is scheduled.

  1. A mark will be reported for each that populates a StudentSectionMarks object for a student in the section.

Follow SIF Zone Options Rules for Zones:

Do Not Report when the Calendar > 'Exclude from SIF Exchange' is selected.

Object Data Elements

Data Element LabelDescriptionBusiness RulesData Source GUI PathDatabase FieldM, C or O
@RefIdThe Id (GUID) of this record.


M
@SIF_RefIdThe GUID of an associated object, either StudentRecordExchange or StudentPersonal.The Person Id of the student.

enrollment.personId 

M
@SIF_RefObjectThe associated object type.Reports "StudentPersonal"

M
ReportingDateThe date this record was prepared.Reports the current date.

M
StudentSchoolEnrollmentDataCollects elements of interest from StudentSchoolEnrollment.


M
StudentSchoolEnrollmentData/ @SchoolAttendedRefId

References the school of record for the student (see SchoolAttended). 

The GUID that identifies this school.

Reports the school Id
calendar.schoolIdM
StudentSchoolEnrollmentData/GradeLevelGrade or academic level


M
StudentSchoolEnrollmentData/GradeLevel/CodeCode representing the grade levelReports the Standard Code (SIF code) mapped to the student’s grade level.System Administration > Caendar > Grade Levels > Grade Level Detail > Standard Code (SIF code)

Student Information > General > Enrollments > General Enrollment Information > Grade
gradelevel.codeM
StudentSchoolEnrollmentData/GradeLevel/OtherCodeList



O

StudentSchoolEnrollmentData/GradeLevel/

OtherCodeList/OtherCode

A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code elementThe student’s enrollment grade.Student Information > General > Enrollments > General Enrollment Information > Gradegradelevel.nameMR

StudentSchoolEnrollmentData/GradeLevel/

OtherCodeList/ @Codeset

Describes the OtherCode element content as either a state/province code, a local code, other code, or text stringReport "StateProvince"

M
StudentSchoolEnrollmentData/
     Advisor

This is Optional


StudentSchoolEnrollmentData/
     Counselor

This is Optional


DistrictEntryDateThe date the student originally enrolled in the district of the school of recordThis is Optional

O
SchoolAttendanceHistoryChronology of schools attended in the student's academic career, including the current school if enrolled.


M
SchoolAttendanceHistory/SchoolAttendedData about each individual school attended.


MR
SchoolAttendanceHistory/SchoolAttended/ @RefIdId used internally to StudentAcademicRecord to avoid duplication of school-related data.

Requires an attendance history in the school. Repeats for each school history.



calendar.schoolIdM
SchoolAttendanceHistory/SchoolAttended/LEAInfoDataCollects elements of interest from LEAInfo.


O

SchoolAttendanceHistory/SchoolAttended/

LEAInfoData/StateProvinceId


The identifier for this entity as assigned by the state or province
The District Number associated with the schoolSystem Administration > Resources > District Information > State District Numberdistrict.numberO

SchoolAttendanceHistory/SchoolAttended/

LEAInfoData/LEAName

Name of Local Education AgencyThe district nameSystem Administration > Resources > District Information > Namedistrict.nameM

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData

Collects elements of interest from SchoolInfo.


M

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/LocalId

This is a common element used to define the locally assigned identifier associated with an entity. It is used in StudentPersonal, StaffPersonal, SchoolInfo, and other objects.Reports the School NumberSystem Administration > Resources > School > State School Numberschool.numberM

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/StateProvinceId

The identifier for this entity as assigned by the state or province.The District Number associated with the school.System Administration > Resources > District Information > State School Number

School.Number

O

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolName

Name of the schoolReports the school nameStudent Information > General > Transcript > Transcript Course Editor > School Nameschool.nameM

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList

A list of contact persons associated with a school
System Administration > Resources > School >
O

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/SchoolContact

Information on contact persons for this school
System Administration > Resources > School >
MR

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo



System Administration > Resources > School >
M

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/Name

Name of the contact person


M

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/Name @Type

Code that specifies what type of name this is. If unsure, use 04Reports "04"System Administration > Resources > School >
M

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/Name/LastName

The last nameThe Principal's Last NameSystem Administration > Resources > School >school.principalName after the first space.O

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/Name/FirstName

The first nameThe Principal's  First NameSystem Administration > Resources > School >school.principalName until the first space.O

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/PostitionTitle

The position title. Example: PrincipalReports the position titleSystem Administration > Resources > School >school.principalTitleO

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/PhoneNumberList

List of Phone Number elements


O

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/PhoneNumberList/

PhoneNumber





MR

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/PhoneNumberList/

PhoneNumber Type

Code that specifies what type of phone number this is. Note: A subset of valid values may be specified in data objectsReports "0096"

M

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/

SchoolContactList/SchoolContact/ContactInfo/

PhoneNumberList/PhoneNumber/Number

Phone number. Free-form, but typical U.S. formats include:

(###) ###-####
###-####

Reports the phone numberSystem Administration > Resources > School >school.phoneM
SchoolAttendanceHistory/SchoolAttended/MarkingSystemsNote: Mandatory if school of record. Marking systems/grading tables used by the school.Reports when student is assigned at least 1 score in a course.

C

SchoolAttendanceHistory/SchoolAttended/MarkingSystems/

MarkValueInfoData

Marking system/grading table used by the school


MR

SchoolAttendanceHistory/SchoolAttended/MarkingSystems/

MarkValueInfoData @RefId

Id used internally to StudentAcademicRecord to link marks to their marking systems.Report the unique ID of the selected Score Group.Grading & Standards > Score Groups & Rubrics > Score Groups & Rubrics EditorMIN(dbo.ScoreListItem.itemID), School.schoolID, ScoreGroup.scoreGroupIDM

SchoolAttendanceHistory/SchoolAttended/MarkingSystems/

MarkValueInfoData/Name

The text name of the value list ("Letter Grades", "Letter Grades (+/-)", "ESU", "Pass/Fail", "Override Grades", "Citizenship Comment Codes", etc.).
  1. If all of the scores in the score group are numeric, the following report – each element only once for each score group.
    1. Name = “Numeric Grades”
  2. If the score group is not-numeric or both, the following reports Name:
    1. If there is a score group name, ScoreGroup.name
    2. Otherwise, “Letter Grades”


Grading & Standards > Score Groups & Rubrics > Score Groups & Rubrics Editor > Score Group Detail > NameScoreGroup.nameM
SchoolAttendanceHistory/SchoolAttended/
     MarkingSystems/MarkValueInfoData/
     Numeric
Indicates whether a raw numeric score is accepted.Score Groups & Rubrics score must be numeric (whole number) to report.

C
SchoolAttendanceHistory/SchoolAttended/
     MarkingSystems/MarkValueInfoData/
     Numeric/Precision
Number of significant digits.Reports "3"

O
SchoolAttendanceHistory/SchoolAttended/
     MarkingSystems/MarkValueInfoData/
     Numeric/Scale
Number of decimal places.Reports "3"

O

SchoolAttendanceHistory/SchoolAttended/MarkingSystems/

MarkValueInfoData/Letter

Indicates whether a letter Mark is accepted


C

SchoolAttendanceHistory/SchoolAttended/MarkingSystems/

MarkValueInfoData/Letter/ValidMark

List of specific valid letter MarksReports list of all valid marks (this is repeated for each code)

MR

SchoolAttendanceHistory/SchoolAttended/MarkingSystems/

MarkValueInfoData/Letter/ValidMark/Code

String representing the actual Mark that would appear on the report card (e.g., "A+", "I", "100").

Report the value for each "Score" field cell that contains an alphabetic character.
IF ISNUMERIC(dbo.ScoreListItem.score) = 0 THEN dbo.ScoreListItem.score

Grading & Standards > Score Groups & Rubrics > Score Groups & Rubrics Editor > Score Group List Items Detail (or Rubric List Item Detail) > ScoreScoreListItem.scoreM
EnrollmentHistoryA list of each enrollment in the schools above (see SchoolAttended).Optional. Do Not Report

O

CurrentCourseActivity


Note: Mandatory if coursework is underway. Conveys a student's current coursework along with mid-term marks if applicable.Reports when the student is enrolled in a course in the calendar and current year.
Note: Current courses are the courses whose transcripts aren't posted yet.


C

CurrentCourseActivity/TermInfoData


Collects elements of interest from TermInfo.


M

CurrentCourseActivity/TermInfoData @SchoolAttendedRefId


Reference to the school of record for the courses being taken (see SchoolAttended).

calendar.schoolIdM

CurrentCourseActivity/TermInfoData/SchoolYear



  1. Reports the End Year the calendar is associated
System Administration> Calendar> Calendar> Days> Datecalendar.endYearO

CurrentCourseActivity/TermInfoData/StartDate



The earliest term Start Date in the calendar.System Administration > Calendar > Calendar > Termterm.startDateO

CurrentCourseActivity/TermInfoData/TermSpan






O

CurrentCourseActivity/TermInfoData/TermSpan/Code


Code for session Type

Calculated value based upon COUNT(terms)

Hard Coded:

When c.summerSchool = 1 THEN 0833,

When Temp.countTerms = 1 THEN 0827

When Temp.countTerms = 2 THEN 0828

When Temp.countTerms = 3 THEN 0829

When Temp.countTerms = 4 THEN 0830

When Temp.countTerms = 5 THEN 0831

When Temp.countTerms = 6 THEN 0832

When Temp.countTerms = 12 THEN 0837

ELSE 9999

Note: termInfo.TermSpan.Code field will not update when a term is deleted, or when the calendar is changed to summer. The record must be re-sent for the field to update.


Calculated value based upon COUNT(terms)M
CurrentCourseActivity/CoursesCourses being taken


M
CurrentCourseActivity/Courses/CourseCourse being taken


MR
CurrentCourseActivity/Courses/Course/SchoolAttendedRefIdReference to the school where the course is being taken (see SchoolAttended); may be omitted if the school is the same as the school of record.

calendar.schoolId
CurrentCourseActivity/Courses/Course/SchoolCourseInfoDataCollects elements of interest from SchoolCourseInfo.


M

CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/

CourseCode

School defined local code for a courseReports the course numberCourse/Section> Course> Course Numbercourse.numberO

CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/

StateCourseCode

State defined standard course code used to report information about coursesWhen State Code is null, this element is not reported.Cuurse/Section> Course> State Codecourse.stateCodeO

CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/

DistrictCourseCode

A district course codeOnly reports when course.number is not null.
course.numberO

CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/

CourseTitle

Title of a courseReports the course titleCourse/Section> Course> Namecourse.nameO

CurrentCourseActivity/Courses/Course/MarkingPeriod


Reports the Credit 


gradingTaskCredit.creditM
CourseHistoryConveys the coursework completed, performance and attendance information for a student's academic career.1: Courses posted in current district

2: Courses manually entered in current district

3: Courses not tied to current district


O
CourseHistory/TermTime spans by which courses are grouped


OR
CourseHistory/Term/TermInfoDataCollects elements of interest from TermInfo


M
CourseHistory/Term/TermInfoData/ @SchoolAttendedRefIdReference to the school of record for the time span (see School Attended)The GUID that identifies this school
1: calendar.schoolId
2: The school Id associated with the school number entered on the transcript record
3: The school Id is null (no school number associated with the school Id).
M
CourseHistory/Term/TermInfoData/ SchoolYearSchool year for which this information is applicable, expressed as the four-digit year in which the school year ends (e.g., "2004" for the 2003-04 school year)

transcriptCourse.endYear when not null. Otherwise, uses transcriptCourse.termStartDate. Else, transcriptCourse.termEndDateO
CourseHistory/Term/TermInfoData/ StartDate
Reports the Term Start Date

System Administration > Calendar > Calendar > Term

Student Information > General > Transcript

term.startDate
 transcriptCourse.termStartDate
O
CourseHistory/Term/TermInfoData/ EndDate
Reports the Term End Date

System Administration > Calendar > Calendar > Term

Student Information > General > Transcript

term.endDate
transcriptCourse.termEndDate
O
CourseHistory/Term/TermInfoData/ TermCode

System Administration > Calendar > Calendar > Term

Student Information > General > Transcript

term.name

O
CourseHistory/Term/TermInfoData/ TermSpan



O
CourseHistory/Term/TermInfoData/ TermSpan/CodeCode for session type

Calculated value based upon COUNT(terms)

Hard Coded:

When c.summerSchool = 1 THEN 0833,

When Temp.countTerms = 1 THEN 0827

When Temp.countTerms = 2 THEN 0828

When Temp.countTerms = 3 THEN 0829

When Temp.countTerms = 4 THEN 0830

When Temp.countTerms = 5 THEN 0831

When Temp.countTerms = 6 THEN 0832

When Temp.countTerms = 12 THEN 0837

ELSE 9999

Note: termInfo.TermSpan.Code field will not update when a term is deleted, or when the calendar is changed to summer. The record must be re-sent for the field to update.

System Administration > Calendar > Calendar > Termcalendar.summerSchoolM
CourseHistory/Term/Courses



O
CourseHistory/Term/Courses/Course



OR
CourseHistory/Term/Courses/Course/SchoolAttendedRefIdReference to the school where the course was taken (see SchoolAttended); may be omitted if the school is the same as the school of record.The GUID that identifies this school

C
CourseHistory/Term/Courses/Course/SchoolCourseInfoDataCollects elements of interest from SchoolCourseInfo.


M

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/CourseCode




course.numberO

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/StateCourseCode




course.stateCodeO

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/DistrictCourseCode




course.numberO

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/CourseTitle




course.nameO
CourseHistory/Term/Courses/Course/StartDateDate course section started.

System Administration > Calendar > Calendar > Term

Student Information > General > Transcript

1: term.startDate
2,3: transcriptCourse.termStartDate
O
CourseHistory/Term/Courses/Course/EndDateDate course section ended.

System Administration > Calendar > Calendar > Term

Student Information > General > Transcript

1: term.endDate
2,3: transcriptCourse.termEndDate
O
CourseHistory/Term/Courses/Course/MarkingPeriodsStudent performance/attendance data for each marking period.


M
CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriodStudent performance/attendance data for a marking period.


MR

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/SchoolAttendedRefId

Reference to the school where student took the course during the marking period, if different from schools above.The GUID that identifies this school

C

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/TermInfoData





O

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/TermInfoData/StartDate



System Administration > Calendar > Calendar > Term

Student Information > General > Transcript

1: term.startDate
2,3: transcriptCourse.termStartDate
O

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/TermInfoData/EndDate



System Administration > Calendar > Calendar > Term

Student Information > General > Transcript

1: term.endDate
2,3: transcriptCourse.termEndDate
O

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/TermInfoData/TermSpan





O

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/TermInfoData/TermSpan/Code 

Code for session type.1:

When Calendar > Summer School = checked: 0833

Otherwise, count of terms in calendar:

  1. When 1 term: 0827
  2. When 2 terms: 0828
  3. When 3 terms: 0829
  4. When 4 terms: 0830
  5. When 5 terms: 0831
  6. When > 5 terms: 0832

Otherwise: 9999

2,3: 9999
System Administration > Calendar > Calendar > Termcalendar.summerSchoolM

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/GradeLevelWhenTaken

Student's grade level at time of course.


O

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/GradeLevelWhenTaken/Code

Code representing the grade level.
Note: Student's Transcript grade level record.
Check the ncesGrade (GradeLevel.StandardCode) field first and will use that if it exists AND it maps to a known NCES grade*
  • If there is no ncesGrade (GradeLevel.StandardCode) field, check State Grade Level Code. If it exists AND it maps to a known NCES grade, report that code
  • If no State Grade Level Code, check the grade (Enrollment.grade) field. If it exists AND it maps to a known NCES grade, report that code
  • If no above fields map to any NCES fields, we return as Unknown (UN)
    • *Valid NCES Grade Levels: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, KG, PK, PG, UN

Student Information > General > Transcript > Grade


System Administration > Calendar > Grade Levels > Grade Level Detail > Standard Code (SIF code)


System Administration > Calendar > Grade Levels > Grade Level Detail > State Grade Level Code


Student Information > General > Enrollment > Grade


M
CourseHistory/Term/Courses/
Course/MarkingPeriods/MarkingPeriod/
MarkData
CourseHistory/Term/Courses/
Course/MarkingPeriods/MarkingPeriod/
MarkData



C

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/MarkData/@ MarkValueInfoDataRefId

Reference to marking system at school of record.


M

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/MarkData/Percentage

The percent score for this mark (0.00 - 100.00).
Student Information > General > Transcripts > GradingScore.percentC

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/MarkData/Numeric

The raw numeric score for this mark.Note: This element to be deprecated.The score must be numeric (whole number) to reportStudent Information > General > TranscriptsGradingScore.scoreC

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/CourseCreditsAttempted

Number of course credits attempted.
Student Information > General > Transcripts > CourseCreditsAttemptedTranscriptCredit.CreditsAttemptedO

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/CourseCreditsEarned

Number of course credits earned.
Student Information > General > Transcripts > CourseCreditsEarnedTranscriptCredit.CreditsEarnedO

CourseHistory/Term/Courses/Course/MarkingPeriods/

MarkingPeriod/CreditType

Type of credit.
Student Information > General > Transcripts
O
AcademicPerformanceHistory
This is Optional

O
AcademicPerformanceSummaryProvides a summary of a student's academic performance by reporting period.


M
AcademicPerformanceSummary/
     TotalCreditsAttempted

Total credits attempted during academic career.

The sum of Attempted credits from across all course records on the transcript.Student Information > General > Transcript > Transcript Course Editor > AttemptedTranscriptCredit.creditsAttemptedO
AcademicPerformanceSummary/
     TotalCreditsEarned

Total credits earned during academic career.

The sum of Earned credits from across all course records on the transcript.Student Information > General > Transcript > Transcript Course Editor > EarnedTranscriptCredit.creditsEarnedO
AcademicPerformanceSummary/
     CumulativeGPACreditsEarned

Cumulative number of GPA credits earned during academic career.

Reports the total number of credits in use to calculate the GPA.Student Information > General > Credit Summary

TranscriptCourse.gpaValue

TranscriptCredits.creditsEarned

O
AcademicPerformanceSummary/
     CumulativeGradePoints

Cumulative number of grade points earned during academic career.

The sum of Unweighted GPA Value from across all course records on the transcript.

When Null, reports from the GPA Value field.
Student Information > General > Transcript > Transcript Course Editor > Unweighted GPA Value, GPA Value

TranscriptCourse.gpaValue

TranscriptCourse.unweightedGPAValue

O
AcademicPerformanceSummary/
     CumulativeGPA

Cumulative grade point average for academic career.

Reports the student’s transcript-based cumulative GPA.


    1. Takes “Unweighted GPA” on Transcript * the “GPA Weight” for each course on the student’s transcript.
    2. When “Unweighted GPA” is null, uses the “GPA Value” * “GPA Weight” for each course on the student’s transcript.
    3. Sums the above and divides by the total number of credits (GPA Weight) from across all transcript records.
Student Information > General > Transcript > GPA Weight, GPA Value, Unweighted GPA Value

TranscriptCourse.gpaWeight

TranscriptCourse.gpaValue

TranscriptCourse.unweightedGPAValue

O
AcademicPerformanceSummary/
     ClassRank

Student's rank in graduating class.

Reports the student’s class rank. Max value: 99.99Student Information > General > Credit Summary > Class Rank
O
AcademicPerformanceSummary/
     ClassTotalNumber

Total number of students in student's graduating class.

The number of students included in the class rank.Student Information > General > Credit Summary > Class Rank
O
AcademicPerformanceSummary/
     GraduationDate
Note: Mandatory if graduated. Graduation date.Reports the diploma dateStudent Information> Graduation> Diploma Dategraduation.diplomaDateC
AcademicPerformanceSummary/
     GraduationDiplomaType
Note: Mandatory if graduated. Type of diploma earned.

Reports 1 for "Regular Diploma".

Reports 2 for "Certificate of Completion".

Reports 3 for "Standard Diploma".

Student Information> Graduation> Diploma Typegraduation.diplomaTypeC
AssessmentPerformanceHistoryNote: Mandatory if assessments exist. Conveys a history of assessments that the student has taken throughout his/her academic career.

Reports only when Assessments exists

Reports blank when the student does not have an assessment  assigned that has the following:

National Test = AP, ACT, SAT

Student Information > General > Assessment

Assessment > Test Setup > Test Detail > Subject, National Test
test.type

test.nationalCode
C
AssessmentPerformanceHistory/
     Assessment

A record of performance on an individual assessment.

Repeats a record for each assessment assigned to the student that has the following:

National Test = AP, ACT, SAT
Student Information > General > Assessment

Assessment > Test Setup > Test Detail > Subject, National Test
test.type

test.nationalCode
MR
AssessmentPerformanceHistory/
     Assessment/Name

Textual description of assessment.

Reports the name of the assessment from the topmost parent assessment.Assessment > Test Setup > Test Detail > Nametest.nameM
AssessmentPerformanceHistory/
     Assessment/AdministrationDate

Date the assessment was administered, year is required.

Reports the date entered on the assessment.

When the Date field is blank, reports the Date from any parent assessments it’s attached, beginning with the direct parent and working up until a non-blank Date field is found.

Otherwise, reports blank.

Student Information > General > Assessment > Test Score Detail > Date

test.date

O
AssessmentPerformanceHistory/
     Assessment/StudentGradeLevelWhenAssessed

Student's grade level when assessed.

Reports the student’s highest grade level.Student Information > General > Enrollment > Gradeenrollment.gradeO
AssessmentPerformanceHistory/
     Assessment/StudentGradeLevelWhenAssessed/Code
The code used to identify the student's grade level when assessed.

Reports the student’s highest grade level.

  1. Reports first the Standard Code (SIF code) mapped to the student’s grade level matching the enrollment grade. 
    • If Standard Code doesn't have any grade, reports from Student's Enrollment Grade.

System Administration > Caendar > Grade Levels > Grade Level Detail > Standard Code (SIF code)

Student Information > General > Enrollment > Grade


enrollment.grade

AssessmentPerformanceHistory/
     Assessment/SubtestCategory

The subtest or subject category of the assessment.

Reports the Subject name.

Reports only for ACT and SAT

Assessment > Test Setup > Test Detail > Subjecttest.typeO
AssessmentPerformanceHistory/
     Assessment/TestScoreType
Type of test score.

Hard Coded

Reports 0494 for ACT

For other codes, reference NCES0056AssessmentReportingMethodType





AssessmentPerformanceHistory/
     Assessment/TestScore

Test score.

Reports the score based on the following hierarchy:

1. Scale Score
2. Result
3. Raw Score
4. Percentile
5. Percent
6. Normal Curve Equivalent

When the above criteria are not met, reports blank.

Assessment > Test Setup > Test Detail > Scores

testScore

O
AdditionalGraduationRequirementPerformanceHistory

Note: Mandatory if additional graduation requirements exist. Conveys a student's achievements in relation to additional graduation requirements.

  1. Report this parent element only when the following apply:
    1. A grading Standard (does not need to be State Reported or Final) is attached to a course associated with this student's StudentAcademicRecord instance that has:
      1. Code beginning with "PFL" (not case-sensitive)
    2. The course may be from the current course records or the course history records in the StudentAcademicRecord object for the student.
  2. Else do not report


C
AdditionalGraduationRequirementPerformanceHistory/Requirement

A record of performance in an individual graduation requirement.

  1. Report 1 <Requirement> per course that has the Standard assigned to the course.
  2. When the Standard is assigned to > 1 course, report distinct records per Requirement, Name, Method, Status, and StatusDeterminationDate.
    1. When the course has the same standard and matching values for all of the <Requirement> sub-elements, only 1 <Requirement> record is reported.


MR

AdditionalGraduationRequirementPerformanceHistory/Requirement/

Name

Textual description of the requirement.

  1. Report the entered value in (Grading & Standards>Standard Bank>Standards>Standard Detail>Code) in the Standard with Code beginning in "PFL".
Grading & Standards>Standard Bank>Standards>Standard Detail>Code
M

AdditionalGraduationRequirementPerformanceHistory/Requirement/

Method

The method by which the requirement was met.

  1. When (Grading & Standards>Standard Bank>Standards>Standard Detail>Code) NOT = "PFL00", report the value in the 'State Code' field on the associated Course.
    1. When 'State Code' = Null on the Course:
      1. When the student's Section has 'Medium Of Instruction' NOT = 0608:
        1. Report the name of the course with the prefix “Course-“. Example: Course-Math Skills
      2. When the student's Section has 'Medium Of Instruction' = 0608:
        1. Report the name of the course with the prefix “Online-“. Example: Online-Math Skills
  2. When (Grading & Standards>Standard Bank>Standards>Standard Detail>Code) = "PFL00", report "1451"

Grading & Standards>Standard Bank>Standards>Standard Detail>Code

Course/Section> Course Code

Scheduling>Courses>Course>Section>Medium Of Instruction


O

AdditionalGraduationRequirementPerformanceHistory/Requirement/

Status

Student's status with regard to the requirement.

  1. When the student receives a score on this Standard with Passing Score = Checked on the Rubric:
    1. Report "Met"
  2. Otherwise, report "Not Met"
Grading & Standards> Score Groups & Rubrics >Passing Score
M

AdditionalGraduationRequirementPerformanceHistory/Requirement/

StatusDeterminationDate

Date the student's status was determined.

  1. Report the date of the section's term End Date.
System Administration > Calendar > Calendar > TermTerm.endDateO
ActivityAwardHistory

Note: Mandatory if activities/awards exist. Conveys award the student has received and/or activities in which s/he has been involved.




C
ActivityAwardHistory/ActivityAward

A record of an individual award or activity




MR
ActivityAwardHistory/ActivityAward/
     Name
The title that identifies a particular co-curricular or extra-curricular activity.
  1. Reports  from a CASE statement in a new query for this XML container and is derived from the name of the Diploma Type in our system (for all states)
  2. SQL recommendation as follows:

CASE WHEN cd.[name] like '%honors%' THEN 'Honors'
     WHEN cd.[name] like '%inter%bacc%' THEN 'International Baccalaureate'
     WHEN cd.[name] like '%distinguish%' THEN 'Distinguished'
     WHEN cd.[name] like '%scholar%' THEN 'Scholar'
     WHEN cd.[name] like '%salut%' THEN 'Salutatorian'
     WHEN cd.[name] like '%valed%' THEN 'Valedictorian'
     WHEN cd.[name] like '%scholar%' THEN 'Scholar'
     WHEN cd.[name] like '%distinct%' THEN 'With Distinction' END AS 'name'



M
ActivityAwardHistory/ActivityAward/
     InvolvementCode
The code used to identify the co-curricular or extra-curricular activity in which the individual is involved.
  1. Reports from dbo.Graduation.diplomaType,

2. Reports from "diplomaCode" from the SQL query -

SELECT g.personID, g.diplomaType AS 'diplomaCode', cd.[name] AS 'honorsDescription',
       ISNULL(g.grade9Date, MIN(e.startDate)) AS 'startDate',
       ISNULL(g.diplomaDate, MAX(e.endDate)) AS 'endDate',
       CASE WHEN cd.[name] like '%honors%' THEN 'Honors'
            WHEN cd.[name] like '%inter%bacc%' THEN 'International Baccalaureate'
            WHEN cd.[name] like '%distinguish%' THEN 'Distinguished'
            WHEN cd.[name] like '%scholar%' THEN 'Scholar'
            WHEN cd.[name] like '%salut%' THEN 'Salutatorian'
            WHEN cd.[name] like '%valed%' THEN 'Valedictorian'
            WHEN cd.[name] like '%scholar%' THEN 'Scholar'
            WHEN cd.[name] like '%distinct%' THEN 'With Distinction' END AS 'name'
FROM dbo.Graduation g
INNER JOIN #GlobalTempTable temp ON temp.personID = g.personID
INNER JOIN dbo.Enrollment e on e.enrollmentID = temp.enrollmentID and e.personID = g.personID
INNER JOIN dbo.CampusAttribute ca ON ca.[object] = 'Graduation' AND ca.element = 'diplomaType'
INNER JOIN dbo.CampusDictionary cd ON cd.code = g.diplomaType
WHERE cd.[name] like '%honors%' OR cd.[name] like '%inter%bacc%' OR cd.[name] like '%distinguish%'
   OR cd.[name] like '%scholar%' OR cd.[name] like '%salut%' OR cd.[name] like '%valed%'
   OR cd.[name] like '%scholar%' OR cd.[name] like '%distinct%'
GROUP BY g.personID, g.diplomaType, cd.[name], g.grade9Date, e.startDate, g.diplomaDate, e.endDate
ORDER BY g.personID, g.diplomaType



O
ActivityAwardHistory/ActivityAward/InvolvementBeginningDate

The month, day, and year on which the individual began to participate in the activity.

  1. Reports the grade9Date
  2. If not populated, report the earliest enrollment start date within the zone year
Student Information > General > Graduation> Date First Entered the 9th GradeGraduation.grade9DateO
ActivityAwardHistory/ActivityAward/InvolvementEndingDate

The month, day, and year on which the individual ceased to participate in the activity.

  1. Reports the Diploma Date
  2. If not populated, report the latest enrollment end date within the zone year
Student Information > General > Graduation> Diploma DateGraduation.diplomaDateO
ActivityAwardHistory/ActivityAward/HonorsDescription

A textual description of the distinction or honor.

Reports from the Diploma Type droplistStudent Information > General > Graduation > Diploma Type
O