GPBR_RC_GRRF

(SQL Table)
 Index Back

Collection Unemployment BRA

Guide of Collection of Unemployment Guarantee Fund Time Service for Brazil Run Control Table

  • Parent Record Of GPBR_RC_GRRFE

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

    Prompt Table: COMPANY_TBL

    4 ASOFDATE Date(10) DATE NOT NULL As of Date

    Default Value: %date

    5 GPBR_PIN_VAR_NUM Number(8,0) INTEGER NOT NULL Alimony Percentage BRA

    Prompt Table: GP_PIN_VAR_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: 1

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

    Prompt Table: ESTAB_TBL

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

    Prompt Table: GB_GROUP_TBL

    9 GPBR_CRED_BGN_DT Date(10) DATE NOT NULL Credit Begin Date -- Vacations Brazil
    10 GPBR_CRED_END_DT Date(10) DATE NOT NULL Credit End Date Vacations Brazil
    11 GPBR_COMP_REPT Character(1) VARCHAR2(1) NOT NULL Complementary Report Flag

    Y/N Table Edit

    Default Value: N