PRIORITY Dimension

iWD arranges a task list in order of priority based on business rules that are configured for capture points, departments, and processes within departments. This prioritization is stored in the PRIORITY dimension, which is a static dimension.

The PRIORITY Dimension

Field	Data Type	Description
PRIORITY_KEY	int	Primary key of this table.
PRIORITY_RANGE_5	nvarchar(32)	Values in the priority granularity of 5—that is “1–5”, “6–10”, and so on.
PRIORITY_RANGE_10	nvarchar(32)	Values in the priority granularity of 10—that is “1–10”, “11–20”, and so on.
PRIORITY_RANGE_50	nvarchar(32)	Values in the priority granularity of 50—that is “1–50”, “51–100”, and so on.
PRIORITY_RANGE_100	nvarchar(32)	Values in the priority granularity of 100—that is “1–100”, “101–200”, and so on.
PRIORITY_RANGE_500	nvarchar(32)	Values in the priority granularity of 500—that is “1–500”, “501–1000”, and so on.
PRIORITY_RANGE_1000	nvarchar(32)	Values in the priority granularity of 1000—that is “1–1000”, “1001–2000”, and so on, with a maximum value of 50000.
PRIORITY_RANGE_5_START	int	Values that mark the start of each PRIORITY_RANGE_5 range. Values step by 5—for example, 1, 6, 11, and so forth.
PRIORITY_RANGE_5_END	int	Values that mark the end of each PRIORITY_RANGE_5 range. Values step by 5—for example, 5, 10, 15, and so forth.
PRIORITY_RANGE_10_START	int	Values that mark the start of each PRIORITY_RANGE_10 range. Values step by 10—for example, 1, 11, 21, and so forth.
PRIORITY_RANGE_10_END	int	Values that mark the end of each PRIORITY_RANGE_10 range. Values step by 10—for example, 10, 20, 30, and so forth.
PRIORITY_RANGE_50_START	int	Values that mark the start of each PRIORITY_RANGE_50 range. Values step by 50—for example, 1, 51, 101, and so forth.
PRIORITY_RANGE_50_END	int	Values that mark the end of each PRIORITY_RANGE_50 range. Values step by 50—for example, 50, 100, 150, and so forth.
PRIORITY_RANGE_100_START	int	Values that mark the start of each PRIORITY_RANGE_100 range. Values step by 100—for example, 1, 101, 201, and so forth.
PRIORITY_RANGE_100_END	int	Values that mark the end of each PRIORITY_RANGE_100 range. Values step by 100—for example, 100, 200, 300, and so forth.
PRIORITY_RANGE_500_START	int	Values that mark the start of each PRIORITY_RANGE_500 range. Values step by 500—for example, 1, 501, 1001, and so forth.
PRIORITY_RANGE_500_END	int	Values that mark the end of each PRIORITY_RANGE_500 range. Values step by 500—for example, 500, 1000, 1500, and so forth.
PRIORITY_RANGE_1000_START	int	Values that mark the start of each PRIORITY_RANGE_1000 range. Values step by 1000—for example, 1, 1001, 2001, and so forth.
PRIORITY_RANGE_1000_END	int	Values that mark the end of each PRIORITY_RANGE_1000 range. Values step by 1000—for example, 1000, 2000, 3000, and so forth.