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.
Open and edit a report.
Create a Calculated Field by navigating to Analysis → Create → Calculated Field
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)Add the newly created data point to the report.
View and verify the data
Understanding the Results
Run and view the results.
In our example we have a patient whose information is:
Patient Firstname:
LUKE
| Patient Lastname:SKYWALKER
Our results now show as:
Alias:
Sk. . .rL
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®.