EN
Español
English
Português
    ASMS_ARCHIVING_PERIOD

    Represents the retention period in production for each group of case types within a version of the archiving policy. A version that inherits the global policy has no rows in this table

    Data model

    Fields

    Field Type Description
    created_date* DATETIME UTC Log Creation Date
    group_code* NVARCHAR (40) Code of the case type group to which the period applies
    modified_date* DATETIME UTC Log Modification Date
    policy_id* INT Version of the archiving policy to which the period belongs
    preserving_period* INT Months that the group’s information is kept in production before being eligible for deletion. The restriction prevents a non-positive value from persisting, which would make everything already migrated eligible

    Primary Key

    PK_ASMS_ARCHIVING_PERIOD
    policy_id, group_code

    References

    Column Referenced Table Referenced column Name
    policy_id* dbo.ASMS_ARCHIVING_POLICY policy_id FK01_ASMS_ARCHIVING_PERIOD