{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","ErrorCSV","Source"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,1,3,2],[2,1,2,2],[1,0,1,3]]}
["Community Services Data Set (CSDS) Rejection and Warning Message Summary Generator"]
["This tool provides a summary count and description of the validation errors and data quality warnings. Passing the entries from your Validation.csv file and the DataQuality.csv file (from within the SDCS Cloud Portal) into the ErrorCSV tab, and then clicking the \"Create Error List\" button, will summarise those messages."]
[]
[]
[]
["Guidance on resolving data quality errors can be found in the SDCS Cloud data quality guidance available at:  "]
["https://digital.nhs.uk/services/strategic-data-collection-service-in-the-cloud-sdcs-cloud#user-support-and-guidance."]
["More information on the validations applied to your CSDS submissions can be found in the CSDS Technical Output Specification available at:"]
["https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-sets/community-services-data-set#implementing-this-data-set"]
[]
["Table","Code","Message","Additional Information","Count"]

{"sheet":"ErrorCSV","index":1,"n_rows":1,"n_cols":25,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["REPORT_TYPE","DESCRIPTION","CODE","NUMERATOR","DENOMINATOR","DATA_ITEM1","DATA_VALUE1","DATA_ITEM2","DATA_VALUE2","DATA_ITEM3","DATA_VALUE3","DATA_ITEM4","DATA_VALUE4","DATA_ITEM5","DATA_VALUE5","DATA_ITEM6","DATA_VALUE6","DATA_ITEM7","DATA_VALUE7","DATA_ITEM8","DATA_VALUE8","DATA_ITEM9","DATA_VALUE9","DATA_ITEM10","DATA_VALUE10"]

{"sheet":"Source","index":2,"n_rows":720,"n_cols":6,"rows_kept":720,"cut":false,"hidden":false,"merged":[]}
["Count of entries in the ErrorCSV tab","Count","Table","Code","Message","Additional Information"]
[{"$f":"COUNTA(ErrorCSV!C:C)","v":1},{"$f":"COUNTIF(ErrorCSV!C:C,Source!D2)","v":0},"File reject","CYPREJ000","Failed Submission File Format Check. The file is not a valid XML or IDB file.","The submission file has been rejected and the submission has failed because you are attempting to submit a file in the wrong format.The submission portal will only accept either an XML or IDB file for this dataset."]
["Count messages (to loop though) ",{"$f":"COUNTIF(ErrorCSV!C:C,Source!D3)","v":0},"File reject","CYPREJ004","Failed Content Check. Demographics Table is empty.","The submission file you have uploaded contains no entries in the CYP001MPI group. Without any entries in the CYP001MPI group, this is effectively an empty submission."]
[{"$f":"COUNTA(D2:D720)","v":719},{"$f":"COUNTIF(ErrorCSV!C:C,Source!D4)","v":0},"File reject","CYPREJ005","Failed NHS Number Check. File contains invalid NHS numbers.","NHS numbers, if provided, must pass Modulus-11 checks. The NHS NUMBER is 10 numeric digits in length. The tenth digit is a check digit used to confirm its validity. The check digit is validated using the Modulus 11 algorithm and the use of this algorithm is mandatory"]
["Sum the count of messages matching",{"$f":"COUNTIF(ErrorCSV!C:C,Source!D5)","v":0},"File reject","CYPREJ006","Failed Postcode Check. File contains invalid postcodes.","Postcodes, if provided, must be in one of the correct postcode formats.  See the 'Technical Glossary' tab in the CSDS Technical Output Specification for further details."]
[{"$f":"SUM(B2:B720)","v":0},{"$f":"COUNTIF(ErrorCSV!C:C,Source!D6)","v":0},"File reject","CYPREJ007","Failed Date of Birth Check. File contains invalid dates of birth.","Date of Birth, if provided, must be in a valid format and must not be after the end of the latest reporting period selected. The derived age at start of the earliest reporting period selected must not be 130 years old or greater."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D7)","v":0},"File reject","CYPREJ008","Failed Duplicate NHS Number Check. A NHS number is allocated to more than one person.","Duplicate NHS numbers corrupt the generation of the CSDS database and cannot be accepted."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D8)","v":0},"File reject","CYPREJ009","Failed Duplicate Local Patient Identifier (Extended) Check. A Local Patient Identifier (Extended) is allocated to more than one person.","Duplicate Local Patient Identifier (Extended) corrupt the generation of the pseudo person ID and cannot be accepted."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D9)","v":0},"File reject","CYPREJ010","Failed Organisation Identifier (Code of Provider) Check. The organisation Identifier of the provider in the submitted file does not match the Provider Organisation selected in the Submission Portal.","Data submitters can only upload data for one Organisation Identifier (Code of Provider) at a time.  All the data in the uploaded file must be for the selected Organisation Identifier (Code of Provider)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D10)","v":0},"File reject","CYPREJ011","Failed Reporting Period Check. There were no records in the submission file that were for the selected reporting period.","There were no \"date-marked\" events in any of the groups that covered the selected reporting period.  Without any entries for the reporting period, this is effectively an empty submission."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D11)","v":0},"File reject","CYPREJ015","Failed Content Check. GP Practice Registration table is empty.","The file you have uploaded contains no entries in the CYP002GP table. No data included in this table suggests vital information is missing from this submission."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D12)","v":0},"File reject","CYPREJ016","Failed Content Check. Header table is empty.","The submission file you have uploaded contains no entries in the CYP000Header table. No data included in this table suggests vital information is missing from this submission."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D13)","v":0},"File reject","CYPREJ017","Failed Header check. File contains multiple header records.","More than one CYP000Header record transmitted with this submission file. See validation messages in CYP000Header table to view the records affected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D14)","v":0},"File reject","CYPREJ101","All Records Failed Validation. As a result of validation errors, there are no records for the reporting period that can be progressed into the Central System.","All of the submitted records have been rejected by field-level rejections and hence the submission contains no valid data. The data provider should view the field-level error reporting to further understand the underlying causes of this error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D15)","v":0},"CYP000Header","CYP00001","File rejected - Data Set Version Number is blank.","The DatSetVer field is a mandatory field so cannot be left blank. The value should be set to the current data set version in operation. E.g. \"1.5\" for version 1.5"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D16)","v":0},"CYP000Header","CYP00002","File rejected - Data Set Version Number has incorrect data format.","This is the Version field in CYP000Header Table. The expected format is max n2.max n2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D17)","v":0},"CYP000Header","CYP00003","File rejected - Data Set Version Number has incorrect value for current ruling data set.","This is the Version field of CYP000Header table. If the Version is not set to the current ruling data set, e.g. \"1.5\" for version 1.5, the file will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D18)","v":0},"CYP000Header","CYP00004","File rejected - Organisation Identifier (Code of Provider) is blank.","The OrgIDProv field is a mandatory field so cannot be left blank. This is the Organisation Identifier (ODS code) of the Organisation acting as a Health Care Provider."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D19)","v":0},"CYP000Header","CYP00005","File rejected - Organisation Identifier (Code of Provider) has incorrect data format.","This is the OrgIDProv field and is expecting to be populated with the Organisation Identifier (ODS code) of the Organisation acting as a Health Care Provider. The expected format is min an3 max an6. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D20)","v":0},"CYP000Header","CYP00007","File rejected - Organisation Identifier (Code Of Submitting Organisation) is blank.","The OrgIDSubmit field is a mandatory field so cannot be left blank. This field is expecting the Organisation Identifier (ODS code) of the Organisation acting as the physical sender of a Data Set submission. Unless there is an agreement for a third party to submit the data, this will be the same as the OrgIDProv."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D21)","v":0},"CYP000Header","CYP00008","File rejected - Organisation Identifier (Code Of Submitting Organisation) has incorrect data format.","This is the OrgIDSubmit field and is expecting to be populated with the Organisation Identifier (ODS code) of the Organisation acting as the physical sender of a Data Set submission. Unless there is an agreement for a third party to submit the data, this will be the same as the OrgIDProv. The expected format is min an3 max an6. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D22)","v":0},"CYP000Header","CYP00009","Warning - Organisation Identifier (Code of Submitting Organisation) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The OrgID_Submitter field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D23)","v":0},"CYP000Header","CYP00010","File rejected - Reporting Period Start Date is blank.","The ReportingPeriodStartDate field is a mandatory field so cannot be left blank. This field is expecting to be populated with the first day of the reporting period month."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D24)","v":0},"CYP000Header","CYP00011","File rejected - Reporting Period Start Date has incorrect data format.","This is the ReportingPeriodStartDate field of the CYP000Header table. This field is expecting to be populated with the first day of the reporting period month. The expected date format is an10 (CCYY-MM-DD). More information regarding date formats can be found in the Technical Output Specifical, Technical Glossary tab. You can use the calendar to select the date, this may be easier and less prone to error than inputting this manually."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D25)","v":0},"CYP000Header","CYP00012","File rejected - Reporting Period Start Date does not match the reporting period selected in Submission Portal upload.","This is the ReportingPeriodStartDate field of the CYP000Header table. This field is expecting to be populated with the first day of the reporting period month. This date should match the reporting period selected in submission portal upload."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D26)","v":0},"CYP000Header","CYP00013","File rejected - Reporting Period End Date is blank.","The ReportingPeriodEndDate field is a mandatory field so cannot be left blank. This field is expecting to be populated with the last day of the reporting period month."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D27)","v":0},"CYP000Header","CYP00014","File rejected - Reporting Period End Date has incorrect data format.","This is the ReportingPeriodEndDate field of the CYP000Header table. This field is expecting to be populated with the last day of the reporting period month. The expected date format is an10 (CCYY-MM-DD). More information regarding date formats can be found in the Technical Output Specifical, Technical Glossary tab. You can use the calendar to select the date, this may be easier and less prone to error than inputting this manually."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D28)","v":0},"CYP000Header","CYP00015","File rejected - Reporting Period End Date does not match the reporting period selected in Submission Portal upload.","This is the ReportingPeriodEndDate field of the CYP000Header table. This field is expecting to be populated with the last day of the reporting period month. This date should match the reporting period selected in submission portal upload."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D29)","v":0},"CYP000Header","CYP00016","File rejected - Date And Time Data Set Created is blank.","This is the FileCreation_DateTime field of CYP000Header Table. It is the Date/time this upload file was created This is a mandatory field and should not be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D30)","v":0},"CYP000Header","CYP00017","File rejected - Date And Time Data Set Created has incorrect data format.","This is the FileCreation_DateTime field of CYP000Header Table. The expected data format is an19 YYYY-MM-DDThh:mm:ss."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D31)","v":0},"CYP000Header","CYP00025","Warning - Organisation Identifier (Code Of Submitting Organisation) does not match the Organisation Identifier from the Submission Portal login details.","The OrgIDSubmit field is a mandatory field so cannot be left blank. This field is expecting the Organisation Identifier (ODS code) of the Organisation acting as the physical sender of a Data Set submission. It is possible that the OrgIDSubmit field is different to the OrgIDProv as this is the Org Code of the organisation using the portal to send the data. Usually however we normally see this populated with the same value as the OrgIDProv field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D32)","v":0},"CYP000Header","CYP00026","File rejected - Date And Time Data Set Created is before Reporting period Start Date.","This is the DateTimeDatSetCreate field. This field is expecting to be populated with the date that the database was created (may be today's date) and does not need to include the time. This should be populated with a date that is after the ReportingPeriodEndDate but not after the Upload Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D33)","v":0},"CYP000Header","CYP00027","Warning - Date And Time Data Set Created is before Reporting period End Date.","This is the DateTimeDatSetCreate field. This field is expecting to be populated with the date that the database was created (may be today's date) and does not need to include the time. This should be populated with a date that is after the ReportingPeriodEndDate but not after the Upload Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D34)","v":0},"CYP000Header","CYP00028","File rejected - Date And Time Data Set Created is after Upload Date.","This is the DateTimeDatSetCreate field. This field is expecting to be populated with the date that the database was created (may be today's date) and does not need to include the time. This should be populated with a date that is after the ReportingPeriodEndDate but not after the Upload Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D35)","v":0},"CYP000Header","CYP00029","File rejected - Primary Data Collection System In Use is blank.","The PrimSystemInUse is a mandatory field so cannot be left blank. This field is expecting the system you use to store your data, e.g. SystmOne,  Excel etc."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D36)","v":0},"CYP000Header","CYP00030","File rejected - Primary Data Collection System In Use has incorrect data format.","This is the PrimSystemInUse field. This field is expecting the system you use to store your data, e.g. SystmOne, Excel etc. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D37)","v":0},"CYP001MPI","CYP00104","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field is a mandatory field so cannot be left blank. The LocalPatientId provides a link between records in the CYP001MPI table, associated referrals and all non-referral-based data associated with the Patient. To avoid the incorrect linkage of records the LocalPatientId must not be reused i.e. it should only ever relate to one Patient. This ensures that data relating to more than one Patient does not get incorrectly identified as belonging to a single Patient in CSDS."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D38)","v":0},"CYP001MPI","CYP00105","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of CYP001MPI table. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D39)","v":0},"CYP001MPI","CYP00106","Record rejected - Organisation Identifier (Local Patient Identifier) is blank.","The OrgIDLocalPatientId field is a mandatory field so cannot be left blank. This field is expecting to be populated with the Organisation Identifier (ODS code) of the Organisation that assigned the LocalPatientId."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D40)","v":0},"CYP001MPI","CYP00107","Record rejected - Organisation Identifier (Local Patient Identifier) has incorrect data format.","The OrgIDLocalPatientId field is expecting to be populated with the Organisation Identifier (ODS code) of the Organisation that assigned the LocalPatientId. Format: min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D41)","v":0},"CYP001MPI","CYP00108","Warning - Organisation Identifier (Local Patient Identifier) does not match the Organisation Identifier (Code of Provider) from the CYP000.","The OrgIDLocalPatientId field is expecting to be populated with your ODS code and should match the ODS code provided in the OrgIDProvider field in the CYP000Header table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D42)","v":0},"CYP001MPI","CYP00109","Record rejected - Organisation Identifier (Residence Responsibility) has incorrect data format.","The OrgIDResponsible is expecting to be populated with the Organisation Identifier (ODS code) of the Organisation that assigned the LocalPatientId. Format: min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D43)","v":0},"CYP001MPI","CYP00110","Warning - Organisation Identifier (Residence Responsibility) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The OrgIDResponsible field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D44)","v":0},"CYP001MPI","CYP001101","Warning - Death Not At Preferred Location Reason is populated but Death Location Type Code (Preferred) contains the same value as Death Location Type Code (Actual).","This is the NotAtPreferredLocation_Reason field of the CYP001MPI table. Warning is  received because the corresponding Death location Type code (preferred) is the same as Death Location Type Code (Actual). "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D45)","v":0},"CYP001MPI","CYP001103","Warning - Postcode Of Usual Address provided was not a current valid postcode in national code tables at any point during the reporting period.","This is the Postcode field of the CYP001MPI table. This warning is generated because some postcodes could not be matched against the national postcodes. The Data Quality CSV  file should indicate which postcodes these are."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D46)","v":0},"CYP001MPI","CYP001104","Warning - Organisation Identifier (Educational Establishment) was not a live organisation in national code tables at any point during the reporting period.","The OrgID_EducationEstablishment field is an identification number allocated to each educational establishment by the Department for Education. The allocated identification number is six digits, but this is prefixed with 'EE' on the Organisation Data Service reference file. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D47)","v":0},"CYP001MPI","CYP001105","Record rejected - NHS Number (Mother) contains an invalid NHS number.","This is the NHSNumber_Mother field of CYP001MPI. The record is rejected because the NHS number is not valid."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D48)","v":0},"CYP001MPI","CYP00111","Warning - NHS Number is blank.","This is the NHSNumber field of the CYP001MPI table. This is a reminder that the NHS Number field has been left blank. If you do not collect the NHS Number then it is correct to leave this field blank. However, the appropriate Status Indicator code should be populated. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D49)","v":0},"CYP001MPI","CYP00115","Record rejected - NHS Number Status Indicator Code has incorrect data format.","This is the NHSNumberStatus field of the CYP001MPI table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D50)","v":0},"CYP001MPI","CYP00116","Warning - NHS Number Status Indicator Code contains an invalid national code.","The NHSNumberStatus field of the CYP001MPI table is the trace status of the NHS NUMBER. This warning is generated because the code populated is invalid. For a list of valid national codes, visit https://www.datadictionary.nhs.uk/data_elements/nhs_number_status_indicator_code.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D51)","v":0},"CYP001MPI","CYP00117","Warning - NHS Number contains a value, and the NHS Number Status Indicator Code is \"07 - Number not present and trace not required\".","This is the NHSNumberStatus field of the CYP001MPI table. The value 07 is only expected to be populated to the NHSNumberStatus field when the NHSNumber field is blank.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D52)","v":0},"CYP001MPI","CYP00118","Warning - Both the NHS Number Status Indicator Code and the NHS Number are blank.","This is the NHSNumber field and NHSNumber_Status field of the CYP001MPI table. This warning is generated because both fields have been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D53)","v":0},"CYP001MPI","CYP00119","Warning - NHS Number is blank but the NHS Number Status Indicator Code contains a value of'01' or '02'.","This is the NHSNumberStatus field of the CYP001MPI table. Where the NHS Number field has been intentionally left blank the NHSNumberStatus field is expected to be populated with \"07\" (Number not present and trace not required) "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D54)","v":0},"CYP001MPI","CYP00125","Record rejected - Person Stated Gender Code has incorrect data format.","This is the Gender field of the CYP001MPI table. The Technical Output Specification shows the values that are acceptable for this field. The expected format for this field is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D55)","v":0},"CYP001MPI","CYP00126","Warning - Person Stated Gender Code contains an invalid national code.","This is the Gender field of CYP001MPI table. The warning is shown because the record is populated with an invalid national code. Examples of Valid national codes are \"1\"(Male),\"2\"(Female),\"9\"(indeterminate-unable to be classified as either male or female)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D56)","v":0},"CYP001MPI","CYP00127","Record rejected - Ethnic Category has incorrect data format.","This is the EthnicCategory field of the CYP001MPI table. The Technical Output Specification shows the values that are acceptable for this field. The expected format for this field is max an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D57)","v":0},"CYP001MPI","CYP00128","Warning - Ethnic Category contains an invalid national code.","This is the EthnicCategory field of the CYP001MPI table. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D58)","v":0},"CYP001MPI","CYP00129","Record rejected - Language Code (Preferred) has incorrect data format.","This is the LanguagePreferred field of the CYP001MPI table. The ISO 639-1 codes are at http://www.loc.gov/standards/iso639-2/php/code_list.php, as well as additional ones in the Technical Output Specification. The data format for this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D59)","v":0},"CYP001MPI","CYP00130","Warning - Language Code (Preferred) contains an invalid national code.","This is the LanguagePreferred field of the CYP001MPI table. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D60)","v":0},"CYP001MPI","CYP00131","Record rejected - Looked After Child Indicator has incorrect data format.","This is the ChildLookedAfter_Indicator field of the CYP001MPI table. The expected data format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D61)","v":0},"CYP001MPI","CYP00132","Warning - Looked After Child Indicator contains an invalid national code.","This is the ChildLookedAfter_Indicator field of the CYP001MPI table. This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D62)","v":0},"CYP001MPI","CYP00133","Record rejected - Safeguarding Vulnerability Factors Indicator has incorrect data format.","This is the Safeguarding_Indicator field of the CYP001MPI table. The expected data format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D63)","v":0},"CYP001MPI","CYP00134","Warning - Safeguarding Vulnerability Factors Indicator contains an invalid national code.","This is the  Safeguarding_Indicator field of the CYP001MPI table. This warning has been received because an invalid national code has been used.  Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D64)","v":0},"CYP001MPI","CYP00135","Record rejected - Educational Assessment Outcome has incorrect data format.","This is the Educational Assessment Outcome field of the CYP001MPI table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D65)","v":0},"CYP001MPI","CYP00136","Warning - Educational Assessment Outcome contains an invalid national code.","This is the Educational Assessment Outcome field of the CYP001MPI table. This warning has been received because an invalid national code has been used. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is present Excel can automatically remove leading zeros, so this may require extra attention."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D66)","v":0},"CYP001MPI","CYP00137","Record rejected - Person Death Date has incorrect data format.","This is the DateOfDeath field of the CYP001MPI table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D67)","v":0},"CYP001MPI","CYP00138","Record rejected - Person Death Date contains a Person Death Date that is before the Reporting Period Start Date.","This is the DateOfDeath field of the CYP001MPI table. This is a required field and the date should not be before the RP_StartDate of CYP000Header Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D68)","v":0},"CYP001MPI","CYP00139","Warning - Person Death Date contains a Person Death Date that falls after the Reporting Period End Date.","This is the DateOfDeath field of the CYP001MPI table. This is a required field and the date should be  before the RP_EndDate of CYP000Header Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D69)","v":0},"CYP001MPI","CYP00140","Record rejected - Death Location Type Code (Preferred) has incorrect data format.","This is theDeathLocationPreferred_Type field of the CYP001MPI table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D70)","v":0},"CYP001MPI","CYP00141","Warning - Death Location Type Code (Preferred) contains an invalid national code.","This is the DeathLocationPreferred_Type field of the CYP001MPI table. This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D71)","v":0},"CYP001MPI","CYP00142","Record rejected - Death Location Type Code (Actual) has incorrect data format.","This is the DeathLocationActual_Type field of the CYP001MPI table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D72)","v":0},"CYP001MPI","CYP00143","Warning - Death Location Type Code (Actual) contains an invalid national code.","This is the DeathLocationActual_Type field of the CYP001MPI table. This warning has been received because an invalid national code has been used. For accepted codes, check https://www.datadictionary.nhs.uk/data_elements/death_location_type_code__preferred_.html "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D73)","v":0},"CYP001MPI","CYP00144","Warning - PERSON DEATH DATE is populated but the Death Location Type Code (Actual) is blank.","The DeathLocationPreferred_Type field should not be blank .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D74)","v":0},"CYP001MPI","CYP00145","Record rejected - Organisation Identifier (Educational Establishment) has incorrect data format.","This is the OrgID_EducationEstablishment field of CYP001MPI Table. This record is rejected because an incorrect data format has been filled.The expected data format is min an5 max an8."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D75)","v":0},"CYP001MPI","CYP00147","Warning - Organisation Identifier (Local Patient Identifier) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","This is the Org_LocalPatientID field of the CYP001MPI Table.This identifies the organisation where the Local Patient Identifier was issued. This warning is generated because the Org_LocalPatientID provided is not recognised as being live during the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D76)","v":0},"CYP001MPI","CYP00148","Record rejected - NHS Number Status Indicator Code (Mother) has incorrect data format.","This is the NHSNumberStatus_Mother field of the CYP001MPI table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D77)","v":0},"CYP001MPI","CYP00149","Warning - NHS Number Status Indicator Code (Mother) contains an invalid national code.","This is the NHSNumberStatus_Mother field of the CYP001MPI table. This warning has been received because an invalid national code has been used. For valid codes check https://www.datadictionary.nhs.uk/data_elements/nhs_number_status_indicator_code__mother_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D78)","v":0},"CYP001MPI","CYP00150","Warning - Person Birth Date is blank.","This is the PersonBirthDate field of the CYP001MPI table. Warning that the field has been left blank. See the User Guidance document on how the date of birth might be estimated.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D79)","v":0},"CYP001MPI","CYP00151","Warning - Postcode Of Usual Address is blank.","This is the Postcode field of the CYP001MPI table. This is a reminder that the Postcode field has been left blank. If the postcode is unknown then ZZ99 3WZ should be used. The User Guidance has additional information on Postcode options. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D80)","v":0},"CYP001MPI","CYP00152","Warning - Person Stated Gender Code is blank.","This is the Gender field of the CYP001MPI table. This is a reminder that the Gender field has been left blank. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D81)","v":0},"CYP001MPI","CYP00153","Record rejected - Constant Supervision And Care Required Due To Disability Indicator has incorrect data format.","This is the Disability_SupervisionAndCare_Indicator field of the CYP001MPI table. The expected data format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D82)","v":0},"CYP001MPI","CYP00154","Warning - Constant Supervision And Care Required Due To Disability Indicator contains an invalid national code.","This is the Disability_SupervisionAndCare_Indicator  field of the CYP001MPI table. This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D83)","v":0},"CYP001MPI","CYP00155","Record rejected - Person At Risk Of Unexpected Death Indicator has incorrect data format.","This is the RiskOfUnexpectedDeath_Indicator field of the CYP001MPI table. The expected data format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D84)","v":0},"CYP001MPI","CYP00156","Warning - Person At Risk Of Unexpected Death Indicator contains an invalid national code.","This is the  RiskOfUnexpectedDeath_Indicator field of the CYP001MPI table. This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D85)","v":0},"CYP001MPI","CYP00157","Record rejected - Preferred Death Location Discussed Indicator has incorrect data format.","This is the DiscussedPreferredDeathLocation_Indicator field of the CYP001MPI table. The expected data format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D86)","v":0},"CYP001MPI","CYP00158","Warning - Preferred Death Location Discussed Indicator contains an invalid national code.","This is the  DiscussedPreferredDeathLocation_Indicator  field of the CYP001MPI table. This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D87)","v":0},"CYP001MPI","CYP00159","Record rejected - Death Not At Preferred Location Reason has incorrect data format.","This is the NotAtPreferredLocation_Reason field of the CYP001MPI table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D88)","v":0},"CYP001MPI","CYP00160","Warning - Death Not At Preferred Location Reason contains an invalid national code.","This is the  NotAtPreferredLocation_Reason field of the CYP001MPI table. This warning has been received because an invalid national code has been used. For accepted codes check https://www.datadictionary.nhs.uk/attributes/death_not_at_preferred_location_reason.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D89)","v":0},"CYP001MPI","CYP00162","Record rejected - Person Relationship (Main Carer) has incorrect data format.","This is the Relationship_MainCarer field of the CYP001MPI table. The expected format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D90)","v":0},"CYP001MPI","CYP00163","Warning - Person Relationship (Main Carer) contains an invalid national code.","This is the Relationship_MainCarer field. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D91)","v":0},"CYP001MPI","CYP00164","Record rejected - Health Visitor First Antenatal Visit Date has incorrect data format.","This is the HVFAV_Date field of the CYP001MPI table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D92)","v":0},"CYP001MPI","CYP00166","Warning - Death Location Type Code (Actual) is populated but the Person Death Date is blank.","This is the DeathLocationActual_Type field of the CYP001MPI table. This is a required field and the corresponding DateOfDeath field should not be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D93)","v":0},"CYP001MPI","CYP00167","Warning - Death Not At Preferred Location Reason is populated but the Person Death Date is blank.","This is the NotAtPreferredLocation_Reason field of the CYP001MPI table. This is a required field and the corresponding DateOfDeath field should not be blank .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D94)","v":0},"CYP001MPI","CYP00171","Group rejected - No valid CYP002 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP001MPI table rejected because there is no corresponding record in the CYP002GP. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP002GP) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP002GP)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D95)","v":0},"CYP001MPI","CYP00173","Warning - NHS Number (Mother) contains a value, and the NHS Number Status Indicator Code (Mother) is \"07 - Number not present and trace not required\".","ThThe warning is generated because the NHSNumber_Mother field is populated but the selected Status Indicator code states the Number is not present. Check If the NHS Number(Mother) is correctly populated and select an appropriate Indicator code."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D96)","v":0},"CYP001MPI","CYP00175","Warning - NHS Number (Mother) field is blank but the NHS Number Status Indicator Code (Mother) contains a value of '01' or '02'.","This is the NHSNumber_Mother field of CYP001MPI Table. The corresponding indicator code \"01\"(Number present and Verified) or \"02\"(Number present but not traced) indicate that the field  should not be blank .The expected data format is n10."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D97)","v":0},"CYP001MPI","CYP00176","Record rejected - Health Visitor First Antenatal Visit Date is more than 1 year before the Person Birth Date.","This is the HVFAV_Date field of the CYP001MPI table. This is a required field and the date should not be more than a year before the Person Birth Date also Check DateOfBirth field is correct. The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D98)","v":0},"CYP001MPI","CYP00178","Record rejected - Health Visitor First Antenatal Visit Date is after the Date and Time Data Set Created.","This is the HVFAV_Date field of the CYP001MPI table. This is a required field and the date should be  before the FileCreation_DateTime field of CYP000Header Table ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D99)","v":0},"CYP001MPI","CYP00179","Warning - Health Visitor First Antenatal Visit Date is after Reporting Period End Date.","This is the HVFAV_Date field of the CYP001MPI table. This warning is generated because the HVFAV_Date  should not be  after the RP_EndDate of CYP000Header Table ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D100)","v":0},"CYP001MPI","CYP00180","Record rejected - Person Death Date is before the Person Birth Date.","This is the DateOfDeath field of the CYP001MPI table. This is a required field and the date should not be  before the DateOfBirth .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D101)","v":0},"CYP001MPI","CYP00181","Record rejected - Person Death Date is after the Date and Time Data Set Created.","This is the DateOfDeath field of the CYP001MPI table. This is a required field and the date should not be after the FileCreation_DateTime field of CYP000Header Table ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D102)","v":0},"CYP001MPI","CYP00184","Record rejected - Health Visitor First Antenatal Visit Date is after the Person Birth Date.","This is the HVFAV_Date field of the CYP001MPI table. This record is rejected because the date should be before the DateOfBirth .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D103)","v":0},"CYP001MPI","CYP00185","Record rejected - Person Birth Date is blank AND Health Visitor First Antenatal Visit Date is populated.","This record is rejected when the HVFAV_Date field of CYP001MPI Table is populated but the DateOfBirth field is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D104)","v":0},"CYP001MPI","CYP00186","Record rejected - Person was 19 years of age or over at the Reporting Period Start Date, but Looked After Child Indicator is populated.","The age of the patient should be less than 19 years at the Reporting Period Start Date if the ChildLookedAfter_Indicator field of CYP001MPI table is populated. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D105)","v":0},"CYP001MPI","CYP00187","Record rejected - Person Birth Date is blank and Looked After Child Indicator is populated.","This is the DateOfBirth field of CYP001MPI Table. The record is rejected when the ChildLookedAfter_Indicator field is populated but the DateOfBirth field is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D106)","v":0},"CYP001MPI","CYP00188","Record rejected - Person was 19 years of age or over at the Reporting Period Start Date, but Safeguarding Vulnerability Factors Indicator is populated.","The age of the patient should be less than 19 years at the Reporting Period Start Date if the Safeguarding_Indicator field of CYP001MPI table is populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D107)","v":0},"CYP001MPI","CYP00189","Record rejected - Person Birth Date is blank and Safeguarding Vulnerability Factors Indicator is populated.","This is the DateOfBirth field of CYP001MPI Table. The record is rejected when the Safeguarding_Indicator field is populated but the DateOfBirth field is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D108)","v":0},"CYP001MPI","CYP00196","Record rejected - Person was 19 years of age or over at the Reporting Period Start Date, but NHS Number (Mother) is populated.","The age of the patient should be less than 19 years at the Reporting Period Start Date if the NHSNumber_Mother field of CYP001MPI table is populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D109)","v":0},"CYP001MPI","CYP00197","Record rejected - Person Birth Date is blank and NHS Number (Mother) is populated.","This is the DateOfBirth field of the CYP001MPI table. The record is rejected If the NHSNumber_Mother field is populated but the DateOfBirth field is left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D110)","v":0},"CYP001MPI","CYP00198","Warning - NHS Number Status Indicator Code (Mother) should be completed where the NHS Number (Mother) is blank and Person was under 19 years of age at the Reporting Period Start Date.","This is NHSNumberStatus_Mother field of the CYP001MPI table. If the NHS Number Status Indicator Code (Mother) is blank and the Person was under 19 years of age at the Reporting Period Start Date then a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D111)","v":0},"CYP001MPI","CYP00199","Group rejected - More than one CYP001 provided for this Local Patient Identifier (Extended).","Duplicate records have been submitted using the same LocalPatientId. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D112)","v":0},"CYP002GP","CYP00201","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP002GP table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D113)","v":0},"CYP002GP","CYP00202","Group rejected - More than one CYP002 provided for this Local Patient Identifier (Extended) + General Medical Practice Code (Patient Registration) + Start Date (GMP Patient Registration) combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, GMPCodeReg and StartDateGMPRegistration. All duplicate records will be rejected with group-level rejection error. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D114)","v":0},"CYP002GP","CYP00203","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP002GP table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D115)","v":0},"CYP002GP","CYP00204","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is the LocalPatientID field of the CYP002GP table. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D116)","v":0},"CYP002GP","CYP00205","Record rejected - General Medical Practice Code (Patient Registration) is blank.","The GMPCodeReg field is a mandatory field so cannot be left blank. A list of live GP practices and their codes are available to download from the file downloads page: https://digital.nhs.uk/services/Organisation-data-service/file-downloads/gp-and-gp-practice-related-data. Alternatively, you can search for the GP practice on the ODS portal: https://odsportal.digital.nhs.uk/. If you do not have the GP code then one of the below can be used instead.\nGP Practice Code not applicable - V81998\nGP Practice Code not known - V81999\nNo Registered GP Practice - V81997"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D117)","v":0},"CYP002GP","CYP00206","Record rejected - General Medical Practice Code (Patient Registration) has incorrect data format.","This is the GMPCodeReg field. The expected format for this field is an6. A list of live GP practices and their codes are available to download from the file downloads page: https://digital.nhs.uk/services/Organisation-data-service/file-downloads/gp-and-gp-practice-related-data. Alternatively, you can search for the GP practice on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D118)","v":0},"CYP002GP","CYP00212","Record rejected - Start Date (GMP Patient Registration) has incorrect data format.","This is the StartDateGMPRegistration field. The expected date formats is an10 (CCYY-MM-DD). "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D119)","v":0},"CYP002GP","CYP00213","Record rejected - Start Date (GMP Patient Registration) is after the Reporting Period End Date + 1 day.","This is the StartDateGMPRegistration field. Only activity that took place during the reporting period should be submitted. This means that the StartDateGMPRegistration date should not be before the ReportingPeriodStartDate or after the ReportingPeriodEndDate."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D120)","v":0},"CYP002GP","CYP00214","Record rejected - Start Date (GMP Patient Registration) is before the Person Birth Date.","This is the StartDateGMPRegistration field and is expecting the date that the person registered with a GP. This  Start Date cannot be before the PersonBirthDate (recorded in CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D121)","v":0},"CYP002GP","CYP00215","Record rejected - End Date (GMP Patient Registration) has incorrect data format.","This is the EndDateGMPRegistration field of CYP002GP table. The expected date format is an10 (CCYY-MM-DD). "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D122)","v":0},"CYP002GP","CYP00216","Record rejected - End Date (GMP Patient Registration) is before the Reporting Period Start Date.","This is the EndDateGMPRegistration field. Only activity that took place during the reporting period should be submitted. This means that the EndDateGMPRegistration date should not be before the ReportingPeriodStartDate or after the ReportingPeriodEndDate."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D123)","v":0},"CYP002GP","CYP00217","Record rejected - End Date (GMP Patient Registration) is after the Reporting Period End Date.","This is the EndDateGMPRegistration field. Only activity that took place during the reporting period should be submitted. This means that the EndDateGMPRegistration date should not be before the ReportingPeriodStartDate or after the ReportingPeriodEndDate."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D124)","v":0},"CYP002GP","CYP00218","Record rejected - End Date (GMP Patient Registration) is before the Start Date (GMP Patient Registration).","This is the EndDateGMPRegistration field and is expecting the date on which the person ceased to be registered with a GP. This date cannot be before the StartDateGMPRegistration date (the date that the person registered with the GP)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D125)","v":0},"CYP002GP","CYP00219","Record rejected - Organisation Identifier (GP Practice Responsibility) has incorrect data format.","This is the OrgIDGPPrac field of the CYP002GP table. The expected format is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D126)","v":0},"CYP002GP","CYP00220","Warning - Organisation Identifier (GP Practice Responsibility) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","This is the GMPCodeReg field. The ODS code provided is not recognised as being live. A list of live Organisations and their ODS codes (including GPs, CCGs, healthcare providers, schools etc) are available to download from the file downloads page: https://digital.nhs.uk/services/Organisation-data-service/file-downloads. Alternatively, you can search for the Organisation on the ODS portal: https://odsportal.digital.nhs.uk/. Make sure that the Organisation is listed on the ODS portal or in the list of national codes provided on the file downloads pages and check that the Organisation has not closed."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D127)","v":0},"CYP002GP","CYP00221","Group rejected - More than one CYP002 provided for this Local Patient Identifier (Extended) where End Date (GMP Patient Registration) is null.","Duplicate records have been submitted for this LocalPatientId, where the EndDateGMPRegistration is null. All duplicate records will be rejected with group-level rejection error. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D128)","v":0},"CYP002GP","CYP00222","Warning - An End Date (GMP Patient Registration) has been submitted but there is no corresponding record with a consecutive Start Date (GMP Patient Registration) and different General Medical Practice Code (Patient Registration).","Warning generated  because an EndDateGMPRegistration has been submitted but there is no corresponding record with a consecutive StartDateGMPRegistration and different GMPCodeReg in the CYP002GP table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D129)","v":0},"CYP002GP","CYP00223","Warning - Organisation Identifier (GP Practice Responsibility) is blank.","This is the OrgIDGPPrac field of the CYP002GP table. This field can routinely be left blank, however if populated, it should contain the organisation code of the commissioner that is associated with the patient’s current registered GP Practice."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D130)","v":0},"CYP002GP","CYP00225","Warning - General Medical Practice Code (Patient Registration) provided was not a live organisation in national code tables at any point during the reporting period.","This is the GMPCodeReg field. The ODS code provided is not recognised as being live. A list of live Organisations and their ODS codes (including GPs, CCGs, healthcare providers, schools etc) are available to download from the file downloads page: https://digital.nhs.uk/services/Organisation-data-service/file-downloads. Alternatively, you can search for the Organisation on the ODS portal: https://odsportal.digital.nhs.uk/. Make sure that the Organisation is listed on the ODS portal or in the list of national codes provided on the file downloads pages and check that the Organisation has not closed."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D131)","v":0},"CYP003AccommType","CYP00301","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP003AccommType table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D132)","v":0},"CYP003AccommType","CYP00302","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP003AccommStatus table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D133)","v":0},"CYP003AccommType","CYP00303","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is the LocalPatientID field of CYP003AccommType table. This record is rejected because the LocalPatientID has an incorrect data format. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D134)","v":0},"CYP003AccommType","CYP00304","Record rejected - Accommodation Status Code is blank.","This is the AccommStatus field of CYP003AccommType table. It is an indication of the type of accommodation that a PATIENT currently has. This should be based on the PATIENT's main or permanent residence. This field is mandatory and should not be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D135)","v":0},"CYP003AccommType","CYP00305","Record rejected - Accommodation Status Code has incorrect data format.","This is the AccommStatus field of the CYP003AccommType field. The expected data format is an4."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D136)","v":0},"CYP003AccommType","CYP00306","Warning - Accommodation Status Code contains an invalid national code.","This warning has been received because an invalid national code has been used. An indication of the type of accommodation that a PATIENT currently has. This should be based on the PATIENT's main or permanent residence. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D137)","v":0},"CYP003AccommType","CYP00307","Record rejected - Accommodation Status Recorded Date has incorrect date format.","This is the  AccommStatus_Date field of the CYP003AccommType table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D138)","v":0},"CYP003AccommType","CYP00308","Record rejected - Accommodation Status Recorded Date is after the Reporting Period End Date.","If AccommStatus_Date field is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D139)","v":0},"CYP003AccommType","CYP00309","Group rejected - More than one CYP003 provided for this Local Patient Identifier (Extended) + Accommodation Status Code + Accommodation Status Recorded Date combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, AccommStatus, and AccommStatusRecDate. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D140)","v":0},"CYP003AccommType","CYP00310","Record rejected - Accommodation Status Recorded Date is before Person Birth Date.","If AccommStatus_Date field is earlier than the Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D141)","v":0},"CYP003AccommType","CYP00311","Record rejected - Person Birth Date is blank AND Accommodation Status Recorded Date is before 1 January 1890.","The  AccommStatus_Date field of the CYP003AccommType table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D142)","v":0},"CYP003AccommType","CYP00312","Group rejected - More than one CYP003 provided for this Local Patient Identifier (Extended) where Accomodation Status Recorded Date is null.","Duplicate records have been submitted for this LocalPatientId, where the AccommodationStatusDate is null. All duplicate records will be rejected with group-level rejection error. This date should change with each review even if the Accommodation Status remains the same."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D143)","v":0},"CYP004CarePlanType","CYP00401","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP004CarePlanType table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D144)","v":0},"CYP004CarePlanType","CYP00402","Group rejected - More than one CYP004 provided for this Care Plan Identifier.","Duplicate records have been submitted using the same CarePlanID. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D145)","v":0},"CYP004CarePlanType","CYP00403","Record rejected - Care Plan Identifier is blank.","This is the PlanID field of the CYP004CarePlanType.It is a mandatory field and should not be left blank. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D146)","v":0},"CYP004CarePlanType","CYP00404","Record rejected - Care Plan Identifier has incorrect data format.","This is the PlanID field of the CYP004CarePlanType table. It is a unique identifier for Care Plan. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D147)","v":0},"CYP004CarePlanType","CYP00405","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP004CarePlanType table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D148)","v":0},"CYP004CarePlanType","CYP00406","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is the LocalPatientID field of CYP004CarePlanType table. This record is rejected because the LocalPatientID has an incorrect data format. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D149)","v":0},"CYP004CarePlanType","CYP00407","Record rejected - Care Plan Type (Community Care) is blank.","This is the Plan_Type field of the CYP004CarePlanType table. It is a mandatory field and should not be left blank. The expected data format is max an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D150)","v":0},"CYP004CarePlanType","CYP00408","Record rejected - Care Plan Type (Community Care) has incorrect data format.","This is the Plan_Type field of the CYP004CarePlanType table. The expected data format is max an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D151)","v":0},"CYP004CarePlanType","CYP00409","Record rejected - Care Plan Type (Community Care) contains an invalid Care Plan Type (Community Care).","This is the Plan_Type field of the CYP004CarePlanType table. Record is rejected because the populated Care Plan Type is invalid. Examples of valid codes are \"01\"(Young Persons Transition Plan) , \"02\"(Discharge Plan) and \"03\"(Personalised care and Support Plan)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D152)","v":0},"CYP004CarePlanType","CYP00410","Record rejected - Care Plan Creation Date is blank.","This is the Plan_CreatedDate field of the CYP004CarePlanType table. It is a mandatory field and should not be left blank. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D153)","v":0},"CYP004CarePlanType","CYP00411","Record rejected - Care Plan Creation Date has incorrect date format.","This is the Plan_CreatedDate field of the CYP004CarePlanType table. The expected format is for this field is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D154)","v":0},"CYP004CarePlanType","CYP00412","Record rejected - Care Plan Creation Date is after the Reporting Period End Date.","This is the Plan_CreatedDate field of the CYP004CarePlanType table. If Plan_CreatedDate is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D155)","v":0},"CYP004CarePlanType","CYP00413","Record rejected - Care Plan Creation Date is before the Person Birth Date.","This is the Plan_CreatedDate field of the CYP004CarePlanType table. If Plan_CreatedDate is before the corresponding Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D156)","v":0},"CYP004CarePlanType","CYP00414","Record rejected - Care Plan Creation Time has incorrect data format.","This is the Plan_CreatedDate field of the CYP004CarePlanType table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D157)","v":0},"CYP004CarePlanType","CYP00415","Record rejected - Care Plan Last Updated Date has incorrect date format.","This is the Plan_LastUpdateDate field of the CYP004CarePlanType table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D158)","v":0},"CYP004CarePlanType","CYP00416","Record rejected - Care Plan Last Updated Date is before the Care Plan Creation Date.","If Plan_LastUpdateDate field is before Plan_CreatedDate field of CYP004CarePlanType table, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D159)","v":0},"CYP004CarePlanType","CYP00417","Record rejected - Care Plan Last Updated Date is after the Reporting Period End Date.","This is the Plan_LastUpdateDate field of the CYP004CarePlanType table. If Plan_LastUpdateDate  is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D160)","v":0},"CYP004CarePlanType","CYP00418","Record rejected - Care Plan Last Updated Time has incorrect data format.","This is the Plan_LastUpdateTime field of the CYP004CarePlanType table. The time that the Care Plan was last updated for a patient.  Where the Care Plan has not otherwise been updated this will be the same as the Care Plan Creation Time. The expected data format is an8 HH:MM:SS."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D161)","v":0},"CYP004CarePlanType","CYP00419","Record rejected - Care Plan Implementation Date has incorrect date format.","This is the Plan_CreatedDate field of the CYP004CarePlanType table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D162)","v":0},"CYP004CarePlanType","CYP00420","Record rejected - Care Plan Implementation Date is after the Reporting Period End Date.","This is the Plan_ImplementDate field of the CYP004CarePlanType table. If Plan_ImplementDate is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D163)","v":0},"CYP004CarePlanType","CYP00421","Record rejected - Care Plan Implementation Date is before the Care Plan Creation Date.","If  Plan_ImplementDate field is before Plan_CreatedDate field of the CYP004CarePlanType table, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D164)","v":0},"CYP005CarePlanAgreement","CYP00501","Group rejected - No valid CYP004 group transmitted for this Care Plan Identifier.","Record in the CYP005CarePlanAgreement table rejected because there is no corresponding record in the CYP004 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP004CarePlanType) has been rejected due to a validation error. Reason 2: There is no record with a corresponding CarePlanId in the linked table (CYP004CarePlanType)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D165)","v":0},"CYP005CarePlanAgreement","CYP00502","Group rejected - More than one CYP005 provided for this Care Plan Identifier + Care Plan Agreed By + Care Plan Agreed Date combination.","Duplicate records have been submitted with the same values in the following fields:PlanID, Plan_AgreedBy and Plan_AgreedDate. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D166)","v":0},"CYP005CarePlanAgreement","CYP00503","Record rejected - Care Plan Identifier is blank.","This is the PlanID field of the CYP005CarePlanAgreement table. It is a mandatory field and cannot be blank. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D167)","v":0},"CYP005CarePlanAgreement","CYP00504","Record rejected - Care Plan Identifier has incorrect data format.","This is the PlanID field of the CYP005CarePlanAgreement table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D168)","v":0},"CYP005CarePlanAgreement","CYP00505","Record rejected - Care Plan Agreed By is blank.","The Plan_AgreedBy field of the CYP005CarePlanAgreement table is mandatory and so cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D169)","v":0},"CYP005CarePlanAgreement","CYP00506","Record rejected -Care Plan Agreed By has incorrect data format.","This is the Plan_AgreedBy field of the CYP005CarePlanAgreement table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D170)","v":0},"CYP005CarePlanAgreement","CYP00507","Warning - Care Plan Agreed By contains an invalid national code.","This is the Plan_AgreedBy field of the CYP005CarePlanAgreement table. This warning has been received because an invalid national code has been used. For valid codes, visit https://www.datadictionary.nhs.uk/attributes/care_plan_agreed_by.html "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D171)","v":0},"CYP005CarePlanAgreement","CYP00508","Record rejected - Care Plan Agreed Date has incorrect date format.","This is the Plan_AgreedDate field of the CYP005CarePlanAgreement table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D172)","v":0},"CYP005CarePlanAgreement","CYP00509","Record rejected - Care Plan Agreed Date is before the Care Plan Creation Date.","This is the Plan_AgreedDate field of the CYP005CarePlanAgreement table. This is a required field and the date should not be  before the Plan_CreatedDate field of CYP0004CarePlanType Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D173)","v":0},"CYP005CarePlanAgreement","CYP00510","Record rejected - Care Plan Agreed Date is after the Reporting Period End Date.","This is the Plan_AgreedDate field of the CYP005CarePlanAgreement table. This is a required field and the date should be  before the RP_EndDate of CYP000Header Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D174)","v":0},"CYP005CarePlanAgreement","CYP00511","Record rejected - Care Plan Agreed Date is before the Person Birth Date.","This is the Plan_AgreedDate field of the CYP005CarePlanAgreement table. This is a required field and the date should not be before the DateOfBirth of CYP000Header Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D175)","v":0},"CYP005CarePlanAgreement","CYP00512","Record rejected - Care Plan Agreed Time has incorrect data format.","This is the Plan_AgreedTime field of the CYP005CarePlanAgreement table. The expected date format is an8 HH:MM:SS."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D176)","v":0},"CYP006SocPerCircumstances","CYP00601","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP006SocPerCircumstances table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D177)","v":0},"CYP006SocPerCircumstances","CYP00602","Group rejected - More than one CYP006 provided for this Local Patient Identifier + Social and Personal Circumstance Recorded Date + Social and Personal Cirumstance (SNOMED CT) combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, Circumstance_RecordedDate and SNOMED_ID. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D178)","v":0},"CYP006SocPerCircumstances","CYP00603","Record rejected - Local Patient Identifier (Extended) is blank.","This is the LocalPatientID field of the CYP006SocPerCircumstances table. The record is rejected because the LocalPatientID field is a mandatory field and cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D179)","v":0},"CYP006SocPerCircumstances","CYP00604","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is the LocalPatientID field of the CYP006SocPerCircumstances table. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D180)","v":0},"CYP006SocPerCircumstances","CYP00605","Record rejected - Social and Personal Circumstance (SNOMED CT) is blank.","This is the SNOMED_ID field of CYP006SocPerCircumstances table. If Social and Personal Circumstance (SNOMED CT) fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected. It is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D181)","v":0},"CYP006SocPerCircumstances","CYP00606","Record rejected - Social and Personal Circumstance (SNOMED CT) has failed SNOMED CT checks.","This is the SNOMED_ID field of the CYP006SocPerCircumstances table. The field is expecting a SNOMED code. The SNOMED CT concept ID which is used to identify a Social and Personal Circumstance for a person."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D182)","v":0},"CYP006SocPerCircumstances","CYP00607","Record rejected - Social and Personal Circumstance Recorded Date is blank.","This is the Circumstance_RecordedDate field of the CYP006SocPerCircumstances table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D183)","v":0},"CYP006SocPerCircumstances","CYP00608","Record rejected - Social and Personal Circumstance Recorded Date has incorrect date format.","This is the Circumstance_RecordedDate field of the CYP006SocPerCircumstances table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D184)","v":0},"CYP006SocPerCircumstances","CYP00609","Record rejected - Social and Personal Circumstance Recorded Date is after the Reporting Period End Date.","This is the Circumstance_RecordedDate field of the CYP006SocPerCircumstances table. If Social and Personal Circumstance Recorded Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D185)","v":0},"CYP006SocPerCircumstances","CYP00610","Record rejected - Social and Personal Circumstance Recorded Date is before the Person Birth Date.","This is the Circumstance_RecordedDate field of the CYP006SocPerCircumstances table.. If Social and Personal Circumstance Recorded Date is populated and is before the corresponding Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D186)","v":0},"CYP006SocPerCircumstances","CYP00611","Record rejected - Social and Personal Circumstance (SNOMED CT) has incorrect data format.","The expected data format for Social and Personal Circumstance (SNOMED CT)  is min n6 max n18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D187)","v":0},"CYP007EmpStatus","CYP00701","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP007EmpStatus table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D188)","v":0},"CYP007EmpStatus","CYP00702","Group rejected - More than one CYP007 provided for this Local Patient Identifier (Extended) + Employment Status + Employment Status Recorded Date combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId and EmployStatusRecDate. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D189)","v":0},"CYP007EmpStatus","CYP00703","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP007EmpStatus table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D190)","v":0},"CYP007EmpStatus","CYP00704","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is the LocalPatientId field of the CYP007EmpStatus table. This field can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D191)","v":0},"CYP007EmpStatus","CYP00705","Record rejected - Employment Status is blank.","This is the EmployStatus field. The EmployStatus field is mandatory and cannot be left blank. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D192)","v":0},"CYP007EmpStatus","CYP00706","Record rejected - Employment Status has incorrect data format.","This is the EmployStatus field of the CYP007EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D193)","v":0},"CYP007EmpStatus","CYP00707","Warning - Employment Status contains an invalid national code.","This is the EmployStatus field of the CYP007EmpStatus table. This warning has been received because an invalid national code has been used. For a list of valid national codes, visit https://www.datadictionary.nhs.uk/data_elements/employment_status.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D194)","v":0},"CYP007EmpStatus","CYP00708","Record rejected - Employment Status Recorded Date has incorrect date format.","This is the EmpoymentStatusRecordedDate field of the CYP007EmpStatus table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D195)","v":0},"CYP007EmpStatus","CYP00709","Record rejected - Employment Status Recorded Date is after the Reporting Period End Date.","This is the EmpoymentStatusRecordedDate field of the CYP007EmpStatus table. If Employment Status Recorded Date is populated and is after the Reporting Period End Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D196)","v":0},"CYP007EmpStatus","CYP00710","Warning - Employment Status Recorded Date is blank.","This is the EmpoymentStatusRecordedDate field of the CYP007EmpStatus table. This warning is generated because  EmpoymentStatusRecordedDate field has not been populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D197)","v":0},"CYP007EmpStatus","CYP00711","Record rejected - Employment Status Recorded Date is before the Person Birth Date.","This is the EmpoymentStatusRecordedDate field of the CYP007EmpStatus table. If Employment Status Recorded Date is before the Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D198)","v":0},"CYP007EmpStatus","CYP00712","Record rejected - Weekly Hours Worked has incorrect data format.","This is the WeekHoursWorked field of the CYP007EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D199)","v":0},"CYP007EmpStatus","CYP00713","Warning - Weekly Hours Worked contains an invalid national code.","This is the WeekHoursWorked field of the CYP007EmpStatus table. This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/employment_status.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D200)","v":0},"CYP007EmpStatus","CYP00714","Group rejected - More than one CYP007 provided for a Local Patient Identifier (Extended) where the Employment Status Recorded Date is null.","Duplicate records have been submitted for this LocalPatientId, where the AccommodationStatusDate is null. All duplicate records will be rejected with group-level rejection error. This date should change with each review even if the Accommodation Status remains the same."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D201)","v":0},"CYP101Referral","CYP10101","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP101Referral table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D202)","v":0},"CYP101Referral","CYP10102","Group rejected - More than one CYP101 provided for this Service Request Identifier.","Duplicate records have been submitted using the same ServiceorTeamReferral. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D203)","v":0},"CYP101Referral","CYP10103","Record rejected - Service Request Identifier is blank.","This is the ServiceRequestId field of the CYP101Referral table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D204)","v":0},"CYP101Referral","CYP10104","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the CYP101Referral table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D205)","v":0},"CYP101Referral","CYP10105","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP101Referral table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D206)","v":0},"CYP101Referral","CYP10106","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is the LocalPatientId field of the CYP101Referral table. The expected format is  max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D207)","v":0},"CYP101Referral","CYP10107","Record rejected - Referral Request Received Date is blank.","This is the ReferralRequestReceivedDate field of the CYP101Referral table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D208)","v":0},"CYP101Referral","CYP10108","Record rejected - Referral Request Received Date has incorrect date format.","This is the ReferralRequestReceivedDate field of the CYP101Referral table. The format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D209)","v":0},"CYP101Referral","CYP10109","Record rejected - Referral Request Received Time has incorrect data format.","This is the ReferralRequestReceivedTime field. The format this is expecting is an8 (HH:MM:SS)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D210)","v":0},"CYP101Referral","CYP10110","Record rejected - NHS Service Agreement Line Number has incorrect data format.","This is the ServiceLineAgreement field of the CYP101Referral table. The expected data format is max an10."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D211)","v":0},"CYP101Referral","CYP10111","Record rejected - Organisation Identifier (Code of Commissioner) has incorrect data format.","This is the OrgIDComm field of the CYP101Referral table. The expected format for this field is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D212)","v":0},"CYP101Referral","CYP10112","Warning - Organisation Identifier (Code of Commissioner) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","This is the OrgIDComm field of the CYP101Referral table. We usually see this populated with the code of the CCG as they are often the organisation commissioning health care."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D213)","v":0},"CYP101Referral","CYP10115","Record rejected - Source Of Referral For Community has incorrect data format.","This is the SourceOfReferral field. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is present. Excel can automatically remove leading zeros, so this may require extra attention. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D214)","v":0},"CYP101Referral","CYP10116","Warning - Source of Referral For Community contains an invalid national code.","This is the SourceOfReferral field of the CYP101Referral table . It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is present. Excel can automatically remove leading zeros, so this may require extra attention."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D215)","v":0},"CYP101Referral","CYP10117","Record rejected - Organisation Identifier (Referring) has incorrect data format.","This is the OrgIDReferring field and is the  Organisation Identifier (ODS code) of the Organisation from which the referral is made, such as a GP Practice, NHS Trust or NHS Foundation Trust. The expected format is min an3 max an6. You can search for the ODS code on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D216)","v":0},"CYP101Referral","CYP10118","Warning - Organisation Identifier (Referring) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","This is the OrgIDReferring field of the CYP101Referral table. We usually see this populated with the code of the CCG as they are often the organisation commissioning health care."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D217)","v":0},"CYP101Referral","CYP10119","Record rejected - Referring Care Professional Staff Group (Mental Health and Community Care) has incorrect data format.","This is the Referring_StaffGroup field of theCYP101Referral table. The expected data format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D218)","v":0},"CYP101Referral","CYP10120","Warning - Referring Care Professional Staff Group (Mental Health and Community Care) contains an invalid national code.","This is the Referring_StaffGroup field of theCYP101Referral table. This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D219)","v":0},"CYP101Referral","CYP10121","Record rejected - Priority Type Code has incorrect data format.","This is the Priority_Type field of the CYP101Referral table. The expected data format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D220)","v":0},"CYP101Referral","CYP10122","Warning - Priority Type Code contains an invalid national code.","This is the Priority_Type field of theCYP101Referral table. This warning has been received because an invalid national code has been used. Example of Valid codes are \"1\"(Routine), \"2\"(Urgent) and \"3\"(Two Week Wait). The expected data format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D221)","v":0},"CYP101Referral","CYP10123","Record rejected - Primary Reason For Referral (Community Care) has incorrect data format.","This is the PrimaryReferralReason field of the CYP101Referral table. The expected data format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D222)","v":0},"CYP101Referral","CYP10124","Warning - Primary Reason For Referral (Community Care) contains an invalid national code.","This is the PrimaryReferralReason field of theCYP101Referral table. This warning has been received because an invalid national code has been used. For list of valid national codes, visit https://www.datadictionary.nhs.uk/data_elements/primary_reason_for_referral__community_care_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D223)","v":0},"CYP101Referral","CYP10125","Record rejected - Organisation Identifier (Code of Commissioner) is blank.","This is the OrgIDComm field of the CYP101Referral table. The OrgIDComm field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D224)","v":0},"CYP101Referral","CYP10131","Record rejected - Service Discharge Date has incorrect date format.","This is the ServDischDate field. The expected date formats is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D225)","v":0},"CYP101Referral","CYP10132","Record rejected - Service Discharge Date is before the Reporting Period Start Date.","This is the ServDischDate field of the CYP101Referral table. If Service Discharge Date is populated and is before the start of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D226)","v":0},"CYP101Referral","CYP10133","Record rejected - Service Discharge Date is prior to the associated Referral Request Received Date.","This is the ServDischDate field. ServDischDate is the date a patient was discharged from a service. Therefore the ServDischDate cannot be before the date that the referral was received (ReferralRequestReceivedDate)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D227)","v":0},"CYP101Referral","CYP10134","Record rejected - Discharge Letter Issued Date (Mental Health and Community Care) has incorrect date format.","This is the Discharge_LetterIssuedDate field of the CYP101Referral table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D228)","v":0},"CYP101Referral","CYP10137","Warning - Service Discharge Date is after the Reporting Period End Date plus 24 hours.","This is the ServDischDate field of the CYP101Referral table. This warning is received If Service Discharge Date is populated and is after the end of the reporting period End Date plus 24 hours."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D229)","v":0},"CYP101Referral","CYP10138","Record rejected - Referral Request Received Date is after the Reporting Period End Date.","This is the ReferralRequestReceivedDate field of the CYP101Referral table. If Referral Request Received Date is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D230)","v":0},"CYP101Referral","CYP10139","Record rejected - Service Discharge Date is after the Date And Time Data Set Created.","This is the ServDischDate field of CYP101Referral table. ServDischDate is the date a patient was discharged from a service. Only activity that took place during the reporting period should be submitted. This means that the ServDischDate should not be before the ReportingPeriodStartDate or after the ReportingPeriodEndDate. The DateTimeDatSetCreate field is expecting to be populated with the date that the database was created (may be today's date) and should be after the ReportingPeriodEndDate. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D231)","v":0},"CYP101Referral","CYP10141","Record rejected - Referral Request Received Date is before Person Birth Date.","This is the ReferralRequestReceivedDate field of the CYP101Referral table. If Referral Request Received Date is before Person Birth Date (as included in CYP001), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D232)","v":0},"CYP101Referral","CYP10142","Record Rejected - Person Birth Date is blank AND Referral Request Received Date is before 1 January 1890.","The  ReferralRequest_ReceivedDate field of the CYP101Referral table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D233)","v":0},"CYP101Referral","CYP10143","Record rejected - Discharge Letter Issued Date (Mental Health and Community Care) is before the Referral Request Received Date.","This is the Discharge_LetterIssuedDate of the CYP101Referral table. If Discharge_LetterIssuedDate is populated and is before the Referral Request Received Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D234)","v":0},"CYP101Referral","CYP10144","Warning - Discharge Letter Issued Date (Mental Health and Community Care) is after the Service Discharge Date.","This is the Discharge_LetterIssuedDate field of the CYP101Referral table. The Discharge Letter Issued Date (Mental Health and Community Care) is populated and is after Discharge_Date field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D235)","v":0},"CYP101Referral","CYP10145","Warning - Discharge Letter Issued Date (Mental Health and Community Care) is after the Reporting Period End Date.","This is the Discharge_LetterIssuedDate field of the CYP101Referral table. The Discharge Letter Issued Date (Mental Health and Community Care) is populated and is after the end of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D236)","v":0},"CYP101Referral","CYP10146","Record rejected - Discharge Letter Issued Date (Mental Health and Community Care) is after the Date and Time Data Set Created.","This is the Discharge_LetterIssuedDate field of CYP101Referral Table . Discharge_LetterIssuedDate is the date a patient was discharged from a service. Only activity that took place during the reporting period should be submitted. This means that the Discharge_LetterIssuedDate should not be before the ReportingPeriodStartDate or after the ReportingPeriodEndDate. The DateTimeDatSetCreate field is expecting to be populated with the date that the database was created (may be today's date) and should be after the ReportingPeriodEndDate. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D237)","v":0},"CYP102ServiceTypeReferredTo","CYP10201","Group rejected - No valid CYP101 group transmitted for this Service Request Identifier.","Record in the CYP102ServiceTypeReferredTo table rejected because there is no corresponding record in the CYP101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (CYP101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D238)","v":0},"CYP102ServiceTypeReferredTo","CYP10203","Record rejected - Service Request Identifier is blank.","The ServiceRequestId is a mandatory field so cannot be left blank. The ServiceRequestId is used to uniquely identify the referral and provides a means for linking each referral with additional data associated directly with that referral."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D239)","v":0},"CYP102ServiceTypeReferredTo","CYP10204","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the CYP102ServiceTypeReferredTo table. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D240)","v":0},"CYP102ServiceTypeReferredTo","CYP10205","Record rejected - Service Or Team Type Referred To (Community Care) has incorrect data format.","This is the TeamType  field of the CYP102ServiceTypeReferredTo  table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D241)","v":0},"CYP102ServiceTypeReferredTo","CYP10206","Warning - Service Or Team Type Referred To (Community Care) contains an invalid national code.","This is the TeamType  field of the CYP102ServiceTypeReferredTo  table. This warning has been received because an invalid national code has been used. For list of valid codes, Visit https://www.datadictionary.nhs.uk/data_elements/service_or_team_type_referred_to__community_care_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D242)","v":0},"CYP102ServiceTypeReferredTo","CYP10207","Record rejected - Service Or Team Type Referred To (Community Care) is blank.","The TeamType field is a mandatory field so cannot be left blank. The TeamType is used to uniquely identify the type of community service or team that the patient has been referred into"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D243)","v":0},"CYP102ServiceTypeReferredTo","CYP10208","Record rejected - Referral Closure Date has incorrect date format.","This is the Referral_ClosureDate field of the CYP102ServiceTypeReferredTo table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D244)","v":0},"CYP102ServiceTypeReferredTo","CYP10209","Record rejected - Referral Closure Date is after the Date and Time Data Set Created.","If Referral_ClosureDate field of the CYP102ServiceTypeReferredTo table is populated and is after the corresponding FileCreation_DateTime of CYP001Header table , the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D245)","v":0},"CYP102ServiceTypeReferredTo","CYP10210","Warning - Referral Closure Date is after the Reporting Period End Date.","This is the Referral_ClosureDate field of the CYP102ServiceTypeReferredTo table. This warning has been received because the Referral Closure Date is populated and is after the end of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D246)","v":0},"CYP102ServiceTypeReferredTo","CYP10211","Record rejected - Referral Closure Reason has incorrect data format.","This is the Referral_ClosureReason  field of the CYP102ServiceTypeReferredTo table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D247)","v":0},"CYP102ServiceTypeReferredTo","CYP10212","Warning - Referral Closure Reason contains an invalid national code.","This is the Referral_ClosureReason  field of the CYP102ServiceTypeReferredTo table. This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/referral_closure_reason.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D248)","v":0},"CYP102ServiceTypeReferredTo","CYP10213","Record rejected - Referral Closure Date is after the Service Discharge Date.","If Referral_ClosureDate field of the CYP102ServiceTypeReferredTo table is populated and is after the corresponding Discharge_Date field of CYP101Referral table , the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D249)","v":0},"CYP102ServiceTypeReferredTo","CYP10214","Group rejected - More than one CYP102 provided for this Care Professional Team Local Identifier + Service Request Identifier combination.","Duplicate records have been submitted with the same values in the following fields: CareProfTeamLocalId and ServiceRequestId. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D250)","v":0},"CYP102ServiceTypeReferredTo","CYP10215","Record rejected - Referral Rejection Reason has incorrect data format.","This is the Referral_RejectionReason  field of the CYP102ServiceTypeReferredTo table. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D251)","v":0},"CYP102ServiceTypeReferredTo","CYP10216","Warning - Referral Rejection Reason contains an invalid national code.","This is the Referral_RejectionReason  field of the CYP102ServiceTypeReferredTo table. This warning has been received because an invalid national code has been used. Example of Valid codes are \"01\"(Duplicate), \"02\"(Inappropriate) and \"03\"(Incomplete). The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D252)","v":0},"CYP102ServiceTypeReferredTo","CYP10217","Record rejected - Referral Rejection Date has incorrect date format.","This is the Referral_ClosureDate field of the CYP102ServiceTypeReferredTo table.If the populated record have a wrong date format, the record will be rejected. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D253)","v":0},"CYP102ServiceTypeReferredTo","CYP10218","Record rejected - Referral Rejection Date is before the Reporting Period Start Date.","This is the Referral_RejectionDate field of the CYP102ServiceTypeReferredTo table. If  Referral Rejection  Date is populated and is before the start of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D254)","v":0},"CYP102ServiceTypeReferredTo","CYP10219","Record rejected - Referral Rejection Date is after the Date and Time Data Set Created.","This is the Referral_RejectionDate of the CYP102ServiceTypeReferredTo table. This is a required field and the date should be  before the FileCreation_DateTime field of CYP000Header Table ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D255)","v":0},"CYP102ServiceTypeReferredTo","CYP10220","Warning - Referral Rejection Date is after the Reporting Period End Date.","This is the Referral_RejectionDate of the CYP102ServiceTypeReferredTo table. This warning is received If the Referral Rejection Date is populated and is after the end of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D256)","v":0},"CYP102ServiceTypeReferredTo","CYP10221","Record rejected - Referral Rejection Date is after the Service Discharge Date.","The Referral_RejectionDate field of the CYP102ServiceTypeReferredTo table should be less than or equal to the corresponding Discharge_Date of CYP101Referral table, else the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D257)","v":0},"CYP102ServiceTypeReferredTo","CYP10222","Warning - Referral Closure Date is populated but Referral Closure Reason is blank.","If Referral_ClosureDate field is populated but the corresponding  Referral_ClosureReason field of CYP102ServiceTypeReferredTo table is blank, a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D258)","v":0},"CYP102ServiceTypeReferredTo","CYP10223","Warning - Referral Rejection Date is populated but Referral Rejection Reason is blank.","If Referral_RejectionDate field is populated but the corresponding Referral_RejectionReason field of CYP102ServiceTypeReferredTo table is blank, a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D259)","v":0},"CYP102ServiceTypeReferredTo","CYP10224","Record rejected - Care Professional Team Local Identifier has incorrect data format.","This is the TeamID_Local field of CYP102ServiceTypeRefferedTo table.  The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D260)","v":0},"CYP102ServiceTypeReferredTo","CYP10225","Record rejected - Referral Closure Date is before the Reporting Period Start Date.","This is the Referral_ClosureDate field of the CYP102ServiceTypeReferredTo table. If  Referral Closure  Date is populated and is before the start of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D261)","v":0},"CYP102ServiceTypeReferredTo","CYP10226","Record rejected - Referral Closure Date is before the Referral Request Received Date.","This is the eferral_ClosureDate field of the CYP102ServiceTypeReferredTo table. If  Referral Closure  Date is populated and is before the Referral Request Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D262)","v":0},"CYP102ServiceTypeReferredTo","CYP10227","Record rejected - Referral Rejection Date is before the Referral Request Received Date.","This is the Referral_RejectionDate of the CYP102ServiceTypeReferredTo table. If the Referral Rejection Date is before the Referral Request Received Date , the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D263)","v":0},"CYP103OtherReasonReferral","CYP10301","Group rejected - More than one CYP103 provided for this Service Request Identifier + Other Reason For Referral (Community Care) combination.","Duplicate records have been submitted with the same values in the following fields: ServiceRequestId and OtherReasonReferCC. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D264)","v":0},"CYP103OtherReasonReferral","CYP10302","Group rejected - No valid CYP101 group transmitted for this Service Request Identifier.","Record in the CYP103OtherReasonReferral table rejected because there is no corresponding record in the CYP101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (CYP101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D265)","v":0},"CYP103OtherReasonReferral","CYP10303","Record rejected - Service Request Identifier is blank.","The ServiceRequestId is a mandatory field so cannot be left blank. The ServiceRequestId is used to uniquely identify the referral and provides a means for linking each referral with additional data associated directly with that referral."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D266)","v":0},"CYP103OtherReasonReferral","CYP10304","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field and can accept up to 20 characters(max an20)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D267)","v":0},"CYP103OtherReasonReferral","CYP10305","Record rejected - Other Reason For Referral (Community Care) is blank.","This is the ReferralReason_Othe field of the CYP103OtherReasonReferral table. This is a mandatory field so cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D268)","v":0},"CYP103OtherReasonReferral","CYP10306","Record rejected - Other Reason For Referral (Community Care) has incorrect data format.","This is the ReferralReason_Othe field of the CYP103OtherReasonReferral table. The expected date format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D269)","v":0},"CYP103OtherReasonReferral","CYP10307","Warning - Other Reason For Referral (Community Care) contains an invalid national code.","This is the ReferralReason_Othe field of the CYP103OtherReasonReferral table. This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/other_reason_for_referral__community_care_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D270)","v":0},"CYP104RTT","CYP10401","Group rejected - No valid CYP101 group transmitted for this Service Request Identifier.","Record in the CYP104RTT table rejected because there is no corresponding record in the CYP101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (CYP101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D271)","v":0},"CYP104RTT","CYP10402","Group rejected - More than one CYP104 provided for this Service Request Identifier + Referral To Treatment Period Start Date + Referral To Treatment Period End Date + Referral To Treatment Period Status.","Duplicate records have been submitted with the same values in the following fields: ServiceRequestId, ReferToTreatPeriodStartDate, ReferToTreatPeriodEndDate and ReferToTreatPeriodStatus. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D272)","v":0},"CYP104RTT","CYP10403","Record rejected - Service Request Identifier is blank.","The ServiceRequestId is a mandatory field so cannot be left blank. The ServiceRequestId is used to uniquely identify the referral and provides a means for linking each referral with additional data associated directly with that referral."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D273)","v":0},"CYP104RTT","CYP10404","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field and can accept up to 20 characters(max an20)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D274)","v":0},"CYP104RTT","CYP10405","Record rejected - Referral To Treatment Period End Date is after the Reporting Period End Date.","This is the RTT_EndDate of the CYP104RTT table. If the Referral To Treatment Period End Date  is populated and is after the end of the reporting period, the record will be rejected. .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D275)","v":0},"CYP104RTT","CYP10406","Record rejected - Unique Booking Reference Number (Converted) has incorrect data format.","This is the BookingReference  field of the CYP104RTT table. The expected data format is n12."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D276)","v":0},"CYP104RTT","CYP10407","Record rejected - Patient Pathway Identifier has incorrect data format.","This is the PatientPathwayID field of the CYP104RTT table. The expected data format is an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D277)","v":0},"CYP104RTT","CYP10408","Record rejected - Organisation Identifier (Patient Pathway Identifier Issuer) has incorrect data format.","If Organisation Identifier (Patient Pathway Identifier Issuer) is not in national tables a warning will be output. The expected data format is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D278)","v":0},"CYP104RTT","CYP10409","Warning - Organisation Identifier (Patient Pathway Identifier Issuer) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The PatientPathwayID_OrgID field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D279)","v":0},"CYP104RTT","CYP10410","Record rejected - Waiting Time Measurement Type has incorrect data format.","This is the WaitingTime_MeasurementType field of the CYP104RTT table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D280)","v":0},"CYP104RTT","CYP10411","Warning - Waiting Time Measurement Type contains an invalid national code.","This is the WaitingTime_MeasurementType field of the CYP104RTT table. This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/waiting_time_measurement_type.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D281)","v":0},"CYP104RTT","CYP10412","Record rejected - Referral To Treatment Period Start Date has incorrect date format.","This is the RTT_StartDate of the CYP104RTT table. The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D282)","v":0},"CYP104RTT","CYP10413","Record rejected - Referral To Treatment Period End Date has incorrect date format.","This is the RTT_EndDate of the CYP104RTT table. The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D283)","v":0},"CYP104RTT","CYP10414","Record rejected - Referral To Treatment Period Status has incorrect data format.","This is the RTT_Status field of the CYP104RTT table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D284)","v":0},"CYP104RTT","CYP10415","Warning - Referral To Treatment Period Status contains an invalid national code.","This is the RTT_Status field of the CYP104RTT table.  This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/referral_to_treatment_period_status.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D285)","v":0},"CYP104RTT","CYP10416","Record rejected - Referral To Treatment Period End Date is before the Referral To Treatment Period Start Date.","This is the RTT_EndDate of the CYP104RTT table. If the Referral To Treatment Period End Date is populated and is before the Start Date of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D286)","v":0},"CYP104RTT","CYP10417","Record rejected - Referral To Treatment Period Start Date is after the Reporting Period End Date.","This is the RTT_StartDate of the CYP104RTT table. If the Referral To Treatment Period Start Date is populated and is after the end of the reporting period, the record will be rejected. .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D287)","v":0},"CYP104RTT","CYP10418","Group rejected - More than one CYP104 provided for this Unique Booking Reference Number (Converted).","Duplicate records have been submitted for BookingReference. All duplicate records will be rejected with group-level rejection error. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D288)","v":0},"CYP104RTT","CYP10419","Group rejected - More than one CYP104 provided for this Patient Pathway Identifier.","Duplicate records have been submitted for PatientPathwayID. All duplicate records will be rejected with group-level rejection error. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D289)","v":0},"CYP104RTT","CYP10422","Record rejected - Referral To Treatment Period End Date is before the Referral Request Received Date.","This is the RTT_EndDate of the CYP104RTT table. If the Referral To Treatment Period End Date is populated and is before the Referral Request Received Date, the record will be rejected. The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D290)","v":0},"CYP104RTT","CYP10423","Record rejected - Referral To Treatment Period Start Date is before Person Birth Date.","This is the RTT_StartDate of the CYP104RTT table. This is a required field and the date should not be before DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D291)","v":0},"CYP104RTT","CYP10424","Record Rejected - Referral To Treatment Period Start Time has incorrect data format.","This is the RTT_StartTime field of the CYP104RTT table. The expected data format is an8 HH:MM:SS."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D292)","v":0},"CYP104RTT","CYP10425","Record Rejected - Referral To Treatment Period End Time has incorrect data format.","This is the RTT_EndTime field of the CYP104RTT table. The expected data format is an8 HH:MM:SS."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D293)","v":0},"CYP105OnwardReferral","CYP10502","Group rejected - No valid CYP101 group transmitted for this Service Request Identifier.","Record in the CYP105OnwardReferral table rejected because there is no corresponding record in the CYP101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (CYP101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D294)","v":0},"CYP105OnwardReferral","CYP10503","Record rejected - Service Request Identifier is blank.","The ServiceRequestId is a mandatory field so cannot be left blank. The ServiceRequestId is used to uniquely identify the referral and provides a means for linking each referral with additional data associated directly with that referral."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D295)","v":0},"CYP105OnwardReferral","CYP10504","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field and can accept up to 20 characters(max an20)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D296)","v":0},"CYP105OnwardReferral","CYP10505","Record rejected - Onward Referral Date is blank.","This is the OnwardReferDate field of the CYP105OnwardReferral table. This is a mandatory field and cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D297)","v":0},"CYP105OnwardReferral","CYP10506","Record rejected - Onward Referral Date has incorrect data format.","This is the Onward_ReferralDate field of CYP105OnwardReferral table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D298)","v":0},"CYP105OnwardReferral","CYP10507","Record rejected - Onward Referral Reason has incorrect data format.","This is the OnwardReferReason field of the CYP105OnwardReferral table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D299)","v":0},"CYP105OnwardReferral","CYP10508","Warning - Onward Referral Reason contains an invalid national code.","This is the OnwardReferReason field of the CYP105OnwardReferral table.  This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/onward_referral_reason.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D300)","v":0},"CYP105OnwardReferral","CYP10509","Record rejected - Organisation Identifier (Receiving) has incorrect data format.","This is the OrgIDReceiving field of the CYP105OnwardReferral table. The expected format for this field is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D301)","v":0},"CYP105OnwardReferral","CYP10510","Warning - Organisation Identifier (Receiving) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The OrgID_Receiving field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D302)","v":0},"CYP105OnwardReferral","CYP10511","Group rejected - More than one CYP105 provided for this Service Request Identifier + Onward Referral Date + Onward Referral Reason.","Duplicate records have been submitted with the same values in the following fields: ServiceRequestID, Onward_ReferralDate and Onward_ReferralReason. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D303)","v":0},"CYP105OnwardReferral","CYP10512","Record rejected - Onward Referral Date is after the Reporting Period End Date.","This is the OnwardReferDate field of the CYP105OnwardReferral table. If Onward Referral Date is populated and is after the Reporting Period End Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D304)","v":0},"CYP105OnwardReferral","CYP10513","Record rejected - Onward Referral Date is before the Referral Request Received Date.","This is the OnwardReferDate field of the CYP105OnwardReferral table. If Onward Referral Date is before the Referral Request Received Date then the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D305)","v":0},"CYP201CareContact","CYP20101","Record rejected - Care Contact Date is before the Reporting Period Start Date.","This is the CareContDate field of the CYP201CareContact table. The Care Contact Date cannot be before the Reporting Period Start Date of the reporting period. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D306)","v":0},"CYP201CareContact","CYP20102","Group rejected - No valid CYP101 group transmitted for this Service Request Identifier.","Record in the CYP201CareContact table rejected because there is no corresponding record in the CYP101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (CYP101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D307)","v":0},"CYP201CareContact","CYP20103","Record rejected - Care Contact Identifier is blank.","The CareContactId field of the CYP201CareContact table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D308)","v":0},"CYP201CareContact","CYP20104","Record rejected - Care Contact Identifier has incorrect data format.","This is the CareContactId field of the CYP201CareContact table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D309)","v":0},"CYP201CareContact","CYP20105","Record rejected - Service Request Identifier is blank.","The ServiceRequestId field of the CYP201CareContact table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in the CYP101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D310)","v":0},"CYP201CareContact","CYP20106","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the CYP201CareContact table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D311)","v":0},"CYP201CareContact","CYP20107","Record rejected - Care Contact Date is blank.","This is the CareContDate field of the CYP201CareContact table. The Care Contact Date is a mandatory field and should not be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D312)","v":0},"CYP201CareContact","CYP20108","Record rejected - Care Contact Date has incorrect date format.","This is the CareContDate field of the CYP201CareContact table. The expected date format is an10 (CCYY-MM-DD). "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D313)","v":0},"CYP201CareContact","CYP20109","Record rejected - Care Contact Time has incorrect time format.","This is the CareContTime field of the CYP201CareContact table. The time format is an8 (HH:MM:SS)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D314)","v":0},"CYP201CareContact","CYP20110","Record rejected - Organisation Identifier (Code of Commissioner) has incorrect data format.","This is the OrgIDComm field of the CYP201CareContact table. The expected format for this field is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D315)","v":0},"CYP201CareContact","CYP20111","Warning - Organisation Identifier (Code of Commissioner) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The OrgID_Commissioner field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D316)","v":0},"CYP201CareContact","CYP20112","Record rejected - Administrative Category Code has incorrect data format.","This is the AdminCategory field of the CYP201CareContact table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format for this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D317)","v":0},"CYP201CareContact","CYP20113","Warning - Administrative Category Code contains an invalid national code.","This is the AdminCategory field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used. Example of Valid codes are \"01\"(NHS Patient),\"02\"(Private Patient),\"03\"(Amenity Patient) and \"04\"(Category II Patient)"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D318)","v":0},"CYP201CareContact","CYP20114","Record rejected - Clinical Contact Duration Of Care Contact has incorrect data format.","This is the CareContact_Duration field of the CYP201CareContact table. The expected format for this field is max n4."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D319)","v":0},"CYP201CareContact","CYP20115","Record rejected - Consultation Type has incorrect data format.","This is the Consultation_Type field. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is present. Excel can automatically remove leading zeros, so this may require extra attention."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D320)","v":0},"CYP201CareContact","CYP20116","Warning - Consultation Type contains an invalid national code.","This is the Consultation_Type field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used. Example of valid codes  are \"01\"(Initial Consultation) and \"02\"(Follow-up Consultation)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D321)","v":0},"CYP201CareContact","CYP20117","Record rejected - Care Contact Subject has incorrect data format.","This is the CareContSubj field. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is present . Excel can automatically remove leading zeros, so this may require extra attention. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D322)","v":0},"CYP201CareContact","CYP20118","Warning - Care Contact Subject contains an invalid national code.","This is the Consultation_MediumUsed field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used. Example of valid codes  are \"01\"(Patient) and \"02\"(Patient Proxy)"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D323)","v":0},"CYP201CareContact","CYP20119","Record rejected - Consultation Medium Used has incorrect data format.","This is the Consultation_MediumUsed  field of the CYP201CareContact table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D324)","v":0},"CYP201CareContact","CYP20120","Warning - Consultation Medium Used contains an invalid national code.","This is the Consultation_MediumUsed field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/consultation_medium_used.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D325)","v":0},"CYP201CareContact","CYP20121","Record rejected - Activity Location Type Code has incorrect data format.","This is the Activity_LocationType field of the CYP201CareContact table. The Technical Output Specification shows the values that are acceptable for this field. The expected format of this field is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D326)","v":0},"CYP201CareContact","CYP20122","Warning - Activity Location Type Code contains an invalid national code.","This is the Activity_LocationType field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/activity_location_type_code.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D327)","v":0},"CYP201CareContact","CYP20123","Record rejected - Organisation Site Identifier (Of Treatment) has incorrect data format.","If Organisation Site Identifier (Of Treatment) is not in national tables, a warning will be output.  Default codes for this data item can be found in the Technical Glossary tab. The expected data format is min an5 max an9."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D328)","v":0},"CYP201CareContact","CYP20124","Warning - Organisation Site Identifier (Of Treatment) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The Treatment_OrgSiteID field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D329)","v":0},"CYP201CareContact","CYP20125","Record rejected - Attended Or Did Not Attend Code has incorrect data format.","This is the AttendOrNot field of the CYP201CareContact table. The expected format of this field is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D330)","v":0},"CYP201CareContact","CYP20126","Warning - Attended Or Did Not Attend Code contains an invalid national code.","This is the AttendOrNot field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D331)","v":0},"CYP201CareContact","CYP20127","Record rejected - Care Contact Date is after the Reporting Period End Date.","This is the CareContDate field of the CYP201CareContact table. The Care Contact Date cannot be after the Reporting Period End Date of the reporting period. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D332)","v":0},"CYP201CareContact","CYP20129","Record rejected - Earliest Reasonable Offer Date has incorrect date format.","This is the EarliestReasonOfferDate field of CYP201CareContact table. The expected date formats is an10 (CCYY-MM-DD). "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D333)","v":0},"CYP201CareContact","CYP20130","Record rejected - Earliest Clinically Appropriate Date has incorrect date format.","This is the EarliestClinAppDate field of CYP201CareContact table. The expected date formats is an10 (CCYY-MM-DD). "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D334)","v":0},"CYP201CareContact","CYP20131","Record rejected - Care Contact Cancellation Date has incorrect date format.","This is the CareContCancelDate field of CYP201CareContact table. The expected date formats is an10 (CCYY-MM-DD). "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D335)","v":0},"CYP201CareContact","CYP20132","Record rejected - Care Contact Cancellation Reason has incorrect data format.","The Contact_CancellationReason field is the reason that a Care Contact was cancelled. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is presen. Excel can automatically remove leading zeros, so this may require extra attention. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D336)","v":0},"CYP201CareContact","CYP20133","Warning - Care Contact Cancellation Reason contains an invalid national code.","This is the Contact_CancellationReason field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used. Example of valid codes are \"01\"(Cancelled for Clinical Reasons) and \"02\"(Cancelled for Non-clinical Reasons)"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D337)","v":0},"CYP201CareContact","CYP20134","Record rejected - Replacement Appointment Booked Date has incorrect date format.","This is the ReplacementAppointment_BookedDate field of the CYP201CareContact table. The expected format of this field is  an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D338)","v":0},"CYP201CareContact","CYP20135","Record rejected - Replacement Appointment Date Offered has incorrect date format.","The ReplacementAppointment_OfferedDate field of the CYP201CareContact table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D339)","v":0},"CYP201CareContact","CYP20140","Record rejected - Group Therapy Indicator has incorrect data format.","This is the GroupTherapyIndicator field of the CYP201CareContact table. The Technical Output Specification shows the values that are acceptable for this field. The expected format of this field is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D340)","v":0},"CYP201CareContact","CYP20141","Warning - Group Therapy Indicator contains an invalid national code.","This is the GroupTherapyIndicator field of the CYP201CareContact table.  This warning has been received because an invalid national code has been used."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D341)","v":0},"CYP201CareContact","CYP20142","Group rejected - More than one CYP201 provided for this Care Contact Identifier.","Duplicate records have been submitted using the same CareContactId. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D342)","v":0},"CYP201CareContact","CYP20143","Warning - Care Contact Cancellation Date is populated but Care Contact Cancellation Reason is blank.","The Contact_CancellationDate field of the CYP201CareContact table. Warning is because the corresponding Contact_CancellationReason field is blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D343)","v":0},"CYP201CareContact","CYP20144","Record rejected - Care Professional Team Local Identifier has incorrect data format.","This is the TeamID_Local field of CYP201CareContact table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D344)","v":0},"CYP201CareContact","CYP20145","Warning - No valid CYP102 group transmitted for this Care Professional Team Local Identifier.","Warning generated for CYP201CareContact record because there is no corresponding record in the CYP102ServiceTypeReferredTo table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP102ServiceTypeReferredTo) has been rejected due to a validation error. Reason 2: There is no record with a corresponding CareProfTeamLocalId in the linked table (CYP102ServiceTypeReferredTo)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D345)","v":0},"CYP201CareContact","CYP20146","Record rejected - Earliest Reasonable Offer Date is before the Referral Request Received Date.","This is the ReasonableOffer_Date field of the CYP201CareContact table. This is a required field and the date should not be before the ReferralRequest_ReceivedDate of CYP001Referral Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D346)","v":0},"CYP201CareContact","CYP20147","Warning - Earliest Reasonable Offer Date is after the Care Contact Date.","This is the ReasonableOffer_Date field of the CYP201CareContact table. This is a required field and the date should not be after the Contact_Date of CYP201CareContact Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D347)","v":0},"CYP201CareContact","CYP20148","Record rejected - Earliest Reasonable Offer Date is more than 5 years after the Date and Time Data Set Created.","This is the ReasonableOffer_Date field of the CYP201CareContact table. This is a required field and the date should not be more than 5 years after  the FileCreation_DateTime field of CYP000Header Table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D348)","v":0},"CYP201CareContact","CYP20149","Record rejected - Earliest Clinically Appropriate Date is before the Referral Request Received Date.","This is the ClinicallyAppropriate_Date field of the CYP201CareContact table. This is a required field and the date should not be before the corresponding  ReferralRequest_ReceivedDate field of CYP101Referral Table ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D349)","v":0},"CYP201CareContact","CYP20150","Record rejected - Earliest Clinically Appropriate Date is more than 5 years after the Date And Time Data Set Created.","This is the ClinicallyAppropriate_Date field of the CYP201CareContact table. This is a required field and the date should not be more than 5 years after  the FileCreation_DateTime field of CYP000Header Table ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D350)","v":0},"CYP201CareContact","CYP20151","Record rejected - Care Contact Cancellation Date is before the Referral Request Received Date.","This is the Contact_CancellationDate field of the CYP201CareContact table. This is a required field and the date should not be before the corresponding  ReferralRequest_ReceivedDate field of CYP101Referral Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D351)","v":0},"CYP201CareContact","CYP20152","Record rejected - Care Contact Cancellation Date is after the Care Contact Date.","This is the Contact_CancellationDate field of the CYP201CareContact table. This is a required field and the date should not be after the corresponding  ReferralRequest_ReceivedDate field of CYP101Referral Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D352)","v":0},"CYP201CareContact","CYP20153","Record rejected - Care Contact Cancellation Date is after the Date and Time Data Set Created.","This is the Contact_CancellationDate field of the CYP201CareContact table. This is a required field and the date should not be after the corresponding  FileCreation_DateTime field of CYP000Header Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D353)","v":0},"CYP201CareContact","CYP20154","Warning - Care Contact Cancellation Date is after the Reporting Period End Date.","This is the Contact_CancellationDate field of the CYP201CareContact table. This is a required field and the date should not be after the Reporting Period End Date .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D354)","v":0},"CYP201CareContact","CYP20155","Record rejected - Replacement Appointment Date Offered is before the Referral Request Received Date.","This is the ReplacementAppointment_OfferedDate field of the CYP201CareContact table. This is a required field and the date should not be before the corresponding  ReferralRequest_ReceivedDate field of CYP101Referral Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D355)","v":0},"CYP201CareContact","CYP20156","Record rejected - Replacement Appointment Date Offered is before Replacement Appointment Booked Date.","This is the ReplacementAppointment_OfferedDate field of the CYP201CareContact table. This is a required field and the date should not be before the corresponding ReplacementAppointment_BookedDate field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D356)","v":0},"CYP201CareContact","CYP20157","Record rejected - Replacement Appointment Date Offered is more than 5 years after the Date and Time Data Set Created.","This is theReplacementAppointment_OfferedDate field of the CYP201CareContact table. This is a required field and the date should not be more than 5 years after  the FileCreation_DateTime field of CYP000Header Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D357)","v":0},"CYP201CareContact","CYP20158","Record rejected - Replacement Appointment Booked Date is before the referral Request Received Date.","This is the ReplacementAppointment_BookedDate field of the CYP201CareContact table. This is a required field and the date should not be before the corresponding  ReferralRequest_ReceivedDate field of CYP101Referral Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D358)","v":0},"CYP201CareContact","CYP20159","Warning - Replacement Appointment Booked Date is after the Reporting Period End Date.","This is the ReplacementAppointment_BookedDate field of the CYP201CareContact table. This is a required field and the date should not be after the Reporting Period End Date .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D359)","v":0},"CYP201CareContact","CYP20160","Record rejected - Replacement Appointment Booked Date is after the Date and Time Data Set Created.","This is the ReplacementAppointment_BookedDate field of the CYP201CareContact table. This is a required field and the date should not be  after  the FileCreation_DateTime field of CYP000Header Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D360)","v":0},"CYP201CareContact","CYP20161","Record rejected - Care Contact Date is before the Referral Request Received Date.","This is the CareContDate field of the CYP201CareContact table. If Care Contact Date is before the Referral Request Received Date then the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D361)","v":0},"CYP202CareActivity","CYP20201","Group rejected - More than one CYP202 provided for this Care Activity Identifier.","Duplicate records have been submitted using the same CareActivityId. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D362)","v":0},"CYP202CareActivity","CYP20203","Group rejected - No valid CYP201 group transmitted for this Care Contact Identifier.","Record in the CYP202CareActivity table rejected because there is no corresponding record in the CYP201CareContact table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP201CareContact) has been rejected due to a validation error. Reason 2: There is no record with a corresponding CareContactId in the linked table (CYP201CareContact)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D363)","v":0},"CYP202CareActivity","CYP20204","Record rejected - Care Contact Identifier is blank.","The CareContactId field of the CYP202CareContact table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D364)","v":0},"CYP202CareActivity","CYP20205","Record rejected - Care Contact Identifier has incorrect data format.","This is the CareContactId field of the CYP202CareContact table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D365)","v":0},"CYP202CareActivity","CYP20206","Record rejected - Community Care Activity Type is blank.","This is the Activity_Type field of the CYP202CareActivity table. This is mandatory field and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D366)","v":0},"CYP202CareActivity","CYP20207","Record rejected - Community Care Activity Type has incorrect data format.","This is the Activity_Type field of the CYP202CareActivity table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D367)","v":0},"CYP202CareActivity","CYP20208","Warning - Community Care Activity Type contains an invalid national code.","This is the Activity_Type field of the CYP202CareActivity table. This warning has been received because an invalid national code has been used. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is present. Excel can automatically remove leading zeros, so this may require extra attention."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D368)","v":0},"CYP202CareActivity","CYP20211","Record rejected - Clinical Contact Duration Of Care Activity has incorrect data format.","This is the CareActivity_Duration field of the CYP202CareActivity table. The expected format is max n4."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D369)","v":0},"CYP202CareActivity","CYP20212","Record rejected - Care Activity Identifier is blank.","The CareActivityID field of the CYP202CareActivity table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D370)","v":0},"CYP202CareActivity","CYP20213","Record rejected - Care Activity Identifier has incorrect data format.","This is the CareActivityID field of the CYP202CareActivity table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D371)","v":0},"CYP202CareActivity","CYP20214","Record rejected - Care Professional Local Identifier has incorrect data format.","This is the CareProfessionalID_Local field of CYP202CareActivity table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D372)","v":0},"CYP202CareActivity","CYP20215","Record rejected - Procedure Scheme In Use has incorrect data format.","This is the Procedure_Scheme field of the CYP202CareActivity table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D373)","v":0},"CYP202CareActivity","CYP20216","Warning - Procedure Scheme In Use contains an invalid national code.","This is the Procedure_Scheme field of the CYP202CareActivity table. The expected format is an2. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/procedure_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D374)","v":0},"CYP202CareActivity","CYP20217","Record rejected - Coded Procedure (Clinical Terminology) has incorrect data format.","This is the CodedProcedure field of the CYP202CareActivity table. The expected format is min an5 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D375)","v":0},"CYP202CareActivity","CYP20219","Warning - Procedure Scheme In Use is populated, but Coded Procedure (Clinical Terminology) is blank.","The Procedure_Scheme field of the CYP202CareActivity table. Warning is received because the corresponding CodedProcedure field is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D376)","v":0},"CYP202CareActivity","CYP20220","Record rejected - Coded Procedure (Clinical Terminology) is populated, but no valid Procedure Scheme In Use has been provided.","This is the CodedProcedure field of the CYP202CareActivity table. Record is rejected because no valid record has been provided for the corresponding  Procedure_Scheme field of the CYP202CareActivity table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D377)","v":0},"CYP202CareActivity","CYP20221","Record rejected - Observation Value has incorrect data format.","The numeric value resulting from a clinical observation. The expected format is max an10."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D378)","v":0},"CYP202CareActivity","CYP20222","Record rejected - UCUM Unit Of Measurement has incorrect data format.","This is the UC_UnitOfMeasurement field of the CYP202CareActivity table. The expected format is max an10."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D379)","v":0},"CYP202CareActivity","CYP20224","Record rejected - Finding Scheme In Use has incorrect data format.","This is the FindSchemeInUse field of the CYP202CareActivity table. The values expected for this field are 01, 04. Please make sure the leading zero is shown. The expected format for this field is an2. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D380)","v":0},"CYP202CareActivity","CYP20225","Warning - Finding Scheme In Use contains an invalid national code.","This is the FindSchemeInUse field of the CYP202CareActivity table.  This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/finding_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D381)","v":0},"CYP202CareActivity","CYP20226","Record rejected - Coded Finding (Coded Clinical Entry) is populated, but no valid Finding Scheme In Use has been provided.","This is the FindSchemeInUse field of the CYP202CareActivity table. If the CodeFind field is populated then the FindSchemeInUse field also needs to be populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D382)","v":0},"CYP202CareActivity","CYP20227","Record rejected - Coded Finding (Coded Clinical Entry) has incorrect data format.","This is the CodedFinding field of the CYP202CareActivity table. The expected format is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D383)","v":0},"CYP202CareActivity","CYP20228","Warning - Finding Scheme In Use is populated, but Coded Finding (Coded Clinical Entry) is blank.","This warning is received because  Finding_Scheme field is populated but the corresponding CodeFind field of the CYP202CareActivity table is blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D384)","v":0},"CYP202CareActivity","CYP20229","Record rejected - Observation Scheme In Use has incorrect data format.","This is the Observation_Scheme field of the CYP202CareActivity table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.  The expected format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D385)","v":0},"CYP202CareActivity","CYP20230","Warning - Observation Scheme In Use contains an invalid national code.","This is the  Observation_Scheme field of the CYP202CareActivity table.  This warning has been received because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/observation_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D386)","v":0},"CYP202CareActivity","CYP20231","Record rejected - Coded Observation (Clinical Terminology) is populated, but no valid Observation Scheme In Use has been provided.","CodedObservation field of CYP202CareActivity table is rejected because no valid corresponding Observation_Scheme field value has been recorded."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D387)","v":0},"CYP202CareActivity","CYP20232","Record rejected - Coded Observation (Clinical Terminology) has incorrect data format.","This is the CodedObservation field of the CYP202CareActivity table. The expected format is min an5 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D388)","v":0},"CYP202CareActivity","CYP20233","Warning - Observation Scheme In Use is populated, but Coded Observation (Clinical Terminology) is blank.","This warning is received because  Observation_Scheme field is populated but the corresponding CodedObservation field of the CYP202CareActivity table is blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D389)","v":0},"CYP202CareActivity","CYP20234","Record rejected - Coded Procedure (Clinical Terminology) format does not match expected format from selected Procedure Scheme In Use.","If the CodedProcedure  field of the CYP202CareActivity table does not match the corresponding Procedure_Scheme, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D390)","v":0},"CYP202CareActivity","CYP20235","Record rejected - Coded Finding (Coded Clinical Entry) format does not match expected format from selected Finding Scheme In Use.","This is the CodeFind field of the CYP202CareActivity table. The value entered in this field does not match to the ICD-10 or SNOMED indicator in the FindSchemeInUse field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D391)","v":0},"CYP202CareActivity","CYP20236","Record rejected - Coded Observation (Clinical Terminology) format does not match expected format from selected Observation Scheme In Use.","This is the CodedObservation field of the CYP202CareActivity table. The  CodedObservation field is not matching the corresponding Observation_Scheme field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D392)","v":0},"CYP202CareActivity","CYP20237","Warning - No valid CYP901 group transmitted for this Care Professional Local Identifier.","Warning generated for CYP202CareActivity record because there is no corresponding record in the CYP901StaffDetails table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP901StaffDetails) has been rejected due to a validation error. Reason 2: There is no record with a corresponding CareProfLocalId in the linked table (CYP901StaffDetails)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D393)","v":0},"CYP202CareActivity","CYP20238","Warning - Observation Value is populated and the UCUM Unit Of Measurement is blank.","The Observation Value has been populated but this warning is received because the corresponding  UC_UnitOfMeasurement field of the CYP202CareActivity table is blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D394)","v":0},"CYP202CareActivity","CYP20239","Record rejected - Procedure Scheme In Use contains the value '06 - SNOMED CT' and Coded Procedure (Clinical Terminology) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If CodedProcedure fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D395)","v":0},"CYP202CareActivity","CYP20240","Record rejected - Finding Scheme In Use contains the value '04 - SNOMED CT' and Coded Finding (Coded Clinical Entry) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If the populated Finding_Scheme field is '04'(SNOMED CT) and the CodedFinding field of CYP202CareActivity fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D396)","v":0},"CYP202CareActivity","CYP20241","Record rejected - Observation Scheme In Use contains the value '03 - SNOMED CT' and Coded Observation (Clinical Terminology) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If CodedObservation fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D397)","v":0},"CYP301GroupSession","CYP30101","Record rejected - Group Session Identifier is blank.","The GroupSessionID field of the CYP301GroupSession table is a mandatory field and cannot be left blank. The GROUP SESSION IDENTIFIER  is used to uniquely identify the GROUP SESSION within the Health Care Provider.  It would normally be automatically generated by the local system upon recording a new Group Session, although could be manually assigned."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D398)","v":0},"CYP301GroupSession","CYP30102","Record rejected - Group Session Identifier has incorrect data format.","This is the GroupSessionID field of CYP301GroupSession table. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D399)","v":0},"CYP301GroupSession","CYP30103","Record rejected - Group Session Date is blank.","This is the  GroupSession_Date field of CYP301GroupSession table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D400)","v":0},"CYP301GroupSession","CYP30104","Record rejected - Group Session Date has incorrect date format.","This is the  GroupSession_Date field of CYP301GroupSession table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D401)","v":0},"CYP301GroupSession","CYP30105","Record rejected - Organisation Identifier (Code of Commissioner) has incorrect data format.","This is the OrgIDComm field of the CYP301GroupSession table. The expected format for this field is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D402)","v":0},"CYP301GroupSession","CYP30106","Warning - Organisation Identifier (Code of Commissioner) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The OrgID_Commissioner field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D403)","v":0},"CYP301GroupSession","CYP30107","Record rejected - Clinical Contact Duration Of Group Session has incorrect format.","This is the GroupSession_Duration field of the CYP301GroupSession table. The expected format for this field is max n4."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D404)","v":0},"CYP301GroupSession","CYP30108","Record rejected - Group Session Type (Community Care) has incorrect data format.","This is the GroupSession_Type field of the CYP301GroupSession table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format for this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D405)","v":0},"CYP301GroupSession","CYP30109","Warning - Group Session Type (Community Care) contains an invalid national code.","This is the GroupSession_Type field of the CYP301GroupSession table.  This warning has been received because an invalid national code has been used. This warning has been received because an invalid national code has been used. It takes only a set selection of codes that mean certain things in the CSDS, which are listed in the Technical Output Specification. When choosing from a list of codes, you must match the options in the Technical Output Specification exactly. When the code starts with a zero, make sure that this is present. Excel can automatically remove leading zeros, so this may require extra attention."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D406)","v":0},"CYP301GroupSession","CYP30110","Record rejected - Number Of Group Session Participants has incorrect data format.","This is the NumberOfParticipants field of the CYP301GroupSession table. The expected format for this field is max n3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D407)","v":0},"CYP301GroupSession","CYP30111","Record rejected - Activity Location Type Code has incorrect data format.","This is the Activity_LocationType field of the CYP301GroupSession table. The Technical Output Specification shows the values that are acceptable for this field. The expected format of this field is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D408)","v":0},"CYP301GroupSession","CYP30112","Warning - Activity Location Type Code contains an invalid national code.","This is the Activity_LocationType field of the CYP301GroupSession table.  This warning has been received because an invalid national code has been used. Valid codes can be found in the Technical Output Specification."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D409)","v":0},"CYP301GroupSession","CYP30113","Record rejected - Organisation Site Identifier (Of Treatment) has incorrect data format.","This is the Treatment_OrgSiteID field of the CYP301GroupSession table.. The expected data format is min an5 max an9."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D410)","v":0},"CYP301GroupSession","CYP30114","Warning - Organisation Site Identifier (Of Treatment) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The Treatment_OrgSiteID field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D411)","v":0},"CYP301GroupSession","CYP30115","Group rejected - More than one CYP301 provided for this Group Session Identifier.","Duplicate records have been submitted using the same CareActivityId. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D412)","v":0},"CYP301GroupSession","CYP30117","Record rejected - NHS Service Agreement Line Number has incorrect data format.","This is the ServiceLineAgreement field of the CYP301GroupSession table. The expected data format for this field is max an10."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D413)","v":0},"CYP301GroupSession","CYP30118","Record rejected - Care Professional Local Identifier has incorrect data format.","This is the CareProfessionalID_Local field of CYP301GroupSession table.  The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D414)","v":0},"CYP301GroupSession","CYP30120","Record rejected - Organisation Identifier (Code of Commissioner) is blank.","This is the OrgIDComm field of the CYP301GroupSession table. The OrgIDComm field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D415)","v":0},"CYP301GroupSession","CYP30121","Warning - No valid CYP901 group transmitted for this Care Professional Local Identifier.","Warning generated for CYP301GroupSession record because there is no corresponding record in the CYP901StaffDetails table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP901StaffDetails) has been rejected due to a validation error. Reason 2: There is no record with a corresponding CareProfLocalId in the linked table (CYP901StaffDetails)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D416)","v":0},"CYP301GroupSession","CYP30122","Record rejected - Group Session Date is after the Reporting Period End Date.","This is the GroupSession_Date field of the CYP301GroupSession table. If Group Session Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D417)","v":0},"CYP301GroupSession","CYP30123","Record rejected - Group Session Date is before the Reporting Period Start Date.","This is the GroupSession_Date field of the CYP301GroupSession table. This is a Mandatory field and the date should not be before the Reporting Period .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D418)","v":0},"CYP401SpEdNeedId","CYP40101","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP401SpEdNeedId table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D419)","v":0},"CYP401SpEdNeedId","CYP40102","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP401SpEdNeedId table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D420)","v":0},"CYP401SpEdNeedId","CYP40103","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP401SpEdNeedId table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D421)","v":0},"CYP401SpEdNeedId","CYP40104","Record rejected - Special Educational Need Type is blank.","The EducationNeed_Type field of the CYP401SpEdNeedId table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D422)","v":0},"CYP401SpEdNeedId","CYP40105","Record rejected - Special Educational Need Type has incorrect data format.","The EducationNeed_Type field of the CYP401SpEdNeedId table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D423)","v":0},"CYP401SpEdNeedId","CYP40106","Warning - Special Educational Need Type contains an invalid national code.","The EducationNeed_Type field of the CYP401SpEdNeedId table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/special_educational_need_type.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D424)","v":0},"CYP401SpEdNeedId","CYP40108","Group rejected - More than one CYP401 provided for this Local Patient Identifier (Extended) + Special Educational Need Type combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId and EducationNeed_Type. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D425)","v":0},"CYP401SpEdNeedId","CYP40109","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 19 years or older at the Reporting Period Start Date.","This is Used to compare outcomes and provision for children/young people with disabilities or condition. The age of the patient should be less than 19 years at the Reporting Period Start Date. Check if the Date of Birth is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D426)","v":0},"CYP401SpEdNeedId","CYP40110","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP401SpEdNeedId table is rejected because the  DateOfBirth field of CYP001MPI table for the corresponding record is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D427)","v":0},"CYP402SVF","CYP40201","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP402SVF table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D428)","v":0},"CYP402SVF","CYP40202","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP402SVF table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D429)","v":0},"CYP402SVF","CYP40203","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP402SVF table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D430)","v":0},"CYP402SVF","CYP40204","Record rejected - Safeguarding Vulnerability Factors Type is blank.","The SafeguardingFactors_Type field of the CYP402SVF table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D431)","v":0},"CYP402SVF","CYP40205","Record rejected - Safeguarding Vulnerability Factors Type has incorrect data format.","The SafeguardingFactors_Type field of the CYP402SVF table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D432)","v":0},"CYP402SVF","CYP40206","Warning - Safeguarding Vulnerability Factors Type contains an invalid national code.","The SafeguardingFactors_Type field of the CYP402SVF table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/safeguarding_vulnerability_factors_type.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D433)","v":0},"CYP402SVF","CYP40208","Group rejected - More than one CYP402 provided for this Local Patient Identifier (Extended) + Safeguarding Vulnerability Factors Type combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId and SafeguardingFactors_Type. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D434)","v":0},"CYP402SVF","CYP40209","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 19 years or older at the Reporting Period Start Date.","This is To monitor details of children with safeguarding concerns. The age of the patient should be less than 19 years at the Reporting Period Date. Check patient DateOfBirth is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D435)","v":0},"CYP402SVF","CYP40210","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP402SVF table is rejected because the  DateOfBirth field of CYP001MPI table for the corresponding record is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D436)","v":0},"CYP403CPP","CYP40301","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP403CPP table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D437)","v":0},"CYP403CPP","CYP40302","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP403CPP table. This is a mandatory field and should  not be left blank. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D438)","v":0},"CYP403CPP","CYP40303","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP403CPP table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D439)","v":0},"CYP403CPP","CYP40304","Record rejected - Child Protection Plan Reason Code is blank.","This is the CPP_Reason field of the CYP403CPP table is mandatory and so cannot be left blank. The expected data format is  an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D440)","v":0},"CYP403CPP","CYP40305","Record rejected - Child Protection Plan Reason Code has incorrect data format.","This is the CPP_Reason field of the CYP403CPP table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is  an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D441)","v":0},"CYP403CPP","CYP40306","Warning - Child Protection Plan Reason Code contains an invalid national code.","This is the CPP_Reason field of the CYP403CPP table. This warning has been received because an invalid national code has been used. Example of valid codes are \"01\"(Neglect), \"02\"(Physical Abuse),  \"03\"(Emotional Abuse)  and  \"04\"(Sexual Abuse)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D442)","v":0},"CYP403CPP","CYP40307","Group rejected - More than one CYP403 provided for this Local Patient Identifier (Extended) + Child Protection Plan Reason Code + Child Protection Plan Start Date + Child Protection Plan End Date combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, CPP_Reason, CPP_StartDate and CPP_EndDate. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D443)","v":0},"CYP403CPP","CYP40308","Record rejected - Child Protection Plan Start Date has incorrect date format.","The CPP_StartDate field of the CYP403CPP table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D444)","v":0},"CYP403CPP","CYP40309","Record rejected - Child Protection Plan End Date has incorrect date format.","This is the CPP_EndDate field of the CYP403CPP table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D445)","v":0},"CYP403CPP","CYP40310","Record rejected - Child Protection Plan Start Date is blank.","The CPP_StartDate field of the CYP403CPP table is mandatory and so cannot be left blank. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D446)","v":0},"CYP403CPP","CYP40311","Record rejected - Child Protection Plan Start Date is more than 9 months before the Person Birth Date.","This is the CPP_StartDate field of the CYP403CPP table. This is a required field and the date should not be greater than 9 months before DateOfBirth Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D447)","v":0},"CYP403CPP","CYP40312","Record rejected - Child Protection Plan Start Date is after the Reporting Period End Date.","This is the CPP_StartDate field of the CYP403CPP table. If Child Protection Plan Start Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D448)","v":0},"CYP403CPP","CYP40313","Record rejected - Child Protection Plan End Date is before the Child Protection Plan Start Date.","This is the CPP_EndDate field of the CYP403CPP table. If Child Protection Plan End Date is populated and is before  CPP_StartDate , the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D449)","v":0},"CYP403CPP","CYP40315","Record rejected - Child Protection Plan End Date is before the Reporting Period Start Date.","This is the CPP_EndDate field of the CYP403CPP table. If Child Protection Plan End Date is populated and is before the start of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D450)","v":0},"CYP403CPP","CYP40316","Record rejected - Child Protection Plan End Date is after the Reporting Period End Date.","This is the CPP_EndDate field of the CYP403CPP table. If Child Protection Plan End Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D451)","v":0},"CYP403CPP","CYP40317","Record rejected - Person Birth Date is blank AND Child Protection Plan Start Date is before 1 January 1890.","The  CPP_StartDate field of the CYP403CPP table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D452)","v":0},"CYP403CPP","CYP40318","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 19 years or older at the Reporting Period Start Date.","This is Used to compare outcomes and provision for children/young people with disabilities or condition. The age of the patient should be less than 19 years at the Reporting Period Date. Check patient DateOfBirth is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D453)","v":0},"CYP403CPP","CYP40319","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP403CPP table is rejected because the  DateOfBirth field of CYP001MPI table for the corresponding record is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D454)","v":0},"CYP404AssTechToSupportDisTyp","CYP40401","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP404AssTechToSupportDisTyp table rejected because there is no corresponding record in the CYP001 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D455)","v":0},"CYP404AssTechToSupportDisTyp","CYP40402","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP404AssTechToSupportDisTyp table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D456)","v":0},"CYP404AssTechToSupportDisTyp","CYP40403","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP404AssTechToSupportDisTyp table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D457)","v":0},"CYP404AssTechToSupportDisTyp","CYP40404","Record rejected - Assistive Technology Finding (SNOMED CT) is blank.","The Assistive Technology Finding (SNOMED CT) is a mandatory field and cannot be left blank. Also, If Assistive Technology Finding (SNOMED CT) fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D458)","v":0},"CYP404AssTechToSupportDisTyp","CYP40405","Record rejected - Assistive Technology Finding (SNOMED CT) has incorrect data format.","This is the SNOMED_ID field of the CYP404AssTechToSupportDisTyp table. The expected data format for this field is min n6 max n18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D459)","v":0},"CYP404AssTechToSupportDisTyp","CYP40408","Record rejected - Prescription Date (Assistive Technology) has incorrect data format.","This is the SNOMED_Date field of the CYP404AssTechToSupportDisTyp table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D460)","v":0},"CYP404AssTechToSupportDisTyp","CYP40409","Group rejected - More than one CYP404 provided for this Local Patient Identifier (Extended) + Assistive Technology Finding (SNOMED CT) + Prescription Date (Assistive Technology) combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, SNOMED_ID and SNOMED_Date. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D461)","v":0},"CYP404AssTechToSupportDisTyp","CYP40410","Record rejected - Assistive Technology Finding (SNOMED CT) has failed SNOMED CT checks.","If the populated SNOMED_ID field of the CYP404AssTechToSupportDisTyp table fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D462)","v":0},"CYP404AssTechToSupportDisTyp","CYP40411","Record rejected - Prescription Date (Assistive Technology) is before the Person Birth Date.","This is the SNOMED_Date field of the CYP404AssTechToSupportDisTyp table. This is a required field and the date should not be before  DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D463)","v":0},"CYP404AssTechToSupportDisTyp","CYP40412","Record rejected - Person Birth Date is blank AND Prescription Date (Assistive Technology) is before 1 January 1890.","The  SNOMED_Date field of the CYP404AssTechToSupportDisTyp table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D464)","v":0},"CYP404AssTechToSupportDisTyp","CYP40413","Record rejected - Prescription Date (Assistive Technology) is after the Date and Time Data Set Created.","This is the SNOMED_Date field of the CYP404AssTechToSupportDisTyp table. This is a required field and the date should not be  after  the FileCreation_DateTime field of CYP000Header Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D465)","v":0},"CYP404AssTechToSupportDisTyp","CYP40414","Warning - Prescription Date (Assistive Technology) is after the Reporting Period End Date.","This is the SNOMED_Date field of the CYP404AssTechToSupportDisTyp table.This warning is received If Prescription Date (Assistive Technology) is populated and is after the end of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D466)","v":0},"CYP501CodedImm","CYP50101","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP501CodedImm table rejected because there is no corresponding record in the CYP001. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D467)","v":0},"CYP501CodedImm","CYP50102","Group rejected - More than one CYP501 provided for this Local Patient Identifier (Extended) + Immunisation Procedure (Clinical Terminology) + Immunisation Date combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, ImmunisationProcedure and Immunisation_Date. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D468)","v":0},"CYP501CodedImm","CYP50103","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of theCYP501CodedImm table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D469)","v":0},"CYP501CodedImm","CYP50104","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP501CodedImm table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D470)","v":0},"CYP501CodedImm","CYP50105","Record rejected - Immunisation Date is blank.","This is the Immunisation_Date field of the CYP501CodedImm table. This is a mandatory field and should  not be left blank. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D471)","v":0},"CYP501CodedImm","CYP50106","Record rejected - Immunisation Date has incorrect date format.","This is the Immunisation_Date field of the CYP501CodedImm table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D472)","v":0},"CYP501CodedImm","CYP50107","Record rejected - Immunisation Date is before the Person Birth Date.","This is the Immunisation_Date field of the CYP501CodedImm table. This is a required field and the date should  NOT be before  DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D473)","v":0},"CYP501CodedImm","CYP50108","Record rejected - Immunisation Date is after the Reporting Period End Date.","This is the Immunisation_Date field of the CYP501CodedImm table. If  Immunisation Date  is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D474)","v":0},"CYP501CodedImm","CYP50109","Record rejected - Procedure Scheme In Use has incorrect data format.","The Procedure_Scheme field of the CYP501CodedImm table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D475)","v":0},"CYP501CodedImm","CYP50110","Record rejected - Organisation Identifier (Immunisation Responsible Organisation) has incorrect data format.","The OrgID_ImmunisationResponsible field of the CYP501CodedImm table. The expected data format is min an5 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D476)","v":0},"CYP501CodedImm","CYP50111","Warning - Organisation Identifier (Immunisation Responsible Organisation) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The OrgID_ImmunisationResponsible field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D477)","v":0},"CYP501CodedImm","CYP50112","Record rejected - Procedure Scheme In Use contains an invalid national code.","This is the Procedure_Scheme field of the CYP501CodedImm table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/procedure_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D478)","v":0},"CYP501CodedImm","CYP50113","Record rejected - Immunisation Procedure (Clinical Terminology) is blank.","The ImmunisationProcedure field of the CYP501CodedImm table. This is a mandatory field and should  not be left blank. The expected data format is min an5 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D479)","v":0},"CYP501CodedImm","CYP50114","Record rejected - Immunisation Procedure (Clinical Terminology) has incorrect data format.","The ImmunisationProcedure field of the CYP501CodedImm table. The expected data format is min an5 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D480)","v":0},"CYP501CodedImm","CYP50116","Record rejected - Procedure Scheme in use is blank.","The Procedure_Scheme field of the CYP501CodedImm table. This is a mandatory field and should  not be left blank. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D481)","v":0},"CYP501CodedImm","CYP50117","Record rejected - Person Birth Date is blank AND Immunisation Date is before 1 January 1890.","The  Immunisation_Date field of the CYP501CodedImm table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D482)","v":0},"CYP501CodedImm","CYP50118","Record rejected - Procedure Scheme In Use contains the value '06 - SNOMED CT' and Immunisation Procedure (Clinical Terminology) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If ImmunisationProcedure fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D483)","v":0},"CYP501CodedImm","CYP50119","Record rejected - Immunisation Procedure (Clinical Terminology) format does not match expected format from selected Procedure Scheme In Use.","The ImmunisationProcedure field of the CYP501CodedImm table. Record is rejected because the ImmunisationProcedure is a mandatory field but the populated value does not match the corresponding  Procedure_Scheme field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D484)","v":0},"CYP502Imm","CYP50201","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP502Imm table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D485)","v":0},"CYP502Imm","CYP50202","Group rejected - More than one CYP502 provided for this Local Patient Identifier (Extended) + Childhood Immunisation Type (Children and Young People's Health Services) + Immunisation Date combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, ChildhoodImmunisation_Type and Immunisation_Date. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D486)","v":0},"CYP502Imm","CYP50203","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the CYP502Imm table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D487)","v":0},"CYP502Imm","CYP50204","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP502Imm table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D488)","v":0},"CYP502Imm","CYP50205","Record rejected - Childhood Immunisation Type (Children and Young People's Health Services) is blank.","The  ChildhoodImmunisation_Type field of the  CYP502Imm table. This is a mandatory field and should  not be left blank. The expected data format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D489)","v":0},"CYP502Imm","CYP50206","Record rejected - Childhood Immunisation Type (Children and Young People's Health Services) has incorrect data format.","The ChildhoodImmunisation_Type field of the CYP502Imm table. The expected data format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D490)","v":0},"CYP502Imm","CYP50207","Warning - Childhood Immunisation Type (Children and Young People's Health Services) contains an invalid national code.","This is the ChildhoodImmunisation_Type field of the CYP502Imm table. This warning has been received because an invalid national code has been used. For a list of valid codes visit https://www.datadictionary.nhs.uk/data_elements/childhood_immunisation_type__children_and_young_people_s_health_services_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D491)","v":0},"CYP502Imm","CYP50208","Record rejected - Immunisation Date is blank.","The Immunisation_Date field of the CYP502Imm table. This is a mandatory field and should  not be left blank. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D492)","v":0},"CYP502Imm","CYP50209","Record rejected - Immunisation Date has incorrect data format.","The Immunisation_Date field  of the CYP502Imm table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D493)","v":0},"CYP502Imm","CYP50210","Record rejected - Organisation Identifier (Immunisation Responsible Organisation) has incorrect data format.","The OrgID_ImmunisationResponsible field of the CYP502Imm table. The expected data format is max an3 max an6."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D494)","v":0},"CYP502Imm","CYP50211","Warning - Organisation Identifier (Immunisation Responsible Organisation) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","The OrgID_ImmunisationResponsible field is expecting to be populated with your ODS code. The ODS code provided is not recognised as being live. You can search for your Organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D495)","v":0},"CYP502Imm","CYP50212","Record rejected - Immunisation Date is after the Reporting Period End Date.","This is the Immunisation_Date field of the CYP502Imm table. If  Immunisation Date  is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D496)","v":0},"CYP502Imm","CYP50213","Record rejected - Immunisation Date is before Person Birth Date.","This is the Immunisation_Date field of the CYP502Imm table. This is a required field and the date should not be before  DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D497)","v":0},"CYP502Imm","CYP50214","Record rejected - Person Birth Date is blank AND Immunisation Date is before 1 January 1890.","This is the Immunisation_Date field of the CYP502Imm table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D498)","v":0},"CYP502Imm","CYP50215","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 19 years or older at the Reporting Period Start Date.","The age of the patient should be less than 19 years at the Reporting Period Start Date. Check if the corresponding DateOfBirth field of CYP001MPI table is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D499)","v":0},"CYP502Imm","CYP50216","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP502Imm table is rejected because the corresponding DateOfBirth field of CYP001MPI table is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D500)","v":0},"CYP601MedicalHistory","CYP60101","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP601MedicalHistory table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D501)","v":0},"CYP601MedicalHistory","CYP60102","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of theCYP601MedicalHistory table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in CYP001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D502)","v":0},"CYP601MedicalHistory","CYP60103","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP601MedicalHistory table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D503)","v":0},"CYP601MedicalHistory","CYP60104","Record rejected - Diagnosis Scheme In Use has incorrect data format.","The Diagnosis_Scheme field of the CYP601MedicalHistory table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D504)","v":0},"CYP601MedicalHistory","CYP60106","Record rejected - Previous Diagnosis (Coded Clinical Entry) is blank.","This is the PrevDiag field of the CYP601MedicalHistory table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D505)","v":0},"CYP601MedicalHistory","CYP60107","Record rejected - Previous Diagnosis (Coded Clinical Entry) has incorrect data format.","This is the PrevDiag field of the CYP601MedicalHistory table. The expected format for this field is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D506)","v":0},"CYP601MedicalHistory","CYP60108","Record rejected - Diagnosis Date has incorrect data format.","This is the Diagnosis_Date field of the CYP601MedicalHistory table. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D507)","v":0},"CYP601MedicalHistory","CYP60109","Record rejected - Diagnosis Date is after the Reporting Period End Date.","This is the Diagnosis_Date field of the CYP601MedicalHistory table. If  Diagnosis Date  is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D508)","v":0},"CYP601MedicalHistory","CYP60110","Group rejected - More than one CYP601 provided for this Local Patient Identifier (Extended) + Previous Diagnosis (Coded Clinical Entry) + Diagnosis Date combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, PreviousDiagnosis and Diagnosis_Date. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D509)","v":0},"CYP601MedicalHistory","CYP60111","Record rejected - Diagnosis Scheme In Use is blank.","The Diagnosis_Scheme field of the CYP601MedicalHistory table. This a mandatory field and should not be blank. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D510)","v":0},"CYP601MedicalHistory","CYP60112","Record rejected - Previous Diagnosis (Coded Clinical Entry) format does not match expected format from selected Diagnosis Scheme In Use.","This is the PrevDiag field of the CYP601MedicalHistory table. The value entered in this field does not match to the ICD-10 or SNOMED entry as indicated in the DiagSchemeInUse field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D511)","v":0},"CYP601MedicalHistory","CYP60113","Record rejected - Diagnosis Date is before the Person Birth Date.","This is the Diagnosis_Date field of the CYP601MedicalHistory table. This is a required field and the date should  NOT be before  DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D512)","v":0},"CYP601MedicalHistory","CYP60114","Record rejected - Person Birth Date is blank AND Diagnosis Date is before 1 January 1890.","This is the Diagnosis_Date field of the CYP601MedicalHistory table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D513)","v":0},"CYP601MedicalHistory","CYP60115","Record rejected - Diagnosis Scheme In Use contains an invalid national code.","This is the Diagnosis_Scheme field of the CYP601MedicalHistory table. The record is rejected because an invalid national code has been used. For a list of valid codes visit https://www.datadictionary.nhs.uk/data_elements/diagnosis_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D514)","v":0},"CYP601MedicalHistory","CYP60116","Record rejected - Diagnosis Scheme In Use contains the value '06 - SNOMED CT' and Previous Diagnosis (Coded Clinical Entry) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If PreviousDiagnosis fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D515)","v":0},"CYP602DisabilityType","CYP60201","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP602DisabilityType table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D516)","v":0},"CYP602DisabilityType","CYP60202","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field is a mandatory field and must be populated. It must match a LocalPatientId given in CYP001MPI."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D517)","v":0},"CYP602DisabilityType","CYP60203","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field of the CYP602DisabilityType table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D518)","v":0},"CYP602DisabilityType","CYP60204","Record rejected - Disability Code has incorrect data format.","This is the DisabCode field of theCYP602DisabilityType table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D519)","v":0},"CYP602DisabilityType","CYP60205","Warning - Disability Code contains an invalid national code.","This is the DisabCode field of the CYP602DisabilityType table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/disability_code.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D520)","v":0},"CYP602DisabilityType","CYP60206","Record rejected - Disability Code is blank.","This is the DisabCode field of the CYP602DisabilityType table. This is a mandatory field and cannot be left blank. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D521)","v":0},"CYP602DisabilityType","CYP60207","Record rejected - Disability Impact Perception has incorrect data format.","The DisabilityImpactPerception field of the CYP602DisabilityType table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D522)","v":0},"CYP602DisabilityType","CYP60208","Warning - Disability Impact Perception contains an invalid national code.","This is the DisabilityImpactPerception field of the CYP602DisabilityType table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/disability_impact_perception.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D523)","v":0},"CYP602DisabilityType","CYP60209","Group rejected - More than one CYP602 provided for this Local Patient Identifier (Extended) + Disability Code + Disability Impact Perception combination.","Duplicate records have been submitted with the same values in the following fields: LocalPatientId, Disability and DisabilityImpactPerception. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D524)","v":0},"CYP603NewbornHearingScreening","CYP60301","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP603NewbornHearingScreeningType table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D525)","v":0},"CYP603NewbornHearingScreening","CYP60303","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field is a mandatory field and cannot be blank. It must match a LocalPatientId given in CYP001MPI."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D526)","v":0},"CYP603NewbornHearingScreening","CYP60304","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","The LocalPatientId field is a mandatory field and must be populated. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D527)","v":0},"CYP603NewbornHearingScreening","CYP60305","Record rejected - Service Request Date (Newborn Hearing Audiology) has incorrect date format.","This is the ServiceRequest_Date field of the CYP603NewbornHearingScreening table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D528)","v":0},"CYP603NewbornHearingScreening","CYP60306","Record rejected - Procedure Date (Newborn Hearing Audiology) has incorrect date format.","This is the Procedure_Date field of the CYP603NewbornHearingScreening table .The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D529)","v":0},"CYP603NewbornHearingScreening","CYP60307","Record rejected - Newborn Hearing Screening Outcome has incorrect data format.","The Result_HearingScreening field is a mandatory field and must be populated. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D530)","v":0},"CYP603NewbornHearingScreening","CYP60308","Warning - Newborn Hearing Screening Outcome contains an invalid national code.","This is the  Result_HearingScreening field of the CYP603NewbornHearingScreening table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/newborn_hearing_screening_outcome.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D531)","v":0},"CYP603NewbornHearingScreening","CYP60309","Record rejected - Newborn Hearing Audiology Outcome has incorrect data format.","This is the Result_HearingAudiology field of the CYP603NewbornHearingScreening table . The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D532)","v":0},"CYP603NewbornHearingScreening","CYP60310","Warning - Newborn Hearing Audiology Outcome contains an invalid national code.","This is the  Result_HearingAudiology field of the CYP603NewbornHearingScreening table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/newborn_hearing_audiology_outcome.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D533)","v":0},"CYP603NewbornHearingScreening","CYP60311","Record rejected - Service Request Date (Newborn Hearing Audiology) is after the Reporting Period End Date.","This is the ServiceRequest_Date field of the CYP603NewbornHearingScreening table. If  Service Request Date  is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D534)","v":0},"CYP603NewbornHearingScreening","CYP60312","Record rejected - Service Request Date (Newborn Hearing Audiology) is before the Person Birth Date.","This is the ServiceRequest_Date field of the  CYP603NewbornHearingScreening table. This is a required field and the date should NOT be before  DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D535)","v":0},"CYP603NewbornHearingScreening","CYP60315","Record rejected - Newborn Hearing Screening Outcome was recorded as \"Clear response, no follow up required\", but Service Request Date (Newborn Hearing Audiology) is populated.","The  Result_HearingScreening field of the CYP603NewbornHearingScreening table. The ServiceRequest_Date field should not be populated if  \"Clear response, no follow up required\" value is selected for the Result_HearingScreening field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D536)","v":0},"CYP603NewbornHearingScreening","CYP60316","Record rejected - Newborn Hearing Screening Outcome was recorded as \"Clear response, no follow up required\", but Procedure Date (Newborn Hearing Audiology) is populated.","The  Result_HearingScreening field of the CYP603NewbornHearingScreening table. The Procedure_Date field should not be populated if  \"Clear response, no follow up required\" value is selected for the Result_HearingScreening field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D537)","v":0},"CYP603NewbornHearingScreening","CYP60317","Record rejected - Newborn Hearing Screening Outcome was recorded as \"Clear response, no follow up required\", but Newborn Hearing Audiology Outcome is populated.","The  Result_HearingScreening field of the CYP603NewbornHearingScreening table. The Result_HearingAudiology field should not be populated if  \"Clear response, no follow up required\" value is selected for the Result_HearingScreening field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D538)","v":0},"CYP603NewbornHearingScreening","CYP60318","Record rejected - Person Birth Date is blank AND Service Request Date (Newborn Hearing Audiology) is before 1 January 1890.","This is the ServiceRequest_Date field of the  CYP603NewbornHearingScreening table. This is a required field and the date should NOT be before 1 January 1980.The DateOfBirth field should not be blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D539)","v":0},"CYP603NewbornHearingScreening","CYP60319","Record rejected - Procedure Date (Newborn Hearing Audiology) is before the Person Birth Date.","This is the Procedure_Date field of the CYP603NewbornHearingScreening table. This is a required field and the date should NOT be before  DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D540)","v":0},"CYP603NewbornHearingScreening","CYP60321","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 1 year or older at the Reporting Period Start Date.","The age of the patient should be less than 1 year at the Reporting Period Date. Check if the corresponding DateOfBirth field of CYP001MPI table is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D541)","v":0},"CYP603NewbornHearingScreening","CYP60322","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP603NewbornHearingScreening table is rejected because the corresponding DateOfBirth field of CYP001MPI table is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D542)","v":0},"CYP603NewbornHearingScreening","CYP60323","Record rejected - Procedure Date (Newborn Hearing Audiology) is before the Reporting Period Start Date.","This is the Procedure_Date field of the CYP603NewbornHearingScreening table. This is a required field and the date should NOT be before the reporting period start date .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D543)","v":0},"CYP603NewbornHearingScreening","CYP60324","Record rejected - Procedure Date (Newborn Hearing Audiology) is after the Reporting Period End Date.","This is the Procedure_Date field of the CYP603NewbornHearingScreening table. If  Procedure Date (Newborn Hearing Audiology) is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D544)","v":0},"CYP604BloodSpotResult","CYP60401","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP604BloodSpotResult table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D545)","v":0},"CYP604BloodSpotResult","CYP60403","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field is a mandatory field and must be populated. It must match a LocalPatientId given in CYP001MPI."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D546)","v":0},"CYP604BloodSpotResult","CYP60404","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is the LocalPatientId field of the CYP604BloodSpotResult table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D547)","v":0},"CYP604BloodSpotResult","CYP60406","Record rejected - Blood Spot Card Completion Date has incorrect data format.","This is the CardCompletion_Date field of the CYP604BloodSpotResult table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D548)","v":0},"CYP604BloodSpotResult","CYP60407","Record rejected - Newborn Blood Spot Test Outcome Status Code (Phenylketonuria) has incorrect data format.","This is the Result_Phenylketonuria field of the CYP604BloodSpotResult table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D549)","v":0},"CYP604BloodSpotResult","CYP60408","Warning - Newborn Blood Spot Test Outcome Status Code (Phenylketonuria) contains an invalid national code.","This is the Result_Phenylketonuria field of the CYP604BloodSpotResult table .This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__phenylketonuria_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D550)","v":0},"CYP604BloodSpotResult","CYP60409","Record rejected - Newborn Blood Spot Test Outcome Status Code (Sickle Cell Disease) has incorrect data format.","This is the Result_SickleCellDisease field of the CYP604BloodSpotResult table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D551)","v":0},"CYP604BloodSpotResult","CYP60410","Warning - Newborn Blood Spot Test Outcome Status Code (Sickle Cell Disease) contains an invalid national code.","This is the Result_SickleCellDisease field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__sickle_cell_disease_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D552)","v":0},"CYP604BloodSpotResult","CYP60411","Record rejected - Newborn Blood Spot Test Outcome Status Code (Cystic Fibrosis) has incorrect data format.","This is the Result_CysticFibrosis field of the CYP604BloodSpotResult table . The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D553)","v":0},"CYP604BloodSpotResult","CYP60412","Warning - Newborn Blood Spot Test Outcome Status Code (Cystic Fibrosis) contains an invalid national code.","This is the Result_CysticFibrosis field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D554)","v":0},"CYP604BloodSpotResult","CYP60413","Record rejected - Newborn Blood Spot Test Outcome Status Code (Congenital Hypothyroidism) has incorrect data format.","This is the Result_CongenitalHypothyroidism field of the CYP604BloodSpotResult table . The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D555)","v":0},"CYP604BloodSpotResult","CYP60414","Warning - Newborn Blood Spot Test Outcome Status Code (Congenital Hypothyroidism) contains an invalid national code.","This is the Result_CongenitalHypothyroidism field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__congenital_hypothyroidism_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D556)","v":0},"CYP604BloodSpotResult","CYP60415","Record rejected - Newborn Blood Spot Test Outcome Status Code (Medium Chain ACYL-COA Dehydrogenase Deficiency) has incorrect data format.","This is the Result_MCADD field of the CYP604BloodSpotResult table . The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D557)","v":0},"CYP604BloodSpotResult","CYP60416","Warning - Newborn Blood Spot Test Outcome Status Code (Medium Chain ACYL-COA Dehydrogenase Deficiency) contains an invalid national code.","This is the Result_MCADD field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D558)","v":0},"CYP604BloodSpotResult","CYP60418","Record rejected - Newborn Blood Spot Test Result Received Date has incorrect data format.","This is the TestResult_ReceivedDate field of the CYP604BloodSpotResult table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D559)","v":0},"CYP604BloodSpotResult","CYP60419","Record rejected - Newborn Blood Spot Test Outcome Status Code (Homocystinuria) has incorrect data format.","This is the Result_Homocystinuria field of the CYP604BloodSpotResult table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D560)","v":0},"CYP604BloodSpotResult","CYP60420","Warning - Newborn Blood Spot Test Outcome Status Code (Homocystinuria) contains an invalid national code.","This is the Result_Homocystinuria field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__homocystinuria_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D561)","v":0},"CYP604BloodSpotResult","CYP60421","Record rejected - Newborn Blood Spot Test Outcome Status Code (Maple Syrup Urine Disease) has incorrect data format.","This is the Result_MapleSyrupUrineDisease field of the CYP604BloodSpotResult table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D562)","v":0},"CYP604BloodSpotResult","CYP60422","Warning - Newborn Blood Spot Test Outcome Status Code (Maple Syrup Urine Disease) contains an invalid national code.","This is the Result_MapleSyrupUrineDisease field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__maple_syrup_urine_disease_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D563)","v":0},"CYP604BloodSpotResult","CYP60423","Record rejected - Newborn Blood Spot Test Outcome Status Code (Glutaric Aciduria Type 1) has incorrect data format.","This is the Result_GlutaricAciduriaTypeOne field of the CYP604BloodSpotResult table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D564)","v":0},"CYP604BloodSpotResult","CYP60424","Warning - Newborn Blood Spot Test Outcome Status Code (Glutaric Aciduria Type 1) contains an invalid national code.","This is the Result_GlutaricAciduriaTypeOne field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__glutaric_aciduria_type_1_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D565)","v":0},"CYP604BloodSpotResult","CYP60425","Record rejected - Newborn Blood Spot Test Outcome Status Code (Isovaleric Aciduria) has incorrect data format.","This is the Result_IsovalericAciduria field of the CYP604BloodSpotResult table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D566)","v":0},"CYP604BloodSpotResult","CYP60426","Warning - Newborn Blood Spot Test Outcome Status Code (Isovaleric Aciduria) contains an invalid national code.","This is the Result_IsovalericAciduria field of the CYP604BloodSpotResult table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__isovaleric_aciduria_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D567)","v":0},"CYP604BloodSpotResult","CYP60427","Record rejected - Blood Spot Card Completion Date is after the Reporting Period End Date.","This is the CardCompletion_Date field of the CYP604BloodSpotResult table .  If  CardCompletion_Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D568)","v":0},"CYP604BloodSpotResult","CYP60428","Record rejected - Blood Spot Card Completion Date is before the Person Birth date.","This is the CardCompletion_Date field of the CYP604BloodSpotResult table . This is a required field and the date should NOT be before  DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D569)","v":0},"CYP604BloodSpotResult","CYP60430","Record rejected - Newborn Blood Spot Test Result Received Date is before Blood Spot Card Completion Date.","This is the TestResult_ReceivedDate field of the CYP604BloodSpotResult table .The TestResult_ReceivedDate field should not be before the CardCompletion_Date field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D570)","v":0},"CYP604BloodSpotResult","CYP60431","Warning - Newborn Blood Spot Test Outcome Status Code (Phenylketonuria) is populated but Newborn Blood Spot Test Result Received Date is blank.","This is the Result_Phenylketonuria field of the CYP604BloodSpotResult table .The corresponding TestResult_ReceivedDate field should not be blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D571)","v":0},"CYP604BloodSpotResult","CYP60432","Warning - Newborn Blood Spot Test Outcome Status Code (Sickle Cell Disease) is populated but Newborn Blood Spot Test Result Received Date is blank.","This is the Result_SickleCellDisease field of the CYP604BloodSpotResult table .The corresponding TestResult_ReceivedDate field should not be blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D572)","v":0},"CYP604BloodSpotResult","CYP60433","Warning - Newborn Blood Spot Test Outcome Status Code (Cystic Fibrosis) is populated but Newborn Blood Spot Test Result Received Date is blank.","This is the Result_CysticFibrosis field of the CYP604BloodSpotResult table .The corresponding TestResult_ReceivedDate field should not be blank. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/newborn_blood_spot_test_outcome_status_code__cystic_fibrosis_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D573)","v":0},"CYP604BloodSpotResult","CYP60434","Warning - Newborn Blood Spot Test Outcome Status Code (Congenital Hypothyroidism) is populated but Newborn Blood Spot Test Result Received Date is blank.","This is the Result_CongenitalHypothyroidism field of the CYP604BloodSpotResult table .The corresponding TestResult_ReceivedDate field should not be blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D574)","v":0},"CYP604BloodSpotResult","CYP60435","Warning - Newborn Blood Spot Test Outcome Status Code (Medium Chain ACYL-COA Dehydrogenase Deficiency) is populated but Newborn Blood Spot Test Result Received Date is blank.","This warning is received because  the Result_MCADD field of the CYP604BloodSpotResult table is populated but the  corresponding TestResult_ReceivedDate field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D575)","v":0},"CYP604BloodSpotResult","CYP60436","Warning - Newborn Blood Spot Test Outcome Status Code (Homocystinuria) is populated but Newborn Blood Spot Test Result Received Date is blank.","This warning is received because  the Result_Homocystinuria field of the CYP604BloodSpotResult table is populated but the  corresponding TestResult_ReceivedDate field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D576)","v":0},"CYP604BloodSpotResult","CYP60437","Warning - Newborn Blood Spot Test Outcome Status Code (Maple Syrup Urine Disease) is populated but Newborn Blood Spot Test Result Received Date is blank.","This warning is received because  the Result_MapleSyrupUrineDisease field of the CYP604BloodSpotResult table is populated but the  corresponding TestResult_ReceivedDate field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D577)","v":0},"CYP604BloodSpotResult","CYP60438","Warning - Newborn Blood Spot Test Outcome Status Code (Glutaric Aciduria Type 1) is populated but Newborn Blood Spot Test Result Received Date is blank.","This is the Result_GlutaricAciduriaTypeOne field of the CYP604BloodSpotResult table .The corresponding TestResult_ReceivedDate field should not be blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D578)","v":0},"CYP604BloodSpotResult","CYP60439","Warning - Newborn Blood Spot Test Outcome Status Code (Isovaleric Aciduria) is populated but Newborn Blood Spot Test Result Received Date is blank.","This is the Result_IsovalericAciduria field of the CYP604BloodSpotResult table .The corresponding TestResult_ReceivedDate field should not be blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D579)","v":0},"CYP604BloodSpotResult","CYP60441","Record rejected - Person Birth Date is blank AND Blood Spot Card Completion Date is before 1 January 1890.","This is the CardCompletion_Date field of the CYP604BloodSpotResult table, it should not be before 1 January 1890 and the DateOfBirth field  should not be blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D580)","v":0},"CYP604BloodSpotResult","CYP60442","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 1 year or older at the Reporting Period Start Date.","The age of the patient should be less than 1 year at the Reporting Period Date. Check if the corresponding DateOfBirth field of CYP001MPI table is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D581)","v":0},"CYP604BloodSpotResult","CYP60443","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP604BloodSpotResult table is rejected because the corresponding  DateOfBirth field of CYP001MPI table is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D582)","v":0},"CYP604BloodSpotResult","CYP60444","Record rejected - Newborn Blood Spot Test Result Received Date is before the Reporting Period Start Date.","This is the TestResult_ReceivedDate field of the CYP604BloodSpotResult table .The TestResult_ReceivedDate field should not be before the start of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D583)","v":0},"CYP604BloodSpotResult","CYP60445","Record rejected - Newborn Blood Spot Test Result Received Date is after the Reporting Period End Date.","This is the TestResult_ReceivedDate field of the CYP604BloodSpotResult table. If  Newborn Blood Spot Test Result Received Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D584)","v":0},"CYP605InfantPhysicalExamination(GPDelivered)","CYP60501","Group rejected - No valid CYP001 group transmitted for this Local Patient Identifier (Extended).","Record in the CYP605InfantPhysicalExamination(GPDelivered) table rejected because there is no corresponding record in the CYP001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D585)","v":0},"CYP605IPE","CYP60505","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field is a mandatory field and must be populated. It must match a LocalPatientId given in CYP001MPI."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D586)","v":0},"CYP605IPE","CYP60506","Record rejected - Local Patient Identifier (Extended) has incorrect data format.","This is LocalPatientId  field of the CYP605IPE table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D587)","v":0},"CYP605IPE","CYP60509","Record rejected - Infant Physical Examination Result (Hips) has incorrect data format.","This is Result_Hips  field of the CYP605IPE table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D588)","v":0},"CYP605IPE","CYP60510","Warning - Infant Physical Examination Result (Hips) contains an invalid national code.","This is Result_Hips  field of the CYP605IPE table. This warning has been received because an invalid national code has been used. Examples of valid codes are \"01\"(Satisfactory), \"02\"(Problem Identified), \"03\"(Problem Suspected) and \"04\"(Not Examined)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D589)","v":0},"CYP605IPE","CYP60511","Record rejected - Infant Physical Examination Result (Heart) has incorrect data format.","This is Result_Heart  field of the CYP605IPE table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D590)","v":0},"CYP605IPE","CYP60512","Warning - Infant Physical Examination Result (Heart) contains an invalid national code.","This is Result_Heart  field of the CYP605IPE table. This warning has been received because an invalid national code has been used. Examples of valid codes are \"01\"(Satisfactory), \"02\"(Problem Identified), \"03\"(Problem Suspected) and \"04\"(Not Examined)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D591)","v":0},"CYP605IPE","CYP60513","Record rejected - Infant Physical Examination Result (Eyes) has incorrect data format.","This is Result_Eyes  field of the CYP605IPE table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D592)","v":0},"CYP605IPE","CYP60514","Warning - Infant Physical Examination Result (Eyes) contains an invalid national code.","This is Result_Eyes  field of the CYP605IPE table. This warning has been received because an invalid national code has been used. Examples of valid codes are \"01\"(Satisfactory), \"02\"(Problem Identified), \"03\"(Problem Suspected) and \"04\"(Not Examined)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D593)","v":0},"CYP605IPE","CYP60515","Record rejected - Infant Physical Examination Result (Testes) has incorrect data format.","This is Result_Testes  field of the CYP605IPE table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D594)","v":0},"CYP605IPE","CYP60516","Warning - Infant Physical Examination Result (Testes) contains an invalid national code.","This is Result_Testes  field of the CYP605IPE table. This warning has been received because an invalid national code has been used. Examples of valid codes are \"01\"(Satisfactory), \"02\"(Problem Identified), \"03\"(Problem Suspected) and \"04\"(Not Examined)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D595)","v":0},"CYP605IPE","CYP60517","Record rejected - Infant Physical Examination Date has incorrect data format.","This is Examination_Date field of the CYP605IPE table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D596)","v":0},"CYP605IPE","CYP60518","Record rejected - Infant Physical Examination Date is blank.","This is the Examination_Date field of the CYP605IPE table. This is a mandatory field and should not be left blank. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D597)","v":0},"CYP605IPE","CYP60519","Record rejected - Infant Physical Examination Result (Testes) contains a value other than \"NN\", and Person Stated Gender Code contains the value \"Female\".","This is Result_Testes  field of the CYP605IPE table. This record is rejected because the Result_Testes  field does not match the corresponding value selected for the Person Gender code."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D598)","v":0},"CYP605IPE","CYP60520","Record rejected - Infant Physical Examination Date is more than 99 days after Person Birth Date.","This is the Examination_Date field of the CYP605IPE table. This is a required field and the date should not be greater than 99 days from the corresponding DateOfBirth field of CYP001MPI Table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D599)","v":0},"CYP605IPE","CYP60521","Record rejected - Infant Physical Examination Date is less than 2 weeks after Person Birth Date.","This is the Examination_Date field of the CYP605IPE table. It is the date that the PHYSICAL EXAMINATION of the INFANT took place. If Infant Physical Examination Date is less than 2 weeks after Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D600)","v":0},"CYP605IPE","CYP60522","Record rejected - Person Birth Date is blank AND Infant Physical Examination Date is before 1 January 1890.","This is the Examination_Date field  of the CYP605IPE table should not be before 1 January 1890 and the DateOfBirth field  should not be  blank ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D601)","v":0},"CYP605IPE","CYP60523","Record rejected - Infant Physical Examination Date is after the Date And Time Data Set Created.","This is the Examination_Date field of the CYP605IPE table. This is a required field and the date should not be  after  the FileCreation_DateTime field of CYP000Header Table .The expected date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D602)","v":0},"CYP605InfantPhysicalExamination(GPDelivered)","CYP60524","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP605InfantPhysicalExamination(GPDelivered) table is rejected because the corresponding  DateOfBirth field of CYP001MPI table is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D603)","v":0},"CYP605InfantPhysicalExamination(GPDelivered)","CYP60525","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 1 year or older at the Reporting Period Start Date."," The age of the patient should be less than 1 year at the Reporting Period Date. Check if the corresponding DateOfBirth field of CYP001MPI table is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D604)","v":0},"CYP606ProvDiag","CYP60601","Group rejected - No valid CYP101 provided for this Service Request Identifier.","Record in the CYP606ProvDiag table rejected because there is no corresponding record in the CYP101 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP101)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D605)","v":0},"CYP606ProvDiag","CYP60602","Group rejected - More than one CYP606 provided for this Service Request Identifier + Provisional Diagnosis Date + Provisional Diagnosis (Coded Clinical Entry) combination.","Duplicate records have been submitted with the same values in the following fields: ServiceRequestID, ProvisionalDiagnosis_Date and ProvisionalDiagnosis. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D606)","v":0},"CYP606ProvDiag","CYP60603","Record rejected - Service Request Identifier is blank.","This is the ServiceRequestId field of the CYP606ProvDiag table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D607)","v":0},"CYP606ProvDiag","CYP60604","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the CYP606ProvDiag table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D608)","v":0},"CYP606ProvDiag","CYP60605","Record rejected - Diagnosis Scheme In Use has incorrect data format.","This is the Diagnosis_Scheme field of the CYP606ProvDiag table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D609)","v":0},"CYP606ProvDiag","CYP60607","Record rejected - Provisional Diagnosis (Coded Clinical Entry) is blank.","This is the ProvisionalDiagnosis field of the CYP606ProvDiag table. This is a mandatory field and cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D610)","v":0},"CYP606ProvDiag","CYP60608","Record rejected - Provisional Diagnosis (Coded Clinical Entry) has incorrect data format.","This is the ProvisionalDiagnosis field for the CYP606ProvDiag table. The expected data format for this field is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D611)","v":0},"CYP606ProvDiag","CYP60609","Warning - Provisional Diagnosis Date is blank.","This is the ProvisionalDiagnosis_Date field of the CYP606ProvDiag table. Diagnosis Date is a required  field and the expected format is an10 (CCYY-MM-DD) ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D612)","v":0},"CYP606ProvDiag","CYP60610","Record rejected - Provisional Diagnosis Date has incorrect data format.","This is ProvisionalDiagnosis_Date  field of the CYP606ProvDiag table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D613)","v":0},"CYP606ProvDiag","CYP60613","Record rejected - Diagnosis Scheme In Use is blank.","This is the Diagnosis_Scheme field of the CYP606ProvDiag table. This is a mandatory field and should not be left blank. The expected format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D614)","v":0},"CYP606ProvDiag","CYP60614","Record rejected - Provisional Diagnosis (Coded Clinical Entry) format does not match expected format from selected Diagnosis Scheme In Use.","If Provisional Diagnosis (Coded Clinical Entry) format does not match expected format for Diagnosis Scheme In Use, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D615)","v":0},"CYP606ProvDiag","CYP60615","Record rejected - Provisional Diagnosis Date is before Referral Request Received Date.","This is ProvisionalDiagnosis_Date  field of the CYP606ProvDiag table .The record is rejected because the ProvisionalDiagnosis_Date should not be earlier than the  Referral RequestReceived Date"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D616)","v":0},"CYP606ProvDiag","CYP60616","Record rejected - Provisional Diagnosis Date is after the Service Discharge Date.","This is the ProvisionalDiagnosis_Date field of the CYP606ProvDiag table. Record is rejected if ProvisionalDiagnosis_Date is after the corresponding Discharge_Date in CYP101Referral Table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D617)","v":0},"CYP606ProvDiag","CYP60617","Record rejected - Provisional Diagnosis Date is after the Reporting Period End Date.","This is the ProvisionalDiagnosis_Date field of the CYP606ProvDiag table. If  Provisional Diagnosis Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D618)","v":0},"CYP606ProvDiag","CYP60618","Record rejected - Diagnosis Scheme In Use contains an invalid national code.","This is the Diagnosis_Scheme field of the CYP606ProvDiag table. This record is rejected because an invalid national code has been used. For a list of valid national codes visit https://www.datadictionary.nhs.uk/data_elements/diagnosis_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D619)","v":0},"CYP606ProvDiag","CYP60619","Record rejected - Diagnosis Scheme In Use contains the value '06 - SNOMED CT' and Provisional Diagnosis (Coded Clinical Entry) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If ProvisionalDiagnosis fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D620)","v":0},"CYP607PrimDiag","CYP60701","Group rejected - No valid CYP101 provided for this Service Request Identifier.","Record in the CYP607PrimDiag table rejected because there is no corresponding record in the CYP101 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP101)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D621)","v":0},"CYP607PrimDiag","CYP60702","Group rejected - More than one CYP607 provided for this Service Request Identifier + Diagnosis Date + Primary Diagnosis (Coded Clinical Entry) combination.","Duplicate records have been submitted with the same values in the following fields: ServiceRequestID, PrimaryDiagnosis_Date and PrimaryDiagnosis. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D622)","v":0},"CYP607PrimDiag","CYP60703","Record rejected - Service Request Identifier is blank.","This is the ServiceRequestId field of the CYP607PrimDiag table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D623)","v":0},"CYP607PrimDiag","CYP60704","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the CYP607PrimDiag table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D624)","v":0},"CYP607PrimDiag","CYP60705","Record rejected - Diagnosis Scheme In Use has incorrect data format.","This is Diagnosis_Scheme  field of the CYP607PrimDiag table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown.The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D625)","v":0},"CYP607PrimDiag","CYP60707","Record rejected - Primary Diagnosis (Coded Clinical Entry) is blank.","This is the PrimaryDiagnosis field of CYP607PrimDiag table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D626)","v":0},"CYP607PrimDiag","CYP60708","Record rejected - Primary Diagnosis (Coded Clinical Entry) has incorrect data format.","If Primary Diagnosis (Coded Clinical Entry) format does not match expected format for Diagnosis Scheme In Use, the record will be rejected. The expected data format is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D627)","v":0},"CYP607PrimDiag","CYP60709","Warning - Diagnosis Date is blank.","This is PrimaryDiagnosis_Date  field of the CYP607PrimDiag table .This warning is received because this field has been left blank. The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D628)","v":0},"CYP607PrimDiag","CYP60710","Record rejected - Diagnosis Date has incorrect data format.","This is PrimaryDiagnosis_Date  field of the CYP607PrimDiag table .The expected data format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D629)","v":0},"CYP607PrimDiag","CYP60713","Record rejected - Diagnosis Scheme In Use is blank.","This is Diagnosis_Scheme  field of the CYP607PrimDiag table . This is a mandatory field and should not be left blank. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D630)","v":0},"CYP607PrimDiag","CYP60714","Record rejected - Primary Diagnosis (Coded Clinical Entry) format does not match expected format from selected Diagnosis Scheme In Use.","This is PrimaryDiagnosis field of the CYP607PrimDiag table .The expected data format is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D631)","v":0},"CYP607PrimDiag","CYP60715","Record rejected - Diagnosis Date is after the Reporting Period End Date.","This is the ProvisionalDiagnosis_Date field of the CYP607PrimDiag table. If  Provisional Diagnosis Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D632)","v":0},"CYP607PrimDiag","CYP60716","Record rejected - Diagnosis Date is before Referral Request Received Date.","This is the ProvisionalDiagnosis_Date field of the CYP607PrimDiag table. If  Provisional Diagnosis Date is populated and is before the Referral Request Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D633)","v":0},"CYP607PrimDiag","CYP60717","Record rejected - Diagnosis Date is after the Service Discharge Date.","This is the ProvisionalDiagnosis_Date field of the CYP607PrimDiag table. If  Provisional Diagnosis Date is populated and is after the Service Discharge Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D634)","v":0},"CYP607PrimDiag","CYP60718","Record rejected - Diagnosis Scheme In Use contains an invalid national code.","This is the Diagnosis_Scheme field of the CYP607PrimDiag table. This record is rejected because an invalid national code has been used. For list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/diagnosis_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D635)","v":0},"CYP607PrimDiag","CYP60719","Record rejected - Diagnosis Scheme In Use contains the value '06 - SNOMED CT' and Primary Diagnosis (Coded Clinical Entry) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If PrimaryDiagnosis fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D636)","v":0},"CYP608SecDiag","CYP60801","Group rejected - No valid CYP101 provided for this Service Request Identifier.","Record in the CYP608SecDiag table rejected because there is no corresponding record in the CYP101 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP101)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D637)","v":0},"CYP608SecDiag","CYP60802","Group rejected - More than one CYP608 provided for this Service Request Identifier + Diagnosis Date + Secondary Diagnosis (Coded Clinical Entry) combination.","Duplicate records have been submitted with the same values in the following fields: ServiceRequestID, SecondaryDiagnosis_Date and SecondaryDiagnosis. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D638)","v":0},"CYP608SecDiag","CYP60803","Record rejected - Service Request Identifier is blank.","This is the ServiceRequestId field of the CYP608SecDiag table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D639)","v":0},"CYP608SecDiag","CYP60804","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the CYP608SecDiag table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D640)","v":0},"CYP608SecDiag","CYP60805","Record rejected - Diagnosis Scheme In Use has incorrect data format.","The Diagnosis_Scheme field is a mandatory field and must be populated. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D641)","v":0},"CYP608SecDiag","CYP60806","Record rejected - Diagnosis Scheme In Use is blank.","The Diagnosis_Scheme field  of the CYP608SecDiag table is a mandatory field and must be populated. This is the code scheme basis of a diagnosis. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D642)","v":0},"CYP608SecDiag","CYP60807","Record rejected - Secondary Diagnosis (Coded Clinical Entry) is blank.","This is the SecondaryDiagnosis field of the CYP608SecDiag Table. It is a mandatory field and cannot be left blank. It represents any other diagnosis other than the primary diagnosis, from a specific classification or clinical terminology. Multiple Secondary Diagnoses may be recorded."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D643)","v":0},"CYP608SecDiag","CYP60808","Record rejected - Secondary Diagnosis (Coded Clinical Entry) has incorrect data format.","If Secondary Diagnosis (Coded Clinical Entry) format does not match expected format for Diagnosis Scheme In Use, the record will be rejected. The expected data format is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D644)","v":0},"CYP608SecDiag","CYP60809","Warning - Diagnosis Date is blank.","This is the SecondaryDiagnosis_Date field of the CYP608SecDiag table. Diagnosis Date is a required  field and the warning has been generated because it has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D645)","v":0},"CYP608SecDiag","CYP60810","Record rejected - Diagnosis Date has incorrect data format.","This is the SecondaryDiagnosis_Date field of the CYP608SecDiag table. The expected format is an10 (CCYY-MM-DD) ."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D646)","v":0},"CYP608SecDiag","CYP60812","Record rejected - Secondary Diagnosis (Coded Clinical Entry) format does not match expected format from selected Diagnosis Scheme In Use.","If Secondary Diagnosis (Coded Clinical Entry) format does not match expected format for Diagnosis Scheme In Use, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D647)","v":0},"CYP608SecDiag","CYP60813","Record rejected - Diagnosis Date is after the Reporting Period End Date.","This is the SecondaryDiagnosis_Date field of the CYP608SecDiag table. If  Diagnosis Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D648)","v":0},"CYP608SecDiag","CYP60814","Record rejected - Diagnosis Date is before Referral Request Received Date.","This is the SecondaryDiagnosis_Date field of the CYP608SecDiag table. If  Diagnosis Date is populated and is before ReferralRequest_ReceivedDate in CYP101Referral, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D649)","v":0},"CYP608SecDiag","CYP60815","Record rejected - Diagnosis Date is after the Service Discharge Date.","This is the SecondaryDiagnosis_Date field of the CYP608SecDiag table. If  Diagnosis Date is populated and is after Service Discharge Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D650)","v":0},"CYP608SecDiag","CYP60816","Record rejected - Diagnosis Scheme In Use contains an invalid national code.","This is the Diagnosis_Scheme field of the CYP608SecDiag table. This record is rejected because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/diagnosis_scheme_in_use.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D651)","v":0},"CYP608SecDiag","CYP60817","Record rejected - Diagnosis Scheme In Use contains the value '06 - SNOMED CT' and Secondary Diagnosis (Coded Clinical Entry) fails standard SNOMED CT checks (Check Digit and Partition Identifier).","If PrimaryDiagnosis fails standard SNOMED CT checks (Check Digit and Partition Identifier), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D652)","v":0},"CYP609CodedAssessmentReferral","CYP60902","Group rejected - No valid CYP101 provided for this Service Request Identifier.","Record in the CYP609CodedAssessmentReferral table rejected because there is no corresponding record in the CYP101 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP101) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP101)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D653)","v":0},"CYP609CodedAssessmentReferral","CYP60903","Group rejected - More than one CYP609 provided for this Service Request Identifier + Coded Assessment Tool Type (SNOMED CT) + Person Score combination.","Duplicate records have been submitted with the same values in the following fields: ServiceRequestID, SNOMED_ID and Score. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D654)","v":0},"CYP609CodedAssessmentReferral","CYP60904","Record rejected - Service Request Identifier is blank.","This is the ServiceRequestId field of the CYP609CodedAssessmentReferral table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D655)","v":0},"CYP609CodedAssessmentReferral","CYP60905","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the CYP609CodedAssessmentReferral table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D656)","v":0},"CYP609CodedAssessmentReferral","CYP60906","Record rejected - Coded Assessment Tool Type (SNOMED CT) is blank.","This is the SNOMED_ID field of the CYP609CodedAssessmentReferral table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D657)","v":0},"CYP609CodedAssessmentReferral","CYP60907","Record rejected - Coded Assessment Tool Type (SNOMED CT) has incorrect data format.","This is the SNOMED_ID field of the CYP609CodedAssessmentReferral table. A SNOMED code is expected here, value entered could not be matched to SNOMED. The expected data format is min n6 max n18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D658)","v":0},"CYP609CodedAssessmentReferral","CYP60908","Record rejected - Person Score is blank.","This is the Score field of the CYP609CodedAssessmentReferral table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D659)","v":0},"CYP609CodedAssessmentReferral","CYP60909","Record rejected - Person Score has incorrect data format.","This is the Score field of the CYP609CodedAssessmentReferral table. The expected format for this is max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D660)","v":0},"CYP609CodedAssessmentReferral","CYP60910","Warning - Assessment Tool Completion Date is blank.","This is the AssessmentCompletion_Date field of the CYP609CodedAssessmentReferral table. This warning is received because this field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D661)","v":0},"CYP609CodedAssessmentReferral","CYP60911","Record rejected - Assessment Tool Completion Date has incorrect data format.","This is the AssessmentCompletion_Date field of the CYP609CodedAssessmentReferral table. The expected format for this is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D662)","v":0},"CYP609CodedAssessmentReferral","CYP60912","Warning - Person Score contains an invalid Person Score.","This is the Score field of the CYP609CodedAssessmentReferral table. The CSDS Assessment Tools tab of the Technical Output Specification contains the range of values expected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D663)","v":0},"CYP609CodedAssessmentReferral","CYP60913","Record rejected - Coded Assessment Tool Type (SNOMED CT) not in reference table.","This is the SNOMED_ID field of the CYP609CodedAssessmentReferral table. A SNOMED code is expected here and values entered could not be matched to SNOMED."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D664)","v":0},"CYP609CodedAssessmentReferral","CYP60915","Record rejected - Assessment Tool Completion Date is before the Referral Request Received Date.","This is the AssessmentCompletion_Date field of the CYP609CodedAssessmentReferral table. If  Diagnosis Date is populated and is before ReferralRequest_ReceivedDate in CYP101Referral, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D665)","v":0},"CYP609CodedAssessmentReferral","CYP60917","Record rejected - Assessment Tool Completion Date is before the Reporting Period Start Date.","This is the  AssessmentCompletion_Date field of the CYP609CodedAssessmentReferral table. If AssessmentCompletion_Date field is populated and before the reporting period start date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D666)","v":0},"CYP609CodedAssessmentReferral","CYP60918","Record rejected - Assessment Tool Completion Date is after the Reporting Period End Date.","This is the  AssessmentCompletion_Date field of the CYP609CodedAssessmentReferra table. If AssessmentCompletion_Date field is populated and after the reporting period end date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D667)","v":0},"CYP610BreastfeedingStatus","CYP61003","Record rejected - Care Activity Identifier is blank.","The CareActivityID field of the CYP610BreastfeedingStatus table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D668)","v":0},"CYP610BreastfeedingStatus","CYP61004","Record rejected - Care Activity Identifier has incorrect data format.","This is the CareActId field of the CYP610BreastfeedingStatus table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D669)","v":0},"CYP610BreastfeedingStatus","CYP61005","Record rejected - Breastfeeding Status is blank.","The BreastFeedingStatus field of the CYP610BreastfeedingStatus table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D670)","v":0},"CYP610BreastfeedingStatus","CYP61006","Record rejected - Breastfeeding Status has incorrect data format.","This is the BreastFeedingStatus field of the CYP610BreastfeedingStatus table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D671)","v":0},"CYP610BreastfeedingStatus","CYP61007","Warning - Breastfeeding Status contains an invalid national code.","This is the BreastFeedingStatus field of the CYP610BreastfeedingStatus table. This warning has been received because an invalid national code has been used. For  a list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/breastfeeding_status.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D672)","v":0},"CYP610BreastfeedingStatus","CYP61010","Group rejected - No valid CYP202 group transmitted for this Care Activity Identifier.","Record in the CYP610BreastfeedingStatus table rejected because there is no corresponding record in the CYP202 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP202) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP202)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D673)","v":0},"CYP610BreastfeedingStatus","CYP61011","Group rejected - More than one CYP610 provided for this Care Activity Identifier.","Duplicate records have been submitted using the same CareActivityId. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D674)","v":0},"CYP610BreastfeedingStatus","CYP61012","Group rejected - The patient identified by this Local Patient Identifier (Extended) in the CYP001 table is 19 years or older at the Reporting Period Start Date.","The age of the patient should be less than 19 years at the Reporting Period Start Date. Check if the corresponding DateOfBirth field of CYP001MPI table is correct."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D675)","v":0},"CYP610BreastfeedingStatus","CYP61013","Group rejected - The CYP001 group transmitted for this Local Patient Identifier (Extended) has a blank Person Birth Date.","Record in CYP610BreastfeedingStatus table is rejected because the corresponding  DateOfBirth field of CYP001MPI table is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D676)","v":0},"CYP611Obs","CYP61102","Record rejected - Care Activity Identifier is blank.","The CareActivityID field of the CYP611Obs table is mandatory and cannot be left blank. It will normally be automatically generated by the local system upon recording a new activity, although can be manually assigned."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D677)","v":0},"CYP611Obs","CYP61103","Record rejected - Care Activity Identifier has incorrect data format.","This is the CareActivityID field of the CYP611Obs table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D678)","v":0},"CYP611Obs","CYP61104","Record rejected - Person Weight has incorrect data format.","This is the Weight field of the CYP611Obs table. The expected format is max n3.max n3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D679)","v":0},"CYP611Obs","CYP61105","Record rejected - Person Height In Metres has incorrect data format.","This is the Height field of the CYP611Obs table. The expected format is n1.max n2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D680)","v":0},"CYP611Obs","CYP61106","Record rejected - Person Length In Centimetres has incorrect data format.","This is the Length field of the CYP611Obs table. The expected format is max n2.n1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D681)","v":0},"CYP611Obs","CYP61110","Group rejected - No valid CYP202 group transmitted for this Care Activity Identifier.","Record in the CYP611Obs table rejected because there is no corresponding record in the CYP202 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP202) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP202)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D682)","v":0},"CYP611Obs","CYP61112","Record rejected - Both Person Length In Centimetres and Person Height In Metres are populated.","If Person Length In Centimetres and Person Height In Metres are both populated, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D683)","v":0},"CYP611Obs","CYP61113","Warning - Care Activity Identifier is populated, and Person Weight, Person Height In Metres and Person Length In Centimetres are all blank.","This is the CareActivityID field of the CYP611Obs table . Warning is received because the Height, Weight and Length fields have all been left blank. If Care Activity Identifier is populated, then at least one of Person Weight, Person Height in Metres or Person Length in Centimetres should be populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D684)","v":0},"CYP611Obs","CYP61114","Group rejected - More than one CYP611 provided for this Care Activity Identifier.","Duplicate records have been submitted using the same CareActivityId. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D685)","v":0},"CYP612CodedAssessmentContact","CYP61202","Record rejected - Care Activity Identifier is blank.","The CareActivityID field of the CYP612CodedAssessmentContact table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D686)","v":0},"CYP612CodedAssessmentContact","CYP61203","Record rejected - Care Activity Identifier has incorrect data format.","This is the CareActivityID field of the CYP612CodedAssessmentContact table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D687)","v":0},"CYP612CodedAssessmentContact","CYP61204","Record rejected - Coded Assessment Tool Type (SNOMED CT) is blank.","This is the SNOMED_ID field of the CYP612CodedAssessmentContact table. This field is mandatory and cannot be left blank. If Coded Assessment Tool Type (SNOMED CT) is not in CSDS Assessment Tools reference table, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D688)","v":0},"CYP612CodedAssessmentContact","CYP61205","Record rejected - Coded Assessment Tool Type (SNOMED CT) has incorrect data format.","This is the SNOMED_ID field of the CYP612CodedAssessmentContact table. A SNOMED code is expected here, value entered could not be matched to SNOMED. The expected data format is min n6 max n18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D689)","v":0},"CYP612CodedAssessmentContact","CYP61206","Record rejected - Person Score is blank.","This is the Score field of the CYP612CodedAssessmentContact table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D690)","v":0},"CYP612CodedAssessmentContact","CYP61207","Record rejected - Person Score has incorrect data format.","This is the Score field of the CYP612CodedAssessmentContact table. The expected format is max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D691)","v":0},"CYP612CodedAssessmentContact","CYP61210","Group rejected - No valid CYP202 group transmitted for this Care Activity Identifier.","Record in the CYP612CodedAssessmentContact table rejected because there is no corresponding record in the CYP202 table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (CYP202) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (CYP202)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D692)","v":0},"CYP612CodedAssessmentContact","CYP61211","Warning - Person Score contains an invalid Person Score.","This is the Score field of the CYP612CodedAssessmentContact table. The CSDS Assessment Tools tab of the Technical Output Specification contains the range of values expected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D693)","v":0},"CYP612CodedAssessmentContact","CYP61212","Group rejected - More than one CYP612 provided for this Care Activity Identifier + Coded Assessment Tool Type (SNOMED CT) + Person Score combination.","Duplicate records have been submitted with the same values in the following fields: CareActivityID, SNOMED_ID and Score. All duplicate records will be rejected with group-level rejection error."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D694)","v":0},"CYP612CodedAssessmentContact","CYP61213","Record rejected - Coded Assessment Tool Type (SNOMED CT) not in reference table.","This is the SNOMED_ID field of the CYP612CodedAssessmentContact table. A SNOMED code is expected here and values entered could not be matched to SNOMED."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D695)","v":0},"CYP613AnonSelfAssessment","CYP61301","Record rejected - Assessment Tool Completion Date is blank.","This is the AssessmentCompletion_Date field of the CYP613AnonSelfAssessment table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D696)","v":0},"CYP613AnonSelfAssessment","CYP61302","Record rejected - Assessment Tool Completion Date has incorrect data format.","This is the AssessmentCompletion_Date field of the CYP613AnonSelfAssessment table. The expected format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D697)","v":0},"CYP613AnonSelfAssessment","CYP61303","Record rejected - Coded Assessment Tool Type (SNOMED CT) is blank.","This is the SNOMED_ID field of the CYP613AnonSelfAssessment table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D698)","v":0},"CYP613AnonSelfAssessment","CYP61304","Record rejected - Coded Assessment Tool Type (SNOMED CT) has incorrect data format.","This is the SNOMED_ID field of the CYP613AnonSelfAssessment table. A SNOMED code is expected here, value entered could not be matched to SNOMED. The expected data format is min n6 max n18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D699)","v":0},"CYP613AnonSelfAssessment","CYP61305","Record rejected - Person Score is blank.","This is the Score field of the CYP613AnonSelfAssessment table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D700)","v":0},"CYP613AnonSelfAssessment","CYP61306","Record rejected - Person Score has incorrect data format.","This is the Score field of the CYP613AnonSelfAssessment table. The expected format is max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D701)","v":0},"CYP613AnonSelfAssessment","CYP61308","Record rejected - Activity Location Type Code has incorrect data format.","This is the Activity_LocationType field of the CYP613AnonSelfAssessment table. The Technical Output Specification shows the values that are acceptable for this field. The expected format of this field is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D702)","v":0},"CYP613AnonSelfAssessment","CYP61309","Warning - Activity Location Type Code contains an invalid national code.","This is the Activity_LocationType field of the CYP613AnonSelfAssessment table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/activity_location_type_code.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D703)","v":0},"CYP613AnonSelfAssessment","CYP61310","Warning - Organisation Identifier (Code of Commissioner) is blank.","This is the OrgID_Commissioner field of the CYP613AnonSelfAssessment table. The warning is generated because the field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D704)","v":0},"CYP613AnonSelfAssessment","CYP61311","Record rejected - Organisation Identifier (Code of Commissioner) has incorrect data format.","This is the OrgID_Commissioner field of the CYP613AnonSelfAssessment table .The expected data format is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D705)","v":0},"CYP613AnonSelfAssessment","CYP61312","Warning - Organisation Identifier (Code of Commissioner) is not in national organisation tables as a \"live\" organisation at any point during the reporting period.","If Organisation Identifier (Code of Commissioner) is not in national tables, a warning will be output.  Default codes for this data item can be found in the Technical Glossary tab."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D706)","v":0},"CYP613AnonSelfAssessment","CYP61313","Record rejected - Coded Assessment Tool Type (SNOMED CT) not in reference table.","This is the SNOMED_ID field of the CYP613AnonSelfAssessment table. A SNOMED code is expected here and values entered could not be matched to SNOMED."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D707)","v":0},"CYP613AnonSelfAssessment","CYP61314","Warning - Person Score contains an invalid Person Score.","This is the Score field of the CYP613AnonSelfAssessment table. The warning if generated because the populated score does not match the expected scores. The CSDS Assessment Tools tab of the Technical Output Specification contains the range of values expected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D708)","v":0},"CYP613AnonSelfAssessment","CYP61315","Group rejected - No assessment tools currently in scope for CYP613.","Group-level Validation:  There are currently no assessment tools in scope for CYP613AnonSelfAssessment. Any records submitted in this table will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D709)","v":0},"CYP613AnonSelfAssessment","CYP61317","Record rejected - Assessment Tool Completion Date is before the Reporting Period Start Date.","This is the AssessmentCompletion_Date field of theCYP613AnonSelfAssessment table. If AssessmentCompletion_Date field is populated and before the reporting period start date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D710)","v":0},"CYP613AnonSelfAssessment","CYP61318","Record rejected - Assessment Tool Completion Date is after the Reporting Period End Date.","This is the AssessmentCompletion_Date field of the CYP613AnonSelfAssessment table. If AssessmentCompletion_Date field is populated and after the reporting period end date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D711)","v":0},"CYP901StaffDetails","CYP90101","Record rejected - Care Professional Local Identifier is blank.","This is the CareProfessionalID_Local field of the CYP901StaffDetails table. It is a unique local CARE PROFESSIONAL IDENTIFIER within a Health Care Provider which may be assigned automatically by the computer system. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D712)","v":0},"CYP901StaffDetails","CYP90102","Record rejected - Care Professional Local Identifier has incorrect data format.","This is the CareProfLocalId field and can accept up to 20 characters. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. It must match a CareProfLocalId given in CYP901StaffDetails.The expected data format for this field is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D713)","v":0},"CYP901StaffDetails","CYP90104","Record rejected - Professional Registration Body Code has incorrect data format.","This is the RegistrationBody field of the CYP901StaffDetails table.The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. The expected data format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D714)","v":0},"CYP901StaffDetails","CYP90105","Warning - Professional Registration Body Code contains an invalid national code.","This is the RegistrationBody field of the CYP901StaffDetails table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/attributes/professional_registration_body_code.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D715)","v":0},"CYP901StaffDetails","CYP90107","Record rejected - Professional Registration Entry Identifier has incorrect data format.","This is the RegistrationEntryID field of the CYP901StaffDetails table .The expected data format is max an32."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D716)","v":0},"CYP901StaffDetails","CYP90108","Record rejected - Care Professional Staff Group (Community Care) has incorrect data format.","This is the StaffGroup field of the CYP901StaffDetails table .The expected data format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D717)","v":0},"CYP901StaffDetails","CYP90109","Warning - Care Professional Staff Group (Community Care) contains an invalid national code.","This is the StaffGroup field of the CYP901StaffDetails table. This warning has been received because an invalid national code has been used. For a list of valid codes, visit https://www.datadictionary.nhs.uk/data_elements/care_professional_staff_group__community_care_.html"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D718)","v":0},"CYP901StaffDetails","CYP90110","Record rejected - Occupation Code has incorrect data format.","This is the OccupationCode field of the CYP901StaffDetails table .The expected data format is an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D719)","v":0},"CYP901StaffDetails","CYP90111","Record rejected - Care Professional (Job Role Code) has incorrect data format.","This is the JobRoleCode field of the CYP901StaffDetails table .The expected data format is an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D720)","v":0},"CYP901StaffDetails","CYP90112","Group rejected - More than one CYP901 provided for this Care Professional Local Identifier.","Duplicate records have been submitted using the same CareProfessionalID_Local. All duplicate records will be rejected with group-level rejection error."]