Draft Versionis always 0.
Draft Versionto 0. Any proposed changes increments the
Created Byis a linked column to the
[Cinchy].[Users]table, of the user who created the record.
Createdis the time when the record was created.
Createdwill be the same for all records with the same Cinchy Id.
Createdis based on the first user to make changes on an approved record. So the user where
Draft Version= 1.
Modified Byis a linked column to the
[Cinchy].[Users]table, of the user who last modified the record.
Draft Version!= 0) or approve the record (
Draft Version= 0). The timestamp for when that version was generated.
Deletedare based on the user/time when the Delete Request was created, not when it was approved.
Replacedis empty is the current version of that record.