RAD_TMPL_SRCHL

(SQL View)
 Index Back

Search Record for Templates

Display Template for Advisor Search

SELECT A.RAD_TEMPLATE_ID , B.LANGUAGE_CD , B.RAD_TMPL_NAME , A.RAD_STATUS FROM PS_RAD_TEMPLATE A , PS_RAD_TEMPLATE_LN B WHERE A.RAD_TEMPLATE_ID = B.RAD_TEMPLATE_ID

  • Related Language Record for RAD_TMPL_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RAD_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL Advisor Display Template Identifier - represent templates
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RAD_TMPL_NAME Character(30) VARCHAR2(30) NOT NULL Advisor Display Template Name or short description
    4 RAD_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Active
    I=Inactive