GPFR_DSN_EXT_VW

(SQL View)
Index Back

Extraction 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 ,A.GPFR_AF_KEY_EXTRCT ,AA.GPFR_AF_APPL_VER ,A.GPFR_AF_NODE_NAME ,A.GPFR_AF_ATTR_NAME ,A.GPFR_AF_CHAR_VAL ,A.GPFR_AF_DATE_VAL ,A.GPFR_AF_NUM_VAL ,A.GPFR_AF_RND_NM_VAL ,A.ESTABID ,A.GPFR_AF_DON ,A.GPFR_AF_SQL_SEQ ,A.GPFR_AF_LVL_1_ORD ,A.GPFR_AF_LVL_1_VAL ,A.GPFR_AF_LVL_2_ORD ,A.GPFR_AF_LVL_2_VAL ,A.GPFR_AF_LVL_3_ORD ,A.GPFR_AF_LVL_3_VAL ,A.GPFR_AF_LVL_4_ORD ,A.GPFR_AF_LVL_4_VAL ,A.GPFR_AF_LVL_5_ORD ,A.GPFR_AF_LVL_5_VAL ,A.GPFR_AF_LVL_6_ORD ,A.GPFR_AF_LVL_6_VAL ,A.GPFR_AF_LVL_7_ORD ,A.GPFR_AF_LVL_7_VAL ,A.GPFR_AF_LVL_8_ORD ,A.GPFR_AF_LVL_8_VAL ,A.GPFR_AF_LVL_9_ORD ,A.GPFR_AF_LVL_9_VAL ,A.GPFR_AF_LVL_10_ORD ,A.GPFR_AF_LVL_10_VAL ,A.GPFR_AF_CHECK_DONE ,BB.GPFR_AF_ORDER ,BB.GPFR_AF_LEVEL ,AA.GPFR_AF_ATTR_SEQ FROM PS_GPFR_AF_EXTRACT A , PS_GPFR_AF_ATTR AA , PS_GPFR_AF_NODE BB WHERE A.COUNTRY ='FRA' AND A.GPFR_AF_APPL='DSN' AND 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_KEY_EXTRCT Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Extract
    13 GPFR_AF_APPL_VER Number(8,0) INTEGER NOT NULL Application Framework - Application
    14 GPFR_AF_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Application Framework - Node Name
    15 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
    16 GPFR_AF_CHAR_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Character
    17 GPFR_AF_DATE_VAL Date(10) DATE Application Framework - Date
    18 GPFR_AF_NUM_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Application Framework - Number
    19 GPFR_AF_RND_NM_VAL Number(12,0) DECIMAL(12) NOT NULL Application Framework - Round Number Value
    20 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    21 GPFR_AF_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Data Object Name
    22 GPFR_AF_SQL_SEQ Number(8,0) INTEGER NOT NULL Application Framework - SQL Sequence
    23 GPFR_AF_LVL_1_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 1
    24 GPFR_AF_LVL_1_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 1
    25 GPFR_AF_LVL_2_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 2
    26 GPFR_AF_LVL_2_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 2
    27 GPFR_AF_LVL_3_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 3
    28 GPFR_AF_LVL_3_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 3
    29 GPFR_AF_LVL_4_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 4
    30 GPFR_AF_LVL_4_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 4
    31 GPFR_AF_LVL_5_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 5
    32 GPFR_AF_LVL_5_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 5
    33 GPFR_AF_LVL_6_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 6
    34 GPFR_AF_LVL_6_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 6
    35 GPFR_AF_LVL_7_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 7
    36 GPFR_AF_LVL_7_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 7
    37 GPFR_AF_LVL_8_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 8
    38 GPFR_AF_LVL_8_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 8
    39 GPFR_AF_LVL_9_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 9
    40 GPFR_AF_LVL_9_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 9
    41 GPFR_AF_LVL_10_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 10
    42 GPFR_AF_LVL_10_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 10
    43 GPFR_AF_CHECK_DONE Character(1) VARCHAR2(1) NOT NULL Application Framework - Check Done
    I=User Created
    N=System Extracted
    U=User Modified

    Default Value: N

    44 GPFR_AF_ORDER Number(6,0) INTEGER NOT NULL Application Framework - Order
    45 GPFR_AF_LEVEL Number(2,0) SMALLINT NOT NULL Application Framework - Level
    46 GPFR_AF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Application Framework - Attribute Sequence