I'm looking to pull email (not email address) information from RE. On a constituent's record, this shows on the NetCommunity tab, under Email Received. It includes Name and Date Sent. However, when creating a constituent query, there is only NetCommunity - Email Received, Email Name, but not Date Sent. Same thing with Export. So my question is, where / what table is the Date Sent stored?
You may locate this information in the SentDate column of the BBNCEmailRecipients table. Generally, NetCommunity (BBNC) related information would be found in the tables prefixed BBNC in The Raiser's Edge (RE) database. If you would like to view more details about the RE tables and how they relate to each other, the link below shows how to view the database schema.