ERM - OpenAccess derived table for works 'openaccess_works'
Content
Overview
The purpose of this derived table is to show informations about the records in the table "folio_oa.works" and their linked tables and reference data.
Github Issue
https://github.com/folio-org/folio-analytics/issues/787 (ERM - Create derived table 'openaccess_works' for Metadb)
Attributes for the derived table
Folio Table | Folio Attribute | Description | Datatype | Sample Output | FK (From table) | PK (To table) | Notes |
|---|---|---|---|---|---|---|---|
folio_oa.work | w_id | ID of the record in the table work | UUID | c9e32868-217d-4adc-9fb1-abc3596586d9 | Table: folio_oa.work Attribute: w_id | Table: folio_oa.publication_request Attribute: pr_work_fk --------- Table: folio_oa.title_instance Attribute: ti_work_fk | Link to table folio_oa.publication_request |
folio_oa.work | w_version | Version of the record in the table work | INTEGER | 1 | |||
folio_oa.work | w_title | Title of the publication | TEXT | Frontiers in Analytical Science | |||
folio_oa.work | w_indexed_in_doaj_fk | ID of reference data value for the status in the directory DOAJ | UUID | 8aaa80fe-859f-e8ee-0185-a0ea5d8e0021 | Table: folio_oa.work Attribute: w_indexed_in_doaj_fk | Table: folio_oa.refdata_value Attribute: rdv_id | |
folio_oa.refdata_value | w_indexed_in_doaj_value | Reference data value for the status in the directory DOAJ | TEXT | yes | |||
folio_oa.refdata_value | w_indexed_in_doaj_label | Label of the reference data value for the status in the directory DOAJ | TEXT | Yes | |||
folio_oa.work | w_oa_status_fk | ID of reference data value for the kind of Open Access | UUID | 8aaa80fe-859f-e8ee-0185-a0ea5d9b0024 | Table: folio_oa.work Attribute: w_oa_status_fk | Table: folio_oa.refdata_value Attribute: rdv_id | |
folio_oa.refdata_value | w_oa_status_value | Reference data value for the kind of Open Access | TEXT | gold | |||
folio_oa.refdata_value | w_oa_status_label | Label of the reference data value for the kind of Open Access | TEXT | Gold | |||
folio_oa.title_instance | ti_id | ID of the record in the table title_instance | UUID | 4334961d-0bdc-4db5-8c66-3c08c4f04af5 | Table: folio_oa.title_instance Attribute: ti_id | Table: folio_oa.identifier_occurrence Attribute: io_ti_fk | |
folio_oa.title_instance | ti_version | Version of the record in the table title_instance | INTEGER | 1 | |||
folio_oa.title_instance | ti_work_fk | ID to the related record in the table work | UUID | 0d7918e5-c76a-46e0-a707-83555f6788b3 | Table: folio_oa.title_instance Attribute: ti_work_fk | Table: folio_oa.work Attribute: w_id | |
folio_oa.title_instance | ti_type_fk | ID of reference data value for type of the title instance | UUID | 8aaa80fe859fe8ee0185a0ea5de70035 | Table: folio_oa.title_instance Attribute: ti_type_fk | Table: folio_oa.refdata_value Attribute: rdv_id | |
folio_oa.refdata_value | ti_type_value | Reference data value for the type of the title instance | TEXT | serial | |||
folio_oa.refdata_value | ti_type_label | Label of the reference data value for the type of the title instance | TEXT | Serial | |||
folio_oa.title_instance | ti_subtype_fk | ID of reference data value for subtype of the title instance | UUID | 8aaa80fe859fe8ee0185a0ea5ddb0032 | Table: folio_oa.title_instance Attribute: ti_subtype_fk | Table: folio_oa.refdata_value Attribute: rdv_id | |
folio_oa.refdata_value | ti_subtype_value | Reference data value for the subtype of the title instance | TEXT | electronic | |||
folio_oa.refdata_value | ti_subtype_label | Label of the reference data value for the subtype of the title instance | TEXT | Electronic | |||
folio_oa.title_instance | ti_publication_type_fk | ID of reference data value for publication type of the title instance | UUID | 8aaa80fe859fe8ee0185a0ea5df20038 | Table: folio_oa.title_instance Attribute: ti_publication_type_fk | Table: folio_oa.refdata_value Attribute: rdv_id | |
folio_oa.refdata_value | ti_publication_type_value | Reference data value for the publication type of the title instance | TEXT | journal | |||
folio_oa.refdata_value | ti_publication_type_label | Label of the reference data value for the publication type of the title instance | TEXT | Journal | |||
folio_oa.title_instance | ti_title | Title of the title instance | TEXT | Frontiers in Big Data | |||
folio_oa.identifier_occurrence | io_id | ID of the identifier occurrence that is related to the title instance | UUID | 746cefa3-427e-4387-a481-4ff66999b924 | |||
folio_oa.identifier_occurrence | io_version | Version of the record for identifier occurrence | INTEGER | 1 | |||
folio_oa.identifier_occurrence | io_ti_fk | ID of the record in the table title_instance | UUID | bc0551f1-ffc8-409c-b75e-695e84019f2f | Table: folio_oa.identifier_occurrence Attribute: io_ti_fk | Table: folio_oa.title_instance Attribute: ti_id | |
folio_oa.identifier_occurrence | io_status_fk | Status of the record for identifier occurrence | UUID | 8aaa809385efeeed0185f2acf9d10000 | Table: folio_oa.identifier_occurrence Attribute: io_status_fk | Table: folio_oa.refdata_value Attribute: rdv_id | |
folio_oa.refdata_value | io_status_value | Reference data value for the status of the record for identifier occurrence | TEXT | ||||
folio_oa.refdata_value | io_status_label | Label of the reference data value for the status of the record for identifier occurrence | TEXT | ||||
folio_oa.identifier_occurrence | io_identifier_fk | ID to the record for the identifier that is related to the title instance | UUID | ed99abdb-65fd-4305-a5d4-1455705f074d | Table: folio_oa.identifier_occurrence Attribute: io_identifier_fk | Table: folio_oa.identifier Attribute: id_id | |
folio_oa.identifier_occurrence | io_selected | BOOLEAN | |||||
folio_oa.identifier | id_id | ID for the record for the identifier | UUID | ed99abdb-65fd-4305-a5d4-1455705f074d | Table: folio_oa.identifier Attribute: id_id | Table: folio_oa.identifier_occurrence Attribute: io_identifier_fk | |
folio_oa.identifier | id_version | Version of the record for the identifier | INTEGER | 1 | |||
folio_oa.identifier | id_ns_fk | ID to the record for the type of identifier | UUID | 8a6cf7ff-c01c-4674-9e4a-47f0b3343b37 | Table: folio_oa.identifier Attribute: id_ns_fk | Table: folio_oa.identifier_namespace Attribute: idns_id | |
folio_oa.identifier | id_value | Value of the identifier | TEXT | 2813-2831 | |||