GP_NRP_OCS_C_VW

(SQL View)
 Index Back

Correction Configuration

Configuration for Off cycle Corrections interface

SELECT COUNTRY , GP_TX_TYPE , GP_TX_REASON , DESCR , DESCRSHORT , GP_CORR_TYPE_LTD , ALLW_CORR_TYPE_IND , RTO_MTHD_OPTN , ALLW_RTO_MTHD_IND , HIDE_SECTION2_IND , PAYMENT_MTHD , ALLW_PMT_MTHD_IND , GP_ELEM_PRC_OPTN , ALLW_ELEM_PRC_IND , PIN_ELEM_GRP_NUM +50000000 FROM PS_GP_OC_SETUP_C

  • Related Language Record: GP_OC_SU_C_LNG

  • Parent record: GP_OC_SETUP_C

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 GP_TX_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance. XLAT values are assigned to support batch processing order
    A=Advance
    M=Manual Payment
    R=Correction
    U=Additional Payment
    3 GP_TX_REASON Character(18) VARCHAR2(18) NOT NULL Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 GP_CORR_TYPE_LTD Character(1) VARCHAR2(1) NOT NULL Correction Type - Limited (Field used in combination with RTO_MTHD) to represent the master set of options found in GP_CORR_TYPE
    N=Replacement
    R=Forced Reversal
    7 ALLW_CORR_TYPE_IND Character(1) VARCHAR2(1) NOT NULL YesNo toggle controlling whether user can enter Correction Type
    8 RTO_MTHD_OPTN Character(1) VARCHAR2(1) NOT NULL Retro Processing Rule. Allows user to indicate whether to use the normal setting or to force corrective retro
    C=Forced Corrective
    N=Use Existing Retro Rules
    9 ALLW_RTO_MTHD_IND Character(1) VARCHAR2(1) NOT NULL YesNo edit controls whether user can enter Retro Method
    10 HIDE_SECTION2_IND Character(1) VARCHAR2(1) NOT NULL YesNo edit controls the display of a section (group box)
    11 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
    A=Cash
    C=Check
    O=Pay Primary Account Only
    P=Postal Order
    T=Bank Transfer
    U=Use Normal Distribution
    W=Wire Transfer
    12 ALLW_PMT_MTHD_IND Character(1) VARCHAR2(1) NOT NULL YesNo edit controls whether user can enter payment method
    13 GP_ELEM_PRC_OPTN Character(1) VARCHAR2(1) NOT NULL Helps user select what "Big Stuff" elements to process during a given calendar (off cycle). All, only those with PI, or a limited identified set
    A=All
    L=Limited Element Set
    P=Elements with Positive Input
    14 ALLW_ELEM_PRC_IND Character(1) VARCHAR2(1) NOT NULL Allow entry of Element Select
    15 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group