If you work with an investigator who has a preferred name in addition to their primary legal name, and who may have had proposals, awards, negotiations or subawards under both names, use the vertical line ‘or’ operator, “|”, in lookup screens accessed via Common Tasks in the UAR left hand navigation pane. This will allow a search for all names the person might have used in past records.
In the past, UAR only populated a person’s legal/primary name as it was entered into the UAccess Employee system. As of the January 25, 2022 UAccess Research (UAR) system update, both primary legal name and preferred name are brought into UAR, with the default being preferred name. As a result of added flexibility, people who have a preferred name or who have changed their name over time may have older records under a different name.
Example: john den|ja*den finds John R Den, Johnna Alden, OR Jack Den, Jason Hayden.
Lookup Wildcards
Operator |
Name |
Compatible Data Types |
Precedence |
Notes |
| |
Or |
All |
Always |
|
&& |
And |
All |
Always |
|
! |
Not equal to |
String |
1 |
If used repeatedly, an && is assumed. Ex: !1490!1491 is like !1490&&!1491 |
?, * |
Like |
String |
7 |
? matches one character. |
.. |
Greater than or Equal to and Less than |
String, Number, Date |
2 |
|
> |
Greater than |
String, Number, Date |
3 |
|
< |
Less than |
String, Number, Date |
4 |
|
>= |
Greater than or equal to |
String, Number, Date |
5 |
|
<= |
Less than or equal to |
String, Number, Date |
6 |
|