FileSpecRules:201700LEP-ELLAssessmentPre-Code

Item_Number

Item_Name

Collection_Rule_ID

Severity

Business_Rule

Short_Title

General_Message

Detailed_Message

005

Collection Version

ASM00001

E

Some fields supply data that is essential for the analysis of student data. The value of that field must be explicit. There are no default values.

One or more required fields are missing

Some fields supply data that is essential for the analysis of data. A value must be provided. There are no default values.

The record is missing the field {0}.

005

Collection Version

ASM00201

E

Field exceeds its maximum length

Field exceeds its maximum length

Field exceeds its maximum length.

The {0} field exceeds its maximum allowable length of {1} character(s).

005

Collection Version

ASM00401

E

CollectionVersion must match '2017LEPELL1.0AsmPre'

CollectionVersion must be '2017LEPELL1.0AsmPre'

The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2017LEPELL1.0AsmPre'

005

Collection Version

ASM01600

E

There must be at least one Assessment Pre-Code record

There are no Assessment Pre-Code records

There must be at least one Assessment Pre-Code record.

010

Current School Year

ASM00402

E

CurrentSchoolYear must match '2017'

CurrentSchoolYear must be '2017'

The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2017'.

025

Reporting District Code

ASM00441

E

ReportingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table.

Invalid ReportingDistrictCode code

ReportingDistrictCode is not a valid district code.

025

Reporting District Code

ASM00700

E

ReportingDistrictCode must match the SRM user's district code.

The student is not from this district

The student's ReportingDistrictCode does not equal that of the trial.

030

Reporting School Code

ASM00602

E

ReportingSchoolCode must be a valid school code in the Reporting District (Reporting District Code) Use MOSIS District Table and MOSIS Attendance Center tables.

ReportingSchoolCode is not valid for ReportingDistrictCode

ReportingSchoolCode is not a valid school code for the ReportingDistrictCode.

030

Reporting School Code

ASM00612

E

If ReportingSchoolCode = 1000 then StudentGradeLevel must be 'PK'

ReportingSchoolCode is not valid for StudentGradeLevel

ReportingSchoolCode of 1000 is not allowed for grades K-12.

030

Reporting School Code

ASM00888

E

ReportingSchoolCode cannot begin with 102 or 103 unless (ReportingDistrictCode is 002017) or (ReportingDistrictCode/ReportingSchoolCode combination is 010093/1020 or 090078/1030).

ReportingSchoolCode should not begin with 102 or 103

ReportingSchoolCode should not begin with 102 or 103 since school codes which begin with 102 and 103 are reserved for schools which do not have enrollments.

050

MOSIS Student ID

ASM01001

E

State ID verified against ID system SIDMASTER (State_Student_ID)

StateID not found in MOSIS ID

The State ID was not found in the MOSIS ID system.

050

MOSIS Student ID

ASM01064

E

StateID must be unique for all records with the same Assessment (Duplicated student for the same assessment is not allowed)

Duplicated student for the same assessment is not allowed

Duplicated student for the same assessment is not allowed.

050

MOSIS Student ID

ASM01070

E

Reportingschoolcode must be the same across all records with the same StateID (State ID cannot exist in more than one building)

State ID cannot exist in more than one building

State ID cannot exist in more than one building.

080

Date of Birth

ASM00446

E

DateOfBirth must be a valid date.

DateOfBirth is not a valid date

The date is not valid. A date must be in MM/DD/YYYY format and be a valid date.

080

Date of Birth

ASM01020

E

Date of Birth verified against ID system (in conjunction with State ID) SIDMASTER (Date_of_Birth) and SIDMASTER (State_Student_ID)

DateOfBirth does not match MOSIS ID

The date of birth reported does not match the date of birth in the MOSIS ID system.

095

Student Grade Level

ASM00404

E

Must be in code set: (Student_Grade_Level_Codes).

Invalid StudentGradeLevel code

StudentGradeLevel must be PK, K, KA, KP, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11 or 12.

095

Student Grade Level

ASM01062

W

If StudentGradeLevel = KA then verify record exists in Calendar_Header table where reportingdistrictcode = fk_dist_cnty_dist and currentschoolyear = fk_dist_year and begin_grade = (space K) and end_grade = (space K) and KINDERGARTEN_INDICATOR = A

