GPFR_DA_SREC_VW

(SQL View)
 Index Back

Structure for Summarization

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

SELECT GPFR_DA_STRUCT , GPFR_DA_RECORD , GPFR_DA_DESCR FROM PS_GPFR_DA_RECORD WHERE (GPFR_DA_STRUCT LIKE 'S41%' OR GPFR_DA_STRUCT LIKE 'S45%' OR GPFR_DA_STRUCT LIKE 'S70%') AND GPFR_DA_STATUS = 'A' AND GPFR_DA_TYPE IN ('M','N')

  • Related Language Record: GPFR_DA_SRVW_LN

    • # 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 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field