GPFR_DA_SLNG_VW

(SQL View)
 Index Back

Act&Visible Struct / Component

DADS related view: give access to the active and visible structures for a given component

SELECT B.PNLGRPNAME , A.GPFR_DA_STRUCT , C.LANGUAGE_CD , A.GPFR_DA_DESCR FROM PS_GPFR_DA_STRUCT A , PS_GPFR_DA_STCOMP B , PS_GPFR_DA_ST_LNG C WHERE A.GPFR_DA_STRUCT = B.GPFR_DA_STRUCT AND A.GPFR_DA_STRUCT = C.GPFR_DA_STRUCT AND A.GPFR_DA_STATUS = 'A' AND A.GPFR_DA_OPTION IN ('E', 'D')

  • Related Language Record for GPFR_DA_ST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field