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`
MISSING	`localItemStatus`
MISSING	`localItemType`
MISSING	`localBibId`
MISSING	`description`
MISSING	`nextScheduledPoll`
MISSING	`errorMessage`
MISSING	`previousStatus`
MISSING	`pollCountForCurrentStatus`
MISSING	`currentStatusTimestamp`
MISSING	`nextExpectedStatus`
MISSING	`outOfSequenceFlag`
MISSING	`elapsedTimeInCurrentStatus`
MISSING	`patron.id`
MISSING	`requestingIdentity.id`
MISSING	`requestingIdentity.localId`
MISSING	`requestingIdentity.homeIdentity`
MISSING	`requestingIdentity.localBarcode`
MISSING	`requestingIdentity.localNames`
MISSING	`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`