SPRG0249

Duplicate SPRG Record within File



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


ACTIVE DEFECTS:

None

ERROR DESCRIPTION:

Only one record may exist in the file with the same SSID, School of Attendance, Education Program Code, and Education Program Membership Start Date unless Education Program Code = 122 (NCLB Title I Part A Basic Targeted)

FIELDS VALIDATED:

  • 3.07 - SSID
  • 3.05 - School of Attendance
  • 3.13 - Education Program Code
  • 3.15 - Education Program Membership Start Date

SUGGESTED RESOLUTION:

Understanding the Error:

A SPRG record may not be added if a record with the same SSID, School of Attendance, Education Program Code, and Education Program Membership Start Date that already exists in CALPADS ODS. Records with Education Program Code = 122 do not receive this error. Fall 1: also confirms that the SPRG Membership Start Date is between Fall 1 No Show from and Report through date before checking for other criteria.

Things to check for: Compare the record in the submission to the records that already exist for the student in CALPADS, or check for duplicate records within the submitted batch.

Suggested Resolution:

If you intended to make a change to an existing record, then submit the information as a change.

NOTES:

n/a

UPDATE:

11/2022 - updated Error # from SPRG0249 to SPRG0249F1 and suggested resolution to reflect Fall 1 reporting from/through dates

6/11/12 - Added

ADDITIONAL INFORMATION:

None



Need more help?

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