Skip to main content

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 11 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?