Documentation: agreements_subscription_agreement.sql

---

Last update: 2021-11-29
Database: MetaDB
Release: Honeysuckle
Type: Derived table

---

Description:

Table on agreements_subscription_agreement and resolves values and labels from erm_agreements_refdata_value for:

• sa_renewal_priority
• sa_is_perpetual
• sa_agreement_status
• sa_reason_for_closure

---

Attributes:

Attribut	Type	Source - Schema	Source - Table	Source - Attribut	Source - Type	Source - Multiple values	Aggregation	Notes
sa_id	Varchar	folio_agreements	subscription_agreement	sa_id	Varchar	No	No
sa_renewal_priority	Varchar	folio_agreements	subscription_agreement	sa_renewal_priority	Varchar	No	No
sa_renewal_priority_value	Varchar	folio_agreements	refdata_value	rdv_value	Varchar	No	No
sa_renewal_priority_label	Varchar	folio_agreements	refdata_value	rdv_label	Varchar	No	No
sa_is_perpetual	Varchar	folio_agreements	subscription_agreement	sa_is_perpetual	Varchar	No	No
sa_is_perpetual_value	Varchar	folio_agreements	refdata_value	rdv_value	Varchar	No	No
sa_is_perpetual_label	Varchar	folio_agreements	refdata_value	rdv_label	Varchar	No	No
sa_name	Varchar	folio_agreements	subscription_agreement	sa_name	Varchar	No	No
sa_local_reference	Varchar	folio_agreements	subscription_agreement	sa_local_reference	Varchar	No	No	External sources
sa_agreement_status	Varchar	folio_agreements	subscription_agreement	sa_agreement_status	Varchar	No	No
sa_agreement_status_value	Varchar	folio_agreements	refdata_value	rdv_value	Varchar	No	No
sa_agreement_status_label	Varchar	folio_agreements	refdata_value	rdv_label	Varchar	No	No
sa_description	Varchar	folio_agreements	subscription_agreement	sa_description	Varchar	No	No
sa_license_note	Varchar	folio_agreements	subscription_agreement	sa_license_note	Varchar	No	No
sa_reason_for_closure	Varchar	folio_agreements	subscription_agreement	sa_reason_for_closure	Varchar	No	No
sa_reason_for_closure_value	Varchar	folio_agreements	refdata_value	rdv_value	Varchar	No	No
sa_reason_for_closure_label	Varchar	folio_agreements	refdata_value	rdv_label	Varchar	No	No
sa_custom_properties_id	Varchar	folio_agreements	subscription_agreement	custom_properties_id	Int	No	No

ER-diagram:

        erDiagram
            folio_agreements_subscription_agreement |o..o| folio_agreements_refdata_value : "renewal_priority"
            folio_agreements_subscription_agreement |o..o| folio_agreements_refdata_value : "is_perpetual"
            folio_agreements_subscription_agreement |o..o| folio_agreements_refdata_value : "status"
            folio_agreements_subscription_agreement |o..o| folio_agreements_refdata_value : "reason_for_closure"
                folio_agreements_subscription_agreement {
                    varchar sa_id
                    varchar sa_renewal_priority
                    varchar sa_is_perpetual
                    varchar sa_name
                    varchar sa_local_reference
                    varchar sa_agreement_status
                    varchar sa_description
                    varchar sa_license_note
                    varchar sa_reason_for_closure
                    varchar sa_custom_properties_id
                }
                folio_agreements_refdata_value {
                    varchar sa_renewal_priority_value
                    varchar sa_renewal_priority_label
                    varchar sa_is_perpetual_value
                    varchar sa_is_perpetual_label
                    varchar sa_agreement_status_value
                    varchar sa_agreement_status_label
                    varchar sa_reason_for_closure_value
                    varchar sa_reason_for_closure_label
                }

Loading