GPBR_VACN_AP_VW

(SQL View)
 Index Back

Vacation Acquisitive Period.

Vacation Entitlement Period View Brazil.

SELECT A.EMPLID ,A.EMPL_RCD ,A.BEGIN_DT ,A.END_DATE ,A.SEQNUM ,A.GPBR_PER_END_DT ,A.GPBR_AP_VAC_STATUS ,A.SERVICE_YEARS ,A.GPBR_CALC_DAYS ,A.GPBR_MAX_VAC_PER ,A.GPBR_ADJ_DAYS ,A.GPBR_UPD_TYPE ,A.ORIG_BEGIN_DT FROM PS_GPBR_VACN_AP_WA A WHERE A.SEQNUM = ( SELECT MAX(B.SEQNUM) FROM PS_GPBR_VACN_AP_WA B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.BEGIN_DT = A.BEGIN_DT AND B.END_DATE = A.END_DATE) AND (A.CAL_RUN_ID = ( SELECT C.CAL_RUN_ID FROM PS_GP_CAL_RUN C WHERE C.RUN_OPEN_TS = ( SELECT MAX(D.RUN_OPEN_TS) FROM PS_GP_CAL_RUN D WHERE D.CAL_RUN_ID IN ( SELECT E.CAL_RUN_ID FROM PS_GPBR_VACN_AP_WA E WHERE A.EMPLID = E.EMPLID AND A.EMPL_RCD = E.EMPL_RCD AND A.BEGIN_DT = E.BEGIN_DT AND A.END_DATE = E.END_DATE))) OR A.CAL_RUN_ID = 'MAN')

  • Parent record: EMPLMT_SRCH_GBL

    • # 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 Rcd Nbr
    3 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    4 END_DATE Date(10) DATE NOT NULL End Date
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 GPBR_PER_END_DT Date(10) DATE Period End Date -- Vacations Brazil
    7 GPBR_AP_VAC_STATUS Character(2) VARCHAR2(2) NOT NULL Acquisitive Period Status
    01=In Progress
    02=Open
    03=Close per Absence
    04=Close Expired
    05=Close

    Default Value: 02

    8 SERVICE_YEARS Number(2,0) SMALLINT NOT NULL Years of Service
    9 GPBR_CALC_DAYS Number(3,0) SMALLINT NOT NULL Calculated Vacation Days GP Brazil
    10 GPBR_MAX_VAC_PER Number(2,0) SMALLINT NOT NULL Maximum Vacation Days per Period
    11 GPBR_ADJ_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Leave Days Brazil
    12 GPBR_UPD_TYPE Character(2) VARCHAR2(2) NOT NULL Updater Type Online or Batch
    10=On Line
    20=Batch
    13 ORIG_BEGIN_DT Date(10) DATE original begin date