Page Comparison

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%20DESCissueKey%20in%20(DCB-1081%2C%20DCB-1116)%20ORDER%20BY%20created%20DESC

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)
Request created	`dateCreated`

2024-04-29 14:48

Request updated

dateUpdated[empty]

details.request_created

2024-04-29 14:48

Description

description

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`

false

Requesting agency

suppliers.localAgency

6wmdp

Pickup location

pickupLocationCode

[UUID]

Request ID

id

[UUID]

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]

Status

title

missingpatronHostlmsCode

	NOT USED

pickupLocationCode

details.pickup_code

[UUID]

Status

title	missing

nextScheduledPoll

details.next_poll

Status

title	missing

patron.id

details.patron_id

Status

title	missing

requestingIdentity.id

details.requestor_id

Status

title	missing

requestingIdentity.localId

details.borrowing_patron_id

Patron Request by ID

...

missingLocal patron type

Contributor titlemissing

missingSelected bib

missingRecord updated

missingAuthor

missingSource system ID

missingSource record ID

missingRequest created

missingActive workflow

missingRequestor note

missingDate created

missingcode

missingisActive

missingLocal item ID

missingLocal Bib ID

missingLocal item barcode

missingLocal item location code

missing

missingLocal item type

missingLocal supplier request ID

missingSupplying agency code

missingLocal ID

missingLocal barcode

missingLocal patron type

missingDCB patron type

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

Status

title	missing

requestingIdentity.homeIdentity

Local patron barcode

requestingIdentity.localBarcode

Status

title	missing

requestingIdentity.localNames

Status

title

requestingIdentity.localPtype

Status

title	missing

requestingIdentity.canonicalPtype

`

Status

title	missing

requestingIdentity.localHomeLibraryCode

Status

title	missing

requestingIdentity.lastValidated

Status

title	missing

audit.id

Status

title	missing

audit.auditDate

Status

title	missing

audit.briefDescription

Status

title	missing

audit.fromStatus

Status

title	missing

audit.toStatus

Status

title	missing

audit.auditData

Status

title	missing

clusterRecord.id

Status

clusterRecord.title

Status

title

clusterRecord.selectedBib

Status

title	missing

clusterRecord.isDeleted

Status

title	missing

clusterRecord.dateCreated

Status

title

clusterRecord.dateUpdated

Status

title	missing

clusterRecord.members.id

Status

title	missing

clusterRecord.members.dateCreated

Status

title	missing

clusterRecord.members.dateUpdated

Status

title	missing

clusterRecord.members.title

Status

title

clusterRecord.members.author

Status

title	missing

clusterRecord.members.placeOfPlublication

Status

title	missing

clusterRecord.members.publisher

Status

title	missing

clusterRecord.members.dateOfPublication

Status

title	missing

clusterRecord.members.edition

Status

title	missing

clusterRecord.members.isLargePrint

Status

title	missing

clusterRecord.members.clusterReason

Status

title	missing

clusterRecord.members.typeOfRecord

Status

title	missing

clusterRecord.members.canonicalMetadata

Status

title	missing

clusterRecord.members.metadataScore

Status

title	missing

clusterRecord.members.processVersion

Status

title

clusterRecord.members.sourceSystemId

Status

title

clusterRecord.members.sourceRecordId

Status

title	missing

clusterRecord.members.sourceRecord.id

Status

title	missing

clusterRecord.members.sourceRecord.hostLmsId

Status

title	missing

clusterRecord.members.sourceRecord.remoteId

Status

title	missing

clusterRecord.members.sourceRecord.json

Status

title

dateCreated

Status

title

activeWorkflow

Status

title

requestorNote

Status

title	missing

Supplier ID

suppliers.id

Status

title	missing

Canonical item type

suppliers.canonicalItemType

Status

title

suppliers.dateCreated

Status

title	missing

Request updated

suppliers.dateUpdated

Status

title

suppliers.hostLmsCode

Status

title

suppliers.isActive

Status

title

suppliers.localItemId

Status

title

suppliers.localBibId

Status

title

suppliers.localItemBarcode

Status

title

suppliers.localItemLocationCode

Local item status

title

suppliers.localItemStatus

Status

title

suppliers.localItemType

Status

title

suppliers.localId

Local request status

title	missing

