TL_TMPLTRULE_VW

(SQL View)
 Index Back

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 TEMPLATE_ID , TL_RULE_ID , DESCR FROM PS_TL_TMPLT_RULE

  • Related Language Record: TL_TMPLTRULE_LV

  • Parent record: TL_TMPLT_RULE

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description