Page tree
Skip to end of metadata
Go to start of metadata


Database schemaTableAttributesDerived tableEditorStatus
folio_agreementssubscription_agreement

sa_id
sa_name
sa_description

https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement.sqlAxel(tick)
folio_agreementssubscription_agreement_org
org

sao_role
sao_role→ refdata_value
org_orgs_uuid
org_name

https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/agreements_subscription_agreement_org_ext.sqlAxel(tick)
folio_agreementsentitlementent_idhttps://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement_entitlement.sqlAxel(tick)
folio_agreementsremote_license_linkrll_owner (sa_id)
rol_remote_id (lic_id)
https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sqlStefan(tick)
folio_organizationsorganizationsname (for invoice & purchase order)purchase_order_transactions
invoice_transactions
Axel(tick)
folio_licenseslicenselic_id
lic_name
https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sqlStefan(tick)
folio_agreementsorder_linepol_owner_fk → ent_id
pol_id → po_line_id (purchase_order_transactions)
Add with left join to erm_agreements_subscription_agreement_entitlementAxel(tick)

folio_orders
folio_finance

purchase_order
po_lines
transactions
...https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/purchase_order_transactions.sqlAxel(tick)
folio_invoices
folio_finance

invoices
invoice_lines
transactions

...https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sqlAxel(tick)
folio_agreementscustoms_properties
https://github.com/folio-org/folio-analytics/blob/main/sql_metadb/derived_tables/agreements_custom_property.sql

Stefan

(Additions to the existing derived table)

(tick)
  • No labels