Hello @richardmgb,
as far as I can remember, this information won't be found on the metadata, but on the CI datamart (CI CDM) or on the CI datawarehouse.
About the way to query, I believe to remember there is an specific table containing the active campaigns (ending on _active).
Please check: https://communities.sas.com/t5/SAS-Customer-Intelligence/SAS-CI-5-4-To-create-Business-Context-and-I...
Perhaps some members of this community can help you better with this question.
Kind regards,
Juan