DW_CXS_SUBSCRIPTION_RELATIONSHIP_F

This table stores the subscription relationship details.

Details

Module: Subscription Management

Key Columns

OPERATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPERATION_ID NUMBER 38 0 True The unique identifier of the operation associated with the relation.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System Generated Unique Identifier
OPERATION_CODE VARCHAR2 32 The code of the operation that resulted in this relationship record. Stores values such as Renewal, Amendment, Upgrade. DW_CXS_SUBSCRIPTION_OPERATION_D_TL CODE
SOURCE_SUBSCRIPTION_ID NUMBER 38 0 The unique identifier of the source subscription associated with the relationship.
SOURCE_SUBSCRIPTION_PRODUCT_ID NUMBER 38 0 The unique identifier of the source subscription product associated with the relationship
TARGET_SUBSCRIPTION_ID NUMBER 38 0 The unique identifier of the target subscription associated with the relationship.
TARGET_SUBSCRIPTION_PRODUCT_ID NUMBER 38 0 The unique identifier of the target subscription product associated with the relationship.
CREATION_DATE DATE The date on which the subscription relationship record was created.
LAST_UPDATE_DATE DATE The date on which the subscription relationship record was last updated.
CREATION_TIMESTAMP TIMESTAMP The date and time on which the subscription relationship record was created.
LAST_UPDATE_TIMESTAMP TIMESTAMP The date and time on which the subscription relationship record was last updated.