Tool Search: SIRS Extracts

The SIRS Assessment Fact Extract reports all state-coded assessments taken by students within the selected calendar(s) and grade level(s).

Tip for Best Score Reporting

When your district would like to only report the highest grade when a student takes an exam more than once, set up two different versions of the exam in Campus. One exam should be mapped to an active value in the State Code dropdown list on the Test Setup > Test Detail editor. Do NOT map the other exam to an active State Code. The District/School/Counselor can then choose to capture the value initially in the state-mapped assessment and switch the exam to the non-state-mapped assessment if it is determined that a different exam's score should report.

This setup gives you the flexibility of deciding, on a case-by-case basis, whether to take advantage of the best score reporting rule.

Screenshot of the SIRS Assessment Fact extract editor.

Reporting Logic

Any NY Assessment (which also meets the other extract criteria for the report) with a value in the State Code field (Assessment > Test Setup > Tests > Test Detail > State Test > State Code) reports.

Only records where the student's Enrollment Start Date is less than or equal to the extract editor's Effective Date report.

Multiple Enrollments

When multiple Enrollments may report, a record reports from the Enrollment with the first Service Type listed below:
- P: Primary
- S: Partial
- N: Special Ed
When multiple Enrollments meet the previous requirement, the Enrollment with the most recent Start Date reports.
When multiple Enrollments meet the previous requirement, the Enrollment with the lowest Enrollment ID reports.

Students are NOT included when:

their Enrollment Start Status is 0055;
their enrollment record is marked as State Exclude;
their enrollment record is marked as No Show;
their Grade Level of enrollment is marked as State Exclude; or
their Calendar of enrollment is marked as State Exclude.

The following RCT assessments report numeric and alpha pass/fall scores:

RCT Reading - Jan
RCT Reading - Jun
RCT Reading - Aug
RCT Mathematics - Jan
RCT Mathematics - Jun
RCT Mathematics - Aug
RCT Science - Jan
RCT Science - Jun
RCT Science - Aug
RCT Global Studies - Jan
RCT Global Studies - Jun
RCT Global Studies - Aug
RCT US Hist & Gov't - Jan
RCT US Hist & Gov't - Aug
RCT US Hist & Gov't - Jun

The following RCT assessments only report numeric scores: RCT Writing - Jan, RCT Writing - Jun, RCT Writing - Aug.

The score reports from one of the following three locations based on which State Code is saved in the Assessment record: Scale Score, Raw Score, or Result Score. The score reports in Numeric Score (column 10).

All active State Code values report a record in the Assessment Fact extract. However, when they are not part of the current state code mapping in Campus, records report as follows:

Location	Logic	Column
Scale Score	Reports when saved in the database	NumericScore (column 10)
Raw Score	Reports when saved in the database and no Scale Score exists	NumericScore (column 10)
Result Score	Reports when saved in the database	AlphaScore (column 9)

Extract Editor

Field	Description
Extract Type	The SIRS Extract to run.
Effective Date	The date for which information reports.
Included State Grade Levels	Identifies the state grade levels to include in the report.
Format	The Format in which the report should generate. Options are State Format (CSV) and HTML. Use State Format for reporting information to the state and the other types for data review and verification.
Ad Hoc Filter	Selecting a filter limits the results to only those included in the filter.
Column Headers	Indicates whether Column Headers should be included in the report. This dropdown list applies to State Format (CSV).
Generate Extract/ Submit to Batch	Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Select Calendars	Identifies which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year.

Assessment Fact Extract Layout

