FPDS Query Library
About Us
Contact Us

Alternate COTR Name

Human-readable name for NASA's alternate Contracting Officer Technical Representative (COTR) on the award record. This is a descriptive label field associated with the agency-specific award element, not a coded identifier.

Family: Award
Category: General
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__alternateCOTRName
Title
Alternate COTR Name
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/alternateCOTRName
Description
Human-readable name for NASA's alternate Contracting Officer Technical Representative (COTR) on the award record. This is a descriptive label field associated with the agency-specific award element, not a coded identifier.
Business Meaning
Useful for identifying the individual or name recorded as the alternate COTR in NASA awards, which supports oversight of contract administration, accountability, and workload assignment. It can help analysts review agency-specific award handling and validate whether the record contains the expected technical representative information.
Example Value
x
Observed Non-Null Count
37,573

FPDS Compare

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__alternateCOTRName
FPDS XML Path
award/agencySpecificAwardElements/NASASpecificAwardElements/alternateCOTRName
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/agencySpecificAwardElements/NASASpecificAwardElements/alternateCOTRName' into the SQL-ready variable 'content__award__agencySpecificAwardElements__NASASpecificAwardElements__alternateCOTRName'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • Identify the alternate COTR named on NASA awards
  • Support award-level compliance or oversight reviews
  • Compare NASA-specific administrative data across records

Common Mistakes

  • Assuming it is a coded value or unique identifier
  • Using exact string matches without accounting for name variation

Query Guidance

Select and filter it as a text field, but avoid using it as a join key. For analysis, apply `TRIM`, case normalization, and `COALESCE` as needed, and pair it with related NASA COTR fields when validating completeness or comparing records.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__alternateCOTRName AS alternate_c_o_t_r_name
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__alternateCOTRName IS NOT NULL
LIMIT 25

Top values

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