GP_ABSHISTSS_VW

(SQL View)
 Index Back

Self Service Absence Hist Inqu

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

  • 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 Rcd Nbr
    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 ORIG_BEGIN_DT Date(10) DATE original begin date
    8 ORIG_PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    9 ORIG_END_DT Date(10) DATE Original END_DT before adjust
    10 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country
    11 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group
    12 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
    1=Administrator
    2=Time & Labor
    3=Third Party
    4=Employee Self Service
    5=Manager Self Service
    6=Employee Timesheet
    7=Manager Timesheet
    13 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
    14 VOIDED_IND Character(1) VARCHAR2(1) NOT NULL Voided Indicator
    15 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
    N=Normal
    V=Void
    16 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
    17 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
    18 PROCESS_DT Date(10) DATE Process Date
    19 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    21 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
    D=Days
    H=Hours