GP_ABS_EAADM_VW

(SQL View)
 Index Back

View to retrieve EA Events

View to retrieve Extended Absence Events using AWE tables.

SELECT EA.EMPLID , EA.EMPL_RCD , EA.TRANSACTION_NBR , EA.PIN_TAKE_NUM , EA.BGN_DT , EA.END_DT , EA.RETURN_DT , EA.REQUEST_DT , EA.ABS_ENTRY_SRC , EA.ABSENCE_REASON , EA.MANAGER_APPR_IND , EA.LAST_UPDT_DT , EA.COMMENTS , PERS.NAME , PERS.LAST_NAME , P.DESCR , EA.WF_STATUS , ST.EOAWSTEP_STATUS , ST.OPRID , %DateNull FROM PS_GP_ABS_EA_XREF X , PS_EOAW_STEP_VW ST , PS_GP_ABS_EA EA , PS_GP_PIN P , PS_PERSON_NAME PERS WHERE X.EOAWTHREAD_ID = ST.EOAWTHREAD_ID AND X.EOAWPRCS_ID = ST.EOAWPRCS_ID AND EA.TRANSACTION_NBR = X.TRANSACTION_NBR AND EA.EMPLID = PERS.EMPLID AND P.PIN_NUM = EA.PIN_TAKE_NUM AND X.EOAWPARENT_THREAD = ( SELECT MAX(Y.EOAWPARENT_THREAD) FROM PS_GP_ABS_EA_XREF Y WHERE X.TRANSACTION_NBR = Y.TRANSACTION_NBR AND Y.EOAWTHREAD_STATUS <> 'T')

  • Related Language Record: GP_ABS_EAAD_LNG

    • # 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 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.
    4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    5 BGN_DT Date(10) DATE Begin Date
    6 END_DT Date(10) DATE end date
    7 RETURN_DT Date(10) DATE Return Date
    8 REQUEST_DT Date(10) DATE Request Date
    9 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
    10 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
    11 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
    12 LAST_UPDT_DT Date(10) DATE Date of last Update
    13 COMMENTS Long Character CLOB Comment
    14 NAME Character(50) VARCHAR2(50) NOT NULL Name
    15 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
    A=Approved
    B=Pushed back
    C=Auto Approved
    D=Denied
    E=Administrator denied
    F=Deleted
    G=Bypassed
    H=On Hold
    I=No Action Taken
    K=Skipped
    L=Terminated
    M=Administrator approved
    N=Not Active
    P=Pending
    R=No longer in role
    T=Terminated
    U=Auto approved
    X=Deleted
    Z=Pending Denial
    19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    20 SUBMIT_DT Date(10) DATE Submission Date