FPDS Query Library
About Us
Contact Us

Created By

User identifier for the person or system account that created the transaction record in FPDS. It is typically a login or email-style value rather than a descriptive name.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__transactionInformation__createdBy
Title
Created By
FPDS Path
OtherTransactionIDV/contractDetail/transactionInformation/createdBy
Description
User identifier for the person or system account that created the transaction record in FPDS. It is typically a login or email-style value rather than a descriptive name.
Business Meaning
This field helps analysts trace record provenance, identify responsible offices or user accounts, and assess data entry patterns across agencies or commands. It is useful for audit support, workflow analysis, and troubleshooting unusual or inconsistent transaction creation activity.
Example Value
ASTLEY.DAVY.CTR.HR0011@DARPA.MIL
Observed Non-Null Count
13,416

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__transactionInformation__createdBy
FPDS XML Path
OtherTransactionIDV/contractDetail/transactionInformation/createdBy
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/transactionInformation/createdBy' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__transactionInformation__createdBy'.

Use Cases

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

Common Usage

  • audit trail review
  • creator-level grouping
  • data quality troubleshooting

Common Mistakes

  • assuming it is a full person name
  • using it as a stable cross-system identity without validation

Query Guidance

Use exact-match or pattern-based filters when isolating records by creator, and aggregate by this field to compare transaction volumes by user account. In SQL, consider trimming/casing normalization if source values are inconsistent, but preserve the original value for auditability.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__transactionInformation__createdBy AS created_by
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__transactionInformation__createdBy IS NOT NULL
LIMIT 25

Top values

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