GP_NRP_OCS_U_VW

(SQL View)
 Index Back

Addtl Payment Configuration

Configuration for Off cycle Additional Payment interface

SELECT COUNTRY , GP_TX_TYPE , GP_TX_REASON , DESCR , DESCRSHORT , HIDE_SECTION_IND , ALLW_BGN_DT_IND , ALLW_END_DT_IND , HIDE_SECTION2_IND , RUN_TYPE , ALLW_RUN_TYPE_IND , PAYMENT_MTHD , ALLW_PMT_MTHD_IND , GP_ELEM_PRC_OPTN , ALLW_ELEM_PRC_IND , PIN_ELEM_GRP_NUM + 50000000 , ALLW_PMT_KEYS_IND FROM PS_GP_OC_SETUP_U

  • Related Language Record: GP_OC_SU_U_LNG

  • Parent record: GP_OC_SETUP_U

    • # 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 HIDE_SECTION_IND Character(1) VARCHAR2(1) NOT NULL Hide Calendar Controls
    7 ALLW_BGN_DT_IND Character(1) VARCHAR2(1) NOT NULL Allow entry of Begin Date
    8 ALLW_END_DT_IND Character(1) VARCHAR2(1) NOT NULL Allow entry of End Date
    9 HIDE_SECTION2_IND Character(1) VARCHAR2(1) NOT NULL YesNo edit controls the display of a section (group box)
    10 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
    11 ALLW_RUN_TYPE_IND Character(1) VARCHAR2(1) NOT NULL Allow entry of Run Type
    12 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
    13 ALLW_PMT_MTHD_IND Character(1) VARCHAR2(1) NOT NULL YesNo edit controls whether user can enter payment method
    14 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
    15 ALLW_ELEM_PRC_IND Character(1) VARCHAR2(1) NOT NULL Allow entry of Element Select
    16 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group
    17 ALLW_PMT_KEYS_IND Character(1) VARCHAR2(1) NOT NULL Allow entry of Payment Keys