GPFR_DA_SRVW_LN

(SQL View)
 Index Back

Structure for Summarization

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

SELECT A.GPFR_DA_STRUCT , A.GPFR_DA_RECORD , B.LANGUAGE_CD , B.GPFR_DA_DESCR FROM PS_GPFR_DA_RECORD A , PS_GPFR_DA_REC_LNG B WHERE %Join(COMMON_KEYS, GPFR_DA_RECORD A, GPFR_DA_REC_LNG B) AND(A.GPFR_DA_STRUCT LIKE 'S41%' OR A.GPFR_DA_STRUCT LIKE 'S45%' OR A.GPFR_DA_STRUCT LIKE 'S70%') AND GPFR_DA_STATUS = 'A' AND GPFR_DA_TYPE IN ('M','N')

  • Related Language Record for GPFR_DA_SREC_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 GPFR_DA_RECORD Character(10) VARCHAR2(10) NOT NULL DADS related record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field