GPBR_LEAVE_PROG

(SQL Table)
Index Back

Leave Credit Record

Leave Program Record

  • Parent record: GPBR_VACN_AP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    4 END_DATE Date(10) DATE NOT NULL End Date
    5 ABS_BGN_DT Date(10) DATE NOT NULL Absence Begin Date
    6 ABS_END_DT Date(10) DATE Absence End Date
    7 DAYS Number(3,0) SMALLINT NOT NULL Days
    8 GPBR_13TH_ADVANCE Number(1,0) SMALLINT NOT NULL Advance payment 13th Month

    1/0 Table Edit (1=True, 0=False)

    9 GPBR_LEAVE_STATUS Character(2) VARCHAR2(2) NOT NULL Leave Status
    01=Programmed
    03=Calculated
    04=Confirmed
    05=Cancelled
    06=Closed

    Default Value: 01

    10 GPBR_PROG_LEAVE_ID Character(2) VARCHAR2(2) NOT NULL Program Identifier
    01=Manual
    02=Collective

    Default Value: 01

    11 GPBR_PAY_CREDIT Number(1,0) SMALLINT NOT NULL Y N field Pay Credit for Programed Leaves

    1/0 Table Edit (1=True, 0=False)

    12 GPBR_CREDIT_DAYS Number(3,0) SMALLINT NOT NULL Credit Days
    13 GPBR_CRED_BGN_DT Date(10) DATE Credit Begin Date -- Vacations Brazil
    14 GPBR_CRED_END_DT Date(10) DATE Credit End Date Vacations Brazil
    15 GPBR_MASS_ABS_ID Character(10) VARCHAR2(10) NOT NULL Mass Vacation ID Brazil