| Schema Version | 5.0.6 | |
| Filegroup | SUBSCRIBER_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The EXPIRATION_ALERT table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| SUAC_OID | IX_EXAL_SUAC | SUBSCRIBER_ACCOUNT (OID)
|
|
The identifier of the subscriber account | ||
| CODE |
|
The code of the expiration alert | ||||
| PREPAID_ACCOUNT_CODE |
|
The code of the prepaid account owning the expiration alert | ||||
| REFERENCE_DATE_STATE |
|
The state of the prepaid account that triggers the alert | ||||
| DAY_COUNT |
|
The number of days between the change of state and the expiration alert | ||||
| TRIGGERING_DATE |
|
The date when the alert is triggered | ||||
| SUAC_CODE |
|
The code of the subscriber account | ||||
| SUAC_SERVICE_PROVIDER |
|
The service provider associated to the subscriber account | ||||
| PARTITION_ID |
|
The partition of the subscriber account |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The identifier of the subscriber account |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_EXAL_SUAC |
| Definition | The code of the expiration alert |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The code of the prepaid account owning the expiration alert |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The state of the prepaid account that triggers the alert |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| 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 |
| Definition | The date when the alert is triggered |
| Type | DATETIME, NULL |
| Definition | The code of the subscriber account |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The service provider associated to the subscriber account |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The partition of the subscriber account |
| Type | DECIMAL(4), NOT NULL |
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:
| Indexed Column(s) | SUAC_OID |
| Unique | No |
| Partitioned | Yes |
| Clustered | No |
| Filegroup | SUBSCRIBER_INDX |
