When web transactions are downloaded, the constituent data goes into BATCHREVENUECONSTITUENTT, and the ID is referenced by BATCHREVENUE.PRIMARYRECORDID
However, if CRM matches that incoming donation to a record, the PRIMARYRECORDID is the actual CONSTITUENTID.
For the life of me, I can't figure out how to get the the specific data in BATCHREVENUECONSTITUENT when this happens.
The reason I'm asking is primarily because the phone country ID seems to be getting wiped out on these records when we commit the revenue batch. This might be because when you click on “Edit Constituent” in the enhanced revenue batch, phone country is NOT an available field.
We prefer that the Enhanced Revenue batch make ZERO modifications to constituent biographical data. I have a process in place that actually looks at the incoming enhanced revenue batch and loads the constituent data into a separate constituent update batch. It does this by joining BATCHREVENUE to BATCHREVENUECONSTITUENT, taking the information that was entered (along with a number of revenue attributes that we use for data poitns that aren't supported by the ADF).
However, for those matched constituents, I can't GET to the data from the BATCHREVENUECONSTITUENT table. IT's there, but I can't figure out how to make the connection when the BATCHREVENUE.PRIMARYRECORDID table contains the constituent ID instead of the ID to the BATCHCONSTITUENT table.
