ERM - OpenAccess derived table for works 'openaccess_works'

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