Where to find the Project Codes Table?

I would like to transfer all the Project Codes from one P6 (R16)PMDB to another P6 (R16)PMDB. How do I find the table/schema?

 

Thanks,

 

Rod

Z
Zoltan Palffy 👤 Member for 16 years 10 months

project codes or activity codes ?

here is the project code schema

PROJPCAT
Columns
Key Name Type Description Default
PK,FK proj_id integer FK to PROJECT table - identifies the project  
PK,FK proj_catg_type_id integer FK to PCATTYPE table - identifies the project code type  
FK proj_catg_id integer FK to PCATVAL table - identifies the project code value  
  update_date date Refresh audit field of last date updated. Trigger maintained.  
  update_user string(255) Refresh audit field of last user updated. Trigger maintained.  
  create_date date Refresh audit field for date record created. Trigger maintained.  
  create_user string(255) Refresh audit field for user that created the record. Trigger maintained.  
  delete_session_id integer Deleted by session id. Client maintained.  
  delete_date date Deleted date. Client maintained.  

Indexes
Name Unique Fields
ndx_projpcat_pcattype NONUNIQUE proj_catg_type_id
ndx_projpcat_pcatval NONUNIQUE proj_catg_id
ndx_projpcat_update_date1 NONUNIQUE update_date
ndx_projpcat_dsi NONUNIQUE delete_session_id,delete_date
ndx_projpcat_upd NONUNIQUE update_date,delete_session_id

Triggers
PRMAUD_PROJPCAT OR SQL Server  
RT_PROJPCAT_DEL OR SQL Server  
RT_PROJPCAT OR SQL Server  

Constraints
Name Type Fields Target Fields Delete rule Refer Type Condition
pk_projpcat PRIMARY proj_id,proj_catg_type_id        
fk_projpcat_pcattype FOREIGN proj_catg_type_id PCATTYPE proj_catg_type_id   DEPENDENT  
fk_projpcat_pcatval FOREIGN proj_catg_id PCATVAL proj_catg_id   DEPENDENT  
fk_projpcat_project FOREIGN proj_id PROJECT proj_id   DEPENDENT

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts