GP_OC_SETUP_A

(SQL Table)
 Index Back

Advance Configuration

Configuration for Off cycle Advances interface

  • Related Language Record: GP_OC_SU_A_LNG

  • Parent record: GP_OC_SETUP

    • # 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 ALLW_PART_PRD_IND Character(1) VARCHAR2(1) NOT NULL Allow Partial Period Advances

    Y/N Table Edit

    Default Value: Y

    7 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

    Default Value: U

    Prompt Table: GP_X_PMTMTHD_VW

    8 ALLW_PMT_MTHD_IND Character(1) VARCHAR2(1) NOT NULL YesNo edit controls whether user can enter payment method

    Y/N Table Edit

    Default Value: Y