sp614_rpt_groupby_skill
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table provides a list of default skills/resources and skill levels which are used as the initial selection in the "Group By Specific Skills" selection for Analytics reports Capacity Report and Capacity Summary. These are only defaults, users can change the selection before running the reports.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| resource_no | number(38) | Â |  |
| skill_level | number(38) | Â | |
Keys
primary key (resource_no, skill_level)Â
foreign key (resource_no) references sp211_resources(resource_no)
Column Descriptions
| Field | Description |
|---|---|
| resource_no | Identifier of resource required. Obtained from sp211_resources. |
| skill_level | This specifies the required skill level. |