GP_ABS_APPR_VW

(SQL View)
Index Back

Absence SS according to AWE

View to retrieve Absence Events belong to a Manager using AWE tables.

SELECT DISTINCT R.TRANSACTION_NBR , R.EMPLID , R.EMPL_RCD , R.BGN_DT , R.PIN_TAKE_NUM , R.END_DT , R.ORIG_EMPLID , R.ORIG_EMPL_RCD , R.ORIG_BEGIN_DT , R.ORIG_PIN_TAKE_NUM , R.ORIG_END_DT , R.ELIG_GRP , Z.NAME , C.JOBTITLE , D.DESCR , R.WF_STATUS , R.DURATION_ABS , R.ACTION_DT_SS , S.PTAFSTEP_STATUS , S.OPRID FROM PS_GP_ABSSS_V_XREF X , PS_PTAFAW_STEP_VW S , PS_GP_ABSSS_PNDG_2 R , PS_GP_ABS_EEJOB_VW C , PS_GP_PIN D , PS_PERSON_NAME Z WHERE X.PTAFTHREAD_ID = S.PTAFTHREAD_ID AND X.PTAFPRCS_ID = S.PTAFPRCS_ID AND R.TRANSACTION_NBR = X.TRANSACTION_NBR AND R.EMPLID = Z.EMPLID AND R.EMPLID = C.EMPLID AND R.EMPL_RCD = C.EMPL_RCD AND D.PIN_NUM = R.ORIG_PIN_TAKE_NUM AND X.PTAFPARENT_THREAD = ( SELECT MAX(Y.PTAFPARENT_THREAD) FROM PS_GP_ABSSS_V_XREF Y WHERE X.TRANSACTION_NBR = Y.TRANSACTION_NBR AND Y.PTAFTHREAD_STATUS <> 'T')

  • Related Language Record: GP_ABS_APPRVW_L
  • # 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 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 end date
    7 ORIG_EMPLID Character(11) VARCHAR2(11) NOT NULL Originating Emplid
    8 ORIG_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    9 ORIG_BEGIN_DT Date(10) DATE original begin date
    10 ORIG_PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    11 ORIG_END_DT Date(10) DATE Original END_DT before adjust
    12 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group
    13 NAME Character(50) VARCHAR2(50) NOT NULL Name
    14 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    16 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
    17 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
    18 ACTION_DT_SS Date(10) DATE Termination Date
    19 AWSTEP_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
    K=Skipped
    L=Terminated
    M=Administrator approved
    N=Not Active
    P=Pending
    S=Skipped
    T=Terminated
    U=Auto approved
    X=Deleted
    Y=Bypassed
    20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN