...

Therefore, "adjusted expiration" is just our best estimate of the expiration date. To get an exact date, you need to open up the file wrapper and see what the terminal disclaimers say, and see if any additional adjustments have been made.

For tips on searching anticipated and adjusted expiration dates, see Tips for Searching the IFI Integrated Data.

Searching with the Anticipated and Adjusted Expiration Date Fields

The anticipated and adjusted expiration date fields can be useful in searching. However, one must be careful.

For example, if you want to see how many US grants expire in 2020, it is important to note that the ifi_expdyear_adj field is only present in a record if there has been a term adjustment or extension. When there is no adjustment or extension, there is no adjusted expiration date. Therefore, you must use the anticipated expiration date.

So if you enter the following search using the anticipated expiration year:

pnctry:US AND pnkind:(A OR B1 OR B2) AND ifi_expdyear:2020

this results in 208,915 records. This is NOT the correct result as it excludes grants with term adjustments and extensions that when adjusted, expire in 2020.

If you perform the same search and replace the anticipated expiration year with the adjusted expiration year:

pnctry:US AND pnkind:(A OR B1 OR B2) AND ifi_expdyear_adj:2020

this results in 32,889 records. This is obviously NOT correct and reflects only those records with populated ifi_expdyear_adj fields (about 15% of the records).

To get the correct number, you must combine the anticipated and adjusted expiration date fields using the "OR" operator in a nested search:

pnctry:US AND pnkind:(A OR B1 OR B2) AND ((ifi_expdyear_adj:2020) OR (ifi_expdyear:2020 NOT flags:has_ifi_expdyear_adj))

This results in 167,209 records. It is the sum of:

pnctry:US AND pnkind:(A OR B1 OR B2) AND (ifi_expdyear:2020 NOT flags:has_ifi_expdyear_adj)

which results in 134,320 records, and

pnctry:US AND pnkind:(A OR B1 OR B2) AND (ifi_expdyear_adj:2020)

...