Skip to content

Latest commit

 

History

History
 
 

derived_tables

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
deps.txt
deps.txt
 
 
feesfines_accounts_actions.sql
feesfines_accounts_actions.sql
 
 
finance_transaction_invoices.sql
finance_transaction_invoices.sql
 
 
finance_transaction_purchase_order.sql
finance_transaction_purchase_order.sql
 
 
holdings_electronic_access.sql
holdings_electronic_access.sql
 
 
holdings_ext.sql
holdings_ext.sql
 
 
holdings_notes.sql
holdings_notes.sql
 
 
holdings_statements.sql
holdings_statements.sql
 
 
holdings_statements_indexes.sql
holdings_statements_indexes.sql
 
 
holdings_statements_supplements.sql
holdings_statements_supplements.sql
 
 
holdings_statistical_codes.sql
holdings_statistical_codes.sql
 
 
instance_administrative_notes.sql
instance_administrative_notes.sql
 
 
instance_alternative_titles.sql
instance_alternative_titles.sql
 
 
instance_contributors.sql
instance_contributors.sql
 
 
instance_editions.sql
instance_editions.sql
 
 
instance_electronic_access.sql
instance_electronic_access.sql
 
 
instance_ext.sql
instance_ext.sql
 
 
instance_formats.sql
instance_formats.sql
 
 
instance_identifiers.sql
instance_identifiers.sql
 
 
instance_languages.sql
instance_languages.sql
 
 
instance_nature_content.sql
instance_nature_content.sql
 
 
instance_notes.sql
instance_notes.sql
 
 
instance_publication.sql
instance_publication.sql
 
 
instance_relationships_ext.sql
instance_relationships_ext.sql
 
 
instance_series.sql
instance_series.sql
 
 
instance_statistical_codes.sql
instance_statistical_codes.sql
 
 
instance_subjects.sql
instance_subjects.sql
 
 
invoice_adjustments_ext.sql
invoice_adjustments_ext.sql
 
 
invoice_adjustments_in_addition_to.sql
invoice_adjustments_in_addition_to.sql
 
 
invoice_lines_adjustments.sql
invoice_lines_adjustments.sql
 
 
invoice_lines_fund_distributions.sql
invoice_lines_fund_distributions.sql
 
 
invoice_transactions.sql
invoice_transactions.sql
 
 
invoice_voucher_lines_fund_distributions.sql
invoice_voucher_lines_fund_distributions.sql
 
 
item_effective_callno_components.sql
item_effective_callno_components.sql
 
 
item_electronic_access.sql
item_electronic_access.sql
 
 
item_ext.sql
item_ext.sql
 
 
item_notes.sql
item_notes.sql
 
 
item_statistical_codes.sql
item_statistical_codes.sql
 
 
items_holdings_instances.sql
items_holdings_instances.sql
 
 
loans_items.sql
loans_items.sql
 
 
loans_renewal_count.sql
loans_renewal_count.sql
 
 
loans_renewal_dates.sql
loans_renewal_dates.sql
 
 
locations_libraries.sql
locations_libraries.sql
 
 
locations_service_points.sql
locations_service_points.sql
 
 
po_acq_unit_ids.sql
po_acq_unit_ids.sql
 
 
po_instance.sql
po_instance.sql
 
 
po_lines_cost.sql
po_lines_cost.sql
 
 
po_lines_details_subscription.sql
po_lines_details_subscription.sql
 
 
po_lines_er_mat_type.sql
po_lines_er_mat_type.sql
 
 
po_lines_eresource.sql
po_lines_eresource.sql
 
 
po_lines_locations.sql
po_lines_locations.sql
 
 
po_lines_phys_mat_type.sql
po_lines_phys_mat_type.sql
 
 
po_lines_physical.sql
po_lines_physical.sql
 
 
po_lines_tags.sql
po_lines_tags.sql
 
 
po_lines_vendor_reference_numbers.sql
po_lines_vendor_reference_numbers.sql
 
 
po_ongoing.sql
po_ongoing.sql
 
 
po_organization.sql
po_organization.sql
 
 
po_prod_ids.sql
po_prod_ids.sql
 
 
requests_items.sql
requests_items.sql
 
 
runlist.txt
runlist.txt
 
 
users_addresses.sql
users_addresses.sql
 
 
users_departments_unpacked.sql
users_departments_unpacked.sql
 
 
users_groups.sql
users_groups.sql
 
 

README.md

FOLIO Reporting Derived Tables

These queries create "derived tables" which are helper tables to simplify writing ad hoc queries.

The tables should be created in a schema folio_reporting.

The search_path should be set when loading the tables as:

psql -c 'set search_path = folio_reporting, public' -f <sqlfile>

Note that the provided file runlist.txt lists all of the query files in the order they should be run. The order is significant because some of the queries depend on the result of other queries.

The queries should be rerun every night after the LDP full update completes, so that the derived tables will be recreated with the latest data.