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:
- @SIF_RefID
- @StudentSchoolEnrollmentData/SchoolAttendedRefId
- @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.
|
Follow SIF Zone Options Rules for Zones:
|
| Do Not Report when the Calendar > 'Exclude from SIF Exchange' is selected. |
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
|---|---|---|---|---|---|
| @RefId | The Id (GUID) of this record. | M | |||
| @SIF_RefId | The GUID of an associated object, either StudentRecordExchange or StudentPersonal. | The Person Id of the student. | enrollment.personId | M | |
| @SIF_RefObject | The associated object type. | Reports "StudentPersonal" | M | ||
| ReportingDate | The date this record was prepared. | Reports the current date. | M | ||
| StudentSchoolEnrollmentData | Collects 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.schoolId | M | |
| StudentSchoolEnrollmentData/GradeLevel | Grade or academic level | M | |||
| StudentSchoolEnrollmentData/GradeLevel/Code | Code representing the grade level | Reports 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.code | M |
| 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 element | The student’s enrollment grade. | Student Information > General > Enrollments > General Enrollment Information > Grade | gradelevel.name | MR |
StudentSchoolEnrollmentData/GradeLevel/ OtherCodeList/ @Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string | Report "StateProvince" | M | ||
| StudentSchoolEnrollmentData/ Advisor | This is Optional | ||||
| StudentSchoolEnrollmentData/ Counselor | This is Optional | ||||
| DistrictEntryDate | The date the student originally enrolled in the district of the school of record | This is Optional | O | ||
| SchoolAttendanceHistory | Chronology of schools attended in the student's academic career, including the current school if enrolled. | M | |||
| SchoolAttendanceHistory/SchoolAttended | Data about each individual school attended. | MR | |||
| SchoolAttendanceHistory/SchoolAttended/ @RefId | Id used internally to StudentAcademicRecord to avoid duplication of school-related data. | Requires an attendance history in the school. Repeats for each school history. | calendar.schoolId | M | |
| SchoolAttendanceHistory/SchoolAttended/LEAInfoData | Collects 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 school | System Administration > Resources > District Information > State District Number | district.number | O |
SchoolAttendanceHistory/SchoolAttended/ LEAInfoData/LEAName | Name of Local Education Agency | The district name | System Administration > Resources > District Information > Name | district.name | M |
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 Number | System Administration > Resources > School > State School Number | school.number | M |
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 school | Reports the school name | Student Information > General > Transcript > Transcript Course Editor > School Name | school.name | M |
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 04 | Reports "04" | System Administration > Resources > School > | M | |
SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/ SchoolContactList/SchoolContact/ContactInfo/Name/LastName | The last name | The Principal's Last Name | System Administration > Resources > School > | school.principalName after the first space. | O |
SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/ SchoolContactList/SchoolContact/ContactInfo/Name/FirstName | The first name | The Principal's First Name | System Administration > Resources > School > | school.principalName until the first space. | O |
SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/ SchoolContactList/SchoolContact/ContactInfo/PostitionTitle | The position title. Example: Principal | Reports the position title | System Administration > Resources > School > | school.principalTitle | O |
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 objects | Reports "0096" | M | ||
SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/ SchoolContactList/SchoolContact/ContactInfo/ PhoneNumberList/PhoneNumber/Number | Phone number. Free-form, but typical U.S. formats include: (###) ###-#### | Reports the phone number | System Administration > Resources > School > | school.phone | M |
| SchoolAttendanceHistory/SchoolAttended/MarkingSystems | Note: 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 Editor | MIN(dbo.ScoreListItem.itemID), School.schoolID, ScoreGroup.scoreGroupID | M |
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.). |
| Grading & Standards > Score Groups & Rubrics > Score Groups & Rubrics Editor > Score Group Detail > Name | ScoreGroup.name | M |
| 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 Marks | Reports 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. | Grading & Standards > Score Groups & Rubrics > Score Groups & Rubrics Editor > Score Group List Items Detail (or Rubric List Item Detail) > Score | ScoreListItem.score | M |
| EnrollmentHistory | A 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.schoolId | M | ||
CurrentCourseActivity/TermInfoData/SchoolYear |
| System Administration> Calendar> Calendar> Days> Date | calendar.endYear | O | |
CurrentCourseActivity/TermInfoData/StartDate | The earliest term Start Date in the calendar. | System Administration > Calendar > Calendar > Term | term.startDate | O | |
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/Courses | Courses being taken | M | |||
| CurrentCourseActivity/Courses/Course | Course being taken | MR | |||
| CurrentCourseActivity/Courses/Course/SchoolAttendedRefId | Reference 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/SchoolCourseInfoData | Collects elements of interest from SchoolCourseInfo. | M | |||
CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/ CourseCode | School defined local code for a course | Reports the course number | Course/Section> Course> Course Number | course.number | O |
CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/ StateCourseCode | State defined standard course code used to report information about courses | When State Code is null, this element is not reported. | Cuurse/Section> Course> State Code | course.stateCode | O |
CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/ DistrictCourseCode | A district course code | Only reports when course.number is not null. | course.number | O | |
CurrentCourseActivity/Courses/Course/SchoolCourseInfoData/ CourseTitle | Title of a course | Reports the course title | Course/Section> Course> Name | course.name | O |
CurrentCourseActivity/Courses/Course/MarkingPeriod | Reports the Credit | gradingTaskCredit.credit | M | ||
| CourseHistory | Conveys 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/Term | Time spans by which courses are grouped | OR | |||
| CourseHistory/Term/TermInfoData | Collects elements of interest from TermInfo | M | |||
| CourseHistory/Term/TermInfoData/ @SchoolAttendedRefId | Reference 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/ SchoolYear | School 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.termEndDate | O | ||
| 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/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. | System Administration > Calendar > Calendar > Term | calendar.summerSchool | M |
| CourseHistory/Term/Courses | O | ||||
| CourseHistory/Term/Courses/Course | OR | ||||
| CourseHistory/Term/Courses/Course/SchoolAttendedRefId | Reference 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/SchoolCourseInfoData | Collects elements of interest from SchoolCourseInfo. | M | |||
CourseHistory/Term/Courses/Course/ SchoolCourseInfoData/CourseCode | course.number | O | |||
CourseHistory/Term/Courses/Course/ SchoolCourseInfoData/StateCourseCode | course.stateCode | O | |||
CourseHistory/Term/Courses/Course/ SchoolCourseInfoData/DistrictCourseCode | course.number | O | |||
CourseHistory/Term/Courses/Course/ SchoolCourseInfoData/CourseTitle | course.name | O | |||
| CourseHistory/Term/Courses/Course/StartDate | Date course section started. | System Administration > Calendar > Calendar > Term Student Information > General > Transcript | 1: term.startDate 2,3: transcriptCourse.termStartDate | O | |
| CourseHistory/Term/Courses/Course/EndDate | Date course section ended. | System Administration > Calendar > Calendar > Term Student Information > General > Transcript | 1: term.endDate 2,3: transcriptCourse.termEndDate | O | |
| CourseHistory/Term/Courses/Course/MarkingPeriods | Student performance/attendance data for each marking period. | M | |||
| CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod | Student 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: 9999 2,3: 9999 | System Administration > Calendar > Calendar > Term | calendar.summerSchool | M |
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*
| 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.percent | C | |
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 report | Student Information > General > Transcripts | GradingScore.score | C |
CourseHistory/Term/Courses/Course/MarkingPeriods/ MarkingPeriod/CourseCreditsAttempted | Number of course credits attempted. | Student Information > General > Transcripts > CourseCreditsAttempted | TranscriptCredit.CreditsAttempted | O | |
CourseHistory/Term/Courses/Course/MarkingPeriods/ MarkingPeriod/CourseCreditsEarned | Number of course credits earned. | Student Information > General > Transcripts > CourseCreditsEarned | TranscriptCredit.CreditsEarned | O | |
CourseHistory/Term/Courses/Course/MarkingPeriods/ MarkingPeriod/CreditType | Type of credit. | Student Information > General > Transcripts | O | ||
| AcademicPerformanceHistory | This is Optional | O | |||
| AcademicPerformanceSummary | Provides 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 > Attempted | TranscriptCredit.creditsAttempted | O |
| 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 > Earned | TranscriptCredit.creditsEarned | O |
| 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.
| 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.99 | Student 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 date | Student Information> Graduation> Diploma Date | graduation.diplomaDate | C |
| 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 Type | graduation.diplomaType | C |
| AssessmentPerformanceHistory | Note: 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: | 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 > Name | test.name | M |
| 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 > Grade | enrollment.grade | O |
| AssessmentPerformanceHistory/ Assessment/StudentGradeLevelWhenAssessed/Code | The code used to identify the
student's grade level when assessed. | Reports the student’s highest grade level.
| 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 > Subject | test.type | O |
| 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. |
| C | ||
| AdditionalGraduationRequirementPerformanceHistory/Requirement | A record of performance in an individual graduation requirement. |
| MR | ||
AdditionalGraduationRequirementPerformanceHistory/Requirement/ Name | Textual description of the requirement. |
| Grading & Standards>Standard Bank>Standards>Standard Detail>Code | M | |
AdditionalGraduationRequirementPerformanceHistory/Requirement/ Method | The method by which the requirement was met. |
| 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. |
| Grading & Standards> Score Groups & Rubrics >Passing Score | M | |
AdditionalGraduationRequirementPerformanceHistory/Requirement/ StatusDeterminationDate | Date the student's status was determined. |
| System Administration > Calendar > Calendar > Term | Term.endDate | O |
| 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. |
| M | ||
| ActivityAwardHistory/ActivityAward/ InvolvementCode | The code used to identify the co-curricular or extra-curricular activity in which the individual is involved. |
2. Reports from "diplomaCode" from the SQL query -
| O | ||
| ActivityAwardHistory/ActivityAward/InvolvementBeginningDate | The month, day, and year on which the individual began to participate in the activity. |
| Student Information > General > Graduation> Date First Entered the 9th Grade | Graduation.grade9Date | O |
| ActivityAwardHistory/ActivityAward/InvolvementEndingDate | The month, day, and year on which the individual ceased to participate in the activity. |
| Student Information > General > Graduation> Diploma Date | Graduation.diplomaDate | O |
| ActivityAwardHistory/ActivityAward/HonorsDescription | A textual description of the distinction or honor. | Reports from the Diploma Type droplist | Student Information > General > Graduation > Diploma Type | O |
