ICH-CAHPS XML Data Submission Analysis


513-821-6266

ICH-CAHPS XML Data Submission Analysis

0

Failed XMLValidation

0

Not Authorized

4

Authorized Facilities that DO NOT have data

0

Clients DO NOT have data

4

Client(s) have not been submitted (Due to Non-Payment)

0

Submission Report Sample count does not match the database

0

Submission Report Completes count does not match the database

Failed XML Validation

SELECT a.*
FROM ichcahps_new.jos_ichcahps_data_submission_report a
	INNER JOIN (
		SELECT max(STR_TO_DATE(submission_date, '%m/%d/%Y')) as max_date
		FROM ichcahps_new.jos_ichcahps_data_submission_report
		) as b ON STR_TO_DATE(a.submission_date, '%m/%d/%Y') = b.max_date
WHERE status = 'Failed'
	and authorized NOT LIKE 'No%'
GROUP BY a.agency_num
ORDER BY authorized, period;

		
0 Results
MonthYearCCNFilenameStatusAuthorized

Not Authorized

SELECT a.*
FROM ichcahps_new.jos_ichcahps_data_submission_report a
	INNER JOIN (
		SELECT DISTINCT max(STR_TO_DATE(submission_date, '%m/%d/%Y')) as max_date
		FROM ichcahps_new.jos_ichcahps_data_submission_report
		GROUP BY agency_num
		) as b ON STR_TO_DATE(a.submission_date, '%m/%d/%Y') = b.max_date
	INNER JOIN ichcahps_new.jos_ichcahps_agencies c ON a.agency_num = c.agency_num
WHERE authorized LIKE 'No%'
	and a.agency_num <> '123456'
GROUP BY a.agency_num;

		
0 Results
MonthYearCCNFilenameStatusAuthorized

Authorized Agencies Missing From Data Submission

SELECT a.*
		FROM ichcahps_new.jos_ichcahps_vendor_auth a
			LEFT OUTER JOIN ichcahps_new.jos_ichcahps_data_submission_report b ON a.agency_num = b.agency_num
		WHERE b.agency_num IS NULL
			and a.ending_survey_period IN ('',NULL)
		ORDER BY a.agency_num;
	
4 Results
AgencyCCNBeginning Survey PeriodEnding Survey PeriodLast Updated
LEWISVILLE DIALYSIS CTR0425512014 Fall Survey2017-10-10 10:46:16
AVERA DIALYSIS - SIOUX FALLS4323112017 Fall Survey2017-10-10 10:46:16
AVERA DIALYSIS - MITCHELL4335112017 Fall Survey2017-10-10 10:46:16
DIALYSPA VINTAGE PARK6727632017 Fall Survey2017-10-10 10:46:16

Clients DO NOT have data

	SELECT a.agency, a.agency_num
	FROM ichcahps.qibfz_ichcahps_quality_assurance a
		INNER JOIN ichcahps_new.jos_ichcahps_agencies b ON a.agency_num = b.agency_num
	WHERE a.agency_num NOT IN (SELECT agency_num FROM ichcahps_new.jos_ichcahps_data_submission_report)
		and b.`client` = 'Y'
		
0 Results
MonthYearCCNFR Start MonthFR Start Year

Data has not beed submitted (Due to non-payment)

SELECT distinct(a.agency_num)
		FROM ichcahps.qibfz_ichcahps_quality_assurance a
			LEFT OUTER JOIN ichcahps_new.jos_ichcahps_data_submission_report b ON a.agency_num = b.agency_num
		WHERE a.records <> '0'
			and b.agency_num IS NULL
			and a.Semiannual_Survey = 2
			and a.Survey_year = 2017
		ORDER BY a.agency_num;
	
0 Results
MonthYearCCNAgency

Submission Report Sample count does not match the database

SELECT a.year, a.period, a.agency_num, a.filename, a.patients_sampled, a.completes, a.patients_sampled, b.records, b.completes as fr_completes
FROM ichcahps_new.jos_ichcahps_data_submission_report a
	INNER JOIN ichcahps.qibfz_ichcahps_quality_assurance b ON a.agency_num = b.agency_num
		and b.Semiannual_Survey = 2
		and b.Survey_Year = 2017
WHERE a.patients_sampled <> b.records
		
0 Results
CCNFilenamePatients Sampled (CMS)Patients Pulled (FR)Completes (CMS)Completes (FR)

Submission Report Completes count does not match the database

SELECT a.year, a.period, a.agency_num, a.filename, a.patients_sampled, b.records, a.completes, b.completes as fr_completes
FROM ichcahps_new.jos_ichcahps_data_submission_report a
	INNER JOIN ichcahps.qibfz_ichcahps_quality_assurance b ON a.agency_num = b.agency_num 
		and b.Semiannual_Survey = 2
		and b.Survey_Year = 2017
WHERE a.completes <> b.completes
	and a.completes <> '';
		
0 Results
MonthYearCCNFilenamePatients Sampled (CMS)Patients Pulled (FR)Completes (CMS)Completes (FR)

Login

Enter Your Agency Number

You will be redirected to your login page in just a moment.

You will be redirected to your login page in just a moment.

The agency number you provided is not on record with Fields Research. Please try again.

Please complete all the fields in the form before sending.