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:

  1. 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.

  2. 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.

Dossiers

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.

PartyRegistry

int

634489

856928

ReceiverPartyId

The ID of the request recipient.

PartyRegistry

int

189643

486907

ReceiverUnitPartyId

The ID of the request recipient’s unit.

PartyRegistry

Int

784994

65363

RequisitionCreator PartyId

The ID of the request creator.

PartyRegistry

int

634489

856928

RequisitionCreator UnitPartyId

The ID of the request creator’s unit.

PartyRegistry

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.

EnumTypeItems

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.

EnumTypeItems

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