FPAEENOTRET_VW

(SQL View)
 Index Back

Pending Return Individual Ordr

Orders to be edited except Return.

SELECT A.ACTION ,A.EMPLID ,A.EMPL_RCD ,A.FP_NOTIF_REF , SEC.OPRID ,Z.DESCR ,A.FP_TBL_CD FROM PS_FPAEENOTICE A ,PS_FPMACTION_TBL Z %Sql(SCRTY_FPS_FROM, B) , PS_EMPLMT_SRCH_GBL SEC WHERE A.FP_RETURN_R='R' AND A.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND A.ACTION=Z.ACTION AND A.FP_IDVEDIT_DT IS NULL AND (A.FP_EDITIDVDEC='Y' OR A.FP_IDV_ON_REQ='Y') AND (B.EFFDT= ( SELECT MAX(D.EFFDT) FROM PS_FPAEEPOST_TBL D WHERE B.EMPLID=D.EMPLID AND B.EMPL_RCD=D.EMPL_RCD AND D.EFFDT<=%CurrentDateIn)) AND SEC.EMPLID = A.EMPLID AND SEC.EMPL_RCD = A.EMPL_RCD

  • Related Language Record: FPAEENOTRET_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: FPMACTION_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 FP_NOTIF_REF Character(8) VARCHAR2(8) NOT NULL Order reference
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 FP_TBL_CD Character(1) VARCHAR2(1) NOT NULL Step increment indicator
    A=Assignment Table
    C=CareerTable
    D=Request Table
    E=Absence Table
    F=Assignment History
    G=Statutory Position History
    H=Carrer History
    I=Other DataTable
    J=Premium Hist
    K=Work Time History
    L=Compensaton History
    M=Premium
    N=Order Table
    O=Contract Table
    P=Bonus Table
    R=Compensation Table
    S=Statutory Position Table
    T=Other Data History
    U=Bonus History
    W=Work Time Table