RB_TARGT_FLD_VW

(SQL View)
Index Back

Targets for Import template

Targets for Import template

SELECT A.LI_TARGET_ID , A.EFFDT , A.LI_TREE_SEQ , B.FIELDNAME , A.LI_UNIQUE_ID , A.LI_TEMPLATE_ID , A.TREE_LEVEL_NUM , A.DESCRSHORT , A.DESCR , B.LI_TEMPLATE_RULE , C.RA_PROFILE_ID , C.LI_TEMPLATE_TYPE 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 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_TARG_FLD_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 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 LI_TEMPLATE_RULE Character(2) VARCHAR2(2) NOT NULL action to take for a field in a given template
    01=Generate Standard Key
    02=Generate Sequence Key
    03=Reference Key
    04=Required Input
    05=Optional Input
    06=Value
    07=Value Reference
    08=Lookup Value
    09=Concatenation
    10=Insert Null
    11=Generate Id - Not Key
    12=Generate Datetime Stamp
    13=Fetch Text
    14=Staged Default
    15=Mandatory Value
    16=First of Group
    17=Write Contact Method
    18=Cache Contact Method
    19=Map Field Reference
    20=Bas SysId
    11 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
    12 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