GPBR_RC_HRS_CA

(SQL Table)
 Index Back

Hours Compensation Agreement

Hours Compensation Agreement Format Run Control Table

  • Parent Record Of GPBR_RC_HRS_CAE

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

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

    Prompt Table: ESTAB_TBL

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

    Prompt Table: GB_GROUP_TBL

    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SET_VLD_TL_01

    7 SCHEDULE_ID Character(16) VARCHAR2(16) NOT NULL The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).

    Prompt Table: SCH_DEFN_CMN_VW

    8 GPBR_HOURS Number(3,0) SMALLINT NOT NULL Hours
    9 GPBR_DAYS Number(3,0) SMALLINT NOT NULL Days
    10 GPBR_YEAR_CD Character(4) VARCHAR2(4) NOT NULL Calendar Year

    Default Value: 2

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

    12 GPBR_ADVANCE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Advance Percentage Brazil
    13 GPBR_DUE_DATE Date(10) DATE NOT NULL Due Date GRCS report