Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Where to find the Project Codes Table?

1 reply [Last post]
Fri, 2019-08-09 02:25
Rodney Jones
User offline. Last seen 1 week 2 days ago. Offline
Joined: 18 Jun 2012
Posts: 13
Groups: None

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

Top

Replies

Fri, 2019-08-09 13:19
#1
Zoltan Palffy
User offline. Last seen 11 hours 39 min ago. Offline
Joined: 13 Jul 2009
Posts: 2377
Groups: None

project codes or activity codes ?

here is the project code schema

PROJPCAT
Columns
KeyNameTypeDescriptionDefault
PK,FKproj_idintegerFK to PROJECT table - identifies the project 
PK,FKproj_catg_type_idintegerFK to PCATTYPE table - identifies the project code type 
FKproj_catg_idintegerFK to PCATVAL table - identifies the project code value 
 update_datedateRefresh audit field of last date updated. Trigger maintained. 
 update_userstring(255)Refresh audit field of last user updated. Trigger maintained. 
 create_datedateRefresh audit field for date record created. Trigger maintained. 
 create_userstring(255)Refresh audit field for user that created the record. Trigger maintained. 
 delete_session_idintegerDeleted by session id. Client maintained. 
 delete_datedateDeleted date. Client maintained. 

Indexes
NameUniqueFields
ndx_projpcat_pcattypeNONUNIQUEproj_catg_type_id
ndx_projpcat_pcatvalNONUNIQUEproj_catg_id
ndx_projpcat_update_date1NONUNIQUEupdate_date
ndx_projpcat_dsiNONUNIQUEdelete_session_id,delete_date
ndx_projpcat_updNONUNIQUEupdate_date,delete_session_id

Triggers
PRMAUD_PROJPCATORSQL Server 
RT_PROJPCAT_DELORSQL Server 
RT_PROJPCATORSQL Server 

Constraints
NameTypeFieldsTargetFieldsDelete ruleRefer TypeCondition
pk_projpcatPRIMARYproj_id,proj_catg_type_id    
fk_projpcat_pcattypeFOREIGNproj_catg_type_idPCATTYPEproj_catg_type_id DEPENDENT 
fk_projpcat_pcatvalFOREIGNproj_catg_idPCATVALproj_catg_id DEPENDENT 
fk_projpcat_projectFOREIGNproj_idPROJECTproj_id DEPENDENT
Top