List Events (spine_lists)
- Chris Laun
Owned by Chris Laun
Feb 28, 2023
Loading data...
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 Name | Description | Source Field |
|---|---|---|
| timestamp_field | Date/time that the event occurred | cdcCreationTimestamp/time of seed |
| Confirmation_Date | The date that the registration or order was confirmed | CNFM_DTE |
| Add_Date | Date that the customer was added to the list | DTE_ADD |
| Customer_Number | Advantage identifier of the customer | CTM_NBR |
| Demographic_Data | An open field that can be partitioned in Advantage for custom needs | DMO_DAT |
| Email_Address | Email address used with the list | Contextual.EmailAddress ADR_EML |
| Email_ID | Advantage identifier of the email address | EMAL_ID |
| Email_Ref_Num | Email reference number for external mailing systems | EML_REF |
| Email_Status | Status of this email address on this list | EML_STA |
| Update_User | The Advantage user or process that last updated this list record | UPD_USR |
| Update_Date | The most recent date that this list record was updated | UPD_DTE |
| List_Code | A short code that represents the list the customer was put on | LIST_CDE |
| List_Source | Source code that can be used to track how the customer was added to the list | LST_SRC |
| Owning_Org | The org code indicating who owns the publication | Contextual.List OWN_ORG |
com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.