You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »


The following derived tables are not getting created in Metadb Test because data types need to be fixed. Here is the status of 

a mini-project to fix them. Here is a link to our documentation for Making a Pull Request for FOLIO Analytics


Table NameStatusWho is Fixing/UpdatingNotesPR link
agreements_package_content_item.sqlavailableStefan?no records for CUL
feesfines_accounts_actions.sqlavailableNatalya

finance_transaction_purchase_orderavailableJoanne/SharonNot impacted by Poppy; needs updating only
finance_invoice_transactions.sqlavailableSharon/Ann

holdings_electronic_access.sqlnot availableNatalya

holdings_statistical_codes.sqlavailableNatalya

instance_ext.sqlavailableJoanne/Vandana

items_holdings_instances.sqlavailableJoanne/Vandana

openaccess_checklists.sqlnot available - low priority - no data in CUL FOLIO Prod


openaccess_publication_request.sqlnot available - low priority - no data in CUL FOLIO Prod


po_instance.sqlavailableNatalya/Joanneneed to verify if better to point to derived table po_lines_locations instead of extracting holdings id and locations id from JSON; see https://github.com/cul-it/cul-folio-analytics/blob/main/review/po_instance.sql
po_line_fund_distribution_transactions.sqlavailableSharon/Ann

po_lines_vendor_reference_numbers.sqlavailableSharon/Ann

po_lines_eresource.sqlavailableNatalya

po_lines_locations.sqlavailableNatalya

po_organization.sqlavailable -submittedSharon
https://github.com/folio-org/folio-analytics/pull/842
requests_items.sqlavailableJoanne/Vandana

users_groups.sqlavailableJoanne/Vandana






  • No labels