"Days in Status" Export


A new report has now been  to track how submissions are progressing through statuses. These exports are available at the System-, Community-, and Initiative-levels

Two types of exports are available:

  • Submission Days in Status: This shows how long individual submissions stayed in custom and system statuses
    • Export columns:

      1. Code

      2. Title

      3. Category

      4. Status: The current status of the submission

      5. Submitted: The date the submission was submitted

      6. Days since Submitted: The number of days from submission to today (when the report is generated)

      7. Days in “[STATUS]”: For each custom status, the number of days that the submission was in that status

        1. One column should appear for each status in the Initiative

      8. Total days in Active system statuses: Total number of days the submission was in statuses with an "Active" system status; this should be aggregated across multiple statuses sharing the same “Active” system status

      9. Total days in Paused system statuses: Total number of days the submission was in statuses with a "Paused" system status; this should be aggregated across multiple statuses sharing the same “Paused” system status

      10. Time to Closed system statuses: If the submission is currently in a “Stopped” or “Complete” system status, the total number of days between submission and the when it is moved to a “Stopped” or “Complete” system status

      11. User Name: Submitter user name

      12. User Email

      13. Member ID

DaysinStatusexport.png

 

  • Status Summary: This shows at the initiative-level the average time that submissions stayed in custom and system status
    • Export columns:

      1. Submissions in "[STATUS]”: For each custom status, the number of submissions currently in that status

      2. Average days in “[STATUS]: For each custom status, the average number of days submissions were in that status

        • NOTE: Submissions in “[STATUS]” and Average days in “[STATUS]” columns should always be paired together for each status (e.g. Submissions in “Open”, Average days in “Open”, Submissions in “Paused”, Average days in “Paused”, etc.)

      3. Submissions in Active system status: Number of submissions moved to a “Active” system status

      4. Average days in Active system status: Average number of days that submissions remain "Active" system statuses

      5. Submissions in Complete system status: Number of submissions moved to a “Complete” system statuses

      6. Average days to Complete system status: Average number of days between submission date to being moved to “Complete" system statuses

      7. Submissions in Stopped system status: Number of submissions moved to a "Stopped" system status

      8. Average days to Stopped system status: Average number of days between submission to being moved to "Stopped" system statuses

      9. Average days to Closed system status: For submissions currently in a “Stopped” or “Complete” system status, the average number of days before submissions are moved to either a “Stopped” or “Complete” system status

StatusSummaryExport.png

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments