Student Assessment (FA) Downloads Mapping

The assessment downloads retrieves the assessments data stored in Test Scores. If you enter a Start Date and End Date, the download will only retrieve the selected assessments where the Test Date is within that date range. If the Start Date and End Date are blank, all records for the selected assessments will be processed. Refer to Assessment Downloads and Assessments (A) Submission Checklist for more details.

Prerequisites

The download period must be selected as Assessments (A). Select each assessment that you want to include in the download. Only the selected assessments will be generated.
The school must be associated with a student for the report to be valid.
The student is not excluded from state reporting.

The following fields have the same values for every download, along with fields: OVERRIDE_DOWNLOAD, RECORD_EDITED, CHANGE_DATE_TIME, and CHANGE_UID.

DISTRICT	FISCAL YEAR	PERIOD	DISTRICT_IRN	STUDENT_ID	EMIS_ID	ASSESS_TYPE_CODE	TESTING_DATE_EMIS
The environment	Prompt year	Download period prompt	reg_district.state_code_equiv	reg_entry_with.student_id	reg_user SCREEN_NUMBER = 616 AND FIELD_NUMBER = 30	The assessment being run	Format (Testing_Date, "YYYYMMDD")

The different assessment downloads include the following fields.

ASSESSMENT	TESTING_LEVEL	ASSESS_AREA_CODE	TESTING DATE	REQD_TEST_TYPE	STUDENT_GRADE	ACOMMODATIONS	WAIVER_REASON	SCORE
AC	**	Substring of the score’s state code equiv value Characters 3 through 6 Substring(Rtrim(ltdb_subtest_score.state_code_equiv), 3, 4)	ltdb_stu_subtest.test_date	STR	**	**	LTDB_SUBTEST_SCORE with a score code matching the score code of the score and in the subtest of “NOSCORE” if waiver is blank or null; report ”*”	LTDB_SUBTEST_SCORE with a state_code_equiv of 'ACM', 'ACR', 'ACS', 'ACW', or 'ACENG' if waiver is not “”; report “**”
AP	**	Left 4 characters of LTDB_SUBTEST_SCORE.STATE_CODE_EQUIV, for key values matching OH_V_AP_EXAMS	OH_V_AP_EXAMS.TEST_DATE	STR	**	**	*	OH_V_AP_EXAMS.SCORE
GA	Score from the “Grade” score. If not blank, LTDB_STU_TEST.SCORE. If blank, REG_GRADE.STATE_CODE_EQUIV for REG_ENTRY_WITH.GRADE record covering the test date.	ltdb_subtest.state_code_equiv characters 3 through 6 If ELA, use R Otherwise, use the value (M or S)	ltdb_stu_subtest.Test_date	ALT	ltdb_stu_test.grade → reg_grade.state_code_equiv	NO	LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive"; report ltdb_stu_subtest.score if the waiver is ““ or “~”; report “*” if score is "NS"; report “S”	LTDB_SUBTEST_SCORE with a state_code_equiv of "Score" report ltdb_stu_subtest.score if score is "","---","",""; report ““ if score is "N"; report “000“ if score is "NS"; report “*”
GB	PS	LTDB_SUBTEST.state_code_equiv minus the first 2 chars (all characters after “GB”)	ltdb_stu_subtest.Test_date	STR	PS	LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom" report ltdb_stu_subtest.score if blank; report NO if ~~; report **	LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" report ltdb_stu_subtest.score otherwise, report *	LTDB_SUBTEST_SCORE with a state_code_equiv of "Score" report ltdb_stu_subtest.score blank scores reported as * when a waiver is present if N; report . Report Waiver Reason as S. if NE; report . Report Waiver Reason as F. if Waiver Reason; report *
GE	**	LTDB_SUBTEST.state_code_equiv minus the first 2 chars if record is created from a course report EMIS Course -> EOC Assessment Area Screen = 600 Field = 80	ltdb_stu_subtest.Test_date if record is created from a course report EMIS District -> Test Date - Marks as EOC Score	STR	most recent grade on or before test date ISNULL(reg_grade.state_code_equiv,reg_entry_with.grade)	if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom3" has a ltdb_stu_subtest.score = Y; report Y3 if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom2" has a ltdb_stu_subtest.score = Y; report Y2 else if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom1" has a ltdb_stu_subtest.score = Y; report Y1 else NO If record is created from a course report NO	if LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" has a ltdb_stu_subtest.score = ""; report * else if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = NS; report S else LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" has a ltdb_stu_subtest.score if record is created from a course; report W	if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = "","___","","","NS"; report else if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = "N"; report 000 else; report LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score then if longer than 3 characters take 3 left most characters pad with leading 0s until 3 characters long if waiver = W, score = , and EMIS District ->Use EOC Points for GE Waiver W is checked check the student's courses for any with both EOC Mark Type and EOC Assessment Area filled in on the EMIS Course screen. Screen 600 fields 40 and 80 if the student has at least one course with a mark that matches the mark type selected on EMIS Course screen with a matching assessment area then report the highest first state code equiv on the level table else; report ** if on EMIS District -> Test Date - Marks as EOC Score has a date if a student has a course with both EOC Mark Type and EOC Assessment Area filled in on the EMIS Course screen create a GE record based off the course if they don’t already have one for the assessment area Screen 600 fields 40 and 80 if the student has at least one course with a mark that matches the mark type selected on EMIS Course screen for an assessment area then report the highest first state code equiv on the level table do not report any assessment areas they do not have marks in
GF	**	LTDB_SUBTEST.state_code_equiv minus the first 2 chars	ltdb_stu_subtest.Test_date	ALT if ltdb_stu_subtest.score is ALT where the connected LTDB_SUBTEST_SCORE has a state_code_equiv of "TEST" otherwise STR	ltdb_stu_test.grade → reg_grade.state_code_equiv if blank then most recent grade on or before test date ISNULL(reg_grade.state_code_equiv,reg_entry_with.grade)	if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom2" has a ltdb_stu_subtest.score = Y; report Y2 else if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom1" has a ltdb_stu_subtest.score = Y; report Y1 else; report NO	if LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" has a ltdb_stu_subtest.score = ""; report * else if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = NS; report S else LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" has a ltdb_stu_subtest.score	if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = "","___","","","NS"; report ** else if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = "N"; report 000 else; report LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score then if longer than 3 characters take 3 left most characters pad with leading 0s until 3 characters long
GM	PS	LTDB_SUBTEST.state_code_equiv and LTDB_SUBTEST.state_code_equiv + “PRG”	ltdb_stu_subtest.Test_date	LTDB_SUBTEST_SCORE with a state_code_equiv of "TEST" report ltdb_stu_subtest.score if blank report STR	PS	NO	LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive"; report ltdb_stu_subtest.score if blank or ~; report *	LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE"; report ltdb_stu_subtest.score and LTDB_SUBTEST_SCORE with a state_code_equiv of "PROGRESS"; report ltdb_stu_subtest.score if “~” or ““ or waiver present; report “***”
GN	LTDB_SUBTEST_SCORE with a state_code_equiv of "GRADE" has a ltdb_stu_subtest.score, if that is not present use the grade from the student test header. If neither, use the student grade	LTDB_SUBTEST.state_code_equiv minus the first 2 chars; Special Scenario for ELA tests for grade 03, A second record will be created for students in grade 3; reporting grade three reading score with and assessment area of “R”	ltdb_stu_subtest.Test_date	STR when ASSESSMENT TYPE = OCBA, ALT when ASSESSMENT TYPE = AASCD	Most recent grade on or before test date ISNULL(reg_grade.state_code_equiv,reg_entry_with.grade) If no grade on or before test date use first grade after test date	Update from research on ESP-75837 - Y3,Y2,Y1 only set if “ACCOM” is “Y” if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom3" has a ltdb_stu_subtest.score = Y; report Y3 if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom2" has a ltdb_stu_subtest.score = Y; report Y2 else if LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom1" has a ltdb_stu_subtest.score = Y; report Y1 else; report NO	if LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" has a ltdb_stu_subtest.score = ""; report * else if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = NS; report S else; report LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" has a ltdb_stu_subtest.score	if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = "","___","","","NS"; report ** else if LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score = "N"; report 000 else; report LTDB_SUBTEST_SCORE with a state_code_equiv of "SCORE" has a ltdb_stu_subtest.score then if longer than 3 characters; take 3 left most characters Pad with leading 0s until 3 characters long
GO	KG	LTDB_SUBTEST.state_code_equiv minus the first 2 chars	ltdb_stu_subtest.Test_date	STR	KG	LTDB_SUBTEST_SCORE with a state_code_equiv of "Accom" report ltdb_stu_subtest.score if the score is “”; report “NO” If the score is “~~”; report “**”	LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" report ltdb_stu_subtest.score if the waiver is ““ or “~”; report “*” if score is "NS"; report “S”	LTDB_SUBTEST_SCORE with a state_code_equiv of "Score" report ltdb_stu_subtest.score if score is "","---","",""; report ““ if score is "N"; report “000“ if score is "NS"; report “*”
GW	**	LTDB_SUBTEST_SCORE with a state_code_equiv of "FA205GW" report ltdb_stu_subtest.score compare against OHTB_INDUSTRY_CREDENTIALS joined to OH_EMIS_CONFIG for days code is valid if code is not in OHTB_INDUSTRY_CREDENTIALS report ERR and log error if test date is not within the valid days for code then report the code but log an error	ltdb_stu_subtest.Test_date	LTDB_SUBTEST_SCORE with a state_code_equiv of "FA215GW" report ltdb_stu_subtest.score if "" then STR if not STR, IPD, or INP then log error but still create record	**	**	*	LTDB_SUBTEST_SCORE with a state_code_equiv of "FA240GW" report ltdb_stu_subtest.score if score <> N; report P
GX	10	ltdb_subtest.state_code_equiv convert code: GNM, GEMTH1, GEMTH2, GEALG1, GEGEOM M GNS, GEPHYS, GEBIOL S GNELA, GEELA1, GEELA2 R GNC, GEGOVM, GEHIST C	ltdb_stu_subtest.Test_date	ALT	ltdb_stu_test.grade → reg_grade.state_code_equiv	NO	LTDB_SUBTEST_SCORE with a state_code_equiv of "Waive" report ltdb_stu_subtest.score If the waiver is ““ or “~”; report “*” if score is "NS"; report “S”	LTDB_SUBTEST_SCORE with a state_code_equiv of "Score" report ltdb_stu_subtest.score if score is "","---","",""; report ““ if score is "N"; report “000“ if score is "NS"; report “*”
GY	**	ltdb_stu_subtest.score where score_code = ‘CODE’, if the subtest of the score is “TECH” and creating the record based on a test score ltdb_stu_subtest.subtest where the subtest of the score is not “TECH” and creating the record based on a test score schd_ms_user.field_value (or schd_course_user.field_value) where screen_number = 600 and field_number = 90, when creating the record based on course marks	ltdb_stu_subtest.Test_date when creating the record based on a test score reg_user_district.field_value where screen_number = 600 and field_number = 50 when creating the record based on a course mark	STR	**	**	ltdb_stu_subtest.score where score_code = ‘ScoreNot' (or “*” when score is blank) when creating the record based on a test score “X” when creating the record based on a course mark	ltdb_stu_subtest.score where score_code = ‘INDIC' when creating the record based on a test score and the assessment_area_code starts with two numeric values ltdb_stu_subtest.score where score_code = ‘TSCORE' when creating the record based on a test score and the assessment_area_code starts with two alpha character values ltdb_stu_subtest.score where score_code = ‘TSCORE' when creating the record based on a test score and the assessment_area_code = ‘14TP’. A separate record will be created in this case, using the score where score_code = ‘PSCORE’ (see above) The fourth element in the comma-delimited value in mr_level_marks.state_code_equiv, when using course marks. The mark used will be from mr_stu_marks.mark_value.
IB	**	ltdb_subtest_score.state_code_equiv	ltdb_stu_subtest.test_date	STR	**	**	*	ltdb_stu_subtest.score, where the corresponding ltdb_subtest_score.state_code_equiv value has a record with the same state_code_equiv in ohtb_international_baccalaureate
SA	**	Substring of the score’s state code equiv Characters 3 through 6 Substring(Rtrim(ltdb_subtest_score.state_code_equiv), 3, 4)	ltdb_stu_subtest.test_date	STR	**	**	LTDB_SUBTEST_SCORE with a score code matching the score code of the score and in the subtest of “NOSCORE” if waiver is blank or null; report ”*”	LTDB_SUBTEST_SCORE with a state_code_equiv of 'SAM','SAR','SAW' if waiver is not “”; report “**”
WK	**	Substring on the score’s state code equiv, characters 3 through 6	ltdb_stu_subtest.test_date	STR	**	**	*	ltdb_subtest_score with a state_code_equiv of WKM, WKR, WKLCIF, WKAMTH, WKGLIT, WKWDOC. Only report the highest score earned for a specific subtest. Do not report blank, 0, or “>3” scores.
DS	**	test - SCE, translated through OHTB_TIER_1_DYSLEXIA_SCREENER From the screen: EMIS District Field: DS Test Area Code	ltdb_stu_subtest.test_date	STR	ltdb_stu_test.grade → reg_grade.state_code_equiv From the year 2024, all students from grades 1-3 will be included. For less than 2024 grade K, and any students grades 1-6 will be included.	LTDB_SUBTEST_SCORE of "Accom" report ltdb_stu_subtest.score if blank; report NO if ~~; report **	This value will be from the LTDB_STU_SUBTEST score code using the settings from oh_v_emis_district(TIER_1_DYS_TEST_KEY, TIER_1_DYS_SUBTEST, TIER_1_DYS_SCORE_NOT_REPORTED)	SCE from OHTB_TIER_1_DYSLEXIA_SCORE This value will be from the LTDB_STU_SUBTEST score code using the settings from oh_v_emis_district(TIER_1_DYS_TEST_KEY, TIER_1_DYS_SUBTEST, TIER_1_DYS_SCORE)
RD	**	test - SCE, translated through OHTB_READING_DIAGNOSTIC	ltdb_stu_subtest.test_date		ltdb_stu_test.grade → reg_grade.state_code_equiv	**	This value will be from the LTDB_STU_SUBTEST score code using the settings from oh_v_emis_district(READING_DIAGNOSTIC_TEST_KEY, READING_DIAGNOSTIC_SUBTEST, READING_DIAGNOSTIC_NOT_REPORTED)	SCE from OHTB_READING_DIAGNOSTIC_SCORE This value will be from the LTDB_STU_SUBTEST score code using the settings from oh_v_emis_district(READING_DIAGNOSTIC_TEST_KEY, READING_DIAGNOSTIC_SUBTEST, READING_DIAGNOSTIC_SCORE)