OTIDVs Data Dictionary¶

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

Overview¶

OTIDVs (Other Transaction IDVs) are indefinite-delivery Other Transaction vehicles. OTIDVs 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/otidvs/{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¶

OTIDV 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 OTIDV 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	OTIDV description/title.	FPDS
`idv_type`	Object	IDV type.	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
`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
`transactions`	Array	Modification/transaction records. Use expansion for same fields as contracts.	FPDS

Expansions (via `shape`)¶

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

Data Sources¶

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

Usage Notes¶

Use key for API references. Use piid for FPDS lookups.
Child awards: Use /api/otidvs/{key}/awards/ for orders under this OTIDV; see OTIDVs API Reference.

Report an issue with this page