This table stores the subscription relationship details.
Module: Subscription Management
OPERATION_ID
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 | System | ||||
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. |