Versions Compared

Version Old Version 2 New Version Current
Changes made by

Jag Goraya

Jag Goraya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

https://openlibraryfoundation.atlassian.net/issues/?jql=issueKey%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
titlemissing

nextScheduledPoll

details.next_poll

Status
titlemissing

patron.id

details.patron_id

Status
titlemissing

requestingIdentity.id

details.requestor_id

Status
titlemissing

requestingIdentity.localId

details.borrowing_patron_id

Patron Request by ID

...

missingRequest ID

missingPatron HostLMS code

missingBib cluster ID

missingPickup location code

missingPickup patron ID

missingPickup item ID

missingLocal patron barcode

Contributor titlemissing

missingSelected bib

missingRecord updated

missingAuthor

missingSource system ID

missingSource record ID

missingLocal patron type

Field label

GraphQL source

Example (source)

Status
titleMISSING

id

Status
title

Request updated

dateUpdated

Status
title

patronHostlmsCode

Status
title

bibClusterId

Status
title

pickupLocationCode

Status
title

pickupPatronId

Status
titlemissing

pickupItemId

Status
titlemissing

pickupItemType

Status
titlemissing

pickupItemStatus

Status
titlemissing

pickupRequestId

Status
titlemissing

pickupRequestStatus

Status
titlemissing

status

Status
titlemissing

localRequestId

Status
titlemissing

localRequestStatus

Status
titlemissing

localItemId

Status
titlemissing

localItemStatus

Status
titlemissing

localItemType

Status
titlemissing

localBibId

Status
titlemissing

description

Status
titlemissing

nextScheduledPoll

Status
titlemissing

errorMessage

Status
titlemissing

previousStatus

Status
titlemissing

pollCountForCurrentStatus

Status
titlemissing

currentStatusTimestamp

Status
titlemissing

nextExpectedStatus

Status
titlemissing

outOfSequenceFlag

Status
titlemissing

elapsedTimeInCurrentStatus

Status
titlemissing

patron.id

Status
titlemissing

requestingIdentity.id

Status
title

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
titlemissing

requestingIdentity.homeIdentity

Status
title

requestingIdentity.localBarcode

Status
titlemissing

requestingIdentity.localNames

Status
titlemissing

Local patron type

requestingIdentity.localPtype

Status
titlemissing

requestingIdentity.canonicalPtype

`

Status
titlemissing

requestingIdentity.localHomeLibraryCode

Status
titlemissing

requestingIdentity.lastValidated

Status
titlemissing

audit.id

Status
titlemissing

audit.auditDate

Status
titlemissing

audit.briefDescription

Status
titlemissing

audit.fromStatus

Status
titlemissing

audit.toStatus

Status
titlemissing

audit.auditData

Status
titlemissing

clusterRecord.id

Status

clusterRecord.title

Status
title

clusterRecord.selectedBib

Status
titlemissing

clusterRecord.isDeleted

Status
titlemissing

clusterRecord.dateCreated

Status
title

clusterRecord.dateUpdated

Status
titlemissing

clusterRecord.members.id

Status
titlemissing

clusterRecord.members.dateCreated

Status
titlemissing

clusterRecord.members.dateUpdated

Status
titlemissing

clusterRecord.members.title

Status
title

clusterRecord.members.author

Status
titlemissing

clusterRecord.members.placeOfPlublication

Status
titlemissing

clusterRecord.members.publisher

Status
titlemissing

clusterRecord.members.dateOfPublication

Status
titlemissing

clusterRecord.members.edition

Status
titlemissing

clusterRecord.members.isLargePrint

Status
titlemissing

clusterRecord.members.clusterReason

Status
titlemissing

clusterRecord.members.typeOfRecord

Status
titlemissing

clusterRecord.members.canonicalMetadata

Status
titlemissing

clusterRecord.members.metadataScore

Status
titlemissing

clusterRecord.members.processVersion

Status
title

clusterRecord.members.sourceSystemId

Status
title

clusterRecord.members.sourceRecordId

Status
titlemissing

clusterRecord.members.sourceRecord.id

Status
titlemissing

clusterRecord.members.sourceRecord.hostLmsId

Status
titlemissing

clusterRecord.members.sourceRecord.remoteId

Status
titlemissing

clusterRecord.members.sourceRecord.json

Status
titlemissing

dateCreated

Status
titlemissing

activeWorkflow

Status
titlemissing

requestorNote

Status
titlemissing

suppliers.id

Status
titlemissing

suppliers.canonicalItemType

Status
titlemissing

suppliers.dateCreated

Status
titlemissing

suppliers.dateUpdated

Status
titlemissing

suppliers.hostLmsCode

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

Status
titlemissing

suppliers.virtualPatron.id

Local ID

suppliers.isActivevirtualPatron.localId

Status
titlemissing

suppliers.virtualPatron.homeIdeniity

Local barcode

suppliers.virtualPatron.localItemIdlocalBarcode

Status
titlemissing

suppliers.virtualPatron.localBibIdlocalNames

Status
title

suppliers.virtualPatron.localPtype

DCB patron type

suppliers.localItemBarcodevirtualPatron.canonicalPtype

Status
titlemissing

suppliers.virtualPatron.localItemLocationCodelocalHomeLibraryCode

Status
titlemissing

Status
titlemissing

suppliers.localId

Status
titlemissing

suppliers.localStatus

Status
titlemissing

suppliers.localAgency

Status
titlemissing

suppliers.virtualPatron.id

Status
titlemissing

suppliers.virtualPatron.localId

Status
titlemissing

suppliers.virtualPatron.homeIdeniity

Status
titlemissing

suppliers.virtualPatron.localBarcode

Status
titlemissing

suppliers.virtualPatron.localNames

Status
titlemissing

suppliers.virtualPatron.localPtype

Status
titlemissing

suppliers.localItemStatus

Status
titlemissing

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

Example (source)

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

Example (source)

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

Example (source)

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
titlemissing

suppliers.virtualPatron.localHomeLibraryCode

Status
titlemissing

suppliers.virtualPatron.lastValidated

...

Borrowing

Field label

GraphQL source

Translation key

Example (source)

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
titleMISSING

Status
titlemissing

Status
titleMISSING

Pickup - Virtual item

Field label

GraphQL source

Translation key

Example (source)

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

...

Field label

GraphQL source

Translation key

Example (source)

statusAudit ID

titlemissing

id

Status
titlemissing

auditDate

Status
titlemissing

briefDescription

Status
titlemissing

fromStatus

Status
titlemissing

toStatusid

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

Status
titlemissing

audit.auditData

Status
titlemissing
patronRequest.
MISSING

Patron request ID

audit.patronRequest.id

details.patron_request_id