Changing Status back to Pending on MOD projects.

If a Project has been approved or cancelled and needs to be set back to pending the user needs to use System tables.

You will need to use System Tables to change the status.

First search the MOD_PROJ table for the matching project number.

Open the Project detail and Make a note of the MOD_ID_NUM (and Mod_rvs_dt revision date)

Then Search in system tables Mod Project Revision (MOD_APRV_RVS) for that matching MOD_ID_NUM (and date)

Open the List and Detail

You can then change the Status back to pending.

NOTE you will need to verify that the RCD_ST is set to Pending as well on this window.

THEN: Go back to System Tables and Search MOD_APRV_CERT Table for the same Mod_id_num

Open the Detail and save the RCD_STE code to pending here as well,

If more than 1 row exists you need to find the same Cert_seqnum from MOD_APRV_RVS

Change RCD_STE to pending and save.

If the Project was issued change CERT_ISU_FLG to No \ Non

(NOTE: You may need to modify the CERT_ISU_FLG if the project type was changed previously)