ApprovalInfo
The ApprovalInfo dataset contains data regarding approvals, such as the time of creation, when the approval was started and completed, and which step it is currently on.
Importing to a BI database
Approvals can change continuously on records. This makes it necessary to ensure during periodic runs that the latest changes are included and that obsolete data is deleted. The Dossiers dataset, which contains general data about records, governs changes in the ApprovalInfo dataset. Changes in Dossiers thus mean that there may also be changes in ApprovalInfo (see also Diagram of "Entity Relationship").
You should do the following when importing to a BI database:
-
Delete rows related to changed records in the existing ApprovalInfo table. Record IDs for the changed records can be found in the latest version of the Dossiers table.
-
Import the latest versions of the Dossiers and ApprovalInfo tables to the BI database.
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 |
|---|---|---|---|---|---|
ApprovalProcess_Id |
The internal F2 database ID of the approval. |
bigint |
20896 17506 |
||
InternalDossierId |
The internal F2 database ID of the approval’s record. |
bigint |
12058 69863 |
||
ApprovalTypeEnumItemId |
The internal F2 database ID of the approval’s type. |
int |
6985 1240 |
||
InReturn |
Whether the approval was returned. 0 = No. 1 = Yes. |
int |
0 1 |
||
Comment |
The content of the approval’s "Comment" field. |
nvarchar |
OK Good |
||
Urgent |
Whether the approval’s "Urgent" field was ticked. 0 = No. 1 = Yes. |
int |
0 1 |
||
Approved |
Whether the approval was finally approved. 0 = No. 1 = Yes. |
int |
0 1 |
||
CurrentStepSequenceNumber |
The current step of the approval. |
int |
1 2 |
||
CreatedDate |
The time and date when the record was created. |
datetime |
7/19/2017 10:28:12 AM 1/17/2021 12:01:45 PM |
||
StartDate |
The time and date when the approval process was started. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
DeadLine |
The approval’s deadline. |
datetime |
7/19/2017 10:28:12 AM 1/17/2021 12:01:45 PM |
||
FinishedDate |
The time and date when the approval was finally approved. |
datetime |
2025-09-01 10:09:23.948 |
||
CancelledDate |
The time and date when the approval was cancelled. |
datetime |
2025-08-10 10:00:54.156 |
||
CreateAnswerAutomatically |
Whether the approval is set up to automatically create an answer record. 0 = No. 1 = Yes. |
int |
0 1 |