If a Project has been approved 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.
Add Comment