TABLE OF CONTENTS
Welcome to CRISP on the web. This user interface is designed for the general public to access the CRISP data using basic queries. These basic queries allow the user to access both the CRISP records for the current fiscal year and the records dating back to fiscal year 1972. The search form allows the user to generate two types of queries, keyword and fielded. The keyword queries are a type of unstructured text or stream of consciousness query. After these keyword terms are entered, they are parsed, Common Words are removed and an Oracle InterMedia Text Query is constructed. The results of the query are returned in a Hit List. The information provided in the hit list includes the title of the project, clicking on this title will bring up the Abstract containing additional information about the project including the text of the Abstract.
This is the main search screen for accessing information about awarded grants. By entering data into this form you are building an Oracle InterMedia Text Query. The default logic combining the keyword search terms is OR. This can be changed by selecting one of the Advanced Search options. The fields below the keyword search box allow the user to form a fielded query that defines a SQL select statement. The logic between these fields is AND. Both the keyword queries and the fielded queries are case insensitive, so terms may be entered in any combination of upper and lower case letters. The Clear button may be clicked at any time to reset the form. When the search criteria are defined, clicking on the Submit button at the bottom of the screen initiates the search of the CRISP database to locate the projects that satisfy the search criteria. Information about these relevant projects is returned in the Hit List. The following eleven elements are used to define a user's query:
- Keyword Search Terms - The default logic between each of the keywords is OR. The query will search for projects that contain at least one occurrence of one of the query terms (e.g. glucose receptor retrieves projects containing glucose or receptor.) The '%' wildcard can be used to expand the keyword search. The logic between the keywords can be changed by selecting one of the Advanced Search options. Pre-processing of the query, such as removing Common Words occurs before the query is submitted.
- PI Name (Last, First) - The name of the principal researcher who received the grant and will conduct the research. The '%' wildcard may be used if only a portion of the name is known.
doe, john creates a query for all projects with a PI of John Doe.
doe% creates a query for all projects for which the prefix of the PI's Last Name is doe. For example, doe, doeman, and doelan would be possible matches to this fielded query.
- Award Type - A one digit code identifying the application type of a grant, or the type of contract transaction (i.e. New (1), Competing (1,2,&9), Non-Competing (5)).
- Activity - A three digit code identifying a specific category of extramural activity.
All R, M, S, K, U, G12, D42 activity codes. The largest category of NIH research funding, support research projects, research centers, and other research grants.
R01, P01, U01, R23, R29, R35, R37, R03, R15, R12, U19, R55 activity codes. Investigator initiated, basic scientific support to principal investigator in his/her area of competency. Projects NCRR's R21 activity code and any awards made by NLM are omitted.
All N activity codes. A mechanism in which NIH procures specified services.
R41, R42, R43, R44, N43, N44, U43, U44 activity codes. Small Business Innovation Research and Small Business Technology Transfer awards are designed to support projects that may ultimately have commercial viability.
R15 activity codes. Supports small scale research projects conducted by faculty in primary baccalaureate degree-granting domestic institutions.
- Grant Number - Unique identifying number assigned to applications. When entering the grant number, do not include any spaces. For all current and historical data the serial number of the grant has been converted to a six digit field by prefixing it with a zero. The '%' wildcard is added as a prefix to all grant numbers. In addition the '%' wildcard may be used if only a portion of the grant number is known.
5R01CA062482-03 is a valid grant number.
5R01CA062% would return all projects with a grant number having the prefix 5R01CA062.
- Grant Title - Title of research grant, contract, or intramural project. The '%' wildcard may be used if only a portion of the title is known.
- Institutes and Centers - The NIH component responsible for funding and administering the awarded research.
- Institution - Usually a university, hospital, research center, or other organization where the investigator is employed. The '%' wildcard may be used to expand the school name. This is especially useful for schools with multiple campuses.
johns hopkins% matches with Johns Hopkins University.
The schools that match the fielded query pennsylvania state% or penn% include all 23 campuses of the Pennsylvania State University system.
- Fiscal Year - The Fiscal Year in which the research funding was awarded. The default is the current fiscal year. CRISP currently contains records funded from fiscal year 1972.
- IRG - The Initial Review Group assigned to competing applications.
- State - Geographical location (state) of awarded projects.
CRISP Advanced Search
The CRISP advanced search provides the search capability of the basic search and introduces four more search options:
- AND - Use to search for documents that contain at least one occurrence of each of the query terms (e.g. glucose AND receptor retrieves projects containing both glucose and receptor.)
- OR - Use to search for projects that contain at least one occurrence of one of the query terms (e.g. glucose OR receptor retrieves projects containing at least one of the terms.)
- Phrase - Use to search for projects that contain the keywords together in a phrase. (e.g. A search with the keywords glucose receptor returns all projects that contain the phrase glucose receptor, but none of the projects with just glucose, just receptor, or that contain both glucose and receptor, but not in the context of a phrase.)
- Stem - Expands the list of words to include all words having the same stem or root. (e.g. carcinogen expands to search for projects including carcinogen, carcinogenic, carcinoma, carcinomas, and carcinogenesis.)
- Maximum Records - Changes the maximum number of records returned in the Hit List from a range of 1 to 9999. The default value is 250.
The CRISP Thesaurus is a controlled vocabulary used to assign indexing terms or keywords to research projects. The CRISP Thesaurus is also a tool for selecting the appropriate terminology when querying the database. Consider using 'Phrase' or 'And' global logic when searching multi-term concepts, such as HIV Infection or cystic fibrosis.
A successful query will generate a hit list that provides information about the projects that satisfy the query. The format of the hit list is determined by the type of query that was performed. A successful keyword search generates a hit list with a Rank, Score, Grant Number, PI Name, and Project Title for each project that satisfied the search criteria. The score that is displayed represents which of the documents returned are most closely related to the user's query. The projects are listed in decreasing order by score. The rank is simply a numerical ordering of the projects returned. A query without keywords generates a hit list with the Grant Number, PI Name, and Project Title, ordered by PI Name, then grant number.
For both types of hit lists, clicking on the project title will bring up the Abstract that provides more information about the project.
This screen provides additional information about an individual project. The information displayed includes Grant Number, PI Name, PI Email Address, PI Title, Project Title, the text of the Abstract, Thesaurus Terms related to the Abstract, Institution Name and Address, Fiscal Year, Department, the Project Start and End Dates, ICD, and IRG.
- PI Title - The title of the principal investigator, e.g. Professor of Biology.
- Abstract - The abstract provided with the grant application. The words that match the keywords used in the query are returned as bold and italicized text.
- Thesaurus Terms - These are the three terms assigned from the dictionary of controlled words.
- Address - The address of the institution with which the PI is affiliated.
- IRG - The initial review group assigned to the project.
Usage Report Form
This section is currently under construction
This is the list of 76 common words that are removed from the query.
A BEEN HER MRS S TO ABOUT BUT HIS MS SAYS UP AFTER BY IF MZ SHE WAS ALL CAN IN NO SO WE ALSO CO INC NOT SOME WHERE AN CORP INTO OF SUCH WHEN AND COULD IS ON THAN WHICH ANY FOR IT ONE THAT WHO ARE FROM ITS ONLY THE WILL AS HAD LAST OR THEIR WITH AT HAS MORE OTHER THERE WOULD BE HAVE MOST OUT THEY BECAUSE HE MR OVER THIS
- Internet Explorer 4.x
- On the View menu, click Internet Options.
- Click the Security tab.
- Make sure that the "Run ActiveX scripts" box is checked, then click Apply, then OK.
- Netscape Communicator 4.x
- On the Edit menu, click Preferences.
- Click on Advanced.
- Netscape Navigator 3.x
- On the Options menu, click Network Preferences.
- Click on Languages.