As an agency Broker user, I want my D1 file to clearly distinguish IDVs and Awards

Description

Right now, we have
ContractAwardType
and IDV_Type.
We need to add a "Referenced IDV Type" field to fully capture the heirarchy of awards and associated IDVs. Because IDVs can be children of other IDVs, we need this additional field to properly link them.
Awards can also be associated with IDVs, and having this 'reference idv type field' makes it much clearer what's going on there, rather than just shoving the referenced IDV in the IDV_Type field.

Part 1

  • The Broker Data Store is already doing this, by creating a new field called Referenced_IDV_Type.

  • When an award is tied to an IDV, that IDV's type goes there.

  • When an IDV is tied to a parent IDV, that parent IDV's type goes there.

  • We need to add this field in the IDD-D1 and MDR, and to the D1 file produced in the Broker.

  • Field length is 1 (it's a 1 character field)

Part 2

  • The Broker Data Store is already doing this, by creating a new field called Referenced_IDV_Multiple_Or_Single.

  • When an award is tied to an IDV, that IDV's Multiple or Single status goes there.

  • When an IDV is tied to a parent IDV, that parent IDV's Multiple or Single status goes there.

  • We need to add this field in the IDD-D1 and MDR, and to the D1 file produced in the Broker.

  • Field length is 1. It's a string (M or S).

Part 3

  • Alisa added a "pulled_from" element which stores which feed a pull came from (IDV or AWARD). This might be valuable to add to D1 as well, to make it crystal clear whether a record is an AWARD or IDV. I don't know the best name to use. Could be FeedType, SourceFeed, PulledFrom, etc. Open to suggestions.

  • Let's go with Award_Or_IDV_Flag for now?

Activity

Show:
alex jaja
June 5, 2017, 7:21 PM

New D1 fields, Referenced IDV Multiple or Single and Award_Or_IDV_Flag have been added as part of latest changes in the MDR:
https://github.com/fedspendingtransparency/schema/blob/master/MDR/DAIMS-MDR_v1.01.13.xlsm

Ross Williford
May 26, 2017, 8:20 PM
Edited

Alex--should we roll this story over into the next sprint? AFAIK only part 1 has been done in the MDR

alex jaja
May 19, 2017, 7:06 PM

Added new element called Referenced IDV Type to the MDR & Change Log, see GH:
https://github.com/fedspendingtransparency/schema/blob/master/MDR/DAIMS-MDR_v1.01.08.xlsm

Ross Williford
May 16, 2017, 3:28 PM

Alex--maybe we can set up a call to talk through these. Or I can provide you an "IDD version" of these elements as a starting point and you can fill out the rest of the MDR metadata fields.

Done
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

alex jaja

Reporter

Ross Williford