GPBR_RC_DEPEND

(SQL Table)
Index Back

Process SQR Dependents

The purpose of this record is to run Dependents SQR reports

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

    Prompt Table: OPERATOR_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 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: 5

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

    Prompt Table: GP_PYGRP

    5 BEGIN_DT Date(10) DATE Begin Date
    6 END_DT Date(10) DATE end date
    7 GPBR_PIN_FAMLY_NUM Number(8,0) INTEGER NOT NULL Family Salary

    Prompt Table: GP_PIN_BR0_VW

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

    Prompt Table: GB_GROUP_TBL