EX_SRCH_FLD_LVW

(SQL View)
 Index Back

Fields eligible for Search

This view is used within Summary Approvals and Modify Approved Transactions components.

SELECT B.APPR_SUM_TRAN_TYPE , A.PNLFIELDNAME , D.LANGUAGE_CD , D.LONGNAME , B.XLATVALUES FROM PSPNLFIELD A , PS_EX_APPR_CFG_TBL B , PSDBFIELD C , PSDBFLDLABLLANG D WHERE A.PNLNAME = B.PNLNAME AND A.PNLFIELDNAME = B.PNLFIELDNAME AND B.PNLFIELDNAME = C.FIELDNAME AND B.SEARCH_FLG = 'Y' AND A.PNLFIELDNAME = D.FIELDNAME AND A.LABEL_ID = D.LABEL_ID

  • Related Language Record for EX_SRCH_FLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 APPR_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Approval Transaction Type.
    CA=Cash Advance
    ER=Expense Report
    TA=Travel Authorization
    TJ=Time Adjustment
    TR=Time Report
    2 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    5 XLATVALUES Character(1) VARCHAR2(1) NOT NULL Translate Table Descriptions