| | | | | |
|---|
folio_agreements | subscription_agreement | sa_id
sa_name
sa_description | 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
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.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
folio_finance | 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
invoice_lines
transactions | ... | https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sql | Axel |
|
folio_agreements | customs_properties | | https://github.com/folio-org/folio-analytics/blob/main/sql_metadb/derived_tables/agreements_custom_property.sql | Stefan (Additions to the existing derived table) |
|