I didn't want to make the thread subject "status" or "submission_progress" as those things seem to mean something specific, the definitions for which lead me to understand that they are not what I'm after.
What I am looking for is how the designations of Unassigned, In Review, Accepted, or Archived are captured within the database. From what I understand "status" has a potential of a binary value which indicate that it is either archived or not. In pursuit of determining which database fields might hold values that would represent unassigned, in-review, or accepted, I've been looking at these other fields within the "papers" table: "submission_progress" and "current_stage". From a related search I've found that "current_stage" is representative of whether it is the "abstract" or "presentation" which is in review (source
). The same source also indicates that "submission_progress" is where values are stored related to what step of the submission process a paper is in, however my testing has yielded the result of papers both unassigned and in-review as a submission_progress value of "0".
My question is to verify my current understanding of these various fields and also specifically to ask how one might determine through a database query whether a paper is "unassigned" or "in review".
If someone has the info on hand, a quick summary of the submission_progress field (value & meaning pairs) could be very valuable and certainly appreciated.
In general, any information or resources with the above would be a great help. I've been running reports on a few of our ocs instances lately and these seem to be reoccurring questions.
- Patrick E.