Forum Sponsor:
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?
Fri, 2019-08-09 01:25
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
Fri, 2019-08-09 12:19
#1
project codes or activity codes ?
here is the project code schema
PROJPCATColumns | ||||
---|---|---|---|---|
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 |
Replies