/
List Events (spine_lists)
Document toolboxDocument toolbox

List Events (spine_lists)

Owned by Chris Laun
Feb 28, 2023

Overview: This is a stream of events from the LSTEML_M table in Advantage which contains the current record for list signups

Frequency: Streaming
Data Source: Advantage
LQL Advice: Most fields here should be mapped to List_Code for context

Sample Payload: /wiki/spaces/SPINE/pages/40269911842


Field NameDescriptionSource Field
timestamp_fieldDate/time that the event occurredcdcCreationTimestamp/time of seed
Confirmation_DateThe date that the registration or order was confirmedCNFM_DTE
Add_DateDate that the customer was added to the listDTE_ADD
Customer_NumberAdvantage identifier of the customerCTM_NBR
Demographic_DataAn open field that can be partitioned in Advantage for custom needsDMO_DAT
Email_AddressEmail address used with the listContextual.EmailAddress ADR_EML
Email_IDAdvantage identifier of the email addressEMAL_ID
Email_Ref_NumEmail reference number for external mailing systemsEML_REF
Email_StatusStatus of this email address on this listEML_STA
Update_UserThe Advantage user or process that last updated this list recordUPD_USR
Update_DateThe most recent date that this list record was updatedUPD_DTE
List_CodeA short code that represents the list the customer was put onLIST_CDE
List_SourceSource code that can be used to track how the customer was added to the listLST_SRC
Owning_OrgThe org code indicating who owns the publicationContextual.List OWN_ORG

Related content

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