EN
Español
English
Português
    ASMS_ARCHIVING_POLICY

    Represents each version of a project’s archiving policy. Push-only: The entire series is the change history, and a project’s current policy is the most recent non-canceled version whose effective date has already arrived. Global policy isn’t saved here: It lives in your app’s settings

    Data model

    Fields

    Field Type Description
    author_id* INT User who saved the version. From it hangs the traceability of who authorized an irreversible deletion
    created_date* DATETIME UTC Log Creation Date
    effective_date* DATETIME The UTC date from which the version takes effect. A change that extends the deletion is recorded with a future date to prevent accidental deletions; one that restricts it takes effect immediately
    first_applied_date DATETIME Date in UTC when a run of the process first applied the version. Null as long as no run has applied it, and null forever in a canceled version. Not overwritten: not a run counter
    guid* NVARCHAR (72) Universal unique identifier of the registry
    inherits_global* BIT Indicates whether the project inherits the periods from the global policy. When it inherits, the version has no rows in ASMS_ARCHIVING_PERIOD
    is_cancelled* BIT Indicates that the version was canceled before it went into effect. A canceled version is never applied and is retained as evidence that it was scheduled and rolled back
    is_enabled* BIT Indicates whether archiving is active for the project. The absence of a current version means that no one has made the decision, and that project is not processed
    modified_date* DATETIME Date of modification of the UTC log. It only changes when you mark the version as canceled or when you register your first application
    policy_id* INT Policy version ID
    project_id* INT Project to which you apply the release. Always has value: Global policy is unrowed in this table

    Primary Key

    PK_ASMS_ARCHIVING_POLICY
    policy_id

    References

    Column Referenced Table Referenced column Name
    author_id* dbo.AFW_USERS user_id FK02_ASMS_ARCHIVING_POLICY
    project_id* dbo.ASMS_PROJECTS proj_id FK01_ASMS_ARCHIVING_POLICY