Exploring Database Objects in Clarity

Question 1

Look up the following database objects in the Clarity Compass and fill in the type:
Database Object Type
Clarity_TDL ———————–
OB_HISTORY ———————–
MU_EP_PROV_SUMMARY ———————–

Answer 1

VIEW
VEIW
Derived Table

Question 2

Look up the following database objects in the Clarity Compass and fill in the type

Answer 2

HH_OASIS_INFO, HH_PAT_ENC, PAT_ADDENDUM_INFO, PAT_ENC, SMRTDTA_ELEM_DATA,
SMRTDTA_ELEM_VALUE

Question 3

What are “dependent database objects”, listed in the Clarity Compass? How can you use this information?

Answer 3

The list of database objects upon which this object depends.
This list can help determine what extracted tables and columns a view or derived table can be used
in place of

Question 4

V_PAT_FACT is based on the PATIENT table. What logic has been applied to PATIENT in this view?
How can you find this information?

Answer 4

V_PAT_FACT uses Case statements in to calculate patient age. The logic can be viewed from the
Scripts tab of the Clarity Compass for V_PAT_FACT

Question 5

T/F All views in Clarity start begin with ‘V_’

Answer 5

False, Naming conversions are not strictly enforced in Clarity