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 , GPBR_PIN_ACCUM_NUM + 50000000 , GPBR_PIN_ACCM2_NUM + 50000000 , GPBR_PIN_ERN_NUM + 50000000 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 GPBR_PIN_ACCUM_NUM Number(8,0) INTEGER NOT NULL Accumulator Pin Number for general purpose - run controls

    Prompt Table: GP_PIN_AC0_VW

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

    Prompt Table: GP_PIN_AC0_VW

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

    Prompt Table: GPBR_PIN_ER_VW