GPBR_RC_UNEMP

(SQL Table)
 Index Back

Unemployment Report

The purpose of this record is to store the run control parameters for Unemployment Insurance Report

  • Parent record: GPBR_RC_DARF

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    4 GPBR_DESCR_CBO Character(30) VARCHAR2(30) NOT NULL CBO Description for Unemployment Report
    5 GPBR_HORIZONTAL Number(1,0) SMALLINT NOT NULL Horizontal alignment for report

    Default Value: 0

    6 GPBR_VERTICAL Number(1,0) SMALLINT NOT NULL Vertical Alignment positions for printed reports

    Default Value: 0

    7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: GPBR_COMPBRA_VW

    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_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

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

    Prompt Table: GB_GROUP_TBL

    11 GPBR_PIN_ACCUM_NUM Number(8,0) INTEGER NOT NULL Accumulator Pin Number for general purpose - run controls

    Prompt Table: GPBR_PIN_ACM_VW

    12 GPBR_PIN_ACCM2_NUM Number(8,0) INTEGER NOT NULL Accumulator Pin Num for general purpose (Brazil)

    Prompt Table: GPBR_PIN_ACM_VW

    13 GPBR_PIN_ERN_NUM Number(8,0) INTEGER NOT NULL Earnings Pin Number

    Prompt Table: GPBR_PIN_ER_VW

    14 BGN_DT Date(10) DATE NOT NULL Begin Date
    15 END_DT Date(10) DATE NOT NULL end date