Versions Compared

Key

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

...

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


Table NamePriorityStatusWho is Fixing/UpdatingNotesPR link
agreements_package_content_item.sql
available

restoredStefan?no records for CUL
feesfines_accounts_actions.sql
available

restoredNatalyafixed for data types, submitted PRhttps://github.com/folio-org/folio-analytics/pull/846
finance_transaction_purchase_order
available
HIGHrestored, needs updateJoanne/Sharon
Not impacted by Poppy; needs updating only
PR submittedhttps://github.com/folio-org/folio-analytics/pull/848
finance_invoice_transactions.sql
available

restoredSharon/Ann

holdings_electronic_access.sql
not available

missingCorrieCorrie to put in a PR to update the derived table and will send us instructions to fix our data. From Corrie: The holdings_electronic_access table issues are related to https://folio-org.atlassian.net/browse/UIIN-2787.  Essentially, if an empty relationshipId exists when Metadb expects a UUID, the table will fail to build.  Until we can fix the derived table, we've addressed it for Chicago by adding the appropriate UUID value.
holdings_ext (metadb)HIGHneeds updateVandana, Joanne, Linda

-(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.

-PR submitted for Metadb version
Natalya
holdings_statistical_codes.sql
available

restoredNatalyafixed for data types, submitted PRhttps://github.com/folio-org/folio-analytics/pull/844
instance_ext.sql
available

restoredJoanne/Vandana

item_ext.sql
needs updateDavid Bottorff, Joanne

The folio_derived.item_ext table in metadB is storing status_date as long text rather than as date/time. Need to check all date fields for this. 

(Joanne) would also be good to have effective_shelving_order field from folio_inventory.item table 

https://github.com/folio-org/folio-analytics/issues/860
items_holdings_instances.sql
available

restored, needs update for both LDP and Metadb versionsNatalya

(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
Joanne/Vandana
loans_renewal_dates.sql - both LDP and MetadbHIGHlow recordsJoanne

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

be using the folio_circulation.audit_loans__ table for the source, not the folio_circulation.loan table

just be one

-should discuss with Reporting SIG

-PRs submitted for LDP and Metadb
openaccess_checklists.sql

restored
Next Step: Sharon to ask Stefan to fix this one

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

restored

Next Step: Sharon to ask Stefan to fix this one


low priority - no data in CUL FOLIO Prod


po_instance.sql
available
(metadb)HIGHrestored, but needs updateNatalya/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

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/
cul
folio-
it
org/
cul-
folio-analytics/
blob/main/review/po_instance.sql
issues/851 
po_line_fund_distribution_transactions.sql
available

restoredSharon/Ann

po_lines_vendor_reference_numbers.sql
available

restoredSharon/Ann

po_lines_eresource.sql
available

restored, needs updateNatalya-will update with CASE WHEN to show deleted_holdings
po_lines_locations.sql
available

restored, needs updateNatalya-will update with CASE WHEN to show deleted_holdings
po_organization.sql
available -update submitted
(metadb)
restoredJoanne/Sharonfixed for data types and extracted more from JSON, submitted PRhttps://github.com/folio-org/folio-analytics/pull/842
requests_items.sql
available

restoredJoanne/Vandana

users_groups.sql
available

restored, needs updates to LDP and Metadb tablesJoanne/Vandana

-low priority

Next step: Joanne to fix these after other tables get fixed


LDP: the first subquery (creating the user_departments table) uses the users_departments_unpacked derived table, but doesn't specify "folio_reporting" as the schema. The department information from the custom fields (of the user_users table) is not properly extracted.

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
reviewedJoanneJoanne reviewed this table and it is fine