DCB-1081 Patron Request data presentation and source

https://openlibraryfoundation.atlassian.net/issues/?jql=text%20~%20%22DCB-1081*%22%20or%20summary%20~%20%22DCB-1081*%22%20or%20key%20%3D%20DCB-1081%20ORDER%20BY%20created%20DESC

Patron Requests

Field label (column)	GraphQL source	Example (source)
Request created	`dateCreated`	2024-04-29 14:48
Request updated	`dateUpdated`	2024-04-29 14:48
Description	`description`	[empty]
Patron barcode	`requestingIdentity.localBarcode`	[0077777777]
Status	`status`	REQUEST_PLACED_AT_SUPPLYING_AGENCY
Out of sequence	`outOfSequenceFlag`	false
Requesting agency	`suppliers.localAgency`	6wmdp
Pickup location	`pickupLocationCode`	[UUID]
Request ID	`id`	[UUID]
Polling count	`pollCountForCurrentStatus`	[empty]
Time in state	`elapsedTimeInCurrentStatus`	2024-04-29 14:48
MISSING	`patronHostlmsCode`
MISSING	`nextScheduledPoll`
MISSING	`patron.id`
MISSING	`requestingIdentity.id`
MISSING	`requestingIdentity.localId`

Patron Request by ID

GQL 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`
MISSING	`clusterRecord.title`
MISSING	`clusterRecord.selectedBib`
MISSING	`clusterRecord.isDeleted`
MISSING	`clusterRecord.dateCreated`
MISSING	`clusterRecord.dateUpdated`
MISSING	`clusterRecord.members.id`
MISSING	`clusterRecord.members.dateCreated`
MISSING	`clusterRecord.members.dateUpdated`
MISSING	`clusterRecord.members.title`
MISSING	`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`
MISSING	`clusterRecord.members.sourceSystemId`
MISSING	`clusterRecord.members.sourceRecordId`
MISSING	`clusterRecord.members.sourceRecord.id`
MISSING	`clusterRecord.members.sourceRecord.hostLmsId`
MISSING	`clusterRecord.members.sourceRecord.remoteId`
MISSING	`clusterRecord.members.sourceRecord.json`
MISSING	`dateCreated`
MISSING	`activeWorkflow`
MISSING	`requestorNote`
MISSING	`suppliers.id`
MISSING	`suppliers.canonicalItemType`
MISSING	`suppliers.dateCreated`
MISSING	`suppliers.dateUpdated`
MISSING	`suppliers.hostLmsCode`
MISSING	`suppliers.isActive`
MISSING	`suppliers.localItemId`
MISSING	`suppliers.localBibId`
MISSING	`suppliers.localItemBarcode`
MISSING	`suppliers.localItemLocationCode`
MISSING	`suppliers.localItemStatus`
MISSING	`suppliers.localItemType`
MISSING	`suppliers.localId`
MISSING	`suppliers.localStatus`
MISSING	`suppliers.localAgency`
MISSING	`suppliers.virtualPatron.id`
MISSING	`suppliers.virtualPatron.localId`
MISSING	`suppliers.virtualPatron.homeIdeniity`
MISSING	`suppliers.virtualPatron.localBarcode`
MISSING	`suppliers.virtualPatron.localNames`
MISSING	`suppliers.virtualPatron.localPtype`
MISSING	`suppliers.virtualPatron.canonicalPtype`
MISSING	`suppliers.virtualPatron.localHomeLibraryCode`
MISSING	`suppliers.virtualPatron.lastValidated`

General

Field label	GraphQL source	Translation key	Example (source)
Request ID	`id`	`details.request_id`	4b6e37e9-bdad-4c3e-b625-dd9a6336d372
Request created
Request updated

Bib record

Field label	GraphQL source	Example (source)

Supplying

Field label	GraphQL source	Example (source)

Borrowing

Field label	GraphQL source	Example (source)

Pickup

Field label	GraphQL source	Example (source)

Audit log

Field label (column)	GraphQL source	Example (source)

Audit Detail

Audit detail

Field label	GraphQL source	Example (source)
MISSING	`id`
MISSING	`auditDate`
MISSING	`briefDescription`
MISSING	`fromStatus`
MISSING	`toStatus`
MISSING	`auditData`
MISSING	`patronRequest.id`