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	Translation key	Example (source)
Request created	`dateCreated`	`details.request_created`	2024-04-29 14:48
Request updated	`dateUpdated`	`details.record_updated`	2024-04-29 14:48
Description	`description`	`details.description`	[empty]
Patron barcode	`requestingIdentity.localBarcode`	Can not find	[0077777777]
Status	`status`	`details.status`	REQUEST_PLACED_AT_SUPPLYING_AGENCY
Transition out of sequence?	`outOfSequenceFlag`	`details.is_transition_out_of_sequence`	false
Requesting agency	`suppliers.localAgency`	`details.supplying_agency_code`	6wmdp
Pickup location	`pickupLocationCode`	`details.pickup_code`	[UUID]
Request ID	`id`	`details.request_id`	[UUID]
Polling count	`pollCountForCurrentStatus`	`details.polling_checks_in_status`	[empty]
Time in state	`elapsedTimeInCurrentStatus`	`details.time_in_status`	2024-04-29 14:48
MISSING	`patronHostlmsCode`	`details.patron_hostlms`
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)
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	`suppliers.id`
Canonical item type	`suppliers.canonicalItemType`
Date created	`suppliers.dateCreated`
Request updated	`suppliers.dateUpdated`
code	`suppliers.hostLmsCode`
isActive	`suppliers.isActive`
Local item ID	`suppliers.localItemId`
Local Bib ID	`suppliers.localBibId`
Local item barcode	`suppliers.localItemBarcode`
Local item location code	`suppliers.localItemLocationCode`
Local item status	`suppliers.localItemStatus`
Local item type	`suppliers.localItemType`
Local supplier request ID	`suppliers.localId`
Local request status	`suppliers.localStatus`
Supplying agency code	`suppliers.localAgency`
MISSING	`suppliers.virtualPatron.id`
Local ID	`suppliers.virtualPatron.localId`
MISSING	`suppliers.virtualPatron.homeIdeniity`
Local barcode	`suppliers.virtualPatron.localBarcode`
MISSING	`suppliers.virtualPatron.localNames`
Local patron type	`suppliers.virtualPatron.localPtype`
DCB patron type	`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	`dateCreated`	`details.request_created`
Request updated	`dateUpdated`	`details.request_updated`

Bib record

Field label	GraphQL source	Translation key
Bib cluster ID	`bibClusterId`	`details.bib_cluster_id`
Title	`clusterRecord.title`	`details.title`
Author	`clusterRecord.members.author`	`details.author`
Record created	`clusterRecord.dateCreated`	`details.record_created`
Record updated	`clusterRecord.dateUpdated`	`details.record_updated`
Selected bib	`clusterRecord.selectedBib`	`details.selected_bib`
Source record ID	`clusterRecord.members.sourceRecordId`	`details.source_record_id`
Source system ID	`clusterRecord.sourceSystemId`	`details.source_system_id`

Supplying

Field label	GraphQL source	Translation key
Supplying agency code	`suppliers.localAgency`	`details.supplying_agency_code`
Supplier ID	`suppliers.id`	`details.supplier_id`
Canonical item type	`suppliers.canonicalItemType`	`details.supplier_ctype`
Date created	`suppliers.dateCreated`	`details.date_created`
Date updated	`suppliers?.dateUpdated`	`details.date_updated`
code	`suppliers.hostLmsCode`	`details.code`
isActive	`suppliers.isActive`	`details.active`
Local Bib ID	`suppliers.localBibId`	`details.local_bib_id`
Local supplier request ID	`suppliers.localId`	`details.local_supplier_id`
Local request status	`suppliers.localStatus`	`details.local_request_status`

Borrowing

Field label	GraphQL source	Translation key
Pickup request ID	`localRequestId`	`details.borrowing_request_id`
Pickup request status	`localRequestStatus`	`details.borrowing_request_status`
Local item ID	`localItemId`	`details.local_item_id`
Host LMS code	`localItemStatus`	`hostlms.code`
Local Bib ID	`localBibId`	`details.local_bib_id`

Pickup

Field label	GraphQL source	Translation key
Pickup location code	`pickupLocationCode`	`details.pickup_code`
Pickup patron ID	`pickupPatronId`	`details.pickup_patron_id`
Pickup request ID	`pickupRequestId`	`details.pickup_request_id`
Pickup request status	`pickupRequestStatus`	`details.pickup_request_status`

Audit log

Field label (column)	GraphQL source	Example (source)
Audit date	`auditDate`
Description	`briefDescription`
fromStatus	`fromStatus`
toStatus	`toStatus`

Audit Detail

Audit detail

Field label	GraphQL source	Translation key
Audit ID	`id`	`details.audit_id`
Audit date	`auditDate`	`details.audit_date`
Brief description	`audit.briefDescription`	`details.audit_description`
fromStatus	`audit.fromStatus`	`details.audit_from_status`
toStatus	`audit.toStatus`	`details.audit_to_status`
MISSING	`audit.auditData`
Patron request ID	`audit.patronRequest.id`	`details.patron_request_id`