/
Subscription Email Events (spine_subscription_emails)
Document toolboxDocument toolbox

Subscription Email Events (spine_subscription_emails)

Owned by Chris Laun
Feb 28, 2023

Overview: This is a feed of events generated from the Advantage CIREML_M table. This is needed to join events from spine_subscriptions to an email address.

Frequency: Streaming
Data Source: Advantage
LQL Advice:
Sample Payload: /wiki/spaces/SPINE/pages/40269911842 (SubscriptionEmailLink)
Field NameDescriptionSource Field
Cdc_Creation_TimestampTimestamp of the CIREML_M eventCdc_Creation_Timestamp
Email_AddressEmail address of the customerContextual.EmailAddress = ADR_EML
Subscription_ReferenceAdvantage identifier of the subscription recordSUB_REF
PUB_CDEThe publication that the customer ownsPUB_CDE
EMAL_IDAdvantage identifier of the email addressEMAL_ID
EML_STAThe status of the email address on this subscriptionEML_STA
CTM_NBRAdvantage identifier of the customerCTM_NBR
Event_TypeI = Insert, U = Update, D = DeleteU

Related content

com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.