Subscription Events (spine_subscriptions)
- Chris Laun
Owned by Chris Laun
Feb 28, 2023
1 min read
Loading data...
Overview: This is a stream of events from the CIRSUB_M table in Advantage which contains the current record for all subscriptions. This stream does not contain the email address and may need to be joined with spine_subscription_emails (on Subscription_Reference) in order to connect it with the rest of a Lytics profile
Frequency: Streaming
Data Source: Advantage
LQL Advice:
Sample Payload: /wiki/spaces/SPINE/pages/40269911842 (SubscriptionCurrentLink)
| Field Name | Description | Source Field |
|---|---|---|
| Billing_Status | Code of the billing status the subscription | BIL_STS |
| Billing_Status_Description | Long description for the billing status code | getBillingStatus(BIL_STS) |
| Circulation_Status | Code of the circulation status the subscription (used to determine whether the sub is active/inactive) | CRC_STS |
| Circulation_Status_Description | Long description of the circulation status | getCirculationStatus(CRC_STS) |
| Customer_Number | Advantage identifier of the customer | CTM_NBR |
| Final_Expire | The date that this subscription will expire, including any future terms | FIN_EXP |
| Owning_Org | The org code indicating who owns the publication | Contextual.Item OWN_ORG |
| Publication_Code | Code of the publication owned by the customer | PUB_CDE |
| Publication_Code_Description | Description of the Publication_Code | Contextual.Item FULL_TTL |
| Rate | Price from the current term of the subscription | RATE |
| Subscription_Reference | Advantage identifier of the subscription record | SUB_REF |
| Term | The total number of issues to be fulfilled in the current term | TERM |
| Term_Number | The number of times the pub has been purchased/renewed | TRM_NBR |
com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.