EXPIRATION_ALERT_SCHED

Definition


The EXPIRATION_ALERT_SCHED table contains the last date when the alert scheduler has been triggered

Technical Data


Schema Version 2025.0.0
Filegroup CATALOG_DATA
Partitioned No

Summary


The EXPIRATION_ALERT_SCHED 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
LAST_TRIGGERING_DATE        

    The last date when the alert scheduler has been triggered
    CLIENT_NUMBER        

      The client number associated to the subscriber account
      PARTITION_ID        

        The partition of the subscriber account

        Column Details

        The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

        LAST_TRIGGERING_DATE

        Definition The last date when the alert scheduler has been triggered
        Type DATETIME, NULL

        CLIENT_NUMBER

        Definition The client number associated to the subscriber account
        Type DECIMAL(3), NOT NULL

        PARTITION_ID

        Definition The partition of the subscriber account
        Type DECIMAL(4), NOT NULL