(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.
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
Printer-friendly version
Send to friend
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 | ||
Email: PPadmin@planningplanet.com
Replies