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

Request updated

dateUpdated

Field label (column)	GraphQL source	Translation key	Example (source)
Request created	`dateCreated`

2024-04-29 14:48

[empty]

details.request_created

2024-04-29 14:48

Description

description

Requesting agency

suppliers.localAgency

6wmdp

Pickup location

pickupLocationCode

[UUID]

Request ID

id

[UUID]

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

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

...

missingVirtual item type

missingLast check for updates

missingPolling checks in status

missing

missingPatron ID

missingLocal patron type

Contributor title

clusterRecord.titlemissing

missingRecord updated

missingLocal patron type

Field label

GraphQL source

Example (source)

Request ID

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

Status

title

missingPickup request ID

localRequestId

Pickup request status

title	missing

localRequestStatus

Status

title	missing

Virtual item ID

localItemId

Virtual item statustitle

missing

localItemStatus

Status

title	missing

localItemType

Status

title

localItemType

Virtual Bib ID

localBibId

statusDescription

title	missing

description

Status

title	missing

nextScheduledPoll

Status

title

nextScheduledPoll

Error message

errorMessage

Previous statustitle

missing

previousStatus

Status

title

pollCountForCurrentStatus

Status

title	missing

Status changed

currentStatusTimestamp

Next expected status

title

nextExpectedStatus

Status

title	missing

Transition out of sequence?

outOfSequenceFlag

Time in status

title	missing

elapsedTimeInCurrentStatus

Status

title

patron.id

Status

title	missing

Patron ID at requesting agency

requestingIdentity.id

Status

title	missing

Local patron ID

requestingIdentity.localId

Status

title	missing

requestingIdentity.homeIdentity

Status

title	missing

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

missing

Status

title

Selected bib

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

statusAuthor

title	missing

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	missing

Source system ID

clusterRecord.members.sourceSystemId

Status

title	missing

Source record ID

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	missing

dateCreated

Status

title	missing

activeWorkflow

Status

title	missing

requestorNote

Status

title	missing

suppliers.id

Status

title	missing

suppliers.canonicalItemType

Status

title	missing

suppliers.dateCreated

Status

title	missing

suppliers.dateUpdated

Status

title	missing

suppliers.hostLmsCodeRequest 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

Status

title	missing

suppliers.isActive.virtualPatron.id

Local ID

suppliers.virtualPatron.localId

Status

title	missing

suppliers.virtualPatron.homeIdeniity

Local barcode

suppliers.localItemIdvirtualPatron.localBarcode

Status

title	missing

suppliers.virtualPatron.localBibIdlocalNames

Status

title

suppliers.virtualPatron.localPtype

DCB patron type

suppliers.localItemBarcodevirtualPatron.canonicalPtype

Status

title	missing

suppliers.virtualPatron.localItemLocationCodelocalHomeLibraryCode

Status

title	missing

Status

title	missing

suppliers.localId

Status

title	missing

suppliers.localStatus

Status

title	missing

suppliers.localAgency

Status

title	missing

suppliers.virtualPatron.id

Status

title	missing

suppliers.virtualPatron.localId

Status

title	missing

suppliers.virtualPatron.homeIdeniity

Status

title	missing

suppliers.virtualPatron.localBarcode

Status

title	missing

suppliers.virtualPatron.localNames

Status

title	missing

suppliers.virtualPatron.localPtype

Status

title	missing

suppliers.localItemStatus

Status

title	missing

suppliers.localItemType

.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`

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

suppliers.virtualPatron.localHomeLibraryCode

Status

title	missing

suppliers.virtualPatron.lastValidated

...

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	Example (source)

...


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	Example (source)

...


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	Example (source)

...


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 4	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

General

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