PROJ_TYPE_CATLV

(SQL View)
 Index Back

Project Type Cat Prompt View

Related language view for table PROJ_TYPE_CATVW.

SELECT A.SETID , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , L1.LANGUAGE_CD , B.EFFDT , L1.DESCR , L2.DESCR FROM PS_PROJ_TYPE_CAT A , PS_PROJ_CATG_TBL B , PS_PROJ_TYP_CAT_LG L1 , PS_PROJ_CATG_LANG L2 WHERE A.SETID = B.SETID AND A.RESOURCE_CATEGORY = B.RESOURCE_CATEGORY AND %Join(COMMON_KEYS, PROJ_TYPE_CAT A, PROJ_TYP_CAT_LG L1) AND %Join(COMMON_KEYS, PROJ_CATG_TBL B, PROJ_CATG_LANG L2) AND L1.LANGUAGE_CD = L2.LANGUAGE_CD

  • Related Language Record for PROJ_TYPE_CATVW

    • # 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_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

    Prompt Table: PROJ_RES_TYPE

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

    Prompt Table: PROJ_CATG_TBL

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE Effective Date
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 RELATE_DESCR Character(30) VARCHAR2(30) NOT NULL Relationship Description