*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
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 | PR link |
|---|---|---|---|
| agreements_package_content_item.sql | available | Stefan? | |
| feesfines_accounts_actions.sql | available | Natalya | |
| 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 | Joanne/Natalya | |
| 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 | |