TL_TMPLTRULE_LV

(SQL View)
 Index Back

Lang View of TL_TMPLT_RULE

View keyed by TEMPLATE_ID. Introduced on the TL_TMPLT_DEFN component to retrieve and list rules linked to a given template

SELECT BASE.TEMPLATE_ID , BASE.TL_RULE_ID , REL.LANGUAGE_CD , REL.DESCR FROM PS_TL_TMPLT_RULE BASE , PS_TL_TMPLT_R_LANG REL WHERE BASE.TEMPLATE_ID=REL.TEMPLATE_ID AND BASE.TL_RULE_ID=REL.TL_RULE_ID

  • Related Language Record for TL_TMPLTRULE_VW

  • Parent record: TL_TMPLTRULE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Template ID
    2 TL_RULE_ID Character(12) VARCHAR2(12) NOT NULL Rule ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description