Skip to main content
All CollectionsData IQ®Workflows - Data IQ®
Replacing a Patient Name with an Alias - Data IQ®
Replacing a Patient Name with an Alias - Data IQ®

Changing a name into an alias within an report

Joe Caffrey avatar
Written by Joe Caffrey
Updated over 5 months ago

About

It is possible to display field aliases for reports. In this example we’re referencing a Patient Aliases similar to what appears in Capacity Management Suite® or Capacity IQ® for confidential patients.


Steps

Creating a Patient Alias with Calculated Fields

We’re going to use the PATIENT_VISIT data source.

  1. Open and edit a report.

  2. Create a Calculated Field by navigating to Analysis Create Calculated Field

  3. Add the following calculation then Save the field.

    LEFT([Patient Lastname],1)
    +LOWER(MID([Patient Lastname],2,1))
    +". . ."
    +LOWER(RIGHT([Patient Lastname],1))
    +LEFT([Patient Firstname],1)
  4. Add the newly created data point to the report.

  5. View and verify the data

Understanding the Results

  1. Run and view the results.

  2. In our example we have a patient whose information is:

    1. Patient Firstname: LUKE | Patient Lastname: SKYWALKER

  3. Our results now show as:

    1. Alias: Sk. . .rL

  4. Looking at our calculated field we can understand how string functions were used to create a custom format - String Functions


Best Practices

Replacing patient names with aliases are common practice in Data IQ®.

Did this answer your question?