StudentGradeLevel does not exist in Calendar

StudentGradeLevel KA does not exist in Core Data Calendar.

095

Student Grade Level

ASM01063

W

If StudentGradeLevel = KP then verify record exists in Calendar_Header table where reportingdistrictcode = fk_dist_cnty_dist and currentschoolyear = fk_dist_year and begin_grade = (space K) and end_grade = (space K) and KINDERGARTEN_INDICATOR = P

StudentGradeLevel does not exist in Calendar

StudentGradeLevel KP does not exist in Core Data Calendar.

095

Student Grade Level

ASM01065

W

Student Grade Level must be the same for all records with matching StateIDs

StudentGradeLevel must be the same for StateID

StudentGradeLevel must be the same for StateID

095

Student Grade Level

ASM01080

E

Reference MO-2007-21-2007-K8 Indicator Business Rules-V1.2-JY.doc (This is simliar to SEA01061 except for against the ReportingDistrictCode and ReportingSchoolCode)

StudentGradeLevel not taught in reporting school

The StudentGradeLevel is not taught in the reporting school.

100

Gender

ASM00405

E

Must be in code set: (Gender_Codes).

Gender must be M or F

Gender must be M or F.

100

Gender

ASM01066

E

Gender must be the same for all records with matching StateIDs

Gender must be the same for StateID

Gender must be the same for StateID

105

Race/Ethnicity

ASM00406

E

Must be in code set: (Race_Ethnicity_Codes).

Invalid RaceEthnicity code

RaceEthnicity must be A, B, H, I or W, P or M.

105

Race/Ethnicity

ASM01067

E

RaceEthnicity must be the same for all records with matching StateIDs

RaceEthnicity must be the same for StateID

RaceEthnicity must be the same for StateID

110

Assessment

ASM01068

E

Must be in code set: (ASMNT_TYPE_CODES).

Invalid Assessment code

Assessment must be MAPSPR, EOCFAL, EOCSUM, or EOCSPR.

110

Assessment

ASM01069

W

If Assessment = 'MAPSPR' then StudentGradeLevel must be '03','04','05','06','07', or '08'

Assessment is not valid for StudentGradeLevel

Assessment MAPSPR expects StudentGradeLevel of 03, 04, 05, 06, 07, or 08.

110

Assessment

ASM01081

E

Assessment must match the 6 characters following the year in the collectionversion. substring(collectionversion,5, 6)

Assessment does not match Collectionversion

The type of Assessment reported does not match the Assessment type indicated in the CollectionVersion. This record will not be used.

115

Testing Method

ASM01071

E

Must be in code set: (ASMNT_Test_Method_Codes).

Invalid TstMethod code

TstMethod must be PENPAP or ONLINE.

115

Testing Method

ASM01072

E

Required if Assessment is EOCFAL, EOCSUM, or EOCSPR.

TstMethod is required when Asssement is for End of Course

TstMethod is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.

140

Subject

ASM01075

E

Required if Assessment is EOCFAL, EOCSUM, or EOCSPR.

Subject is required when Asssement is for End of Course

Subject is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.

140

Subject

ASM01076

E

Must be unique with StateID, Subject, and Assessment within the file. Each student can only be reported once per Subject per Assessment type.

Subject can only be reported once per StateID

Subject can only be reported once per StateID.

140

Subject

ASM01079

E

Must be in code set: (ASMNT_Subject_Codes).

Invalid Subject code

Subject must be a valid Assessment Subject code.

145

Period

ASM01077

E

Required if Assessment is EOCFAL, EOCSUM, or EOCSPR.

Period is required when Asssement is for End of Course

Period is required when Assessment is EOCFAL, EOCSUM, or EOCSPR.

150

Sort

ASM01078

W

If Assessment is 'MAPSPR' then SORT value is expected.

Sort is allowed for MAP Labels

Sort field is allowed for all MAP Labels.

155

Examiner Email

ASM01090

E

Examiner Email must match a valid email format. A valid email address is one or more characters, a ampersand, one or more characters, a period, one or more characters.

Examiner Email has an invalid email format

Examiner Email has an invalid email format.