Influence Explorer

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.