ProgressCodes

The ProgressCodes dataset contains data regarding progress codes.

Importing to a BI database

The progress codes on cases can change continuously. This makes it necessary to ensure during periodic runs that the latest changes are included and that obsolete data is deleted. Delete the existing table in your BI database and import the latest version.

Column overview

The following table describes the columns available in the dataset. The table includes the following information about each column:

  • Dataset name: The column’s name in the dataset.

  • Description: Describes the column’s content and function.

  • Reference to other dataset: Specifies references to other datasets, if any.

  • Format: Specifies the format of the returned values.

  • Length: Specifies the length of the returned values, if any.

  • Examples: Examples of returned values.

Dataset name Description Reference to other dataset Format Length Examples

InternalProgressCodeId

The internal database ID of the progress code.

int identity

6

98

Active

The state of the progress code, i.e. whether it is assignable. Inactive codes can still show up on old cases.

bit

1: Active

0: Inactive

CodeName

Name of the progress code.

nvarchar

256

Awaits approval

In hearing

Description

Progress code description

nvarchar

256

FinalDeadline

The starting number of full days until the deadline.

int

7

WarningDeadline

The starting number of full days until the warning date.

int

4