PTSF_CAT_ATRSVL

(SQL View)
 Index Back

rel lang cat attrs descr view


SELECT A.PTSF_SRCCAT_NAME ,A.PTSF_SRCATTR_NAME , B.LANGUAGE_CD , B.DESCR254 FROM PS_PTSF_CATATTRSVW A , PS_PTSF_ALLATR_VL B WHERE A.PTSF_SD_SOURCE = B.PTSF_SD_SOURCE AND A.PTSF_SOURCE_NAME = B.PTSF_SOURCE_NAME AND A.PTSF_SRCATTR_NAME = B.PTSF_SRCATTR_NAME

  • Related Language Record for PTSF_CATADVF_V PTSF_CATDISPF_V PTSF_CATSORTF_V PTSF_CAT_ATRSV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).
    2 PTSF_SRCATTR_NAME Character(65) VARCHAR2(65) NOT NULL Search Attribute (see PSPTSF_ATTRS).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254