GPNZ_PDR_RC_EMF

(SQL Table)
 Index Back

Run CNTL- Record Empl File

Run control record for PDR Employment File.

  • Parent Record Of GPNZ_PDR_RC_EMC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: PRCSRUNCNTL.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: PRCSRUNCNTL.RUN_CNTL_ID

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

    Prompt Table: GPNZ_PDR_OPR_VW

    4 GPNZ_PDR_YEAR Character(4) VARCHAR2(4) NOT NULL Year code
    5 GPNZ_PDR_FL_RNTYP Character(1) VARCHAR2(1) NOT NULL PDR Employment File Run Control - Run Type
    P=Production
    T=Test
    6 GPNZ_PDR_RNTYP Character(3) VARCHAR2(3) NOT NULL PDR Run Type
    AMD=Amendment
    NRM=Original
    OVR=Override
    7 GPNZ_PDR_FL_TYP Character(4) VARCHAR2(4) NOT NULL PDR Employment File Run Control - File Type
    CSV=CSV
    XLS=XLS
    XML=XML

    Default Value: CSV

    8 PYMT_DT Date(10) DATE NOT NULL Payment Date

    Prompt Table: %GP_EDIT_FLD9

    9 GPNZ_PDR_FINRET_ER Character(1) VARCHAR2(1) NOT NULL PDR Employment File Run Control - Final Return Indicator

    Y/N Table Edit

    Default Value: N

    10 GPNZ_PDR_NILRET_ER Character(1) VARCHAR2(1) NOT NULL PDR Employment File Run Control - Nil Return Indicator

    Y/N Table Edit

    Default Value: N