OTAs Data Dictionary¶

This document describes the fields available in the OTAs API endpoints (/api/otas/). For filtering, ordering, and pagination, see the OTAs API Reference.

Overview¶

OTAs (Other Transaction Agreements) are non-standard procurement instruments. OTAs are sourced from FPDS only.

Identifiers¶

key (canonical): The canonical award identifier derived from FPDS award keys. This is what the API uses for lookups: GET /api/otas/{key}/.
uuid (internal): Tango’s deterministic internal UUID used as the database primary key and for stable internal joins/orderings. This is not intended as a public lookup key.

Note: The full set of fields is available via the shape query parameter. See Response Shaping for details.

Update Frequency¶

OTA data is loaded from FPDS twice daily via the awards ETL pipeline.

Fields¶

Field	Type	Description	Source
`key`	String	Canonical award identifier (FPDS). Used for detail lookups and cross-referencing.	FPDS
`piid`	String	Procurement Instrument Identifier.	FPDS
`award_date`	Date	Date the OTA was awarded.	FPDS
`psc_code`	String	Product/Service Code on the award.	FPDS
`total_contract_value`	Decimal	Total value.	FPDS
`base_and_exercised_options_value`	Decimal	Base plus exercised options.	FPDS
`fiscal_year`	Integer	Federal fiscal year.	FPDS
`obligated`	Decimal	Total obligated amount.	FPDS
`description`	String	OTA description/title.	FPDS
`award_type`	String	Award type code. Expandable to `{code, description}` via `?shape=`.	FPDS
`type_of_ot_agreement`	String	Type of OT agreement code. Expandable to `{code, description}` via `?shape=`.	FPDS
`extent_competed`	String	Extent competed code. Expandable to `{code, description}` via `?shape=`.	FPDS
`consortia`	String	Consortia indicator.	FPDS
`consortia_uei`	String	Consortia UEI.	FPDS
`dod_acquisition_program`	String	DoD acquisition program identifier.	FPDS
`non_governmental_dollars`	Decimal	Non-governmental dollars.	FPDS
`non_traditional_government_contractor_participation`	String	Non-traditional government contractor participation indicator.	FPDS
`parent_award_modification_number`	String	Parent award modification number.	FPDS
`transactions`	Array	Modification/transaction records. Use expansion for same fields as contracts.	FPDS

Expansions (via `shape`)¶

recipient, place_of_performance, parent_award, awarding_office, funding_office, period_of_performance, award_type, type_of_ot_agreement, extent_competed, transactions, psc.

Data Sources¶

FPDS – OTA actions, PIID, dates, values, types.
Tango – Internal deterministic uuid and award materialization.

Usage Notes¶

Use key for API references. Use piid for FPDS lookups.

Report an issue with this page