| 005 |
Collection Version |
SCC00001 |
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 |
SCC00201 |
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 |
SCC00401 |
E |
CollectionVersion must match '2019Jun1.0StuCRSComp' |
CollectionVersion must be '2019Jun1.0StuCRSComp' |
The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2019Jun1.0StuCRSComp'. |
|
| 010 |
Current School Year |
SCC00402 |
E |
CurrentSchoolYear must match '2019' |
CurrentSchoolYear must be '2019' |
The CurrentSchoolYear identifies the school year for the data. For this collection the CurrentSchoolYear must be '2019'. |
|
| 025 |
Reporting District Code |
SCC00441 |
E |
ReportingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. |
Invalid ReportingDistrictCode code |
The ReportingDistrictCode is not a valid district code. |
|
| 025 |
Reporting District Code |
SCC00700 |
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 |
SCC00602 |
E |
ReportingSchoolCode must be a valid school code in the Reporting District (Reporting District Code) Use MOSIS Attendance Center tables. |
Invalid ReportingSchoolCode |
The Reporting School Code is not a valid school code in the Reporting District Code. |
|
| 032 |
Receiving Coll/Dist Code |
SCC00464 |
E |
ReceivingCollDistCode must match a valid District Code in v_DESE_DISTRICT_PUB_PRIV_STATE_HIGH matching the CurrentSchoolYear |
Invalid ReceivingCollDistCode code |
ReceivingCollDistCode is not valid. |
|
| 032 |
Receiving Coll/Dist Code |
SCC01301 |
E |
If ReceivingColDistCode is not null then SendingDistrictCode is required. |
SendingDistrictCode is required |
SendingDistrictCode is required with ReceivingCollDistCode |
|
| 032 |
Receiving Coll/Dist Code |
SCC01302 |
E |
RecevingColDistCode is required if DualCreditSite is not null |
RecevingColDistCode is required |
RecevingColDistCode is required with DualCreditSite. |
|
| 032 |
Receiving Coll/Dist Code |
SCC01303 |
W |
ReportingSchoolCode is not (1100-1199 or 0000) then RecevingColDistCode, ReportingDistrictCode, and SendingDistCode cannot be the same. |
ReportingDistrictCode, SendingDistrictCode, and ReceivingCollDistCode should not match |
ReportingDistrictCode, SendingDistrictCode, and ReceivingCollDistCode should not match unless the student is being sent to an area career center or another high school in your district. |
|
| 034 |
Sending District Code |
SCC00447 |
E |
SendingDistrictCode must match a valid DESE County District Code. District codes are in DESE District table. |
Invalid SendDistCode code |
SendDistCode is not a valid district code. |
|
| 034 |
Sending District Code |
SCC01400 |
E |
If SendingDistrictCode is not null then ReceivingColDistCode is required. |
ReceivingCollDistCode is required |
ReceivingCollDistCode is required with SendingDistrictCode |
|
| 034 |
Sending District Code |
SCC01401 |
E |
SendingDistrictCode is required if DualCredSite is not null. |
SendingDistrictCode is required |
SendingDistrictCode is required with DualCreditSite. |
|
| 034 |
Sending District Code |
SCC01402 |
E |
If ReportingDistrictCode is not 048078, 096119 or 115115 and ReportingSchoolCode = (1100-1199 or 0000) then SendingDistrictCode is required. |
SendingDistrictCode is required with ReportingSchoolCode |
SendingDistrictCode is required since ReportingSchoolCode is 0000 or 1100-1199. |
|
| 036 |
Sending School Code |
SCC01403 |
E |
SendingSchoolCode is required if SendingDistrictCode is not null. |
SendingSchoolCode is required with SendingDistrictCode |
SendingSchoolCode is required with SendingDistrictCode. |
|
| 036 |
Sending School Code |
SCC01404 |
E |
SendingSchoolCode must be a valid school code in the Sending District (Sending District Code). Use MOSIS District Table and MOSIS Attendance Center tables. |
SendingSchoolCode is not valid for SendingDistrictCode |
SendingSchoolCode is not a valid school code for the SendingDistrictCode. |
|
| 045 |
MOSIS ID |
SCC00467 |
W |
SCC.StateID must exist in the Current Year Certified June Student Enrollment and Attendance (SEA) for the ReportingDistrictCode with a sum of RegHrsAttnd > 0. This rule ensures that if a student was reported in the June SCC file they show up in the June Student Enrollment and Attendance. |
StateID not found in certified June Student Core/Enrollment Attendance |
StateID was not found in the certified June Enrollment Attendance. Any student reported in the June Student Course Completion should also exist in the certified June Student Core/Enrollment Attendance. |
|
| 045 |
MOSIS ID |
SCC00468 |
W |
Using the Current Year Certified June Student Enrollment and Attendance (SEA) for the ReportingDistrictCode. All SEA.StateID which have a sum of SEA.RegHrsAttended >= 1 where SEA.ReportingSchoolCode is not (1100-1199 or 0000) and and SEA.ResidencyStatus is not R2 and SEA.StudentGradeLevel is ('07','08','09','10','11','12') must have a record in the June Student Course Completion with the key of CurrentSchoolYear, ReportingDistrictCode, and StateID. This rule ensures that if a student was reported in the June SEA file in the correct grades and school and had at least 1 hour of attendance they show up in the June Completion. |
StateID not found in June Student Course Completion |
StateID was reported in June Student Core/Enrollment Attendance, but was not found in June Student Course Completion. See "Jun. StateID missing Course Completion" report for individual State Identifiers. |
|
| 045 |
MOSIS ID |
SCC00477 |
W |
Using the Certified October Student Assignment (STA) for the ReportingDistrictCode. All STA.StateID with a student grade level 7, 8, 9, 10, 11, 12 must have a record in the June Student Course Completion with the key of CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum, StateID unless CRS.AssignEndDate is not null. This rule ensures that if a student was reported in the October Assignment that they show up in the June Completion. |
StateID not found in June Student Course Completion |
StateID was reported in October Student Assignment, but was not found in June Student Course Completion. See "Oct. StateID missing Course Completion" report for individual State Identifiers. |
|
| 045 |
MOSIS ID |
SCC01001 |
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. |
|
| 080 |
Student Date of Birth |
SCC00446 |
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. |
|
| 095 |
Student Grade Level |
SCC00404 |
E |
Must be in code set: (Student_Grade_Level_Codes). |
Invalid StudentGradeLevel code |
Student Grade Level must be a valid code in the Student Grade Level Codes. |
|
| 111 |
ED SSN |
SCC00460 |
E |
The Social Security Number must 9 digits with no extra characters such as spaces and dashes. |
EDSSN must be 9 digits |
The Social Security Number must be specified as 9 digits. |
|
| 111 |
ED SSN |
SCC00461 |
E |
EDSSN is required if SCC.ReportingDistrictCode is not 118118 and ((SCC.ReceivingCollDistCode is equal to SCC.ReportingDistrictCode) or SCC.ReceivingCollDistCode is null) and October CRS.courseprogramcode is not 50 matching on CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum. |
EDSSN is required |
EDSSN is required since ReceivingCollDistCode is equal to ReportingDistrictCode or ReceivingCollDistCode is null and Cousre Program Code is not 50. |
|
| 111 |
ED SSN |
SCC00500 |
E |
EDSSN is not allowed if DualCreditSite is COLL and October CRS.CourseDeliverySys is not (V, VH, or begins with S) matching on CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, Edssn, PosCode, CTEProgType, AssignNum. |
EDSSN is not allowed |
EDSSN is not allowed since DualCreditSite is COLL. |
|
| 117 |
Position Code |
SCC00442 |
E |
Must be in code set: (Position_Codes). |
Invalid PosCode code |
Position Code is not valid. |
|
| 117 |
Position Code |
SCC00478 |
W |
SCC.PosCode must be 60. |
Unexpected PosCode |
PosCode is expected to be 60. |
|
| 119 |
CTE Program Type |
SCC00443 |
E |
Must be in code set: (CTE_Program_Type_Codes) |
Invalid CTEProgType code |
CTEProgType is not valid. |
|
| 120 |
Assignment Number |
SCC00465 |
E |
If AssignNum is not null Then CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, CTEProgType, PosCode, and AssignNum must match a record in the current year certified October Course Assignment where the CRS.AssignEndDate is null. |
AssignNum was not reported in October |
AssignNum was not reported in October Course Assignment. Must have a record that matches CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum and the AssignEndDate must be null. |
|
| 120 |
Assignment Number |
SCC00466 |
W |
Join the current year certified Oct Course Assignment (CRS) and Student Assignment (STA) on trial_id, EDSSN, CTEProgType, PosCode, and AssignNum and STA.StudentGradeLevel in 7, 8, 9, 10, 11, 12. Verify for the Current Year that each unique instance of STA.EDSSN, STA.CTEProgType, STA.PosCode, and STA.AssignNum where CRS.AssignEndDate is null exists in the June Student Course Completion Collection. This rule is to ensure students are reported in the June Student Course Completion for a particular assignment if students were reported in October for that assignment and it was not ended. |
Course Completion missing |
Assignments were found in October which do not have students reported. See "Oct. Assignments missing Course Completions" report for information about specific assignments. |
|
| 130 |
State Course Number |
SCC00449 |
E |
Must be in code DESE_DC_COURSE for the CurrentSchoolYear |
Invalid CourseNum code |
CourseNum is not valid. |
|
| 130 |
State Course Number |
SCC00469 |
W |
Using the Certified October Course Assignment for the ReportingDistrictCode the CourseNum must match. Key: CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum unless October Course Num for the matching assignment is 994210 or null. |
CourseNum does not match October |
CourseNum does not match the CourseNum of the educators assigment reported in October Course Assignment. |
CourseNum {0} reported in the June Student Course Completion does not match the CourseNum {1} reported in the October Course Assignment. |
| 190 |
Course Time Unit |
SCC00481 |
E |
Must be in code set: (Course_Time_Unit_Codes) |
Invalid CourseTimeUnit code |
CourseTimeUnit code must be one of (Q1, Q2, Q3, Q4, S1, S2, T1, T2, T3, YL). |
|
| 190 |
Course Time Unit |
SCC00482 |
E |
Using the Certified October Course Assignment for the ReportingDistrictCode the CourseNum must match. Key: CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, PosCode, CTEProgType, AssignNum. CourseTimeUnit cannot match another SCC.CourseTimeUnit with the same SCC.CurrentSchoolYear, SCC.ReportingDistrictCode, SCC.ReportingSchoolCode, SCC.EDSSN, SCC.CTEProgType, SCC.PosCode, SCC.AssignNum, and SCC.StateId unless CRS.CourseNum is 994210 or null in the matching October Assignment. |
Student reported more than once for CourseTimeUnit |
CourseTimeUnit cannot match another CourseTimeUnit with the same CurrentSchoolYear, ReportingDistrictCode, ReportingSchoolCode, EDSSN, CTEProgType, PosCode, CourseNum, and StateId. |
|
| 191 |
Dual Credit Site |
SCC00445 |
E |
Must be in code set: (Dual_Credit_Site_Codes). |
Invalid DualCreditSite code |
DualCreditSite must be one of ACC, DIST, COLL, or ITV. |
|
| 191 |
Dual Credit Site |
SCC01500 |
E |
If DualCreditSite is null then the combination of ReportingDistrictCode and ReportingsSchoolCode must be different than the combination of SendingDistrictCode and SendingSchoolCode. |
Reporting district and school cannot be the same as sending district and school |
ReportingDistrictCode and ReportingSchoolCode cannot match SendingDistrictCode and SendingSchoolCode since DualCreditSite is not provided. |
|
| 191 |
Dual Credit Site |
SCC01501 |
E |
If RecevingColDistCode does not equal the ReportingDistrictCode and the RecevingColDistCode exists in srm.dbo.v_dese_district_high (is a college) then DualCreditSite is required. |
DualCreditSite is required |
DualCreditSite is required since ReportingDistrictCode is a school district and the RecevingColDistCode is a college. |
|
| 191 |
Dual Credit Site |
SCC01502 |
E |
If ReportingDistrictCode is not (‘126126’, ‘145145’, ‘166166’, ‘640121’) and DualCreditSite is Null and RecevingColDistCode is in (‘126126’, ‘145145’, ‘166166’, ‘640121’) then record is not allowed to be reported. |
DualCreditSite is expected |
This record should be removed. Only area career centers report students attending area career center classes. |
|
| 191 |
Dual Credit Site |
SCC01503 |
E |
DualCreditSite cannot be 'DIST', 'COLL', or 'ACC' unless ReceivingColDistCode exists in srm.dbo.v_DESE_DISTRICT_HIGH. Matching ReceivingColDistCode to CNTY_DIST_CODE and currentschoolyear to Year. |
DualCreditSite is not valid |
DualCreditSite is not valid since ReceivingCollDistCode is not a college. |
|
| 191 |
Dual Credit Site |
SCC01504 |
E |
DualCreditSite cannot be 'ITV' if ReportingDistrictCode = SendDistCode and ReportingSchoolCode = SendSchoolCode unless ReceivingColDistCode begins with 999 or exists in srm.dbo.v_DESE_DISTRICT_HIGH or. Matching ReceivingColDistCode to CNTY_DIST_CODE and currentschoolyear to Year. |
DualCreditSite is not valid |
DualCreditSite cannot be ITV since Reporting District and School information match Sending District and School information and ReceivingCollDistCode is not a college. You cannot send students to an ITV class that you broadcast. |
|
| 192 |
Course Semester |
SCC00479 |
E |
Must be in code set: (Course_Semester_Codes) |
Invalid CourseSem code |
CourseSem is not valid. |
|
| 193 |
Student Credits Earned |
SCC00470 |
E |
CreditEarned does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. |
CreditEarned has an invalid format |
CreditEarned does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. |
|
| 193 |
Student Credits Earned |
SCC00471 |
W |
If CreditEarned is not null it must be zero or inclusively be between 0.25 and 7.00 |
CreditEarned is not in valid range |
CreditEarned should be between 0.25 and 7.00. |
|
| 193 |
Student Credits Earned |
SCC00485 |
W |
If StudentGradeLevel is 09, 10, 11, or 12 and GradeEarned is not equal to F, PS, FL, IC, NC, or WD then CreditEarned cannot equal zero. |
CreditEarned is not valid |
CreditEarned should be between 0.25 and 7.00. |
|
| 195 |
Student Credits Scheduled |
SCC00472 |
E |
CreditScheduled does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. |
CreditScheduled has an invalid format |
CreditScheduled does not have a valid format. It may have 1 digit followed by an optional decimal point and 1 or 2 digits. |
|
| 195 |
Student Credits Scheduled |
SCC00473 |
W |
If CreditScheduled is not null it must be zero or inclusively be between 0.25 and 7.00 |
CreditScheduled is not in valid range |
CreditScheduled should be between 0.25 and 7.00. |
|
| 201 |
Student Grade Earned |
SCC00474 |
E |
Must be in code set: (Grade_Codes). |
Invalid GradeEarned code |
GradeEarned must be A, A- ,B+ ,B ,B- ,C+ ,C ,C- ,D+ ,D ,D- ,F ,PS ,FL ,IC ,NC or WD. |
|
| 205 |
Advanced Placement |
SCC00475 |
E |
Must be in code set: (Yes_No) |
Invalid AdvPlacement code |
AdvPlacement must be in Y or N. |
|
| 207 |
Honors |
SCC00476 |
E |
Must be in code set: (Yes_No) |
Invalid Honors code |
Honors must be in Y or N. |
|
| 235 |
Course Sequence Number |
SCC00483 |
E |
Must be in code set: (Course_Seq_Num_Codes) |
Invalid CourseSeqNum code |
CourseSeqNum is not valid. |
|
| 235 |
Course Sequence Number |
SCC00484 |
W |
CRS.CourseSeqNum must be 0 or null if CRS.CourseNum is Null. |
CourseSeqNum must be 0 or Null |
CourseSeqNum must be 0 or null since CourseNum is null. |
|