GPBR_NRP_UEM_VW

(SQL View)
 Index Back

Unemployment Insurance Brazil

Unemployment Insurance Report Brazil Non Rule package view

SELECT OPRID , RUN_CNTL_ID , EMPLID , GPBR_DESCR_CBO , GPBR_HORIZONTAL , GPBR_VERTICAL , COMPANY , EE_LVL_SORT_OPTION , GPBR_LIST_OPTION , GB_GROUP_ID , GPBR_PIN_ACCUM_NUM + 50000000 , GPBR_PIN_ACCM2_NUM + 50000000 , GPBR_PIN_ERN_NUM + 50000000 , BGN_DT , END_DT , GPBR_OUTPUT_TYPE FROM PS_GPBR_RC_UNEMP

  • 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).

    Prompt Table: OPERATOR_VW

    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
    6 GPBR_VERTICAL Number(1,0) SMALLINT NOT NULL Vertical Alignment positions for printed reports
    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: GP_PIN_AC0_VW

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

    Prompt Table: GP_PIN_AC0_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 Begin Date
    15 END_DT Date(10) DATE end date
    16 GPBR_OUTPUT_TYPE Character(1) VARCHAR2(1) NOT NULL Output Report Option
    1=File Only
    2=Report Only
    3=Both
    4=File Only - By Establishment