Understanding the edit_decisions table values

pilas · January 11, 2024, 5:39pm

Hi everyone!

We are trying to understand the values found in OJS table edit_decisions.

It only contains numbers that seems to correspond to specific decision taken on a submission.

For example: 2 and 3 seems to correspond to Revisions (minor) and Revision (major) ; 4 to Reject but they are lots of values (17, 16, etc.) for which we do not have a clue…

Is there any documentation on this edit_decisions table values?

Thank you very much for your help!

Best,
Pierre

asmecher · January 11, 2024, 5:53pm

Hi @pilas,

The decision constants (in 3.4.0) are coded here:

github.com

pkp/pkp-lib/blob/stable-3_4_0/classes/decision/Decision.php

<?php

/**
 * @defgroup decision Decision
 */

/**
 * @file classes/decision/Decision.php
 *
 * Copyright (c) 2014-2022 Simon Fraser University
 * Copyright (c) 2000-2022 John Willinsky
 * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
 *
 * @class Decision
 *
 * @ingroup decision
 *
 * @see DAO
 *
 * @brief An editorial decision taken on a submission, such as to accept, decline or request revisions.

This file has been truncated. show original

(I’ve added a comment to the database schema that will result in more context being given in our public SchemaSpy documentation, once that is rebuilt.)

Regards,
Alec Smecher
Public Knowledge Project Team