Where to find the Project Codes Table?
In the Open Standard
Rodney JonesMember for 14 years 4 months
- Created
- 1
- 1
0
1 reply
Oldest first- 0Zoltan Palffy ·
project codes or activity
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
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?