| 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 '2017Jun1.0StuCRSComp' |
CollectionVersion must be '2017Jun1.0StuCRSComp' |
The CollectionVersion identifies the data contained within the file and the Submission for that data. For this collection the CollectionVersion must be '2017Jun1.0StuCRSComp'. |
|
| 010 |
Current School Year |
SCC00402 |
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 |
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 S |
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 |
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, ReportingDistric |
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 |
StudentGradeLevel is invalid. |
|
| 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, ReportingD |
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 |
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 as |
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.Cou |
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 |
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. |
|