GPFR_AF_RUN_DFN

(SQL Table)
 Index Back

Extraction Definition

Application Framework - This record is used to define required extraction data

  • Related Language Record: GPFR_AF_RUN_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
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    4 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application

    Prompt Table: GPFR_AF_APPL

    5 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set

    Prompt Table: GPFR_AF_NTSR_VW

    6 GPFR_DA_USEDDT Character(1) VARCHAR2(1) NOT NULL DADS related field
    E=End Dates
    P=Payment Dates
    7 GPFR_AF_PERIOD Character(1) VARCHAR2(1) NOT NULL Application Framework - Period Format
    M=Monthly Declaration
    O=Other Declaration
    Q=Quaterly Declaration
    Y=Yearly Declaration

    Default Value: Y

    8 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date
    9 PERIOD_END_DT Date(10) DATE Period End Date
    10 GPFR_DA_YEAR Number(4,0) SMALLINT NOT NULL DADS related field
    11 GPFR_AF_RUN_PRCFLG Character(1) VARCHAR2(1) NOT NULL Application Framework - Run Processed Flag
    N=Process Not Run
    Y=Process Run

    Y/N Table Edit

    Default Value: N