Federal Contracts Data Schema
- id
- Unique record identifier.
- transaction_number
- Unique identifier for the contract transaction.
- fiscal_year
- The year in which the contract was awarded.
- last_modified_date
- The date that this record was last modified.
- piid
- When reporting orders under Indefinite Delivery Vehicles (IDV) such as a GWAC, IDC, FSS, BOA, or BPA, report the Procurement Instrument Identifier (Contract Number or Agreement Number) of the IDV. For the initial load of a BPA under a FSS, this is the FSS contract number. Note: BOAs and BPAs are with industry and not with other Federal Agencies.
- parent_id
- ID of the original contract record identifier.
- award_id
- Award identifier.
- modification_number
- An identifier issued by an agency that uniquely identifies one modification for one contract, agreement, order, etc.
- modification_reason
- Reason for contract modification. http://transparencydata.com/docs/lookup/contracts/mod_reasons/
- agency_name
- The name of the agency awarding the contract.
- agency_id
- FIPS identifier for the agency awarding the contract.
- contracting_agency_name
- The name of the agency responsible for the contracting process.
- contracting_agency_id
- FIPS identifier for the agency responsible for the contracting process.
- contracting_office_id
- Agency specific identifier for the office responsible for the contracting process.
- requesting_agency_name
- The name of the agency requesting the contract.
- requesting_agency_id
- FIPS identifier for the agency requesting the contract.
- requesting_office_id
- Agency specific identifier for the office requesting the contract.
- major_program_code
- The agency determined code for a major program within the agency.
- idv_agency_fee
- The fee charged to the requesting agency by the contracting agency for the cost of the contracting process.
- cotr_name
- The name of the person responsible for overseeing the contracting process.
- cotr_other_name
- The name of an additional COTR involved in the process.
- contract_action_type
- The type of action used to award the contract. http://transparencydata.com/docs/lookup/contracts/action_types/
- contract_bundling_type
- http://transparencydata.com/docs/lookup/contracts/bundling/
- contract_competitiveness
- The level of competition during the contracting process. http://transparencydata.com/docs/lookup/contracts/competitiveness/
- contract_description
- A text description of the purpose and result of the contract.
- contract_financing
- The type of financing that will be used to pay the contractor. http://transparencydata.com/docs/lookup/contracts/financing/
- contract_nia_code
- A code that represents the national interest for which the contract is created. http://transparencydata.com/docs/lookup/contracts/nia_codes/
- contract_nocompete_reason
- The reason the contract was not competed. http://transparencydata.com/docs/lookup/contracts/nocompete_reasons/
- contract_offers_received
- The number of offers/proposals received during the competition process.
- contract_pricing_type
- The type of pricing used to compensate the contractor. http://transparencydata.com/docs/lookup/contracts/pricing_types/
- contract_set_aside
- http://transparencydata.com/docs/lookup/contracts/set_asides/
- subcontract_plan
- The plan the contractor has for using subcontractors. http://transparencydata.com/docs/lookup/contracts/subcontract_plans/
- number_of_actions
- The number input by the agency that identifies number of actions that are reported in one modification.
- consolidated_contract
- True if contract action is consolidated.
- multiyear_contract
- Indicates that the contract is for services or supplies that go beyond 1 year, but less than 5 years.
- performance_based_contract
- Indicates whether the contract is performance based or not. http://transparencydata.com/docs/lookup/contracts/ynx/
- signed_date
- The date that both parties signed the contract.
- effective_date
- The date on which the contract will begin.
- completion_date
- The current completion date for the contract. If options have been executed, this date can be greater than the completion_date on the original record.
- maximum_date
- The date of completion if all contract options are awarded.
- renewal_date
- The date of contract renewal.
- cancellation_date
- The date of cancellation if the contract is ended early.
- obligated_amount
- The amount of money obligated or de-obligated in this transaction.
- current_amount
- The current cost of the contract.
- maximum_amount
- The maximum cost of the contract if all options and extensions are executed.
- price_difference
- The percent difference between the award price and the lowest priced offer from a responsive, responsible non-HUBZone or non-SDB.
- cost_data_obtained
- Whether or not cost data was obtained or waived. http://transparencydata.com/docs/lookup/contracts/cost_obtained/
- purchase_card_as_payment
- Indicates that a purchase card was used to pay the contractor.
- vendor_name
- Name of the contractor.
- vendor_business_name
- Additional name used by the contractor for conducting business.
- vendor_employees
- The number of people employed by the contractor.
- vendor_annual_revenue
- The annual revenue of the contractor.
- vendor_street_address
- Street address of the contractor.
- vendor_street_address2
- Additional street address of the contractor.
- vendor_street_address3
- Additional street address of the contractor.
- vendor_city
- The primary city in which the contractor conducts business.
- vendor_state
- The primary state in which the contractor conducts business.
- vendor_zipcode
- The primary zip code in which the contractor conducts business.
- vendor_district
- The primary congressional district in which the contractor conducts business.
- vendor_country_code
- FIPS code indicating the country in which the contractor operates.
- vendor_duns
- The Dun and Bradstreet identifier for the contractor.
- vendor_parent_duns
- The Dun and Bradstreet identifier for the contractor's corporate parent.
- vendor_phone
- The phone number for the contractor.
- vendor_fax
- The fax number for the contractor.
- vendor_ccr_exception
- The reason a vendor/contractor not registered in the mandated CCR system may be used in a purchase. http://transparencydata.com/docs/lookup/contracts/ccr_exceptions/
- place_district
- The congressional district in which the contract action will be performed.
- place_location_code
- FIPS identifier for the location in which the contract action will be performed.
- place_state_code
- FIPS identifier for the state in which the contract action will be performed.
- product_origin_country
- FIPS identifier for the country of origin for the product being purchased by the contract.
- product_origin
- Indicates the origin of the product being purchased. http://transparencydata.com/docs/lookup/contracts/product_origin/
- producer_type
- Indicates the type and nationality of the manufacturing organization. http://transparencydata.com/docs/lookup/contracts/org_types/
- statutory_authority
- The statutory authority under which the agency is authorized to execute the contract.
- product_service_code
- The code that best identifies the product or service procured. Codes are defined in the Product and Service Codes Manual.
- naics_code
- The North American Industry Classification System (NAICS) codes designate major sectors of the economies of Mexico, Canada, and the United States.
- solicitation_id
- Identifier used to link transactions in FPDS-NG to solicitation information.
- supports_goodness
- A designator of contract actions that support a declared contingency operation, a declared humanitarian operation or a declared peacekeeping operation.
- dod_system_code
- Indicates the DoD system or equipment for which the contract is being awarded.
- it_commercial_availability
- Indicates the commercial availability of the contract being purchased. http://transparencydata.com/docs/lookup/contracts/commercial/
- cas_clause
- http://transparencydata.com/docs/lookup/contracts/ynx/
- recovered_material_clause
- http://transparencydata.com/docs/lookup/contracts/rm_clauses/
- fed_biz_opps
- Indicates whether or not the contract was listed in Fed Biz Opps. http://transparencydata.com/docs/lookup/contracts/ynx/
- government_property
- Indicates whether or not government property will be furnished for the contract.