GPBR_RC_PAY001

(SQL Table)
 Index Back

Run Control Payslip

Run Control Payslip

  • Parent Record Of GPBR_RC_PAY_EE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GP_CAL_GRP_SRCH

    4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

    Prompt Table: GPBR_CALRUN_VW

    5 GPBR_FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

    Prompt Table: GPBR_FORMAT_VW

    6 GPBR_SORTID Character(10) VARCHAR2(10) NOT NULL SORT ID

    Prompt Table: GPBR_SORTID_VW

    7 GPBR_VACATION_IND Character(1) VARCHAR2(1) NOT NULL GP Brazil Vacation Indicator

    Y/N Table Edit

    Default Value: N

    8 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

    Prompt Table: GP_RUN_TYPE

    9 GPBR_LIST_OPTION Character(1) VARCHAR2(1) NOT NULL List Option Brazil Run Control
    1=All Establishments & Employees
    2=Select Establishment ID
    3=Select Employees
    4=Select Group ID
    5=Select Pay Group
    6=All Employees
    7=Select Department ID

    Default Value: 1

    10 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL

    11 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_TBL

    12 GPBR_MESSAGE Character(254) VARCHAR2(254) NOT NULL Message