| Database Table Tracer |
[This is preliminary documentation and is subject to change.]
This table defines tracers that may be created on each Survey.
It is possible to register an Assessment object per survey phase on each tracer.
A tracer may be used to describe any object that needs to be assesed / surveyed. The possibilites include - but are not limited to - a patient, a pathway / period of care, a piece of equipment, etc.
FieldsField Name | Type | Note | Description |
|---|---|---|---|
Id | INT | Primary Key | Internal unique id |
CreatedDateTime | DATETIME | Date and time the tracer was created | |
CreatedBy | INT | Reference to Employee: id of user who created the tracer | |
UpdatedDateTime | DATETIME | Date and time the tracer was updated | |
UpdatedBy | INT | Reference to Employee: id of user who updated the tracer | |
DeletedDateTime | DATETIME | Date and time the tracer was deleted | |
DeletedBy | INT | Reference to Employee: id of user who deleted the tracer | |
SurveyId | INT | Reference to Survey | |
Name | VARCHAR(255) | Name of tracer | |
Description | VARCHAR(MAX) | Description of tracer |