SQL Database Solutions

SQL Database Solutions

Answer 1)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 102058 - Chronic kidney disease code assigned more than once
5854702468245SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102058
AND pcq.Error_Type 3
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102058
AND pcq.Error_Type 3
This indicator identifies records containing more than one Chronic kidney disease code. ACS 1438 Chronic kidney disease states that, in cases where there is a range of values reported across the admission, assign the stage for the lowest GFR (eGFR), i.e. the highest stage of the disease, except where superimposed acute deterioration in kidney function has necessitated the admission or occurs during the admission. In these instances assign a code for the chronic component of the disease according to the GFR (eGFR) result closest to the discharge date, reflecting the underlying level of kidney function. That is, if a patient has CKD of differing stages across the admission, only one code is assigned to indicate the highest stage. Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.

Answer 2)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 102228 - Aortic valve disorders code with mitral valve disorders code
This indicator identifies records containing an aortic valve disorder code and a mitral valve disorder code. ACS 0015 Combination codes state that a combination code is a single code used to classify two diagnoses and that combination codes are identified by referring to subterm entries in the Index. When there is an aortic valve and mitral valve disorders a combination code should be assigned according to the Index, for example, Stenosis/ mitral/ with aortic valve disease, and the Excludes notes in the Tabular. These records would be correct if a specific aortic or mitral valve disorders code was assigned to further specify the multiple valve disorders code, or because one valve disorder has a known cause and the other does not. Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.
54800515240SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102228
AND pcq.Error_Type 4
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102228
AND pcq.Error_Type 4

Answer 3)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 102094 - Diabetes mellitus or intermediate hyperglycemia (IH) with background retinopathy code and background retinopathy code
This indicator identifies records containing Diabetes mellitus or intermediate hyperglycemia (IH) with background retinopathy code and the background retinopathy code. ACS 0401 Diabetes mellitus and intermediate hyperglycemia (IH) indicates that the relevant code for retinopathy, not otherwise specified, with diabetes mellitus or IH is Diabetes/IH with background retinopathy and retinal vascular changes (following General classification rules, Rule 3). No additional code for retinopathy is required as the Diabetes/IH with background retinopathy and retinal vascular changes code clearly identifies all of the elements documented in the diagnosis (ACS 0401, General classification rules, Rule 6). Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.
53530520320SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102094
AND pcq.Error_Type 3
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102094
AND pcq.Error_Type 3

Answer 4)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 102194 - Pain code as principal diagnosis with a pain management procedure code
This indicator identifies records containing a pain code as the principal diagnosis with a pain management procedure code. ACS 1807 Pain diagnoses and pain management procedures state that chronic pain should be sequenced as the principal diagnosis only when a patient is admitted specifically for pain management and no related definitive diagnosis has established the site of the pain should be used to assign the principal diagnosis code and the condition causing the pain should be sequenced as the principal diagnosis. Patients admitted for pain management procedures often have a long history of pain and the coder should check correspondence or previous admissions for documentation of the cause and site of the pain where it is not specifically documented in the current episode of care. These records may be correct if the site or cause of the pain is not documented or the code was assigned for another condition. Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.
57658014605SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102194
AND pcq.Error_Type 4
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102194
AND pcq.Error_Type 4

Answer 5)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 101967 - Administration of blood product code assigned more than once - platelets
This indicator identifies records containing more than one administration of blood product code for the same blood product - platelets. ACS 0302 Blood transfusions state that multiple administrations of the same blood product within the same episode of care should be reflected by one procedure code only. Indicators 101966 - 101967 check for the administration of blood product codes assigned more than once. Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.
58102535560SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 101967
AND pcq.Error_Type 3
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 101967
AND pcq.Error_Type 3

Answer 6)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 101938 - Diabetes mellitus code and kidney failure or impairment code
This indicator identifies records containing a Diabetes mellitus code and kidney failure or impairment code but no Diabetes mellitus with established diabetic nephropathy code, incipient diabetic nephropathy code, or other specified kidney complication code. ACS 0401 Diabetes mellitus and intermediate hyperglycemia (IH) states that, when a patient has diabetes and kidney failure or impairment, a Diabetes mellitus with established diabetic nephropathy code, incipient diabetic nephropathy code or other specified kidney complication code should be assigned (refer to General classification rules, Rules 1, 3 and 4a). Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.
60515510160SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 101938
AND pcq.Error_Type 4
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 101938
AND pcq.Error_Type 4

Answer 7)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 101980 - Leiomyoma of uterus (fibroids) morphology code without leiomyoma diagnosis code
This indicator identifies records containing a leiomyoma of uterus morphology code and a benign neoplasm of uterus code but without a leiomyoma of uterus diagnosis code. The Alphabetic Index of Diseases at Leiomyoma, uterus, provides coders with the site classification codes that should be used, rather than referring to the Neoplasm Table. Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.
55562531750SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 101980
AND pcq.Error_Type 4
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 101980
AND pcq.Error_Type 4

Answer 8)

You have been provided with an SQL database containing one year's admissions for all Victorian hospitals. This data has logical errors (eg giving a hysterectomy to a male patient). These errors are described in a set of rules called Performance Indicators for Coding Quality, or PICQ. For this question, you must write and test a set of queries on this database to extract admissions that are described by the following indicator
PICQ ID 102091 - Diabetes mellitus with multiple microvascular complications and without multiple microvascular complications code
This indicator identifies records containing two or more Diabetes mellitus codes classified as multiple microvascular complications but no Diabetes mellitus with multiple microvascular and other specified nonvascular complications code. ACS 0401 Diabetes mellitus and intermediate hyperglycemia (IH) states that the code for diabetes mellitus with multiple microvascular and other specified nonvascular complications should be assigned when the individual has conditions classifiable to two or more of the following five categories of complications kidney, ophthalmic, neurological, diabetic cardiomyopathy or skin and subcutaneous tissue. Write a set of SQL queries to find the frequency of this error in the VAED database. Show details as per the assessment document.
54800529210SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102091
AND pcq.Error_Type 2
00SELECT diag.Patient_Id, pcq.PICQ_ID, pcq.Error_Type, diag.DIAG, diag.Position, diag.pref, diag.nfk_ae, pcq.Desc, pcq.Indicator_desc
FROM diagnosis diag, picq pcq
WHERE diag.Patient_Id pcq.Patient_Id
AND pcq.PICQ_ID 102091
AND pcq.Error_Type 2