DCB-1081 Patron Request data presentation and source

Description

This document is used to keep track of patron request data used in the DataGrids.
Field label - the label that the GraphGL data is displayed under.
GraphGL source - the JSON value where data is stored.
For everything in the GraphQL source column, assume patronRequest is before each one.
Translation key - the corresponding translation key, which is used to store the field label.
Missing - the value is currently not displayed in the datagrids

Patron Requests

Field label (column)	GraphQL source	Translation key	Example (source)

Field label (column)	GraphQL source	Translation key	Example (source)
Request created	`dateCreated`	`details.request_created`	2024-04-29 14:48
Patron host LMS code	`patronHostlmsCode`	`details.patron_hostlms`
Patron barcode	`requestingIdentity.localBarcode`	-	[0077777777]
Title	`clusterRecord?.title`
Supplying agency	`suppliers[0].localAgency`	`details.supplying_agency_code`	6wmdp
Status	`status`	`details.status`	REQUEST_PLACED_AT_SUPPLYING_AGENCY
Error message	`errorMessage`	`-`	[empty]
Out of sequence	`outOfSequenceFlag`	`details.is_transition_out_of_sequence`	false
Polling count	`pollCountForCurrentStatus`	`details.polling_checks_in_status`	[empty]
Time in state	`elapsedTimeInCurrentStatus`	`details.time_in_status`	2024-04-29 14:48
Request updated	`dateUpdated`	`details.record_updated`	2024-04-29 14:48
Request ID	`id`	`details.request_id`	[UUID]
NOT USED	`pickupLocationCode`	`details.pickup_code`	[UUID]
missing	`nextScheduledPoll`	`details.next_poll`
missing	`patron.id`	`details.patron_id`
missing	`requestingIdentity.id`	`details.requestor_id`
missing	`requestingIdentity.localId`	`details.borrowing_patron_id`

Patron Request by ID

GQL Source

Field label	GraphQL source	Example (source)

Field label	GraphQL source	Example (source)
Request ID
Request updated	`dateUpdated`
Patron HostLMS code	`patronHostlmsCode`
Bib cluster ID	`bibClusterId`
Pickup location code	`pickupLocationCode`
Pickup patron ID	`pickupPatronId`
Pickup item ID	`pickupItemId`
Pickup item type	`pickupItemType`
Pickup item status	`pickupItemStatus`
Pickup request ID	`pickupRequestId`
Pickup request status	`pickupRequestStatus`
Status	`status`
Pickup request ID	`localRequestId`
Pickup request status	`localRequestStatus`
Virtual item ID	`localItemId`
Virtual item status	`localItemStatus`
Virtual item type	`localItemType`
Virtual Bib ID	`localBibId`
Description	`description`
Last check for updates	`nextScheduledPoll`
Error message	`errorMessage`
Previous status	`previousStatus`
Polling checks in status	`pollCountForCurrentStatus`
Status changed	`currentStatusTimestamp`
Next expected status	`nextExpectedStatus`
Transition out of sequence?	`outOfSequenceFlag`
Time in status	`elapsedTimeInCurrentStatus`
Patron ID	`patron.id`
Patron ID at requesting agency	`requestingIdentity.id`
Local patron ID	`requestingIdentity.localId`
missing	`requestingIdentity.homeIdentity`
Local patron barcode	`requestingIdentity.localBarcode`
missing	`requestingIdentity.localNames`
Local patron type	`requestingIdentity.localPtype`
missing	`requestingIdentity.canonicalPtype`	`
missing	`requestingIdentity.localHomeLibraryCode`
missing	`requestingIdentity.lastValidated`
missing	`audit.id`
missing	`audit.auditDate`
missing	`audit.briefDescription`
missing	`audit.fromStatus`
missing	`audit.toStatus`
missing	`audit.auditData`
missing	`clusterRecord.id`
Contributor title	`clusterRecord.title`
Selected bib	`clusterRecord.selectedBib`
missing	`clusterRecord.isDeleted`
missing	`clusterRecord.dateCreated`
Record updated	`clusterRecord.dateUpdated`
missing	`clusterRecord.members.id`
missing	`clusterRecord.members.dateCreated`
missing	`clusterRecord.members.dateUpdated`
missing	`clusterRecord.members.title`
Author	`clusterRecord.members.author`
missing	`clusterRecord.members.placeOfPlublication`
missing	`clusterRecord.members.publisher`
missing	`clusterRecord.members.dateOfPublication`
missing	`clusterRecord.members.edition`
missing	`clusterRecord.members.isLargePrint`
missing	`clusterRecord.members.clusterReason`
missing	`clusterRecord.members.typeOfRecord`
missing	`clusterRecord.members.canonicalMetadata`
missing	`clusterRecord.members.metadataScore`
missing	`clusterRecord.members.processVersion`
Source system ID	`clusterRecord.members.sourceSystemId`
Source record ID	`clusterRecord.members.sourceRecordId`
missing	`clusterRecord.members.sourceRecord.id`
missing	`clusterRecord.members.sourceRecord.hostLmsId`
missing	`clusterRecord.members.sourceRecord.remoteId`
missing	`clusterRecord.members.sourceRecord.json`
Request created	`dateCreated`
Active workflow	`activeWorkflow`
Requestor note	`requestorNote`
Supplier ID