Coeus |
Query/search
Awards, proposals,
rolodex, sponsors, personnel
Query/search |
|
COEUS® 3.5 is the current version, and it's available to download and install over MITnet.
|
|||||||||||||
|
|
|
||||||||||||
|
COEUS® provides powerful tools to help you search for awards, proposals, rolodex entries, sponsors, and persons. The Award Search and Award List (search results) windows below illustrate the COEUS® search process.
The sample below shows a search for awards funded by a specified Sponsor Code.
=> Use the horizontal scrollbar to see all fields. <= |
|||||||||||||
|
|
|
||||||||||||
|
After you enter search criteria and select Find, the Award List window shows the awards that meet your selection.
=> Use the horizontal scrollbar to see all fields. <= Select the award to view by double clicking on the award line. The window Display Award appears. Proposal, rolodex, sponsor, and personnel/person queries behave in a similar way. |
|||||||||||||
|
|
|
||||||||||||
|
|
|||||||||||||
|
|
|
||||||||||||
|
When you search for awards or proposals by investigator name, COEUS® also retrieves awards or proposals where the target person is a co-investigator (Co-I). The name that appears in the List window is that of the principal investigator. |
|||||||||||||
|
|
|
||||||||||||
|
COEUS® wild cards, shown in the table below, allow the use of partial search criteria. Remember to use a space after "like".
Search for award account numbers beginning with "666"
... for sponsor name ending in "Laboratory"
... for sponsor name containing "Lab"
... for sponsor name containing "Research"
... for sponsor name containing "Air"
... for award titles containing "DNA"
|
|||||||||||||
|
|
|
||||||||||||
|
Some COEUS® name fields, such as "Investigator", contain a person's full name -- first, last, and middle. When searching by last name in a full name field, enter "like %lastname%", even if you know the exact last name.
For fields actually labeled "Last name", use like %...% only if you do not know the exact last name. |
|||||||||||||
|
|
|
||||||||||||
|
The award search examples in this section show how to use more than one row for a search. Sponsor Code 000146 and Unit 067000
Units 067000 and 068000
Sponsor Code 000146 and Units 067000 and 068000 For this type of search, the key is remembering to enter complete search criteria in each row!
|
|||||||||||||
|
|
|
||||||||||||
|
Instead of doing three separate queries, the example below shows how you can retrieve several groupings of information in a single query:
|
|||||||||||||
|
|
|
||||||||||||
|
Suppose you want to search for awards or proposals with an Air Force sponsor code. This includes sponsor codes beginning with 000100 and ending with 000119. The example below shows how to specify the range -- greater than or equal to (>=) 000100 and less than or equal to (<=) 000119:
A search using items in a single row invokes the logical AND. A search using multiple rows invokes the logical OR. For queries using greater than (>) or less than (<), you need to enter "and" in the second line to override the OR relation between rows; otherwise, in this example, you would retrieve all sponsor codes! |
|||||||||||||
|
|
|
||||||||||||
|
On the ."... List" search results windows ... Single level ascending sort -- Select the desired column head. Multi
level sorts and descending sorts -- Sort window
|
|||||||||||||
|
|
|
||||||||||||
|
Move the cursor to the right edge of the column head, until the cursor changes to a double headed arrow. Drag the cursor to the left or right as needed. |
|||||||||||||
|
|
|
||||||||||||
|
Save search results -- List windows |
You can save search results from the "... List" window in Excel and other table formats:
|
||||||||||||
|
|
|
||||||||||||
|
Use the toolbar button, Search for Award, or the menu option, Tools>>Search . If you want to switch to a new type of search -- from Proposal to Award, for example -- select the search type on the Maintain or Departmental menu. |
|
Comments
about these pages |
