ERM - OpenAccess derived table for publication requests 'openaccess_publication_request'
Content
Overview
The purpose of this derived table is to show statistics associated with Open Access publication requests.
Github Issue
https://github.com/folio-org/folio-analytics/issues/784 (ERM - Create derived table 'openaccess_publication_request' for Metadb)
Attributes for the derived table
Folio Table | Folio Attribute | Description | Datatype | Sample output | FK (From table) | PK (To table) | Notes |
|---|---|---|---|---|---|---|---|
folio_oa.publication_request | pr_id | UUID for the publication request | UUID | 3002f645-1b70-4cf2-83ce-ee0cfdd1dd3e | Table: folio_oa.publication_request Attribute: pr_id | Table: folio_oa.charge Attribute: ch_owner_fk |
|
folio_oa.publication_request | pr_request_date | Date when the request was made (manually) | TIMESTAMP | 2021-01-04 00:00:00.000 |
|
|
|
folio_oa.publication_request | pr_date_created | Timestamp when the record was created (comes from the system) | TIMESTAMP | 2023-02-17 08:47:44.597 |
|
|
|
folio_oa.publication_request | pr_last_updated | Timestamp when the record is last updated (comes from the system) | TIMESTAMP | 2023-05-24 21:16:33.135 |
|
|
|
folio_oa.publication_request | pr_request_number | Number created from the system for a publication request | VARCHAR | OAM-001 2023-001 |
|
| It is possible to create a template how it will be created optionally with a number generator |
folio_oa.publication_request | pr_title | Title of the publication | VARCHAR | Decontamination of lupine (Lupinus angustifolius) flakes ... |
|
| Article or book title |
folio_oa.publication_request | pr_request_status | UUID reference to a refdata value | UUID | 8aaa80fe859fe8ee0185a0ea5e230045 | Table: folio_oa.publication_request Attribute: pr_request_status | Table: folio_oa.refdata_value Attribute: rdv_id |
|
folio_oa.refdata_value | pr_request_status_value | Refdata value for publication request status | VARCHAR | open |
|
|
|
folio_oa.refdata_value | pr_request_status_label | Refdata label for publication request status | VARCHAR | Open |
|
|
|
folio_oa.publication_request | pr_pub_type_fk | UUID reference to a refdata value | UUID | 8aaa80fe859fe8ee0185a0ea5e06003e | Table: folio_oa.publication_request Attribute: pr_pub_type_fk | Table: folio_oa.refdata_value Attribute: rdv_id |
|
folio_oa.refdata_value | pr_pub_type_value | Refdata value for publication request publication type | VARCHAR | journal_article |
|
|
|
folio_oa.refdata_value | pr_pub_type_label | Refdata label for publication request publication type | VARCHAR | Zeitschriftenartikel |
|
|
|
folio_oa.publication_request | pr_authnames | List of names of the authors of the publication | VARCHAR |
|
|
| Just a string, not separated by the system |
folio_oa.publication_request | pr_corresponding_author_fk
| FK for a record in folio_oa.request_party | UUID | 4dc4e261-6150-47a7-a6a1-51f2ae3ef295 | Table: folio_oa.publication_request Attribute: pr_corresponding_author_fk | Table: folio_oa. folio_oa.request_party Attribute: rp_id | folio_oa.request_party can be used to get the relation between the role to the "party record" Limited by 2 roles |
folio_oa.refdata_value | pr_corresponding_author_role_value | Refdata value for the role of the corresponding author | VARCHAR | corresponding_author |
|
|
|
folio_oa.refdata_value | pr_corresponding_author_role_label | Refdata label for role of the corresponding author | VARCHAR | Korrespondenzautor |
|
|
|
folio_oa.party | pr_corresponding_author_name | Name of the linked corresponding author | VARCHAR | Erika Musterfrau |
|
|
|
folio_oa.request_party | pr_corresponding_author_rp_party_fk | FK to the table party | UUID | a6034022-5cad-40e3-935e-ca73e65b3bf6 | Table: folio_oa.request_party Attribute: rp_party_fk | Table: folio_oa. party Attribute: p_id |
|
folio_oa.publication_request | pr_local_ref | ID to use for a local repository or storage | VARCHAR |
|
|
| There is a separate column for DOI |
folio_oa.publication_request | pr_pub_url | URL for the publication | VARCHAR |
|
|
|
|
folio_oa.publication_request | pr_subtype | UUID reference to a refdata value | UUID |
| Table: folio_oa.publication_request Attribute: pr_subtype | Table: folio_oa.refdata_value Attribute: rdv_id | Type of publication, e.g. Review, Research Article ... |
folio_oa.refdata_value | pr_subtype_value | Refdata value for publication request subtype | VARCHAR |
|
|
|
|
folio_oa.refdata_value | pr_subtype_label | Refdata label for publication request subtype | VARCHAR |
|
|
|
|
folio_oa.publication_request | pr_publisher | UUID reference to a refdata value | UUID | 8aaa844885f4499b01862b15321b0017 | Table: folio_oa.publication_request Attribute: pr_publisher | Table: folio_oa.refdata_value Attribute: rdv_id |
|
folio_oa.refdata_value | pr_publisher_value | Refdata value for publication request publisher | VARCHAR | wiley |
|
|
|
folio_oa.refdata_value | pr_publisher_label | Refdata label for publication request publisher | VARCHAR | Wiley |
|
|
|
folio_oa.publication_request | pr_license | UUID reference to a refdata value | UUID | 8aaa809385efeeed0185f3644cb5000d | Table: folio_oa.publication_request Attribute: pr_license | Table: folio_oa.refdata_value Attribute: rdv_id | License used for the publication |
folio_oa.refdata_value | pr_license_value | Refdata value for publication request license | VARCHAR | cc_by |
|
|
|
folio_oa.refdata_value | pr_license_label | Refdata label for publication request license | VARCHAR | CC BY |
|
|
|
folio_oa.publication_request | pr_doi | DOI for the publication | VARCHAR | 10.3389/fmicb.2022.822369 |
|
|
|
folio_oa.publication_request | pr_group_fk | ? | ? |
|
|
|
|
folio_oa.publication_request | pr_agreement_reference | FK for publication request agreement | UUID |
| Table: folio_oa.publication_request Attribute: pr_agreement_reference | Table: folio_oa.publication_request_agreement Attribute: rol_id | Remote ID to Agreements Table: folio_oa.publication_request_agreement Attribute: rol_remote_id |
folio_oa.publication_request | pr_without_agreement | Is there a agreement to the publication request | BOOLEAN |
|
|
| A link to a agreement is not required |
folio_oa.publication_request | pr_work_fk | FK for a record in folio_oa.work | UUID | b39a2800-1249-489e-8c8c-e1939c48dd73 | Table: folio_oa.publication_request Attribute: pr_work_fk | Table: folio_oa.work Attribute: w_id |
|
folio_oa.publication_request | pr_book_date_of_publication | Year of publication | VARCHAR |
|
|
| For books only |
folio_oa.publication_request | pr_book_place_of_publication | Place of publication | VARCHAR |
|
|
| For books only |
folio_oa.publication_request | pr_work_indexed_in_doaj_fk | UUID reference to a refdata value | UUID | 8aaa80fe859fe8ee0185a0ea5d8e0021 | Table: folio_oa.publication_request Attribute: pr_work_indexed_in_doaj_fk | Table: folio_oa.refdata_value Attribute: rdv_id |
|
folio_oa.refdata_value | pr_work_indexed_in_doaj_value | Refdata value for publication request doaj status | VARCHAR | yes |
|