Jump to: navigation, search

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.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on December 19, 2017, at 02:26.