Requisitions
The Requisitions dataset contains data regarding internal, external, and group requests.
It can be complicated to create reporting on the overall flow, lead times, etc. for requests. Contact cBrain for assistance with reporting projects. |
Importing to a BI database
Requests 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 Requisitions dataset. Changes in Dossiers thus mean that there may also be changes in Requisitions (also see Diagram of "Entity Relationship").
You should do the following when importing to a BI database:
-
Delete rows related to changed records in the existing Requisitions 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 Requisitions 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 |
---|---|---|---|---|---|
RequisitionInternalId |
The internal database ID of the request. |
bigint identity |
470 1289 |
||
InternalDossierId |
The internal database ID of the record of the request. |
bigint |
26784 63846 |
||
RequisitionDeadline |
The deadline specified in the request window. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RecipientAuthority PartyId |
The ID of the authority who received the request. Only relevant for group and external requests. |
int |
634489 856928 |
||
ReceiverPartyId |
The ID of the request recipient. |
int |
189643 486907 |
||
ReceiverUnitPartyId |
The ID of the request recipient’s unit. |
Int |
784994 65363 |
||
RequisitionCreator PartyId |
The ID of the request creator. |
int |
634489 856928 |
||
RequisitionCreator UnitPartyId |
The ID of the request creator’s unit. |
int |
189643 486907 |
||
RequisitionSentDate |
The time and date of when the request was sent. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RequisitionTypes |
Any types selected in the "Request type" field of the request window. |
nvarchar |
4000 |
Office answer See description |
|
AnswerReceivedDate |
The time and date the answer record was sent. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RequisitionApproved |
Whether the "Approved" field of the request window has been checked. Only relevant if evaluation has been enabled through a configuration. |
varchar |
3 |
Yes No |
|
RequisitionAssessment EnumTypeItemId |
The ID of the evaluation selected by the user in the drop-down list of the "Evaluation" field in the request window. Only relevant if evaluation has been enabled through a configuration. |
int |
64749 76593 |
||
RequisitionReceiver AssessmentEnumItemID |
The ID of the evaluation selected by the user in the drop-down list of the "Recipient evaluation" field in the request window. Only relevant if evaluation has been enabled through a configuration. |
int |
398 9027 |
||
RequisitionStatus |
The status of the request. |
varchar |
23 |
Approved Retracted Accepted |
|
MinutesToDeadline |
The number of minutes from a request has been executed - or its answer record has been sent - until the specified deadline specified in the request window. |
int |
1593 69 -45 |
||
AuthorityId |
The ID of the authority who sent the request. Only relevant for group and external requests. |
int |
634489 856928 |
||
RequisitionRetractedDate |
The time and date of when a request was cancelled by a user. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RequisitionAcceptedDate |
The time and date of when a request was accepted, i.e. a user clicked "Accept" or "Accept and close" in the request window. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RequisitionExecutedDate |
The time and date of when a request was executed, i.e. a user clicked "Executed" in the request window. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RequisitionAssessedDate |
The time and date of when a request was evaluated, i.e. a user selected a value in the "Evaluation" field of the request window. If evaluations have not been configured, the column shows when a user clicked "Finalise request" in the request window. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RequisitionInternalDeadline |
The deadline specified in the "Internal request deadline" field in the request window. |
datetime |
7/19/2017 10:28:12 AM 1/17/2022 12:01:45 PM |
||
RequisitionKind |
The type of request in question. |
varchar |
18 |
Internal Group External |