...
| Database schema | Table | Attributes | Derived table | Editor | Status |
|---|---|---|---|---|---|
| folio_agreements | subscription_agreement | sa_id | 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/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 | |
| 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 | |
| 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 | |
| folio_invoices folio_finance | invoices | ... | https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sql | Axel | |
| folio_agreements | customs_properties ??? Needed? | https://github.com/folio-org/folio-analytics/blob/ermmain/sql_metadb/derived_tables/erm_agreements_custom_property.sqlAsk ERM Team | Stefan (Additions to the existing derived table) | |