|
Home > CRISP > CRISP Help |
|
|
|
|
TABLE OF CONTENTS
|
Introduction
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. |
CRISP Search
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.
EXAMPLE:
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.
Research Grants 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.
Research Projects 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.
Contracts All N activity codes. A mechanism in which NIH procures specified services.
SBIR/STTR 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.
AREA 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.
EXAMPLES:
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.
EXAMPLES:
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.
|
Thesaurus
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. |
Hit List
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. |
Abstract
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
|
Common Words
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 |
|
CRISP and JavaScript
The CRISP query screens use JavaScript to validate and qualify your search requests. If your browser does not support JavaScript, or if you have
disabled JavaScript in your browser's settings, then your CRISP search will be executed, but the results will likely be inaccurate. Popular browsers that support JavaScript include Netscape Navigator 3.0 and
higher, Netscape Communicator 4.0 and higher, and Microsoft Internet Explorer 4.0 and higher. If you are using one of these browsers and still receive a
JavaScript warning, then follow the appropriate procedure below to make sure that your browser is set to accept JavaScript commands. Once you have changed
your browser settings, click the Reload button and re-enter your search criteria. |
To Enable JavaScript:
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.
- Make sure that the "Enable JavaScript" box is checked, then click OK.
Netscape Navigator 3.x
- On the Options menu, click Network Preferences.
- Click on Languages.
- Make sure that the "Enable JavaScript" box checked, then click OK.
|
|
|
|
|