FPDS Query Library
About Us
Contact Us

Fax No

Fax number associated with the vendor location recorded for the award. It identifies the contact fax for that specific site in the Vendor Site Details section, not a government office or contract office.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__faxNo
Title
Fax No
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorLocation/faxNo
Description
Fax number associated with the vendor location recorded for the award. It identifies the contact fax for that specific site in the Vendor Site Details section, not a government office or contract office.
Business Meaning
This field helps analysts characterize vendor contact information at the location level and distinguish among multiple sites tied to the same vendor. It can support entity resolution, outreach validation, and quality checks when analyzing award records, especially where location-specific communication details are relevant.
Example Value
2564898201
Observed Non-Null Count
20,520

FPDS Compare

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

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 location contact profiling
  • Data quality and completeness checks
  • Entity matching and normalization workflows

Common Mistakes

  • Interpreting it as a government or contracting office fax number
  • Casting it to a numeric type and losing leading zeros or formatting

Query Guidance

Select and group this field as a string attribute; normalize punctuation and whitespace before comparison, and use NULL/blank checks to measure completeness. For matching, compare standardized values rather than raw text, and join with vendor location identifiers instead of using fax number alone as a key.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__faxNo AS fax_no
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__faxNo IS NOT NULL
LIMIT 25

Top values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__faxNo AS value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__faxNo 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.