Element Name	Description	Campus Location
DistrictCode	The identification number of the district. The prefix "NY" is added to the district number. For example, when the district number is 662001, the District Code is NY662001. Numeric, 8 digits	District Information > District Number District.number
TestDescription	The name of the assessment being reported. ALTRCT ALTREG CTE NYSAA NYSESLAT RCT Regents Alphanumeric, 15 characters	Assessment > Test Detail > State Test stateCode.test
Version	The school year for which the assessment was taken. Reports as YYYY-6-30. Date field, 10 characters, YYYY-6-30	Calendar Information > End Date (year only) Calendar.endDate
ItemDescription	The longer version of the assessment name. Alphanumeric, 50 characters	Test Setup > Tests > Test Detail Test.name
TestDate	The first date of test administration. Date field, 10 characters	Test Setup > Tests > Test Detail Test.date
Student ID	The student's Local Student Number. Alphanumeric,12 characters	Demographics > Person Identifiers > Local Student Number Person.studentNumber
LocationCode	This field reports 0000. Numeric, 4 digits	Not dynamically stored.
ScoreDisplay	This field reports blank.	N/A
AlphaScore	The value based on the State Code Mapping table below. Alphanumeric, 8 characters	N/A
NumericScore	The score achieved on the assessment when score is numeric. Numeric, 8 characters	Student Information > General > Assessments > Test Score Detail > Score or Raw Score Test.useScaleScore Test.useRawScore
Credits	This field reports blank.	N/A
NationalPercentile	This field reports blank.	N/A
LocalPercentile	This field reports blank.	N/A
Mastery	This field reports blank.	N/A
AssessmentStatus	This field reports blank.	N/A
Assessment LanguageCode	Code indicating in which language the assessment was administered. The language code selected on the assessment reports. When a parent and child assessment both exist, the value from the parent assessment reports for both the parent and child lines on the extract. The default language, ENG, reports when a language is not selected on the assessment. Alphanumeric, 4 characters	Student Information > General > Assessments > Test Score Detail > Assessment Language TestScore.language
Standard AchievedCode	Code used to indicate the level of performance on an assessment or the reason there is no score for the assessment. Alphanumeric, 4 characters	Student Information > General > Assessments > Test Score Detail > Standard Achieved TestScore.resultLevel
NormCurveEquiv	This field reports blank.	N/A
RawScore	This field reports blank.	N/A
ScaleScore	This field reports blank.	N/A
PercentScore	This field reports blank.	N/A
LocalStanine	This field reports blank.	N/A
NationalStanine	This field reports blank.	N/A
National PercentileByAge	This field reports blank.	N/A
Number OfItemsCorrect	This field reports blank.	N/A
Objective MasteryScore	This field reports blank.	N/A
DegreesOf ReadingPower	This field reports blank.	N/A
Intelligence Quotient	This field reports blank.	N/A
Standard PerformanceLevel	This field reports blank.	N/A
GradeEquivalent	This field reports blank.	N/A
SpecialNormGroup	This field reports blank.	N/A
LevelOfAggregation	This field reports blank.	N/A
TestingModification	This field reports blank.	N/A
TestAssignmentDate	This field reports blank.	N/A
EvaluatorID	This field reports blank.	N/A
EvaluatorName	This field reports blank.	N/A
SchoolYearDate	This field reports blank.	N/A
SubtestScaleScore	This field reports blank.	N/A
NumberofTimesTested	This field reports blank.	N/A
ConvertedScore	This field reports blank.	N/A
AssessmentAccountable	This field reports blank.	N/A
TestingAccommodation	This field reports blank.	N/A
Standard ErrorOfMeasurement	This field reports blank.	N/A
ScoringModelCode	This field reports blank.	N/A
Survey CompletionIndicator	This field reports blank.	N/A
Assessment AccountableSchool	This field reports blank.	N/A
Lexile MinimumScore	This field reports blank.	N/A
Lexile MaximumScore	This field reports blank.	N/A
Number OfItemsAttempted	This field reports blank.	N/A
Number OfItemsOmmitted	This field reports blank.	N/A
Number OfItemsIncorrect	This field reports blank.	N/A
Associated CourseIndicator	This field reports blank.	N/A
RepeatIndicator	This field reports blank.	N/A
QuantileScore	This field reports blank.	N/A
Title1Status	This field reports blank.	N/A
TestBookletID	This field reports A, B, C, or D for grades 3-8 ELA and mathematics. When the Form field is null, this field reports blank. All other assessments report blank. Alphanumeric, 1 character	Student Information > General > Assessment > Test Score Detail > Form TestScore.Form
HolisticScore	This field reports blank.	N/A
State AccountabilityStatus	This field reports blank.	N/A
Testing LocationDistrictCode	This field reports blank.	N/A
Accountable LocationCode	This field reports blank.	N/A
Accountable LocationDistrictCode	This field reports blank.	N/A
StudentSnapshotDate	This field reports blank.	N/A
RegionalPercentile	This field reports blank.	N/A
Testing EnvironmentCode	This field reports blank.	N/A
Alternate Standard Achieved Code	This field reports blank.	N/A
Student Grade Level Code When Assessed	This field reports blank.	N/A
Growth Score	This field reports blank.	N/A
Student Met Standard Indicator	This field reports blank.	N/A
Primary Standard Achieved Score Type	This field reports blank.	N/A
Alternate Standard Achieved Score Type	This field reports blank.	N/A
Event Circumstance Code	This field reports blank.	N/A
Event Circumstance Comment	This field reports blank.	N/A
Rasch Score	This field reports blank.	N/A
Rasch Scaled Score	This field reports blank.	N/A
Platform Type	This field reports blank.	N/A
Pre-Slugged Test Booklet Indicator	This field reports blank.	N/A
Time Taken	This field reports blank.	N/A

Previous Versions

SIRS Assessment Fact (New York) [.2231 and previous]

SIRS Assessment Fact (New York)

Reporting Logic

Extract Editor

Assessment Fact Extract Layout

Previous Versions

Related Articles