FPAEENOTRET_LNG

(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.LANGUAGE_CD ,Z.DESCR FROM PS_FPAEENOTICE A ,PS_FPMACTION_LNG Z ,PS_EMPLMT_SRCH_GBL SEC WHERE A.ACTION=Z.ACTION AND A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD

  • Related Language Record for FPAEENOTRET_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description