Database Table SelfevaluationRound |
[This is preliminary documentation and is subject to change.]
Master table for self evaluations (previously called "self evaluation "rounds").
Field Name | Type | Note | Description |
---|---|---|---|
Id | INT | Primary Key | Internal unique id |
CreatedDateTime | DATETIME | Date and time for creation of self evaluation round | |
CreatedBy | INT | Employee id of user who created the self evaluation round | |
UpdatedDateTime | DATETIME | Date and time for lateste update of self evaluation round | |
UpdatedBy | INT | Employee id of user who latest updated the self evaluation round | |
DeletedDateTime | DATETIME | Date and time for (logical) deletion of self evaluation round. NB: Not used - selfevaluations are deleted physically! | |
DeletedBy | INT | Employee id of user who (logically) deleted the self evaluation round. NB: Not used - selfevaluations are deleted physically! | |
OrgUnitType | VARCHAR (20) | Reference to OrgUnit | |
OrgUnitCode | VARCHAR (20) | Reference to OrgUnit | |
SequenceNumber | INT | ||
DateFrom | DATETIME | First date in selfevaluation | |
DateTo | DATETIME | Last date in selfevaluation | |
RoundType | INT | Reference to SelfEvaluationRoundType | |
Status | INT | Reference to SelfEvaluationStatus | |
Comment | VARCHAR(MAX) | Comment on self evaluation | |
ResultAverage | FLOAT | Average result of self evaluation round - NB: not used |
Table | Fields | Comment |
---|---|---|
OrgUnitType, OrgUnitCode | The institution subunit that is target of self evaluation | |
RoundType | Type of self evaluation. | |
Status | Status of self evaluation. |