research questions: data relationships

[bsweger]

Data relationship questions from Sprint 1.

• When matching JAAMS PO_HEADERS_ALL to Prism header.docnum, how should the header.vernum attribute be handled? What does it represent? Should we only be taking one vernum per docnum?
• What does it mean when there are multiple records in PO_HEADERS_ALL with the same PO_HEADER_ID (the other data looks the same too)? For example, there are 9 records with a PO_HEADER_ID = 351260.

[bsweger]

From this morning's conversation with Sunil and Kavya:

In Prism, each grant has a docnum. Every time the grant is modified, it's logged in the header table with a new vernum (i.e., the primary key of the header is DOCNUM + VERNUM). To get the total obligated amount of a grant, you need to add up the amounts on all of the award's vernum records.

As for duplicated records in PO_HEADERS_ALL, they reflect the way that data was pulled from the source (i.e., original query was likely going through a more detailed tabled). We can safely ignore these: Sunil confirmed that PO_HEADER_ID is unique.

We have the answers, so closing this one.