Overview
The Process dimension table is designed to manage and categorize the various processes within a system. This table includes process groups, names, descriptions, internal rates per hour, and schedule display settings. By providing detailed attributes for each process, it helps organize and efficiently manage them.
common.dimProcesses
| Column Name | Description | Type | Is Unique |
|---|---|---|---|
| Id | The primary key for the table | number | Yes |
| ProcessGroup | The group to which the process belongs | text | No |
| Name | The name of the process | text | No |
| Description | Description of the process | text | No |
| DisplayOrder | The order in which the process is displayed | number | No |
| InternalRatePerHour | The internal rate per hour for the process | number | No |
| ShortName | Abbreviated name for the process | text | No |
| ScheduleBarColor | Background colour for the schedule bar | number | No |
| ScheduleBarTextColor | Text colour for the schedule bar | number | No |
finance.dimProcesses
| Column Name | Description | Type | Is Unique |
|---|---|---|---|
| Id | The primary key for the table | number | Yes |
| InternalRatePerHour | The estimated internal hourly rate for this process | decimal | No |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article