...
| Database schema | Table | Attributes | Derived table | Editor | Status |
|---|---|---|---|---|---|
| folio_agreements | subscription_agreement | sa_id 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 | https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement.sql | Axel |  |
| folio_agreements | subscription_agreement_org org | sao_role | https://github.com/folio-org/folio-analytics/blob/ermmain/sql_2g/derived_tables/erm_agreements_subscription_agreement_org_ext.sql | Axel | need to convert for MetaDB |
| folio_agreements | entitlement | ent_id | https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement_entitlement.sql | Axel | need to convert for MetaDB |
| folio_agreements | remote_license_link | rll_owner (sa_id) rol_remote_id (lic_id) | https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sql | Stefan | |
| folio_organizations | organizations | name (for invoice & purchase order) | purchase_order_transactions invoice_transactions | Axel | done |
| folio_licenses | license | lic_id lic_name | https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sql | Stefan | |
| folio_agreements | order_line | pol_owner_fk → ent_id pol_id → po_line_id (purchase_order_transactions) | Add with left join to erm_agreements_subscription_agreement_entitlement | Axel | |
folio_orders | purchase_order po_lines transactions | ... | https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/purchase_order_transactions.sql | Axel | done |
| folio_invoices folio_finance | invoices | ... | https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sql | Axel | done |
| folio_agreements | customs_properties ??? Needed? | https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_custom_property.sql | Ask ERM Team | need to convert for MetaDB |