GPBR_RC_VAC_REC

(SQL Table)
 Index Back

Vacation Receipt/Notice Brazil

Vacation Receipt/Notice Brazil General Options

  • Parent Record Of GPBR_RC_AVG_DEP GPBR_RC_AVG_EMP GPBR_RC_AVG_EST GPBR_RC_VAC_DEP GPBR_RC_VAC_EMP GPBR_RC_VAC_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).

    Prompt Table: OPERATOR_VW

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

    5 GPBR_REPORT_OPTION Character(2) VARCHAR2(2) NOT NULL Report Option Run Control Vacation Receipt Brazil
    10=Receipt & Notice
    20=Vacation Receipt
    30=Vacation Notice
    40=Compensation Agreement
    50=Extension Agreement

    Default Value: 10

    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 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    9 END_DATE Date(10) DATE NOT NULL End Date
    10 GPBR_PIN_ACCUM_NUM Number(8,0) INTEGER NOT NULL Accumulator Pin Number for general purpose - run controls

    Prompt Table: GP_PIN_AC0_VW

    11 GPBR_EXCLUDE_FLG1 Character(1) VARCHAR2(1) NOT NULL Exclude Flag 1 Run Control Vacation Receipt Brazil

    Y/N Table Edit

    Default Value: N

    12 GPBR_TOT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Amount
    13 GPBR_NOTICE_DATE Date(10) DATE Notice Date Vacation report