HGA_BAL_HIST_VW

(SQL View)
Index Back

List of Events by Take

Self Service Absence History outer join with workflow status

SELECT DAT.TRANSACTION_NBR , DAT.EMPLID , DAT.EMPL_RCD , DAT.BGN_DT , DAT.PIN_TAKE_NUM , DAT.END_DT , B.PIN_ENTL_BAL_NUM , DAT.ORIG_BEGIN_DT , DAT.ORIG_PIN_TAKE_NUM , DAT.ORIG_END_DT , DAT.COUNTRY , DAT.ELIG_GRP , AE.ABS_ENTRY_SRC , AE.DURATION_ABS , AE.VOIDED_IND , AE.PRC_EVT_ACTN_OPTN , AE.MANAGER_APPR_IND , AE.WF_STATUS , AE.PROCESS_DT , PIN.COUNTRY , PIN.DESCR , SS.UNIT_TYPE FROM PS_GP_ABS_SS_DAT DAT , PS_GP_ABS_EVENT AE , PS_GP_PIN PIN , PS_GP_ABS_SS SS , PS_GP_PIN_CMPNT B , PS_GP_ABS_TAKE_ENT C WHERE AE.TRANSACTION_NBR = DAT.TRANSACTION_NBR AND AE.EMPLID = DAT.EMPLID AND AE.EMPL_RCD = DAT.EMPL_RCD AND AE.BGN_DT = DAT.ORIG_BEGIN_DT AND AE.PIN_TAKE_NUM = DAT.ORIG_PIN_TAKE_NUM AND AE.END_DT = DAT.ORIG_END_DT AND SS.COUNTRY = DAT.COUNTRY AND SS.PIN_TAKE_NUM = DAT.ORIG_PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, SS, DAT.BGN_DT) AND PIN.PIN_NUM = DAT.ORIG_PIN_TAKE_NUM AND (PIN.USED_BY = 'A' OR PIN.COUNTRY = SS.COUNTRY) AND C.PIN_ENT_NUM = B.PIN_NUM AND C.PRIORITY = ( SELECT MIN(PRIORITY) FROM PS_GP_ABS_TAKE_ENT GATE WHERE GATE.PIN_ENT_NUM = C.PIN_ENT_NUM) AND AE.PIN_TAKE_NUM = C.PIN_NUM AND AE.PROCESS_DT IS NULL

  • Related Language Record: GP_ABSHISTSS_LV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 BGN_DT Date(10) DATE NOT NULL Begin Date
    5 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

    Prompt Table: GP_PIN_ABSTK_VW

    6 END_DT Date(10) DATE NOT NULL end date
    7 PIN_ENTL_BAL_NUM Number(8,0) INTEGER NOT NULL Element number field
    8 ORIG_BEGIN_DT Date(10) DATE original begin date
    9 ORIG_PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    10 ORIG_END_DT Date(10) DATE Unadjusted End Date
    11 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country
    12 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group
    13 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
    1=Administrator Absence Event
    2=Time & Labor
    3=Third Party
    4=Employee Absence Request
    5=Manager Absence Request
    6=Employee Timesheet
    7=Manager Timesheet
    A=Employee Extended Absence
    B=Manager Extended Absence
    C=Administrator Extended Absence
    D=Employee Desktop Integration
    14 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
    15 VOIDED_IND Character(1) VARCHAR2(1) NOT NULL Voided Indicator
    16 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
    N=Normal
    V=Void
    17 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
    18 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    19 PROCESS_DT Date(10) DATE Process Date
    20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    22 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
    D=Days
    H=Hours