FPDS Query Library
About Us
Contact Us

Vendor Alternate Site Code

Code identifying an alternate vendor site location recorded for the award. It represents a site-level identifier associated with the vendor’s place of performance, billing, or administrative location when more than one site may exist.

Family: Other Transaction Award
Category: Vendor Site Details
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorAlternateSiteCode
Title
Vendor Alternate Site Code
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorAlternateSiteCode
Description
Code identifying an alternate vendor site location recorded for the award. It represents a site-level identifier associated with the vendor’s place of performance, billing, or administrative location when more than one site may exist.
Business Meaning
This field helps analysts distinguish which vendor location is tied to the transaction when the same vendor has multiple sites. It supports geographic, organizational, and relationship analyses at a more granular level than the vendor record alone, especially for footprint, concentration, and routing questions.
Example Value
94080
Observed Non-Null Count
38,800

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorAlternateSiteCode
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorAlternateSiteCode
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorAlternateSiteCode' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorAlternateSiteCode'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • vendor site-level aggregation
  • location-based spend analysis
  • matching awards to vendor site reference data

Common Mistakes

  • treating the code as a street address or city
  • grouping site codes without checking whether the same vendor uses multiple formats or reference systems

Query Guidance

Use this field as a grouping or join key only when you need site-level granularity. In SQL, filter for non-null values, normalize casing/spacing if needed, and join to a vendor site lookup to resolve the code to a readable site name or address; avoid using it as a proxy for vendor identity at the parent-vendor level.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorAlternateSiteCode AS vendor_alternate_site_code
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorAlternateSiteCode IS NOT NULL
LIMIT 25

Top values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorAlternateSiteCode AS value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorAlternateSiteCode IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.