Clean up fields to display in search results export file

[ClaireValdivia]

Why is this issue important?

after new search was implemented, the fields in the csv export file were not updated to reflect new fields or remove fields that are not relevant to users.

Current State

The following fields show on My Grants and Browse Grants results table:

• Title
• Viewed by
• Interested Agencies
• Status - (shows "Opportunity Status")
• Opportunity Category
• Cost Sharing
• Award Floor
• Award Ceiling
• Open Date
• Close Date

The export file includes all these fields, as well as:

• Opportunity Number
• Agency Code
• Grant ID
• URL (this is the grants.gov url)

Expected State

Add the following fields as columns to the export file:

• Funding Type
• Eligibility
• Appropriations Bill
• Agency Code

Rename the following fields on export file:

• The column titled "Status" should be named "Opportunity Status"

Implementation Plan

tbd

Relevant Code Snippets

No response

[replicantSocks]

For eligibility, each grant has multiple eligibility codes, sometimes even as many as 15. Is the proposal to map these to their corresponding phrases e..g "Public housing authorities/Indian housing authorities" and have a column with each of those phrases in a delimited list or is there another way to display Eligibility more succinctly?

[ClaireValdivia]

@replicantSocks yes, having the mapped phrases show in a delimited list is the proposal. The phrases should match what is displayed on the dropdown in Search for the Eligibility field

[ClaireValdivia]

tested in staging and export looks great!

[ClaireValdivia]

re-tested in staging and still looks good!