Skip to main content

Table Alias Section

  1. Last updated
  2. Save as PDF

Alias a table to another table. Aliasing creates a table link to file data in the aliased table. Available tables depend on the application.

Map a portion of the user-defined table to a solution table for the purpose of filing a row in the solution table as well as the user-defined table (Table Aliasing). This allows the DCI developer to create DCIs that can file the following example data: 

  • Diagnoses to the Diagnosis table.

  • Services to the Treatment History table.

  • Notes to the Progress Notes Table.

The product tables available for alias are solution dependent.

The following Client Entity Database tables can be aliased:

  • Diagnosis History
  • Diagnosis History by Date of Diagnosis
  • Treatment History

The following CWS Entity Database tables can be aliased:

  • CWS Central Diagnosis table
  • Patient Notes
  • Vital Signs

Requirements:

  • CWS Client Entity Table
  • Episodic in Nature (Except Vital Signs – the episode will be ignored since this is a non episodic table)
  • Date Sorted (Except Vital Signs – the date used will be mapped when the alias is completed) 

  1. In the Table Alias table, click Add New Item.

  2. In the Alias Table Entity Database field, select the entity database that contains the table to alias.

  3. In the Alias Table field, select the table to alias.
    Tables with the same sort criteria as the user-defined table are available (Is This Table Date or Order of Entry Sorted field, Table Definition section).
    Tables with the same episode based status are available (Is Table Episode Based field, Table Definition section).

  4. Click Submit.

Example

One of the uses for aliasing tables is to allow a CWS modeled form to enter service information in the billing_tx_history table. The table must be date sorted and episodic. The aliased table must have all the required columns in order to bill (all fields are required to submit the Client Charge Input form). The required columns (with the associated column types) are:

Column Label Type of Column
Service Date Table must be Date sorted. The table alias will use Sort Date column as the Date of Service.
Duration Integer
Location Single Response Dictionary with dictionary mapped to Client Location 
Practitioner Other Entity Look-up (Staff)
Program Single Response Dictionary with dictionary mapped to CWS Service Program 
Service Service Code Lookup

Once all columns are added to your table, click on the Table Alias section and select Client from the Alias Table Entity Database, and select Treatment History from the Alias Table.

Once the table is selected, you can click on the Column Mapping section, and one-by-one, select your newly-added columns (Duration, Location, Practitioner, Program, and Service) from the Table Column dropdown and map to the corresponding column in the Alias Table Column dropdown.