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.