A customer needs claims data pulled for 100 specific PatientUIDs. What is the "best" way to accomplish this in the Claims Cube?
1. Use multi select function in the dropdown box
2. Manually select each Patient UID
3. Create a smaller Pivot Table only for the Patient UIDs
4. Use OLAP Pivot table Extension, use "Filter List" tab
100
The easiest way to have windows side by side on a single monitor when comparing Windows OS?
Grab the top of each window and drag it to the side.
100
Which one is an ICD-9-CM Diagnose Code and which one is an ICD-9-CM Procedure Code:
1. 4XX.X
2. 4X.XX
1. 4XX.X Diagnosis Code
2. 4X.XX Procedure Code
Because of the decimal point.
100
What does PPO stand for?
preferred provider organization
100
What is the maximum rows and columns allowed in Excel 2010 and later?
1. No limit
2. 3 million rows, 3 million columns
3. 1,048,576 rows, 16,384 columns
4. 2,444,555 rows, 2,345,274 columns
3. 1,048,576 Rows, 16,384 Columns
200
What is "Pass Through Query" used for in MS Access Database?
To pull data directly from SQL server using SQL script rather than Access SQL script.
200
What is a dx. pointer?
Each dx may have multiple procedures associated with it.
200
Name the one column that is incorrect.
PrescriberName
200
Name the 5 health plans contracted on the PPO side:
Cigna, BlueShield, Anthem, United, Aetna
200
Which of the following is NOT a benefit of Index(Match) over VLookup?
A) Less processing power is used
B) Wildcard search is possible
C)Index(Match) is bidirectional and Vlookup is only from the left
D)Column Immunity
B)Wildcard search is possible.
300
Is "Cross Tab Query" in MS Access Database the same as Pivot function in T-SQL?
True or False?
True
300
Where would you go find dx pointer in QNXT?
Claim
Enter a claim number
Click on claim link
Click "Service" from the menu on the left hand side
300
Name the one column with a yellow header that is incorrect:
a)LOINC# b)DOS c)procedurecode d)testname e)CleanResult
e)CleanResult
300
PPO gets their claims data from QNXT.
True or False
False.
300
What is the easiest Excel formula to calculate age?
=datedif(date1,date2,"y")
400
Name one way to properly convert lines that start leading zeroes i.e 0000001234 into Excel for analysis?
Notepad, save as CSV, import and column data type as Text.
400
What is the difference between M.D. vs. D.O.?
MD’s practice allopathic medicine, the classical form of medicine, focused on the diagnosis and treatment of human diseases.
DO’s practice osteopathic medicine which is centered around a more holistic view of medicine in which the focus is on seeing the patient as a “whole person” to reach a diagnosis, rather than treating the symptoms alone.
400
Name the attribution months that are incorrect in the EffectiveMonth column
June 2016, July 2016, August 2016, September 2016
400
HPs uses the following for their risk scores:
DxCG, Pulse, Pre*Vise, Symmetry Prospective Risk
True or False?
True
400
What does "=T()" function do?
1. Converts to text
2. Checks if a value is text and returns the text or returns nothing if not text
3. Finds the Top value in an array of values
2. Checks if a value is text and returns the text or returns nothing if not text
500
What is the difference between "Patient ID" vs. "Patient UID"?
A patient may have multiple "Patient ID"s when a patient terms and re-enroll under a new health plan.
"Patient UID" is what groups/rolls-up the multiple "patient ID"s of the same patient.
500
What do the following specialty division really mean: "TSRG", "SPCP", "SPAD"?
TSRG: Thoracic Surgery. SPCP: Special PCPs: Internal Medicine doctors and Specialist, has no assigned members. SPAD: Speech Audiology.
500
Which column is incorrect?
IPDays
500
Which health plans do we receive Lab results for in PPO
1. AETNA
2. Anthem
3. Alameda Alliance
4. Humana
1. AETNA
500
What is the difference between ".xlsx" vs. ".xlsb" Excel file extensions?
xlsx is the default format of Excel in XML format
xlsb is in binary format.
For our purpose they are exactly the same except xlsb is about half the file size of xlsx.