GP_ABS_LVDN_HVW

(SQL View)
 Index Back

Leave Donation Hist Inquiry

Self Service Leave Donation History

SELECT HDR.TRANSACTION_NBR , HDR.EMPLID , HDR.EMPL_RCD , HDR.ACTION_DT_SS , HDR.LVDN_PRGM_ID , PRGM.DESCR , HDR.LVDN_REQUEST_TYPE , HDR.WF_STATUS , HDR.LVDN_ENTRY_SRC , HDR.LVDN_TRANS_STATUS FROM PS_GP_ABS_LVDN_HDR HDR , PS_GP_ABS_LVDN_PRG PRGM WHERE HDR.COUNTRY2 = PRGM.COUNTRY AND HDR.LVDN_PRGM_ID = PRGM.LVDN_PRGM_ID

  • Related Language Record: GP_ABS_LVDN_HLN

    • # 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 ACTION_DT_SS Date(10) DATE Termination Date
    5 LVDN_PRGM_ID Character(10) VARCHAR2(10) NOT NULL Leave Program
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 LVDN_REQUEST_TYPE Character(3) VARCHAR2(3) NOT NULL Leave Donation Request Type
    ADJ=Adjust
    DON=Donate
    RCV=Receive
    RET=Return
    TER=Terminate
    8 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
    9 LVDN_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Leave Donation Entry Source
    A=Administrator
    E=Employee Self Service
    10 LVDN_TRANS_STATUS Character(1) VARCHAR2(1) NOT NULL Leave Donation Transaction Status
    P=Processed
    R=Recurring
    U=Unprocessed