FPDS Query Library
About Us
Contact Us

Last Modified By

A string identifying the user, account, or system identity that most recently modified the Other Transaction Award record in FPDS. It captures the last update attribution for the transaction information section rather than a procurement status or award attribute.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__transactionInformation__lastModifiedBy
Title
Last Modified By
FPDS Path
OtherTransactionAward/contractDetail/transactionInformation/lastModifiedBy
Description
A string identifying the user, account, or system identity that most recently modified the Other Transaction Award record in FPDS. It captures the last update attribution for the transaction information section rather than a procurement status or award attribute.
Business Meaning
This field helps analysts trace record stewardship, identify the source of recent changes, and support audit or data quality reviews. It can be useful for understanding workflow patterns, spotting bulk edits, and diagnosing anomalies in award records when combined with timestamps and other audit fields.
Example Value
THOMAS.BUNCH.W900KK@SA2100.ASA.ALT
Observed Non-Null Count
38,894

FPDS Compare

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

Use Cases

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

Common Usage

  • audit trail and record stewardship analysis
  • identifying bulk updates or system-generated edits
  • filtering records modified by a specific user or account

Common Mistakes

  • mistaking the value for the award official or contracting officer
  • using it as a business metric instead of an audit attribute

Query Guidance

Use the field in WHERE clauses for editor-level filters and in GROUP BY for modification-source analysis. Because values may be inconsistent in format, normalize case when needed and consider trimming whitespace before aggregating; pair it with modified date/time fields when available to reconstruct update activity.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__transactionInformation__lastModifiedBy AS last_modified_by
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__transactionInformation__lastModifiedBy IS NOT NULL
LIMIT 25

Top values

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