FPDS Query Library
About Us
Contact Us

Negotiator Code

Coded NASA identifier for the negotiator associated with the IDV record. It captures the internal code used by NASA to identify the responsible negotiator rather than a free-text name.

Family: IDV
Category: NASA Specific Fields
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__negotiatorCode
Title
Negotiator Code
FPDS Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/negotiatorCode
Description
Coded NASA identifier for the negotiator associated with the IDV record. It captures the internal code used by NASA to identify the responsible negotiator rather than a free-text name.
Business Meaning
This field supports internal accountability, acquisition tracking, and review of which NASA negotiator handled a vehicle. Analysts can use it to segment IDVs by responsible office or person-level code when assessing workload, portfolio distribution, or negotiation patterns.
Example Value
CAF
Observed Non-Null Count
57,741

FPDS Compare

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__negotiatorCode
FPDS XML Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/negotiatorCode
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/agencySpecificIDVElements/NASASpecificIDVElements/negotiatorCode' into the SQL-ready variable 'content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__negotiatorCode'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • NASA-specific IDV record interpretation

Common Usage

  • Attribute IDVs to a NASA negotiator code for portfolio analysis
  • Join to agency reference tables or code mappings when available
  • Filter or group records to review negotiator-level activity

Common Mistakes

  • Interpreting the code as a person name or descriptive text
  • Comparing values across agencies without confirming NASA-specific meaning

Query Guidance

Use this field as a grouping or join key only after confirming the valid code set. In SQL, prefer exact matching and treat null or blank values as missing assignment; if a mapping table exists, join on the code to obtain the human-readable negotiator name or description.

SQL Examples

Preview values

SELECT
    content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__negotiatorCode AS negotiator_code
FROM fpds.data
WHERE content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__negotiatorCode IS NOT NULL
LIMIT 25

Top values

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