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 |