GPNZ_RUNCTL_MT9

(SQL Table)
 Index Back

EFT transfer run control table

The table stores parameters for the NZ EFT file creation process

  • Parent record: PRCSRUNCNTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 GPNZ_PMT_TYPE Character(2) VARCHAR2(2) NOT NULL This field determines which kind of payments will be included in the NZ EFT process.
    10=Net Pay Distributions Only
    20=Deduction Recipients Only
    30=Net Pay and Recipients
    40=Group Tax

    Default Value: 10

    4 GPNZ_RERUN_MT9 Character(1) VARCHAR2(1) NOT NULL Indicates when the NZ EFT process is a re-run to allow the payment file to be recreated

    Y/N Table Edit

    Default Value: N

    5 GPNZ_DEPOSIT_DT Date(10) DATE NOT NULL Date of Deposit of EFT payments for NZ

    Default Value: %Date

    6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GPNZ_CALRUN1_VW

    7 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT

    8 DEBIT_DT Date(10) DATE Debit Date
    9 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: 20

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

    Prompt Table: GPAU_DED_SRCH

    11 PRD_BGN_DT Date(10) DATE Period Begin Date
    12 PRD_END_DT Date(10) DATE Pay Period End Date