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 Name | Status | Who is Fixing/Updating | Notes | PR link |
---|---|---|---|---|
agreements_package_content_item.sql | available | Stefan? | no records for CUL | |
feesfines_accounts_actions.sql | available | Natalya | ||
finance_transaction_purchase_order | available | Joanne/Sharon | Not impacted by Poppy; needs updating only | |
finance_invoice_transactions.sql | available | Sharon/Ann | ||
holdings_electronic_access.sql | not available | Natalya | ||
holdings_statistical_codes.sql | available | Natalya | ||
instance_ext.sql | available | Joanne/Vandana | ||
items_holdings_instances.sql | available | Joanne/Vandana | ||
openaccess_checklists.sql | not available - low priority - no data in CUL FOLIO Prod | |||
openaccess_publication_request.sql | not available - low priority - no data in CUL FOLIO Prod | |||
po_instance.sql | available | Natalya/Joanne | need 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.sql | available | Sharon/Ann | ||
po_lines_vendor_reference_numbers.sql | available | Sharon/Ann | ||
po_lines_eresource.sql | available | Natalya | ||
po_lines_locations.sql | available | Natalya | ||
po_organization.sql | available -submitted | Sharon | https://github.com/folio-org/folio-analytics/pull/842 | |
requests_items.sql | available | Joanne/Vandana | ||
users_groups.sql | available | Joanne/Vandana | ||