FPDS Query Library
About Us
Contact Us

Renewal Date

The date on which the vendor's CCR/SAM registration is scheduled to be renewed or expires and must be updated. It is a vendor site attribute recorded under the contractor registration details for the transaction.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__ccrRegistrationDetails__renewalDate
Title
Renewal Date
FPDS Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/ccrRegistrationDetails/renewalDate
Description
The date on which the vendor's CCR/SAM registration is scheduled to be renewed or expires and must be updated. It is a vendor site attribute recorded under the contractor registration details for the transaction.
Business Meaning
This date helps analysts assess whether a vendor's registration was current at the time of award, which is important for compliance checks, vendor eligibility review, and timeline analysis of registration status relative to contracting actions.
Example Value
2022-07-27 00:00:00
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__ccrRegistrationDetails__renewalDate
FPDS XML Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/ccrRegistrationDetails/renewalDate
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/ccrRegistrationDetails/renewalDate' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__ccrRegistrationDetails__renewalDate'.

Use Cases

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

Common Usage

  • Check whether vendor registration was valid at award or modification date
  • Flag contracts associated with soon-to-expire registrations
  • Analyze vendor registration timing across suppliers or periods

Common Mistakes

  • Assuming the value is the actual registration start date rather than the renewal/expiration date
  • Comparing the raw string lexicographically instead of casting to a date type

Query Guidance

Cast the field to a date or timestamp in SQL, then compare it to award/action dates for validity checks or use it in GROUP BY and time-bucketed analyses. If your source includes timezone or time components, normalize them before reporting.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__ccrRegistrationDetails__renewalDate AS renewal_date
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__ccrRegistrationDetails__renewalDate IS NOT NULL
LIMIT 25

Top values

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