Where to find the Project Codes Table?

Member for

16 years 3 months

project codes or activity codes ?

here is the project code schema

PROJPCAT

ColumnsKeyNameTypeDescriptionDefaultPK,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. 

IndexesNameUniqueFieldsndx_projpcat_pcattypeNONUNIQUEproj_catg_type_idndx_projpcat_pcatvalNONUNIQUEproj_catg_idndx_projpcat_update_date1NONUNIQUEupdate_datendx_projpcat_dsiNONUNIQUEdelete_session_id,delete_datendx_projpcat_updNONUNIQUEupdate_date,delete_session_id

TriggersPRMAUD_PROJPCATORSQL Server RT_PROJPCAT_DELORSQL Server RT_PROJPCATORSQL Server 

ConstraintsNameTypeFieldsTargetFieldsDelete ruleRefer TypeConditionpk_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