suppliers.localStatus

Status

title

suppliers.localAgency

Status

title	missing

suppliers.virtualPatron.id

Status

title

suppliers.virtualPatron.localId

Status

title	missing

suppliers.virtualPatron.homeIdeniity

Status

title

suppliers.virtualPatron.localBarcode

Status

title	missing

suppliers.virtualPatron.localNames

Status

title

suppliers.virtualPatron.localPtype

Status

title

suppliers.virtualPatron.canonicalPtype

Status

title	missing

suppliers.virtualPatron.localHomeLibraryCode

Status

title	missing

suppliers.virtualPatron.lastValidated

...

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`

Source Record

Field label	GraphQL source	Translation key	Example (source)
Source record	`clusterRecord.members.sourceRecord`	`details.source_record`

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`

Supplying - Item

Field label	GraphQL source	Translation key
Local item ID	`suppliers.localItemId`	`details.local_item_id`
Local item barcode	`suppliers.localItemBarcode`	`details.local_item_barcode`
Local item location code	`suppliers.localItemLocationCode`	`details.local_item_loc`
Local item status	`suppliers.localItemStatus`	`details.local_item_status`
Local item type	`suppliers.localItemType`	`details.local_item_type`

Suppling - Virtual patron

Field label

GraphQL source

Translation key

Example (source)

Local ID

suppliers.virtualPatron.localId

details.local_id

Local barcode

suppliers.virtualPatron.localBarcode

details.local_barcode

Local patron type

suppliers.virtualPatron.localPtype

details.borrowing_patron_type

DCB patron type

patronRequest.suppliers.virtualPatron.canonicalPtype

Status

title	missing

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`

Borrowing - Patron

Field label	GraphQL source	Translation key
Patron ID	`patron.id`	`details.patron_id`
Patron HostLMS code	`patronHostlmsCode`	`details.patron_hostlms`
Patron ID at requesting agency	`requestingIdentity.id`	`details.requestor_id`
Local patron type	`requestingIdentity.localPtype`	`details.borrowing_patron_type`
Local patron ID	`requestingIdentity.localId`	`details.borrowing_patron_id`
Local patron barcode	`requestingIdentity.localBarcode`	`details.borrowing_patron_barcode`

Borrowing - Virtual item

Field label	GraphQL source	Translation key
Virtual item ID	`localItemId`	`details.borrowing_virtual_id`
Virtual item status	`localItemStatus`	`details.borrowing_virtual_item_status`
Virtual item type	`localItemType`	`details.borrowing_virtual_type`
Virtual Bib ID	`localBibId`	`details.borrowing_virtual_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`

Pickup - Virtual patron (empty accordion)

Field label

GraphQL source

Translation key

Example (source)

Status

title	MISSING

Status

title	missing

Status

title	MISSING

Pickup - Virtual item

Field label	GraphQL source	Translation key
Pickup item ID	`patronRequest.pickupItemId`	`details.pickup_item_id`
Pickup item status	`patronRequest.pickupItemStatus`	`details.pickup_item_status`
Pickup item type	`patronRequest.pickupItemType`	`details.pickup_item_type`

Audit log

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

Audit Detail

...

missingid

Field label

GraphQL source

Translation key

Example (source)

statusAudit ID

title	missing

id

Status

title

details.audit_id

Audit date

auditDate

Status

title	missing

briefDescription

Status

title	missing

fromStatus

Status

title	missing

toStatusdetails.audit_date

Brief description

audit.briefDescription

details.audit_description

fromStatus

audit.fromStatus

details.audit_from_status

toStatus

audit.toStatus

details.audit_to_status

Status

title	missing

audit.auditData

Status

title	MISSINGmissing

Patron request ID

audit.patronRequest.id

details.patron_request_id

Version	Old Version 6	New Version Current
Changes made by	Millie Wilkinson	Jag Goraya
Saved on	Apr 30, 2024	May 11, 2024

Page Comparison

Versions Compared

Key

Description

Patron Requests

Patron Request by ID

Bib record

Source Record

Supplying

Supplying - Item

Suppling - Virtual patron

Borrowing

Borrowing - Patron

Borrowing - Virtual item

Pickup

Pickup - Virtual patron (empty accordion)

Pickup - Virtual item

Audit log

Audit Detail