SQL Database – Chronic Kidney Disease Code – PICQ – IT Assignment Help

By

Internal Code: 6CIAG
IT Assignment Help
Task:
Question 1
Question text
You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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
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 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.
Question 2

Question text

You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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 disorders code and a mitral valve disorders code. ACS 0015 Combination codes states 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 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 assessement document.
Question 3

Question text

You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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 hyperglycaemia (IH) with background retinopathy code and background retinopathy code
This indicator identifies records containing Diabetes mellitus or intermediate hyperglycaemia (IH) with background retinopathy code and the background retinopathy code. ACS 0401 ‘Diabetes mellitus and intermediate hyperglycaemia (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.
Question 4

Question text

You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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 states 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 is 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.

Question 5

Question text

You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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’ states 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 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.

Question 6

Question text

You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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 a kidney failure or impairment code

This indicator identifies records containing a Diabetes mellitus code and a 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 hyperglycaemia (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.

Question 7

Question text

You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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.

Question 8

Question text

You have been provided with an SQL database containing one years admissions for all Victorian hospitals. This data has logical errors (eg giving an 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 hyperglycaemia (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.

This IT Assignment has been solved by our IT experts at TVAssignmentHelp. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

 

 

 

 

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services