Versions Compared

Old Version 6

changes.mady.by.user Axel Dörrer

Saved on

compared with

New Version Current

changes.mady.by.user Stefan Dombek

Saved on

Key

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

...

Database schemaTableAttributesDerived tableEditorStatus
folio_agreementssubscription_agreement

sa_id
sa_name
sa_description

 Plus possible vendor location:
subscripton_agreement:
sa_vendor_reference → agreements:org
subscripton		https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement.sqlAxel(tick)
folio_agreementssubscription_agreement_org
  - org

sao_

org_fk → agreements:org
  - sao_role → rdv_value
Knowledgebase!!!!!
package:
pkg_vendor_id → agreements:org

role
sao_role→ refdata_value
org_orgs_uuid
org_name

https://github.com/folio-org/folio-analytics/blob/ermmain/sql_2g/derived_tables/erm_agreements_subscription_agreement_org_ext.sqlAxelneed to convert for MetaDB(tick)
folio_agreementsentitlementent_idhttps://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement_entitlement.sqlAxelneed to convert for MetaDB(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		Axeldone(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.sqlAxeldone(tick)
folio_invoices
folio_finance

invoices
invoice_lines
transactions

...https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sqlAxeldone(tick)
folio_agreementscustoms_properties ??? Needed?
https://github.com/folio-org/folio-analytics/blob/ermmain/sql_metadb/derived_tables/erm_agreements_custom_property.sqlAsk ERM Teamneed to convert for MetaDB

Stefan

(Additions to the existing derived table)

(tick)