| Database Table Indicator |
[This is preliminary documentation and is subject to change.]
This table holds indicators.
FieldsField name | Type | Note | Description |
|---|---|---|---|
StandardCode | VARCHAR (20) | Primary key | Reference to StandardVersion |
VersionNumber | INT | Primary key | Reference to StandardVersion |
IndicatorCode | VARCHAR (20) | Primary key | Code of indicator |
IndicatorName | VARCHAR(255) | Editable | Name of indicator |
IndicatorDescription | VARCHAR(MAX) | Editable (rich text) | What the indicator is about |
IndicatorGuidance | VARCHAR(MAX) | Editable (rich text) | Guidance for users of this indicator |
Step | INT | Relation | Relation to table IndicatorStep |
RecordAudit | BIT | Whether record audit is required for this indicator | |
FormFilename | VARCHAR(255) | Filename of configured, indicator specific form - NB: not used anymore. | |
CreatedDateTime | DATETIME | Date and time for creation of indicator | |
CreatedBy | INT | Employee if of user who created the indicator | |
UpdatedDateTime | DATETIME | Date and time for last update of indicator | |
UpdatedBy | INT | Employee id of user who last updated the indicator | |
DeletedDateTime | DATETIME | Date and time for (logical) deletion of indicator. NB: NOT USED - indicators are deleted physically! |
RelationsTable | Field(s) | Description |
|---|---|---|
StandardCode, VersionNumber. | The standard edition that this indicator is part of. | |
Step | The step in the quality cycle, where this indicator belongs. |