GPNZ_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 GPNZ_RC_RCP_LST GPNZ_RC_RCP_MT9

    • # 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

    5 PAYMENT_DT Date(10) DATE NOT NULL Payment Date

    Default Value: %Date

    6 GPNZ_RCPNT_OPTN Character(2) VARCHAR2(2) NOT NULL Determines how recipients are to be selected for inclusiuon in the NZ EFT & Recipient processing.
    10=Selected Recipients
    20=All Recipients
    30=Selected Deduction

    Default Value: 10

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

    Prompt Table: GPAU_DED_SRCH