| Agency |
| Department of Agriculture |
| Department of Commerce |
| Department of Defense* |
| Department of Education |
| Department of Energy |
| Department of Health and Human Services |
| Department of Homeland Security |
| Department of Housing and Urban Development |
| Department of Justice |
| Department of Labor |
| Department of State |
| Department of the Interior |
| Department of the Treasury |
| Department of Transportation |
| Department of Veterans Affairs |
| Environmental Protection Agency |
| General Services Administration |
| NASA |
| Nuclear Regulatory Commission |
| National Science Foundation |
| Office of Personnel Management |
| Small Business Administration |
| Social Security Administration |
| U.S. Agency for International Development |
| All other agencies** |
| |
Recipient Definition
Federal Assistance Awards Data System does not have any data fields that define a single recipient of
assistance across multiple records (i.e., one entry that would list multiple
awards for the same recipient). Clearly, this would be convenient, since it
would be useful to look up a single recipient and find out the total assistance
for any given year. |
| |
| Therefore, USAspending.gov has created its own recipient ID based on the following steps:
first, the name of the recipient in each Federal Assistance Awards Data System records is regularized by discarding some
punctuation, removing words like "Co." or "Inc.", and
standardizing certain abbreviations. Then, all records with the same
regularized recipient name and recipient state are assumed to belong to the
same recipient. A single overall recipient name is chosen for this group of
records, based on the most commonly occurring name within the un-standardized
recipient names for the group. |
| |
| This method of grouping records by recipient name and state has some
disadvantages. It may, for instance, treat a multi-state recipient as being
more than one entity, thereby listing the same group twice in different states,
or it may group unrelated entities together that happen to have the same name
within the same state. But, the advantages of a common recipient name to enable
aggregate totals across records outweigh the problems. |
| |
| As a final step, the names of many recipients were standardized from the
original federal data. State agencies, for instance, now begin with the name of
the state fully spelled out. So the original recipient name of NC ST DEPARTMENT
OF HEALTH & HUMAN SERVIC, for example, was changed to NORTH CAROLINA DEPT
OF HEALTH & HUMAN SERVICES. This should make searches easier and subtotals
more meaningful. |
USAspending.gov recipient category |
Federal Assistance Awards Data System recipient type |
government |
state government |
government |
county government |
government |
city or township government |
government |
special district government |
government |
independent school district |
higher ed |
State controlled institution of higher education |
government |
Indian tribe |
nonprofit |
other nonprofit |
higher ed |
private higher education |
individual |
individual |
for profit |
profit organization |
for profit |
small business |
other |
all other |
USAspending.gov assistance category |
Federal Assistance Awards Data System assistance type |
| grants and co-op. agreements |
block grant |
| grants and co-op. agreements |
formula grant |
| grants and co-op. agreements |
project grant |
| grants and co-op. agreements |
cooperative agreement |
| direct payments (both specified and unspecified) |
direct payment for specified use, as a subsidy or other
non-reimbursable direct financial aid |
| loans (both direct and guaranteed) |
direct loan |
| loans (both direct and guaranteed) |
guaranteed/insured loan |
| insurance |
insurance |
| direct payments (both specified and unspecified) |
direct payment with unrestricted use (retirement, pension,
veterans benefits, etc.) |
| other |
other reimbursable, contingent, intangible, or indirect
financial assistance |
Parent Company Definition
The most basic task that many users want to accomplish is to look up a
particular contractor and find out which contracts they have received. This
makes the most sense if done by parent company -- the entity that owns multiple
divisions, "doing business as" names, or subsidiaries that may show up as
individual contractor names. |
| |
| The Federal Procurement Data System includes limited information on parent company identity. Therefore, USAspending.gov utilizes parent company information provided by Dun & Bradstreet. Where a search on this site groups together records by parent company, or when a user searches by parent company name, they are using parent company names and parent DUNS Numbers as supplied by Dun & Bradstreet. |
| |
| There may exist some errors in these parent company assignments, so that transaction records that really apply to different contractors are grouped together. In cooperation with Duns & Bradstreet, we will periodically fix any such errors that are brought to our attention. |
| |
Competition Category
There are five data fields in Federal Procurement Data System that are useful for assessing the level of
competition of a contract: the Extent Competed, Reason Not Competed,
Number of Offers Received, Statutory Exception to Fair Opportunity,
and Type of Set Aside. USAspending.gov has combined information from all
five of these fields into one overall summation of the amount of competition
for each transaction, called the competition category. More specific
"transactions" are summed by these new competition categories in
various tables. |
| |
| Transactions were classified as follows. "Full and open"
competition means that all responsible sources (or potential contractors) are
permitted to compete. Those with Extent Competed indicating full and open
competition or competitive delivery order were provisionally put in the full
and open competition category. "Full and open with at least one
exclusion" includes competitions in which a certain sources are not
permitted to compete. "Exclusive competitions" can happen only if
certain conditions are met. Transactions were removed from this category that
had a reason for non-competition, a statutory exception to fair opportunity, or
a set-aside and added to the "competition after exclusion of sources"
category. Those remaining in the full and open competition category that had
zero or one offers were moved to a category of full and open competition with
only one bid. The other noncompetition categories are modeled from Federal Procurement Data System Extent
Competed values. "Follow-on contract" is a contract that continues
the funding stream and obligations of a contract that has already been issued. |
| The table below shows how USAspending.gov streamlines Federal Procurement Data System competition
categories: |
| Federal Procurement Data System 'Extent Competed' Description |
USAspending.gov Competition Category |
Exceptions |
| Full and Open Competition (A) |
Full and open competition |
- Records with a reason for non competition, statutory exception to fair opportunity, or set-aside are moved to "Competed After Exclusion"
- Records with zero or one offers are moved to Full and Open Competition but only One Bid
|
| Competitive Delivery Order (CDO) |
| Full and Open Competition (A) |
Full and open competition, but only one bid |
Includes only Full and Open Competition records with zero or one offers. |
| Full and Open Competition after exclusion of sources (D) |
Competed after exclusion of sources |
None |
| Competed under Simplified Acquisition Threshold (F)
|
| Not Competed (C)
|
Not competed |
None |
| Not Competed under SAT (G) |
| Non Competitive Delivery Order (NDO) |
| Not Available for Competition (B) |
Not Available for Competition |
None |
| Follow On to Competed Action (E) |
Follow-on to previous contract |
None |
| Data Field | Description | Field Type |
|---|
| Dollars Obligated | The net dollar amount that is obligated or de-obligated by this transaction. If the net is a de-obligation, the amount will be negative. | double(18,2) |
| Current Contract Value | The contract value in dollars for the base contract and any options that have been exercised. For a new award, this is a total; for a modification, it is a change in value (positive or negative). | double(18,2) |
| Ultimate Contract Value | The total contract or order value in dollars including all options (if any). For IDVs, the estimated value for all orders expected to be placed against the vehicle. For modifications, the change (positive or negative) in the total contract value. | double(18,2) |
| Data Field | Description | Field Type |
|---|
| Major Agency | The original Federal Procurement Data System contracting agency code, modified by USAspending.gov to show the major agency giving out the contract. Major agencies are usually departments of the government. All minor agencies are listed within a general category. | char(2) |
| Modified Contracting Agency | The contracting agency code, as modified by USAspending.gov to replace disused agency codes with current ones. | varchar(4) |
| Contracting Agency | A code for the governmental agency or bureau that executed or is otherwise responsible for the transaction. | varchar(4) |
| Contracting Office | The agency supplied code for the contracting office that executes the transaction. | varchar(6) |
| Program / Funding Agency | A code for the agency that provided the preponderance of the funds obligated by this transaction. If left blank, defaults to Contracting Agency. | varchar(4) |
| Program / Funding Office | The agency provided code that identifies the office that provided the preponderance of funds. If the Funding Agency is a DoD agency, the code is the DoD Activity Address Code (DODAAC). | varchar(6) |
| Reason For Purchase For DoD | A code that indicates why a civilian agency made a purchase for DoD. | char(1) |
| Funded by Foreign Government or International Org. | Indicates that a foreign government, international organization, or foreign military organization bears some of the cost of the acquisition. | char(1) |
| Program Source/Treasury Account Symbol: Agency Code | Agency Code part (First 2 characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(2) |
| Program Source/Treasury Account Symbol: Account Code | Account Code part (3rd to 6th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(4) |
| Program Source/Treasury Account Symbol; Sub-Account Code (OPTIONAL) | Sub-Account Code part (7th to 9th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(3) |
| Data Field | Description | Field Type |
|---|
| Date Signed | The date that a mutually binding agreement was reached. The date signed by the Contracting Officer or the Contractor, whichever is later. | date |
| Effective Date | The date that the parties agree will be the starting date for the contract's requirements. Usually, this is the same as the date signed, but may be different. | date |
| Current Completion Date | The current expected or scheduled contract completion date, based on the initial schedule, any options exercised at the time of the award, and any modifications made later. | date |
| Ultimate Completion Date | The estimated or scheduled completion date including the base contract or order and all options (if any) whether the options have been exercised or not. Defaults to be the same as the Current Completion Date. | date |
| Award Type | The type of award for this record. Types of awards include Purchase Orders (PO), Delivery Orders (DO), BPA Calls and Definitive Contracts. | char(1) |
| Reason For Modification | Code for the type of modification to an award or IDV performed by this transaction. | char(1) |
| Type of Contract Pricing | The type of contract as defined in FAR Part 16 that applies to this procurement. Can be fixed price, cost plus, labor hours, etc. | char(1) |
| Letter Contract | Indicates whether the award is a Letter Contract. | char(1) |
| Multi-Year Contract | Indicates whether this is a multi-year contract, a contract for the purchase of supplies or services for more than 1, but not more than 5, program years. Such contracts are issued under specific congressional authority for specific programs. | char(1) |
| Performance-Based Service Contract | Indicates whether the contract is a Performance-Based Service Acquisition (PBSA) as defined by FAR 37.601. A PBSA describes the requirements in terms of results rather than the methods of performance of the work and has other detailed requirements. | char(1) |
| Major Program | The agency determined code for a major program within the agency. For an Indefinite Delivery Vehicle, this may be the name of a GWAC (e.g., ITOPS or COMMITS). | varchar(100) |
| Contingency, Humanitarian, or Peacekeeping Operation | Indicates contract actions that exceed $200,000 and support a contingency operation, a humanitarian operation, or a peacekeeping operation. | char(1) |
| Cost or Pricing Data DoD | Indicates whether cost or pricing data was obtained, not obtained, or waived for DoD assigned contracts. | char(1) |
| Contract Financing | Type of financing used to effect payment (progress payments, advance payments, etc.). | char(1) |
| Cost Accounting Standards Clause | Indicates whether the contract includes a Cost Accounting Standards clause. | char(1) |
| Contract Description | A brief description of the goods or services bought (for an award) or that are available (for an IDV). | text |
| Purchase Card As Payment Method | Indicates whether the method of payment under an award is the Purchase Card. Agencies may issue formal contract documents and make payment using the Purchase Card. It is also permitted that agencies may report Purchase Card purchases. | char(1) |
| Number of Actions | The number of actions that involved contract modifications for additional supplies or services. Can be reported for new contracts or contract modification transactions. Data fields exists in XML schema version 1.2 and later only. | int(11) |
| National Interest Action | Code for contracts created in response to "national interests" (e.g. Hurricane Katrina, Hurricane Rita). Note: data field only exists in XML schema version 1.2 and later. | varchar(4) |
| Data Field | Description | Field Type |
|---|
| Vendor Name | The name of the vendor supplying the product or service as it appears in CCR or as entered by the user if CCR exception is selected. | varchar(100) |
| Vendor Alternate Name | An alternate name for the vendor. | varchar(255) |
| Vendor Legal Organization Name | The legal organizational name of the vendor. | varchar(120) |
| Vendor Doing Business As Name | The doing as business name of the contractor address. | varchar(80) |
| Vendor Name from Contract | The name of the contractor supplying the product or service as it appears on the contract. | varchar(80) |
| Best Vendor Name | A single name chosen as the vendor name by USAspending.gov. The name is the fist valid-appearing one from the following data fields in order: vendor Name, legal name, dba name, alternate name, vendor name from contract, parent company name. | varchar(120) |
| Best Vendor Name Type | A code showing which of the six name fields provided the best vendor name for this record. | char(1) |
| Division Name | The division name for the division of the vendor contracted. Usually taken from the CCR (Central Contractor Registry). | varchar(60) |
| Division Number or Office Code | Unknown meaning. | varchar(10) |
| Vendor Enabled | Not known. | char(1) |
| Vendor Location Disable Flag | Unknown meaning. | char(1) |
| CCR Exception | Indicates and gives the reason why a vendor/contractor not registered in the mandated Central Contractor Registry (CCR) system may be used in a purchase. Data field only exists in XML schema version 1.1 and later. | char(1) |
| Vendor Address Line 1 | The first line of the street address for the contractor. | varchar(55) |
| Vendor Address Line 2 | The second line of the street address for the contractor. | varchar(55) |
| Vendor Address Line 3 | The third line of the street address for the contractor. | varchar(55) |
| Vendor Address City | The city of the contractor address. | varchar(35) |
| Vendor Address State | The state in the contractor address. | char(2) |
| Vendor Zip Code | The zip code in the contractor address. | varchar(10) |
| Vendor Country | The country code in the contractor address -- a three-letter abbreviation rather than the FIPS country code. | varchar(20) |
| Vendor Congressional District (Modified) | The Congressional District that the vendor's address falls within, in the form of a two-letter state abbreviation plus a two-digit number, as modified by USAspending.gov. | varchar(4) |
| Vendor Congressional District | The Congressional district of the contractor, as derived from the Zip+4 in the contractor address. | varchar(6) |
| Vendor Site Code | Unknown meaning. Apparently not FIPS codes. | varchar(15) |
| Vendor Alternate Site Code | Unknown meaning. Apparently not FIPS codes. | varchar(15) |
| Vendor DUNS Number | The Dun & Bradstreet number of the vendor. This is used to link records to the Central Contractor Registry (CCR) and only exists for vendors in the CCR. | varchar(13) |
| Parent DUNS Number | The Dun & Bradstreet number of the common parent of the affiliated group if the contractor receiving the award is a member of an affiliated group of corporations that files its federal income tax returns on a consolidated basis. | varchar(13) |
| Vendor Phone Number | The phone number of the contractor. | varchar(20) |
| Vendor Fax Number | The fax number of the contractor. | varchar(20) |
| CCR Registration Date | Date the initial registration for the contractor was submitted to the CCR (Central Contractor Registry). | date |
| CCR Renewal Date | Date the contractor's registration in the CCR (Central Contractor Registry) will expire. | date |
| Parent ID | A unique ID assigned by USAspending.gov to each parent company, so that records can be grouped by parent company. Information defining which parent companies apply to which data records was supplied by Eagle Eye. | bigint(20) |
| Parent Company Name | Eagle-Eye provided data field. The parent company for the vendor, as supplied by Eagle Eye and in some cases modified by USAspending.gov. | varchar(100) |
| Data Field | Description | Field Type |
|---|
| Place Congressional District (Modified) | The Congressional District which was the primary place of performance for the contract (i.e. where the work took place) expressed as a two-letter state abbreviation plus a two-digit number, as modified by Eagle Eye and USAspending.gov. | varchar(4) |
| Place of Performance Code | The code from the combined FIPS Pub. 10 and FIPS Pub. 55 that identifies the place where the work is being performed. | varchar(5) |
| Place of Performance State | The U.S. state that is the principal place where the work was / is performed. | char(2) |
| Place of Performance Country | The country that is the principal place where the work was / is performed. | char(3) |
| Place of Performance Zip Code | The Zip code of the principal place where the work was / is performed. Data field exists only in XML schema version 1.2 and later. | varchar(10) |
| Place of Performance Cong. District | The Congressional district that is the principal place in which the work was / is performed. | varchar(6) |
| Data Field | Description | Field Type |
|---|
| Major Product or Service Code | The major category that the Federal Procurement Data System Product or Service Code for the record falls within. Data field created by USAspending.gov. | char(2) |
| Product or Service Code | The code that best identifies the product or service procured. If more than one code applies, then the code that represents most of the ultimate contract value is reported. | varchar(4) |
| DoD Program, System, or Equipment Code | Two codes that identify the program and weapons system or equipment purchased by a DoD agency. The first character is a number 1-4 that identifies the DoD component. The last 3 characters identify that component's program, system, or equipment. | varchar(4) |
| DoD Claimant Program Code | A claimant program number designates a grouping of supplies, construction, or other services. This data field may have a code from the DoD Procurement Coding Manual Section III, DoD Claimant Program Number. | char(3) |
| Principal NAICS Code | The principal North American Industry Classification System (NAICS) code (used to designate major sectors of the economies of Mexico, Canada, and the United States) that indicates the industry in which the contractor does business. | varchar(6) |
| Information Technology Commercial Item Category | A code that designates the commercial availability of an information technology product or service. | char(1) |
| Govt. Furnished Equipment or Property | Indicates whether Government Furnished Equipment (GFE) or Government Furnished Property (GFP) used for the contract, pursuant to FAR 45. |
| Use of EPA Designated Products | Indicates whether EPA approved products with a minimum recovered material content were used, or whether an exception was made. | char(1) |
| Recovered Material Clauses | Indicates whether Recovered Material Certification and/or Estimate of Percentage of Recovered Material Content for EPA-Designated Products clauses were included in the contract. | char(1) |
| Sea Transportation | Indicates whether the contractor anticipates that some of the supplies may be transported by sea. | char(1) |
| Contract Bundling Reason | Indicates that the value of the contract, including all options, is expected to exceed $5M as a result of consolidating separate small contracts into a single contract likely to be unsuitable for a small business concern, and the reason for bundling. | char(1) |
| Consolidated Contract | Indicates whether the contract is a consolidated contract. This is only required if the Funding Agency or the contracting agency is a DoD Agency. Data field exists in XML schema version 1.2 and later only. | char(1) |
| Product Country of Origin | Identifies the country of origin of the product. | char(2) |
| U.S. Contract | When product has substantial foreign components or services are performed by foreign entities, this field indicates whether the contract is still technically a U.S. contract. | char(1) |
| Data Field | Description | Field Type |
|---|
| Identifying Agency ID | This is a code for a governmental agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves only as part of the unique identification for Federal Procurement Data System awards records. | varchar(4) |
| Procurement Instrument ID | A unique ID for each contract, agreement, or order. It is not a unique ID for Federal Procurement Data System records, since there can be more than one record for each contract, agreement, or order. | varchar(50) |
| Modification Number | An identifier that uniquely identifies a modification for a contract, agreement, or order. | varchar(25) |
| Transaction Number | Unique identifier for each transaction for a contracting action or modification. There can be more than one in situations such as when an action includes more than one contract type. | varchar(6) |
| Fiscal Year | The federal government fiscal year (starting September 1) in which the award or IDV record was reported. | smallint(6) |
| IDV Agency ID | This is a code for an agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves as part of the unique identification for Federal Procurement Data System IDV records. For awards records, it partially identifies a linked IDV record. | varchar(4) |
| IDV Procurement Instrument ID | For an IDV record, this is a unique identifier for each contract, agreement, or order. For awards records, it partially identifies a linked IDV record. | varchar(50) |
| IDV Modification Number | For IDV records, uniquely identifies the modification of the contract, agreement, or order. For awards records, it partially identifies a linked IDV record. | varchar(25) |
| Solicitation ID | Identifier used to link transactions to solicitation information. | varchar(25) |
| XML Schema Version | The version of the XML schema (i.e., the data format) used to transmit the data record. XML formats before 1.2.1 do not include all data fields. | varchar(10) |
| Created By | An identifier for the person or role that created the Federal Procurement Data System record. | varchar(50) |
| Created Date | The date on which the Federal Procurement Data System record was created. | date |
| Last Modified By | An identifier for the person or role at an agency who last modified the Federal Procurement Data System record (does not include modifications by Federal Procurement Data System staff). | varchar(50) |
| Last Modified Date | The date on which this Federal Procurement Data System record was last modified by someone at an agency (does not include modifications by Federal Procurement Data System staff). | date |
| Federal Procurement Data System Record Status | Equals F for Final for all records available to the public. | char(1) |
| Data Field | Description | Field Type |
|---|
| Competition Category | The Extent Competed field, with code values regrouped into broader categories by USAspending.gov. Indicates whether the contract was competed or not. | char(1) |
| Extent Competed | A code that represents how the contract was competed. | char(3) |
| Reason Not Competed | A code for the reason the contract was not competed -- i.e., solicitation procedures other than full and open competition pursuant to FAR 6.3. | char(3) |
| Number of Offers Received | The number of actual offers/bids received in response to the solicitation. | smallint(6) |
| Pre-award Synopsis Requirement | Indicates whether the synopsis requirements of FAR Subpart 5.2 were followed. | char(1) |
| Synopsis Waiver Exception | Indicates participation in the SBA/OFPP Pilot Program that allows for waiver of the synopsis requirement in the FAR Subpart 5.2 when agencies acquire services with an anticipated value between $25,000 and $100,000 using small businesses set-asides. | char(1) |
| Alternative Advertising | Indicates whether the contracting officer used methods to advertise the requirement other than the advertising that is required by FAR 5.201 (currently, by using FedBizOpps). | char(1) |
| Commercial Item Acquisition Procedures | Indicates whether the solicitation used the special requirements for the acquisition of commercial items intended to more closely resemble those customarily used in the commercial marketplace as defined by FAR Part 12. | char(1) |
| Commercial Item Test Program | Indicates whether the solicitation used Commercial Item Acquisition Procedures (FAR Part 12) and Simplified Acquisition Procedures (FAR Part 13.5) for acquisitions above the Simplified Acquisition Threshold and below $5,000,000. | char(1) |
| Small Business Compet. Demonstration Program | Indicates whether the contract was awarded to a U.S. business concern as a result of a solicitation issued on or after Jan 1, 1989 as part of the Small Business Competitiveness Program (FAR Part 19.10). | char(1) |
| A-76 (FAIR Act) Action | Indicates whether the contract action resulted from an A-76/Fair Act competitive sourcing process. | char(1) |
| Competitive Procedures | Data fields not extensively used in production and since disused, do not display. | char(3) |
| Solicitation Procedures | A code for the type of solicitation procedures used. Data field exists only in XML schema version 1.2 and later. | varchar(5) |
| Type of Set Aside | A code for the type of set aside determined for the contract action. Data field exists only in XML schema version 1.2 and later. | varchar(10) |
| Evaluated Preference |
The type of preference determined for the contract action, reported when a contract was made pursuant to the socioeconomic program price evaluation preferences -- FAR 19.11 and FAR 19.13. Data field exists only in XML schema version 1.2 and later. |
varchar(6) |
| Type of Research | A code used when the contract was awarded as part of a Small Business Innovation Research or Small Technology Transfer Research Program. Data field exists only in XML schema version 1.2 and later. | char(3) |
| Statutory Exception To Fair Opportunity | A code indicating a statutory exception to Fair Opportunity, used awarding a non competitive task order or delivery order exceeding $2500.00 against an IDIQ contract. Data field exists only in XML schema version 1.2 and later. | char(3) |
| Data Field | Description | Field Type |
|---|
| Fee Paid For Use of IDV | Actual fee paid, in dollars, in order to use the IDV. | double(18,2) |
| Data Field | Description | Field Type |
|---|
| Organizational Type | A code for the type of organization of the vendor. | varchar(30) |
| Number of Employees | The contractor's business size in terms of number of employees. Usually obtained from the CCR (Central Contractor Registry). | int(11) |
| Annual Revenue | The contractor's annual gross revenue, taken from an average of the last three years. Usually obtained from the CCR (Central Contractor Registry). | double |
| Small Business | Indicates whether the vendor is a small business. | char(1) |
| 8A Firm | Indicates whether the vendor is an 8(a) Program Participant Organization. | char(1) |
| Hist. Underutilized Business Zone (HUBZone) Firm | Indicates whether the vendor is a Historically Underutilized Business Zone (HUBZone) Firm. | char(1) |
| Small Disadvantaged Business | Indicates whether the vendor is a Small Disadvantaged Business Organization. | char(1) |
| Sheltered Workshop (JWOD Provider) | Indicates whether the vendor is a Sheltered Workshop (JWOD Provider) Organization. | char(1) |
| Historically Black College or University | Indicates whether the vendor is a Historically Black College or University. | char(1) |
| Educational Institution | Indicates whether the vendor is an Educational Institution. | char(1) |
| Woman Owned Business | Indicates whether the vendor is a Woman Owned Business. | char(1) |
| Veteran Owned Business | Indicates whether the vendor is a Veteran Owned Business. | char(1) |
| Service Disabled Veteran Owned Firm | Indicates whether the vendor is a Service-Related Disabled Veteran Owned Business. | char(1) |
| Local Government | Indicates whether the vendor is a Local Government Organization. | char(1) |
| Minority Institution | Indicates whether the vendor is a Minority Institution. | char(1) |
| American Indian Owned Business | Indicates whether the vendor is an American Indian Owned Business. | char(1) |
| State Government | Indicates whether the vendor is a State Government Organization. | char(1) |
| Federal Government | Indicates whether the vendor is a Federal Government Organization. | char(1) |
| Minority Owned Business | Indicates whether the vendor is a Minority Owned Business. | char(1) |
| Asian-Pacific American Owned Business | Indicates whether the vendor is an Asian-Pacific American Owned Business. | char(1) |
| Tribal Government | Indicates whether the vendor is a Tribal Government Organization. | char(1) |
| Black American Owned Business | Indicates whether the vendor is a Black American Owned Business. | char(1) |
| Native American Owned Business | Indicates whether the vendor is a Native American Owned Business. | char(1) |
| Subcontinent Asian (Asian-Indian) American Owned Business | Indicates whether the vendor is a Subcontinent Asian (Asian- Indian) American Owned Business. | char(1) |
| Nonprofit Organization | Indicates whether the vendor is a Nonprofit Organization. | char(1) |
| Hispanic American Owned Business | Indicates whether the vendor is a Hispanic American Owned Business. | char(1) |
| Emerging Small Business | Indicates whether the vendor is an Emerging Small Business. | char(1) |
| Hospital | Indicates whether the vendor is a Hospital. | char(1) |
| Data Field | Description | Field Type |
|---|
| Walsh-Healy Act | Indicates whether the transaction is subject to the Walsh-Healy Act (designed to prevent "bid brokering"). | char(1) |
| Service Contract Act | Indicates whether the transaction is subject to the Service Contract Act (concerning payment of prevailing wage rates and fringe benefits to service employees). | char(1) |
| Davis-Bacon Act | Indicates whether the transaction is subject to the Davis-Bacon Act (concerning the payment of prevailing wages on public works projects). | char(1) |
| Clinger-Cohen Act | Indicates the funding office has certified that the information technology purchase meets the planning requirements in 40 USC 1422 and 1423. | char(1) |
| Other Statutory Authority | Indicates whether the transaction is subject to other statutory authority (i.e., legislation other than the Economy Act). | text |
| Data Field | Description | Field Type |
|---|
| Business Size Determination | The Contracting Officer's determination of whether the contractor meets the small business size standard for award to a small business for the NAICS code that is applicable to the contract. | char(1) |
| Subcontracting Plan | A code for a type of subcontracting plan requirement (FAR Part 19.702). | char(1) |
| Price Evaluation Percent Difference | The percent difference between the award price and the lowest priced offer from a responsive, responsible non-HUBZone or non-SDB. | char(2) |
| Reason Not Awarded to Small Disadvantaged Business | If contract was not awarded to a Small Disadvantaged Business (SDB), this designates the reason. | char(1) |
| Reason Not Awarded to Small Business | If contract was not awarded to a small business, this designates a reason. | char(1) |
| Data Field | Description | Field Type |
|---|
| Recipient Name | The name of the recipient of the award. | varchar(45) |
| Recipient City Code | The five-digit FIPS city code for the city in the address of the recipient of the award. | varchar(5) |
| Recipient City Name | The city in which the address of the recipient of the award is located. | varchar(21) |
| Recipient County Code | The three-digit FIPS county code for the county in which the address for the recipient of the award is located. | char(3) |
| Recipient County Name | The county in which the address for the recipient of the award is located. | varchar(21) |
| Recipient State Code | The two-digit FIPS state code for the state or territory in which the address for the recipient of the award is located. | char(2) |
| Recipient State Name | The name of the state or territory in which the address for the recipient of the award is located. | varchar(25) |
| Recipient Zip Code | The Zip code in the address of the recipient of the award. | varchar(9) |
| Congressional District | The Congressional District of the recipient, modified by USAspending.gov to fix some bad data and to use a 2-letter state followed by 2 digit format. 90 means not known, 00 means at large or statewide, 98 means nonvoting, 99 means no representative. | varchar(4) |
| Recipient Congressional District | The Congressional district in which the address of the recipient of the award is located. 90 indicates district not known, 00 at-large or statewide, 98 nonvoting, 99 no representative. | char(2) |
| Recipient Category | The original Federal Assistance Awards Data System recipient type code, modified by USAspending.gov into a set of broader categories (government, individual, nonprofit, for profit, higher ed, other). | char(1) |
| Recipient Type | The type of recipient (i.e., state government, local government, Indian tribe, individual, small business, for-profit, nonprofit, etc.) | char(2) |
| Recipient Address Line 1 | Recipient 's Full address Line 1 | char(35) |
| Recipient Address Line 2 | Recipient 's Full address Line 2 | char(35) |
| Recipient Address Line 3 | Recipient 's Full address Line 3 | char(35) |
| Recipient DUNS Number | Unique nine-digit number issued by Dun & Bradstreet to the Agency. Followed by optional DUNS Plus 4 which allows an agency to submit different bank account data for a single DUNS (Assigned by Dun & Bradstreet) | char(13) |
| Dun & Bradstreet Confidence Code | Optional data field to enter the D&B Confidence Code received for validated DUNS data (As provided to agencies by Dun & Bradstreet when obtaining DUNS). OMB encourages Agencies to submit this code with their file submissions to affirm the accuracy of data validated through the D&B process. | char(2) |
| Data Field | Description | Field Type |
|---|
| Major Agency | The original Federal Assistance Awards Data System agency code, modified by USAspending.gov to show the major agency giving out the award. Major agencies are generally departments of the government. All minor agencies are listed within a general category. | char(2) |
| Agency Code | A code indicating which governmental agency or bureau provided the award. | varchar(4) |
| Agency Name | The name of the governmental agency or bureau that provided the award. | varchar(72) |
| Federal Award ID | An agency-specific unique ID number for each individual assistance award. There may be more than one action record per assistance award, because of continuations, revisions, funding adjustments, corrections, etc. | varchar(16) |
| Federal Award ID Modification | A modification number used to indicate action records that modify a previous action record with the same federal award ID. | varchar(4) |
| State Application ID Number | A number assigned by state (as opposed to federal) review agencies to the award during the grant application process. | varchar(20) |
| CFDA Program Number | The numeric code that indicates the program under which this award was funded within the Catalog of Federal Domestic Assistance (CFDA). Numbers that contain AAA, AAB etc. are pseudo-codes and are not in CFDA. | varchar(7) |
| CFDA Program Title | The title of the program under which the award was funded, taken from the Catalog of Federal Domestic ASsistance (CFDA). | varchar(74) |
| Assistance Category | The original Federal Assistance Awards Data System assistance type code, modified by USAspending.gov into a set of broader categories (direct grants, loans, insurance, etc.) | char(1) |
| Assistance Type | The type of assistance provided by the award: whether it is a grant, cooperative agreement, direct payment, loan, insurance, etc. | char(2) |
| Program Source/Treasury Account Symbol: Agency Code | Agency Code part (First 2 characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(2) |
| Program Source/Treasury Account Symbol: Account Code | Account Code part (3rd to 6th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(4) |
| Program Source/Treasury Account Symbol; Sub-Account Code (OPTIONAL) | Sub-Account Code part (7th to 9th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury | varchar(3) |
| Data Field | Description | Field Type |
|---|
| Fiscal Year |
The fiscal year in which the award occurred. It may be different from the fiscal year of the award record if the record is a late filing or correction of an amount for a prior fiscal year. Data field added by USAspending.gov. |
smallint(6) |
| Fiscal Year / Quarter | The fiscal year and fiscal year quarter for this record, with the first four digits being the year, the fifth the quarter. | varchar(5) |
| Action Type | The type of action for the record: whether it is a new assistance action, a continuation, a revision, or a funding adjustment. | char(1) |
| Federal Funding Amount | Amount of federal government's obligation or contingent liability, in dollars. A negative number represents a decrease in funding. | int(11) |
| Non-Federal Funding Amount | Amount of non-federal funding, in dollars. A negative number represents a decrease in funding. | int(11) |
| Total Funding Amount | The total federal plus non-federal funding amount in dollars. A negative number represents a decrease in funding. | int(12) |
| Face Value of Direct Loan/Loan Guarantee | The face value of the direct loan or loan guarantee | bigint(16) |
| Original Subsidy Cost of the Direct Loan/Loan Guarantee | The original subsidy cost of the direct loan or loan guarantee | bigint(16) |
| Obligation / Action Date | Obligation or action date for the award. | date |
| Starting Date | The starting date for the award. | date |
| Ending Date | The ending date for the award. | date |
| Record Type | Federal Assistance Awards Data System record type: 1 = county aggregate record, 2 = individual action record | char(1) |
| Correction / Late Indicator | Indicates that the action record is either a correction of a record from a previous quarter or a late reported record from a previous quarter. The previous quarter is indicated in the Corrected Fiscal Year / Quarter data field. | char(1) |
| Corrected Fiscal Year / Quarter | The fiscal year (first four digits) and quarter (fifth digit) of the previous fiscal year and quarter that this record corrects, or which it is a late report for. | varchar(5) |
| Data Field | Description | Field Type |
|---|
| Principal Place Code | A code for the principal place of performance for the award. The first two digits are the state FIPS code, the next five the county FIPS (three digits followed by **) or city FIPS code. 00***** = multi-state, 00FORGN = foreign country. | varchar(7) |
| Principal Place State | The state or territory name of the principal place of performance for the award. | varchar(25) |
| Principal Place County or City | The city or county name of the principal place of performance for the award. | varchar(25) |
| Principal Place of Performance Zip Code | The 9 digit zipcode (zip+4) of the principal place of performance for the award. | varchar(9) |
| Principal Place of Performance Congressional District | The Congressional District of the principal place of performance for the award. | varchar(2) |
PRINTER-FRIENDLY
