SPRG0070

Overlapping Program Records


Submission: SPRG
Status: Active
Severity: Fatal
Input Validation: X
Data Discrepancy: N/A


ACTIVE DEFECTS:

None

ERROR DESCRIPTION:

SSID has an existing/matching overlapping Education Program record existing in Staging or ODS

FIELDS VALIDATED:

  • 3.05 - School of Attendance
  • 3.13 - Education Program Code
  • 3.15 - Education Program Membership Start Date
  • 3.16 - Education Program Membership End Date
  • 3.17 - Education Service Academic Year
  • 3.18 - Education Service Code

SUGGESTED RESOLUTION:

Understanding the Error:

Following conditions were detected: For program records where Education Program Code is NOT 122 (i) In the ODS, the student has an existing program record with the SAME Education Program code and SAME school as the SPRG record that is being submitted AND (ii) The Submitted SPRG program start date and/or end date (Education Program Membership Start Date - End Date) are overlapping with the existing program record in ODS. OR For program records where Education Program Code = 122
(i) Student has an existing OVERLAPPING program record with the SAME Education Program code, SAME school, SAME Education Service Academic Year, and SAME Education Service Code in ODS AND (ii) Submitted Education Program Membership Dates (Education Program Membership Start Date - End Date) overlap with this existing program record.

Things to check for: Verify that the fields listed in the Fields Validated column are correct in the submitted file.

Suggested Resolution:

1) Identify the existing program record in conflict and change the Education Program Membership Date (Education Program Membership Start - End Date) in the submission so it does not overlap with the existing program record in ODS. OR 2) If the School of Attendance is incorrectly populated in the submission, change it so the correct value is submitted to CALPADS for the student program record of the SSID. OR 3) If the Education Program Code is incorrectly populated in the submission, change it so the correct value is submitted to CALPADS for the student program record of the SSID. OR 4) If the Service Academic Year and Education Service Code are in correctly populated in the submission, change it so the correct value is submitted to CALPADS for the student program record of the SSID. Note: You need the "Free Reduced Lunch" role to see NSLP program records. If you get this error (SPRG0070), but do not see a conflicting record, check with your LEA admin to make sure you have the "Free Reduced Lunch" role.

NOTES:

n/a

UPDATE:

9/2022 - Moved from DD to IVR (File Input)

1/21/16 Updated Error Name, Error Description and Suggested Resolution.

ADDITIONAL INFORMATION:

None


Need more help?

Let's start the conversation by filling out the CALPADS Service Request Form.



Create a ticket