One of my colleagues in marketing has asked me to import some information for the Promotions radial button under the Connections tab. The idea is to log the calling of constituents and their responses as part of a telemarketing campaign with a notion of producing reports for business intelligence reporting. The problem is if they're called multiple times (e.g. "not at home", "call back later", etc), you need a different source_no to avoid violating the primary constraint for the T_PROMOTION table. Is it a mistake to think "we'll just create a 'FY19 Telemarketing Blitz (first call)', and a 'FY19 Telemarketing Blitz (second call)', and 'FY19 Telemarketing Blitz (third call)', and so forth for each iteration (they've called some people a half dozen times already), or is there perhaps a better way to track this information for reporting purposes in some other part of Tessitura?
Thanks, Tessiturians.