GPFR_AF_EXTV_VW

(SQL View)
 Index Back

Extraction Version view

Application Framework - This view is used in extraction

SELECT A.COUNTRY ,A.GPFR_AF_APPL ,A.GPFR_AF_NODE_SET ,A.GPFR_AF_EXTRACT_ID ,A.COMPANY ,A.EMPLID ,A.EMPL_RCD ,A.GPFR_AF_SIT_BGN_DT ,A.GPFR_AF_SIT_END_DT ,A.GPFR_AF_KEY_NODE ,A.GPFR_AF_KEY_ATTR ,AA.GPFR_AF_APPL_VER ,AA.GPFR_AF_ATTR_NAME ,AA.DESCR60 FROM PS_GPFR_AF_EXTRACT A , PS_GPFR_AF_ATTR AA , PS_GPFR_AF_NODE BB WHERE A.COUNTRY = AA.COUNTRY AND A.GPFR_AF_APPL = AA.GPFR_AF_APPL AND A.GPFR_AF_KEY_NODE = AA.GPFR_AF_KEY_NODE AND A.GPFR_AF_KEY_ATTR = AA.GPFR_AF_KEY_ATTR AND A.GPFR_AF_ATTR_NAME = AA.GPFR_AF_ATTR_NAME AND A.GPFR_AF_KEY_NODE = BB.GPFR_AF_KEY_NODE AND A.GPFR_AF_NODE_NAME = BB.GPFR_AF_NODE_NAME AND AA.GPFR_AF_APPL_VER = ( SELECT MAX(CC.GPFR_AF_APPL_VER) FROM PS_GPFR_AF_ATTR CC WHERE CC.COUNTRY=AA.COUNTRY AND CC.GPFR_AF_APPL=AA.GPFR_AF_APPL AND CC.GPFR_AF_KEY_NODE=AA.GPFR_AF_KEY_NODE AND CC.GPFR_AF_KEY_ATTR=AA.GPFR_AF_KEY_ATTR AND CC.GPFR_AF_APPL_VER <=( SELECT %Sql(GPFR_AF_STRTONBR, PR.GPFR_AF_CHAR_VAL) FROM PS_GPFR_AF_RUN_PRM PR WHERE PR.GPFR_AF_FUNCT_NM='RUN_CTL' AND PR.GPFR_AF_PARM_NM='VERSION' AND A.GPFR_AF_EXTRACT_ID=PR.GPFR_AF_EXTRACT_ID))

  • Parent record: GPFR_AF_EXTRACT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application
    3 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set
    4 GPFR_AF_EXTRACT_ID Character(18) VARCHAR2(18) NOT NULL Application Framework - Extraction ID
    5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    8 GPFR_AF_SIT_BGN_DT Date(10) DATE Application Framework - Situation Begin Date
    9 GPFR_AF_SIT_END_DT Date(10) DATE Application Framework - Situation End Date
    10 GPFR_AF_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node

    Default Value: 99999999

    11 GPFR_AF_KEY_ATTR Number(8,0) INTEGER NOT NULL Application Framework - Key Attribute

    Default Value: 99999999

    12 GPFR_AF_APPL_VER Number(8,0) INTEGER NOT NULL Application Framework - Application
    13 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
    14 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description