| Database Table StandardVersion |
[This is preliminary documentation and is subject to change.]
The database table StandardVersion holds editions of standards (one record in this table = one edition of a standard).
Note that the terminology in the database differs from the terminology in the user interface. In the database the term "standard version" is used - in the user interface the term "standard edition" is used.
FieldsField name | Type | Note | Description |
|---|---|---|---|
StandardCode | VARCHAR (20) | Part of primary key | Reference to Standard |
VersionNumber | INT | Part of primary key | Edition number. NOTE: meaning of this field has changed. In the database base it is still "Version", but in the GUI it is now called "Edition". |
Description | TEXT | Editable (rich text) | What the standard is about |
Purpose | VARCHAR(MAX) | Editable (rich text) | Purpose of standard |
Target | VARCHAR(MAX) | Editable (rich text) | Sub-set of staff / roles for which this standard is relevant |
Area | VARCHAR(MAX) | Editable (rich text) | Area |
Population | VARCHAR(MAX) | Editable (rich text) | Sub-set of patients / illnesses, where the standare version applies |
ValidFrom | DATETIME | Date from which this edition is valid | |
ValidTo | DATETIME | Date after which this edition is no longer valid | |
Comment | VARCHAR(MAX) | Comment (not used) | |
StandardDescription | VARCHAR(MAX) | What the standard is about | |
StandardGuidance | VARCHAR(MAX) | Guidance: information to staff on how to use the standard | |
CreatedDateTime | DATETIME | Date and time for creation of standard edition | |
CreatedBy | INT | Employee id of user who created the standard edition | |
UpdatedDateTime | DATETIME | Date and time for latest update of standard edition | |
UpdatedBy | INT | Employee id of user who latest updated the standard edition | |
DeletedDateTime | DATETIME | Date and time for (logical) deletion of standard edition. NB: NOT USED - standard editions are deleted physically! | |
DeletedBy | INT | Employee id of user who (logically) deleted the standard edition. NB: NOT USED - standard editions are deleted physically! |
Relations