GPFR_DA_STVW_LN

(SQL View)
 Index Back

Structure for Summarization

Structure related to S41,S45 and S70 only will be considered

SELECT DISTINCT B.GPFR_DA_STRUCT , C.LANGUAGE_CD , C.GPFR_DA_DESCR FROM PS_GPFR_DA_RECORD A , PS_GPFR_DA_STRUCT B , PS_GPFR_DA_ST_LNG C WHERE %Join(COMMON_KEYS, GPFR_DA_STRUCT B , GPFR_DA_ST_LNG C) AND (A.GPFR_DA_STRUCT LIKE 'S41%' OR A.GPFR_DA_STRUCT LIKE 'S45%' OR A.GPFR_DA_STRUCT LIKE 'S70%') AND A.GPFR_DA_STATUS = 'A' AND A.GPFR_DA_TYPE IN ('M','N') AND A.GPFR_DA_STRUCT = B.GPFR_DA_STRUCT

  • Related Language Record for GPFR_DA_STRU_VW

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