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 |
| Available Index |
IX_EXAL_SUAC_G |
CODE
| Definition |
The code of the expiration alert |
| Type |
VARCHAR2(256 CHAR), NOT NULL |
| Available Index |
IX_EXAL_SUAC_G |
PREPAID_ACCOUNT_CODE
| Definition |
The code of the prepaid account owning the expiration alert |
| Type |
VARCHAR2(256 CHAR), 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 |
DATE, NULL |
SUAC_CODE
| Definition |
The code of the subscriber account |
| Type |
VARCHAR2(256 CHAR), NOT NULL |
SUAC_SERVICE_PROVIDER
| Definition |
The service provider associated to the subscriber account |
| Type |
VARCHAR2(256 CHAR), 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 |
IX_EXAL_SUAC_G
| Indexed Column(s) |
SUAC_OID, CODE |
| Unique |
No |
| Partitioned |
No |
| Tablespace |
SUBSCRIBER_INDX |
