Versions Compared

Version Old Version 2 New Version Current
Changes made by

Axel Dörrer

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_agreement_org
  - sao_org_fk → agreements:org
  - sao_role → rdv_value
Knowledgebase!!!!!
package:
pkg_vendor_id → agreements:org???.erm_agreements_subscription_agreementAxelneed to convert for MetaDB
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_id
??.erm_
https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement_entitlement.sqlAxel
need 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		Axel
done
(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
(integrate)
erm_agreements_subscription_agreement_entitlementAxel(tick)

folio_orders
folio_finance

purchase_order
po_
transactionsdone
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_

transactionsdone

lines
transactions

...https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sqlAxel(tick)
folio_agreementscustoms_properties
??? Needed?Ask ERM Team

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)