GPAU_STP_PRE_RN

(SQL Table)
 Index Back

Run Control for STP Pay Event

Run Control for STP Payroll Event Prep Process

  • Parent Record Of GPAU_CAL_RUNCTL GPAU_STPCLRN_VW GPAU_STP_CAL_RN GPAU_STP_DC_CAL GPAU_STP_REC_CL

    • # 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 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
    4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT_SGPAU

    5 GPAU_STP_PREP_IND Character(1) VARCHAR2(1) NOT NULL Header - STP Preparation Process
    6 GPAU_PROCESS_BY Character(1) VARCHAR2(1) NOT NULL Processing Option of STP Preparation Process.. Options are: By Pay Entity, Pay Group, Employee, Stream, Group List.
    E=Emplid
    G=Group List
    N=Pay Entity
    P=Pay Group
    R=Period End Date
    S=Streams

    Default Value: N

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

    Prompt Table: GPAU_CALRUN_VW

    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %RECNAME_EDIT

    9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: GPAU_EMPRCD_VW

    10 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.

    Prompt Table: GPAU_EEBLGRP_VW

    11 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List

    Prompt Table: GP_GRP_LIST_VW

    12 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

    Prompt Table: GPAU_STRM_VW

    13 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GPAU_PYGRP_VW

    14 GPAU_TAX_YR_BGN_DT Date(10) DATE Begin Date
    15 GPAU_TAX_YR_END_DT Date(10) DATE End Date
    16 GPAU_STP_FINAL_IND Character(1) VARCHAR2(1) NOT NULL Finalized Payroll Indicator - Single Touch Payroll

    Y/N Table Edit

    17 PRD_END_DT Date(10) DATE Pay Period End Date

    Prompt Table: GPAU_PRDEND_DVW

    18 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

    Prompt Table: GPAU_CALPRD_DVW

    19 GPAU_STP_PRC_CLGRP Character(1) VARCHAR2(1) NOT NULL Processed Calender Groups - Single Touch Payroll
    20 SELECT_ALL Character(1) VARCHAR2(1) NOT NULL Select All
    21 DESELECT_ALL Character(1) VARCHAR2(1) NOT NULL Deselect All