Federal Grants data field mappings

	A	B	C	D	E	F
1	Source Provider	Source Field	Destination Field (USDR Grant objectschema, object-dot-notation)	Finder usage (in Browse Grants)	Additional Information (see Grants.gov Terminology Page)	Grants.gov usage (on View Opportunity page)

2	Grants.gov Grant Opportunity	OpportunityID	opportunity.id	Grant Id	One of two unique identifiers for grants/opportunities, maintained by Grants.gov. This is a numeric value. Grants.gov Tracking Number A number set used by Grants.gov which is used to identify each application it receives.	(In URL, but not displayed on page)
3	Grants.gov Grant Opportunity	OpportunityNumber	opportunity.number	Grant number	One of two unique identifiers for grants/opportunities, maintained by Grants.gov. This is an alphanumeric, often hyphenated value. Maybe?: Funding Opportunity Number (FON) The number that a federal agency assigns to its grant announcement.	General Information -> Funding Opportunity Number
4	Grants.gov Grant Opportunity	OpportunityTitle	opportunity.title	Title		General Information -> Funding Opportunity Title
5	Grants.gov Grant Opportunity	Description	opportunity.description	Description		Additional Information -> Description
6	Grants.gov Grant Opportunity	OpenDate	opportunity.milestones.post_date	Valid from (Also determines Opportunity Status)	The date the grant-making agency published the funding opportunity on Grants.gov.	General Information -> Posted Date
7	Grants.gov Grant Opportunity	CloseDate	opportunity.milestones.close.date	Valid from (Also determines Spportunity Status)	The deadline designated by the grant-making agency designated for submission of a particular grant application. Also see Grace Period	General Information -> Original Closing Date for Applications General Information -> Current Closing Date for Applications
8	Grants.gov Grant Opportunity	CloseDateExplanation	opportunity.milestones.close.explanation			(Not shown)
9	Grants.gov Grant Opportunity	ArchiveDate	opportunity.milestones.archive_date	(Determines Opportunity Status)		General Information -> Archive Date
10	Grants.gov Grant Opportunity	LastUpdatedDate	opportunity.last_updated			General Information -> Last Updated Date
11	Grants.gov Grant Opportunity	OpportunityCategory	opportunity.category.name, opportunity.category.code	Opportunity Category	A field located on the Grant Opportunity Properties screen within Grants.gov. The Opportunity Category field values include Discretionary, Mandatory, Earmark, and Continuation. The Opportunity Category field was added to the site to assist Grants.gov with aggregating opportunities and application packages for public and private displays on the site. For example, there are links which show grant opportunities and packages recently posted to the site. Those opportunities and packages with a category type of Earmarked or Continuation will not show up on these public listings. C: Continuation D: Discretionary E: Earmark M: Mandatory O: Other	General Information -> Opportunity Category
12	Grants.gov Grant Opportunity	OpportunityCategoryExplanation	opportunity.category.explanation			General Information -> Opportunity Category Explanation
13	Grants.gov Grant Opportunity	EligibleApplicants	eligible_applicants.<list>.name, eligible_applicants.<list>.code	Eligibility Code	See https://www.grants.gov/web/grants/learn-grants/grant-eligibility.html 00: State governments 01: County governments 02: City or township governments 04: Special district governments 05: Independent school districts 06: Public and State controlled institutions of higher education 07: Native American tribal governments (Federally recognized) 08: Public housing authorities/Indian housing authorities 11: Native American tribal organizations (other than Federally recognized tribal governments) 12: Nonprofits having a 501(c)(3) status with the IRS, other than institutions of higher education 13: Nonprofits that do not have a 501(c)(3) status with the IRS, other than institutions of higher education 20: Private institutions of higher education 21: Individuals 22: For profit organizations other than small businesses 23: Small businesses 25: Others (see text field entitled "Additional Information on Eligibility" for clarification) 99: Unrestricted (i.e., open to any type of entity above), subject to any clarification in text field entitled "Additional Information on Eligibility"	Eligibility -> Eligible Applicants
14	Grants.gov Grant Opportunity	CategoryExplanation	funding_activity.explanation	(Not shown)		General Information -> Category Explanation
15	Grants.gov Grant Opportunity	CategoryOfFundingActivity	funding_activity.categories.<list>.name, funding_activity.categories.<list>.code	(Not shown)	ACA: Affordable Care Act AG: Agriculture AR: Arts BC: Business and Commerce CD: Community Development CP: Consumer Protection DPR: Disaster Prevention and Relief ED: Education ELT: Employment, Labor and Training EN: Energy ENV: Environment FN: Food and Nutrition HL: Health HO: Housing HU: Humanities IIJ: Infrastructure Investment and Jobs Act IS: Information and Statistics ISS: Income Security and Social Services LJL: Law, Justice and Legal Services NR: Natural Resources O: Other OZ: Opportunity Zone Benefits RA: Recovery Act RD: Regional Development ST: Science and Technology and Other Research and Development T: Transportation	General Information -> Category of Funding Opportunity
16	Grants.gov Grant Opportunity	FundingInstrumentType	funding_instrument_types.<list>.name, funding_instrument_types.<list>.code	Funding Type	CA: Cooperative Agreement G: Grant PC: Procurement Contract O: Other	General Information -> Funding Instrument Type
17	Grants.gov Grant Opportunity	CostSharingOrMatchingRequirement	cost_sharing_or_matching_requirement	Cost Sharing	The portion of project costs not paid by Federal funds (unless otherwise authorized by Federal statute). See also §200.306 Cost sharing or matching of the OMB Uniform Grant Guidance.	General Information -> Cost Sharing or Matching Requirement
18	Grants.gov Grant Opportunity	AdditionalInformationOnEligibility	additional_information.eligibility		See https://www.grants.gov/web/grants/learn-grants/grant-eligibility.html	Eligibility -> Additional Information on Eligibility
19	Grants.gov Grant Opportunity	AdditionalInformationURL	additional_information.url			Additional Information -> Link to Additional Information
20	Grants.gov Grant Opportunity	AdditionalInformationText	additional_information.text			(Not sure, maybe not shown?)
21	Grants.gov Grant Opportunity	AwardCeiling	award.ceiling	Award Ceiling	Award Financial assistance that provides support or stimulation to accomplish a public purpose. Awards include grants and other agreements in the form of money or property in lieu of money, by the federal government to an eligible recipient. The term does not include: technical assistance, which provides services instead of money; other assistance in the form of loans, loan guarantees, interest subsidies, or insurance; direct payments of any kind to individuals; and contracts which are required to be entered into and administered under federal procurement laws and regulations.	General Information -> Award Ceiling
22	Grants.gov Grant Opportunity	AwardFloor	award.floor	Award Floor	(See above)	General Information -> Award Floor
23	Grants.gov Grant Opportunity	ExpectedNumberOfAwards	award.expected_number_of_awards		(See above)	General Information -> Expected Number of Awards
24	Grants.gov Grant Opportunity	EstimatedTotalProgramFunding	award.estimated_total_program_funding			General Information -> Estimated Total Program Funding
25	Grants.gov Grant Opportunity	AgencyName	agency.name		Federal agency means an ‘‘agency'' as defined at 5 U.S.C. 551(1) and further clarified by 5 U.S.C. 552(f).	Additional Information -> Agency Name
26	Grants.gov Grant Opportunity	AgencyCode	agency.code	Agency Code	(See above)	(Not shown, corresponds to AgencyName)
27	Grants.gov Grant Opportunity	GrantorContactText	grantor.text		A user registered on behalf of their federal grant-making agency to post funding opportunities or manage submissions to these funding opportunities.	Additional Information -> Grantor Contact Information
28	Grants.gov Grant Opportunity	GrantorContactEmail	grantor.email.address		(See above)	Additional Information -> Grantor Contact Information
29	Grants.gov Grant Opportunity	GrantorContactEmailDescription	grantor.email.description		(See above)	Additional Information -> Grantor Contact Information
30	Grants.gov Grant Opportunity	GrantorContactPhoneNumber			(See above)	Additional Information -> Grantor Contact Information
31	Grants.gov Grant Opportunity	CFDANumbers	cfda_numbers.<list>	Cfda List	A user registered on behalf of their federal grant-making agency to post funding opportunities or manage submissions to these funding opportunities.	General Information -> CFDA Number(s)
32	FFIS.org	(Parsed from spreadsheet)	bill	Bill	Piece of legislation that funds this grant opportunity. Not part of the official Grants.gov data set.	(Not shown) Sometimes indicated by General Information -> Category of Funding Activity
33	USDR	N/A	revision.id, revision.timestamp		Internal value, generated whenever a grant record is created/updated from a source provider.	(Not shown, maintained by USDR)
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100