Skip to content

Progress

The third tab of Master Doc. Register: how far each document has come.

Progress: last revision, last issued code, last return code, the percentage, the weight factor and the earned value, then plan, actual and return dates per issued status
Progress: last revision, last issued code, last return code, the percentage, the weight factor and the earned value, then plan, actual and return dates per issued status · click to enlarge

One row per MDR document, read from ts_mdr_progress.progress_content, a JSON document with two parts:

PartKeysWritten by
onelast_revision, last_revision_date, last_issued_code, last_return_code, percentage_progress, weight_factor, earned_valueupdateMDRProgress('two', ...) when the revision is published to the library (the D - Transmit sign-off, or the MDR upload itself when the routing has no D) and ('three', ...) when the routing closes (the approver's sign-off, or the return transmittal), in tracking_function.inc.php
twoper issued code: plan_date, actual_date, return_date, return_code, revthe same, plus Edit Progress for the plan dates

The columns are ID, Document Number, Previous Document Number, Document Title, Last Revision, Last Revision Date, Last Issued Code, Last Return Code, Percentage, Weight Factor, Earned Value, then Plan Date, Actual Date, Return Date, Rev and Return Code for each issued status of the project.

  • Percentage follows the two columns of the Progress Gate setting, shown there as Submission % (submission_progress) and Completion % (percentage). Step two writes Submission % of the gate the revision was published at: the document has been handed to Document Control for review. Step three replaces it with Completion % when the routing closed with an approving result code (doc_res_action = approved); a rejection leaves Submission % in place. Earned Value is percentage_progress × weight_factor / 100, recomputed at each step. The two columns are explained in full in MDR Report, Submission % and Completion %. The bar under the grid (cmd=totalprogress) sums earned value and weight factor over the project and shows the ratio.
  • Recalculate re-runs recalculateProgressContent() on every row and writes the result back. Run it after changing gate percentages or return codes; nothing else refreshes old rows.
  • Edit Progress (cmd=edit_progress) edits the plan dates per issued status.
  • Weight factors come from the MDR import; a project without them has an all-zero progress tab and an empty MDR Report summary.