RB_MATCHFLD_VW

(SQL View)
 Index Back

Matching Target Fields

Matching Target Fields

SELECT A.LI_TARGET_ID , A.EFFDT , A.LI_TREE_SEQ , B.FIELDNAME , A.LI_UNIQUE_ID , A.LI_TEMPLATE_ID , C.LI_TEMPLATE_TYPE , C.RA_PROFILE_ID , A.TREE_LEVEL_NUM , A.DESCRSHORT , A.DESCR FROM PS_RB_TARGT_STRUCT A , PS_RB_TEMPL_INTFC B , PS_RB_TEMPLATE 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: RB_MATCHFLD_LVW

    • # 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 LI_TREE_SEQ Number(3,0) SMALLINT NOT NULL in what position is this tree element?
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 LI_UNIQUE_ID Character(31) VARCHAR2(31) NOT NULL Unique_Id
    6 LI_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL template identifier
    7 LI_TEMPLATE_TYPE Character(2) VARCHAR2(2) NOT NULL what type of import template is this?
    01=Manual Template
    02=Profile Template
    03=Implicit Template
    04=Optional Template
    8 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
    9 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description