Contains the information for a specific 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 |
| 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 |
| voted_date | DATETIME | Date of Approval Vote |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| group_id | dbo.AFW_GROUPS | grou_id | FK03_ASMS_APPROVALS_DETAIL |
| result_id* | dbo.ASMS_APPROVALS_DATA | id | FK01_ASMS_APPROVALS_DETAIL |
| user_id* | dbo.AFW_USERS | user_id | FK02_ASMS_APPROVALS_DETAIL |
| user_id_optional | dbo.AFW_USERS | user_id | FK04_ASMS_APPROVALS_DETAIL |