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.DURATION_HOURS ,AE.DURATION_DYS , 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 , DAT.HGA_WF_STATUS , SS.HGA_CAN_ALLOW_BY , SS.HGA_CANCEL_OPTN , CN.HGA_CAN_LIMIT_BACK , CN.HGA_CAN_LIMIT_FWD , CASE WHEN AE.CAL_RUN_ID = ' ' THEN 'N' ELSE CASE WHEN CAL.RUN_FINALIZED_IND = 'Y' THEN 'F' ELSE 'P' END END , SS.FCST_IND , AE.ABS_EVT_FCST_VAL , CN.FCST_REQ_FLAG , AE.ABSENCE_REASON , AE.COMMENTS FROM PS_GP_ABS_SS_DAT DAT , PS_GP_ABS_EVENT AE LEFT OUTER JOIN PS_GP_CAL_RUN CAL ON CAL.CAL_RUN_ID = AE.CAL_RUN_ID , PS_GP_PIN PIN , PS_GP_ABS_SS SS , PS_GP_ABS_SS_CNTRY CN 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 CN.COUNTRY = DAT.COUNTRY AND %EffdtCheck(GP_ABS_SS_CNTRY, CN, DAT.BGN_DT)

  • 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 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 Unadjusted End Date
    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 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
    13 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
    14 DURATION_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Duration (Hours)
    15 DURATION_DYS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
    16 VOIDED_IND Character(1) VARCHAR2(1) NOT NULL Voided Indicator
    17 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
    N=Normal
    V=Void
    18 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
    19 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
    20 PROCESS_DT Date(10) DATE Process Date
    21 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    22 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    23 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
    D=Days
    H=Hours
    24 HGA_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=Push Back
    S=Submitted
    V=Saved
    25 HGA_CAN_ALLOW_BY Character(1) VARCHAR2(1) NOT NULL Cancel Allowed By
    B=Employee and Manager
    E=Employee
    M=Manager
    26 HGA_CANCEL_OPTN Character(1) VARCHAR2(1) NOT NULL Delete Event option
    1=All Events
    2=All Events Except Processed
    3=All Events Except Finalized
    4=Not Used
    27 HGA_CAN_LIMIT_BACK Number(4,0) SMALLINT NOT NULL Cancel limit by Months backward
    28 HGA_CAN_LIMIT_FWD Number(4,0) SMALLINT NOT NULL Cancel limit by months forward
    29 GP_ABS_EVT_STAT Character(1) VARCHAR2(1) NOT NULL Absence event status
    F=Finalized
    N=Not Processed
    P=Processed
    30 FCST_IND Character(1) VARCHAR2(1) NOT NULL This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting.
    31 ABS_EVT_FCST_VAL Character(30) VARCHAR2(30) NOT NULL This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.
    32 FCST_REQ_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether Forecasting a request is enabled.
    33 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
    34 COMMENTS Long Character CLOB Comment