TL_PROJ_SUB_V2

(SQL View)
Index Back

TL Proj Sub Cat Prompt View


SELECT A.SETID , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , B.EFFDT , B.EFF_STATUS , B.DESCR , A.DESCR FROM PS_PROJ_CAT_SUB A , PS_PROJ_SUBCAT_TBL B WHERE A.SETID = B.SETID AND A.RESOURCE_SUB_CAT = B.RESOURCE_SUB_CAT

  • Related Language Record: TL_PROJ_SUBV2_L
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: PROJ_CATG_TBL

    3 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category

    Prompt Table: PROJ_SUBCAT_TBL

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