RB_MATCHFLD_LVW

(SQL View)
 Index Back

Matching Target Flds RelLangVw

Matching Target Fields Related Language view

SELECT A.LI_TARGET_ID , A.EFFDT , C.LANGUAGE_CD , A.LI_TREE_SEQ , B.FIELDNAME , A.DESCRSHORT , A.DESCR FROM PS_RB_TARGT_STRUCT A , PS_RB_TEMPL_INTFC B , PS_RB_TEMPLATE_LNG C WHERE A.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND B.LI_TEMPLATE_ID = C.LI_TEMPLATE_ID AND B.LI_TEMPLATE_RULE IN ('04','05') AND B.LI_MATCH_TGT_REC <> ' ' AND C.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_RB_TEMPLATE Z WHERE Z.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND Z.EFFDT <= B.EFFDT) AND B.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_RB_TEMPL_INTFC Z WHERE Z.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND Z.FIELDNAME = B.FIELDNAME AND Z.EFFDT <= A.EFFDT) AND A.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_RB_TARGT_STRUCT Z WHERE Z.LI_TARGET_ID = A.LI_TARGET_ID AND Z.LI_TREE_SEQ = A.LI_TREE_SEQ AND Z.EFFDT <= %CurrentDateIn)

  • Related Language Record for RB_MATCHFLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LI_TARGET_ID Character(31) VARCHAR2(31) NOT NULL field target identifier
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LI_TREE_SEQ Number(3,0) SMALLINT NOT NULL in what position is this tree element?
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description