EXPIRATION_ALERT
Definition
The EXPIRATION_ALERT table represents an expiration alert in a subscriber account
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
SUBSCRIBER_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The EXPIRATION_ALERT table is defined by the
following columns.
See the column details for more information.
Column Details
SUAC_OID
| Definition |
The identifier of the subscriber account |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_EXAL_SUAC |
CODE
| Definition |
The code of the expiration alert |
| Type |
VARCHAR(256), NOT NULL |
PREPAID_ACCOUNT_CODE
| Definition |
The code of the prepaid account owning the expiration alert |
| Type |
VARCHAR(256), NOT NULL |
REFERENCE_DATE_STATE
| Definition |
The state of the prepaid account that triggers the alert |
| Format |
The possible values are:
0: Active
1: Blocked
2: Locked
3: Closed
|
| Type |
DECIMAL(1), NOT NULL |
DAY_COUNT
| Definition |
The number of days between the change of state and the expiration alert |
| 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.
|
| Type |
DECIMAL(28), NOT NULL |
TRIGGERING_DATE
| Definition |
The date when the alert is triggered |
| Type |
TIMESTAMP, NULL |
SUAC_CODE
| Definition |
The code of the subscriber account |
| Type |
VARCHAR(256), NOT NULL |
SUAC_SERVICE_PROVIDER
| Definition |
The service provider associated to the subscriber account |
| Type |
VARCHAR(256), NOT NULL |
PARTITION_ID
| Definition |
The partition of the subscriber account |
| Type |
DECIMAL(4), NOT NULL |
Index Details
The following database indexes are available in the
EXPIRATION_ALERT database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_EXAL_SUAC
| Indexed Column(s) |
SUAC_OID |
| Unique |
No |
| Partitioned |
Yes |
| Tablespace |
SUBSCRIBER_INDX |
