Table:
EXPIRATION_ALERT
|
Table Name
|
EXPIRATION_ALERT |
| Table Description |
The EXPIRATION_ALERT table represents an expiration alert in a subscriber account. |
| Tablespace |
SUBSCRIBER_DATA |
| Database |
Core Database |
|
Partitioned
|
Yes
|
|
Columns
|
|
Columns of the Table
The EXPIRATION_ALERT database table is defined by the following columns.
Column: SUAC_OID
| Value Type |
BIGINT, NOT NULL |
|
| Key(s) |
- |
Foreign K.:
- Foreign table: SUBSCRIBER_ACCOUNT
- Foreign field(s): OID
|
| Index(es) |
IX_EXAL_SUAC
IX_EXAL_SUAC_G (unique) (oracle)
|
| Column Description |
The identifier of the subscriber account. |
Column: CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Index(es) |
IX_EXAL_SUAC_G (unique) (oracle)
|
| Column Description |
The code of the expiration alert. |
Column: PREPAID_ACCOUNT_CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The code of the prepaid account owning the expiration alert. |
Column: REFERENCE_DATE_STATE
| Value Type |
DECIMAL(1), NOT NULL |
|
| Column Description |
The state of the prepaid account that triggers the alert. Possible values are:
- 0: active
- 1: blocked
- 2: locked
- 3: closed
|
Column: DAY_COUNT
| Value Type |
BIGINT, NOT NULL |
|
| Column Description |
The number of days between the change of state and the expiration alert. The alert can be sent either before or after the
change. When the alert is sent before, the value of DAY_COUNT is negative.
|
Column: TRIGGERING_DATE
| Value Type |
DATE |
|
| Column Description |
The date when the alert is triggered. |
Column: SUAC_CODE
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The code of the subscriber account. |
Column: SUAC_SERVICE_PROVIDER
| Value Type |
VARCHAR(256), NOT NULL |
|
| Column Description |
The service provider associated to the subscriber account. |
Column: PARTITION_ID
| Value Type |
SMALLINT, NOT NULL |
|
| Column Description |
The partition of the subscriber account. |
Top of the list
SAP Convergent Charging 3.0
Document Version: SP04 and later
(c) Copyright 2011 SAP AG. All rights reserved.