GPAU_RC_RCPT_FL

(SQL Table)
Index Back

RCP file run controbl table

The table stores parameters for the recipient payment file process.

  • Parent Record Of GPAU_RC_RCP_LST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: PRCSRUNCNTL.RUN_CNTL_ID

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: PRCSRUNCNTL.OPRID

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: ENG

    4 DEBIT_DT Date(10) DATE NOT NULL Debit Date

    Default Value: %Date

    Prompt Table: GPAU_DEBITDT_VW

    5 PAYMENT_DT Date(10) DATE NOT NULL Payment Date

    Default Value: %Date

    6 GPAU_RCPNT_OPTN Character(2) VARCHAR2(2) NOT NULL This is used to identify the recipient option.
    10=Select Recipients Only
    20=All Recipients
    30=Deduction

    Default Value: 10

    7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: GPAU_DED_SRCH

    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    9 SUMMARY_REPORT Character(1) VARCHAR2(1) NOT NULL Summary Report
    N=No Summary Report
    Y=Report Summary

    Default Value: N