GPBR_RC_PAYRSL

(SQL Table)
 Index Back

Main SQR run control record

Main, level 0 SQR run control record, used in all SQRs.

  • Parent Record Of GPBR_RC_PAYRSL1 GPBR_RC_PAYRSL2 GPBR_RC_PAYRSL3

    • # 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 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: GPBR_COMPBRA_VW

    6 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: 6

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

    Prompt Table: GPBR_PAYSL_FORM

    8 EE_LVL_SORT_OPTION Character(2) VARCHAR2(2) NOT NULL Indicates whether to payee associated data should be sorted by EMPLID or NAME
    10=Employee ID
    20=Name

    Default Value: 10

    9 GPBR_SUMMARY_IND Character(1) VARCHAR2(1) NOT NULL Summary Option BRA

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GB_GROUP_TBL