Change Date 10/28/2014 Updated Result Codes and Messages - Added B8, N8, SA3, SA4, SP2, T9 and T10 Change Date 10/07/2014 Removed 2014 PARCC Pre-ID File Format Layout Change Date 09/19/2014 Removed Student Discipline File Format Layout Added Student Disicpline Groups File Format Layout Change Date 09/05/2014 Updated Result Codes and Messages Updated N10 Removed N8 Change Date 09/04/2014 Added SAPID back to the Student Address File Format Layout Change Date 09/03/2014 Changed length of Section Number to 16 in both Student Course Assignment and Teacher Course Assignment. Change Date 08/15/2014 Removed SAPID from Student Address File Format Layout Change Date 05/19/2014 Updated Student Demographics File Format Layout (Eligible for Immigrant Indicator – Optional, Migrant Indicator – Optional) Updated Demographics and Early Childhood File Format Layout (Eligible for Immigrant Indicator – Optional, Migrant Indicator – Optional) Assessment Correction (Migrant Indicator – Optional) Added Immigrant File Format Layout Added Student Address File Format Layout Added Service Provider File Format Layout Updated Student Course Assignment File Format (Artculated Credit – Optional) Updated College Course File Format (Artculated Credit – Optional) Updated Oiutside Course Assignment File Format (Artculated Credit – Optional) Added Result Codea and Result Messages for Immigrant Program (IP), Student Address (SA), and Service Provider (SP) Change Date 03/27/2014 Added ACCESS Correction Bacth Result Codes and Messages “W” Updated ECO “J8” Result Message Change Date 01/14/2014 Added PARCC PreID Batch Result Codes and Messages “V” Change Date 01/08/2014 Added PARCC PreID File Format Layout Change Date 12/17/2013 Updated Batch result codes and Messages – U1: To allow “Enrollment Type” to be updated Updated Batch result codes and Messages – Changed U9 result code to exclude “Enrollment Type” code. Change Date 07/12/2013
# Field Type Max. Length Optional 1 Student ID String 9 M 2 SAP ID String 50 O 3 Legal Last Name String 30 M 4 Legal First Name String 30 M 5 Birth Date String 10 M 6 String 15 M 7 String 15 M 8 EI Number String 6 O 9 Program Model String 2 M 10 Service Location (Modality) for Prevention Initiative programs String 2 M 11 Screening for Eligibility Tool String 2 M 12 Total Number of Home Visits During the Year String Num M 13 Total Number of Parent Groups/Sessions Attended During the Year String Num M 14 Total number of Hours Student Spent in DCFS Licensed Child Care Center String Num M 15 Student born with a Low Birth Weight String 2 M 16 Is Student A Youth In Care String 2 M 17 Was parent married at time of student’s birth String 2 O 18 Biological Mother’s Date of Birth String 10 O 19 Student’s Family is receiving Child support String 2 M 20 Student’s Family is receiving TANF String 2 M 21 Student’s Family is receiving WIC String 2 M 22 Student’s Family is receiving SNAP String 2 M
5 Birth Date String 10 M 6 Entry Rating - Home RCDTS String 15 O 7 Entry Rating Date String 10 O* 8 Entry Rating – Positive Social Relationships String 2 O* 9 Entry Rating – Acquire Use and Knowledge Skills String 2 O* 10 Entry Rating – Take Appropriate Action to Meet Own Needs String 2 O* 11 Entry Rating - How was Parent Involved in the Ratings? String 2 O* 12 Entry Rating – Did a Coordinator, LEA Representative or Administrator Participate in the Ratings? String 2 O* 13 Entry Rating – Did an Early Childhood Teacher Participate in the Ratings? String 2 O* 14 Entry Rating – Did a Psychologist or Social Worker Participate in the Ratings? String 2 O* 15 Entry Rating – Did a Speech/ Language Pathologist Participate in the Ratings? String 2 O* 16 Entry Rating – Did another Related Service Provider (e.g. OT/PT) Participate in the Ratings? String 2 O* 17 Progress Rating – Home RCDTS String 15 O**
18 Progress Rating Date String 10 O** 19 Progress Rating – Positive Social Relationships String 2 O** 20 Progress Rating – Made Progress Positive Social Relationships String 2 O** 21 Progress Rating – Acquire Use and Knowledge Skills String 2 O** 22 Progress Rating – Made Progress Acquire use and Knowledge Skills String 2 O** 23 Progress Rating – Take Appropriate Action to Meet Own Needs String 2 O** 24 Progress Rating - Made Progress Take Appropriate Action to Meet Own Needs String 2 O** 25 Progress Rating – Primary Assessment String 2 O** 26 Progress Rating – How was Parent Involved in Ratings String 2 O** 27 Progress Rating – Did a Coordinator, LEA Representative or Administrator Participate in the Ratings? String 2 O** 28 Progress Rating – Did the Child’s Teacher Participate in the Ratings? String 2 O** 29 Progress Rating – Did a Psychologist or Social Worker Participate in the Ratings? String 2 O** 30 Progress Rating – Did a Speech/ Language Pathologist Participate in the Ratings? String 2 O**
27 Maximum Numeric Grade (Term) Integer O 28 Student Course End Date String 10 M 29 Course Final Letter Grade/ Completion Status (Term) String 2 M 30 Result Code String 2 N/A 31 Result Message Codes String 200 N/A PARCC Pre-ID File Format THIS SECTION ONLY APPLIES TO THOSE STUDENTS WHO WERE INVOLVED IN ACT TESTING (GRADES 3-8). This file format pertains to the data submitted to ISBE SIS when submitting information for PARCC Pre-ID. The batch import file must conform to the order and data type listed in the table on the following page with exception to the Result Code and Result Message fields. The Result Code and Result Message fields will be appended to each record by the ISBE SIS system for the batch export file. Refer to the ISBE SIS Data Elements document for the approved codes and definitions.
3 Mothers Legal Middle Name String 30 M 4 Mothers Legal Last Name String 30 M 5 Mothers Maiden Name String 30 M 6 Mothers Address String 50 M 7 City in which mother resides String 30 M 8 State name is which mother resides String 2 M 9 Zip code of city in which mother resides String 5 M 10 Zip +4 code of city in which mother resides String 4 O 11 Contact telephone number area code for mother String 3 M 12 Contact telephone number prefix for mother String 3 M 13 Contact telephone number suffix for mother String 3 M 14 Mothers date of birth String 10 M 15 Marital Status of Mother String 2 M 16 General racial category which most clearly reflects the mothers recognition of her community or with which the individual most identifies String 2 M 17 RCDTS for Home School String 15 M 18 RCDTS for Serving School String 15 M 19 Date Prenatal Services Started String 10 M 20 Due Date String 10 M 21 Prenatal Exit Reason String 2 O 22 Exit Date String 10 O 23 Total Number of Home Visits During the Year String 3 O 24 Total Number of Parent Groups or Sessions Attended During the Year String 3 O 25 Number of Birthed Children String 2 O 26 Where mother delivered child String 30 O
22 Single Parents including Single Pregnant Women (Reported for CTE Courses Only) String 2 O 23 Displaced Homemaker (Reported for CTE Courses only) String 2 O 24 Course Numeric Grade (Term) Integer O 25 Maximum Numeric Grade (Term) Integer O 26 Student Course End Date String 10 O 27 Course Final Letter Grade/ Completion Status (Term) String 2 O 28 Result Code String 2 N/A 29 Result Message Codes String 200 N/A .
Result Codes and Result Messages The batch process will first validate the fields contained in the ISBE SIS batch import file. If all validations pass, the system will execute the batch process. Based on the results of the batch processing, a result code and result message will be assigned to each record indicating the result of the batch processing The ISBE SIS Result Codes and Result Messages are listed in the table below: Result Code Result Message Possible Reason for Outcome A New SID Assigned Student attributes provided do not match existing ISBE SIS record B1 Existing SID Returned; New Enrollment Created Student attributes provided match one existing record and new enrollment passes validations B2 Existing SID Returned; No New Enrollment Created RCDTS for Serving School is the same as Existing enrollment RCDTS for Serving School is the same as Existing enrollment. Include SID on next upload to update B3 Existing SID Returned; No New Enrollment Created RCDTS for Home School is the different from existing enrollment RCDTS for Home School is the different from existing enrollment. Student must be exited and in the correct Home School B4 Existing SID Returned; No New Enrollment Created; Enrollment Dates can not overlap Enrollment Dates can not overlap B5 Existing SID Returned; No New Enrollment Created; LEP should be No; Student has previous ACCESS score that met the criteria and is transitioned out Previous school year ACCESS score exists with overall proficiency level of 5.0 or higher a proficiency level of 4.2 or higher in both Reading AND Writing. B6 Existing SID Returned; No New Enrollment Created; LEP should be Yes; Student has previous ACCESS score that DID NOT meet the criteria to transition out Previous school year ACCESS score exists with overall proficiency level less than 5.0 or less than 4.2 proficiency level in both Reading AND Writing B7 Existing SID returned; No New Enrollment created; Not eligible for Grade 12 SID Returned; User attempted to enroll a student in 12 grade. Student does not meet the PSAE graduation requirement and can not be 12 grade
B8 Existing SID Returned; No New Enrollment Created; Student Already Graduated C Multiple Matches Exist; No SID Assigned Or Please check Gender; Similair student already exists ; No New SID assigned Student attributes provided match two or more existing records and uniqueness cannot be determined. OR Similar student found with a different Gender. To resolve these go online, create the SID nad send it with the file on the next transmission C1 Student must be actively enrolled in your district Student must be actively enrolled in your district C2 No record can be added or Updated; Student is repeated in the file No record can be added or Updated; Student is repeated in the file C3 Student Enrollment Not Found Student must be enrolled to be updated for PARCC D1 Student Discipline Record Accepted exists and student discipline record is created for the student D2 Student Discipline Record Updated exists and existing student discipline record is updated D3 No valid Enrollment found at the time the incident occurred Student does not have an enrollment record at the time the incident occurred D4 No valid Enrollment found at the time the incident occurred Student does not have an enrollment record at the time the incident occurred D5 Existing Enrollment Found; Exit Date before Incident Date-No Record Updated SID and enrollment exists but the Exit Date is prior to the Incident Date D6 Existing Enrollment Found; Exit Type Invalid-No Record Updated SID and enrollment exists but the Exit Enrollment/ Withdrawal Type Code is invalid because a Student Discipline record is associated with this enrollment D7 Duplicate Record – Student already updated in file for same incident date and incident number Student Discipline Record Duplicated within file. SID, Incident Date, and Incident Number already processed within the file
EG1 Student’s Enrollment can not be exited until Early Childhood Expansion Grant data is submitted Student’s Enrollment can not be exited until Early Childhood Expansion Grant data is submitted E11 Total Attendance days cannot be greater than Total Enrollment days The total number of days present, excused absences and unexcucsed absences, exceeds the total number of days enrolled F Missing or Invalid Data One or more edit check failures. (Specific error codes will be returned) G1 Updated ELL Information SID exists and existing student ELL record is updated G2 SID Exists but No Record Updated SID exists however ELL record not found. Student must be marked LEP G3 Missing mandatory ELL data; Enrollment Not Exited User attempted to exit a student designated as LEP without first submitting the Mandatory ELL data G4 SID exists; no record updated; LEP status cannot change until ELL Services is ended and the reason is not; Withdrawn by parents User attempted to change a student’s LEP status but mandatory ELL data is missing or the Date ELL Services Ended is blank G5 Reason ELL Services Ended cannot be Erroneous; student has a previous ACCESS score that does not meet the transition criteria Student has a previous ACCESS test score and cannot be transitioned until they obtain overall proficiency level of 5.0 or higher a proficiency level of 4.2 or higher in both Reading AND Writing H1 Updated Early Childhood information Updated Early Childhood information H2 No Record Updated; IEP is No; IEP Completion and Services Began must be Null No Record Updated; IEP is No; IEP Completion and Services Began must be blank H3 Missing Mandatory Early Childhood Data; Enrollment Not Exited User attempted to exit a student designated as Pre-K without first submitting the mandatory Early Childhood data H4 Early Childhood record has another enrollment with the specified funding source Early Childhood record has another enrollment with the specified funding source H5 Percent of day student is enrolled is less than the specified funding amount Percent of day student is enrolled is less than the specified funding amount
J11 Multiple identical Progress ratings exist for the student in file Multiple Progress Ratings in the uploaded file J12 Entry Home RCDT does not match existing Entry Home RCDT. Entry Ratings cannot be updated The Entry Home RCDT (District) must match the user uploading the file J13 Entry Rating can not be after Progress rating date for the student Entry Rating date must be before the Progress Rating Date J14 New Progress Rating cannot be added as an erroneous record Can not add a New Progress Rating as Erronoeus J15 Home RCDT does not match existing Home RCDT for Progress rating. Progress Ratings cannot be updated Progress Rating can not be updated, Home RCDT of user uploading the file does not match Home RCDT (District) of Progress Record J16 Entry rating should exist for student before submitting Progress ratings Progress Rating can not be submitted until an Entry Rating has been submitted J17 Progress Rating date cannot be before Entry Rating date Progress Rating Date can not before Entry Rating Date J18 Entry Rating cannot be marked erroneous until the student has valid Progress Ratings If the Student has valid Progress Ratings the Entry Rating can not be marked Erroneous J19 The 98 Rating Code can only be used when the student is a private school student The student must be Private School Student = ‘yes’ to use the code 98 rating J20 Parents Involvement can only be set to 98 when the student is a private school student The student must be Private School Student = ‘yes’ to use Parent Involvment code 98 J21 Primary Assessment can only be set to 98 when the student is a private school student The student must be Private School Student = ‘yes’ to use Primary Assessment code 98 J22 Invalid Entry Rating for Acquire Use and Knowledge Skills Cannot use selected entry rating for Acquire Use and Knowledge Skills J23 Invalid Entry Rating for Take Appropriate Action to Meet Own Needs Cannot use selected entry rating for Take Appropriate Action to Meet Own Needs J24 Invalid Entry Rating for Positive Social Relationships Cannot use selected entry rating for Positive Social Relationships J25 Invalid progress rating and indicator combination for Acquire Use and Knowledge Skills Cannot use selected progress rating and indicator for Acquire Use and Knowledge Skills
J26 Invalid progress rating and indicator combination for Take Appropriate Action to Meet Own Needs Cannot use selected progress rating and indicator for Take Appropriate Action to Meet Own Needs J27 Invalid progress rating and indicator combination for Positive Social Relationships Cannot use selected progress rating and indicator for Positive Social Relationships L1 Homeless Record updated User successfully updated the student Homeless data L2 Student must be actively enrolled in your district User attempted to update the students Homeless but could not. The Home RCDTS of the active enrollment does not match the IWAS user submitting the file L3 No Homeless Record exists for Student Id User attempted to update the students Homeless but could not. The students Homeless Indicator is set to “No” in SIS L4 SID exists; no record updated; Homeless status cannot change until mandatory Homeless data has been provided All Mandatory Homeless data must be entered before the Homeless status can be changed L5 Missing Mandatory Homeless Data; Enrollment Not Exited All Mandatory Homeless data must be entered before student can be exited L6 Existing Enrollment Found; Has Homeless data; Exit Type Invalid – No Record Updated Enrollment can not be set to “Erroneous” Unless existing Homeless record is also set to “Erroneous” M1 EL Screener Record Added An EL Screener record has been added M2 EL Screener Record Updated An Existing EL Screener record has been updated M3 Student must be actively enrolled in your district Student must be actively enrolled in the IWAS user’s district to add or update EL screener data M4 Student has already taken a Screener test on this date Student has already taken a Screener test on this date M5 Test Date or Grade does not match Student Enrollment The Test Date or Grade Level of student does not match the student’s enrollment M6 EL Screener NOT Accepted Home Language is English OR An EL Screener record can not be added if the Home Lanaguage is
Home Language changed to English. LL Screener should be marked erroneous English. Also. The Home Language can not be Updated to English unless the LL screener data is made Erroneous M7 Missing Mandatory EL Screener Data; Enrollment Not Exited EL Screener data is mandatory before the student can be exited N1 Student Course Assignment record has been successfully added Student Course Assignment Record Added N2 Student Course Assignment record has been successfully updated Student Course Assignment Record Updated N3 Student does not have a valid enrollment record; Check Grade Level The student does not have a valid matching district enrollment record in SIS N4 Student should be assigned to a valid state course code Student Course Assignment record not updated; Student Course Assignment record does not contain a valid State course code N5 The Student Course Assignment record is duplicated and can not appear more than once in the file The Student Course Assignment record duplicated and can not appear more than once in the file N6 Student Assignment record can not be added as erroneous A student Assignment record can not be added as erroneous N7 Student not exited; Student assignment record exists with a Course End date less than the specified Enrollment exit date The Exit Enrollment Date is less than the Maximum Course End Date in an existing non-erroneous Course record with a matching intEnrolId N8 Student Not Exited; A valid Student Assignment Record Exists, Enrollment may not be specified as erroneous until all Student Course Assignments are Erronoeus The student can not be exited as Erronous without specifying the submitted student course assignments as erroneous N9 End of course data is required for exited enrollments Student enrollment has already been exited; user must submit all course data including course end data N10 Cannot exit student enrollment; Missing Mandatory Course data Student enrollment cannot be exited until all Secondary course data including course end data has been submitted N11 Invalid Final Letter Grade; Student must be grade K thru 8 User has tried to submit a Course Assignment with a Final Letter
PC9 No record updated; PARCC Assessment Correction Not Found; Testing Window has not ended Testing Window has not ended for Student PC10 No record updated; PARCC Assessment Correction Not Found; High School PARCC Test; Missing course PARCC Correction record not found, High School Course was not entered. Student must be added Online under Assessment Correction PARCC PC11 No record updated; PARCC Assessment Correction Not Found; Student not enrolled during Test Window Student was not enrolled during the test window. Student must be added Online under Assessment Correction PARCC PD1 No record updated; DLM-AA PreID does not exist for this student No record updated; DLM-AA PreID does not exist for this student. PD2 DLM-AA PreID updated successfully Record successfully updated PD3 DLM-AA PreID exists;Cannot change IEP to No Pre_ID record for DLM-AA PP1 No record updated; PARCC PreID does not exist for this student and PARCC Test Code. No record updated; PARCC PreID does not exist for this student and PARCC Test Code PP2 PARCC PreID updated successfully PARCC PreID updated successfully PP3 No record updated; Student is not IEP; Cannot have IEP accomodations Student is not IEP = Yes PP4 No record updated; Student is not LEP; Cannot have LEP accomodations Student is Not LEP = Yes PP5 No record updated; Grade 9 to 12; PARCC PreID does not exist; Missing Student Course Assignments Student is in Grades 9-12 and missing a Student Course Assignment that meet the PARCC standards PS1 No record updated; SAT PreID does not exist for this student Student not found in SAT Pre-ID. Either student is not enrolled correctly or they are listed in the DLM-AA Pre-ID PS2 SAT PreID updated successfully SAT Pre-ID Record update successfully PS3 SAT PreID exists; First Year in US School cannot be Yes because LEP is No Student must be LEP “Yes” if First Year in U.S. School as “Yes”
Q15 The provided Service Location code is not valid The provided Service Location code is not valid Q16 The provided Screening Eligibility code is not valid The provided Screening Eligibility code is not valid R1 Adjusted Cohort Graduation Rate Record Updated Adjusted Cohort Graduation Rate Record has been Updated R2 The student has an active enrollment and must be exited before modifying Adjusted Cohort Graduation Rate data Student is enrolled and must be exited before the Exit Type code can be updated R3 Student is not part of your Adjusted Graduation Cohort Student is not part of your Adjusted Cohort Graduation Rate R4 The Adjusted Cohort Graduation Rate record is duplicated and can not appear more than once in the file The Student duplicated and appears more than once in the file S1 Regional Safe Schools program record updated Regional Safe Schools Program record has been updated S2 Missing Mandatory Regional Safe Schools Program Data; Enrollment Not Exited Enrollment can not be exited until the mandatory Regional Safe Schools Program data has been submitted S3 Student is not enrolled in a . RSSP record not accepted Student must be enrolled wit a serving school identified as a Regional Safe School before RSSP data can be updated S4 Student must be actively enrolled in your district Student must be actively enrolled in your district S5 Multiple identical RSSP records exist for the student in file Multiple identical RSSP records exist for the student in file SA1 Student Address Record Added Student Address record has been successfully added SA2 Student Address Record Updated Student Address record has been successfully updated SA3 Student address is duplicated and can not appear more tan once in the file Student address is duplicated and can not appear more tan once in the file SA4 Student must be actively enrolled in your district Student must be actively enrolled in your district SA5 Missing Mandatory Active Student Address data; Enrollment not Exited Student Not Exited, missing mandatory Student Address data
SC1 No record updated; Student has no SAT Assessment Correction for this Home and Serving School Student needs to be enrolled in grade 11 or moved from DLM-AA to SAT SC2 No record updated; Student has no SAT Assessment Correction for this Home and Testing School Student needs to be enrolled in grade 11 or moved from DLM-AA to SAT SC3 No record updated; Attempt Test Items is 0; Reason for Void should be provided No record updated; Attempt Test Items is 0; Reason for Void should be provided SC4 No record updated; Last test attempt being voided; Reason for Not Testing should be provided No record updated; Last test attempt being voided; Reason for Not Testing should be provided SC5 No record updated; LEP is YES but student has no EL record Student must have an EL record to be LEP yes in Correction SC6 SAT Assessment Correction updated successfully SAT Correction record successfully updated SC7 SAT Assessment Correction window is closed SAT Correction Window is Closed, correction can no longer be made SP1 Service Provider not updated; IEP Student for given Home school and Serving School not found Service Provider not updated; IEP Student for given Home school and Serving School not found SP2 Student Provider record updated successfully Student Provider record updated successfully ST1 Record Not Accepted for Assessment Pre-ID Generation: No Current Enrollment Exists for Student Record Not Accepted for Assessment Pre-ID Generation: No Current Enrollment Exists for Student ST2 Updated Assessment Pre-Id Information Updated Assessment Pre-Id Information ST3 Assessment Pre-Id Record Not Updated: Pre-Id record cannot be updated after the last day of testing. Please update the students Correction record instead SAT online Assessment Pre-Id Record Not Updated: Pre-Id record cannot be updated after the last day of testing. Please update the students Correction record instead SAT online T1 Teacher Assignment Record Successfully inserted Teacher assignment record has been successfully added T2 Teacher Assignment Record successfully updated Teacher assignment record has been successfully updated T3 Teacher should be assigned to to a valid State Course code Teacher should be assigned to to a valid State Course code
U6 SID Exists; No New Enrollment created; LEP should be Yes;Student has previous ACCESS score that DID NOT meet the criteria to transition out SID exists however; previous school year ACCESS score exists with overall proficiency level less than 4.8 and/or literacy proficiency level less than 4.2 U7 SID Exists; No New Enrollment Created; Enrollment Dates can not overlap Enrollment Dates can not overlap U8 SID Exists; No New Enrollment created; Not eligible for Grade 12 Student Exists; User attempted to enroll a student in 12 grade. Student does not meet the PSAE graduation requirement and can not be 12 grade U9 Updated Student Demographic information;Enrollment not updated;Verify that Enrollment Date/Grade/PDA/RCDTS match existing enrollment Student’s Demographic elements were updated. Enrollment Information not updated. Enrollment information provided in file does not match existing enrollment information V1 PARCC PreID accepted successfully PARCC Record accepted V2 PARCC PreID record was not found. Record not saved. Students have not had the student course assigmments identified that correspond with the PARCC Field Test W1 ACCESS Assessment Correction record created ACCESS Assessment Correction record created W2 ACCESS Assessment Correction record updated ACCESS Assessment Correction record updated W3 SID and 3 attributes do not exist for Student. No record created SID, Last Name, First Name and Date of Birth do not match a stuent in the ACCESS Correction file W4 SID exists; Last Name or First Name or Date Of Birth do not match; No record updated SID exists, but the Last Name or First Name or Date Of Birth do not match W5 SID exists; Enrollment not found; No record created Student was not enrolled, no record craeated
W6 SID exists; Home RCDTS does not match; No record updated Student has a different Home RCDTS W7 SID and Enrollment exists; EL not found; No record created Student ius not marked LEP “Yes” in SIS. An EL record was not found, could not create ACCESS Correction record X1 Student to Keep must be actively enrolled SID to Keep must have an Active enrollment in the Home District of the IWAS user submitting the file X2 Not all Enrollments Exited for Student to Delete ID SID to Delete still has Active Enrollments – All Enrollments for the Bad SID must be exited X3 Enrollments moved and Bad ID Deleted All Enrollments moved to SID to Keep and Bad SID removed X4 Enrollments moved. Assessments unchanged and Bad ID Deleted All Enrollments moved to SID to Keep. Assessments were left unchanged and Bad SID removed X5 Enrollments moved. Assessments moved and Bad ID Deleted All Enrollments moved to SID to Keep. Assessments moved to SID to Keep and Bad SID removed X6 Enrollments moved. Assessments merged and Bad ID Deleted All Enrollments moved to SID to Keep. Assessments were merged and Bad SID Removed X7 Student to Keep ID exists more than once in the file. No record created or updated SID to Keep is in the file multiple times Y1 Prenatal Id and 2 attributes do not exist for an active Prenatal Record. No record created or updated Prenatal Id and 2 attributes do not exist for an active Prenatal Record. No record created or updated Y2 Prenatal record is not active. No record created or updated Prenatal record is not active. No record created or updated Y3 The Prenatal record is duplicated and can not appear more than once in the file The Prenatal record is duplicated and can not appear more than once in the file Y4 Exit Date must be blank when no Exit Reason is provided Exit Date must be blank when no Exit Reason is provided Y5 Total Number of Home Visits and Total Number of Group/Parent Sessions must be blank with the provided Exit Reason Total Number of Home Visits and Total Number of Group/Parent Sessions must be blank with the provided Exit Reason