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 | restored | Stefan? | no records for CUL | |
| feesfines_accounts_actions.sql | restored | Natalya | fixed for data types, submitted PR | https://github.com/folio-org/folio-analytics/pull/846 |
| finance_transaction_purchase_order | restored, needs update | Joanne/Sharon | PR submitted | https://github.com/folio-org/folio-analytics/pull/848 |
| finance_invoice_transactions.sql | restored | Sharon/Ann | ||
| holdings_electronic_access.sql | missing | Natalya | Next Step: Sharon to reach out to Stefan and Nassib for help with this one | |
| holdings_ext | needs update | Ask Christie to fix | -(Linda) The holdings_supress field needs to be cast as Boolean. It is currently cast as varchar. (Joanne) The json extract for ill_policy_id also needs to be cast as UUID. -(Christie) the holdings_ext table is bringing in the created by userid rather than the updated_by_user_ud for the updated_by field. The location of the data being pulled needs to be updated so that the updated_by_user_id is what is being pulled from the json. | |
| holdings_statistical_codes.sql | restored | Natalya | fixed for data types, submitted PR | https://github.com/folio-org/folio-analytics/pull/844 |
| instance_ext.sql | restored | Joanne/Vandana | ||
| items_holdings_instances.sql | restored, needs update for both LDP and Metadb versions | Natalya | (LDP) in the items_holdings_instances table, the column instance_hrid is showing the same value as the holdings_hrid instead of the instance's hrid (Metadb) instance and holdings HRIDs need to be added; effective call number also missing | -PR submitted for LDP version |
| loans_renewal_dates.sql - both LDP and Metadb | low records | Joanne | Next Step: Joanne to first work on LDP version and give to Sharon/Vandana for PR -will rewrite so that inflated counts of renewals are not made -each step of processing is counted as a renewal, when it should just be one -should discuss with Reporting SIG | |
| openaccess_checklists.sql | restored | Next Step: Sharon to ask Stefan to fix this one low priority - no data in CUL FOLIO Prod | ||
| openaccess_publication_request.sql | restored | Next Step: Sharon to ask Stefan to fix this one low priority - no data in CUL FOLIO Prod | ||
| po_instance.sql | restored, but needs update | Natalya/Joanne | Next Step - Natalya to update Metadb version and submit PR -updated to extract holdings and locations ids from JSON rather than pointing to a derived table | https://github.com/folio-org/folio-analytics/issues/851 |
| po_line_fund_distribution_transactions.sql | restored | Sharon/Ann | ||
| po_lines_vendor_reference_numbers.sql | restored | Sharon/Ann | ||
| po_lines_eresource.sql | restored, needs update | Natalya | -will update with CASE WHEN to show deleted_holdings | |
| po_lines_locations.sql | restored, needs update | Natalya | -will update with CASE WHEN to show deleted_holdings | |
| po_organization.sql | restored | Joanne/Sharon | fixed for data types and extracted more from JSON, submitted PR | https://github.com/folio-org/folio-analytics/pull/842 |
| requests_items.sql | restored | Joanne/Vandana | ||
| users_groups.sql | restored, needs updates to LDP and Metadb tables | Joanne/Vandana | -low priority Next step: Joanne to fix these after other tables get fixed MetaDB: the code does not specify the folio_derived schema for the user_departments subquery. Also, the MetaDB version is lacking the "user_tags" and "user_custom_fields" fields that are in the LDP version. | |
| loan_renewals_counts | reviewed | Joanne | Joanne reviewed this table and it is fine |