# Views that are created

For drug, condition, and procedure tables, views are created with the following naming convention:

<table_name>_VIEW

Each view joins the base table with CONCEPT to translate the drug, condition, and procedure concept_ids into the associated codes and names.

- Coded values appear in the views in one of the following additional columns:
  - DRUG_CD, for drug concept_ids.
  - CONDITION_CD, for condition concept_ids.
  - PROCEDURE_CD, for procedure concept_ids.
- Text descriptions appear in the views in one of the following additional columns:
  - DRUG_NAME, for drug concept_ids.
  - CONDITION_NAME, for condition concept_ids.
  - PROCEDURE_NAME, for procedure concept_ids.

Copyright © 2015 Oracle and/or its affiliates. All rights reserved.