...
| 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 | ???.erm_agreements_subscription_agreement | Axel | need to convert for MetaDBhttps://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/main/sql_2g/derived_tables/agreements_subscription_agreement_org_ext.sql | Axel | | ||
| 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 (integrate) 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 | doneAxel | | ||
| 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? | Ask ERM Team | need to convert for MetaDB | https://github.com/folio-org/folio-analytics/blob/main/sql_metadb/derived_tables/agreements_custom_property.sql | Stefan (Additions to the existing derived table) | |