Transfer a project/approval from one region to another
When the project has an approval number:
Use the menu under tools to select Regional Mod or Type Certificate Transfer
But make sure you are logged into the region where the approval is currently located, not the region you want to transfer to (Or any other region)
If the Project doesn’t have an approval number:
If the project is a standalone TC (Type Certificate/CAN-TSO) project with out an approval number.
An admin can change the OPI Region in System tables Napa TC Projects (TA_PROJ) table.
If the project is a MOD and not approved (has no approval number) you will need to contact DSD Support.
(NOTE: Since the topic is about projects without approval none of these transfer procedures can be used)
Transfer of a MOD Project (project numbers start with a letter (O-21-0076) with an approval/certificate number regularly uses either procedure
NAPA_NACIS.SP_UPDATE_MOD_REGION (Used for projects with Canadian certificate numbers)
or NAPA_NACIS.SP_UPDATE_FOREIGN_MOD_REGION (Used for Projects with a foreign certificate number)
(NOTE: BUT since the topic is about projects without approval neither MOD procedure can be used)
And the developer needs to update the region on these tables based on Mod_ID_num, Mod_rvsn_dt found in the MOD_Proj record.
UPDATE mod_proj SET rgn_cd
UPDATE mod_aprv SET rgn_cd
UPDATE mfr_pub_supp SET rgn_cd
UPDATE mod_aprv_cert SET rgn_cd
UPDATE mod_aprv_cert_doc SET rgn_cd
UPDATE mod_aprv_mdl SET rgn_cd
UPDATE mod_aprv_ac SET rgn_cd
UPDATE mod_inst SET rgn_cd
UPDATE mod_aprv_rvs SET rgn_cd