Exploring SQL in Hyperspace

Question 1

True or False

All metric definitions (IDN records) will reference the Clarity database.

Answer 1

False. IDN records may reference many possible data sources including Clarity or Caboodle. To learn more about a specific IDN, investigate the record.

Question 2

Select all that apply

Results of a Cogito SQL Reporting Workbench report that is searching on Patient IDs could return:

A. Any PAF that is displaying Chronicles information
B. Any PAF that is displaying a column from the select clause of the SQL query
C. Any PAF that is displaying a column from the source database (Clarity or Caboodle)

Answer 2

A and B

A Cogito SQL template can display Chronicles information or information from the select clause of the SQL query. For a Cogito SQL template to display Chronicles information you must search on either Records or Contacts, build that was not covered in this class but is covered in COG2030v Cogito SQL