PC_CAT_SUB_CAT

(SQL View)
Index Back

Project Cat-SubCat Res Catg


select a.setid , a.resource_category , b.effdt , b.eff_status , b.descr from ps_proj_cat_sub a , PS_PROJ_CATG_TBL b where a.setid = b.setid and a.resource_category = b.resource_category

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: PROJ_CATG_TBL

3 EFFDT Date(10) DATE Effective Date
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description