Contains information from a specific closed vote in an approval process
Data model
Fields
| Field | Type | Description |
|---|---|---|
| description | NVARCHAR (8000) | Additional Comment to the Vote of Approval |
| group_id | INT | Specialist group identifier |
| group_name | NVARCHAR (512) | Name of the specialist group |
| result | INT | Identifier of the current result of the approval process, (0 = rejected, 1 = approved, 2 = more information needed) |
| result_id* | INT | Approval process ID, reference to ASMS_APPROVALS_DATA.id table |
| user_id* | INT | Voting user ID, reference to AFW_USERS.user_id table |
| user_id_optional | INT | Identifier of the user voting on behalf of other assignees, reference to the AFW_USERS.user_id table |
| user_name | NVARCHAR (510) | Name of the user who performs the vote |
| user_name_optional | NVARCHAR (510) | Name of the user voting on behalf of other assigned users |
| voted_date | DATETIME | Date of Approval Vote |