ICH-CAHPS XML Data Submission Analysis

513-821-6266

ICH-CAHPS XML Data Submission Analysis

0

Failed XMLValidation

0

Not Authorized

4

Clients DO NOT have data

9

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

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'
		
4 Results
MonthYearCCNFR Start MonthFR Start Year
672698
162500
433512
522534

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

SELECT a.agency, 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
ORDER BY a.agency_num;
		
9 Results
MonthYearCCNAgency
052825
142526
142675
142703
162507
430016
432311
552570
672698

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 = 2016
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 = 2016
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.