{"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]]}
["NHS Talking Therapies - 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-guidance"]
["More information on the validations applied to your NHS Talking Therapies submissions can be found in the Technical Output Specification available at:"]
["https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-sets/improving-access-to-psychological-therapies-data-set/submitting-iapt-data"]
[]
["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":441,"n_cols":6,"rows_kept":441,"cut":false,"hidden":true,"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","IDSREJ001","Failed database structure check\n\n","The IDB must not be altered in ANY way. All the tables must be present, all the fields listed in each table must be present and the field types must be exactly as specified. \n\"Date\", \"Time\" and \"Date and Time\" data items must be provided in a valid format. Dates that are earlier than 01/01/1890 or include a time other than 00:00:00 are not valid, and will cause the submission to be rejected."]
["Count messages (to loop though) ",{"$f":"COUNTIF(ErrorCSV!C:C,Source!D3)","v":0},"File Reject","IDSREJ002","Failed Content Check. Header Table is empty","The IDB file you have uploaded contains no entries in the IDS000Header table. No data included in this table suggests vital information is missing from this submission."]
[{"$f":"COUNTA(D:D)","v":441},{"$f":"COUNTIF(ErrorCSV!C:C,Source!D4)","v":0},"File Reject","IDSREJ003","Failed Content Check. MPI Table is empty","The IDB file you have uploaded contains no entries in the IDS001MPI table. No data included in this table suggests vital information is missing from this submission."]
["Sum the count of messages matching",{"$f":"COUNTIF(ErrorCSV!C:C,Source!D5)","v":0},"File Reject","IDSREJ004","Failed Content Check. Service or Team Referral table is empty","The IDB file you have uploaded contains no entries in the IDS101Referral table. No data included in this table suggests vital information is missing from this submission."]
[{"$f":"SUM(B2:B500)","v":0},{"$f":"COUNTIF(ErrorCSV!C:C,Source!D6)","v":0},"File Reject","IDSREJ005","Failed Content Check. GP Practice Registration table is empty.","The IDB file you have uploaded contains no entries in the IDS002GP table. No data included in this table suggests vital information is missing from this submission."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D7)","v":0},"File Reject","IDSREJ006","Failed NHS Number Check. File contains invalid NHS numbers.","NHS numbers, if provided, must pass Modulus-11 checks."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D8)","v":0},"File Reject","IDSREJ007","Failed Postcode of Usual Address Check. File contains invalid postcodes.","Postcodes, if provided, must be in one of the correct postcode formats.\nSee the 'Technical Glossary' tab in the IAPT Technical Output Specification for further details."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D9)","v":0},"File Reject","IDSREJ008","Failed Person Birth Date Check. File contains invalid dates of birth. ","Invalid Person Birth Dates corrupt the allocation of the pseudo person ID and the file cannot be accepted.\nPerson Birth Date, if provided, 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 greater than 120 years old."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D10)","v":0},"File Reject","IDSREJ009","Failed Duplicate NHS Number Check. A NHS number is allocated to more than one person.","Duplicate NHS numbers corrupt the generation of the pseudo person ID and cannot be accepted."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D11)","v":0},"File Reject","IDSREJ010","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!D12)","v":0},"File Reject","IDSREJ012","Failed Reporting Period Check. There were no submitted records in the submission file that were for the selected reporting period.","There were no submitted \"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!D13)","v":0},"File Reject","IDSREJ015","Failed Header check. File contains an invalid or duplicated Header Record.","At least one of the group or record level rejections applied to the IDS000Header table have failed. The submitted file contains no valid IDS000Header record and cannot be accepted.\nPlease see the group or record level rejection messages to identify the data quality issues."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D14)","v":0},"File Reject","IDSREJ101","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 for a particular reporting period have been rejected by field-level rejections and hence the submission for that reporting period contains no valid data.\nThe 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},"IDS000Header","IDS00001","Record rejected - Data Set Version Number is blank","The DatSetVer field of the IDS000Header table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D16)","v":0},"IDS000Header","IDS00003","Record rejected - Data Set Version Number contains an invalid value for current ruling data set.","This is the DatSetVer field of the IDS000Header table. Value should be set to the current data set version in operation. E.g. \"2.0\" for version 2.0, \"2.1\" for version 2.1, etc."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D17)","v":0},"IDS000Header","IDS00004","Record rejected - Data Set Version Number has incorrect data format","This is the DatSetVer field of the IDS000Header table. Value should be set to the current data set version in operation. E.g. \"2.0\" for version 2.0, \"2.1\" for version 2.1, etc."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D18)","v":0},"IDS000Header","IDS00012","Record rejected - Primary Data Collection System In Use is blank","The PrimSystemInUse field of the IDS000Header table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D19)","v":0},"IDS000Header","IDS00013","Record rejected - Primary Data Collection System In Use has incorrect data format.","This is the PrimSystemInUse field of the IDS000Header table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D20)","v":0},"IDS000Header","IDS00014","Record rejected - Reporting Period Start Date is blank  ","The ReportingPeriodStartDate field of the IDS000Header table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D21)","v":0},"IDS000Header","IDS00015","Record rejected - Reporting Period Start Date has incorrect data format. ","This is the ReportingPeriodStartDate field of the IDS000Header table. This field is expecting to be populated with the first day of the reporting period month. The data dictionary specification for date formats 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!D22)","v":0},"IDS000Header","IDS00016","Record rejected - Reporting Period Start Date does not match the reporting period selected in Submission Portal upload.","This is the ReportingPeriodStartDate field of the IDS000Header 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!D23)","v":0},"IDS000Header","IDS00017","Record rejected - Reporting Period End Date is blank","The ReportingPeriodEndDate field of the IDS000Header table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D24)","v":0},"IDS000Header","IDS00018","Record rejected - Reporting Period End Date has incorrect data format. ","This is the ReportingPeriodEndDate field of the IDS000Header table. This field is expecting to be populated with the last day of the reporting period month. The data dictionary specification for date formats 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},"IDS000Header","IDS00019","Record rejected - Reporting Period End Date does not match the reporting period selected in Submission Portal upload.","This is the ReportingPeriodEndDate field of the IDS000Header 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!D26)","v":0},"IDS000Header","IDS00020","Record rejected - Date And Time Data Set Created is blank","The DateTimeDatSetCreate field of the IDS000Header table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D27)","v":0},"IDS000Header","IDS00021","Record rejected - Date And Time Data Set Created has incorrect data format","This is the DateTimeDatSetCreate field of the IDS000Header table. 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 Reporting Period End Date but not after the Upload Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D28)","v":0},"IDS000Header","IDS00027","Record Rejected - Date and Time Data Set Created is after Upload Date","This is the DateTimeDatSetCreate field of the IDS000Header table. 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 Reporting Period End Date but not after the Upload Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D29)","v":0},"IDS000Header","IDS00028","Record rejected - Organisation Identifier (Code of Provider) is blank","The OrgIDProv field of the IDS000Header table is mandatory and so cannot be left blank. This is the ORGANISATION IDENTIFIER of the ORGANISATION acting as a Health Care Provider."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D30)","v":0},"IDS000Header","IDS00029","Record rejected - Organisation Identifier (Code of Provider) has incorrect data format.","This is the OrgIDProv field of the IDS000Header table. This is the ORGANISATION IDENTIFIER of the ORGANISATION acting as a Health Care Provider. The expected format is min an3 max an6."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D31)","v":0},"IDS000Header","IDS00030","Record rejected - Organisation Identifier (Code of Provider) does not match the Organisation Identifier from the Submission Portal login details.","This is the OrgIDProv field of the IDS000Header table. This is the ORGANISATION IDENTIFIER of the ORGANISATION acting as a Health Care Provider. This code should match the organisation code from the Submission Portal login details."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D32)","v":0},"IDS000Header","IDS00031","Record rejected - Organisation Identifier (Code Of Submitting Organisation) is blank","The OrgIDSubmit field of the IDS000Header table is mandatory and so cannot be left blank. This field is expecting the ORGANISATION IDENTIFIER of the ORGANISATION acting as the physical sender of a Data Set submission."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D33)","v":0},"IDS000Header","IDS00032","Record rejected - Organisation Identifier (Code Of Submitting Organisation) has incorrect data format.","This is the OrgIDSubmit field of the IDS000Header table. This field is expecting the ORGANISATION IDENTIFIER of the ORGANISATION acting as the physical sender of a Data Set submission. The expected format is min an3 max an6."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D34)","v":0},"IDS000Header","IDS00033","Warning - Organisation Identifier (Code Of Submitting Organisation) does not match the organisation Identifier from the Submission Portal login details.","This is the OrgIDSubmit field of the IDS000Header table. It is possible that this 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!D35)","v":0},"IDS000Header","IDS00034","Warning - Organisation Identifier (Code Of Submitting Organisation) is not for a current live organisation in national tables.","This is the OrgIDSubmit field of the IDS000Header table. This field is expecting the ORGANISATION IDENTIFIER of the ORGANISATION acting as the physical sender of a Data Set submission. The ODS code provided is not recognised as being live. You can search for the organisation on the ODS portal: https://odsportal.digital.nhs.uk/."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D36)","v":0},"IDS001MPI","IDS00101","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the IDS001MPI table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D37)","v":0},"IDS001MPI","IDS00102","Record rejected - Local Patient Identifier (Extended) has an incorrect data format","This is the LocalPatientId field of the IDS001MPI table and can only accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D38)","v":0},"IDS001MPI","IDS00111","Warning - NHS Number is blank.","This is the NHSNumber field of the IDS001MPI 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. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D39)","v":0},"IDS001MPI","IDS00115","Record rejected - NHS Number Status Indicator Code has an incorrect data format.","This is the NHSNumberStatus field of the IDS001MPI 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!D40)","v":0},"IDS001MPI","IDS00116","Warning - NHS Number Status Indicator Code contains an invalid NHS Number Status Indicator Code.","This is the NHSNumberStatus field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D41)","v":0},"IDS001MPI","IDS00117","Warning - NHS Number contains a value, but NHS Number Status Indicator Code is  \"07 - Number not present and trace not required\".","This is the NHSNumberStatus field of the IDS001MPI 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!D42)","v":0},"IDS001MPI","IDS00118","Warning - NHS Number Status Indicator Code should be mandatory where the NHS Number provided is blank.","This is the NHSNumberStatus field of the IDS001MPI table. If the NHS Number field is blank then 07 (Number not present and trace not required) is expected to be populated to the NHSNumberStatus field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D43)","v":0},"IDS001MPI","IDS00120","Warning - Person Birth Date is blank.","This is the PersonBirthDate field of the IDS001MPI 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!D44)","v":0},"IDS001MPI","IDS00123","Warning - Postcode of Usual Address is blank.","This is the Postcode field of the IDS001MPI 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!D45)","v":0},"IDS001MPI","IDS00125","Warning - Postcode of Usual Address is not in the national postcode look-up table as a live postcode at any point during the reporting period.","This is the Postcode field of the IDS001MPI table. These are postcodes that could not be matched against the national postcodes. Your Data Quality csv file should indicate to you which postcodes these are."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D46)","v":0},"IDS001MPI","IDS00129","Warning - Person Stated Gender Code is blank.","This is the Gender field of the IDS001MPI 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!D47)","v":0},"IDS001MPI","IDS00130","Record rejected - Person Stated Gender Code has an incorrect data format.","This is the Gender field of the IDS001MPI 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!D48)","v":0},"IDS001MPI","IDS00131","Warning - Person Stated Gender Code contains an invalid Person Stated Gender Code.","This is the Gender field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D49)","v":0},"IDS001MPI","IDS00132","Record rejected - Ethnic Category has an incorrect data format.","This is the EthnicCategory field of the IDS001MPI 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!D50)","v":0},"IDS001MPI","IDS00133","Warning - Ethnic Category contains an invalid Ethnic Category.","This is the EthnicCategory field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D51)","v":0},"IDS001MPI","IDS00138","Record rejected - Language Code (Preferred) has an incorrect data format.","This is the LanguageCodePreferred field of the IDS001MPI 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!D52)","v":0},"IDS001MPI","IDS00139","Warning - Language Code (Preferred) contains an invalid Language Code (Preferred).","This is the LanguageCodePreferred field of the IDS001MPI 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."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D53)","v":0},"IDS001MPI","IDS00145","Group rejected - No valid IDS002 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS001MPI table rejected because there is no corresponding record in the IDS002GP table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS002GP) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS002GP)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D54)","v":0},"IDS001MPI","IDS00146","Group rejected - No valid IDS101 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS001MPI table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D55)","v":0},"IDS001MPI","IDS00151","Record rejected - Organisation Identifier (Local Patient Identifier) is blank.","The OrgIDLocalPatientId field of the IDS001MPI table is mandatory and so cannot be left blank. It must match to the OrgIDProv field in IDS000Header table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D56)","v":0},"IDS001MPI","IDS00152","Record rejected - Organisation Identifier (Local Patient Identifier) has an incorrect data format.","This is the OrgIDLocalPatientId field of the IDS001MPI table. The value expected is between 3 and 5 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D57)","v":0},"IDS001MPI","IDS00153","Warning - Organisation Identifier (Local Patient Identifier) does not match the Organisation Identifier (Code of Provider) from the IDS000.","This is the OrgIDLocalPatientId field of the IDS001MPI table. We usually see this as the same Organisation Identifier that is in the Header table (OrgIDProv field) as this is the code of the organisation who assigned the ID for the patient (the LocalPatientId). This can be different though if the LocalPatientID was assigned by a different organisation."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D58)","v":0},"IDS001MPI","IDS00154","Warning - Organisation Identifier (Local Patient Identifier) is not for a current live organisation in national tables.","This is the OrgIDLocalPatientId field of the IDS001MPI table. We usually see this as the same Organisation Identifier that is in the Header table (OrgIDProv field) as this is the code of the organisation who assigned the ID for the patient (the LocalPatientId)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D59)","v":0},"IDS001MPI","IDS00155","Record rejected - Organisation Identifier (Residence Responsibility) has an incorrect data format.","This is the OrgIDResidenceResp field of the IDS001MPI table. The value expected is between 3 and 5 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D60)","v":0},"IDS001MPI","IDS00156","Warning - Organisation Identifier (Residence Responsibility) is not for a current live organisation in national tables.","This is the OrgIDResidenceResp field of the IDS001MPI table. This field can routinely be left blank, however if populated it should contain the organisation Identifier of the commissioner with which the patient is resident."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D61)","v":0},"IDS001MPI","IDS00157"," Record rejected - Educational Establishment Type (Improving Access to Psychological Therapies) has an incorrect data format.","This is the EduEstabTypeIAPT field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field. The expected format for this field is max an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D62)","v":0},"IDS001MPI","IDS00158","Warning - Educational Establishment Type (Improving Access to Psychological Therapies) contains an invalid Educational Establishment Type (Improving Access to Psychological Therapies).","This is the EduEstabTypeIAPT field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D63)","v":0},"IDS001MPI","IDS00159","Record rejected - Ex-British Armed Forces Indicator has an incorrect data format.","This is the ExBAFIndicator field of the IDS001MPI 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!D64)","v":0},"IDS001MPI","IDS00160","Warning - Ex-British Armed Forces Indicator contains an invalid Ex-British Armed Forces Indicator code.","This is the ExBAFIndicator field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D65)","v":0},"IDS001MPI","IDS00161","Warning - NHS NUMBER is blank but the NHS NUMBER STATUS INDICATOR CODE is a value of '01' or '02'.","This is the NHSNumberStatus field of the IDS001MPI table. Where the NHS Number field has been left blank then the NHSNumberStatus field is expected to be populated with the value 07 (Number not present and trace not required)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D66)","v":0},"IDS001MPI","IDS00162","Warning - NHS NUMBER STATUS INDICATOR CODE is blank.","This is the NHSNumberStatus field of the IDS001MPI table. Warning that the 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!D67)","v":0},"IDS001MPI","IDS00163","Warning - Gender Identity Code (Mental Health) is blank.","This is the GenderIdentity field of the IDS001MPI table. Warning that the 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!D68)","v":0},"IDS001MPI","IDS00164","Record rejected - Gender Identity Code (Mental Health) has an incorrect data format. ","This is the GenderIdentity field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field. The data format of this field is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D69)","v":0},"IDS001MPI","IDS00165","Warning - Gender Identity Code (Mental Health) contains an invalid Gender Identity Code (Mental Health).","This is the GenderIdentity field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D70)","v":0},"IDS001MPI","IDS00166","Warning - Gender Identity Same At Birth Indicator is blank.","This is the GenderIdentitySameAtBirth field of the IDS001MPI table. Warning that the field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D71)","v":0},"IDS001MPI","IDS00167","Record rejected - Gender Identity Same At Birth Indicator has an incorrect data format.","This is the GenderIdentitySameAtBirth field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field. The data format of this field is an1. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D72)","v":0},"IDS001MPI","IDS00168","Warning - Gender Identity Same At Birth Indicator contains an invalid Gender Identity Same At Birth Indicator.","This is the GenderIdentitySameAtBirth field of the IDS001MPI table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D73)","v":0},"IDS001MPI","IDS00169","Warning - Gender Identity Same At Birth Indicator populated but Gender Identity Code is blank.","This is the GenderIdentitySameAtBirth fieldof the IDS001MPI table. If the GenderIdentitySameAtBirth field is populated then the GenderIdentity field should also be populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D74)","v":0},"IDS001MPI","IDS00170","IDS00170 - Record rejected - Ethnic Category 2021 has incorrect data format.","This is the EthnicCategory2021 field of the IDS001MPI table. The expected format is max an3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D75)","v":0},"IDS001MPI","IDS00171","IDS00171 - Warning - An agreed value list for Ethnic Category 2021 does not yet exist.","This is the EthnicCategory2021 field of the IDS001MPI table. If Ethnic Category 2021 is populated a warning will be reported. An agreed value list for Ethnic Category 2021 does not yet exist. No data is expected for this data item until an agreed value list has been created by the NHS Data Model and Dictionary."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D76)","v":0},"IDS001MPI","IDS00172","IDS00172 - Record rejected - Person Birth Date is blank.","This is the PersonBirthDate field of the IDS001MPI table. If Person Birth Date is blank, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D77)","v":0},"IDS002GP","IDS00201","Record rejected - Local Patient Identifier (Extended) is blank","The LocalPatientId field of the IDS002GP table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D78)","v":0},"IDS002GP","IDS00202","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS002GP table and can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D79)","v":0},"IDS002GP","IDS00203","Record rejected - General Medical Practice Code (Patient Registration) is blank.","This is the GMPCodeReg field of the IDS002GP table. The GMPCodeReg field of the GP table is mandatory and cannot be left blank. 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!D80)","v":0},"IDS002GP","IDS00204","Record rejected - General Medical Practice Code (Patient Registration) has an incorrect data format.","This is the GMPCodeReg field of the IDS002GP table. The expected format for this field is an6."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D81)","v":0},"IDS002GP","IDS00206","Warning - General Medical Practice Code (Patient Registration) is not for a current live organisation in national tables.","This is the GMPCodeReg field of the IDS002GP table. Your Data Quality csv file should indicate which these unrecognised codes are."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D82)","v":0},"IDS002GP","IDS00210","Record rejected - Start Date (GMP Patient Registration) has an incorrect data format.","This is the StartDateGMPRegistration field of the IDS002GP table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D83)","v":0},"IDS002GP","IDS00211","Record rejected - Start Date (GMP Patient Registration) is after the end of the reporting period + 1 day.","This is the StartDateGMPRegistration field of the IDS002GP table. The Start Date cannot be after the end date of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D84)","v":0},"IDS002GP","IDS00212","Record rejected - Start Date (GMP Patient Registration) is before Person Birth Date.","This is the StartDateGMPRegistration field of the IDS002GP table. If START DATE is before Person Birth Date (as included in IDS001), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D85)","v":0},"IDS002GP","IDS00213","Record rejected - End Date (GMP Patient Registration) has an incorrect data format.","This is the EndDateGMPRegistration field of the IDS002GP table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D86)","v":0},"IDS002GP","IDS00214","Record rejected - End Date (GMP Patient Registration) is before the start of the reporting period.","This is the EndDateGMPRegistration field of the IDS002GP table. If EndDateGMPRegistration is populated and is before the start of the reporting period then the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D87)","v":0},"IDS002GP","IDS00215","Record rejected - End Date (GMP Patient Registration) is after the end of the reporting period.","This is the EndDateGMPRegistration field of the IDS002GP table. If EndDateGMPRegistration is populated and is after the end of the reporting period then the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D88)","v":0},"IDS002GP","IDS00216","Record rejected - End Date (GMP Patient Registration) is prior to the associated Start Date (GMP Patient Registration)","This is the EndDateGMPRegistration field of the IDS002GP table. If EndDateGMPRegistration is populated and is before the StartDateGMPRegistration then the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D89)","v":0},"IDS002GP","IDS00217","Warning - Organisation Identifier (GP Practice Responsibility) is blank.","This is the OrgIDGPPrac field of the IDS002GP 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!D90)","v":0},"IDS002GP","IDS00218","Record rejected - Organisation Identifier (GP Practice Responsibility) has incorrect data format.","This is the OrgIDGPPrac field of the IDS002GP table. The expected format is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D91)","v":0},"IDS002GP","IDS00219","Warning - Organisation Identifier (GP Practice Responsibility) provided is not in National Code tables.","This is the OrgIDGPPrac field of the IDS002GP table. This field can routinely be left blank. However, if populated, it should contain the organisation identifier of the commissioner that is associated with the patient’s current registered GP Practice. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D92)","v":0},"IDS002GP","IDS00220","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS002GP table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D93)","v":0},"IDS002GP","IDS00221","Group rejected - More than one IDS002 provided for this Local Patient Identifier (Extended) + General Medical Practice Code (Patient Registration) + Start Date (GMP Patient Registration) combination.","Within the IDS002GP table, the combination of LocalPatientId and GMPCodeReg and StartDateGMPRegistration cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D94)","v":0},"IDS002GP","IDS00222","Group rejected - More than one IDS002 provided for this Local Patient Identifier (Extended) where End Date (GMP Patient Registration) is null.","The IDS002GP table is to hold only one active GP for each patient. Where there is more than one GP record within the table then the non-active GP record needs to have the EndDateGMPRegistration field populated. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D95)","v":0},"IDS002GP","IDS00223","Warning - If a record is submitted with an End Date (GMP Practice Registration) populated, a corresponding record should be submitted with a consecutive Start Date (GMP Patient Registration) and a different General Medical Practice Code (Patient Registration) for this Local Patient Identifier (Extended).","Within the IDS002GP table, this message relates to the StartDateGMPRegistration and the EndDateGMPRegistration fields. These warnings appear to be showing because the end date of the old GP is the same as the start date of the new GP and is not the following day. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D96)","v":0},"IDS003AccommStatus","IDS00301","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the IDS003AccommStatus table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D97)","v":0},"IDS003AccommStatus","IDS00302","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS003AccommStatus table. The field can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D98)","v":0},"IDS003AccommStatus","IDS00303","Record rejected - Accommodation Type is blank.","The AccommodationType field of the IDS003AccommStatus table is mandatory and so cannot be left blank. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D99)","v":0},"IDS003AccommStatus","IDS00304","Record rejected - Accommodation Type has incorrect data format.","This is the AccommodationType field of the IDS003AccommStatus 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!D100)","v":0},"IDS003AccommStatus","IDS00305","Warning - Accommodation Type contains an invalid Accommodation Type.","This is the AccommodationType field of the IDS003AccommStatus table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D101)","v":0},"IDS003AccommStatus","IDS00306","Record rejected - Settled Accommodation Indicator has incorrect data format.","This is the SettledAccommodationInd field of the IDS003AccommStatus table. The Technical Output Specification shows the values that are acceptable for this field. The expected format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D102)","v":0},"IDS003AccommStatus","IDS00307","Warning - Settled Accommodation Indicator contains an invalid Settled Accommodation Indicator.","This is the SettledAccommodationInd field of the IDS003AccommStatus table. The Technical Output Specification shows the values that are acceptable for this field. The expected format is an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D103)","v":0},"IDS003AccommStatus","IDS00308","Record rejected - Accommodation Type Recorded Date has incorrect date format.","This is the AccommodationTypeDate field of the IDS003AccommStatus table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D104)","v":0},"IDS003AccommStatus","IDS00309","Record rejected - Accommodation Type Recorded Date is after the end date of the reporting period. ","This is the AccommodationTypeDate field of the IDS003AccommStatus table. If date entered is after the end of the reporting period then the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D105)","v":0},"IDS003AccommStatus","IDS00310","Group rejected - No valid IDS001 group transmitted for this  Local Patient Identifier (Extended).","Record in the IDS003AccommStatus table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D106)","v":0},"IDS003AccommStatus","IDS00312","Warning - Accommodation Type Recorded Date is blank.","This is the AccommodationTypeDate field of the IDS003AccommStatus table. Warning that the field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D107)","v":0},"IDS003AccommStatus","IDS00315","Group rejected -  More than one IDS003 provided for this Local Patient Identifier (Extended) + Accomodation Status Recorded Date combination.","Within the IDS003AccommStatus table, the combination of LocalPatientId and GMPCodeReg and AccommodationStatusDate cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D108)","v":0},"IDS003AccommStatus","IDS00316","Group rejected - More than one IDS003 provided for this Local Patient Identifier (Extended) where Accomodation Status Recorded Date is null.","Within the IDS003AccommStatus table, there is more than one entry of the LocalPatientId entry where the AccommodationTypeDate entry is null. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D109)","v":0},"IDS003AccommStatus","IDS00317","Record rejected - Accommodation Type Start Date has incorrect date format.","This is the AccommodationTypeStartDate field of the IDS003AccommStatus table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D110)","v":0},"IDS003AccommStatus","IDS00318","Record rejected - Accommodation Type Start Date is after the end date of the reporting period.","This is the AccommodationTypeStartDate field of the IDS003AccommStatus table. If date entered is after the end of the reporting period then the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D111)","v":0},"IDS003AccommStatus","IDS00319","Warning - Accommodation Type Start Date is blank.","This is the AccommodationTypeStartDate field of the IDS003AccommStatus table. Warning that the field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D112)","v":0},"IDS003AccommStatus","IDS00320","Record rejected - Accommodation Type End Date has incorrect date format.","This is the AccommodationTypeEndDate field of the IDS003AccommStatus table. The date format is an10 (CCYY-MM-DD)"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D113)","v":0},"IDS003AccommStatus","IDS00321","Record rejected - Accommodation Type End Date is after the end date of the reporting period.","This is the AccommodationTypeEndDate field of the IDS003AccommStatus table. The record is rejected if the entered date is after the end date of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D114)","v":0},"IDS003AccommStatus","IDS00322","Warning - Accommodation Type End Date is blank.","This is the AccommodationTypeEndDate field of the IDS003AccommStatus table. Warning that the field has been left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D115)","v":0},"IDS003AccommStatus","IDS00323","IDS00323 - Record rejected - Accommodation Type End Date is before Accommodation Type Start Date.","This is the AccommodationTypeEndDate field of the IDS003AccommStatus table. The Accommodation Type End Date cannot be before the Accommodation Type Start Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D116)","v":0},"IDS004EmpStatus","IDS00401","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS004EmpStatus table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D117)","v":0},"IDS004EmpStatus","IDS00402","Group rejected - More than one IDS004 provided for this Local Patient Identifier (Extended) + Employment Status Recorded Date combination.","Within the IDS004EmpStatus table, the combination of LocalPatientId and EmployStatusRecDate cannot be repeated.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D118)","v":0},"IDS004EmpStatus","IDS00403","Record rejected - Local Patient Identifier (Extended) is blank ","The LocalPatientId field of the IDS004EmpStatus table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D119)","v":0},"IDS004EmpStatus","IDS00404","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS004EmpStatus table. This field can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D120)","v":0},"IDS004EmpStatus","IDS00405","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!D121)","v":0},"IDS004EmpStatus","IDS00406","Record rejected - Employment Status has incorrect data format.","This is the EmployStatus field of the IDS004EmpStatus 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!D122)","v":0},"IDS004EmpStatus","IDS00407","Warning - Employment Status contains an invalid Employment Status.","This is the EmployStatus field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D123)","v":0},"IDS004EmpStatus","IDS00408","Record rejected - Employment Status Recorded Date has incorrect date format.","This is the EmployStatusRecDate field of the IDS004EmpStatus table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D124)","v":0},"IDS004EmpStatus","IDS00410","Record rejected - Weekly Hours Worked has incorrect data format.","This is the WeekHoursWorked field of the IDS004EmpStatus 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!D125)","v":0},"IDS004EmpStatus","IDS00411","Warning - Weekly Hours Worked contains an invalid Weekly Hours Worked.","This is the WeekHoursWorked field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D126)","v":0},"IDS004EmpStatus","IDS00412","Warning - Employment Status Recorded Date is blank.","This is the EmployStatusRecDate field of the IDS004EmpStatus table. This is a reminder that the field has not been populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D127)","v":0},"IDS004EmpStatus","IDS00413","Record Rejected - Self Employed Indicator has incorrect data format.","This is the SelfEmployInd field of the IDS004EmpStatus 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!D128)","v":0},"IDS004EmpStatus","IDS00414","Warning - Self Employed Indicator contains an invalid Self Employed Indicator.","This is the SelfEmployInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D129)","v":0},"IDS004EmpStatus","IDS00415","Record Rejected - Sickness Absence Indicator has incorrect data format.","This is the SickAbsenceInd field of the IDS004EmpStatus 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!D130)","v":0},"IDS004EmpStatus","IDS00416","Warning - Sickness Absence Indicator contains an invalid Sickness Absence Indicator.","This is the SickAbsenceInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field.\n"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D131)","v":0},"IDS004EmpStatus","IDS00417","Record Rejected - Statutory Sick Pay Receipt Indicator has incorrect data format.","This is the SSPInd field of the IDS004EmpStatus 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!D132)","v":0},"IDS004EmpStatus","IDS00418","Warning - Statutory Sick Pay Receipt Indicator contains an invalid Statutory Sick Pay Receipt Indicator.","This is the SSPInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D133)","v":0},"IDS004EmpStatus","IDS00419","Record Rejected - Benefit Receipt Indicator has incorrect data format.","This is the BenefitRecInd field of the IDS004EmpStatus 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!D134)","v":0},"IDS004EmpStatus","IDS00420","Warning - Benefit Receipt Indicator contains an invalid Benefit Receipt Indicator.","This is the BenefitRecInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D135)","v":0},"IDS004EmpStatus","IDS00421","Record Rejected - Jobseekers Allowance Receipt Indicator has incorrect data format.","This is the JSAInd field field of the IDS004EmpStatus 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!D136)","v":0},"IDS004EmpStatus","IDS00422","Warning - Jobseekers Allowance Receipt Indicator contains an invalid Jobseekers Allowance Receipt Indicator.","This is the JSAInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D137)","v":0},"IDS004EmpStatus","IDS00423","Record Rejected - Employment And Support Allowance Receipt Indicator has incorrect data format.","This is the ESAInd field of the IDS004EmpStatus 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!D138)","v":0},"IDS004EmpStatus","IDS00424","Warning - Employment And Support Allowance Receipt Indicator contains an invalid Employment And Support Allowance Receipt Indicator.","This is the ESAInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D139)","v":0},"IDS004EmpStatus","IDS00425","Record Rejected - Universal Credit Receipt Indicator has incorrect data format. ","This is the UCInd field of the IDS004EmpStatus 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!D140)","v":0},"IDS004EmpStatus","IDS00426","Warning - Universal Credit Receipt Indicator contains an invalid Universal Credit Receipt Indicator.","This is the UCInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D141)","v":0},"IDS004EmpStatus","IDS00427","Record Rejected - Personal Independence Payment Receipt Indicator has incorrect data format.","This is the PIPInd field of the IDS004EmpStatus 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!D142)","v":0},"IDS004EmpStatus","IDS00428","Warning - Personal Independence Payment Receipt Indicator contains an invalid Personal Independence Payment Receipt Indicator.","This is the PIPInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D143)","v":0},"IDS004EmpStatus","IDS00429","Record Rejected - Other Benefits Receipt Indicator has incorrect data format.","This is the OtherBenefitInd field of the IDS004EmpStatus 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!D144)","v":0},"IDS004EmpStatus","IDS00430","Warning - Other Benefits Receipt Indicator contains an invalid Other Benefits Receipt Indicator.","This is the OtherBenefitInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D145)","v":0},"IDS004EmpStatus","IDS00431","Record Rejected - Employment Support Suitability Indicator has incorrect data format.","This is the EmpSupportInd field of the IDS004EmpStatus 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!D146)","v":0},"IDS004EmpStatus","IDS00432","Warning - Employment Support Suitability Indicator contains an invalid Employment Support Suitability Indicator.","This is the EmpSupportInd field of the IDS004EmpStatus table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D147)","v":0},"IDS004EmpStatus","IDS00433","Warning - Employment Support Referral Date is populated and Employment Support Suitability Indicator is blank.","This is the EmpSupportInd field of the IDS004EmpStatus table. If Employment Support Referral Date is populated and Employment Support Suitability Indicator is blank, a warning will be generated. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D148)","v":0},"IDS004EmpStatus","IDS00434","Record Rejected - Employment Support Referral Date has incorrect data format.","This is the EmpSupportReferral field of the IDS004EmpStatus table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D149)","v":0},"IDS004EmpStatus","IDS00435","Warning - Employment Support Suitability Indicator is populated and equals Y but Employment Support Referral Date is blank.","This is the EmpSupportReferral field of the IDS004EmpStatus table. If Employment Support Suitability Indicator is populated and equals Y, but Employment Support Referral Date is blank, a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D150)","v":0},"IDS004EmpStatus","IDS00436","Record rejected - Employment Status Recorded Date is after Reporting Period End Date.","This is the EmployStatusRecDate field of the IDS004EmpStatus 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!D151)","v":0},"IDS004EmpStatus","IDS00437","Record rejected - Employment Support Referral Date is after the end of the reporting period.","This is the EmpSupportReferral field of the IDS004EmpStatus table. If Employment Support Referral Date is populated and is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D152)","v":0},"IDS004EmpStatus","IDS00438","Record rejected - Employment Status Recorded Date is before Person Birth Date.","This is the EmployStatusRecDate field of the IDS004EmpStatus table. If date is before the Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D153)","v":0},"IDS004EmpStatus","IDS00439","Record rejected - Employment Support Referral Date is before Person Birth Date.","This is the EmpSupportReferral field of the IDS004EmpStatus table. If Employment Support Referral Date is before the Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D154)","v":0},"IDS004EmpStatus","IDS00440","Group rejected - More than one IDS004 provided for this Local Patient Identifier (Extended) where Employment Status Recorded Date is null.","Within the IDS004EmpStatus table, this is the combination of LocalPatientId and EmployStatusRecDate fields. It is not expected to see more than one entry of a LocalPatientId value where the EmployStatusRecDate field is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D155)","v":0},"IDS004EmpStatus","IDS00441","Record Rejected - Discharge Date (Employment Support) has incorrect data format.","This is the EmpSupportDischargeDate field of the IDS004EmpStatus table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D156)","v":0},"IDS004EmpStatus","IDS00442","Record rejected - Discharge Date (Employment Support) is after the end of the reporting period.","This is the EmpSupportDischargeDate field of the IDS004EmpStatus table. If date is after the reporting period end date then the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D157)","v":0},"IDS004EmpStatus","IDS00443","Record rejected - Discharge Date (Employment Support) is before Person Birth Date.","This is the EmpSupportDischargeDate field of the IDS004EmpStatus table. If date is before the Person Birth Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D158)","v":0},"IDS004EmpStatus","IDS00444","Warning - Discharge Date (Employment Support) is before Employment Status Recorded Date.","This is the EmpSupportDischargeDate field of the IDS004EmpStatus table. Warning that the date is before the Employment Status Recorded Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D159)","v":0},"IDS004EmpStatus","IDS00445","IDS00445 - Record rejected - Employment Status Recorded Date is blank.","This is the EmployStatusRecDate field of the IDS004EmpStatus table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D160)","v":0},"IDS007DisabilityType","IDS00701","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS007DisabilityType table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D161)","v":0},"IDS007DisabilityType","IDS00702","Group rejected - More than one IDS007 provided for this Local Patient Identifier (Extended) + Disability Code combination.","Within the IDS007DisabilityType table, the combination of LocalPatientId and DisabCode cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D162)","v":0},"IDS007DisabilityType","IDS00703","Record rejected - Local Patient Identifier (Extended) is blank","The LocalPatientId field of the IDS007DisabilityType table is mandatory field and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D163)","v":0},"IDS007DisabilityType","IDS00704","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS007DisabilityType table. This field can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D164)","v":0},"IDS007DisabilityType","IDS00705","Record rejected - Disability Code is blank.","This is the DisabCode field of the IDS007DisabilityType 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!D165)","v":0},"IDS007DisabilityType","IDS00706","Record rejected - Disability Code has incorrect data format.","This is the DisabCode field of the IDS007DisabilityType 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!D166)","v":0},"IDS007DisabilityType","IDS00707","Warning - Disability Code contains an invalid Disability Code.","This is the DisabCode field of the IDS007DisabilityType table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D167)","v":0},"IDS011SocPerCircumstances","IDS01101","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS011SocPerCircumstances table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D168)","v":0},"IDS011SocPerCircumstances","IDS01102","Group rejected - More than one IDS011 provided for this Local Patient Identifier + Social and Personal Circumstance Recorded Date + Social and Personal Circumstance (SNOMED CT) combination.","Within the IDS011SocPerCircumstances table, the combination of LocalPatientId and SocPerCircumstance and SocPerCircumstanceRecDate cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D169)","v":0},"IDS011SocPerCircumstances","IDS01103","Record rejected - Local Patient Identifier (Extended) is blank","The LocalPatientId field of the IDS011SocPerCircumstances table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D170)","v":0},"IDS011SocPerCircumstances","IDS01104","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS011SocPerCircumstances table. This field can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D171)","v":0},"IDS011SocPerCircumstances","IDS01106","Record rejected - Social and Personal Circumstance Recorded Date has incorrect date format.","This is the SocPerCircumstanceRecDate field of the IDS011SocPerCircumstances table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D172)","v":0},"IDS011SocPerCircumstances","IDS01107","Record rejected - Social and Personal Circumstance Recorded Date is after the end of the reporting period.","This is the SocPerCircumstanceRecDate field of the IDS011SocPerCircumstances 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!D173)","v":0},"IDS011SocPerCircumstances","IDS01108","Record rejected - Social and Personal Circumstance (SNOMED CT) is blank.","This is the SocPerCircumstance field of the IDS011SocPerCircumstances table. This is a mandatory field and so if a record is being written to this table this field needs to be populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D174)","v":0},"IDS011SocPerCircumstances","IDS01109","Record rejected - Social and Personal Circumstance (SNOMED CT) has failed SNOMED CT checks.","This is the SocPerCircumstance field of the IDS011SocPerCircumstances table. The field is expecting a SNOMED code for the Religion and also the Sexual Orientation of the patient. Some examples of the data we see populated to this field are 20430005, 160552003, 160549006, 42035005, 38628009, 763896000. A good place to start with this is by looking at 28 of the User Guidance document at the below location.\nhttps://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-sets/improving-access-to-psychological-therapies-data-set/submitting-iapt-data"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D175)","v":0},"IDS011SocPerCircumstances","IDS01110","Warning - Social and Personal Circumstance Recorded Date is blank.","This is the SocPerCircumstanceRecDate field of the IDS011SocPerCircumstances table. This is population of the SocPerCircumstanceRecDate field, if that data is available."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D176)","v":0},"IDS011SocPerCircumstances","IDS01111","Record rejected - Social and Personal Circumstance Recorded Date is before Person Birth Date.","This is the SocPerCircumstanceRecDate field of the IDS011SocPerCircumstances table. If Social and Personal Circumstance Recorded Date is before Person Birth Date (as included in IDS001MPI), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D177)","v":0},"IDS011SocPerCircumstances","IDS01112","IDS01112 - Group rejected - More than one IDS011 provided for this Local Patient Identifier (Extended) + Social and Personal Circumstance (SNOMED CT) combination where Social and Personal Circumstance Recorded Date is null.","Within the IDS011SocPerCircumstances table, the combination of LocalPatientId and SocPerCircumstance cannot be repeated where the SocPerCircumstanceRecDate is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D178)","v":0},"IDS012OverseasVisitorChargCat","IDS01201","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS012OverseasVisitorChargCat table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D179)","v":0},"IDS012OverseasVisitorChargCat","IDS01202","Group rejected - More than one IDS012 provided for this Local Patient Identifier + Overseas Visitor Charging Category + Overseas Visitor Charging Category Applicable Date combination.","Within the IDS012OverseasVisitorChargCat table, the combination of LocalPatientId and OvsVisChCat and OvsVisChCatAppDate cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D180)","v":0},"IDS012OverseasVisitorChargCat","IDS01203","Record rejected - Local Patient Identifier (Extended) is blank","The LocalPatientId field of the IDS012OverseasVisitorChargCat table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D181)","v":0},"IDS012OverseasVisitorChargCat","IDS01204","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS012OverseasVisitorChargCat table and can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D182)","v":0},"IDS012OverseasVisitorChargCat","IDS01205","Record rejected - Overseas Visitor Charging Category is blank.","This is the OvsVisChCat field of the IDS012OverseasVisitorChargCat table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D183)","v":0},"IDS012OverseasVisitorChargCat","IDS01206","Record rejected - Overseas Visitor Charging Category has incorrect data format.","This is the OvsVisChCat field of the IDS012OverseasVisitorChargCat 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!D184)","v":0},"IDS012OverseasVisitorChargCat","IDS01207","Warning - Overseas Visitor Charging Category contains an invalid Overseas Visitor Charging Category.","This is the OvsVisChCat field of the IDS012OverseasVisitorChargCat table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D185)","v":0},"IDS012OverseasVisitorChargCat","IDS01208","Record rejected - Overseas Visitor Charging Category Applicable Date has incorrect date format.","This is the OvsVisChCatAppDate field of the IDS012OverseasVisitorChargCat table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D186)","v":0},"IDS012OverseasVisitorChargCat","IDS01209","Record rejected - Overseas Visitor Charging Category Applicable Date is after the end of the reporting period.","This is the OvsVisChCatAppDate field of the IDS012OverseasVisitorChargCat table. The date is after the reporting period end date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D187)","v":0},"IDS012OverseasVisitorChargCat","IDS01210","Warning - Overseas Visitor Charging Category Applicable Date is blank Local.","This is the OvsVisChCatAppDate field of the IDS012OverseasVisitorChargCat table. The date when the PATIENT's OVERSEAS VISITOR CHARGING CATEGORY was applicable from. If the applicable date is not available, this should be the date the OVERSEAS VISITOR CHARGING CATEGORY was recorded."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D188)","v":0},"IDS012OverseasVisitorChargCat","IDS01211","Record rejected - Overseas Visitor Charging Category Applicable Date is before Person Birth Date.","This is the OvsVisChCatAppDate field of the IDS012OverseasVisitorChargCat table. The date is before the Person Birth Date."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D189)","v":0},"IDS012OverseasVisitorChargCat","IDS01212","IDS01212 - Group rejected - More than one IDS012 provided for this Local Patient Identifier + Overseas Visitor Charging Category combination where Overseas Visitor Charging Category Applicable Date is null.","Within the IDS012OverseasVisitorChargCat table, the combination of LocalPatientId and OvsVisChCat cannot be repeated where the OvsVisChCatAppDate field is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D190)","v":0},"IDS101Referral","IDS10101","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS101Referral table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D191)","v":0},"IDS101Referral","IDS10103","Group rejected - More than one IDS101 provided for this Service Request Identifier.","This is the ServiceRequestId field of the IDS101Referral table. This is a unique identifier of the referral and cannot appear in this table more than once. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D192)","v":0},"IDS101Referral","IDS10104","Record rejected - Service Request Identifier is blank.","This is the ServiceRequestId field of the IDS101Referral table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D193)","v":0},"IDS101Referral","IDS10105","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the IDS101Referral table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D194)","v":0},"IDS101Referral","IDS10106","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the IDS101Referral table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D195)","v":0},"IDS101Referral","IDS10107","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS101Referral table and can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D196)","v":0},"IDS101Referral","IDS10108","Record rejected - Organisation Identifier (Code of Commissioner) is blank.","This is the OrgIDComm field of the IDS101Referral table. The OrgIDComm field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D197)","v":0},"IDS101Referral","IDS10109","Record rejected - Organisation Identifier (Code of Commissioner) has incorrect data format.","This is the OrgIDComm field of the IDS101Referral table. The expected format for this field is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D198)","v":0},"IDS101Referral","IDS10110","Warning - Organisation Identifier (Code of Commissioner) is not for a current live organisation in National Code tables.","This is the OrgIDComm field of the IDS101Referral 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!D199)","v":0},"IDS101Referral","IDS10111","Record rejected - Referral Request Received Date is blank.","This is the ReferralRequestReceivedDate field of the IDS101Referral table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D200)","v":0},"IDS101Referral","IDS10112","Record rejected - Referral Request Received Date has incorrect date format.","This is the ReferralRequestReceivedDate field of the IDS101Referral table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D201)","v":0},"IDS101Referral","IDS10113","Record rejected - Referral Request Received Date is after the end of the reporting period.","This is the ReferralRequestReceivedDate field of the IDS101Referral 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!D202)","v":0},"IDS101Referral","IDS10117","Record rejected - Source Of Referral For Mental Health has incorrect data format.","This is the SourceOfReferralIAPT field of the IDS101Referral table. The Technical Output Specification shows the values that are acceptable for this field. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D203)","v":0},"IDS101Referral","IDS10118","Warning - Source Of Referral For Mental Health contains an invalid Source Of Referral For Mental Health.","This is the SourceOfReferralMH field of the IDS101Referral table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D204)","v":0},"IDS101Referral","IDS10127","Record rejected - Service Discharge Date has incorrect date format.","This is the ServDischDate field of the IDS101Referral table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D205)","v":0},"IDS101Referral","IDS10128","Record rejected - Service Discharge Date is prior to the associated Referral Request Received Date.","This is the ServDischDate field of the IDS101Referral table. If Service Discharge Date is before the Referral Request Received Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D206)","v":0},"IDS101Referral","IDS10129","Record rejected - Service Discharge Date is before the start of the reporting period but no follow-up appointment or PEQ have been submitted for this Service Request Identifier.","This is the ServDischDate field of the IDS101Referral table. If Service Discharge Date is before the start of the reporting period, the record will be rejected unless a valid 'follow-up' appointment or PEQ is also submitted for this Service Request Identifier, as defined in the Technical Glossary."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D207)","v":0},"IDS101Referral","IDS10132","Record rejected - Year And Month Of Symptoms Onset has incorrect data format.","This is the OnsetDate field of the IDS101Referral table. The date format is an7 YYYY-MM."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D208)","v":0},"IDS101Referral","IDS10133","Record rejected - Previous Diagnosed Condition Indicator has incorrect data format.","This is the PrevDiagCondInd field of the IDS101Referral 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!D209)","v":0},"IDS101Referral","IDS10134","Warning - Previous Diagnosed Condition Indicator contains an invalid Previous Diagnosed Condition Indicator.","This is the PrevDiagCondInd field of the IDS101Referral table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D210)","v":0},"IDS101Referral","IDS10135","Record rejected - Discharge From Improving Access To Psychological Therapies Service Reason has incorrect data format.","This is the EndCode field of the IDS101Referral table. The Technical Output Specification shows the values that are acceptable for this field. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D211)","v":0},"IDS101Referral","IDS10136","Warning - Discharge From Improving Access To Psychological Therapies Service Reason contains an invalid Discharge From Improving Access To Psychological Therapies Service Reason.","This is the EndCode field of the IDS101Referral table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D212)","v":0},"IDS101Referral","IDS10137","Warning - Service Discharge Date has been populated but no Discharge From Improving Access To Psychological Therapies Service Reason has been provided.","This is the EndCode field of the IDS101Referral table. If the ServDischDate field has been populated with a date then the EndCode field is expected to be populated with values such as examples 50, 10, 11, 12, 13 etc."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D213)","v":0},"IDS101Referral","IDS10138","Warning - Discharge From Improving Access To Psychological Therapies Service Reason has been populated but no Service Discharge Date has been provided.","This is the ServDischDate field of the IDS101Referral table. It is expected that where a reason has been entered in the EndCode field, that the ServDischDate field should be populated. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D214)","v":0},"IDS101Referral","IDS10139","Record rejected - Service Discharge Date is after the end of the reporting period.","This is the ServDischDate field of the IDS101Referral table. If Service Discharge Date is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D215)","v":0},"IDS101Referral","IDS10140","Record rejected - Referral Request Received Date is before Person Birth Date.","This is the ReferralRequestReceivedDate field of the IDS101Referral table. If Referral Request Received Date is before Person Birth Date (as included in IDS001), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D216)","v":0},"IDS101Referral","IDS10141","Record rejected - Year And Month Of Symptoms Onset is before the Person Birth Date.","This is the OnsetDate field of the IDS101Referral table. If Year And Month Of Symptoms Onset is before Person Birth Date (as included in IDS001), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D217)","v":0},"IDS101Referral","IDS10142","Warning - Year And Month Of Symptoms Onset is not in the specified format of \"YYYY-MM\".","This is the OnsetDate field of the IDS101Referral table. Year And Month Of Symptoms Onset is expected to be submitted in the format \"YYYY-MM\"."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D218)","v":0},"IDS101Referral","IDS10143","Warning - Organisation Identifier (Code of Commissioner) does not have the expected role of “RO98” (CLINICAL_COMMISSIONING_GROUP) in national organisation tables.","This is the OrgIDComm field of the IDS101Referral table. The Code of Commissioner does not have the expected role."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D219)","v":0},"IDS101Referral","IDS10144","IDS10144 - Warning - No valid IDS603 group transmitted for this Service Request Identifier.","This is a warning shown for the IDS101Referral table where there is no matching entry within the IDS603PresentingComplaints table for a ServiceRequestID that is in the IDS101Referral table. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D220)","v":0},"IDS105OnwardReferral","IDS10501","Record rejected - Service Request Identifier is blank","The ServiceRequestId field of the IDS105OnwardReferral table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in IDS101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D221)","v":0},"IDS105OnwardReferral","IDS10502","Record rejected - Service Request Identifier has incorrect data format. ","This is the ServiceRequestId field of the IDS105OnwardReferral table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D222)","v":0},"IDS105OnwardReferral","IDS10503","Record rejected - Onward Referral Date is blank.","This is the OnwardReferDate field of the IDS105OnwardReferral table. This is a mandatory field and cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D223)","v":0},"IDS105OnwardReferral","IDS10504","Record rejected - Onward Referral Date has incorrect data format.","This is the OnwardReferDate field of the IDS105OnwardReferral table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D224)","v":0},"IDS105OnwardReferral","IDS10505","Record rejected - Onward Referral Date is after the Reporting Period End Date.","This is the OnwardReferDate field of the IDS105OnwardReferral 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!D225)","v":0},"IDS105OnwardReferral","IDS10506","Record rejected - Onward Referral Reason has incorrect data format.","This is the OnwardReferReason field of the IDS105OnwardReferral 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!D226)","v":0},"IDS105OnwardReferral","IDS10507","Warning - Onward Referral Reason contains an invalid Onward Referral Reason.","This is the OnwardReferReason field of the IDS105OnwardReferral table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D227)","v":0},"IDS105OnwardReferral","IDS10510","Group rejected - No valid IDS101 group transmitted for this Service Request Identifier.","Record in the IDS105OnwardReferral table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D228)","v":0},"IDS105OnwardReferral","IDS10514","Record Rejected - Onward Referral Time has incorrect data format.","This is the OnwardReferTime field of the IDS105OnwardReferral table. The time format is an8 (HH:MM:SS)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D229)","v":0},"IDS105OnwardReferral","IDS10518","Record rejected - Organisation Identifier (Receiving) has incorrect data format.","This is the OrgIDReceiving field of the IDS105OnwardReferral table. The expected format for this field is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D230)","v":0},"IDS105OnwardReferral","IDS10519","Warning - Organisation Identifier (Receiving) is not for a current live organisation in national tables.","This is the OrgIDReceiving field of the IDS105OnwardReferral table. If Organisation Identifier (Receiving) is not in national tables, a warning will be output. The Data Quality report should indicate which record this refers to."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D231)","v":0},"IDS105OnwardReferral","IDS10520","Group rejected - More than one IDS105 provided for this Service Request Identifier + Onward Referral Date + Onward Referral Time + Onward Referral Reason + Organisation Identifier (Receiving) combination.","Within the IDS105OnwardReferral table, the combination of ServiceRequestId, OnwardReferDate, OnwardReferTime, OnwardReferReason and OvsVisChCat and OrgIDReceiving cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D232)","v":0},"IDS105OnwardReferral","IDS10521","Record rejected - Onward Referral Date is before the Referral Request Received Date.","This is the OnwardReferDate field of the IDS105OnwardReferral 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!D233)","v":0},"IDS105OnwardReferral","IDS10522","Record rejected - Onward Referral Date is before the Reporting Period Start Date.","This is the OnwardReferDate field of the IDS105OnwardReferral table. If Onward Referral Date is populated and is before the Reporting Period Start Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D234)","v":0},"IDS108WaitingTimePauses","IDS10801","Group rejected - No valid IDS101 group transmitted for this Service Request Identifier.","Record in the IDS108WaitingTimePauses table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D235)","v":0},"IDS108WaitingTimePauses","IDS10802","Group rejected - More than one IDS108 provided for this Improving Access To Psychological Therapies Activity Suspension Identifier + Service Request Identifier combination.","Within the IDS108WaitingTimePauses table, the combination of the values for field PauseID and field ServiceRequestId is being repeated. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D236)","v":0},"IDS108WaitingTimePauses","IDS10803","Record rejected - Improving Access To Psychological Therapies Activity Suspension Identifier is blank.","This is the PauseID of the IDS108WaitingTimePauses table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D237)","v":0},"IDS108WaitingTimePauses","IDS10804","Record rejected - Improving Access To Psychological Therapies Activity Suspension Identifier has incorrect data format.","This is the PauseID field of the IDS108WaitingTimePauses table. The expected format is max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D238)","v":0},"IDS108WaitingTimePauses","IDS10805","Record rejected - Service Request Identifier is blank.","The ServiceRequestId field of the IDS108WaitingTimePauses table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in IDS101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D239)","v":0},"IDS108WaitingTimePauses","IDS10806","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the IDS108WaitingTimePauses table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D240)","v":0},"IDS108WaitingTimePauses","IDS10807","Record rejected - Activity Suspension Start Date is blank.","This is the PauseStartDate field of the IDS108WaitingTimePauses table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D241)","v":0},"IDS108WaitingTimePauses","IDS10808","Record rejected - Activity Suspension Start Date has incorrect date format.","This is the PauseStartDate field of the IDS108WaitingTimePauses table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D242)","v":0},"IDS108WaitingTimePauses","IDS10809","Record rejected - Activity Suspension Start Date is after the end of the reporting period.","This is the PauseStartDate field of the IDS108WaitingTimePauses table. If START DATE is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D243)","v":0},"IDS108WaitingTimePauses","IDS10810","Record rejected - Activity Suspension End Date has incorrect date format.","This is the PauseEndDate field of the IDS108WaitingTimePauses table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D244)","v":0},"IDS108WaitingTimePauses","IDS10811","Record rejected - Activity Suspension End Date is before the start of the reporting period.","This is the PauseEndDate field of the IDS108WaitingTimePauses table. If 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!D245)","v":0},"IDS108WaitingTimePauses","IDS10812","Record rejected - Activity Suspension End Date is after the end of the reporting period.","This is the PauseEndDate field of the IDS108WaitingTimePauses table. If 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!D246)","v":0},"IDS108WaitingTimePauses","IDS10813","Record rejected - Activity Suspension End Date is prior to the associated Activity Suspension Start Date.","This is the PauseEndDate field of the IDS108WaitingTimePauses table. This date cannot be before the PauseStartDate field date. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D247)","v":0},"IDS108WaitingTimePauses","IDS10814","Record rejected - Improving Access To Psychological Therapies Activity Suspension Reason has an incorrect data format Improving Access To Psychological Therapies Activity Suspension ","This is the PauseReason field of the IDS108WaitingTimePauses 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 the field is an2. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D248)","v":0},"IDS108WaitingTimePauses","IDS10815","Warning - Improving Access To Psychological Therapies Activity Suspension Reason contains an invalid Improving Access To Psychological Therapies Activity Suspension Reason.","This is the PauseReason field of the IDS108WaitingTimePauses table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D249)","v":0},"IDS108WaitingTimePauses","IDS10816","Record rejected - Activity Suspension Start Date is before Referral Request Received Date.","This is the PauseStartDate field of the IDS108WaitingTimePauses table. If START DATE is before the Referral Request Received Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D250)","v":0},"IDS108WaitingTimePauses","IDS10817","Warning - Improving Access To Psychological Therapies Activity Suspension Reason is blank.","This is the PauseReason field of the IDS108WaitingTimePauses table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D251)","v":0},"IDS201CareContact","IDS20101","Record rejected - Care Contact Identifier is blank.","The CareContactId field of the IDS201CareContact table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D252)","v":0},"IDS201CareContact","IDS20102","Record rejected - Care Contact Identifier has incorrect data format.","This is the CareContactId field of the IDS201CareContact table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D253)","v":0},"IDS201CareContact","IDS20103","Record rejected - Service Request Identifier is blank.","The ServiceRequestId field of the IDS201CareContact table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in the IDS101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D254)","v":0},"IDS201CareContact","IDS20104","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the IDS201CareContact table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D255)","v":0},"IDS201CareContact","IDS20106","Record rejected - Care Contact Date is blank.","This is the CareContDate field of the IDS201CareContact table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D256)","v":0},"IDS201CareContact","IDS20107","Record rejected - Care Contact Date is before Referral Request Received Date.","This is the CareContDate field of the IDS201CareContact table. The Care Contact Date cannot be before the ReferralRequestReceivedDate entry in the IDS101Referral table. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D257)","v":0},"IDS201CareContact","IDS20108","Record rejected - Care Contact Date is after the Reporting Period End Date.","This is the CareContDate field of the IDS201CareContact table. The Care Contact Date cannot be after the Reporting Period End Date of the reporting period. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D258)","v":0},"IDS201CareContact","IDS20109","Record rejected - Care Contact Time has incorrect time format.","This is the CareContTime field of the IDS201CareContact table. The time format is an8 (HH:MM:SS)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D259)","v":0},"IDS201CareContact","IDS20114","Record rejected - Clinical Contact Duration of Care Contact has incorrect data format.","This is the ClinContDurOfCareCont field of the IDS201CareContact table. The expected format of this field is max n4."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D260)","v":0},"IDS201CareContact","IDS20115","Record rejected - Integrated Improving Access to Psychological Therapies Long Term Condition Service Indicator is blank.","This is the IAPTLTCServiceInd field of the IDS201CareContact table. This is a mandatory field and cannot be left blank. The values expected here are Y or N."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D261)","v":0},"IDS201CareContact","IDS20116","Record rejected - Integrated Improving Access to Psychological Therapies Long Term Condition Service Indicator has incorrect data format.","This is the IAPTLTCServiceInd field of the IDS201CareContact table. The expected values here are Y or N. The expected format of this field is an1. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D262)","v":0},"IDS201CareContact","IDS20117","Warning - Integrated Improving Access to Psychological Therapies Long Term Condition Service Indicator contains an invalid Integrated Improving Access to Psychological Therapies Long Term Indicator.","This is the IAPTLTCServiceInd field of the IDS201CareContact table. The expected values here are Y or N. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D263)","v":0},"IDS201CareContact","IDS20119","Record rejected - Consultation Medium Used has incorrect data format.","This is the ConsMediumUsed (ConsMechanism in v2.1) field of the IDS201CareContact 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!D264)","v":0},"IDS201CareContact","IDS20120","Warning - Consultation Medium Used contains an invalid Consultation Medium Used.","This is the ConsMediumUsed (ConsMechanism in v2.1) field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D265)","v":0},"IDS201CareContact","IDS20121","Record rejected - Activity Location Type Code has incorrect data format.","This is the ActLocTypeCode field of the IDS201CareContact 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!D266)","v":0},"IDS201CareContact","IDS20122","Warning - Activity Location Type Code contains an invalid Activity Location Type Code.","This is the ActLocTypeCode field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D267)","v":0},"IDS201CareContact","IDS20125","Record rejected - Care Contact Patient Therapy Mode has incorrect data format.","This is the CareContPatientTherMode field of the IDS201CareContact 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!D268)","v":0},"IDS201CareContact","IDS20126","Warning - Care Contact Patient Therapy Mode contains an invalid Care Contact Patient Therapy Mode.","This is the CareContPatientTherMode field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D269)","v":0},"IDS201CareContact","IDS20127","Record rejected - Attended or Did Not Attend Code has incorrect data format.","This is the AttendOrDNACode field of the IDS201CareContact 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!D270)","v":0},"IDS201CareContact","IDS20128","Record rejected - Attended or Did Not Attend Code contains an invalid Attended or Did Not Attend Code.","This is the AttendOrDNACode field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D271)","v":0},"IDS201CareContact","IDS20142","Group rejected - No valid IDS101 group transmitted for this Service Request Identifier.","Record in the IDS201CareContact table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D272)","v":0},"IDS201CareContact","IDS20143","Group rejected - More than one IDS201 provided for this Care Contact Identifier.","This is the CareContactId field of the IDS201CareContact table. The same value cannot be repeated for this field, it is unique IDs only."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D273)","v":0},"IDS201CareContact","IDS20146","Record rejected - Organisation Identifier (Code of Commissioner) has incorrect data format.","This is the OrgIDComm field of the IDS201CareContact table. The expected format for this field is min an3 max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D274)","v":0},"IDS201CareContact","IDS20147","Warning - Organisation Identifier (Code of Commissioner) provided is not for a current live organisation in National tables.","This is the OrgIDComm field of the IDS201CareContact table. If Organisation Identifier (Code of Commissioner) is not in national tables a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D275)","v":0},"IDS201CareContact","IDS20148","Record rejected - Organisation Site Identifier (of Treatment) has incorrect data format.","This is the SiteIDOfTreat field of the IDS201CareContact table. ORGANISATION SITE IDENTIFIER (OF TREATMENT) is the ORGANISATION IDENTIFIER of the Organisation Site where the PATIENT was treated. Expecting between 5 and 9 characters. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D276)","v":0},"IDS201CareContact","IDS20149","Warning - Organisation Site Identifier (of Treatment) is not for a current live organisation in national tables.","This is the SiteIDOfTreat field of the IDS201CareContact table. If Organisation Site Identifier (Of Treatment) is not in national tables, a warning will be output."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D277)","v":0},"IDS201CareContact","IDS20150","Record rejected - Planned Care Contact Indicator has incorrect data format.","This is the PlannedCareContIndicator field of the IDS201CareContact 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 an1."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D278)","v":0},"IDS201CareContact","IDS20151","Warning - Planned Care Contact Indicator contains an invalid Planned Care Contact Indicator.","This is the PlannedCareContIndicator field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D279)","v":0},"IDS201CareContact","IDS20152","Record rejected - Appointment Slot Short Notice Cancellation Indicator has incorrect data format.","This is the Cancellation field of the IDS201CareContact 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!D280)","v":0},"IDS201CareContact","IDS20153","Warning - Appointment Slot Short Notice Cancellation Indicator contains an invalid Appointment Slot Short Notice Cancellation Indicator.","This is the Cancellation field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D281)","v":0},"IDS201CareContact","IDS20154","Record rejected - Appointment Type is blank.","This is the AppType field of the IDS201CareContact table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D282)","v":0},"IDS201CareContact","IDS20155","Record rejected - Appointment Type has incorrect data format.","This is the AppType field of the IDS201CareContact 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!D283)","v":0},"IDS201CareContact","IDS20156","Record rejected - Appointment Type contains an invalid Appointment Type.","This is the AppType field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D284)","v":0},"IDS201CareContact","IDS20157","Record rejected - Internet Enabled Therapy Programme has an incorrect data format.","This is the IntEnabledTherProg field of the IDS201CareContact table. The expected format of this field is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D285)","v":0},"IDS201CareContact","IDS20158","Record rejected - Number Of Group Therapy Participants has an incorrect data format.","This is the NumGroupTherParticipants field of the IDS201CareContact table. The expected format of this field is max n3."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D286)","v":0},"IDS201CareContact","IDS20159","Record rejected - Number Of Group Therapy Facilitators has an incorrect data format.","This is the NumGroupTherFacilitators field of the IDS201CareContact table. The expected format of this field is max n2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D287)","v":0},"IDS201CareContact","IDS20160","Record rejected - Psychotropic Medication Usage Indication Code has incorrect data format.","This is the PsychMed of the IDS201CareContact 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 max n2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D288)","v":0},"IDS201CareContact","IDS20161","Warning - Psychotropic Medication Usage Indication Code contains an invalid Psychotropic Medication Usage Indication Code.","This is the PsychMed of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D289)","v":0},"IDS201CareContact","IDS20162","Record rejected - Language Code (Treatment) has an incorrect data format.","This is the LanguageCodeTreat field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field. The expected format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D290)","v":0},"IDS201CareContact","IDS20163","Warning - Language Code (Treatment) contains an invalid Language Code (Treatment).","This is the LanguageCodeTreat field of the IDS201CareContact 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."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D291)","v":0},"IDS201CareContact","IDS20164"," Record rejected - Interpreter Present At Care Contact Indication Code has an incorrect data format.","This is the InterpreterPresentInd field of the IDS201CareContact 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!D292)","v":0},"IDS201CareContact","IDS20165","Warning - Interpreter Present At Care Contact Indication Code contains an invalid Interpreter Present At Care Contact Indication Code.","This is the InterpreterPresentInd field of the IDS201CareContact table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D293)","v":0},"IDS201CareContact","IDS20166","Warning - Attended or Did Not Attend Code is populated and equals '2' and Appointment Slot Short Notice Cancellation Indicator is blank.","This is the Cancellation field of the IDS201CareContact table. Where the AttendOrDNACode field is populated with \"2\" then the Cancellation field is expected to be populated with the value of \"Y\" or \"N\". "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D294)","v":0},"IDS201CareContact","IDS20167","Warning - Attended or Did Not Attend Code is populated and does not equal '2' and Appointment Slot Short Notice Cancellation Indicator is populated.","This is the Cancellation field of the IDS201CareContact table. It is only where the AttendOrDNACode value is 2 where the Cancellation field is to be populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D295)","v":0},"IDS201CareContact","IDS20168","Warning - More than one IDS201 provided for this Service Request Identifier + Care Contact Date + Care Contact Time + Attended or Did Not Attend Code of '5' or '6' combination.","Within the IDS201CareContact table, the combination of Service Request Identifier + Care Contact Date + Care Contact Time + Attended or Did Not Attend Code of '5' or '6'  appears to being repeated for these records. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D296)","v":0},"IDS201CareContact","IDS20169","Warning - No valid IDS202 group transmitted for this Care Contact Identifier where the Attended or Did Not Attend Code of '5' or '6' has been submitted.","There is no matching entry (based on the CareContactId field of the IDS201CareContact table) in the IDS202CareActivity table for these attended appointments. It could be that the IDS202CareActivity records have been rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D297)","v":0},"IDS201CareContact","IDS20170","Record rejected - Care Contact Date is before the Reporting Period Start Date.","This is the CareContDate field of the IDS201CareContact table. The Care Contact Date cannot be before the Reporting Period Start Date of the reporting period. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D298)","v":0},"IDS201CareContact","IDS20171","Record rejected - Care Contact Date is before Referral Request Received Date.","This is the CareContDate field of the IDS201CareContact table. If Care Contact Date is before the Referral Request Received Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D299)","v":0},"IDS201CareContact","IDS20172","Warning - Attended or Did Not Attend Code has been populated with a value of '2', '3', '4' or '7' but Planned Care Contact Indicator contains a value of 'N'.","This is the AttendOrDNACode field of the IDS201CareContact table. The value entered in this field does fit with the value entered in the PlannedCareContIndicator field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D300)","v":0},"IDS201CareContact","IDS20173","Warning - No valid IDS202 group transmitted for this Care Contact Identifier where the Planned Care Contact Indicator contains a value of 'N'.","This is a warning that there is no entry in the IDS202CareActivity table for the CareContactId value entered in the IDS201CareContact table.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D301)","v":0},"IDS201CareContact","IDS20174","Warning - Organisation Identifier (Code of Commissioner) does not have the expected role of “RO98” (CLINICAL_COMMISSIONING_GROUP) in national organisation tables. ","This is the OrgIDComm field of the IDS201CareContact table. The Code of Commissioner does not have the expected role."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D302)","v":0},"IDS201CareContact","IDS20175","Warning - Organisation Site Identifier (of Treatment) does not contain one of the expected roles: \"RO198\" (NHS Trust site), \"RO108\" (Care Trust site), “RO176” (Independent Sector Healthcare Providers site) or \"RO76\" (GP Practice) in national organisation tables.","This is the SiteIDOfTreat field of the IDS201CareContact table. The Organisation Site Identifier does not have the expected role."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D303)","v":0},"IDS201CareContact","IDS20176","IDS20176 - Warning - Organisation Site Identifier (of Treatment) does not contain one of the expected roles: \"RO198\" (NHS Trust site), \"RO108\" (Care Trust site), “RO176” (Independent Sector Healthcare Providers site) or \"RO177\" (GP Practice) in national organisation tables.","This is the SiteIDOfTreat field of the IDS201CareContact table. If Organisation Site Identifier (of Treatment) does not contain one of the expected roles: \"RO198\" (NHS Trust site), \"RO108\" (Care Trust site), “RO176” (Independent Sector Healthcare Providers site) or \"RO76\" (GP Practice) in national organisation tables, a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D304)","v":0},"IDS202CareActivity","IDS20201","Record rejected - Care Activity Identifier is blank.","The CareActId field of the IDS202CareActivity table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D305)","v":0},"IDS202CareActivity","IDS20202","Record rejected - Care Activity Identifier has incorrect data format.","This is the CareActId field of the IDS202CareActivity table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D306)","v":0},"IDS202CareActivity","IDS20203","Record rejected - Care Contact Identifier is blank.","The CareContactId field of the IDS202CareActivity table is mandatory and so cannot be left blank. It must match to the CareContactId field in IDS201CareContact table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D307)","v":0},"IDS202CareActivity","IDS20204","Record rejected - Care Contact Identifier has incorrect data format.","This is the CareContactId field of the IDS202CareActivity table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D308)","v":0},"IDS202CareActivity","IDS20205","Record rejected - Care Personnel Local Identifier has incorrect data format.","This is the CarePersLocalId field of the IDS202CareActivity table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D309)","v":0},"IDS202CareActivity","IDS20206","Record rejected - Clinical Contact Duration of Care Activity has incorrect data format.","This is the ClinContactDurOfCareAct field of the IDS202CareActivity table. The expected format for this field is max n4."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D310)","v":0},"IDS202CareActivity","IDS20212","Record rejected - Finding Scheme In Use has incorrect data format.","This is the FindSchemeInUse field of the IDS202CareActivity 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!D311)","v":0},"IDS202CareActivity","IDS20213","Warning - Finding Scheme In Use contains an invalid Finding Scheme In Use.","This is the FindSchemeInUse field of the IDS202CareActivity table. The values expected for this field are 01 or 04. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D312)","v":0},"IDS202CareActivity","IDS20214","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 IDS202CareActivity table. If the CodeFind is populated then the FindSchemeInUse field also needs to be populated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D313)","v":0},"IDS202CareActivity","IDS20215","Record rejected - Coded Finding (Coded Clinical entry) has incorrect data format.","This is CodeFind field of the IDS202CareActivity table. The field is excected to be be populated with a value that has a length between 4 and 18 characters.   "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D314)","v":0},"IDS202CareActivity","IDS20216","Warning - Finding Scheme In Use is populated, but Coded Finding (Coded Clinical entry) is blank.","This is the CodeFind field of the IDS202CareActivity table. Where the FindSchemeInUse is populated then a value is expected for the CodeFind field. If there is nothing to be populated to the CodeFind field then leave the FindSchemeInUse field as blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D315)","v":0},"IDS202CareActivity","IDS20222","Record rejected - Observation Value has incorrect data format.","This is the ObsValue field of the IDS202CareActivity table. The expected format for this field is max an10"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D316)","v":0},"IDS202CareActivity","IDS20223","Record rejected - UCUM Unit of Measurement has incorrect data format.","This is the UnitMeasure field of the IDS202CareActivity table. The expected format for this field is max an10"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D317)","v":0},"IDS202CareActivity","IDS20224","Group rejected - No valid IDS201 group transmitted for this Care Contact Identifier.","Record in the IDS202CareActivity table rejected because there is no corresponding record in the IDS201CareContact table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS201CareContact) has been rejected due to a validation error. Reason 2: There is no record with a corresponding CareContactId in the linked table (IDS201CareContact)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D318)","v":0},"IDS202CareActivity","IDS20225","Group rejected - More than one IDS202 provided for this Care Activity Identifier.","This is the CareActId field of the IDS202CareActivity table. This is a unique ID for the Care Activity and is not expected to be repeated and appear in this table more than once. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D319)","v":0},"IDS202CareActivity","IDS20226","Warning - OBSERVATION VALUE is populated and the UCUM UNIT OF MEASUREMENT is blank.","This is the UnitMeasure field of the IDS202CareActivity table. If Observation Value is populated and UCUM Unit of Measure is blank, then a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D320)","v":0},"IDS202CareActivity","IDS20228","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 IDS202CareActivity 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!D321)","v":0},"IDS202CareActivity","IDS20230","Record rejected - Coded Procedure and Procedure Status (SNOMED CT) has failed SNOMED CT checks.","This is the CodeProcAndProcStatus field of the IDS202CareActivity table. The SNOMED value entered has not been recognised."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D322)","v":0},"IDS202CareActivity","IDS20231","Record rejected - Coded Observation (SNOMED CT) has failed SNOMED CT checks.","This is the CodeObs field of the IDS202CareActivity table. The value entered does not match to a SNOMED value. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D323)","v":0},"IDS205InternetTherLog","IDS20501","Group rejected - No valid IDS101 group transmitted for this Service Request Identifier.","Record in the IDS205InternetTherLog table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D324)","v":0},"IDS205InternetTherLog","IDS20502","Record rejected - Service Request Identifier is blank.","The ServiceRequestId field of the IDS205InternetTherLog table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in IDS101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D325)","v":0},"IDS205InternetTherLog","IDS20503","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the IDS205InternetTherLog table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D326)","v":0},"IDS205InternetTherLog","IDS20504","Record rejected - Start Date (Internet Enabled Therapy Activity Log) is blank.","This is the StartDateIntEnabledTherLog field of the IDS205InternetTherLog table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D327)","v":0},"IDS205InternetTherLog","IDS20505","Record rejected - Start Date (Internet Enabled Therapy Activity Log) has incorrect date format.","This is the StartDateIntEnabledTherLog field of the IDS205InternetTherLog table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D328)","v":0},"IDS205InternetTherLog","IDS20506","Record rejected - Start Date (Internet Enabled Therapy Activity Log) is after the Reporting Period End Date.","This is the StartDateIntEnabledTherLog field of the IDS205InternetTherLog table. If START DATE is after the Reporting Period End Date, the record will be rejected.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D329)","v":0},"IDS205InternetTherLog","IDS20507","Record rejected - End Date (Internet Enabled Therapy Activity Log) is blank.","This is the EndDateIntEnabledTherLog field of the IDS205InternetTherLog table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D330)","v":0},"IDS205InternetTherLog","IDS20508","Record rejected - End Date (Internet Enabled Therapy Activity Log) has incorrect date format.","This is the EndDateIntEnabledTherLog field of the IDS205InternetTherLog table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D331)","v":0},"IDS205InternetTherLog","IDS20509","Record rejected - End Date (Internet Enabled Therapy Activity Log) is before the start of the reporting period.","This is the EndDateIntEnabledTherLog field of the IDS205InternetTherLog table. If 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!D332)","v":0},"IDS205InternetTherLog","IDS20510","Record rejected - End Date (Internet Enabled Therapy Activity Log) is after the end of the reporting period.","This is the EndDateIntEnabledTherLog field of the IDS205InternetTherLog table. If 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!D333)","v":0},"IDS205InternetTherLog","IDS20511","Record rejected - End Date (Internet Enabled Therapy Activity Log) is prior to the associated Start Date (Internet Enabled Therapy Activity Log).","This is the EndDateIntEnabledTherLog field of the IDS205InternetTherLog table. If 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!D334)","v":0},"IDS205InternetTherLog","IDS20512","Record rejected - Internet Enabled Therapy Programme is blank.","This is the IntEnabledTherProg field of the IDS205InternetTherLog table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D335)","v":0},"IDS205InternetTherLog","IDS20513","Record rejected - Internet Enabled Therapy Programme has an incorrect data format.","This is the IntEnabledTherProg field of the IDS205InternetTherLog table. The expected format of this field is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D336)","v":0},"IDS205InternetTherLog","IDS20514","Record rejected - Duration Of Internet Enabled Therapy Improving Access To Psychological Therapies Care Professional Clinical Time is blank.","This is the DurationIntEnabledTher field of the IDS205InternetTherLog table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D337)","v":0},"IDS205InternetTherLog","IDS20515","Record rejected - Duration Of Internet Enabled Therapy Improving Access To Psychological Therapies Care Professional Clinical Time has incorrect data format.","This is the DurationIntEnabledTher field of the IDS205InternetTherLog table. The expected format of this field is max n4."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D338)","v":0},"IDS205InternetTherLog","IDS20516","Record rejected - Care Personnel Local Identifier has incorrect data format","This is the CarePersLocalId field of the IDS205InternetTherLog table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D339)","v":0},"IDS205InternetTherLog","IDS20517","Record rejected - Internet Enabled Therapy Integrated Software Engine Used Indicator has incorrect data format.","This is the IntegratedSoftwareInd field of the IDS205InternetTherLog 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},"IDS205InternetTherLog","IDS20518","Warning - Internet Enabled Therapy Integrated Software Engine Used Indicator contains an invalid Internet Enabled Therapy Integrated Software Engine Used Indicator.","This is the IntegratedSoftwareInd field of the IDS205InternetTherLog table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D341)","v":0},"IDS205InternetTherLog","IDS20519","Warning - More than one IDS205 for this Service Request Identifier + Start Date (Internet Enabled Therapy Activity Log) + End Date (Internet Enabled Therapy Activity Log) + Internet Enabled Therapy Programme + Duration Of Internet Enabled Therapy Improving Access To Psychological Therapies Care Professional Clinical Time + Care Personnel Local Identifier combination.","Within the IDS205InternetTherLog table, the combination of fields ServiceRequestId, StartDateIntEnabledTherLog, EndDateIntEnabledTherLog, IntEnabledTherProg, DurationIntEnabledTher and CarePersLocalId cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D342)","v":0},"IDS205InternetTherLog","IDS20520","Record rejected - Start Date (Internet Enabled Therapy Activity Log) is before the Referral Request Received Date.","This is the StartDateIntEnabledTherLog field of the IDS205InternetTherLog table. If START DATE is before the Referral Request Received Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D343)","v":0},"IDS601MedHistPrevDiag","IDS60101","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the IDS601MedHistPrevDiag table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D344)","v":0},"IDS601MedHistPrevDiag","IDS60102","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS601MedHistPrevDiag table and can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D345)","v":0},"IDS601MedHistPrevDiag","IDS60103","Record rejected - Diagnosis Scheme In Use (Mental Health) is blank.","This is the DiagSchemeInUse field of the IDS601MedHistPrevDiag table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D346)","v":0},"IDS601MedHistPrevDiag","IDS60104","Record rejected - Diagnosis Scheme In Use (Mental Health) has incorrect data format.","This is the DiagSchemeInUse field of the IDS601MedHistPrevDiag 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!D347)","v":0},"IDS601MedHistPrevDiag","IDS60105","Warning - Diagnosis Scheme In Use (Mental Health) contains an invalid Diagnosis Scheme In Use ","This is the DiagSchemeInUse field of the IDS601MedHistPrevDiag table. The Technical Output Specification shows the values that are acceptable for this field. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D348)","v":0},"IDS601MedHistPrevDiag","IDS60106","Record rejected - Previous Diagnosis (Coded Clinical Entry) is blank.","This is the PrevDiag field of the IDS601MedHistPrevDiag table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D349)","v":0},"IDS601MedHistPrevDiag","IDS60107","Record rejected - Previous Diagnosis (Coded Clinical Entry) has incorrect data format.","This is the PrevDiag field of the IDS601MedHistPrevDiag table. The expected format for this field is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D350)","v":0},"IDS601MedHistPrevDiag","IDS60108","Record rejected - Coded Diagnosis Timestamp has incorrect data format.","This is the DiagDate field of the IDS601MedHistPrevDiag table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D351)","v":0},"IDS601MedHistPrevDiag","IDS60109","Record rejected - Coded Diagnosis Timestamp is after the end date of the reporting period.","This is the DiagDate field of the IDS601MedHistPrevDiag table. The date cannot be after the end date of the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D352)","v":0},"IDS601MedHistPrevDiag","IDS60110","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS601MedHistPrevDiag table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D353)","v":0},"IDS601MedHistPrevDiag","IDS60111","Group rejected - More than one IDS601 provided for this Local Patient Identifier (Extended) + Previous Diagnosis (Coded Clinical Entry) + Coded Diagnosis Timestamp combination.","Within the IDS601MedHistPrevDiag table, the combination of LocalPatientId, LongTermCondition and CodedDiagTimestamp cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D354)","v":0},"IDS601MedHistPrevDiag","IDS60112","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 IDS601MedHistPrevDiag 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!D355)","v":0},"IDS601MedHistPrevDiag","IDS60113","IDS60113 - Group rejected - More than one IDS601 provided for this Local Patient Identifier + Previous Diagnosis combination where Diagnosis Date is null.","Within the IDS601MedHistPrevDiag table, the combination of LocalPatientId and PrevDiag cannot be repeated where the DiagDate field is blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D356)","v":0},"IDS602LongTermCondition","IDS60201","Group rejected - No valid IDS101 group transmitted for this Service Request Identifier.","Record in the IDS602LongTermCondition table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D357)","v":0},"IDS602LongTermCondition","IDS60202","Record rejected - Service Request Identifier is blank.","The ServiceRequestId field of the IDS602LongTermCondition table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in IDS101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D358)","v":0},"IDS602LongTermCondition","IDS60203","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the IDS602LongTermCondition table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D359)","v":0},"IDS602LongTermCondition","IDS60204","Record rejected - Finding Scheme In Use is blank.","This is the FindSchemeInUse field of the IDS602LongTermCondition table. This is a mandatory field and cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D360)","v":0},"IDS602LongTermCondition","IDS60205","Record rejected - Finding Scheme In Use has incorrect data format.","This is the FindSchemeInUse field of the IDS602LongTermCondition table. The values expected for this field are 01, 04. Please make sure the leading zero is shown. The expected format is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D361)","v":0},"IDS602LongTermCondition","IDS60206","Warning - Finding Scheme In Use contains an invalid Finding Scheme In Use.","This is the FindSchemeInUse field of the IDS602LongTermCondition table. The values expected for this field are 01 or 04. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D362)","v":0},"IDS602LongTermCondition","IDS60207","Record rejected - Long Term Physical Health Condition (Coded Clinical Entry) is blank.","This is the LongTermCondition field of the IDS602LongTermCondition table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D363)","v":0},"IDS602LongTermCondition","IDS60208","Record rejected - Long Term Physical Health Condition (Coded Clinical Entry) has incorrect data format.","This is the LongTermCondition field of the IDS602LongTermCondition table. The expected format for this field is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D364)","v":0},"IDS602LongTermCondition","IDS60209","Record rejected - Long Term Physical Health Condition (Coded Clinical Entry) format does not match expected format from selected Finding Scheme In Use.","This is the LongTermCondition field of the IDS602LongTermCondition table. If Long Term Physical Health Condition (Coded Clinical Entry) format does not match expected format for Finding Scheme In Use, the record will be rejected. So if the FindSchemeInUse field has a value of 01 then an ICT-10 code is expected for this field and if the FindSchemeInUse value is 04 then a SNOMED code is expected for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D365)","v":0},"IDS602LongTermCondition","IDS60210","Group rejected - More than one IDS602 provided for this Service Request Identifier + Long Term Physical Health Condition (Coded Clinical Entry) combination.","Within the IDS602LongTermCondition table, the combination of ServiceRequestId and PrevDiag cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D366)","v":0},"IDS603PresentingComplaints","IDS60301","Group rejected - No valid IDS101 group transmitted for this Service Request Identifier.","Record in the IDS603PresentingComplaints table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D367)","v":0},"IDS603PresentingComplaints","IDS60302","Group rejected - More than one IDS603 provided for this Service Request Identifier + Presenting Complaint Recorded Date + Presenting Complaint (Coded Clinical Entry) combination.","Within the IDS603PresentingComplaints table, the combination of ServiceRequestId and PRESENTING COMPLAINT (CODED CLINICAL ENTRY) and PRESENTING COMPLAINT RECORDED DATE cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D368)","v":0},"IDS603PresentingComplaints","IDS60303","Record rejected - Service Request Identifier is blank.","The ServiceRequestId field of the IDS603PresentingComplaints table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in IDS101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D369)","v":0},"IDS603PresentingComplaints","IDS60304","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the IDS603PresentingComplaints table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D370)","v":0},"IDS603PresentingComplaints","IDS60305","Record rejected - Finding Scheme In Use is blank.","This is the FindSchemeInUse field of the IDS603PresentingComplaints table. This is a mandatory field and cannot be left blank.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D371)","v":0},"IDS603PresentingComplaints","IDS60306","Record rejected - Finding Scheme In Use has incorrect data format.","This is the FindSchemeInUse field of the IDS603PresentingComplaints table. Values expected are 01 or 04. Please make sure the leading zero is shown. The expected format for this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D372)","v":0},"IDS603PresentingComplaints","IDS60307","Warning - Finding Scheme In Use contains an invalid Finding Scheme In Use.","This is the FindSchemeInUse field of the IDS603PresentingComplaints table. Values expected are 01 or 04. Please make sure the leading zero is shown."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D373)","v":0},"IDS603PresentingComplaints","IDS60308","Record rejected - Presenting Complaint (Coded Clinical Entry) is blank.","This is the PresComp field of the IDS603PresentingComplaints table. This is a mandatory field and cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D374)","v":0},"IDS603PresentingComplaints","IDS60309","Record rejected - Presenting Complaint (Coded Clinical Entry) has incorrect data format.","This is the PresComp field of the IDS603PresentingComplaints table. The expected format for this field is min an4 max an18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D375)","v":0},"IDS603PresentingComplaints","IDS60310","Record rejected - Presenting Complaint (Coded Clinical Entry) format does not match expected format from selected Finding Scheme In Use.","This is the PresComp field of the IDS603PresentingComplaints table. If Presenting Complaint (Coded Clinical Entry) format does not match expected format for Finding Scheme In Use, the record will be rejected. So if the FindSchemeInUse field has a value of 01 then an ICT-10 code is expected for this field and if the FindSchemeInUse value is 04 then a SNOMED code is expected for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D376)","v":0},"IDS603PresentingComplaints","IDS60311","Record rejected - Presenting Complaint Coding Significance has incorrect data format.","This is the PresCompCodSig field of the IDS603PresentingComplaints 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!D377)","v":0},"IDS603PresentingComplaints","IDS60312","Warning - Presenting Complaint Coding Significance contains an invalid Presenting Complaint Coding Significance.","This is the PresCompCodSig field of the IDS603PresentingComplaints table. The values expected for this field are 1 or 2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D378)","v":0},"IDS603PresentingComplaints","IDS60313","Record rejected - Presenting Complaint Recorded Date has incorrect data format.","This is the PresCompDate field of the IDS603PresentingComplaints table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D379)","v":0},"IDS603PresentingComplaints","IDS60314","Record rejected - Presenting Complaint Recorded Date is after the end of the reporting period.","The PresCompDate field of the IDS603PresentingComplaints table cannot be populated with a date after the reporting period."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D380)","v":0},"IDS603PresentingComplaints","IDS60315","Warning - Presenting Complaint Coding Significance is blank.","This is the PresCompCodSig field of the IDS603PresentingComplaints table. The value 1 or 2 is expected here."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D381)","v":0},"IDS603PresentingComplaints","IDS60316","Record rejected - Presenting Complaint Recorded Date is before Person Birth Date.","This is the PresCompDate field of the IDS603PresentingComplaints table. If Presenting Complaint Recorded Date is before the person's Person Birth Date (as included in the IDS001MPI), the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D382)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60601","Record rejected - Service Request Identifier is blank.","The ServiceRequestId field of the IDS606CodedScoreAssessmentRefer table is mandatory and so cannot be left blank. It must match to the ServiceRequestId field in IDS101Referral table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D383)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60602","Record rejected - Service Request Identifier has incorrect data format.","This is the ServiceRequestId field of the IDS606CodedScoreAssessmentRefer table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D384)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60603","Record rejected - Coded Assessment Tool Type (SNOMED CT) is blank.","This is the CodedAssToolType field of the IDS606CodedScoreAssessmentRefer table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D385)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60604","Record rejected - Coded Assessment Tool Type (SNOMED CT) has incorrect data format.","This is the CodedAssToolType field of the IDS606CodedScoreAssessmentRefer table. A SNOMED code is expected here, value entered could not be matched to SNOMED."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D386)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60605","Record rejected - Person Score is blank.","This is the PersScore field of the IDS606CodedScoreAssessmentRefer table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D387)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60606","Record rejected - Person Score has incorrect data format.","This is the PersScore field of the IDS606CodedScoreAssessmentRefer table. The expected format for this is max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D388)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60607","Warning - Person Score contains an invalid Person Score for the Coded Assessment Tool Type.","This is the PersScore field of the IDS606CodedScoreAssessmentRefer table. The score entered into the PersScore field does not match to the expected scores for the SNOMED code entered in the CodedAssToolType field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D389)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60608","Record rejected - Assessment Tool Completion Date is blank.","This is the AssToolCompDate field of the IDS606CodedScoreAssessmentRefer table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D390)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60609","Record rejected - Assessment Tool Completion Date has incorrect date format.","This is the AssToolCompDate field of the IDS606CodedScoreAssessmentRefer table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D391)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60610","Record rejected - Assessment Tool Completion Date is after the Reporting Period End Date.","This is the AssToolCompDate field of the IDS606CodedScoreAssessmentRefer table. If ASSESSMENT TOOL COMPLETION DATE is populated and after the reporting period end date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D392)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60612","Group rejected - No valid IDS101 provided for this Service Request Identifier.","Record in the IDS606CodedScoreAssessmentRefer table rejected because there is no corresponding record in the IDS101Referral table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS101Referral) has been rejected due to a validation error. Reason 2: There is no record with a corresponding ServiceRequestId in the linked table (IDS101Referral)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D393)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60613","Record rejected - Coded Assessment Tool Type (SNOMED CT) not in reference table.","This is the CodedAssToolType field of the IDS606CodedScoreAssessmentRefer table. A SNOMED code is expected here and values entered could not be matched to SNOMED."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D394)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60614","Record rejected - Assessment Tool Completion Time has incorrect data format.","This is the AssToolCompTime field of the IDS606CodedScoreAssessmentRefer table. The time format is an8 (HH:MM:SS)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D395)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60615","Record rejected - Person Score has incorrect value format for the Coded Assessment Tool Type.","This is the PersScore field of the IDS606CodedScoreAssessmentRefer table. The expected format for this field is max an5. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D396)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60616","Group rejected - More than one IDS606 provided for this Service Request Identifier + Assessment Tool Completion Date + Assessment Tool Completion Time + Coded Assessment Tool Type (SNOMED CT) combination.","Within the IDS606CodedScoreAssessmentRefer table, the combination of these fields cannot be repeated. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D397)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60617","Record rejected - Assessment Tool Completion Date is before Referral Request Received Date.","This is the AssToolCompDate field of the IDS606CodedScoreAssessmentRefer table. If Assessment Tool Completion Date is before the Referral Request Received Date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D398)","v":0},"IDS606CodedScoreAssessmentRefer","IDS60618","Record rejected - Assessment Tool Completion Date is before the Reporting Period Start Date.","This is the AssToolCompDate field of the IDS606CodedScoreAssessmentRefer table. If ASSESSMENT TOOL COMPLETION DATE is populated and before the reporting period start date, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D399)","v":0},"IDS607CodedScoreAssessmentAct","IDS60701","Record rejected - Care Activity Identifier is blank.","The CareActId field of the IDS607CodedScoreAssessmentAct table is mandatory and so cannot be left blank. It must match to the CareActId field in IDS202CareActivity table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D400)","v":0},"IDS607CodedScoreAssessmentAct","IDS60702","Record rejected - Care Activity Identifier has incorrect data format.","This is the CareActId field of the IDS607CodedScoreAssessmentAct table. The expected format is max an20."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D401)","v":0},"IDS607CodedScoreAssessmentAct","IDS60703","Record rejected - Coded Assessment Tool Type (SNOMED CT) is blank.","This is the CodedAssToolType field of the IDS607CodedScoreAssessmentAct table. This is a mandatory field and it cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D402)","v":0},"IDS607CodedScoreAssessmentAct","IDS60704","Record rejected - Coded Assessment Tool Type (SNOMED CT) has incorrect data format.","This is the CodedAssToolType field of the IDS607CodedScoreAssessmentAct table. If Coded Assessment Tool Type (SNOMED CT) is not in \"IAPT Assessment Scale Observables\" subset reference table, the record will be rejected. The expected format for this field is min n6 max n18."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D403)","v":0},"IDS607CodedScoreAssessmentAct","IDS60705","Record rejected - Person Score is blank.","This is the PersScore field of the IDS607CodedScoreAssessmentAct table. This field is mandatory and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D404)","v":0},"IDS607CodedScoreAssessmentAct","IDS60706","Record rejected - Person Score has incorrect data format.","This is the PersScore field of the IDS607CodedScoreAssessmentAct table. The expected format is max an5."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D405)","v":0},"IDS607CodedScoreAssessmentAct","IDS60707","Warning - Person Score contains an invalid Person Score.","This is the PersScore field of the IDS607CodedScoreAssessmentAct table. The ROM Mapping tab of the Technical Output Specification contains the range of values expected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D406)","v":0},"IDS607CodedScoreAssessmentAct","IDS60708","Group rejected - No valid IDS202 group transmitted for this Care Activity Identifier.","Record in the IDS607CodedScoreAssessmentAct table rejected because there is no corresponding record in the IDS202CareActivity table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS202CareActivity) has been rejected due to a validation error. Reason 2: There is no record with a corresponding CareActId in the linked table (IDS202CareActivity)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D407)","v":0},"IDS607CodedScoreAssessmentAct","IDS60709","Group rejected - More than one IDS607 provided for this Care Activity Identifier + Coded Assessment Tool Type (SNOMED CT) combination.","Within the IDS607CodedScoreAssessmentAct table, the combination of CareActId and CodedAssToolType cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D408)","v":0},"IDS607CodedScoreAssessmentAct","IDS60710","Record rejected - Coded Assessment Tool Type (SNOMED CT) not in reference table.","This is the CodedAssToolType field of the IDS607CodedScoreAssessmentAct table. A SNOMED code is expected here, values entered could not be matched to SNOMED."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D409)","v":0},"IDS607CodedScoreAssessmentAct","IDS60711","Record rejected - Person Score has incorrect value format for the Coded Assessment Tool Type.","This is the PersScore field of the IDS607CodedScoreAssessmentAct table. The ROM Mapping tab of the Technical Output Specification contains the range of values expected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D410)","v":0},"IDS803CareCluster","IDS80301","Group rejected - No valid IDS001 group transmitted for this Local Patient Identifier (Extended).","Record in the IDS803CareCluster table rejected because there is no corresponding record in the IDS001MPI table. There are two possible reasons why this message is presented. Reason 1: The corresponding record in the linked table (IDS001MPI) has been rejected due to a validation error. Reason 2: There is no record with a corresponding LocalPatientId in the linked table (IDS001MPI)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D411)","v":0},"IDS803CareCluster","IDS80302","Record rejected - Local Patient Identifier (Extended) is blank.","The LocalPatientId field of the IDS803CareCluster table is mandatory and so cannot be left blank. It must match to the LocalPatientId field in IDS001MPI table."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D412)","v":0},"IDS803CareCluster","IDS80303","Record rejected - Local Patient Identifier (Extended) has an incorrect data format.","This is the LocalPatientId field of the IDS803CareCluster table and can accept up to 20 characters."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D413)","v":0},"IDS803CareCluster","IDS80304","Warning - Start Date (Care Cluster Assignment Period) is blank.","This is the StartDateCareClust field of the IDS803CareCluster table. This date should be entered where it is available. Although this is shown as a mandatory field, presently that is not being enforced as this is a new requirement for IAPT v2.0 and some organisations may be using clusters for which they did not collect this date. Switching this to enforce that mandatory rule is likely happen in the future when enough time has been given to allow all organisations to start collecting this information. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D414)","v":0},"IDS803CareCluster","IDS80305","Record rejected - Start Date (Care Cluster Assignment Period) has incorrect data format.","This is the StartDateCareClust field of the IDS803CareCluster table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D415)","v":0},"IDS803CareCluster","IDS80306","Record rejected - Start Date (Care Cluster Assignment Period) is after the end of the reporting period.","This is the StartDateCareClust field of the IDS803CareCluster table. If START DATE is after the end of the reporting period, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D416)","v":0},"IDS803CareCluster","IDS80307","Record rejected - Start Time (Care Cluster Assignment Period) has incorrect data format.","This is the StartTimeCareClust field of the IDS803CareCluster table. The time format is an8 (HH:MM:SS)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D417)","v":0},"IDS803CareCluster","IDS80308","Record rejected - Adult Mental Health Care Cluster Code (Final) has incorrect data format.","This is the AMHCareClustCodeFin field of the IDS803CareCluster table. The Technical Output Specification shows the values that are acceptable for this field. Please check values, where required, are showing the leading zero.  The expected format for this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D418)","v":0},"IDS803CareCluster","IDS80309","Warning - Adult Mental Health Care Cluster Code (Final) contains an invalid Adult Mental Health Care Cluster Code (Final).","This is the AMHCareClustCodeFin field of the IDS803CareCluster table. The Technical Output Specification shows the values that are acceptable for this field. Please check values, where required, are showing the leading zero.  "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D419)","v":0},"IDS803CareCluster","IDS80314","Record rejected - End Date (Care Cluster Assignment Period) has incorrect data format.","This is the EndDateCareClust field of the IDS803CareCluster table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D420)","v":0},"IDS803CareCluster","IDS80315","Record rejected - End Date (Care Cluster Assignment Period) is before the start of the reporting period.","This is the EndDateCareClust field of the IDS803CareCluster table. If 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!D421)","v":0},"IDS803CareCluster","IDS80316","Record rejected - End Date (Care Cluster Assignment Period) is after the end of the reporting period.","This is the EndDateCareClust field of the IDS803CareCluster table. If 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!D422)","v":0},"IDS803CareCluster","IDS80317","Record rejected - End Date (Care Cluster Assignment Period) is prior to the associated Start Date (Care Cluster Assignment Period).","This is the EndDateCareClust field of the IDS803CareCluster table. If END DATE is populated and before the START DATE, the record will be rejected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D423)","v":0},"IDS803CareCluster","IDS80318","Record rejected - End Time (Care Cluster Assignment Period) has incorrect data format.","This is the EndTimeCareClust field of the IDS803CareCluster table. The time format is an8 (HH:MM:SS)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D424)","v":0},"IDS803CareCluster","IDS80319","Group rejected - More than one IDS803 provided for this Local Patient Identifier + End Date (Care Cluster Assignment Period) combination.","Within the IDS803CareCluster table duplicate records have been submitted with the same values in the following fields: LocalPatientId and EndDateCareClust. All duplicate records will be rejected with group-level rejection error"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D425)","v":0},"IDS803CareCluster","IDS80320","Group rejected - More than one IDS803 provided for this Local Patient Identifier + Start Date (Care Cluster Assignment Period) combination.","Within the IDS803CareCluster table duplicate records have been submitted with the same values in the following fields: LocalPatientId and StartDateCareClust. All duplicate records will be rejected with group-level rejection error"]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D426)","v":0},"IDS803CareCluster","IDS80321","Record rejected - Adult Mental Health Care Cluster Code (Final) is blank.","This is the AMHCareClustCodeFin field of the IDS803CareCluster table. This is a mandatory field and cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D427)","v":0},"IDS803CareCluster","IDS80322","IDS80322 - Record rejected - Start Date (Care Cluster Assignment Period) is blank.","This is the StartDateCareClust field of the IDS803CareCluster table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D428)","v":0},"IDS902CarePersQual","IDS90201","Record rejected - Care Personnel Local Identifier is blank.","The CarePersLocalId field of the IDS902CarePersQual table is mandatory and so cannot be left blank. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D429)","v":0},"IDS902CarePersQual","IDS90202","Record rejected - Care Personnel Local Identifier has incorrect data format.","This is the CarePersLocalId field of the IDS902CarePersQual table and can accept up to 20 characters. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D430)","v":0},"IDS902CarePersQual","IDS90203","Record rejected - Qualification Attainment Level (Improving Access To Psychological Therapies) is blank.","This is the QualAttainLevelIAPT field of the IDS902CarePersQual table. This is a mandatory field and cannot be left blank."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D431)","v":0},"IDS902CarePersQual","IDS90204","Record rejected - Qualification Attainment Level (Improving Access To Psychological Therapies) has incorrect data format.","This is the QualAttainLevelIAPT field of the IDS902CarePersQual table. The Technical Output Specification shows the values that are acceptable for this field. The data format of this field is an2."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D432)","v":0},"IDS902CarePersQual","IDS90205","Warning - Qualification Attainment Level (Improving Access To Psychological Therapies) contains an invalid Qualification Attainment Level (Improving Access To Psychological Therapies).","This is the QualAttainLevelIAPT field of the IDS902CarePersQual table. The Technical Output Specification shows the values that are acceptable for this field."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D433)","v":0},"IDS902CarePersQual","IDS90206","Record rejected - Employee Qualification Awarded Date has incorrect data format.","This is the QualAwardedDate field of the IDS902CarePersQual table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D434)","v":0},"IDS902CarePersQual","IDS90207","Record rejected - Employee Qualification Awarded Date is after the end of the Reporting Period End Date.","This is the QualAwardedDate field of the IDS902CarePersQual table. If Employee Qualification Awarded Date is after the end of the Reporting Period End Date, the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D435)","v":0},"IDS902CarePersQual","IDS90208","Record rejected - Employee Qualification Planned Completion Date has incorrect data format.","This is the QualPlannedCompletionDate field of the IDS902CarePersQual table. The date format is an10 (CCYY-MM-DD)."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D436)","v":0},"IDS902CarePersQual","IDS90209","Record rejected - Employee Qualification Planned Completion Date is before Reporting Period Start Date.","This is the QualPlannedCompletionDate field of the IDS902CarePersQual table. If Employee Qualification Planned Completion Date is before the Reporting Period Start Date, the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D437)","v":0},"IDS902CarePersQual","IDS90210","Group rejected - More than one IDS902 provided for this Care Personnel Local Identifier + Qualification Attainment Level (Improving Access To Psychological Therapies) combination.","Within the IDS902CarePersQual table, the combination of CarePersLocalId and QualAttainLevelIAPT cannot be repeated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D438)","v":0},"IDS902CarePersQual","IDS90212","Record rejected - Employee Qualification Awarded Date is before 01/01/2005.","This is the QualAwardedDate field of the IDS902CarePersQual table. If Employee Qualification Awarded date is before 01/01/2005, the record will be rejected. "]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D439)","v":0},"IDS902CarePersQual","IDS90213","Warning - Employee Qualification Awarded Date is before Employee Qualification Planned Completion Date.","This is the QualAwardedDate field of the IDS902CarePersQual table. If Employee Qualification Awarded Date is before the Employee Qualification Planned Completion Date, a warning will be generated."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D440)","v":0},"IDS902CarePersQual","IDS90214","Warning - Both Employee Qualification Awarded Date and Employee Qualification Planned Completion Date are blank.","Within the IDS902CarePersQual table, either a date population to the QualAwardedDate field or the QualPlannedCompletionDate field is expected."]
[null,{"$f":"COUNTIF(ErrorCSV!C:C,Source!D441)","v":0},"IDS902CarePersQual","IDS90215","Record rejected - Employee Qualification Planned Completion Date is more than 2 years after the Reporting Period End Date.","This is the QualPlannedCompletionDate field of the IDS902CarePersQual table. If Employee Qualification Planned Completion Date is more than 2 years after the Reporting End Date, the record will be rejected. "]