exists in the County for the file retransmission Fatal Error Duplicate File A file with Reject the file Name the same set and notify name the County for exists retransmission multiple Fatal Error Incorrect County A file from Reject the file a county set and notify does not the County to contain correct the UCNs with data and the correct retransmit the county file. code Error Data field Data Reject the mismatch error cannot be record and inserted process the into the remaining database data records. (i.e., does Log the error not agree records into with CCIS Audit Database tables. format) Error Record key field(s) Data Reject the duplicated record record and cannot be process the inserted remaining into the data records. database Log the error due to records into previous CCIS Audit unique key tables. record exists Invalid UCN length The UCN is Do not load Error not 20 the record characters into CCIS long. database. Log the error record in CCIS Audit. Invalid Data Bit field Load the Error on Bit field does not record into CCIS database.
exists in the file the County for retransmission Fatal Error Duplicate File Name A file with the same name exists multiple Reject the file set and notify the County for retransmission Fatal Error Incorrect County A file from a county does not contain UCNs with the correct county code Reject the file set and notify the County to correct the data and retransmit the file. Error Data field mismatch error Data cannot be inserted into the database (i.e., does not agree with Database format) Reject the record and process the remaining data records. Log the error records into CCIS Audit tables. Error Record key field(s) duplicated Data record cannot be inserted into the database due to previous unique key record exists Reject the record and process the remaining data records. Log the error records into CCIS Audit tables. Error Invalid UCN length The UCN is not 20 characters long. Do not load the record into CCIS database. Log the error record in CCIS Audit. Error Invalid Data on Bit field Bit field does not Load the record into CCIS database.
CCIS_3_ICD_v1.8.docx