GPFR_DSNFL_SRCH

(SQL View)
 Index Back

Search record for Extr Defn

Application Framework - This record is used as a search view for Extraction definition component

SELECT A.GPFR_AF_EXTRACT_ID , A.PERIOD_BEGIN_DT , A.GPFR_AF_NODE_SET , A.DESCR , A.COUNTRY , A.GPFR_AF_APPL FROM PS_GPFR_AF_RUN_DFN A WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPFR_AF_RUN_PRM P , PS_GPFR_AF_PRMTMPT PRM WHERE P.GPFR_AF_EXTRACT_ID = A.GPFR_AF_EXTRACT_ID AND PRM.COUNTRY = 'FRA' AND PRM.GPFR_AF_APPL = 'DSN' AND PRM.GPFR_AF_PARM_SEQ = P.GPFR_AF_PARM_SEQ AND PRM.GPFR_AF_FUNCT_NM = 'RUN_CTL' AND PRM.GPFR_AF_PARM_NM = 'EVT_SELECT_EE' AND P.GPFR_AF_CHAR_VAL IN ('Y')) AND A.PERIOD_BEGIN_DT IS NOT NULL AND A.PERIOD_END_DT IS NOT NULL

  • Related Language Record: GPFR_AF_DFN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_AF_EXTRACT_ID Character(18) VARCHAR2(18) NOT NULL Application Framework - Extraction ID

    Prompt Table: GPFR_AF_RUN_DFN

    2 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date
    3 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set

    Prompt Table: GPFR_AF_NTSR_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    6 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application