GPBR_RC_TER_CON

(SQL Table)
Index Back

Contract Termination/Report Br

Contract Termination/Report Brazil General Options

  • Parent Record Of GPBR_RC_TER_DEP GPBR_RC_TER_EMP GPBR_RC_TER_EST
  • # 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 BEGIN_DT Date(10) DATE Begin Date
    5 END_DT Date(10) DATE end date
    6 GPBR_FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

    Prompt Table: GPBR_FORMAT_VW

    7 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

    Prompt Table: GP_RUN_TYPE

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

    Prompt Table: GP_PIN_AC0_VW

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

    Prompt Table: GPBR_PIN_DV_VW

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

    Prompt Table: GPBR_PIN_DV_VW

    11 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: 2

    12 GPBR_COMP_REPT Character(1) VARCHAR2(1) NOT NULL Complementary Report Flag

    Y/N Table Edit

    Default Value: N

    13 GPBR_PRINT_ZERO Character(1) VARCHAR2(1) NOT NULL Print if Legal Code is Zero

    Y/N Table Edit

    Default Value: N

    14 GPBR_TRCT_RPT_TYPE Character(1) VARCHAR2(1) NOT NULL Print Report Indcator
    1=All Reports
    2=TRCT- Termination Report
    3=Termination Settlement Report
    4=Homologation Report

    Default Value: 1

    15 GPBR_COPIES Number(3,0) SMALLINT NOT NULL Number of Copies to generate for brazlian reports

    Default Value: 1