GPFR_DA_STRU_VW

(SQL View)
 Index Back

Structure for Summarization

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

SELECT DISTINCT B.GPFR_DA_STRUCT , B.GPFR_DA_DESCR FROM PS_GPFR_DA_RECORD A , PS_GPFR_DA_STRUCT B WHERE (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: GPFR_DA_STVW_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_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field