RB_TARG_FLD_LVW

(SQL View)
 Index Back

Targets for Import template

Import Targets for pre-defined Import template

SELECT A.LI_TARGET_ID , C.LANGUAGE_CD , A.EFFDT , MIN(A.LI_TREE_SEQ) , B.FIELDNAME , A.DESCRSHORT , A.DESCR FROM PS_RB_TARGT_ST_LNG A , PS_RB_TARGT_STRUCT A1 , PS_RB_TEMPL_INTFC B , PS_RB_TEMPLATE_LNG C WHERE A.LI_TARGET_ID = A1.LI_TARGET_ID AND A.EFFDT = A1.EFFDT AND A.LI_TREE_SEQ= A1.LI_TREE_SEQ AND A1.LI_TEMPLATE_ID = B.LI_TEMPLATE_ID AND B.LI_TEMPLATE_ID = C.LI_TEMPLATE_ID AND A.LANGUAGE_CD = C.LANGUAGE_CD AND B.LI_TEMPLATE_RULE IN ('04','05') 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) GROUP BY A.LI_TARGET_ID , C.LANGUAGE_CD, A.EFFDT ,B.FIELDNAME, A.DESCRSHORT , A.DESCR

  • Related Language Record for RB_TARGT_FLD_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    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