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]
Rodney Jones
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 18 Jun 2012
Posts: 19
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

Replies

Zoltan Palffy
User offline. Last seen 4 days 15 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2764
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